michigan-gov/sequential-sampling-city-of-flint-xbup-d3a8
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated almost 2 years ago
Indexed 1 month ago

Sequential Sampling - City of Flint

A building's plumbing system and water service line (pipes) can be made up of different types of materials. Each type of material can affect drinking water differently, so it is useful to conduct what is known as "sequential sampling". Sequential sampling is where all water usage in a building is stopped for several hours, known as "stagnation". Next, water is collected from the faucet in a series of bottles. This is done without wasting any water or running the water before filling the bottles. The first few bottles represent water that was in contact with the faucet or building plumbing during stagnation. The later bottles represent water that was in contact with the water service line. These sample results can help decide whether treatment is working.

Learn more at Michigan.gov/FlintWater

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/sequential-sampling-city-of-flint-xbup-d3a8\".\"sequential_sampling_city_of_flint\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • sequential_sampling_city_of_flint