DWR Surface Water Supply Index Component by HUC

The Surface Water Supply Index (SWSI) is used as an indicator of surface water supply conditions in Colorado. The SWSI compares the total volume of water in a basin or sub-basin against the volume available in the same month of historical years. Depending on the month, the volume is a combination of components: streamflow, streamflow forecast, or reservoir storage. The SWSI is calculated for Colorado’s river basins and sub-basins; this data set provides information on the Colorado’s sub-basin-level SWSI calculation. More information is available at http://water.state.co.us/DWRDocs/Reports/Pages/SWSIReport.aspx.

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 \"colorado-gov/dwr-surface-water-supply-index-component-by-huc-xbs6-xrne\".\"dwr_surface_water_supply_index_component_by_huc\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.