Parks Signs

One row of data represents a physical Sign (its location and attributes) that was surveyed or installed by NYC Parks. Data is collected and udpated on an ongoing basis per updates to signage policies, seasonal upgrades, and one-off requests. Some limitations to the data: missing photos of installed signs, occasional shifting of Points (geometry) surveyed by GIS and that NOT ALL SIGNS THAT HAVE BEEN INSTALLED ARE CURRENTLY CAPTURED IN THIS DATASET.

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/parks-signs-hv9n-xgy4\".\"parks_signs\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.