WSPC05429

• File Number: 8283.200
• Description: Colorado River Basin-Colorado River Computer Models-Colorado River Decision Support System-Ray
• State: CO
• Water Division: 5
• Date: 1/1/1996
• Author: CADSWES
• Title: South Platte Water Rights Management System-Programmers Manual
• Water Supply Pro - Doc Type: Report/Study

.,

OllQQ68

SPWRMS database
manual

Embedded SOL

3

Water Rights Tabulation), and dynamic relational data (user-input and streamflow
data). This section describes how the various types of information are loaded and
manipulated by the system.

Informix Relational Database

Dynamic data for the South Platte Water Rights Management System is stored in a
relational database managed by software purchased from Informix Software. Inc. This
database resides on the Denver SOl workstation dbserver and receives data from three
sources: 1) state tabulations, which are loaded manually by the database administrator
and periodically updated; 2) streamflow data, which is automatically downloaded
from the Denver VAX; and 3) user-input data, which is saved to the database through
the SPWRMS interface.

The primary documentation for the SPWRMS database is the SPWRMS Database
Manual, which describes the database design, data sources, and maintenance proce-
dures. Both the relational database and the spatial data are discussed in this document.

The SPWRMS DMI uses embedded SQL to access the Informix relational database.
Embedded SQL is a precompiled database access language provided by the vendor of
the database software. Refer to the Informix user's manual for information on this
language.

Spatial Data

The spatial data for SPWRMS are in the form of digital planimetric maps covering the
extent ofthe South Platte River basin. Map elements, such as lines and points, have
associated attributes which define the identity and nature of the elements. Coordinates
which locate map elements are in meters, within the Universal Transverse Mercator
(U1M) coordinate system. The digital maps were compiled and developed by
CADSWES using AtclInfo software. a proprietary geographic information system
(GIS). These maps exist as binary files whieb are accessed by SPWRMS at run-time
to generate graphical map displays in the application interface.

Each map is a distinct layer of information which covers the entire project area. The
layering approach allows independent display of the various types of information.
Within the SPWRMS application, layers of spatial data fall into two broad groups:
those used for building the in-memory data structure upon which SPWRMS operates,
and those used for display only.

Real-Time Streamflow Data

Near real-time data arrives on the Denver VAX via satellite transmission. The data is
processed and then stored by Sutran software for users who connect with the VAX to
view the day files.

A server application on the VAX reads the Sutron data files and sends the data to
dbserver, where a client application accepts the data and inserts it into the SPWRMS
database.