Make a GeoJSON file of Census tracts with certain attributes

[stevevance]

It should have these attributes:

Primary

• Median income
• % Black
• % White
• % Hispanic
• Hypertension
• Miles of bike lane:

SELECT sum(ST_Length(bikelanes.geom)) 
FROM bikelanes LEFT JOIN censustracts 
ON ST_Intersects(bikelanes.geom, censustracts.geom) GROUP BY tractid

Secondary

• Vehicles available
• Mode share: Bike
• Mode share: Transit
• Mode share: SOV
• Mode share: Carpool

[stevevance]

@easherma Thanks for creating this file!

Can you make some changes to it?

• Export as EPSG:4326
• Remove SHAPE_AREA and SHAPE_LEN fields
• Amend how Census tracts are identified
• Change bikelanelength_BikeLENGTH to something shorter

Census tract identification:
I think it would be sufficient to identify the Census tract by truncating the GEOID field to just the digits on the right side of "US" and then drop the NAME field.

What is the DATA_VALUE field?