My WebLink
|
Help
|
About
|
Sign Out
Home
Browse
Search
WSPC01419
CWCB
>
Water Supply Protection
>
Backfile
>
13000-13999
>
WSPC01419
Metadata
Thumbnails
Annotations
Entry Properties
Last modified
7/29/2009 7:56:45 AM
Creation date
10/9/2006 2:46:39 AM
Metadata
Fields
Template:
Water Supply Protection
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-Database Manual-South Platte Water Rights Management System
Water Supply Pro - Doc Type
Record of Decision
There are no annotations on this page.
Document management portal powered by Laserfiche WebLink 9 © 1998-2015
Laserfiche.
All rights reserved.
/
28
PDF
Print
Pages to print
Enter page numbers and/or page ranges separated by commas. For example, 1,3,5-12.
After downloading, print the document using a PDF reader (e.g. Adobe Reader).
Show annotations
View images
View plain text
<br />." ." 0 0 0 0 J 4 <br /> <br />South Platte Water Rights Management System <br /> <br />The Infonnix database was created without foreign key constraints. Instead, these relation- <br />ships are maintained by the SPWRMS application. For example. the structure rows in the <br />water information sheet must all be structures present in the phS_structures table. <br />SPWRMS maintains this relationship between tables. See Figure 1 for an entity-relation- <br />ship diagriun of the SPWRMS database. <br /> <br />Static Tables <br /> <br />Static tables contain data which change infrequently; i.e.. not during a run of the applica- <br />tion. <br /> <br />Diversion structures The structures table is a copy of the SEO DBase tables relevant to Division I. Structures <br />which are wells or springs have been removed from the table. The table contains all <br />columns supplied by SED: however. only the following columns are used by the <br />SPWRMS application: <br /> <br />-,'(\_\1$(_ ,-od~ <br /> <br />C \ U C ~ de. ~ ** indicates primary key <br /> <br />Column Description <br />wd ** Water district of structure <br />id ** ID of structure <br />name Name of structure <br /> <br />Database Table 1: ph5_structures <br /> <br />Stream gauges The streamgauges table was created ar CADSWES to hold information about satellite flow <br />structures. The following columns are used by the SPWRMS application: <br /> <br />Column Description <br />wd ** Water district of gauge <br />gageno ** Unique gauge ID <br />abbrev SPWRMS 8-character abbreviation for gauge <br />has data Indicator for whether gauge collects data <br />transmtn Indicator of transmountain flow <br />fullname Full name of structure <br />valuetype 4-character string indicating flow, storage, and elevation data. <br /> <br />** indicates primary key <br /> <br />Database Table 2: gagingstations <br /> <br />The state gauging stations and their datatypes are mapped to SPWRMS gauges abbrevi- <br />ated in the table station_code_lu. Each Static gauge may have several datatypes (e.g.. the <br />station HFCWASCO has three datatypes. DlSCHRG. Q_l. and Q_2). Each <br />stationldatatype pair is mapped to a SPWRMS station abbreviation (the "abbrev" column <br />in the gagingstations table). For example, HFLWASCOIDISCHRG is represented in <br /> <br />Database Manual <br /> <br />3 <br />
The URL can be used to link to this page
Your browser does not support the video tag.