Public Water Service Lines

A water service pipe, also known as a water service line, is the way drinking water is delivered to each home in Calgary. The water service pipe can be thought of as two sections:

(1) From the water main to the property line: This part of the pipe is owned and maintained by The City of Calgary.

(2) From the property line to your house: This part of the pipe is owned and maintained by the homeowner.

The data shown here only relates to the portion of the water service pipe on public property, owned and operated by The City. The material on private property can be a different material, and could have been installed at a different time. The data shown on this map is subject to change due to parcel re-development or The City repair/maintenance activities. If you believe there is an error or an omission regarding to the pipe material provided on this map, please contact 311.

For more information, please visit: <a href="https://www.calgary.ca/UEP/Water/Pages/Water-and-wastewater-systems/Water-Service-Lines-Calgary.aspx">Water Service Lines in Calgary</a>

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/public-water-service-lines-ta76-7bfx\".\"public_water_service_lines\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.