Fort Collins Floodwarning Stream Gage Stage & Flow Data

Automated readings from the city-wide flood warning system, which is made up in part of stream-flow gages throughout the city. While these data specify flow rates at each gage, extreme care should be taken if using these measurements as flow data; the sensors are not placed ideally for accurate flow measurements and they are not monitored closely enough for this purpose. This is the raw sensor data and analysis would be needed to use for anything but flood monitoring.

The real-time map of these values is located at https://gisweb.fcgov.com/HTML5Viewer/Index.html?viewer=Flood%20Warning

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 \"opendata-fcgov/fort-collins-floodwarning-stream-gage-stage-flow-f5as-vvbj\".\"fort_collins_floodwarning_stream_gage_stage_flow\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.