Laserfiche WebLink
<br />'~'I ~ .., <br /> <br />000(153 <br /> <br />South Platte Water Rights Management System <br /> <br />Modifying the Arc/Info <br />coverages <br /> <br />Modifying the Informix <br />Tables <br /> <br />Adding a new gauge <br /> <br />To add a new gauge lo the system, modify the Arc/Info coverage and the Informix lables. <br /> <br />1. Determine the highest current gageno in SPWRMS database. The new gauge must <br />have a higher ID to assure it is unique. Use Informix utilities to execute the following <br />SQL statement: <br />SELECT gageno FROM gagingstations <br />ORDER BY gageno DESC; <br />will produce a list of gageno's in descending order. <br /> <br />2. Digitize the new point into the coverage containing gauges. <br />Arcedit: ec phS_strearn_g <br />Arcedit: ef arc <br />Arcedit: Add <br /> <br />3. Attribute the new point. Assign a water district and a unique ID. <br />Arcedit: calc gageno = <highest current gageno + 1> <br />Arcedit: calc wd# = <appropriate water district number> <br /> <br />4. Connect the new point to the Network coverage (see "Modifying the Stream Net- <br />work" below). <br /> <br />1. Create a new record in the gagingstations table for each new gauge added. <br /> <br />INSERT INTO gagingstations <br /> <br />VALUES {gageno, abbrev,wd, altid,hasdata, trans- <br />rntn,fullname, valuetype) <br /> <br />where the items in parentheses are: <br /> <br />gageno the unique ID given to the newly-added gauge <br /> <br />abbrev SEa's 8-character abbreviation for gauge <br /> <br />wd the Water District ID of the gauge location <br /> <br />altid the corresponding ID in rights table. if there is one <br /> <br />hasdata binary field indicating whether data is collected by <br />this gauge (O=no, l=yes) <br /> <br />transmtn binary field indicating whether the gauge measures <br />flow on a transmountain diversion (O=no, I=yes) <br /> <br />full name full name of the gauge <br /> <br />valuetype type of value represented by gauge, one of "STaR," <br />"FLOW," or "ELEV" <br /> <br />2. Map the station and its datatype onto the new record in gagingstations table added in <br />(I): <br /> <br />INSERT INTOstation_code_lu <br /> <br />VALUES (station, datatype_code, station_code) <br /> <br />where the items in parenthesis are: <br /> <br />station SEO's 8-character code for gauge data received from <br />rhe VAX <br /> <br />datatype_code <br /> <br />up lo 7-character code from VAX indicating data type <br />from gauge (e.g.. DISCHRG, Q_l. ELEV, etc.) <br /> <br />Database Manual <br /> <br />21 <br />