NYC Parks Drinking Fountains

Each record is either an individual drinking fountain or multiple drinking fountains that are attached to each other. NYC Parks created the dataset using collector for arcgis. All outdoor drinking fountains in parks were collected and a rigorous QA/QC process followed. In addition to the GPS coordinates the dataset includes descriptions of its physical environment and attributes about the drinking fountain itself.

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

Data Dictionary: https://drive.google.com/open?id=1s7VSUHDJsGcHNghzllmdFgdwEMX2Zps_ygqSMMzfVgo

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/nyc-parks-drinking-fountains-qnv7-p7a2\".\"nyc_parks_drinking_fountains\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.