Laserfiche WebLink
DSS Component Assessment <br />4.1.6 DSS Integration -Relational Database Management System <br />Data within the database consist of spatial and non-spatial data. Spatial data will be discussed in <br />Section 4.1.7. Non-spatial data should be collected and stored in tables in a relational database. <br />Relationships between tables should be stored to provide the basis for organizing, sorting, and <br />querying data within the database. There is not always a clear distinction between data stored in the <br />spatial database and data stored in the relational database. <br />Non-spatial data consists primarily of time series data (streamflow), parametric data (data used in <br />modeling), and physical characteristic data (data used to describe the river and reservoir system, or <br />data such as crop information or water rights). <br />4.1.6.1 Implementation <br />The HydroBase database used by the State is a centralized database system that will eventually <br />contain water resources data for the entire state. It is currently complete for the five CRDSS basins. <br />4.1.6.2 System Requirements <br />HydroBase was designed and is being constructed to allow a centralized database to act as a server for <br />the field division offices (including Alamosa) that are connected to the data network. Water <br />commissioners and others can download portions of the central database and use data within a <br />Microsoft Access database locally on their own computers. Additionally, web browser functionality <br />has been developed as part of CRDSS to allow users access to the database over the World Wide Web <br />using any computer that can run a web browser such as Netscape or Internet Explorer. <br />4.1.6.3 Specific RGDSS Issues <br />The current HydroBase database contains limited well or ground water information. The current <br />HydroBase design includes a table structure to support the State's well permit program. This ground <br />water feature would need to be designed and tested to verify that these tables contain the correct fields <br />and relationships for tracking well information to be used in the RGDSS. The current design of <br />HydroBase would need to be enhanced to store data associated with the ground water issues that have <br />been identified and to support analysis tools or modeling tools associated with these issues. A list of <br />possible data types that could be included in the HydroBase design follows: <br />• Adjudicated wells with locations and decreed withdrawal rates and volumes <br />• Permitted wells with locations and decreed withdrawal rates and volumes <br />• Well completion logs <br />• Well pump test results <br />• Time series of static water levels <br />• Time series of well pumping or flow records <br />• Time series of well water quality data <br />These data types could be added to the existing design with few or no changes in the way the <br />database is currently keyed. Utilities would need to be developed to enter, retrieve, and view these <br />data. <br />4.1.7 DSS Integration -Spatial Database Management System <br />The CRDSS spatial database contains GIS capabilities and data in the ARC/INFO format. ARC/INFO <br />is used to develop spatial data sets, also referred to as coverages. ARC/INFO coverages have also <br />been converted to other data formats using ARC/INFO and associated utility programs for use in <br />system map displays. ARC/VIEW is the current tool used to view spatial coverages in the PC <br />environment. This generic system can be applied to data for the Rio Grande basin and should be used. <br />a454/report/final/comp. doc 07/2&~OS Y-6 <br />