City of Flint Distribution System Monitoring Data (Expanded)

The City of Flint purchases treated water from the Great Lakes Water Authority (GLWA) and the Genesee County Drain Commissioner (GCDC) and provides further treatment to optimize corrosion control.

• Data collected from the City's distribution system helps us know whether the treatment process is working correctly

• Some data in the table is informational only

• Some data shows whether target ranges for pH, orthophosphate, chlorine, and iron are being met.

Other testing that EGLE is doing for the City of Flint is Lead and Copper Sequential Sampling.

This expanded dataset helps the City of Flint make decisions about the best way to treat the water. If more than one sample is collected per day at a particular location, the average or range of all daily samples may be shown.

Visit Michigan.gov/FlintWater for more information.

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 \"michigan-gov/city-of-flint-distribution-system-monitoring-data-8j9y-e7ze\".\"city_of_flint_distribution_system_monitoring_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.