Colorado s Surface Water Monitor System Colorado Division of

Colorado’s Surface Water Monitor System Colorado Division of Water Resources

History n 1881 - State Hydraulic Engineer n Water Rights Administration n Stream Flow and Diversion Measurements n Reservoir Capacity, Cost and Location n First gaging station installation n 1884 First chart recorder installation n 1969 - Division of Water Resources n Public Safety n Ground Water Permitting n Interstate Compacts n Hydrographic and Satellite Monitoring

Hydrographic and Satellite Monitoring Branch n n n n 28 project staff Gaging station operations and maintenance Stream flow measurement Electronic equipment maintenance Records publication Software development and web administration Manage surface water monitoring system n n n Satellite-linked starting in 1985 VAX and DB 2 database Retrieve data from external sources

Hydrographic and Satellite Monitoring Branch n n n n Water administration/distribution Compact administration Water storage and release Flood warning/monitoring Dam safety Recreation/safety Environmental monitoring Minimum stream flow n n n 6 Certified final stream flow records Hydrologic modeling Water rights analyses, exchanges, transfers Litigation Wildlife and fisheries Water quality

Data Collection Overview

Surface Water Monitoring System Data Collection n DWR Data Collection n 456 DWR gaging stations on satellite telemetry n 62 cooperator gaging stations n Federal agencies (USBR, USACE, NWS) n Local entities (Colorado Springs, Aurora, etc. ) n Stream flows and diversions n Reservoir levels n Environmental data (precipitation, air and water temperature) n Water quality parameters (cooperators) n Data from external providers n 375+ external stations n U. S. Geological Survey n Water conservancy districts (NCWCD, LSPWCD, SVLHWCD)

Surface Water Monitoring System Data Collection n Satellite Telemetry n 509 NESDIS IDs (411 active) n 86% are High Data Rate (HDR) n Decode 53 cooperator IDs n 10, 700+ transmissions /day n 105, 500+ data values/day n 32, 000+ diagnostics values/day (signal strength, battery voltage, error codes) n Data provider stations n Via web services n Data automation services n 45, 200+ data values / day

Rio Grande Above the Mouth of Trinchera Creek La Plata and Cherry Creek Ditch Cheeseman Reservoir

Data Processing Overview

Decode and Processing Server n Data Retrieval & Decoding n n Data Processing Services n n n Ilex Local Readout Ground Station Ilex DCS Real-time Process (self-timed and random data) Ilex DCS Diagnostics Process (raw transmission string) Data Loader Service Data Processor Service Diagnostics Service USGS Data Service NCWCD Data Service System Monitor n Monitor Service

Database Server n Microsoft SQL Server 2000 n n n Data storage Update Decodes database System configurations System status Data Processing (Data Transformation Services) n FTP export DTS

System Administration n Hydrologic Management System (web. HMS) n n n n Web accessible application Configure station setup Manage gaging station lists Manage satellite transmission configurations Update Decodes database View system and station diagnostics Reporting

web. HMS – Station configuration n n Manage station setup Change platform Configure station sensor data Reporting

web. HMS – Diagnostics n n n System status View diagnostics Data transmission strings

Colorado’s Surface Water Conditions Web Site n n Provide near real-time telemetry data to personnel and the public Detailed graphs Tabular data Approximately 3 million page views per year

Colorado’s Surface Water Conditions n n n Customized user station lists Statistics Analysis / Comparison Tools

Telephony Solutions n Alert Notification System n Dials out to subscribers n User subscribed station list n Informs subscriber of “red flag” conditions (minimum, maximum or rate of change) n Water. Talk n Inbound stream flow condition requests n Approximately 90, 000 inbound call per year Active Call Center

Automated Data Services n Web Service n Colorado. Water. SMS n Expose provisional data to Cooperators, Application Developers, and other data harvesters n. NET platform, can be consumed by any SOAP client n Web Site n URL - http: //www. dwr. state. co. us/Surface. Water/data/export_tabular. aspx n FTP Site n Data exported from SQL Server using scheduled Data Transformation Services (DTS) packages n Being phased out in favor of web services

The End… Questions?

Presented By: Phil De. Arcos Co. Division of Water Resources (303) 866 -3581 ext. 8259 phil. dearcos@state. co. us www. dwr. state. co. us