chicago_bike_equity icon indicating copy to clipboard operation
chicago_bike_equity copied to clipboard

Published 20 hours ago • verified publisher icon zorostang

Make a GeoJSON file of Census tracts with certain attributes

Open stevevance opened this issue 9 years ago • 1 comments

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 avatar Apr 01 '15 01:04 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?

stevevance avatar Apr 20 '15 16:04 stevevance