Positive Total Coliform Samples Data.

Samples are collected daily at locations throughout the distribution system by city personnel. Samples are taken to a lab to be analyzed for Total Coliform and E. Coli indicators. All positive samples since 2011 are provided 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 \"dashboard-plano-gov/positive-total-coliform-samples-data-72kc-s2ax\".\"positive_total_coliform_samples_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.