Home

HydroGeo Analyst Demo Tutorial Guide

1. AREA Template This data category contains four tables e Chemistry_Sample sample code date etc e Chemistry_Results sampling results for various chemicals e Field Props physical properties e Water Level results from water table elevations measurements for several dates Chemistry_Results to view the list of samples collected for this well the date and time of the observation and the concentrations provided by laboratory analyses Viewing the Demo Project 23 Sorting Records Using the sorting and filtering options you can also select different views for the data For example it may be helpful to view just the stations at specific elevation To do this Station List tab Project from the Station Groups node Place the mouse cursor into any field under the Elevation column Record Sort Descending from the main menu This will sort the values in this column from highest to lowest You will see that the highest elevation is 340 49 and this occurs at station GB 33 There is a more efficient way to find the data that you want and this involves Queries which will be demonstrated in the next section 2 2 Querying the Database Queries can be used to create station groups or find and locate crucial data values you can quickly filter and locate the desired data from a larger dataset Data Queries can
2. Data Category Y gt Select Stati Xx m Y m Elevation m TOC m Geologio Description GB 06 gt 535743 69 4814070 00 330 50 331 5 0 0 0 0 4 4 E A Queries Tables 1 4 2 Main Menu Bar The menu bar provides access to most of the features available in HydroGeo Analyst See HydroGeo Analyst Main Menu Bar on page 85 of the HGA User s Manual for more details 1 4 3 Toolbar 12 The toolbars that appear beneath the menu bar are dynamic changing as you move from one window tab to another Some toolbar buttons become available only when certain tabs are in view For example the Add and Delete toolbar buttons are only available when the focus is on a grid Some toolbar buttons are available only in a particular context for example the Paste button is only available after the Copy or Cut command has been used The following tool buttons appear at the top of the HydroGeo Analyst main window For a short description of an icon move the mouse pointer over the icon without clicking either mouse button New button loads the Project Manager to create a new project Open button opens an existing HydroGeo Analyst project Chapter 1 Introduction to HydroGeo Analyst ii E Zee x 5 E About the Interface Print button sends the data item that is currently active to the report manager This data item could be a list of stations data from any table
3. RTF and other file formats In addition the Report Editor allows for customizing the header footer and logo The image will appear similar to the one shown below Contents amp fh amp ml A x EE vet OE A 0 CODO AN DI Ona naon Ju 0 veS SE Cross Section AA Vertical Exaggeration 6 46743 Topography 400 Distance m ee ce _ Print Report button from the toolbar X Close button to return to the Cross Section Editor window In the next section you will see how multiple cross sections can be viewed in 3D 2 5 Visualizing Cross Sections and Maps in 3D Quite often viewing individual cross sections in 2D simply does not provide the overall picture of the site lithology Fortunately HydroGeo Analyst offers the 3D Explorer tool which allows you to simultaneously display multiple cross sections in order to create fence diagrams In this demonstration you will select a few cross sections from the Demo Map project and load these into 3D Explorer Visualizing Cross Sections and Maps in 3D 39 From the Cross Section Editor View View 3D from the main menu or select the button from the toolbar The following dialogue will appear x m Select CrossSections Select Surfaces Tl Select All T Select All Cross Section Name Grid Name IV Include site map 3D name demd OK C
4. 1 2 4 Starting HydroGeo Analyst a To launch HydroGeo Analyst double click on the desktop icon as shown on the left hand side or by accessing WHI Software HydroGeo Analyst from your Start gt Programs Windows menu 1 3 Learning HydroGeo Analyst There are several ways of getting acquainted with HydroGeo Analyst including using the Getting Started section in Chapter 2 of the User s Manual a Demo Tutorial which is provided with this document and the On Line Help Please contact Waterloo Hydrogeologic if you require further training on this as well as any other software developed and distributed by Waterloo Hydrogeologic 1 3 1 HydroGeo Analyst On Line Help The User s Manual is supplied to you in two forms as a printed book and as an online help file To view the online help version of the manual select Help gt Contents Some HydroGeo Analyst windows and dialogues contain H Hep buttons which allow for loading the help section for the current active component A HydroGeo Analyst Help window is divided into three main areas 8 Chapter 1 Introduction to HydroGeo Analyst e A Navigation Frame on the left displays the Contents Index Search and Favorites tabs e A Toolbar across the top displays a set of buttons to move around in the HydroGeo Analyst Help system A Topic Frame on the right displays the actual Help topics included in the On Line Help The tabs in the Navigation Frame provide the core navigational f
5. 519 885 5262 E mail Sales waterloohydrogeologic com Web www waterloohydrogeologic com 50 Chapter 2 Demonstration Exercise
6. Waterloo Hydrogeologic Inc means for example that this software may be used by any num ber of people and may be freely moved from one computer location to another so long as there is NO POSSIBILITY of it being used at one location while it is being used at another Just like a book can t be read by two different people in two different places at the same time Specifically you may not distribute rent sub license or lease the software or documentation alter modify or adapt the software or documentation including but not limited to translating decompiling disassembling or creating derivative works without the prior written consent of Waterloo Hydrogeologic Inc The provided software and documentation contain trade secrets and it is agreed by the licensee that these trade secrets will not be disclosed to non licensed persons without written consent of Waterloo Hydrogeologic Inc Il Warranty Waterloo Hydrogeologic Inc warrants that under normal use the material on the CD ROM and the documentation will be free of defects in materials and workmanship for a period of 30 days from the date of purchase In the event of notification of defects in material or workmanship Waterloo Hydrogeologic Inc will replace the CD ROM or documentation The remedy for breach of this warranty shall be limited to replacement and shall not encompass any other damages including but not limited to loss of profit and special incidental consequential or othe
7. 460577457861 20593 20 93 2608 13 80 553231831 65 43 481463607934 324 85 32585 i az os 14_ 8055402680388 13 460990954016 223 05 224 05 gt 6815 80 55533499173 43 480315651909 24 26 325 26 l r lola aa nasal 2751 Return to Designer 2 button to move to the Report Designer The following window will appear ja SARRIA AAN eS Ee ella MainReport PageHeader HE Detail EHE PageFooter Jetsvatiori Creating Data Summary Reports 47 48 Properties button circled in the image above to display the ToolBox Properties menu gt New Report in the Designer window circled in the image above to activate that label Caption field of the Properties and change New Report to Boreholes lx Label1 s Els Name Label1 Alignment 2 ddTXCenter Angle 0 BackColor E BackStyle OQ ddek Transparent Classhame torma Font Arial ForeColor height 567 hyperLink left 35 MultiLine True Style text align center ver Tag top 360 Vertical lignme 1 ddTXMiddle Visible True width 9360 WordWrap True Expand the Detail node of the Report tree gt fldx to activate the x coordinate field OutputFormat field Chapter 2 Demonstration Exercise ix ge leh Custom Name Fldx Alignment
8. for the newly selected station You can also see the Well Construction in the Well Profile diagram To do this Station List tab GB 15 in the list to ensure it is selected View Well Profile A new frame will appear in the HGA window containing a profile view of the selected station After resizing the plot columns your view should be similar to the figure shown below S HydroGeo Analyst Demo D Program Files HGAnalyst Projects Demo_Project AEE Project Edt View Record Settings Tools Help Ge 2 SAX al ROE gt ada a i gt Station Groups Profle 68 181 afl Station List 3B Data Quer Station Data br re ea bhipt 7 x iv lonitoring Wells m m m sai Boreholes 53621269 4814030 00 323 50 a Soil Borings 536156 69 4814050 00 326 00 a Al Stations 596079 68 481407000 326 00 Station_Data 53595369 4814020 00 322 00 Queries 535848 69 4814060 00 324 00 itt clas aria cian 535743 69 4814070 00 330 50 clevation esconde 328 nea 535652 69 4814030 00 332 00 535498 69 4814040 00 32350 i par peated m9 bide and 535386 69 4814060 00 32950 tce exceeds 10 mg per kg 535295 69 4814030 00 338 00 tvoc exceeds 5000 ug per 53523269 4814000 00 339 50 vo exceeds 1 mg per kg Paki 536225 92 4814281 80 325 93 a 5306878 E ME a tna 535960 34 4814251 30 324 26 535866 68 481434940 326 56 BA 595776 66 4814293 00 328 30 al es 535625 46 4
9. item is EEN Queries S 5 7 E Maps organized as a node in the tree view with one or more items All Site Map A x A EMI Cross Sections under each node If there is no item under a given node there aij aa will be no branches available aj cc E E Reports El pr Station Groups H Map H Queries El a Cross Sections 3D Views Gi Borehole Logs El Template A ES 3D M lt box 24 Borehole Logs 3 bhiot Station Groups The Station Groups node contains the Station Groups in your HydroGeo Analyst project By default all projects will contain a station group named Project that lists all stations in the database belonging to the project All station groups that are created for a project are listed under the Station Groups node below the Project node Clicking on any station group under the Station Group node will load the Station List tab and display a limited number of columns of data for the stations belonging to that group Additional fields and tables for each Station are available through the Station Data tab discussed later in this section Station Data Data Categories The Station Data node displays the visible data categories under which project tables are organized Clicking on any of the data categories activates the Station Data tab if it is not already active and displays a tab for each of the tables classified under the selected data category The Station Data tab loads information for the station currently
10. module All model interpretations can be exported for use as modeling layers in groundwater modeling software packages including Waterloo Hydrogeologic s Visual MODFLOW The Cross Section editor is seamlessly integrated with the HydroGeo Analyst 3D Explorer a tool that combines and displays one or more cross sections in a 3D fence diagram view 3D Subsurface Visualization with 3D Explorer Once cross sectional views of the data are created and preliminary interpretations are made the 3D Explorer can be used to create fence diagrams containing one or more of those cross sections The 3D Explorer provides a unique perspective of the entire site through its ability to display multiple cross sections simultaneously this perspective is not possible when viewing individual 2D cross sections The 3D Explorer in addition to displaying fence diagrams can also be used to display surfaces for each layer involved in the interpretation For instance a surface depicting static groundwater elevations over the site can be created and displayed in the 3D Explorer Use the 3D Explorer to import basemaps or shape files containing any type of data and relate this to the cross section interpretations For example a contour map or DXF site map may be draped or overlaid on top of multiple fence diagrams Finally use the AVI recording tools to record the auto rotation of the 3D fence diagrams for presentation purposes 1 1 4 Reporting and Printing Repor
11. or a query result This button is activated only if a grid is active Refresh button refreshes the current view by updating the project browser and all grids Copy button copies selected character s in a grid cell to the clipboard Paste button pastes text from the clipboard to the active cell Add button adds a new record this button is activated only if a grid is active Delete button deletes the selected record this button is activated only if a record is selected Post Data button saves posts all changes made to the project this button is activated if changes to a record have been made Find button displays a dialog for searching in a grid using a user specified criterion Filter by Value filters the grid using the value in the active cell Hide Selected button hides selected data records rows this button is activated only if one or more records are selected Inverse Selection button will select all records that are not selected and de select all records that are currently selected this button is activated only if one or more records are selected 13 14 Sort Ascending button sorts records in ascending order based on the selected column this button is activated when the cursor is placed in one of the grid cells Sort Descending button sorts records in descending order based on the selected column this button is activated when the cursor is placed in one of the grid cells Template Manager button l
12. selected in the Station List tab The station can be easily changed in the Station Data About the Interface 15 tab using the Select Station combo box Data categories are provided to enable logical groupings of your tables Queries The Queries node lists all the queries that are created and available for the current project Double clicking on any of the queries under this node executes the query activates the Data Query tab and displays the returned results Maps The Map node lists all map projects that are available created for the current HydroGeo Analyst project Double clicking on a map project node loads the map manager if not already loaded and opens the selected map project into the map manager Cross Sections The Cross Sections node lists all cross sectional views created using the Cross Section Editor Double clicking on a cross section launches the Cross Section Editor and loads the selected cross section Reports The Reporting component included with HydroGeo Analyst allows you to create as many reports as needed for your project and save the layouts for future report generation All the reports created for a selected project will be listed under the Reports node Double clicking on any of these report layouts will open a report template or a saved report By default the report will be displayed in print preview mode however it is a simple task to activate the report designer in order to modify the report layo
13. shown below along with the well profile The well profile is not loaded by default To activate it select View Well Profile and select one of the Borehole Log Plotter BHLP templates discussed later About the Interface 9 Menu Bar 8 x Project EMM Record Settings Tools Help Toolbar Sp 0 x64 84005 gt 805 240 29 10 Era Station Groups Profile 68 01 aff Station List Data Query E Station Data a Project A Montoiing Wels trip Station Name ES i I Teran ie 9 Boreholes Geo 53621269 4814030 00 32350 13245 sa Soil Borings GB 02 536156 69 4814050 00 326 00 327 aff Al Stations 68 03 536079 69 4814070 00 326 00 327 Proj ect a wayne 1GB 04 535953 69 4814020 00 32200323 ation Data GB 05 535848 69 4814060 00 324 00 325 GB 06 535743 69 4814070 00 330 50 331 9 Browser a A coe 68 07 53565269 4814030 00 33300 33 E cen GB 08 535498 69 481404000 329 50 3305 Es MY Cross Sections 68 09 535386 69 4814060 00 32950 3305 E E Reports 68 10 53529569 4814030 00 338 00 339 B BDView Medium 68 11 53523269 4814000 00 33950 340 5 Bf Borehole Logs Sand GB 12 536225 92 4814281 80 325 93 326 93 Well GB13 53612974 4814379 70 324 85 325 85 68 14 536065 76 4814320 20 32305 324 05 GB 15 535960 34 4814251 30 324 26 325 26 Profi le GB 16 535866 68 4814349 40 326 56 327 56 GB 17 535776 6
14. the Report Editor allows for customizing the header footer and logo The image will appear similar to the one shown below Visualizing Cross Sections and Maps in 3D 43 6322 ma anaoa AASE x Contents Print Report button from the toolbar X Close button to return to the 3D Explorer window Then close the 3D Explorer window by selecting File Exit from the main menu In the next section you will view borehole log plots for one of the stations 2 6 Creating Borehole Log Reports Using the HydroGeo Analyst Borehole Log Plotting BHLP Tool you can create a professional style borehole log report A few samples are provided in the Demo project Select Boreholes from the Station Groups node in the project browser From the project tree expand the Borehole Logs node then bhipt The WHI Borehole Log Plot Designer window will appear as shown below 44 Chapter 2 Demonstration Exercise 10 x e ___ sciqner bhip1 elect Station GB 01 Y Elevation m TOC m 6212 69 4814030 00 323 50 324 5 Beta Beta B Lithology Well Construction Scale Coarse Gra Design H E Lithology E Well Construction Scale Medium Sal wH FXT Name Value Fine Sand 60 24 100 Close Print B Hep From the Select Stations drop down m
15. the map project as a new map layer Next you will create a Thematic map in order to visually represent the greatest concentrations of TCE at these stations 2 3 2 Creating a Thematic Map In this example you will create a Bar chart To create a Thematic Bar Chart TCE exceeds 5mg per_kg layer from the Layer Control it should be the first top most layer to ensure that this layer is active gt Layer Create Thematic Map Bar Chart from the Map Manager main menu A Thematic map window will appear as shown below Create Thematic Map d xj Name Bar Chart Fields in Table Fields for the Theme ID Ela tall T Hert Cancel B Hep type BarChart in the Name field This name will appear in the thematic map list should you choose to edit it later on Result_Val field from the left panel gt button to move this field to the right panel gt Next to proceed to the next window 32 Chapter 2 Demonstration Exercise Field Color p Setting RESULT_VAL fa Height e Points Width jo Points Preview ok cce In this dialogue specify the bar chart color and the column dimensions A preview window in the lower right corner displays a preview of the true size and color of the thematic map as it will appear in the map manager type 20 for the height type 10 for the width OK to create the map The thematic map is an entity of the selected laye
16. 08 80 56 43 48 3295 305 GB29 50 56 43 48 3295 305 GB40 80 56 348 338 39 GB11 80 56 3 48 395 MOS 6842 80 55 43 48 325 93 326 93 GB43 80 55 43 48 324 85 32585 GB14 80 55 43 48 323 05 324 05 GB45 0 56 43 48 32426 325 26 GB46 80 56 43 48 326 56 327 56 GBAT 80 56 8 48 3283 293 GB18 80 56 4348 32 92 3392 GB19 50 56 43 48 330 13 3113 6820 80 56 43 48 330 76 29176 68 21 80 56 43 48 335 95 36 95 GB22 80 56 43 48 307 59 38 59 68 23 80 55 43 48 323 47 32447 GB24 80 55 43 48 325 26 32626 GB25 80 55 43 48 325 81 2681 08 26 80 56 3 48 26 12 32712 sja sla e lo S S os fos 9 8 e 8 8 12 8 t 8 Na HGA ToDo Notepad Print Report button from the toolbar X Close button to return to the main HydroGeo Analyst window This concludes the demonstration exercise for HydroGeo Analyst v 1 0 2 8 Contacting WHI Although the purpose of this exercise is to highlight some of the key features and analysis capabilities of HydroGeo Analyst it really only scratches the surface of the potential applications for this software package Continue to explore HydroGeo Analyst and discover for yourself how truly powerful it can be If you have specific questions regarding the features and analysis capabilities of HydroGeo Analyst please contact a Waterloo Hydrogeologic Sales Representative at Phone 1 519 746 1798 Fax 1
17. 1 ddTXRight BackColor C BackStyle 0 ddBKTransparen CanGrow True CanShrink False ClassName Normal DataField x Font Arial ForeColor height 223 hyperLink left 1930 SummaryDistine SummaryFunc 0 ddSFSum SummaryGroup SummaryRunnil 0 ddSRNone SummaryType 0 ddSMNone Tag text x top 0 Vertical lignme 1 ddTXMiddle Miribla Tere button to launch the following dialogue OutputFormat Properties xj DutputFormat Category Sample 12 345 0000 Decimal places E IV Use 1000 Separator Negative numbers 1 234 00 coa mp Set the dialogue to match the settings shown above i e set Category Number and Decimal Places 4 Repeat the above procedure for fldy Creating Data Summary Reports Now that you are done formatting your report click the Report Preview D button to move to the Preview window The report should appear similar to the image shown below l81x 6032 m1 JARA AA A i j ESE O A Ee SAO CHEO CENT A o a 7 Company Name Station List E Address Project Waterloo Investigation E Contact Info Location Waterloo ON Date January 1 2004 f Boreholes id name x y elevation toc 6801 80 55 43 48 3235 3245 68 02 80 55 43 48 326 27 68 03 80 55 43 48 326 307 68 04 50 56 43 48 322 23 CBS 80 56 43 48 324 25 68 06 80 56 3 48 3205 313 6807 80 56 43 48 333 334 68
18. 6 4814293 00 328 30 329 3 GB 18 535625 46 4814253 10 332 92 333 92 Data 68 19 535518 50 4814305 80 39013 331 13 68 20 pe 60 481430260 330 76 1331 76 68 21 5288 76 4814296 10 33595 336 95 Grids GB 22 535200 00 4814293 30 337 59 338 59 68 23 536219 27 4814620 30 323 47 324 47 68 24 536163 06 4814641 50 325 26 326 26 GB 25 536032 58 4814664 20 325 81 326 81 GB 26 535964 68 4814497 90 326 12 327 12 GB 27 535866 19 4814655 10 327 88 328 88 GB 28 535782 82 4814529 00 325 48 326 48 68 29 535592 63 4814501 80 334 29 1335 29 _ GB 30 535504 78 4814554 40 330 39 1331 39 GB 31 535364 36 4814634 30 328 78 329 78 68 32 535278 96 4814624 00 336 52 337 52 GB 33 535233 32 4814527 90 340 49 341 49 GB 34 536200 30 4814861 50 321 09 32209 GB 35 536129 32 4814985 30 322 86 323 86 GB 36 536002 20 4814870 50 325 39 326 39 GB 37 535993 10 4814773 80 326 62 327 62 GB 38 535887 19 4814948 60 327 26 328 26 68 39 535749 08 4814731 90 326 45 327 45 68 40 535596 06 4814791 50 333 93 334 33 Status GB 41 535476 43 4814760 20 327 40 3284 A 68 42 53535239 4814906 20 331 64 33264 zl Bar Shere done I i The HydroGeo Analyst Graphical User Interface is composed of several controls Data Tabs Menu Bar Toolbar Project Browser Well Profile Data Grids Status Bar Provides access to the various parts of the database including the Station List Data Query and Station Data Contains menu commands wit
19. 814253 10 332 92 al cc 595518 50 4814305 80 330 13 sl op 535394 60 481430260 330 76 TE Ror B2000 481423830 EE cta Stowe 536219 27 481462030 323 47 E 536163 06 4814641 50 325 26 ill Map 536092 58 4814664 20 325 81 Template 535964 68 4814497 90 326 12 3 Queries 535866 19 4814655 10 327 88 Template 53578282 4814529 00 325 48 etc 53550478 EME E el pacity 535364 36 4814634 30 328 78 wt 595278 96 4814624 00 336 52 i Cross Sections 535233 32 4814527 90 340 49 E Template 536200 30 4814861 50 321 03 fig reporto 596129 32 4814985 30 322 86 id Feport_0 1 536002 20 481487050 325 39 SE View 535993 10 481477380 326 62 E Template 535887 19 4814948 60 327 26 SHE Borat Logs 595749 08 4814731 90 326 45 J 535596 06 4814791 50 333 93 Template 535476 43 4814760 20 327 40 E 4 Station Groups 68 15 ID 38 Selecting a new Borehole in the Station List will load the respective well profile view Feel free to experiment with this option now Chapter 2 Demonstration Exercise Once you are finished the well profile view should be turned off before proceeding To hide the well profile view View Well Profile Next you will view the Monitoring Event data groundwater chemistry and water table elevations First you must select an appropriate station group Monitoring Wells from the Station Group node in the Project Tree W 01 the first station in the list Station Data tab to view the data for this station or simply dou
20. HydroGeo Analyst Demo Tutorial Guide Database Utilities Borehole logging reporting 2D Mapping and Cross Sections and 3D Visualization Project Layer Edit Tools View Select Settings Help Gea mex A 07 1x2 Tr S248 0G Rae dew Boreholes Screen Monitoring Wells o ve_exceeds_2ppb CrossSectionLine2 Test Site Map bmp lajx Edt View Settings Help uaaa GA RE ES veticalEsaggeration ff xd Stay on top Iv Defaut Settings Site maps Sufaces Cross Sections Data T saing N properties Visble Color Size X Label Y Label Z Label Sets the color of the avi label Live Update Apply Rotate model around the screen ares X up down Y left right Z rock side to side Copyright 2004 Waterloo Hydrogeologic Inc License Agreement Waterloo Hydrogeologic Inc retains the ownership of this copy of the software This copy is licensed to you for use under the fol lowing conditions I Copyright Notice This software is protected by both Canadian copyright law and international treaty provisions Therefore you must treat this soft ware JUST LIKE A BOOK with the following single exception Waterloo Hydrogeologic Inc authorizes you to make archive copies of the software for the sole purpose of backing up our software and protecting your investment from loss By saying JUST LIKE A BOOK
21. Time 0 0 0 30 This query should return 10 records that satisfy the specified conditions a Save Query button to save the query The Query Results may be sent to a data summary report or as a new map layer This will be demonstrated later in this exercise Close to return to the main HydroGeo Analyst window Upon returning to the HGA window you will see the Data Query will appear as a new node under the Queries node in the project browser Expand the Queries node in the project browser and locate this query There are several ways to recall this query Data Query tab at the top of the window Under the Query List select the new query TCE exceeds 5 mg_kg e Dl Execute Query button located at the bottom of the window This will execute the Query and display the Query results Alternately you may select the query node from the project tree and double click on the query or right mouse click on the query and select Execute Data Query Several queries have been created for you in the Demo Project Feel free to peruse them and see how they were constructed To view how a query was designed right click on the desired query and select Edit The names and organization of the queries should give you an idea of their purpose Querying the Database 29 In the next section you will experiment with Map projects 2 3 Plotting Stations on a Map Project 30 The HydroGeo Analyst s Map Manager provides a tool for mapp
22. ade secret or other proprietary information to be used in the soft ware and documentation shall be considered as included in the contract price V Governing Law This license agreement shall be construed interpreted and governed by the laws of the Province of Ontario Canada and the United States Any terms or conditions of this agreement found to be unenforceable illegal or contrary to public policy in any jurisdiction will be deleted but will not affect the remaining terms and conditions of the agreement VI Entire Agreement This agreement constitutes the entire agreement between you and Waterloo Hydrogeologic Inc Copyright 2004 Waterloo Hydrogeologic Inc Table of Contents 1 Introduction to HydroGeo Analyst 0 0 eee eee 1 Key Features in HydroGeo Analyst 1 0 0 0 cece eee eee eee 2 D ta ACQUISION tirate Ii Shue aoe oarsmen OM a eae 2 Data Manda MM A PERS a eee ia 3 Data Vistiali zation st the A A di dee els eters te 4 Reporting and Printing oi a ed ee e AE ad oe ee ee es 5 Interface to Visual MODFLOW and other WHI Software 0 0 0 2 6 Installing HydroGeo Analyst 0 0 cece eee nee 7 System Requirements codi A Ade T sta A A ES 7 Uninstalling HydroGeo AnalySt o oo ooooocoorccor cette een eae 8 Starting HydroGeo Analyst 0 2 cece teen eens 8 Learning HydroGeo Analyst nd gh av ae eak need hee ees 8 HydroGeo Analyst On Line Help 0 0 eee e eee 8 About
23. al data is inherently spatial as observations are taken at specific map coordinates over time In HydroGeo Analyst these sampling locations are referred to as Stations HydroGeo Analyst comes with standard easy to use data entry grids equipped with drop down combo boxes and many other features that facilitate data entry and validation for virtually any type of Station data Importing and Exporting Data The Data Transfer System DTS is designed to assist in the process of importing exporting data to from the database Using the DTS station data can be imported from 2 Chapter 1 Introduction to HydroGeo Analyst practically any source including delimited text files MS Excel MS Access Databases SQL Server Databases and others 1 1 2 Data Management HydroGeo Analyst supports virtually any database structure including those with multiple levels of relationships among two or more entities This provides an unparalleled flexibility for projects that may have variable needs For instance the project database structure may need to satisfy requirements by the United States Environmental Protection Agency USEPA or Ontario s Ministry of the Environment MOE For these and many other needs HydroGeo Analyst comes with a number of customizable templates implementing various commonly used database structures The database structure included with the demo project is Environmental These templates also include commonly used and customizab
24. ancel Help Select the cross sections to display from the dialogue by placing a check mark beside each cross section name Or to select all cross sections place a check mark beside Select All at the top of the dialog Select AA and CC Enter a name for the 3D project in the field in the lower right corner type Demo OK This will load the 3D Explorer window similar to the figure shown below 40 Chapter 2 Demonstration Exercise SX HydroGeo Analyst 3D Explorer Aschalew HGA_Projects HGA_Demo_Project Demo 3D demo f lajxj Vertical Exaggeration 1 File Edit View Settings Help jannaa Sle S Default Settings Ba Axis Site maps Surfaces Cross Sections Data Setting B ound Vertical Ex 1 0 Interpretation Geology Title GLegend Ala Rotate Shift Light Position xa yi IV Live Update Apply zid Rotate model around the screen axes X up down Y left right Z rock side to side The 3D Explorer window contains several controls which are not discussed in this exercise For more details refer to Chapter 10 HydroGeo Analyst 3D Explorer of the User s Manual You will see that the fence diagrams produce a new perspective on the site geology The site map from the demo map project is also displayed by default to help relate the cross section data to surficial features 2 5 1 Navigation Tools Locat
25. aunches the Template Manager List Editor button launches the List Editor Material Specifications button launches the Material Specifications Editor Query Builder button loads the Query Manager that allows building simple and advanced queries Well Profile Viewer button loads a window displaying the profile view of the selected station This includes data for Lithology and Well Construction drilling procedure filling materials screen and well casing materials Map Manager button loads the Map Manager by default the most recently used map project will be loaded View Cross Section button launches the Cross Section editor and displays the last edited cross section if any Import button launches the Data Transfer System TDS to import data Export button launches the Data Transfer System DTS to export data Chapter 1 Introduction to HydroGeo Analyst 1 4 4 Project Browser The project browser tree lists the following items Sa Station Groups A Project e Station Groups a Monitoring Wells E Mi Boreholes e Station Data Data categories af Sci Borings 1 M All Stations 3 Queries E Station Data Maps E Description Geologic Description e Cross Sections Well Construction 3 Soil Testing A Reports Soil Sampling ES Monitoring Event E Mining Exploration E Geophysics e 3D Views and e Borehole Logs E Well History 4 A ee i These items may be part of any project Each
26. be used for quantifying and qualifying any field in the HGA database and can be used to create a new map layer on a map project 2 2 1 Creating a Data Query In this example you will create and execute a Data Query to find exceedences of TCE Trichloroethylene in the Soil Samples To load the Query Builder Tools Query Builder from the main menu or click on the E Query button in the toolbar A prompt may appear to save the query Click NO to continue The Query Builder window will load as shown below 24 Chapter 2 Demonstration Exercise Diss Bade BEE Xe A C Station Group Query lg ae Select a Query E Description E Geologic Description Design SQL View Preview Display Fields Expression station id station x stationy E Well Construction E Soil Testing E Soil Sampling Es Monitoring Event E Mining Exploration station name name gt Y Map Read E Geophysics tX Te TMe naaa E Well History Conditions E User Category LC Expression Dperator Expression Source Condition Project hd m Advanced Close B Help Category User Time 00 00 00 gt Data Query radio button in the upper left corner of the window A prompt may appear to save the query Click NO to continue E New button in the toolbar and the following dialog will appear A prompt may appear to save the query Click NO to continue Name l Des
27. ble click on the station Monitoring Event from the Data Category combo box The data for this will appear as shown in the figure below HydroGeo Analyst Demo D Program Files HGAnalyst Projects Demo_Project BEES Project Edt View Record Settings Tools Help Bar DOF XAO BOBA ip E all Station Groups 2 a Station List 5 Data Quey Station Data a Project Data Category 9 Mara Wels Monitoring Event SelectStation Xim Yim Elev tionim TOC Imm wall Boreholes e w 01 535320 00 4814610 50 330 80 331 8 a Soil Borings a All Stations H E Station_Dat og Goes ne Name Screen from screen to sys_sample_code date tine chan_cu__ eolection comment o Eb m m Bf clay containing stations wal W Ol_1 2 1996 01 02 1996 1200 00 AM EA elevation exceeds 335 mas wo W 01_1 8 1996 01 08 1996 1200 00 AM BR poe exceeds 10 mg per kg and J E w 01 W 01_2 12 1996 02 12 1996 12 00 00 AM E tce exceeds 10 mg per kg Ewn W 01_4 16 1995 04 16 1996 1200 00 AM Ge oe exceeds 5000 ug per wo W 01_8 9 1996 08 09 1996 1200 00 AM El ve exceeds 1 mg per kg El Maps E Site Map S A Cross Sections Bl aa Chemisty Sample Chemistiy_Resuits Water Level oooool Ea Station Groups Template Sal Map 54 Queries Y Template MOE_Well Record fal tptMairwwR A Chart report ij Cross Sections Y Template fag report_O report_0_1 etd Dew E Template El Borehole Logs Template
28. clicking on the tab itself For more details on creating and editing queries please see Chapter 7 Query Builder of the User s Manual Station Data Tab This tab allows the user to enter and view the data for a single station This tab can be activated either by selecting a data category in the Station Data node in the Project Browser or by directly clicking on the tab itself The former will activate the selected data category and the related tables will be loaded for viewing and or editing Each table in the selected category will be displayed in a separate tab on this page Each of these tabs displays data from corresponding tables filtered for the Station selected at the top of the window To change the active station simply select a new station from the combo box above the grid About the Interface 11 Category Station selection selection HydroGeo Analyst Demo F Program Files HGAnalyst Projects Demo_Project iol xj Project Edit View Record Settings Tools Help aeag ARtXRA REGRHS BOS Seas lni Eai Station Groups M Station List LLE Data Query Station Cata MN Project wa Monitoring Wells M4 Boreholes a Soil Borings A All Stations Lithology Hydrogeology Modeling features l taining st Ll oy SOAS d d iptio E Consister Structure ASTM De E Station_Data sy Queries j Coarse Y 3 Maps El ine 34 Fine S Cross Sections 4 il Cay Hy j Sit Mw Diew 7 Sand Si il 3 Borehole Logs
29. cription DK Cancel El Help In the dialogue that appears enter a Name for the new query and a Description optional type TCE Exceeds 5 mg_kg OK NOTE Slashes are not supported in the SQL string therefore the underscore is used to denote per Querying the Database 25 In the tree on the left side of the window expand the Soil Sampling node then expand the Soil Chemistry node 2101 x iXaH A C Station Group Query Data Query Design SQL View Preview Display Fields Function Select a Query Tce exceeds 5 mg_ltr Geologic Description Well Construction Expression station id id station x x station y y station name name X name db amp Fv Map Ready sys_sample_code sample_date Conditions chemical_name result_value result_unit conc_ppm fractioncode interpreted_qualifiers reporting_detection_limit result_comment rdl_ppm sample_matrix_code sample_type_code y Source Conditio Project Expression Advanced Close E Help Category Descripti Time 00 00 00 Locate and click on the chemical_name field Drag this field into the blank Conditions frame under the Expression column The selected field will be added automatically to the Query Conditions soil_samples Soil Chemistry name sys_sample_code EME chemical_nam
30. ct an Expression for the field For this example select the appropriate soil chemistry units mg kg from the combo box In addition some fields must be also be added to the Display Fields The Name field has been added automatically however you can also add any relevant fields to display in the query results To do so Locate and click on the chemical_name field in the tree on the left side of the window Drag this field into the blank Display Fields grid in the upper part of the window Querying the Database 27 Select a Query TCE exceeds 5 mg_ltr y Display Fields Function Expression Geologic Description Well Construction Soil Testing Soil Sampling soil_samples E Soil Chemistry name sys_sample_code 0 4 F X station id station station y station name JV Map Ready Conditions Expression Dperator chemical_name A enil chemistn chemical Trichlarnethilane X Repeat this for the result_value and result_unit fields In the Display Fields you may specify aggregate function or sort options These options are not explored in this example Once the fields have been added the Query Manager display should be similar to the one shown in the figure below FE Query Builder BEE Ixe 3 Design i C Station Group Query Data Query ion SOL View Prev
31. cted size of the data e the number of anticipated users and e data and system security The SQL Server 2000 Desktop Engine commonly known as the Microsoft SQL Server Database Engine MSDE will be installed on your hard drive as part of the installation process and will be setup as the default database server The MSDE 2000 is a database engine built and based on core SQL Server technology Installing HydroGeo Analyst 7 1 2 3 Uninstalling HydroGeo Analyst There may be instances where you will need to uninstall remove HydroGeo Analyst from your system i e if the software is to be transferred to another computer or if you need to reinstall it on the current computer Before un installing the HydroGeo Analyst software package from your system we strongly recommend you to make backup copies of all your HydroGeo Analyst projects and databases These include your entire HGA project folder and all its contents If you are also uninstalling MSDE component make sure to also back up the SQL Server databases This file has the extension MDF and can be found in the MSDE installation folder e g C Program Files Microsoft SQL Server MSSQL WHI Data Name MDF To uninstall HydroGeo Analyst e Locate the Add Remove Programs option in your Windows Control Panel e Select HydroGeo Analyst as the program to be removed e Follow the on screen instructions e Once you are finished re boot your system to ensure all system files are updated
32. ditor where the image may be inserted into a report and printed or saved to PDF HTML RTF and other file formats In addition the Report Editor allows for customizing the header footer and logo The image will appear similar to the one shown below Chapter 2 Demonstration Exercise SaS Alal acaos 7100 x 1 2 030 v eSEE A Contents Print Report button from the toolbar X Close button to return to the Map Manager window In the next section you will view a pre defined cross section using the Cross Section editor 2 4 Viewing Geological Cross Sections The Cross Section editor tool included with the HydroGeo Analyst package can be used to view and interpret cross sections for your station data The Cross Section editor is able to display the following cross section interpretation types e Geologic containing lithology structure data e Hydrogeologic containing locations of aquifers aquitards etc e Model containing locations of model layer lines which may be used in numerical groundwater modeling To load the cross section editor from the map manager Viewing Geological Cross Sections 35 36 Cross Section tab in the upper right corner of the Map Manager window Next select a cross section from the tree on the left side beside AA Once a cross section has been loaded into the Cross Section Editor the window will appear simi
33. e e IV Map Ready Conditions Expression result_unit conc_ppm fractioncode interpreted_qualifiers Under the Conditions select an Operator for this field from the combo box Select an Expression for the field For this example locate TCE Trichloroethylene from the list 26 Chapter 2 Demonstration Exercise Trichloroethylene chemical_name 7 Expression result_value soil_chemistry chemid t result_unit cane nnm Operator ple O Trichloroethylene X sys_sample_code INES SES SSS SSS SSNS sample_date Conditions Next add two additional fields to the Query Conditions Locate and click on the result_value field Drag this field into the blank conditions field under the Expression column The selected field will be added automatically to the Query Conditions NOTE Operator AND is added by default You can change this operator by selecting a new one from the drop down menu For the Operator gt from the combo box Select an Expression for the field For this example enter the concentration criteria type 5 Finally repeat these steps for the result_unit field Locate and click on the result_unit field Drag this field into the blank conditions field under the Expression column The selected field will be added automatically to the Query Conditions For the Operator from the combo box Sele
34. e the field containing the Vertical Exaggeration at the top of the window and enter a new value type 4 lt Enter gt on your keyboard At the bottom of the 3D window there is a Navigation tools panel which is used to orient the 3D grid To rotate the 3D grid Rotate tab amp X slider bar Visualizing Cross Sections and Maps in 3D 41 Drag the X slider bar slowly to the left to see the resulting affect on the 3D grid Alternately you may use the AutoRotate feature The AutoRotate tools located on the right hand side of the Rotate tab may be used to continuously rotate the model image around the X Y and or Z axis gt Z under the AutoRotate options ii Rotate Shift Light Position Me o ul ee y vil Z ul D Eras 2 m gt Options Rotate model around the screen axes X up down Y left right Z rock side to side e B Play button to start the rotation Observe the rotation for a few seconds then Bl Stop button to stop the rotation You can also record the Autorotate as an AVI file To do so a Record button This will load the following dialog Video settings E ax Settings Custom frame size AVI File name Wa4schalewsHGA_ProjectsiDemo_Y Frame size Full window size y Width gt Compression T Full Frames Uncompressed Height 24 By default the AVI file will be saved to the folder in which the project is located You can chan
35. each interpretation type Also note some of the other convenient features of the Cross Section editor The Map Preview window shows the location of the cross section line and the stations involved in the cross section The Map Preview window is linked directly to the displayed cross section Place your mouse cursor over the Map Preview window and place it on top of one of the stations selected for this cross section This causes the selected station to temporarily flash in the cross section window This helps you to relate the stations in a planar view to what you are seeing in the cross section 2D view Conversely you may relate stations in the cross section view to what is displayed in the map preview window Place your mouse cursor over a single station in the cross section window then look at the Map Preview window You will see the selected station will flash temporarily in the map preview window This helps you to relate the stations in the cross section view to their physical XY location on the map view To confirm the lithology for an individual station use the information button in the toolbar View Information from the main menu or select the O button from the toolbar Move the mouse cursor over a station and move through the depth of the borehole This will display a text box containing the soil description and interval information for the station Intersecting Layers When viewing an individual cross section
36. eatures as described below Contents The Contents tab displays the headings in the Table of Contents in the form of an expandable collapsible tree view Closed book icons represent Table of Contents headings that have subheadings Index The Index tab displays all Help topics You can scroll to find the index entry you want or you can type in the first few letters of the keyword in the text box and the index will scroll automatically as you type Double click an index entry to display the corresponding Help topic Alternatively you may select an index entry and then click the Display button to open the Help topic Search The Search tab is used to search the On Line Help documents for a word or phrase of interest Simply type the search word s or phrase s then press lt Enter gt or click the Display button Favorites You can add frequently accessed Help topics to a personal list of favorites which is displayed on the Favorites tab Once you have added a topic to your list of favorites you can access the topic by double clicking it Click Add to add the currently displayed topic to your favorites list Select a favorite and then click Remove to delete a topic from your favorites list 1 4 About the Interface When HydroGeo Analyst is first loaded a blank window will appear indicating no project is loaded To create a new project select Project New to open an existing project select Project Open A sample dataset is
37. emo project To expand the entire tree View Expand All from the main menu bar OK in the message box that appears Take a moment to inspect the items under each node in the Project Browser In the next section you will learn about Station Groups 2 1 1 Station Groups In HydroGeo Analyst stations can be sorted into groups allowing for efficient management and quick retrieval of data stored in the database All station groups created for a project are listed in the Project Browser under the Station Group node Clicking on any of the sub nodes corresponding to a station group will load the Station List tab and display the appropriate stations belonging to that group In the demo database there are several station groups e Project the complete list of stations e Boreholes contains only those stations which are boreholes e Monitoring Wells contains only those stations which are monitoring wells e Soil Borings contains only those stations which are soil borings Viewing the Demo Project 19 To see the stations which belong to the Monitoring Wells station group select this node from the project tree Monitoring Wells under the Station Groups node in the project tree When a station group is selected the stations belonging to that group will appear in the Station List tab Once the stations in a group are displayed a number of operations can be applied based on the selection For example loading a station group and the
38. enu circled above GB 03 The display is updated to reflect the Lithology Well Construction and Scale of the selected station The BHLP templates created in the Demo Project each contain a different number and or order of data columns Feel free to peruse the other BHLPs Once the desired view has been loaded the BHLP may be loaded into the Report Editor for printing It is possible to create one report for each station in the group or only one report for the selected station To print a report for the selected BHLP only Right click on the station name at the top of the window From the menu that appears Print current borehole Select any print template from the list OK Creating Borehole Log Reports 45 Report YE suo ce ce ce TEL E Aa EA aa lt r Borehole ID 10062 Description 25 Drilling Date Hs eS Print Report button from the report toolbar X Close button to return to the BHLP window Close button to return to the main HGA window In the next section you will learn how to prepare data summary reports 2 7 Creating Data Summary Reports 46 Using the HydroGeo Analyst Report Tool you can create a professional style report of any types of data in your project A few samples are provided in the Demo project however all reports start with a template The templates are provided under each node of the Reports node and are provided automatically when you ch
39. eo Analyst 1 0 Demo or double click on the desktop icon Ga When HydroGeo Analyst starts it displays the main window To open the demo project Project Open An Open Database dialogue will appear prompting you to select a HydroGeo Analyst project to open Browse to the folder C Program Files HGAnalyst Projects Demo_Project If you have installed HydroGeo Analyst in another folder please browse to the appropriate folder now and locate this file Project VBH located in this folder Open A prompt will appear for the password for the project HydroGeo Analyst uses password protection for projects to support multiple user levels If a password is entered the user will have Project Manager status and full control over the project Enter the following password for this project type password OK Chapter 2 Demonstration Exercise The Demo project should then be loaded into HydroGeo Analyst as shown in the following window 2f HydroGeo Analyst Demo Aschalew HGA_Projects HGA_Demo_Project Demo Project Edit View Record Settings Tools Help BeF SAR tXBa PBRHH B0S 2 Dae aio ani Station Groups ad Station List EZ Data Query Station Data H E Station_Data ESE Queries a a Maps Cross Sections Ef Reports e 3DView fl Borehole Logs Station Name Project Demo 1 The Project Browser tree can be easily expanded to see all the nodes and entities of the D
40. ge the file destination by browsing to the desired location You can also set the speed of the video by changing the value in the Frames per second field The larger the value the faster the video will play This has no effect on the recording time Feel free to record a video file now by pressing OK When you are finished after about 30 seconds Bl Stop button NOTE The recorded AVI files may get very large depending on the length of the video 42 Chapter 2 Demonstration Exercise To play back the file browse to the folder on your hard drive locate the AVI file and load it into a supported media player You can shift or zoom in out of the 3D grid using the shift options Shift tab Z slider bar Drag the slider bar to the left to zoom out or to the right to zoom in Individual cross sections and interpretation types may be shown or hidden from the 3D display using the project tree on the left side of the 3D Explorer window However these capabilities are not explored in this demo exercise Once the desired view has been loaded the 3D image may be loaded into the Report Editor for printing To do so e File Print from the main menu or click the Le Print button from the toolbar Select any print template from the list OK The 3D window will load into the Report Editor where the image may be inserted into a report and printed or saved to PDF HTML RTF and other file formats In addition
41. h access to most features that are available in the HydroGeo Analyst package Contains several context sensitive short cut buttons for the most frequently used HydroGeo Analyst features Hosts a tree view listing some of the most common components of your project These include nodes for Station Groups Queries Maps Cross Sections Reports 3D Views Station Data and Borehole Log Plots Provides a borehole log plot for the selected station Contains the grids for data entry and visualization Displays the program status The following sections describe each of these components in greater detail Chapter 1 Introduction to HydroGeo Analyst 1 4 1 Data Tabs To facilitate data management the main interface is separated into three tabs described below Stations List Tab This tab hosts a grid displaying a list of stations for the selected station group Only a few selected columns are displayed in this tab namely Station Name X and Y coordinate Elevation and TOC Top of Casing elevation The purpose of this list is to provide an overview of multiple stations and to perform general operations based on one or more selected stations For a more detailed view of an individual station the Station Data tab should be utilized Data Query Tab This tab displays results from an execution of any selected data query This tab can be activated by double clicking on any query under the Queries node on the Project Browser or by directly
42. iew Select a Query Display Fields TCE Exceeds 5 mg_ka Function Expression pies Order by 7 tation x x EX Soil Sampling soil_samples station y alas station name name E Soil Chemistry soil_chemistry chemical_name i chemical_name name soil_chemistry result_value result_value sys_sample_code gt soil_chemistry result_urit result_unit Ss sample_date chemical_name nm Y Map Ready result_value tX ai Conditions one PPM Expression Operator Expression fractioncode a Ji interpreted_qualifiers reporting_detection_limit soil_chemistry chemical_name soil_chemistry result_value gt soil_chemistry result_unit Trichloroethylene 5 mg Kg result_comment rdl ppm sample_matrix_code sample_type_code sampling_teason from to xl Source Conditio Station Groups Soil Borings Field Name soil_ct Time 0 0 0 40 5 Generate SQL Statement button from the toolbar to Generate the SQL string If the Query string is invalid the violating rows will be highlighted red indicating error or yellow indicating warning Finally to execute the Data Query E Execute SQL Statement button from the toolbar 28 Chapter 2 Demonstration Exercise The results of the query should appear as shown in the figure below FE Query Builder lolx kha ee Staion Group Quey Data uey Desin SOLView Preview Select a Query SELECT tid AS id
43. ing station data on basemaps in addition to thematic and contour maps Basemaps may be in AutoCAD Shape file or Georeferenced Raster Image formats BMP JPG GIF PNG TIF etc The Map Manager tool is also used to digitize the locations for cross section lines In this example you will load an existing map project then plot the TCE exceedences which were determined using a Data Query in the previous section First before proceeding ensure that you are viewing the main window of HydroGeo Analyst Then to load the Map Manager Maps to expand this node of the project tree ee Site Map Once the Map Manager window is loaded the display should be similar to the one shown below Active Window Menu Bar Project Layer Edit Tools View Select Settings Help Toolbar tecali cues Alos xi slo ageo h 5455 90 ean PENA r Al Stations wm iossSectionLines L p Boreholes al ayer Du pa Manager r rose He Water Courses He Contour Lines pmo Arale E He Major Railroads Map P Window a mw Giasslands y Coplands Layer Information su Layer PIE os I fe Datum D WGS 1984 yee nformation Ub INAD 1983 UTM Zone 17N 535 093 4 813 709 1 10 359 Current projection 4 System X Y Co ordinates Scal Chapter 2 Demonstration Exercise The Map Manager window contains the following elements e Menu Bar Contain
44. ion from Waterloo Hydrogeologic Inc It is the most comprehensive and yet easy to use environmental data management system providing data validation analysis and visualization The HydroGeo Analyst package integrates a list of flexible and customizable database structures used around the world complimented by state of the art tools for data interpretation statistical analysis GIS mapping data charting and two and three dimensional visualizations For most environment related projects whether they are contaminated sites or municipal water supply projects there is often an abundance of data that has been collected over the years How many times have you had to sift through several paper reports for that one piece of information when compiling monthly summaries on a project Can you be sure that you have not misplaced a report or failed to mention an important piece of data The HydroGeo Analyst package addresses these and many other needs in the industry The system enables you to create a project specific database or enhance and build upon your existing database HydroGeo Analyst can take all of those previous data and reports and consolidate them into a powerful relational database system that can be queried and referenced with ease HydroGeo Analyst HGA operates as a desktop application based on Microsoft SQL Server technology The package supports multi user levels for controlled data management with structured access privileges for
45. lar to the figure shown below Menu Bar EE Toolbar p e ss des me te Ala amp Nix ARE PE BB a a AA E MU Model Layer Control as Gravel Fine Sand Silt 2 E O O HydroGeology E Cross Section su ali Window a Map Preview 400 500 Distance m X Z Co ordinates The Cross Section Editor window contains the following items e Menu Bar Contains program menu commands e Toolbar Contains short cut buttons to some of the functions in the Cross Section editor e Layer Control Modify layer order make layers visible active and modify layer properties e Cross Section Window Contains the cross section view for the selected cross section line e Map Preview Displays the selected cross section line as it appears in the map project The selected stations for the cross section are highlighted in this Map preview window Chapter 2 Demonstration Exercise e Coordinates Displays the X Z co ordinate for the current mouse cursor location e Active Window Select between the Map Manager window or the Cross Section window In the Demo Map project the cross sections have already been defined for you However it is simple task to define new cross section interpretations using the polygon and line drawing tools that are included with the Cross Section Editor In the layer control you can see the aforementioned interpretation types Model Geologic and Hydrogeologic From here you can show hide
46. le data queries and report templates that will be installed with the desired database structure Template Manager Database Schema Designer If your database needs cannot be satisfied through one of the database templates that are provided with the system you may use the Template Designer to create and customize your own database structure The Template Database Schema Designer is provided to handle such tasks as creating editing and importing database schemas for your project databases It provides a set of categories that allows organizing your database tables Existing Database structures can also be imported using the Template Designer Customizable Lists and Standards HydroGeo Analyst comes with a List Editor tool that affords users the ability to create and customize lists for any field allowing for rapid data entry Common examples of lists include e List of over 150 standard Soil Classifications with descriptions and patterns e List of common chemical names with their CAS Registry numbers e Lab analysis test methods e Well drilling methods construction and casing materials e County and State Codes e Applicable standards for various purposes regions and agencies A List in HydroGeo Analyst is equivalent to either a physical or virtual look up table Data Querying and Filtering with the Query Builder Data querying is an important feature for any environmental database It provides the ability to easily locate de
47. minimum system configuration is necessary Pentium II 300 MHz or equivalent e 128 MB of RAM 256 MB recommended e A CD ROM drive for software installation e 100 MB free disk space e Windows 2000 XP NT 4 0 Service Pack 4 0 or later e A local or network printer installation e A Microsoft compatible mouse A minimum screen resolution of 1024 X 768 e A SQL Server connection or installation of WHI MSDE instance included e MSAccess e MSExcel e Internet connection recommended If you have any problems with your particular system configuration please make sure that you followed the installation instructions precisely If the problem is still unresolved contact your hardware experts Finally if you are still having trouble see the section in Preface on How to Contact Waterloo Hydrogeologic 1 2 2 Installation HydroGeo Analyst must be installed on your hard disk before you can start to use the software Please read the section on hardware requirements at the beginning of this section to ensure that your system meets the requirements before you start installing the software The Setup32 EXE executable file is used to install HydroGeo Analyst on computers running on Windows 2000 XP NT 4 0 operating systems Although the HydroGeo Analyst Software needs to be installed on local hard drives this may not necessarily be the case for the databases to be managed by the software The location of the database will depend on e the expe
48. n selecting the Display on Map option from the Record menu activates the Map Manager component and automatically creates a GIS layer containing all stations from this group The mapping feature will be demonstrated later in this tutorial 2 1 2 Viewing Station Data In this section you will see how data is organized in the HydroGeo Analyst database First load the Boreholes Station Group Boreholes under the Station Groups node in the Project Browser GB 20 The Station List tab provides only the station coordinates elevation and TOC Top of Casing elevation if provided To see the additional data belonging to this station GB 20 double click on this station or click on the Station Data tab from the top of the window HydroGeo Analyst Demo Aschalew HGA_Projects HGA_Demo_Project Demo E loj xj Project Edit View Record Settings Tools Help A Ade ee i Eg Station Groups A Station List Data Query Station Data wa Project Data Category eo We II Tesori gt Select Staion Xi fm Elevation TOC In 19 Boreholes Ms GB 20 535394 60 481430260 330 76 331 76 M Soil Borings TO IT afi Al Stations Location description_addins H E Station_Dat S n Name Value Da Station Name GB 20 x 535394 60 Ei clay containin JY 4814302 60 elevation exce 5 gwelevation E poe exceeds i toe exceeds 1 J toe exceeds E tvoc exceeds ve exceeds 1 a vase E Site Ma
49. n Data fiptic _ soil_type Patten Consister Structure ASTM De Color se Grav Coarse Gravel y Geophysics sand Fine Sand y Well History clay Silt Be TENEN E EN TE to Fine Sand ES 79 67 100 Boulder Clay Boulder Clay a This will load the Well Construction data for the selected station GB 20 In this table you will see four tabs e Drilling Protocol contains drilling information e Casing contains info on well casing materials diameter etc e Screen contains screen interval details e Annular Fill contains info on annular fill gravel packs sand packs etc Annular Fill tab to see the records entered in this table You will see the interval and filling materials entered for this borehole From this window you may also view data for another station There is a picklist of stations under the Select Station label at the top of the window GB 15 Viewing the Demo Project 21 22 M Station List El Data Que El Station Data iz Category Select Station X m Y m Elevation m TOC m GB 20 1 1535394 60 4814302 60 330 76 331 76 GB 01 Diiling Protocol Casing Screen 68 02 Casing Screen 68 02 from to diamd GB 04 Pim sm m__ GB 05 10 100 0 304 GB 06 GB 07 GB 08 GB 09 GB 10 GB 11 GB 12 GB 13 GB 14 5 well Construction Ba GB 16 GB 17 GB 18 GB 19 GB 20 This will load the Well Construction data
50. oose Project Report or Project Print or File Print from each corresponding module of HydroGeo Analyst ee ee ce Expand the Station Groups node Boreholes group Project Report from the main menu Stations as a template Chapter 2 Demonstration Exercise To print the report as it is Print Report button from the toolbar The HydroGeo Analyst reports are fully customizable You may modify the title header footer company info company logo etc For this exercise you will change some minor features in the report Company Name Station List E Address Project Waterloo Investigation E Contact Info Location Waterloo ON Date January 1 2004 i New Report 3 id name x y elevation toc po 24 6801 30 maar 143 47831 ti 3235 3245 E 25 6802 80 ira 143 acid 326 27 268 03 30 STZ PERAE 326 37 E aloso _ s0 55543240052 43 4782333321 E 322 323 3 2516805 9055872814372 9 470598595035 224 25 29 08 06 80 55802578257 43 478693601 302 305 319 3 D CBO7 80 5591 sam par 333 34 i afosa A f3 478435148354 mas 3005 E osos 20 saa las 470520537068 295 305 i aloso _ 80 58358777857 8 478354715453 Ec E h A 6B41 80 56434869495 43 478087563755 395 MOS S cs ona2 __ 90 55204805069
51. p EMI Cross Sections Bl sa aj es alj cc aj op EE Reports Eg Station Group B E Template fad statior Fab list report_ Map et 4 Soil Borings 68 20 1D 43 tag Elevation 330 76 TOC 331 76 total depth station type 1 depth to bedrock 20 Chapter 2 Demonstration Exercise The Station Data tab provides access to all data related to a single station There are several Data Categories available which are available in the Data Category combo box in the upper left corner Geologic Description from the Data Category combo box This will load the Geologic Description data for the selected station GB 20 In this table you will see soil sampling intervals from to soil descriptions soil classification names and soil patterns Soil classifications may be selected from a picklist This data will be used to create Borehole log reports and Geological cross sections These features will be demonstrated later in this exercise Next you will view the Well Construction data for the selected borehole Well Construction from the Data Category combo box as shown below Station List GX Data Query E Data Category Geologic Description Select Station X m LY m Elevation m TOC m 9 a GB 20 535394 60 4814302 60 330 76 331 76 Description Geologic Description x se 7 a 7 well Construction Soil Testing Soil Sampling Monitoring Event Mining E xploration Statio
52. r when this layer is hidden so too will the corresponding thematic map An example of a Map Project with a Bar Chart is shown below 3 Map Project Demo y Project Layer Edit Tools View Select Settings Help Demali zme AO xl ae as F o gt o mo kg All Stations a CrossSectionLineS Boreholes AirPhoto_BW_gr bm p AirPhoto_Color_ar b mp Water Courses Contour Lines Seow et ta Airports 1 Major Railroads Urban Areas aaa Trees Grasslands a Cronlands Layer Information las Station Layer Coord GCS WGS 1984 Datum D WGS 1984 Unit Degree Feature Counts 10 To visualize only this bar chart it may be helpful to hide the non essential layers by selecting View Turn off all layers Having done so turn on one of the air photos to Plotting Stations on a Map Project 33 provide a map background and the TCE exceeds 5 mg_kg layer by clicking on the check boxes beside them In the next section the options for saving and printing will be presented 2 3 3 Saving and Printing 34 Once you are satisfied with the map view there are several options to exporting the display e Save the image as a graphics file e Print the image directly as is e Insert the image into a report If you wish you may print this map view now To do so Project Print from the main menu Select any print template from the list OK The map window will load into the Report E
53. r similar claims III Disclaimer Except as specifically provided above neither the developer s of this software nor any person or organization acting on behalf of him them makes any warranty express or implied with respect to this software In no event will Waterloo Hydrogeologic Inc assume any liabilities with respect to the use or misuse of this software or the interpretation or misinterpretation of any results obtained from this software or for direct indirect special incidental or consequential damages resulting from the use of this soft ware Specifically Waterloo Hydrogeologic Inc is not responsible for any costs including but not limited to those incurred as a result of lost profits or revenue loss of use of the computer program loss of data the costs of recovering such programs or data the cost of any substitute program claims by third parties or for other similar costs In no case shall Waterloo Hydrogeologic Inc s liabil ity exceed the amount of the license fee IV Infringement Protection Waterloo Hydrogeologic Inc is the sole owner of this software Waterloo Hydrogeologic Inc warrants that neither the software and documentation nor any component including elements provided by others and incorporated into the software and documenta tion infringes upon or violates any patent trademark copyright trade secret or other proprietary right Royalties or other charges for any patent trademark copyright tr
54. s program menu commands e Toolbar Contains short cut buttons to some of the functions in the Map manager e Layer Manager Modify layer order set layers visible active and modify layer properties e Map Window Contains the layers for the map project e Layer Information Displays the projection system for the selected layer e Coordinates Displays the X Y co ordinate for the current mouse cursor location e Scale Displays scale for the map window e Active Window Select between the Map window or the Cross Section window The Demo Map Project contains several layers as indicated in the Layer Manager on the left side of the window There are two air photos of the site which is a helpful visual aid to relate station locations to land features In this map project some Station Groups have been loaded as a new map layer each represented by a unique symbol In the next section of this exercise you will load the data query as a new map layer 2 3 1 Creating a New Map Layer with a Data Query You will now load the TCE data query as a new map layer To do so Layer Load HGA Data Data Query radio button in the dialog that appears TCE exceeds 5 mg per_kg from the list of data queries you will need to scroll down to the bottom of the list Load HGA Data xi C Station Group Station y Data Query OK Cancel E Help OK Plotting Stations on a Map Project 31 This will display the query results on
55. setting up project data structures checking out data to working sub projects and submitting new or modified data HydroGeo Analyst Sample Applications The following are some sample applications for HydroGeo Analyst e Regional water well management e Contaminant site inventory e Regulatory compliance e Geologic cross sections e Public access to information e Environmental site assessment e Monitored natural attenuation e Regional aquifer characterization and management e Cross boundary data sharing e Aquifer vulnerability mapping 1 1 Key Features in HydroGeo Analyst 1 0 HydroGeo Analyst is implemented through a number of modules each performing a specific task This approach allows HydroGeo Analyst to be memory efficient flexible and extendible In addition with most of its data and settings implemented in the Extensible Markup Language XML there are unparalleled and unlimited possibilities to develop third party components to work with the software Some of the modules that come with HydroGeo Analyst include e Data Transfer System e Template Database Schema Designer and Manager e Query Builder e GIS Map Manager e Cross Section Editor e Borehole Log Plotter e Report Designer and e 3D Visualization A brief description for each of the above modules is provided in the following sections while a more detailed discussion is presented in later chapters 1 1 1 Data Acquisition Data Entry Most environment
56. sired information with only a few mouse clicks Key Features in HydroGeo Analyst 1 0 3 HydroGeo Analyst provides multiple levels of querying data out of your database through the Query Builder The Query Builder combines a set of tools for creating a range of simple to the most advanced queries for your projects All queries created can be saved for later use used to define Station Groups or used to filter data for reporting plotting charts and creating GIS maps 1 1 3 Data Visualization Interpretation of geologic and hydrogeologic data is made easy with the visualization modules that are provided in HydroGeo Analyst Using these tools raw data can be transformed into meaningful spatial data sets HydroGeo Analyst offers a collection of standard and custom modules for interpreting vast amounts of spatial data Some of these modules are briefly described in the following sections Map Manager The Map Manager built on ESRI s MapObjects technology provides a spatial view of any set of selected data Basemaps of the site can be quickly imported allowing for meaningful interpretation of borehole and well data The Map Manager is designed in such a way that most files required for a desired map view are generated automatically The true power of GIS is harnessed when it is used for spatial analysis of multiple data sets These spatial data sets can be combined to provide e Groundwater recharge flux maps e Aquifer yield capacity e Aq
57. t Designer HydroGeo Analyst features a state of the art report generation tool that is equipped with a robust and easy to use runtime designer A Report Wizard provides steps to simplify the report creation process the results are high quality and professional reports containing company headers footers and company logos Reports can contain images and data from any of the other modules Map views cross section views 3D views data grids query results charts etc The final reports can be printed or saved in a number of formats including PDF HTML RTF XLS TIF or TXT as well as in a binary format Key Features in HydroGeo Analyst 1 0 5 Report Templates The Report Designer includes several pre defined Report Templates providing professional results quickly and seamlessly Borehole Log Plotting Borehole log reports can be prepared utilizing the Report Designer A report for multiple boreholes can be generated at once by selecting one or more boreholes in the database and calling the borehole log report generator Borehole log reports may display information such as depth lithology water level screen locations sample results both as values and in charts geophysical data and more Chart Generator HydroGeo Analyst comes with a powerful and easy to use charting interface that is closely linked to the reporting component Unlimited number of charts can be placed on the reporting component s runtime designer The charting con
58. tO x as x t0 y as y tO name as name t1 chemical_name as chemical_name tT result_value AS result_value t result_unit as result_unit FROM Station as tO RIGHT JOIN SStation ON TCE Exceeds 5 mg_kg 2 10 10 Station SID LEFT JOIN soil_chemiStry AS t1 ON tQ id t1 Station WHERE t1 chemical_name TrichiORoethylene AND t1 tesult_value gt 5 AND t1 result_unit mg Kg AND SStation ID 3 5 Soil Sampling a E soil_samples E Soil Chemistry name sys_sample_code sample_date Tid AAA name chemical name result_value result unit a chemical_name b 76 281085094 380680098 SB 09 Trichloroethylene 13 mg Kg result_value El 112 238859659 615763099 SB 45 Trichloroethylene 7 23 mg Kg resuk urd 83 370494521 166910136 SB 16 Trichloroethylene 22 mg Kg pocas 81 1393385647 784886927 SB 14 Trichloroethylene 6 2 mg Kg 91268011122 988725648 SB 24 Trichloroethylene 90 mg Kg fractioncode 134 757480603 559704592 SB 67 Trichloroethylene 12 22 mg Kg interpreted_qualifiers 134 757480603 559704592 SB 67 Trichloroethylene 7 6 mg Kg reporting_detection_limit 134 757480603 559704592 SB 67 Trichloroethylene 3 07 mg Kg result_comment 142 803626106 180361487 58 75 Trichloroethylene 9 7 mg Kg rdl_ppm 128 1782687992 1265180196 SB 61 Trichloroethylene 15 05 mg Kg sample_matrix_code sample_type_code sampling_teason from to x Source Condition Station Groups y Soil Borings z Rows 10
59. the Interfaces 44 04 2 5 0 saves Sta hae rine Bue di 9 Data Tab atta ata nin vie al anes Pens nee atthe anak St E Sata cs 11 Main Menu Bar eisni IIS SG SG A A OL es et 12 TOA cess eRe sty res Ni or AES SEN Mets nea e 8 ANSE rn a es A eat hes 12 Project BROWSER reprene o Ai AS be 15 2 DEMONS tra tion EXETCISS atedacu glee A Nat teas 17 Viewing the Demo Project s messis esnan se aw as e 18 Station Groups 300 ES Ate toot on eel a tue en etn ee se eat lets 19 Viewing Station Data cta es a ENE ak Mee aes One Rete cee hk ee ees 20 Ouetying the Database ola ad a ba da os ps Tue al het peo ke dd 24 Creatina Data Query tii ti 24 Plotting Stations on a Map Project oooooooocooccococoro eee 30 Creating a New Map Layer with a Data Query 0 0 eee eee 31 Creating a Thematic Map o 32 Saving and Printing soe cose eae Sea Ee oe gee Se rede es HE Seen EN e 34 Viewing Geological Cross Sections 0 cece eee eee eee neces 35 Visualizing Cross Sections and Maps in 3D 0 eee eee eee 39 Navig OM Fools pia iS AE A e Ae arene 41 Creating Borehole Log Reports 0 0 0 0 eee 44 Creating Data Summary Reports vos sshd bed poda a 46 Contacune Weir rs Da Nk RS aah o e A 50 Copyright 2004 Waterloo Hydrogeologic Inc Copyright 2004 Waterloo Hydrogeologic Inc Introduction to HydroGeo Analyst Thank you for evaluating the demo version of HydroGeo Analyst v 1 0 HydroGeo Analyst is the newest software solut
60. trol can then be linked to specific parts of the database to retrieve the source data HydroGeo Analyst generates an unlimited number of pages with one or more charts with a single click of the mouse The charting module allows charts to include regulatory limits As such it allows users to define a range of values referred to as the Alarm Zone that may be used to indicate a range of values in exceedance of selected regulatory limits or intervals 1 1 5 Interface to Visual MODFLOW and other WHI Software ESRI GIS SHP files and databases have become two of the main sources of data for groundwater models and HydroGeo Analyst makes it easier to incorporate these data formats directly into your model HydroGeo Analyst allows you to export pumping well and observation well data directly to your model by mapping the data required by the model to the fields stored in the GIS shape files or the database In addition HydroGeo Analyst through the use of the cross section editor enables you to create and export layers resulting from 3D Model interpretations of your geological data in the database Also you can use the Data Transfer System DTS to export station data and chemical analyses then import it into AquaChem for water quality analysis geochemical plotting and modeling with PHREEQC 6 Chapter 1 Introduction to HydroGeo Analyst 1 2 Installing HydroGeo Analyst 1 2 1 System Requirements To run HydroGeo Analyst the following
61. ts Limitations of Demo Version The Demo version of HydroGeo Analyst HGA is designed to provide a brief overview of the capabilities of the software As such you may only open and view the demo database provided with the installation Also the following limitations exist NOTE Cannot create new projects Cannot create or delete records Cannot save post records Cannot edit cross sections Cannot add annotation layers Cannot save map projects Demo watermark appears on all reports maps cross sections and 3D projects If you have purchased a full license and are running the Demo project to familiarize yourself with the interface the above limitations do not apply to you 17 Terms and Notation The following terms and notations will be used in this exercise type Type in the given word or value E Click the left mouse button where indicated eE Double click the left mouse button where indicated lt Tab gt Press the Tab key on your keyboard lt Enter gt Press the Enter key on your keyboard The bold faced type indicates menu or window items to click or values to type The Main Menu items are the items available at the top of the HydroGeo Analyst Parent window 2 1 Viewing the Demo Project 18 In this first section of the tutorial you will start HydroGeo Analyst open the Demo project and become familiar with the program layout To start HydroGeo Analyst Start and choose Programs WHI Software HydroG
62. uifer vulnerability e Contamination risk assessment e Geologic cross sections e Completion diagrams Contour Mapping In addition to creating and displaying selected data on the Map the Map Manager also allows you to create contour maps and other thematic maps for any selected data from your database For example you can create and run a query that returns the maximum concentration of a given chemical over a certain period of time and transfer the result to the Map Manager Once the map with this data is created you can create and view contour maps depicting the distribution of the selected chemical concentration over the site area Thematic Mapping Additionally a Thematic Map of any type of data may be created and displayed on the map view Thematic maps include Pie and Bar charts with options to customize their appearance and style 4 Chapter 1 Introduction to HydroGeo Analyst Geologic Cross Sections with the Cross Section Editor Most geologic and or hydrogeologic site investigations often require a detailed analysis of the available lithological data A crucial effort in such investigations involves the drafting of cross sections The Cross Section editor can be used to achieve these tasks The Cross Section editor provides a set of easy to use tools to interpret subsurface data Geological and hydrogeological interpretations as well as interpretations geared towards creating model layers can be created using the cross section
63. ut See Chapter 11 The Report Editor of the User s Manual for more details 3D Views The 3D Views node contains a list of available 3D views that have been created and saved for your project Double clicking on a 3D view loads the selected view into the HydroGeo Analyst 3D Explorer Borehole Logs The Borehole Logs node contains a list of all Borehole Log Plot BHLP Templates that have been created and saved for your project Double clicking on a Borehole Log loads the selected template into the BHLP viewer The station group that is currently active will be available to be viewed in BHLP 16 Chapter 1 Introduction to HydroGeo Analyst Demonstration Exercise Before you begin this chapter ensure that you have read through Chapter 1 Introduction to HydroGeo Analyst of this Demo Tutorial Chapter 1 is designed to provide a cursory overview of HydroGeo Analyst s major modules and their functions This chapter contains a step by step review of some of HydroGeo Analyst s key features and analysis capabilities This exercise will give you some practical experience using HydroGeo Analyst and familiarize you with the HydroGeo Analyst demo project In this exercise you will become familiar with the following functions Viewing the Demo Project Querying the Database Plotting Stations on a Map Project Viewing Geological Cross Sections Visualizing Cross Sections and Maps in 3D Creating Borehole Log Reports Creating Data Summary Repor
64. you can also see the intersection locations of other cross sections or other layers such as contour lines and highways as defined in the map project To do so BEFORE you create a new cross section line in the Map Manager Select Settings Cross Section The following dialogue will appear Viewing Geological Cross Sections 37 Intersections With Cross Section Lines E x Field Font I CrossSectionLineS name Sample V0 Water Courses OBJECTID Sample FF YO Contour Lines OBJECTID Sample I VO Major Railroads OBJECTID Sample j o o o ojojojo OK Cancel E Help Click on the symbol in each layer to customize the display Pattem Font Symbol Fill Bode MM Sample OK to close the dialog Cross Section tab in the Map window to return to the Cross Section editor Saving and Printing Once you are satisfied with the cross section view there are several avenues you can follow e Save the image as a graphics file e Print the image directly as is e Insert the image into a report e View the cross section and other cross sections in 3D If you wish you may print this cross section now To do so amp File Print from the main menu 38 Chapter 2 Demonstration Exercise E E OK Select any print template from the list The cross section will load into the Report Editor where the image may be inserted into a report and printed or saved to PDF HTML

HydroGeo Analyst Demo Tutorial Guide

Contents

Download Pdf Manuals

Related Search

Related Contents