SPDSS_WatRightScope_20021117

• Title: SPDSS Phase 1 & 2 - Relational System Integration and Water Rights Administration Component
• Description: The Scope of Work for the Relational System Integration and Water Rights Administration components of the South Platte Decision Support System.
• Decision Support - Doc Type: Scope of Work
• Date: 11/17/2002
• DSS Category: Surface Water
• DSS: South Platte
• Basin: South Platte
• Contract/PO #: C153966
• Bill Number: SB01-157, HB02-1152, SB03-110, HB04-1221, SB05-084, HB06-1313, SB07-122
• Prepared By: CWCB

Deliverable:
105.1 An updated CWRAT, with documentation, that allows provisional WIS data to be
exported in a distributable format.
Task 106 -Update to Use New Stream Network Data
Objective:
To review the water source and stream connectivity data stored in HydroBase and update the
water information sheets to use the updated data. The NHD (National Hydrography Dataset)
layer from the SPDSS Spatial Integration contractor will be evaluated and integrated with
HydroBase data.
Background:
Each structure and water right in HydroBase references a "Water Source", which is a stream,
lake, well, spring, etc., that supplies water for the structure. The water sources have numeric
identifiers and character names, the latter of which are commonly used in data displays in
CWRAT/StateView (e.g., the water source is listed with structures, water rights, calls, etc.).
Whereas this general information is of relatively good quality, no distinction is made to indicate
the type of physical water feature (river, well, etc) and the connectivity information ("trib to") to
allow upstream to downstream navigation of a stream system is of poor quality. Poor quality
data limits the effectiveness of administrative tools like CWRAT For example, the water
information sheet builder relies on the water source data to help locate structures for a stream and
to help enforce upstream to downstream relationships.
The water source information in HydroBase is relational (not spatial) data and there is currently
no corresponding spatial data for the water sources. Task 96 of the SPDSS Spatial System
Integration contract will provide an NHD layer with stream network linework, connectivity, and
attributes. This layer will be evaluated and used in some form, resulting in a stream network
layer that can be linked to from HydroBase, for use in CDSS applications.
Reviewing and correcting the water source data will address a basic limitation of HydroBase
data. Relating the data to spatial data will allow CDSS applications to utilize water source data
from amap-based interface.
Approach:
106.1 Database Design and Coordination. Meet and/or communicate with DWR and CWCB
Information Technology staff, the SPDSS management team and SPDSS project team to
review the HydroBase water source data and NHD organization determine necessary design
changes to support a data cleanup effort. It is anticipated that the design will store
information as necessary to link to spatial data layers from the stream network layer (Task
96, SPDSS Spatial Integration Component). For example, include in HydroBase a data field
for the "reach code" attribute in the NHD data. The State's HydroBase DBA will make
HydroBase design changes and initial data changes will be implemented to utilize the new