Fort Collins Floodwarning Rain Gage Data

Automated readings from the rain gages throughout the city. These rain gages use 'tipping buckets' to measure rainfall; whenever the 'bucket' tips, the incremental rainfall data are recorded. Because of this measurement system, this dataset is only updated when there are new 'bucket tips'; the system searches for new data several times an hour, but only updates this dataset if there are new records. The data rate is limited, so for heavy rainfall there will be multiple 'bucket tips' in one record.

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-rain-gage-data-g87z-rviz\".\"fort_collins_floodwarning_rain_gage_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.