WaterFeatures_20190417

This dataset captures all water features within NYC Parks. It combines the State’s hydrography layer with known water fountains. Made for cartographic purposes, the attribute data isn’t as maintained as the geometry.

User guide: https://drive.google.com/open?id=1A7KhVk3LW_IKPHYfYUNAHSPgsVAJb1Chk3ZICtVwDsI

Data Dictionary: https://drive.google.com/open?id=124PsGwqsgf1cW2eWnEEjdO3cojoRtloAh3r37eTAXAM

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/waterfeatures20190417-8kvz-b7tv\".\"waterfeatures20190417\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.