This is something that I've been meaning to do for a very long time. Hope it serves well.
A single relationship file that links up all the local geographies in New York City.
Link to Carto Map with same data
Using CARTO's SQL API to expose this data programmatically This allows you to query any point and retrieve all the local geographies that the point lies in.
What is this?
A single csv file that walks across all of New York City's local geographies. This file links up the following geographies in a single tabulated file:
- Borough Boundaries
- Census Blocks 2010
- Census Tracts 2010
- City Council Districts
- Community Districts
- Election Districts
- Fire Battalions
- Fire Companies
- Fire Divisions
- Health Area
- Health Center
- Municipal Court Districts
- Neighborhood Tabulation Areas
- Police Precincts
- PUMA
- School Districts
- State Assembly Districts
- State Senate Districts
- U.S. Congressional Districts
Why do we need this?
This dataset could help answer questions like this more easily while also reducing the overall friction to integrate data from disparate domains.Example:
In New York City:
How many and which Census Tracts are located in School District 31?
AND
Which Fire District is serviced by this School District?
AND
Which City Council District is this School District in?
AND
Which Congressional District is it in?
AND
How many Health Centers are in this area?
How was this done?
I combined all the shapefiles from NYC.gov's Political and Administrative Districts - Download and Metadata (only used the Clipped to Shoreline shapefiles) using QGIS's "Join attributes by location" and then performing an Interesection operation on each shapefile.
The result was an attribute table that works as a relationship file to connect all the intersecting geographies. Shape Area and Lengths were removed from the resulting attribute table.
Here is a similar relationship file visualized for US Census Data:
