Dataset: SWSI Indicator

Property	Description
title	SWSI Indicator
identifier	owf-model-swsi
description	Surface Water Supply Index (SWSI) Indicator updated for analysis month 2023-05
issued	2023-07-03
modified	2023-07-03
version
keyword	water supply,colorado river,surface water supply index,swsi

Dataset Publisher

Property	Description
name	Open Water Foundation
mbox	info@openwaterfoundation.org

Dataset Details

Overview

This dataset contains files associated with the Surface Water Supply Index (SWSI) analysis, which estimates water supply conditions for river basins. The files are generated using the SWSI Model using TSTool software.

This dataset is for SWSI analysis 2023-05.

Downloads

The following files can be downloaded or used directly by specifying the URL to software.

Files are grouped into product categories.
Within each category, files are organized by Hydrologic Unit Code (HUC8) identifier, or major basin name.

SWSI Products (Summary)

The summary contains SWSI values for each major river basin and HUC8 basins:

all products are for HUC8 basins except for the Major River Basins product

Product	File Link
Current Summary (`xlsx`)	`SWSI-Current-Summary.xlsx`
Current Summary (`csv`)	`SWSI-Current-Summary-Basin.csv`
Current Summary, Upper Colorado (`geojson`)	`SWSI-Current-Summary-UpperColorado-HUC.geojson`
History Heatmap, Upper Colorado (`png`)	`SWSI-HeatMap-UpperColorado-History.png`
Recent Heatmap, Upper Colorado (`png`)	`SWSI-HeatMap-UpperColorado-Recent.png`
Current Summary, Major River Basins (`csv`)	`SWSI-Current-Summary.csv`

SWSI Products - Major River Basins (Details)

SWSI products are available in different formats for each major river basin:

images can be displayed from a link, for example link to the image from a river basin map
the SWSI workbook is formatted to facilitate review
the time series files organize data in linear fashion over the data period
use the BasinName-DataComposite-SWSI column to display the overall SWSI value (where BasinName must be replaced with the specific basin name)

Basin	SWSI Graph, History (`png`)	SWSI Workbook (`xlsx`)	Time Series (`xlsx`)	Time Series (`csv`)	Time Series (DateValue, `dv`)
Arkansas	`Basin-Arkansas-SWSI-history-graph.png`	`Arkansas-SWSI.xlsx`	`Arkansas-TimeSeries.xlsx`	`Arkansas-TimeSeries.csv`	`Arkansas-TimeSeries.dv`
Colorado	`Basin-Colorado-SWSI-history-graph.png`	`Colorado-SWSI.xlsx`	`Colorado-TimeSeries.xlsx`	`Colorado-TimeSeries.csv`	`Colorado-TimeSeries.dv`
Gunnison	`Basin-Gunnison-SWSI-history-graph.png`	`Gunnison-SWSI.xlsx`	`Gunnison-TimeSeries.xlsx`	`Gunnison-TimeSeries.csv`	`Gunnison-TimeSeries.dv`
Rio Grande	`Basin-Rio Grande-SWSI-history-graph.png`	`Rio Grande-SWSI.xlsx`	`Rio Grande-TimeSeries.xlsx`	`Rio Grande-TimeSeries.csv`	`Rio Grande-TimeSeries.dv`
San Juan-Dolores	`Basin-San Juan-Dolores-SWSI-history-graph.png`	`San Juan-Dolores-SWSI.xlsx`	`San Juan-Dolores-TimeSeries.xlsx`	`San Juan-Dolores-TimeSeries.csv`	`San Juan-Dolores-TimeSeries.dv`
South Platte	`Basin-South Platte-SWSI-history-graph.png`	`South Platte-SWSI.xlsx`	`South Platte-TimeSeries.xlsx`	`South Platte-TimeSeries.csv`	`South Platte-TimeSeries.dv`
Yampa-White	`Basin-Yampa-White-SWSI-history-graph.png`	`Yampa-White-SWSI.xlsx`	`Yampa-White-TimeSeries.xlsx`	`Yampa-White-TimeSeries.csv`	`Yampa-White-TimeSeries.dv`

SWSI Products - HUC8 Basins

SWSI products are available in different formats for each HUC8 basin:

images can be displayed from a link, for example link to the image from a HUC8 basin map
the SWSI workbook is formatted to facilitate review
the time series files organize data in linear fashion over the data period
use the HUC8-DataComposite-SWSI data type to display the overall SWSI value (where HUC8 must be replaced with the specific basin name)

HUC	HUC Name	SWSI Graph, History (`png`)	SWSI Graph, Recent (`png`)	SWSI Workbook (`xlsx`)	Time Series (`xlsx`)	Time Series (`csv`)	Time Series (DateValue, `dv`)
14010001	Colorado Headwaters. Colorado.	`HUC-14010001-SWSI-history-graph.png`	`HUC-14010001-SWSI-recent-graph.png`	`14010001-SWSI.xlsx`	`14010001-TimeSeries.xlsx`	`14010001-TimeSeries.csv`	`14010001-TimeSeries.dv`
14010002	Blue. Colorado.	`HUC-14010002-SWSI-history-graph.png`	`HUC-14010002-SWSI-recent-graph.png`	`14010002-SWSI.xlsx`	`14010002-TimeSeries.xlsx`	`14010002-TimeSeries.csv`	`14010002-TimeSeries.dv`
14010003	Eagle. Colorado.	`HUC-14010003-SWSI-history-graph.png`	`HUC-14010003-SWSI-recent-graph.png`	`14010003-SWSI.xlsx`	`14010003-TimeSeries.xlsx`	`14010003-TimeSeries.csv`	`14010003-TimeSeries.dv`
14010004	Roaring Fork. Colorado.	`HUC-14010004-SWSI-history-graph.png`	`HUC-14010004-SWSI-recent-graph.png`	`14010004-SWSI.xlsx`	`14010004-TimeSeries.xlsx`	`14010004-TimeSeries.csv`	`14010004-TimeSeries.dv`
14010005	Colorado Headwaters-Plateau. Colorado.	`HUC-14010005-SWSI-history-graph.png`	`HUC-14010005-SWSI-recent-graph.png`	`14010005-SWSI.xlsx`	`14010005-TimeSeries.xlsx`	`14010005-TimeSeries.csv`	`14010005-TimeSeries.dv`
14020001	East-Taylor. Colorado.	`HUC-14020001-SWSI-history-graph.png`	`HUC-14020001-SWSI-recent-graph.png`	`14020001-SWSI.xlsx`	`14020001-TimeSeries.xlsx`	`14020001-TimeSeries.csv`	`14020001-TimeSeries.dv`
14020002	Upper Gunnison. Colorado.	`HUC-14020002-SWSI-history-graph.png`	`HUC-14020002-SWSI-recent-graph.png`	`14020002-SWSI.xlsx`	`14020002-TimeSeries.xlsx`	`14020002-TimeSeries.csv`	`14020002-TimeSeries.dv`
14020003	Tomichi. Colorado.	`HUC-14020003-SWSI-history-graph.png`	`HUC-14020003-SWSI-recent-graph.png`	`14020003-SWSI.xlsx`	`14020003-TimeSeries.xlsx`	`14020003-TimeSeries.csv`	`14020003-TimeSeries.dv`
14020004	North Fork Gunnison. Colorado.	`HUC-14020004-SWSI-history-graph.png`	`HUC-14020004-SWSI-recent-graph.png`	`14020004-SWSI.xlsx`	`14020004-TimeSeries.xlsx`	`14020004-TimeSeries.csv`	`14020004-TimeSeries.dv`
14020005	Lower Gunnison. Colorado.	`HUC-14020005-SWSI-history-graph.png`	`HUC-14020005-SWSI-recent-graph.png`	`14020005-SWSI.xlsx`	`14020005-TimeSeries.xlsx`	`14020005-TimeSeries.csv`	`14020005-TimeSeries.dv`
14020006	Uncompahgre. Colorado.	`HUC-14020006-SWSI-history-graph.png`	`HUC-14020006-SWSI-recent-graph.png`	`14020006-SWSI.xlsx`	`14020006-TimeSeries.xlsx`	`14020006-TimeSeries.csv`	`14020006-TimeSeries.dv`
14030002	Upper Dolores. Colorado.	`HUC-14030002-SWSI-history-graph.png`	`HUC-14030002-SWSI-recent-graph.png`	`14030002-SWSI.xlsx`	`14030002-TimeSeries.xlsx`	`14030002-TimeSeries.csv`	`14030002-TimeSeries.dv`
14030003	San Miguel. Colorado.	`HUC-14030003-SWSI-history-graph.png`	`HUC-14030003-SWSI-recent-graph.png`	`14030003-SWSI.xlsx`	`14030003-TimeSeries.xlsx`	`14030003-TimeSeries.csv`	`14030003-TimeSeries.dv`
14050001	Upper Yampa. Colorado.	`HUC-14050001-SWSI-history-graph.png`	`HUC-14050001-SWSI-recent-graph.png`	`14050001-SWSI.xlsx`	`14050001-TimeSeries.xlsx`	`14050001-TimeSeries.csv`	`14050001-TimeSeries.dv`
14050002	Lower Yampa. Colorado.	`HUC-14050002-SWSI-history-graph.png`	`HUC-14050002-SWSI-recent-graph.png`	`14050002-SWSI.xlsx`	`14050002-TimeSeries.xlsx`	`14050002-TimeSeries.csv`	`14050002-TimeSeries.dv`
14050003	Little Snake. Colorado.	`HUC-14050003-SWSI-history-graph.png`	`HUC-14050003-SWSI-recent-graph.png`	`14050003-SWSI.xlsx`	`14050003-TimeSeries.xlsx`	`14050003-TimeSeries.csv`	`14050003-TimeSeries.dv`
14050005	Upper White. Colorado.	`HUC-14050005-SWSI-history-graph.png`	`HUC-14050005-SWSI-recent-graph.png`	`14050005-SWSI.xlsx`	`14050005-TimeSeries.xlsx`	`14050005-TimeSeries.csv`	`14050005-TimeSeries.dv`
14080101	Upper San Juan. Colorado.	`HUC-14080101-SWSI-history-graph.png`	`HUC-14080101-SWSI-recent-graph.png`	`14080101-SWSI.xlsx`	`14080101-TimeSeries.xlsx`	`14080101-TimeSeries.csv`	`14080101-TimeSeries.dv`
14080102	Piedra. Colorado.	`HUC-14080102-SWSI-history-graph.png`	`HUC-14080102-SWSI-recent-graph.png`	`14080102-SWSI.xlsx`	`14080102-TimeSeries.xlsx`	`14080102-TimeSeries.csv`	`14080102-TimeSeries.dv`
14080104	Animas. Colorado.	`HUC-14080104-SWSI-history-graph.png`	`HUC-14080104-SWSI-recent-graph.png`	`14080104-SWSI.xlsx`	`14080104-TimeSeries.xlsx`	`14080104-TimeSeries.csv`	`14080104-TimeSeries.dv`
14080105	Middle San Juan. Colorado.	`HUC-14080105-SWSI-history-graph.png`	`HUC-14080105-SWSI-recent-graph.png`	`14080105-SWSI.xlsx`	`14080105-TimeSeries.xlsx`	`14080105-TimeSeries.csv`	`14080105-TimeSeries.dv`
14080107	Mancos. Colorado.	`HUC-14080107-SWSI-history-graph.png`	`HUC-14080107-SWSI-recent-graph.png`	`14080107-SWSI.xlsx`	`14080107-TimeSeries.xlsx`	`14080107-TimeSeries.csv`	`14080107-TimeSeries.dv`

SWSI Products - HUC8 Basins by Month

SWSI graph image files are available for each HUC8 basin for each month, which illustrates the historical variability for each month.

HUC	HUC Name	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SIP	OCT	NOV	DEC
14010001	Colorado Headwaters. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14010002	Blue. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14010003	Eagle. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14010004	Roaring Fork. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14010005	Colorado Headwaters-Plateau. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14020001	East-Taylor. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14020002	Upper Gunnison. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14020003	Tomichi. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14020004	North Fork Gunnison. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14020005	Lower Gunnison. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14020006	Uncompahgre. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14030002	Upper Dolores. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14030003	San Miguel. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14050001	Upper Yampa. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14050002	Lower Yampa. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14050003	Little Snake. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14050005	Upper White. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14080101	Upper San Juan. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14080102	Piedra. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14080104	Animas. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14080105	Middle San Juan. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
14080107	Mancos. Colorado.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC

Workflow

See the owf-model-swsi GitHub repository for information.

Update Frequency and Versions

The dataset is typically updated each month with the model being run in the first few days after the start of the month. A separate dataset folder is available for each month, consisting of many files for each month.

Credits

The original Excel spreadsheet-based model was created by the Natural Resources Conservation Service.
The Open Water Foundation subsequently created an automated tool based on TSTool software, which is used by the Colorado Division of Water Resource.
The latest iteration is a general tool that is being implemented for the Babbitt Center for Land and Water Policy in order to provide hydrologic water supply indicators.

License

Attribution-ShareAlike 4.0 International