Laserfiche WebLink
<br /> Appendix - ColoradoWaterSMS Data Store - 1 <br /> <br />Appendix: Colorado Water Satellite Monitoring <br />System (ColoradoWater SMS) Data Store <br />20 1 2 -0 5 -16 <br />Overview <br /> <br />The State of Colorado’s Satellite Monitoring System (SMS) database stores observations, configuration <br />information, processed data, and alarms, related to field observations collected from real -time stations <br />throughout the State of Colorado. This database has links to HydroBase and HydroBase also includes <br />real -time data (see the HydroBase Input Type Appendix ). However, the HydroBase real -time time <br />seri es are only available to State of Colorado personnel that ha ve access to the State’s internal server s . <br />T he ColoradoWaterSMS data store provides internet web service access to real -time data as described <br />here: <br /> <br />http://www.dwr.state.co.us/SurfaceWater/help.aspx <br /> <br />Raw observations as well as hourly and daily aggregations can be requested. Because the data are <br />considered provisional, time series data collected from external providers are NOT available and must be <br />retrieved from the original provider (e.g., USG S). Time series with DataSource=DWR and several <br />other data cooperators that rely on the State for data access are available from this web service. <br /> <br />ColoradoWaterSMS Web Services and Standard Time Series Properties <br /> <br />The standard time series identifier form at for ColoradoWaterSMS time series is of the form: <br /> <br /> Location.DataSource.DataType.Interval~DataStoreName <br /> <br />The meaning of the parts is as follows: <br /> <br />• The Location is set to the State of Colorado’s station abbreviation , ABBREV (e.g., PLAKERCO ), <br />which typicall y is formed from the river/basin name (PLA =Platte River), station location <br />(KER =Kersey), and state (CO =Colorado). Note that currently the web service does not provide the <br />original identifier and therefore the abbreviation is always used. <br />• The DataSource is set to the providing agency. For example, although data are stored in the <br />State’s database, the data provider may be USGS or another agency. If different from DWR , then the <br />data also may be available directly from th e provider agenc y using the agency’s station identifier. <br />T he State’s web services only provide DWR –managed data and do not pass through provisional data <br />from other agencies that are able to provide the data from their systems . <br />• The DataType is set to the “variable” described in the State’s we b service documentation. <br />Streamflow is the primary data type, indicated by DISCHRG . Reservoir/lake level is indicated by <br />ELEV , and storage by STORAGE . It is possible that a single gage collects data at more than one <br />location, for example at bran ches of a confluence. Use TSTool to query the data store with a data <br />type of “*” to list available data types at a location. <br />• Interval is Irregular for raw data, which generally is evenly spaced but may include more <br />frequent obse rvations during events. Hour and Day interval are also available as aggregated values. <br />• The data store name (ColoradoWaterSMS by default) indicates that the data are being read from <br />the ColoradoWaterSMS web service. <br />19