Historic Land Use Data

Historic land uses on lots that were vacant, privately owned, and zoned for manufacturing in 2009.  Information came from a review of several years of historical Sanborn maps over the past 100 years. 

When the SPEED 1.0 mapping application was created in 2009, OER had its vendor examine historic land use maps on vacant, privately-owned, industrially-zoned tax lots. Up to seven years of maps for each lot were examined, and information was recorded that indicated industrial uses or potential environmental contamination such as historic fill. Data for an additional 139 lots requested by community-based organizations was added in 2014. Each record represents the information from a map from a particular year on a particular tax lot at that time. Limitations of funding determined the number of lots included and entailed that not all years were examined for each lot.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/historic-land-use-data-r9ca-6t4q\".\"historic_land_use_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.