Laserfiche WebLink
CRDSS <br />TASK MEMORANDUM 1.10-1 <br />Station Database <br />Station Database Year 1 Summary <br />1.0 ISSUE <br />The purpose of this task memorandum is to document the station database task activities performed <br />during Year 1. <br />2.0 DISCUSSION/ANALYSIS <br />The primary focus of the database effort was to create a populated station database to support the <br />historical database and to provide tables for data that do not fit well elsewhere. During Phase I, the <br />database design was formulated, and construction of the database began. Beginning in Phase IIa, the <br />database design was refined, and database construction and population continued. Character-based <br />displays were built using the INFORMIX tools as a prototyping tool, debugging tool, and a tool to verify <br />database contents. <br />The progress on the station database task will be summarized by first briefly discussing the work <br />products specified in the scope of work. <br />1.A station database which satisfies the CRDSS requirements for the Gunnison River basin and <br />the other five basins. <br />Table 1 summarizes the station database population to date. The primary purpose of this database task <br />was to ensure that alternate identifiers and station comments, where available, were populated into the <br />database. Note that these data are linked to the data types and identifiers that are part of the historical <br />database. These identifiers include the and These identifiers make it possible to <br />geoloc_num wd. <br />query the database and find, for example, all of the gaging stations in a water district. The <br />is the identifier that was used to query the relational database from the visual data <br />geoloc_num <br />browser. <br />All station header information was digitally available when the data for the historical database were <br />populated into the station database. However, header information was not available for the flow stations. <br />2.A simple GUI to enable the user to easily display and modify the station data. <br />The data entry screen in Figure 1 allows the station database to be updated and viewed. These screens <br />are part of the CRDSS form-based database displays. Note that the individual designated to update the <br />database must have the correct database permissions. There is a recommendation to add a subtask to the <br />Phase IIb scope to update the database if additional digital information becomes available. <br />User input on the displays was solicited near the end of the phase. The station remarks were not added to <br />the streamflow displays in time to be demonstrated as part of that activity. However, based on comments <br />received (additional discussion on displays is provided in Task Memorandum 1.08-2), the time series <br />1 <br />A275 01.09.95 1.08-10 Greer <br />