Graphical Data Processor (GDP) User Manual
Contents
1. Main List Setting 7 7 7 Station and Parameter Lists Data Display Data Type Graph Button 7 777rrrrrrrrnnnn Export Button eee ee e ee eee Exporting Data for WASP Plot Style 7 70 2002 reer rere eee eee eee eee Date Interval Interpolate Option 7 7 4 5 Units Page Tab 5 0 Input File Formats 2 22 22 eee eee eee eee 5 1 STORET File Format 5 2 WATSTORE File Format 6 0 References 2 2 2222 ee ee eee eee eee eee 7 0 Index 222 22 e eee eee eee eee eee ee eee eee eee eee GDP Version 1 1 iv Introduction 1 0 Introduction Current methods for preparing input files for water models such as WASP5 are cumbersome and often become the major task of water modeling projects The Graphical Data Processor GDP has been designed to receive standard2. 7 77 7 9 Closing a Project 777777 77 9 Saving a Project 9 Selecting Other Projects 10 Exiting the Project 7 7 10 3 2 Data Menu 10 Adding Data from a Spreadsheet 1l 3 3 View Pull Down Menu 12 3 4 Window Pull Down Menu 13 3 5 Help Pull Down Menu 13 GDP Help 2 7 2 rrr reer eee eee ee 14 About GDP 14 4 0 Data Tabs 2 2 2 2ee ee eee ee eee ee ee eens 15 4 1 Project Information Tab 15 4 2 Aggregation Tab 15 4 3 Edit Data Tab 17 iii Graphical Data Processor GDP User Manual Adding and Deleting Station Parameter pairs Adding Values for Parameters 4 4 Data Availability Tab Data Time Period
3. Tofile tab delimited To file comma delimited WASP helpers C Toile as timeseries To clipboard as timeseries Cancel _ Figure 22 Export Report Table Options The Export Report Table has the following options e To clipboard This option saves the information in the data display to the clipboard using tabs for delimiters The information can then be pasted into a spreadsheet using the File gt Paste option within the spreadsheet To file tab delimited or comma delimited These options bring up a file browser window to specify the name and location of the ASCII data file e WASP Helpers These options can be used in conjunction with WASP Builder to populated input data files for the WASP water quality model 21 Data Availability Tab Graphical Data Processor GDP User Manual 4 4 8 Exporting Data for WASP To use these option you should have only one station selected If you have multiple stations selected a warning box will appear GDP AN Only timeseries data for a single station and parameter can be output Figure 23 WASP Warning Box The data can be saved to your computer s clipboard and then pasted directly in the correct data tab in WASP Builder or it can be saved to a file to be imported later The file option will display a file browser window to specify the name and location of the file to be saved Note To paste or import the file into Wasp Builder see the Wasp Builder User Manu
4. Closing a Project 9 Control Key 7 Creating a New Project 6 D Data Aggregation Window 16 Data Availability 20 Data Display 20 Data Pull Down Menu 10 Data Time Period 19 Data Type 20 Data Values 20 Date Interval 22 Display of Windows Currently Open 13 29 7 0 Index E Exit Option 10 Exiting the Project 10 Export Button 21 Exporting Data for WASP 22 F File Menu 9 File Pull Down Menu 9 Filter Box 7 Format of Spreadsheet Data 18 Full View 13 G GDP Data Tabs 15 Getting Started with GDP 5 Graph Button 20 Graph Window 21 Graphical Data Processor Directory 5 Graphical Data Processor Option 5 H Hardware Requirements 1 Help Pull Down Menu 13 A Entries Iconified 13 Input File Formats 25 Installing GDP 5 Interpolate Option 22 Introduction 1 Main Display Window Figure 6 Main List Setting 20 Max Mean Min 22 Mean 22 Multiple Stations 11 O Open Button 7 Open Window 6 Opening Files 7 P Parameters 15 Parse Spreadsheet Information Window 18 Plot Graph Window 21 Plot Style 22 Programs Option in the Start Menu 5 Project Information Tab 15 Pull Down Windows 9 R References 27 GDP Version 1 1 Graphical Data Processor GDP User Manual S Save Project 9 Selecting Directories in the Open Window Figure 7 Selecting Multiple Items from a List 7 Selecting Other Projects 10 Shift Key 7 Single Station 11 Starting GDP in Windows 5 Statio
5. Dr Luis Garcia was the Principal Investigator and director of the project at the IDS Group CSU David Patterson and Hong Zhaohui did the programming and software engineering and Robert Lange and Anna Perea created the documentation Table of Contents Table of Contents 1 0 Introduction 25 55 2252 e eee eee eee eee eee eeeee 1 1 1 Hardware Requirements 1 1 2 WASP Builder 1 1 3 WASP Version 5 1 1 4 STORET Data Files 2 1 5 WATSTORE Data Files 2 2 0 Getting Started with GDP 5 2 1 Installing GDP 5 2 2 Starting GDP in Windows 5 Creating a New Project 7 7 6 Loading Parameter Data 6 Selecting Multiple Items from a List 7 3 0 Pull Down Windows 22 2 eee eee eee eee 9 3 1 File Menu 9 New Projects 9 Opening Projects
6. New Ctri N Open Ctrl O 1 test gdp 2 bob gdp 3 new gdp Exit Recently Used Files Figure 7 Selecting Recently Used Projects W 1 6 Exiting the Project The Exit option quits GDP You will be prompted to save any modified projects This has the same effect as pressing the X close icon in the upper corner of the main window 3 2 Data Menu I GDP GDP1 File View window Help Add STORET or WATSTORE format Add From Spreadsheet Figure 8 Data Pull Down Menu The Data pull down menu has the following options e Add data files from STORET or WATSTORE formats This option can be used to import data in standard formats from these data sources For more information see Section 2 2 2 Loading Parameter Data Add data From a Spreadsheet This option can be used to add data from a spreadsheet program when the data is in the proper format For more information see Section 3 2 1 Adding Data from a Spreadsheet GDP Version 1 1 10 Pull Down Windows 3 2 1 Adding Data from a Spreadsheet To use this option data from a spreadsheet program should be saved as a text file with comma or tab delimiters The data can also be copied to your computer s clipboard using the copy option in the spreadsheet Follow these steps to add data from a spreadsheet 1 Create the data in a spreadsheet according to the following formats Single Station This format uses four columns identification value the time of
7. imported from STORET WATSTORE or spreadsheets Results can be exported to a data file spreadsheet or to WASP Builder for assembling input files for WASP 2 1 Installing GDP 1 In world wide web browser open the following page http www ids colostate edu projects gdp download html 2 To download a zipped file containing the setup files for GDP click your mouse on the most current version of GDP listed in the table 3 After selecting the file in your browser open the file and use the Install button in the Winzip program 4 Follow the setup instructions 2 2 Starting GDP in Windows 1 Select the Programs option from the Start menu on the lower left corner of the screen Figure 1 Program Options Start Menu o d 3 Exploring D Projects d Figure 1 Programs Option in the Start Menu 2 One of the options will be WASP AT Select the WASP AT folder in the program menu and open the GDP folder and select the GDP file 5 Installing GDP Graphical Data Processor GDP User Manual 3 The window shown in Figure 2 will be displayed EAD GDP1 olx File Data View Window Help la x Deh Project Information Aggregation Edit Data Data Availability Units Page Input Data Files Ready CAP NUM Figure 2 Main Display Window N 2 1 Creating a New Project You can create a new project before you begin working 1 To start or create a new project select the New opt
8. inputs from STORET WATSTORE and spreadsheets GDP can be used to interpolate data for time periods and can be used to combine parameters and or stations so that they appear as a single entity Once data has been processed it can be used with WASP Builder to fill parameter values such as flow or constituent amounts or it can be used for other modeling tasks 1 1 Hardware Requirements GDP the data preprocessor described in this manual has been designed to run in a Windows 95 98 NT environment with at least a 486 processor and 16 megabytes of RAM 1 2 WASP Builder WASP Builder can be used to build input files for the WASP water quality model Data developed in GDP can be imported into WASP Builder to fill out data cards for WASP 1 3 WASP Version 5 Water Quality Analysis Simulation Program WASP is a generalized framework for modeling water quality and contaminant fate and transport in surface waters Based on a flexible compartment modeling approach WASP can be applied in one two or three dimensions WASP is designed to allow substitution of user written routines into the program structure Problems that have been studied using the WASP framework include biochemical oxygen demand and dissolved oxygen dynamics nutrients and eutrophication bacterial contamination and organic chemical and heavy metal contamination EPA 1995 WASP has been used to simulate the water quality and pollutant fate for a variety of aquatic systems It is used
9. primarily to investigate the water quality response to management actions primarily point and non point source load reduction It is presently being distributed by EPA Office of Research and Development Center for Exposure Assessment Modeling Athens GA CEAM The technical contact is Robert B Ambrose Jr Address U S EPA Center for Exposure Assessment Modeling 960 College Station Road Athens GA 30605 2700 1 Hardware Requirements Graphical Data Processor GDP User Manual 1 4 STORET Data Files STORET is a computerized data base utility maintained by EPA for the STOrage and RETrieval of parametric data pertaining to the quality of the waterways within the contiguous United States EPA 1996 STORET includes several individual but related systems which contain various types of information l Geographical political and descriptive information concerning sites where data have been collected These sites known as stations within STORET are the base to which data are attached Measurements of the physical characteristics and chemical composition of water fish tissue or sediment sampled at these sites referred to as parametric data in STORET This system the Water Quality System is by far the largest and most widely known facility in STORET Counts and descriptions of living organisms found at these sites known as Biological Field Surveys in STORET Stream flow data obtained from the U S Geolo
10. the WASP Builder display 1 View gt Toolbar This displays the tool bar with the following options i bd New GDP File S A YV YY About Box Open GDP File Save File Figure 1 GDP Toolbar e New GDP File Creates a new GDP file see Section 3 1 1 New Projects e Open GDP File Opens a GDP project file see Section 3 1 2 Opening Projects e Save File Saves the current project file see Section 3 1 4 Saving a Project e About Box Displays the About GDP dialog see Section 3 5 1 GDP Help GDP Version 1 1 12 Pull Down Windows 2 View gt Status Bar The status bar contains information about the workings of the program and can be displayed or not depending on the setting of the option It is located in the lower left corner of the main window le 4 Status Bar Ready Figure 2 Status Bar 3 4 Window Pull Down Menu S GDP GDP1 ieee Help New Window Cascade Project Information Iie Arrange Icons Input Data Files Figure 3 Window Pull Down Menu Options for the Window pull down menu 1 Window gt New Window This option creates a new view of the current project 2 Window gt Cascade If there are multiple windows open this option will cascade the windows in the main window 3 Window gt Tile If there are multiple windows open this option will tile the windows in the main window 4 Window gt Arrange Icons If there are multiple windows iconified this option w
11. used to view the results of a data aggregation and to export aggregated data to other programs GDP GDP1 _jolx File Data View Window Help la x Os Data Type Project Information Aggregation Edit Data Data Availability Units Page Graph Data Time Data Type Button Period C Data Availabilty Graph Export aah Main List r Data Values p a S Main list consists of Stations Parameters Button Setting Stations Parameters m Plot Style Data Interval s WATER TEMP C MaxMean Mi Plot Style Station and 2 aa Min Evey fi N Parameter eee Monts z Date List 06694700 J Add threshold line at Interval Data Dis pl ay aroaro gt T Fill missing data using interpolation Inte rpol ate Data for parameter STREAM FLOW_ option 1 1994 2 1994 3 1994 4 1994 5 1994 6 1994 7 1994 841 07079195 7 5 12 140 40 5 20 4 gt L Ready NUM Figure 19 Data Availability Tab 4 4 1 Data Time Period The data time period is defined by the Start and End dates The default start date is the date of the earliest record that appears in any of the selected data files Similarly the default end date is date of the last record You can shorten the period of record by setting new values for the start or end date You can adjust the start and end dates by selecting the new year month and day in the scroll lists to the right of the display 19 Data Availability Tab Graphical Data Processor GDP User Manu
12. Data Availability Displays symbols for the dates when there is a data reading for the given station and parameter Data Values Displays the data values for the parameter specified This option can only be used for single parameter selections 4 4 6 Graph Button Graphs the data displayed in the lower table The data availability graph will list the station or parameter names on the left y axis and use a symbol to indicate if data is available for the period of record that you requested Otherwise values of a given parameter are on the y axis and the period of record is on the x axis on the plots The plot graph window Figure 21 is displayed when the Graph button is selected from the Data Availability tab GDP Version 1 1 20 Data Tabs STREAM FLOW_ Bika Wa etc ES arc Hei 2D sta ae ea EE 2 Q INST CFS 8 1954 Q 1 954 10 1 954 11 1 96 12 1954 4 z 2 5 5 Time 4 07083000 07079200 v 09077160 09063700 07079195 07080980 Figure 21 Plot Graph Window Note The graph format can be changed using options in the graph control tabs For more information on how to use these options select the help button in the Graph window by clicking on the a icon 4 4 7 Export Button This option generates a simple report using the contents of the data table When the Export button is selected the Export Options window will be displayed Export Report Table Options xi
13. G PRR oO FW SEP MR Mm PM POR GDP looks for the UNITED STATES DEPARTMENT OF INTERIOR GEOLOGICAL SURVEY text to know when to start reading data for a station The next line includes the station number and name which is read and stored The next two lines are skipped and the parameter units and period of record are read The data is stored by day of the month with the months listed by water year i e October September The data is stored in 9 character strings starting at the 20th character This information is stored for each of the 31 days of the month After the first set of data values are read the algorithm searches for the next header string and the next set of values Non values are stored using GDP Version 1 1 26 References 6 0 References Environmental Protection Agency EPA 1995 Water Quality Analysis and Simulation Program WASPS URL http www epa gov OWOW watershed tools model html 29 Last updated October 2 1995 Environmental Protection Agency EPA 1996 STORET URL http www epa gov OWOW STORET index html Revised May 31 1996 Pinnacle Publishing Inc Graphics Server Version 4 50 URL http www pinpub com gserver September 2 1997 27 WATSTORE File Format Graphical Data Processor GDP User Manual GDP Version 1 1 28 A About GDP 14 Add data files from STORET or WAT STORE formats 10 Add threshold line at 22 Adding data From a Spreadsheet 10 C
14. Graphical Data Processor GDP User Manual Ble la x Project Information Aggregation Edit Data Data Availability Units Page Start Jan fi X 1970 X Graph Type Plot Type C Single Station Multiple Parameters C Data Availability End Dec E 31 i E3 Multiple Stations Single Parameter Data Values Main list consists of Stations C Parameters Plot Style Interval Stations Parameters C High Low Close Every I Median Yeas E I Add threshold line at STREAM FLOW_ Biles W GD ete EE anc 123 BR a Data for parameter STREAM FLOW_ 1 1970 1 1971 07081200 25 3333 34 07083000 21 3 24 8696 STREAM FLOW INST CFS Ready Version 1 1 Developed by the Integrated Decision Support Group IDS at Colorado State University for The United States Bureau of Reclamation and the Environmental Protection Agency EPA Saran re Ph ets ond nvironmenta _ Protection aura oF cuanto A University Agency Graphical Data Processor GDP User Manual Version 1 1 Copyright Copyright 2000 Integrated Decision Support Group 601 South Howes USC Suite 502 Colorado State University Fort Collins Colorado 80523 USA About This Document This document is a user manual for the Graphical Data Processor GDP software developed as an analysis aid for the Water Quality Analysis Simulation Program WASP Version 5 0 This user manual is parallel to the on l
15. _DISS MN MN_DISS FE_TOT UG L UG L UG L UG L s9 9 a9 9 9 9 a9 E9 79 29 9 9 9 9 lt 9 9 9 a 9 lt 9 9 g 29 9 9 z9 g 9 9 eg 29 E ee 9 The second line of the file is the parameter names starting at column 26 at each 8 character spaces The third line is the continued name of the parameter and is read in the same manner The fourth line is the Units for the parameter is read in the same way Successive lines are read for the year first 4 digits and the month day hour and minutes all 2 digits each The parameters are read with the value occurring after at least one space Non values are stored as 9 25 STORET File Format Graphical Data Processor GDP User Manual 5 2 WATSTORE File Format WATSTORE retrieval files typically contain all the details of the data query including the cost what parameters were found etc Next the data follows listed by station with the parameter values for each date in a table format 1 UNITED STATES DEPARTMENT OF INTERIOR GEOLOGICAL SURVEY 0 STATION NUMBER 07081800 CALIFORNIA GULCH AT MALTA CO LATITUDE 391321 LONGITUDE 1062117 DRAINAGE AREA STREAM DATUM PROCESS DATE IS 08 30 96 SOURCE AGENCY USGS STATE 08 COUNTY 065 DISCHARGE IN CUBIC FEET PER SECOND WATER YEAR OCTOBER 1991 TO SEPTEMBER 1992 MEAN VALUES 0 DAY OCT NOV DEC JAN FEB MAR APR 1 Tss 1 0 1 0 Tol 13 1 6 1 4 2 1 3 1 0 1 1 ket 1 3 1 7 1 5 3 E93 1 0 1 2 1 0 1 3 1 5 1 6 MAY PRR ans AU
16. al Project Information Aggregation Edit Data Data Availabilty Start Jaan x fi 7 A fisis x End jai 7 i E x Mar 7 D Stations Parameters Parameters 4 4 2 Main List Setting This option is used to switch the order of the Station and Parameter lists so that data can be viewed by looking at one parameter at several stations or by looking at several parameters for one station The right list allows for only one selection and the list on the left allows for multiple selections Figure 20 Scroll List for Data Time Periods 4 4 3 Station and Parameter Lists This is a list of all the stations available if the Stations option is selected for the Main List Setting The right list will show all the parameters that are associated with the selected stations The order can be reversed by selecting the Parameters radio button If you want to make multiple selections for parameters or stations make sure that the group is in the display on the left 4 4 4 Data Display Data for the selected stations and parameters will be displayed in this area The data displayed here will be the same data that is used for the graph and export options 4 4 5 Data Type Shows data availability or data values for the selected stations and parameters When the Data Availability option is selected time periods that have a reading for the selected items will show a value of 1 and periods without data will show a 0 in the Data Display e
17. al for how to import timeseries data 4 4 9 Plot Style This option can be used to plot the data in a graph with different styles The maximum mean and minimum of the values in the selected period of record using the Date Interval will be displayed if the Max Mean Min radio button is selected Otherwise the table entries will represent the mean of the data Note All Plot Style options are active only when the Data Values option is set in the Data Type The following options are available for plot style e Max Mean Min This option plots the maximum mean and minimum of the data selected e Mean This option displays the mean of the data selected for the selected interval e Add threshold line at This option will display a line on the plot at the value entered in the field 4 4 10 Date Interval Data can be displayed using different intervals of time For example a data reading can be generated for every 10 years starting at the date given in the Start fields by specifying a 10 in the Every field and selecting years from the scroll list If multiple data points fall in a given interval the value generated is the average of the data points 4 4 11 Interpolate Option The Interpolate option can be used to fill in missing data The algorithm fills the beginning and end of the period selected with the first and last values respectively For every additional missing value a linear interpolation is done between the nearest values o
18. by successive projects Conversions use a multiplier i e the slope of the relationship and an offset i e the y intercept value allowing for complex unit conversions The multiplier is multiplied times the original values and the offset is added to the result for every place in the project the units are used 23 Units Page Tab Graphical Data Processor GDP User Manual GDP Version 1 1 24 Input File Formats 5 0 Input File Formats Input files can be in standard STORET or WATSTORE file formats This section provides a description of the file formats supported by GDP Data can also be entered into GDP using a spreadsheet program the formats used are described in Section 3 2 1 Adding Data from a Spreadsheet and Section 4 3 2 Adding Values for Parameters 5 1 STORET File Format STORET retrievals for water quality data include a string indicating the date time and station name and columns for each parameter with values 00003 00010 VSAMPLOC WATER DEPTH TEMP FEET CENT 19730809 999126901 199004181245390009106135001 199006061405390009106135001 199007171840390009106135001 199008281620390009106135001 199010310800390009106135001 199104240835390009106135001 I 7 0 SS 8 5 2 5 30 S Ts 1 5 00061 00003 00010 STREAM VSAMPLOC WATER FLOW_ NST CFS 9 29 84 27 13 7 3 DEPTH FEET TEMP CENT Pe PrRWNM ous LEAD PB_TOT Aan n n nnne 01049 01055 01056 01045 LEAD MANGNESEMANGNESE IRON PB
19. e data to the clipboard using the copy option or save the data as a text file with columns delimited by tabs or commas 3 Select the Data gt Add From Spreadsheet option The window shown in Figure 11 will be displayed Select the Location Separator and Format appropriate to the data you are importing 11 Data Menu Graphical Data Processor GDP User Manual 4 Add the parameter name and units in the Choose Spreadsheet Options window and click on the Add Parameter button r Choose Location File O Choose Separator E Comma Tab r Choose Format E Single station 1st line is station name 2nd is skipped leomment restis 4 columns of data ID value HH MM SS DAY MON YEAI Multiple stations 1st line is header with first column arbitrary each successive column the date of the reading 1 station per line 1st column is station name each successive column is a value m Choose Parameter New Parameter Name Flow Units iets Add Parameter Corca Figure 11 Choose Spreadsheet Options Window 5 Select the OK button 6 Select the Edit Data tab to view the results For more information see Section 4 3 Edit Data Tab 3 3 View Pull Down Menu WASP Builder WaspB1 g File wasr EE window Help wilpal Toolbar wR ait v Status Bar r E Figure 12 View Pull Down Menu The View pull down menu has two options that are toggle switches to change
20. ee Figure 15 4 Select the stations or parameters from the list on the left to aggregate In this case select item 3 and item 4 from the station list in the left column by clicking on each Note If you need to do a conversion to aggregate parameters you should go to the Units data tab and do the conversion before aggregating 5 Select the right arrow icon 6 The Aggregation Name dialog window will be displayed Figure 15 Give the aggregation a descriptive name i e New Station and add the selected stations J GDP GDP1 of x File Data View Window Help lal x Project Information Aggregation Edit Data Data Availability Units Page Edit Type Stati C Stations Parameters Aggregation Name xi Choose a name for this group New Station cres aA Figure 15 Data Aggregation Tab Note If a parameter value occurs at the same time for two stations that are being aggregated the average of the two values will be used This will also be the case when a parameter value is calculated over an interval that contains several data points 7 To remove station s or parameter s from the aggregation list box on the right highlight the new station or parameter with the cursor and click with the left mouse button on the lt button GDP Version 1 1 16 Data Tabs 8 This process can be repeated to create other aggregates Note Any stations not aggregated will remain unselected in the li
21. gical Survey in what is called the daily values system This project has been designed for the types of data found in the Water Quality System but may be expanded to include other items The data contained in STORET are collected stored and used by a variety of federal state interstate and local government agencies and their contractors For more information contact STORET User Assistance Mail Stop 4305 F U S Environmental Protection Agency 401 M St S W Washington DC 20460 800 424 9067 STORET epamail epa gov 1 5 WATSTORE Data Files The National WATer Data STOrage and REtrieval System WATSTORE was established in 1972 to provide an effective and efficient means for the processing and maintenance of water data collected through the activities of the U S Geological Survey and to facilitate release of the data to the public A variety of useful products ranging from data tables to complex statistical analyses such as log Pearson Type III can be produced using WATSTORE The system resides on the central computer facilities of the U S Geological Survey at its National Center in Reston Virginia and consists of related files and data bases Station Header File Contains descriptive information on more than 440 000 sites throughout the United States and its territories where the U S Geological Survey collects or has collected data Daily Values File Contains more than 220 million daily values of streamflows s
22. ill arrange the icons in the main window Note Input file windows can be iconified displayed in full view or closed using the buttons on the upper right of each window EER The horizontal line iconifies a window the square or double square displays the window in full or partial view respectively and the x symbol closes the window Display of Windows Currently Open The list of windows on the bottom of the Window pull down menu displays all the windows that are currently opened A window can be brought to the front by clicking on the window in the list The currently displayed window has a check mark next to it 3 5 Help Pull Down Menu GDP GDP1 File Data View Window EEE Dol R GDP Help About GDP Figure 4 Help Pull Down Menu 13 Window Pull Down Menu Graphical Data Processor GDP User Manual 3 5 1 GDP Help The WASP Builder help files contain the same information as this document 3 5 2 About GDP About GDP displays the version and date of release for GDP GDP Version 1 1 14 Data Tabs 4 0 Data Tabs GDP is arranged in tabs that can be used to view edit and process data sI GDP GDP1 File Data View Window Help D aw Project Information Aggregation Edit Data Data Availability Units Page 4 1 Project Information Tab Figure 13 GDP Data Tabs This data tab displays the full path of any WATSTORE or STORET files the project uses Figure 14 EAD GDP1 Bel E Fi
23. ine documentation available from the software In addition to this user manual there is a programming routine manual that documents the system s current capabilities and describes each of the programming routines developed for this project Participation This project was sponsored and directed by the Department of Interior Bureau of Reclamation Reclamation the Environmental Protection Agency EPA Office of Science and Technology and the Integrated Decision Support Group IDS Group at Colorado State University CSU Fort Collins Colorado USA Faculty staff members and graduate students from the IDS Group and the Department of Chemical and Bioresource Engineering at CSU served as the principal investigators IDS is part of the Water Center at Colorado State University in Fort Collins Colorado USA For more information contact Luis Garcia IDS Group Merlynn Bender USBR Colorado State University Denver Federal Center Building 67 601 South Howes USC Suite 502 Box 25007 Mail Code D 8570 Fort Collins CO 80523 USA Denver CO 80225 USA Phone 970 491 5144 Phone 303 445 2460 FAX 970 491 2293 FAX 303 445 6351 E mail garcia engr ColoState EDU E mail mbender do usbr gov Acknowledgments Services cooperation effort information reviews and guidance provided by Reclamation and EPA staff are greatly appreciated Special thanks to Merlynn Bender Reclamation Denver CO and Dr Russell Kinerson EPA Washington D C
24. ion from the File menu 2 Select a new name and save the file GDP files have a gdp extension N 2 2 Loading Parameter Data You can select STORET WATSTORE or spreadsheet files for analysis using the Data gt Add STORET or WATSTORE format or the Add from Spreadsheet option GDP currently requires STORET and WATSTORE files to be in the standard format and text files to be in supported formats see Section 5 0 Input File Formats When GDP is installed a directory called Examples is created that contains example data files The path for this directory is typically C Program Files WASP AT GDP Examples To import data from STORET or WATSTORE follow these steps 1 Select the Data gt Add STORET or WATSTORE format option 2 Use the Open window to select the directory that contains the data files Figure 3 If you need to access another disk to get to your data files you can change the directory by clicking on the scroll list next to the Look In field see Figure 3 GDP Version 1 1 6 Getting Started with GDP g l examples E 3 Floppy 4 eg Fall C E Program Files DS Group Look in Click here to change directories Filename S2C954D tut metalsw sto Files of type AI Files bi 7 Cancel I Open as read only Figure 3 Selecting Directories in the Open Window 3 The Files of type field shows the extensions of each file type Figure 4 illustrates the extensions as
25. le Data View Window Help laj x Project Information Aggregation Edit Data Data Availabilty Units Page Input Data Files Figure 14 Project Files Data Tab 4 2 Aggregation Tab This data tab can be used to aggregate or combine stations and parameters for analysis Data can be aggregated by e Stations Typically locations for collecting data e Parameters Types of measurements with values for stations by date and time For example if one of your data files contains temperatures for different days but the same location as another data file you can use GDP to combine these two records Sometimes there are more data sites than you need for a model run GDP can be used to combine multiple stations to model river reaches Consider the possibility that you wanted to treat two STORET stations as the same station There may be data collected as part of each of these stations that could provide a more complete record for a given river reach 15 Project Information Tab Graphical Data Processor GDP User Manual when combined This section will walk you through an example of combining two STORET stations contained in the metalsw sto file in the Examples directory 1 Select the File gt New option to start a new project 2 Input the STORET data file i e metalsw sto from the Examples directory by using the Data gt Add STORET or WATSTORE format option 3 Display the Data Aggregation tab and select the stations option s
26. lue place holders will be added at the end of the parameter list The value will be zero and the date will based either on the current time or the date of the last entry Edit the date and values by selecting the table cells and typing in the new values If you have data in a spreadsheet set the format of the data to be pasted from the spreadsheet by selecting the Format button Parse Spreadsheet Information xi The first five columns of each line has the following form ore Figure 18 Format of Spreadsheet Data Each of the fields in the Parse Spreadsheet Information window corresponds to a column of data that is separated by tabs Once the format corresponds to the data you are copying from a spreadsheet select the OK button GDP Version 1 1 18 Data Tabs 3 Make sure the data to be pasted from the spreadsheet is in the correct format Select the data columns and the Edit gt Copy command in the spreadsheet program The data will be saved to your computer s clipboard 4 Select the Add from Spreadsheet button and the data will be added to the lower data table for the station and parameter combination selected 4 4 Data Availability Tab This tab is used to plot graphs that show data availability data values and to export data Data availability plots are typically used before data aggregation occurs to determine appropriate station and or parameter aggregation see Section 4 4 Data Availability Tab This tab can also be
27. n and Parameter Lists 20 Station List 17 Stations 15 Status Bar 13 STORET Data Files 2 STORET File Format 25 T To clipboard 21 To file tab delimited or comma delimited 21 U Units Conversion Window 23 Units Page Tab 23 V View gt Status Bar 13 View gt Toolbar Option 12 View Pull Down Menu 12 30 W WASP Builder 1 WASP Helpers 21 WASP Version 5 1 Water Quality Analysis Simulation Pro gram WASP 1 WATSTORE Data Files 2 WATSTORE File Format 26 Window gt Arrange Icons Option 13 Window gt Cascade Option 13 Window gt New Window 13 Window gt Tile Option 13 Window Pull Down Menu 13 Windows 95 98 NT 1 31 W Entries
28. n either side For example if you had the following data GDP Version 1 1 22 My Stream Flows cfs ID Value Date b sss 4 10 2000 2 2 0 4 11 2000 i Ses 4 12 2000 4 3 0 4 13 2000 20 gt 4 14 2000 Data Tabs The value for ID 1 would be 2 0 and 3 0 for ID 5 the values of ID 2 and 4 repeated respectively The value for ID 3 is halfway between the values for ID 2 and 4 so therefore 2 5 4 5 Units Page Tab S GDP GDP1 File Data View Window Help Mie E 18 x Project Information Aggregation Edit Data Data Availability Units Page Units for all parameters in project Description Multiplier Alias Comment INST CFS 2 CENT 1 FEET 1 UG L 1 Standard conversions INST CFS CENT FEET UG L INST CFS CENT FEET UG L Conversion Name Offset C gt F F gt C REN O li 32 17 78 0 Add Delete Apply lt new entry gt conversion to INST CFS Figure 24 Units Conversion Window The Units Page tab allows you to convert a parameter s units to another type using a pre defined conversion equation or by defining your own conversion equation All the units used for your project are displayed in the upper table The lower table can be used to create standard conversions you may want to use for other projects For example Centigrade to Fahrenheit is already provided When a standard conversion is created it is saved in a separate program file and will be read
29. sociated with STORET and WATSTORE Click here to show filter options Files of type AI Fies ia z ace All Files Figure 4 Showing Particular File Types in the Open Window STORET files must have a sto extension e WATSTORE files have a wat extension 4 Select files individually by holding down the left mouse button and the Control key Hold down the left mouse button and the Shift key to select groups of files After selecting the files click on the Open button 5 2 2 3 Selecting Multiple Items from a List By using the shift and control keys multiple items from a list can be selected e Control Key The control key is used to select multiple items that are not listed in series Depress the control key and select the desired items with the mouse e Shift Key The shift key is used to select multiple items when they appear together in a list and is utilized by depressing the shift key and clicking on the first and last items in the group of items this will also select all the items between the two These features are used when selecting parameters and or stations when aggregating and also for selecting multiple files 7 Starting GDP in Windows Graphical Data Processor GDP User Manual GDP Version 1 1 Pull Down Windows 3 0 Pull Down Windows 3 1 File Menu faim Data View Window C New Ctrl N 4 Open Ctri 0 Close Save CtrhS Save As m 1 bob gdp Exit Fig
30. st of stations and will retain their individual data 9 The next step is to see how the data overlaps from the two stations The Data Availability data tab can be used to display and graph the data from the combined stations 4 3 Edit Data Tab The Edit data tab can be used to enter values for stations and parameters Data can viewed and edited based on stations or parameters using the Edit Type options gt GDP GDP1 BEE File Data View Window Help la x Project Information Aggregation Edit Data Data Availability Units Page Edit Type Stations CALIFORNIA GULCH AT MALTA CALIFORNIA GULCH AT MALTA 000009 06693980 06694400 7 13 1991 0 0 0 7 14 1991 0 0 0 7 15 1991 0 0 0 7 16 1991 0 0 0 7 17 1991 0 0 0 7 18 1991 0 0 0 7 19 1991 0 0 0 7 20 1991 0 0 0 o i PNNEN SSS momo co o NNN Ne Ne Parameter TEMPERATURE WATER DEG C DISCHARGE IN CUBIC FEET PER LEAD PB_DISS UG L WATER TEMP CENT WATER TEMP CENT EAN mace ScaledValue Mask oO 1 8 no I Add fi Add From Spreadsheet Set Format Delete Figure 16 Edit Data Tab Stations that have multiple parameters will show multiple times in the Station list with an entry for each parameter The parameter associated with the station in the Station list can be changed by pressing the left mouse button on the corresponding table entry and selecting the new parameter from the Parameter list dialog Fig
31. tages reservoir contents water temperatures specific conductances sediment concentrations sediment discharges and ground water levels Peak Flow File Contains approximately 500 000 maximum peak streamflow and gage height values at surface water sites Water Quality File Contains approximately 2 million analyses of water samples that describe the chemical physical biological and radiochemical characteristics of both surface and ground water GDP Version 1 1 2 Introduction e Ground Water Site Inventory Data Base Contains inventory data for more than 900 000 wells springs and other sources of ground water The data include site location geohydrologic characteristics well construction history and one time field measurements such as water temperature In 1976 the U S Geological Survey opened WATSTORE to the public for direct access The signing of a Memorandum of Agreement with the Survey is required to obtain direct access to WATSTORE Direct access may be obtained by contacting U S Geological Survey National Water Data Exchange 421 USGS National Center Reston Virginia 20192 3 WATSTORE Data Files Graphical Data Processor GDP User Manual GDP Version 1 1 Getting Started with GDP 2 0 Getting Started with GDP GDP provides functions that allow users to combine data from different sources to aggregate combine parameters and stations and to interpolate values at different time increments The data can be
32. the reading and the date of the reading Since the program is looking only at the text you should be careful with the formatting of the dates and times The dates should have the format of Day Month Year or Month Day Year as shown in Figure 9 Note that all entries use numerical representations except for Day Month Year format which uses the three letter abbreviation of the month lal File Edit View Insert Format Tools Data Window Help laj x EE Err EEIE Aria gt 10 B z u Z 2 0 A 1M ly Stream Flows cfs 2 ID Value Time Date F 3 1 20 5 15 00 4 11 2000 4 2 2 5 6 15 00 4 11 2000 5 3 30 7 15 00 4717720001 6 dl 4b pi sheets Sheet sheets ae Ready a in Figure 9 Excel File with Single Station Format Multiple Stations This format can include data from multiple stations with a date or a date and a time To enter a time enter it in the same cell as the date at the end and enter it in the format hour minute second X Microsoft Excel multi xls olx sl Eile Edit View Insert Format Tools Data Window Help 18 x o SHiSRY sBBS O L EEE E aria gt 10 Bru z 22H e 2 O A Flow cfs 4 11 2000 4 12 2000 4 13 2000 4 14 2000 4 15 2000 4 16 2000 4 17 2000 Station 1 2 5 2 6 27 2 8 29 Station 2 2 4 2 4 24 4 Station 3 2 6 2 7 2 8 Egg SS SI I I SI Figure 10 Excel File with Multiple Station Format 2 Save th
33. ure 17 If values are entered before the parameter is changed the values will be retained with the new parameter Therefore this option should be used with caution The entries in the upper table include a multiplier and offset for location specific conversions The station s value is first multiplied by the multiplier and then the offset is added the resultant values are displayed in the Scaled Value column in the lower table 17 Edit Data Tab Graphical Data Processor GDP User Manual 4 3 1 1 2 4 4 3 2 Choose a Parameter xi STREAM FLOW VSAMPLOC DEPTH WATER TEMP Cancel Figure 17 Choose Parameter in the Edit Data Tab Adding and Deleting Station Parameter pairs Select the number of stations to add in the field next to the symbol to the right of the upper display Select the Add button New values can be entered in the lower window by typing or by pasting from a spreadsheet Stations can be deleted by pressing the Delete button and choosing them from the dialog that pops up This option should be used with caution since it can not be undone Adding Values for Parameters Values can be entered by typing them into the bottom table or from a spreadsheet 1 First select the station and parameter pair from the upper table that you want to add values to If you want to add the values by hand enter the number to add in the upper table and press the Add button on the bottom of the window New va
34. ure 5 File Pull Down Menu W 1 1 New Projects The New option will create a new GDP project 3 1 2 Opening Projects The Open option can be used to open GDP project files with a gdp extension To import files in another format such as the STORET format use the Data gt Add options see Section 3 2 Data Menu 3 1 3 Closing a Project The Close option will close the current project but the main window and any other projects will remain open If the project has been modified since the last save you will be asked if you want to save the changes 3 14 Saving a Project There are two options for saving projects The Save option saves the current project with the current file name The file name is printed in the title bar i e BOTEI The Save As option can be used to save a project with a new name or location When this option is selected a window is brought up that can be used to specify the name and location of the GDP file The Save in field shows the current directory and the File name field is the name of the file you want to save 9 File Menu Graphical Data Processor GDP User Manual Save in i examples x amp cl Ez metalsw gdp l new gdp File name Save as type GDP Files adp Cancel Figure 6 Save As Window 3 1 5 Selecting Other Projects Most recently used projects can be viewed by selecting them from the list displayed above the Exit option in the file menu Figure 7 View Help
Download Pdf Manuals
Related Search