City of Flint Distribution System Monitoring Data

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.

The four categories shown on the previous page (pH, Orthophosphate, Iron, and Chlorine) are main indicators of whether the City's corrosion control treatment is working properly. In 2017 EGLE set required ranges for pH and orthophosphate. An expanded dataset is available.

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-rv26-qdaw\".\"city_of_flint_distribution_system_monitoring_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.