Skip to content

Crosswalk of NYC city council districts and zip codes

License

Notifications You must be signed in to change notification settings

Pazoles/nyc_council_zips

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

nyc_council_zips

Crosswalk of NYC city council districts and zip codes

Loaded the council district and zip code shapefiles into a PostgreSQL instance with PostGIS, converted to WGS-84 projection.

SQL:

SELECT coun_dist, zips.zipcode FROM nycdist, zips WHERE (SELECT ST_Intersects(nycdist.geom, zips.geom))

About

Crosswalk of NYC city council districts and zip codes

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published