DWR Surface Water Supply Index 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 streamflow, streamflow forecast, and 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-by-huc-m9cg-gqek\".\"dwr_surface_water_supply_index_by_huc\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.