Laserfiche WebLink
<br />n\ ,.1, ... <br /> <br />000053 <br /> <br />South Plane Water Rights Management System <br /> <br />~XAMPLE: LOAD FROM rights23.input INSERT INTO <br />phS_rights <br /> <br />Diversion Structures <br /> <br />Although migration of the SEO's structures tabulation from DBase is not expected. it may <br />become necessary at some point. In order to perform the migration from DBase, the <br />following steps must be performed: <br /> <br />I. Export the data for each district to a text file. Using DBase, export the data for <br />each table to a text file using FIXED- WIDTH HELD output type. This is an option <br />available through the DBase menu system. <br />2. Transfer the text files to the UNIX database server. Use a file transfer utility such <br />as ftp to move the files to the host machine of the SPWRMS database (currently <br />ObServer at SEO). <br />3. Convert the text files to UNIX file format Use the utility dos2unix to perform this <br />conversion. <br />EXAMPLE: dos2unix s23.txt >s23.unix <br />4. Run the UNIX script cutt. structures to prepare file for input This script. <br />written by CADSWES. adds pipe delimiters to the file. which enables SPWRMS <br />database to use the file as input. <br />EXAMPLE: cutt.structures s23.unix > s23.input <br />5. Delete the current structures table from SPWRMS database. <br />EXAMPLE: DELETE FROM phS_rights <br />6. Use Informix utilities to load the file. Simple SQL statements will load a text file of <br />this format into the database. <br />EXAMPLE: LOAD FROM s23.input INSERT INTO <br />phS_structures <br /> <br />Other Tables <br /> <br />Other static tables which may need to be updated include the gagingstations table, the <br />lag_loss_default table, and the spotcheck table. Changes to these tables must be performed <br />in conjunction with changes to the other tables within SPRWMS DB. or ARCIINFO maps, <br />and will be described in later sections. These changes are likely to be row-by-row changes, <br />rather than the bulk operations described above. <br /> <br />1.4 SPWRMS Spatial Database <br /> <br />The spatial data for the South Platte Water Rights Management System are in the form of <br />digital planimetric maps covering the extent of the South Platte River basin. Map <br />elements, such as lines and points, have associated attributes which define the identity and <br /> <br />Database Manual <br /> <br />13 <br />