Private Water Hydrants

This dataset shows true location of privately owned water hydrants in City of Calgary. The hydrant location is at the end of a hydrant lead connected to water pipe. The City enters this data into the Water Utility linear network dataset, only when provided and are not responsible for owning, operating, and maintaining these hydrants.

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 \"calgary-ca/private-water-hydrants-h4dj-4jg8\".\"private_water_hydrants\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.