...
The NYC Geodatabase is a resource designed for mapping and analyzing city-level features and data in GIS. The database comes in two formats: a Spatialite geodatabase built on SQLite that can be used in open source software like QGIS and a personal geodatabase built on MS Access that can be used in ArcGIS. The contents of the databases are identical and include geographic features and statistical areas from the US Census Bureau, transit and public facility point features from the City, and census data at the PUMA, ZCTA, and census tract levels. All features share a common coordinate system: NAD 83 NY State Plane Long Island (feet). Read this document for a quick overview.
NYC Geodatabase - Latest Version (
...
August 2020)
For previous versions of the database see the NYC Geodatabase Archive.If you are using QGIS 3.x and Spatialite and some layers are not rendering, read this post.
NYC Geodatabase dataset creation scripts on GitHub
| Name | File Type | Download | |||
|---|---|---|---|---|---|
| nyc_gdb for QGIS (Spatialite version) | sqlite | nyc_gdb_jan2020aaug2020a.zip | |||
| Introduction and tutorial (Spatialite version) | intro_nycgdb_foss.pdf | ||||
| nyc_gdb for ArcGIS (MS Access version) | mdb | nyc_gdb_jan2020baug2020b.zip | |||
| Introduction and tutorial (MS Access version) | intro_nycgdb_arc.pdf | ||||
| Two-page summary of the database | nycgdb_brief.pdf | ||||
| Data dictionary | datadiction_jan2020aug2020.pdf | ||||
| Metadata | xml | nyc_gdb_jan2020aug2020.xml | |||
NYC ZCTA Population Tables (an extract of the database) | xlsx | nyc_zcta_census_data.xlsx | SQL Exercises | txt | sql_exercises.txt |
 | |||||
Sample Maps Created Using the Database:
...