Home

Demonstration Guide - swstechnology.com archive

1. Project Tree _ Station List Data Query Data Filter 18 Collapse Expand id 411 f3 gt gt i X B F Ea a Station Groups Dnt Station Name X m Y m Elevation m TOC m Station Type m E re All Stations A Rs E gt W 05 53554840 481463730 331000 332 00 Observation Well RE ma W 06 53545940 4814704 90 330 800 331 80 Observation Well Montoing Wak W 07 535476 10 481478110 330 900 331 90 Observation Well A OC Monitoring Wells W 08 53546950 481465270 330 600 331 60 Observation Well AQ Soil_Borings W 09 53548470 481454650 329 900 330 90 Observation Well BC La e wo CEE Observation wel Borie ean wi es fasas 322 100 23210 Observation wen 3 Son Data O ewe 5885770 E asia 5 39 Queres E was o 281469750 _ s25s00_ ao Observation Wel T Time Sones Pits 7 wa sas 9 Crosstabs W 15 535687 40 4814665 30 330 500 331 50 d Cross Sections W 17 53557740 4814477 10 Observation Well T 3D Views 75 We18 535677 10 4814416 20 5 H pera fis ws esa eo a 33050 a C en enm 2120 53549290 481447720 22 10 wz EE 215 7 W 01 53532000 481461050 330 800 331 80 Observation Well w 02 53530000 481432940 331 100 332 10 Sr w 03 53550470 481475020 329 900 33050 lt Station Group Monitoring Wells Rows 23 _ Station Data i 411 t3 b gt i X B S
2. Stop select the a button to stop the animation When you are satisfied with a view click on the Save Colormap button to add this display element to the 3D Project under the Plumes node In the tree There are numerous features available for the Plumes that are not illustrated in this exercise For more details please consult the HGA s Users Manual Record AVI File You can record 3D animation rotation plume animation isosurface or color map spanning to an AVI Tile To do so Record select the E button located on the Navigation toolbar This will load the following dialog Video settings Settings Custom frame size AMI File name TEU RTS lt Width 220 Frame size Full window size Compression Full Frames Uncompressed Height 240 Frames per second 1 0 UK Cancel By default the AVI file will be saved to the folder in which the project is located You can change the Tile 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 UK OK button When you are finished after about 30 seconds Stop select the DO button to stop the recording 60 NOTE The recorded AVI files may get very large depending on the length of the video To play back the file browse to the fo
3. This will display the query results on the map project as a new map layer Next you will create a contour map of the chemistry data Creating a Contour Map Environmental professionals are often required to produce contour maps Contouring of project data such as water levels or contaminant concentrations Is an effective method of relating spatial distribution of data over a map Since HGA stores station data and various quantitative datum within its core HGA was designed with contouring tools that pull data directly from the source 40 some of the key contouring features in the GIS Map Manager include e Quickly load and contour data from any station data or from pre defined HGA queries Display color contours over the map with labels Modify contour line thickness and intervals Use color gradients to show distribution of the parameter over the Site select from industry standard interpolation methods including o Kriging o Inverse Distance and o Natural Neighbor some common examples of environmental data contouring include e Groundwater surface elevations e Bedrock surface elevations e Lithological surface elevations e Water table elevations e Concentration data contaminated water quality volumetric etc In this example you will contour the TCE data that was loaded in the previous section TCE_Exceeds_5mg_kg select layer in the layer control to make this the active layer if not already selected Layer Create
4. station y station geo_ point Geo Point sation name name H Soil Testing soil result chemicals Chemicals J Soil Sampling so result result values Result Values E Soil Sample soil result result units Result Units E Soil Result Sample ID Chemicals Result Values Pesut Units dH x Map BHLP Plot and Flume Ready Use current projection system Reporting Detection Limit Sampling Precision TEH S i TTT Analysis Method so result chemicals Trichloroethylene so result resul values 5 so result resul units mg kg F Description i Geologic Description F Well Construction Qualifier Comment E Rock Coring E Soil V appr E Moisture Content E Grain Size Samnlas Sauce Condition To see the results of your query you must generate the SOL statement based on your design and then execute the SOL Statement generate button on the toolbar execute button on the toolbar The results of the query should appear as shown in the figure below 25 Query Builder a i S ign SOL View Preview C Station Group Quen Data Query Select a Query SELECT station id AS id stations AS v station AS p station geo _polNt AS Geo Pont station name 45 name soil result chemicals 45 Chemicals soil result result values 45 Result Values soil_result result_units 45 Result Units FROM Station RIGHT JOIN PStation ON Station ID PStation SID JLEFT JOIN soil result ON Station id
5. Additionally you will find the first row In the data grids Is a filter row You may want to find all the stations in your project that begin with GB To do this enter GB in the filter row of the Station Name column Station List Station Data Data Query DataFilter Well Profile N 4 1 fi gt H PHD ID Station Name Alm Yim He pH A uszo mo aa GET 451400000 R You will see that only the station which name begin with GB are In the station list Hevaton m TOC m Station Type m o Ea To clear the filter simple select the Ed button in the Station name column To get the station back into the original order you can sort on the ID field Hydro GeoAnalyst Demo Project Project g Modules Database ZZ Help Project Tree Station List Station Data Data Query Data Filter Well Profile 4 Collapse Expand i ld 411 of151 gt fie 3 a F E D EQ Station Groups i Elevation m TOC m Station Type m i All Stations E E Es Es ar E Lab QC Stations 536668 13 481403600 T 334 800 332 10 E bina Wot TOS 28050 i Ac Mentor Wels BR Soil Borings l i g L WQ_Stations Es a thicker than 2m 4 E Peran wh KEE 4814781 10 L d Station Data 53546950 481465270 Queres 2 Time Seres Pits B Costas 7 ROE 53563770 481458230 6 64 Cross Sections 481463750 329 900 Y 3D Vi
6. E sy Concentrations E Water Levels E lt 4 Water Quality ga aquiertest pumpingrates oe ga aquierest pumpingtest water levels bail 99 Cross Section Interpretations sone ga Cross section model interpretations sl ga qr lab analysis AA select for deletion 37 soil desc concatenate AA TCE Exceeds 10 mg per kg AA TCE Exceeds Smg ka L ga Time Series Char Data 7 Tima Garas Plato ne will execute the Query and display the Query results in the Data Query tab 26 Station List Data Query Data Filter 1 u RGE SO O Rowld id x Lm Y im Geo Point name Chemicals Result_Values Result_Units Al Al Al JE E SE 14 oethyl ENE Tesa 620 n E wR S645 Tesa 7 00 00 23 60 INT 80 B 67 Trichloroethylene dia SE 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 You will notice that you can group your queries into folders to make It easier to find the query you are looking for Time Series Plots The plotting component offers the following tools Create Time Series X Y plots based on data queries Display time series plots as line charts or bar charis Add legends and data marker labels to plots Add best fit trend formula or statist
7. STDEVP SUM VAR VARP sort query results in ascending or descending order Using the Query Builder you can design and execute data queries such as select and map all water wells drilled later than a specified date select and map all boreholes deeper than a specified depth Report groundwater soil concentrations that exceed a given concentration Highlight stations with vapor concentrations at a given concentration Map pumping wells with pumping rates greater than a specified value 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 Modules Query Builder from the main menu Or from the main toolbar 19 You will be prompted to either create a new query or open an existing query We are creating a new query so enter the name TCE Exceeds bmg kg and select OK NOTE Slashes are not supported in the SQL string therefore the underscore is used to denote per The Query Builder window will load as shown below Query Builder S S C7 Station Group Quem Data Query Select a Query Display Fields TCE Exceeds Sma kg pes leeson die ato station name z E Description E Geologic Description fl Well Construction al Sail Testing Soil Sampling i Monitoring Event H Mining E xplorati s ae eia ai x L LE Map BHLP Plot and Plume Ready Use current projection system H Nd ell H
8. 332 00 Observation Well EN oo W 06 53545940 481470490 330 800 331 80 Observation Well W D7 535476 10 481478110 330 900 331 90 Observation Well GC Monitoring Wells W 08 53546950 481465270 330 600 331 60 Observation Well Soil Borings W 09 53548470 481454650 329 900 330 90 Observation Well kat ae W 10 535626 80 481465290 329 500 330 50 Observation Well ICKEr an E Peren a e a Wii 53554590 481455350 332 100 333 10 Observation Well 0 69 Station Data W 12 53563770 481458290 330 200 331 20 Observation Well H I Queries W 13 53580000 481463750 329 900 330 90 Observation Well TUF Time Series Plots W 14 53567460 481480000 330 400 331 40 Observation Well c Crosstabs W 15 535687 40 481466530 330 500 331 50 Observation Well a x varie DST 52539000 481474190 T 329900 330 90 Observation Well iagi Cross Sect W 17 53557740 481447710 329 300 330 30 Observation Well H 3D Views wis 53567710 481441620 330 500 331 50 Observation Well 0 7 Reports VOS 53558450 T A812900 00 329 900 330 90 Observation Well W 20 53559970 4814371 80 330 200 331 20 Observation Well W 21 53549290 481447720 331 100 332 10 Observation Well W 22 53563520 481450380 330 800 331 80 Observation Well W 23 535588 40 481466730 331 100 332 15 Observation Well W D 535320 00 4814610 50 330 800 331 80 Observation Well w 02 53530000 4814339 40 331 100 332 10 W 03 53550470 4814750 20 329 900 330 90 W D4 53547200 481470470 330
9. Contours with HGA from the main menu of Map Manager The following dialog will appear Contours Data to be Contoured Interpolator Settings Choose Field Result Val nd Interpolation Method Min Value 6 2 Data Min 6 2 Inverse Distance ka Advanced Settings Max Value 30 Data Max 90 Contour Type le Contour Line Name TCE Contour apl Settings Color Shade N arme Zebra Mame tings Restrain within Domain Create Cancel Help 41 Result val from the combo box beside Choose Field Inverse Distance for the Interpolation Method TCEContourMap typein the Name text box Settings beside the name text box The following dialog will appear Contour Line Settings Intervals Contour Line Settings f Contour Interval 5 Contour Line Style f Number of Intervals E Custom Interval Decimal Places OF Cancel Help Contour Interval select radio button 5 type for the Contour Interval Label Renderer checkbox select to turn on labels OK to accept the contour line settings Create button at the bottom of the window OK to the message that the contours were created successfully The contours will then be displayed on the Map project and the Map layer will be added to the Layer Control on the left side of the window A sample is displayed below 42 O Map paat Mr par K q i E est B E E 0 ATT fB GOM HAN BB D D Of Next you will create a T
10. Logs format and layout is fully customizable scan borehole logs using drop down menus Import export final borehole log designs when exchanging with other HGA users Export final borehole log reports to various formats HTML RTF PDF XLS TIF and TXT Print multiple borehole logs as a group or individually e Report Previews allows for scanning the complete list of logs prior to printing e Print to any Windows printer or standard plotter Viewing BHLP Templates several borehole log plot templates are provided in the Demo project Boreholes from the Station Groups node in the project tree From the project tree expand the Borehole Logs node then neutron_and_mineralization_plot double click The Borehole Log Plot Designer window will appear as shown below 34 Bad esigner Neutron and Mineralization Plot x Eg Elevation m TOCIm 536212 69 4814030 00 323 500 324 50 Pere esign Depth mBGS Depth mBGS Neutron red and Mineralization blue Neutron red and Mineralization i i Select Station GB 01 E PPE DT S E 2 Lithology Well Construction 15 93 25 93 35 93 4593 5593 65 93 oy sample Es min Coarse Gravel Medium Sand wE tX JP 20 Name Value E Fine Sand i eet tte V Live update Apply 100 eee Coon e Rin Hee From the Select Stations drop down menu circled above G
11. Monitoring Wells GB 44 535243 05 481475620 339 22 Borehole QC Monitoring Wells GB 10 53529569 4814030 00 339 00 Borehole Soil_Borings GB 22 535200 00 4814293 30 338 59 Borehole bez N GB 43 53527280 481496260 338 57 Borehole pe lO GB 32 52527896 4814624 00 33752 Borehole GB 21 53528876 4814296 10 336 95 Borehole Ow 4814826 00 331 60 Observation Well MS 4814036 00 332 10 Observation Well GB 29 4814501 80 335 29 Borehole GB 40 4814791 50 334 93 Borehole Ow 2 4814905 00 330 90 Observation Well GB 07 4814030 00 334 00 Borehole GB 18 4814253 10 333 92 Borehole MG 4814315 00 331 80 Observation Well VOT 4814553 50 323 10 Observation Well GB 42 4814906 20 332 64 Borehole SB 02 4814199 00 Soil boring SB 09 4814385 00 Soil boring SB 26 4814009 00 Soil boring w 02 4814339 40 332 10 WET 4814477 20 332 10 Observation Well W23 4814667 30 332 15 Observation Well SB 03 4814303 00 Soil boring SB 11 481462500 Soil boring SB 32 4814391 00 Soil boring SB 35 4814298 00 Soil boring W 05 4814637 30 332 00 Observation Well SB 13 4814091 00 Soil boring SB 30 4814452 00 Soil boring SB 39 481484600 Soil boring SB 70 481429600 Soil boring SB 71 4814269 00 Soil boring SB 72 4814299 00 Soil boring VEO7 4814781 10 331 90 Observation Well SB 07 4814305 00 Soil boring SB 18 4814078 00 Soil boring SB 25 4814208 00 Soil boring SB 38 4814824 00 Soil boring SB 40 4814841 00 Soil boring Station Group All Stations E
12. field Locate and click on the Result units field Drag this field into the blank conditions field under the first Expression column The selected field will be added automatically to the Query Conditions For the Operator select from the combo box Select an Expression for the field For this example select the appropriate soil chemistry units mg kg from the combo box The query Builder should like the image below 22 e Query Builder aS 7 Desen C Station Group Quen 5 Data Query an SUL View Preview Select a Query Display Fields E EE m Enton Eesen de Order by talon id id El Description station x station y U al Geologic Description station geo point Geo Pont H Well Construction stahion name name hl Soil Testing J Soil Sampling Ge Soil Sample Soil Result o sample ID Chemicals Result Values S Resuk Unie sh x I E Map BHLP Plot and Plume Ready Use current projection system Reporting Detection Limit 2 Sampling Precision TEH Fraction Code i Eesen e Tem TT e Analysis Method so result chemicals Trichloroethylene soil result result values Fis so result resul units mg kg Qualifier E Comment T E Rock Coring E E Sail V appr E E Moisture Content E Grain Size Samnlas Source Condition Now 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
13. however you can change this if you wish Then select the location for the project files Lastly select the Install button Please Note this process may take from 2 5 minutes depending on your computer network speed If you encounter difficulties installing the Demo Project as described above you can follow these steps to manually download and install the Demo Project 1 Open your internet browser and navigate to the following website htto trials swstechnology com archive Software Hydro_GeoAnalyst Demo_Project HGA_ Demo_Project ZIP 2 Select Save in the File Download dialog and in the Save As dialog select a destination folder on your computer and then click the Save button 3 The demo project will begin to download to your computer Depending on your internet connection speed this may take several minutes Once the HGA Demo Project zip file has been downloaded to your computer extract the contents of the HGA_Demo_Project zip file to a location on your computer 4 Ensure that your software Is licensed and launch Hydro GeoAnalyst by double clicking on the desktop short cut icon 5 Select Project Open from backup from the HGA main menu 6 In the Restore Database As dialog box specify the SQL Server you wish to use 7 Beside the Project field select the Open button folder with green arrow and navigate to the folder where the demo project files were extracted to Select the Project vbh file 8 Beside the Backup F
14. make a list for If you are making a list associated with Images we have included a quick and easy Import based on image files Updated Material Specification Now supports quick and easy import of material image files Support for SOL Server 2012 Hydro GeoAnanlyst supports Microsoft SOL Server 2012 and continues to support SOL Server 2008R2 We have also included the option to easily and automatically install a SOL Server 2012 Local DB as an alternative to a more lengthy full SOL Server Installation We recommend this as a quick and simple approach for trial evaluation of Hydro GeoAnalyst and for use as a sandbox using the Demo Project to test new program features SOL Server Authentication When connecting to your project database you can now choose the mode of authentication to be used either Windows Authentication or now SOL Server Authentication User Interface Improvements We have made a number of notable interface improvements including the ability to Show Hide Dock your Project Tree to maximize use of screen space and undock any tab based modules out of the main Hydro GeoAnalyst window This you are able to take full advantage of multiple displays and monitors You can now create folders for grouping on additional branches of the Project tree such as Station Groups Maps etc as well as an option to filter your project tree for easy searching About Hydro GeoAnalyst HGA is implemented through a number of modul
15. see the aforementioned interpretation types Model Geologic and Hydrogeologic From here you can show hide 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 49 This will display a text box containing the soil descripti
16. soi result Station WHERE soil result chemicals TrchlOR cethulene AND sol result result values gt Description 5 AND soil result result units mg kg AND PStation ID 1 H Geologic Description H Well Construction El Soil Testing J Sail Sampling E Soil Sample Soil Result Sample ID Chemicals Result tales Result Units Reporting Detection Limit Sampling Precision Fraction Code 43 46154 43 46455 43 45262 43 48299 43 46456 da dadas da 40306 da 40306 da 40306 Trichloroeth Trichloroeth Trichloroeth Trichloroeth Trichloroeth Trichloroeth Trichloroeth Trichloroeth Trichloroeth Trichloroeth ely Geo Point name Chemicals Result Val Result Unit 00 56013 00 55934 00 56434 00 56273 00 55962 00 55936 00 55070 00 55070 00 55070 13 mg Kg E mgrKg 22 mg Kg 30 mg Kg 7 23 mg kg 15 05 mg Kg T E mg Kg 9 07 mg kg 12 22 mg Kg 3 7 mg Kg Analysis Method 0 56259 4248272 Qualifier Outlier Comment Rock Coring Soil vapor Moisture Content H Grain Size S amnles E Condition Rows 10 Advanced This query should return 10 records that satisfy the specified conditions Close to return to the main HGA window Yes to save the query 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 u Queries node in the project browser and select this query 1 oe 2
17. 31 80 Observation Well Station Group All Stations Rows 151 Station Data L I4 424 fit gt i F 3 a PhS yp GB 01 lt Data Category K Description ao 8 Location description_addins a ID Station Name Xm Y m Elevation m TOC m Station Type m F K Ready Well Profile To get this arrangement right click on the Well Profile tab and select New Vertical Tab Group Then right click on the Station Data tab and select New Horizontal Tab Group 11 Viewing Station Data Manual Data Entry HGA 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 Data The Data Transfer System DTS is designed to assist in the process of importing exporting data to from the database Using the DIS station data can be imported from practically any source including delimited text files MS Excel MS Access Databases SOL Server Databases and others e Allows Importing of data from virtually any source including o Text files CSV o Microsoft Excel spreadsheets XLS o Microsoft Access databases MDB o Any other ODBC or OLEDB data sources DBF e DTS includes on the fly unit and coordinate system conversions during Import and export e Quickly choose from a complete list of coordinate systems UTM State Planar Geographic or other Global Coordina
18. 40 7 30 33 00 Observation Well WO 534540 481470490 330800 251 80 Observation wel 76 10 320 900 I 4814652 Observation Well Observation Well Observation Well Observation Well Observation Well ion Well Observation Well Observation Well Observation Well 5 548 481463 3 O M E we 58671 48146620 350500 2150 Observation vel e C EE CS 20 W 20 535599 70 4814371 80 330 200 331 20 Observation Well 88 8 8 8 8 8888 bana s 3 5 8 8 2 8 8 2 S S L S Z Chemical Name Result Value Result Unit ug L Reporting Detection Limit Sampling Precision 18 Querying the Database HGA goes beyond simply storing your data HGA also provides practical search query tools to help you access and interact with your data using the industry standard Structured Query Language SOL Retrieving your data has never been easier some of the features of the Query Builder include Quickly generate simple or advanced SOL Statements within the Design Preview panel Automatic validation of SOL Statement provides warning for incorrect statements Logical use of expressions and operations make data querying easy e g gt gt lt lt lt gt l I lt I gt LIKE IS IS NOT BETWEEN amp Improved query efficiency using group centric or data centric approaches Efficiently map query results directly to the Map Manager Generate quick statistics from your queries e g AVG COUNT MAX MIN STDEV
19. 41 Width 75 Alignment Center Color um Angle 0 Depth ia Auto Color leal Font 0 General Fit width to page Print scale factor 1 750 O fit to report template Cancel Apply UK Help Beside the Print scale factor type 750 A Print scale factor of 1 750 would mean that 750 units on the BHLP would correspond to 1 unit on the printout OK to close dialog box To print a report for the selected BHLP only Print button in the lower right corner bhip_portrait from the Select Template dialog box dropdown list OK You will get a preview of the report to be printed as shown below 36 WHI Report KES mu a Sieg 100 WSS TH T E P mng TT TEE X top right button to close the print preview and return to the BHLP window Close bottom right button to close the BHLP Designer and return to the main HGA window 37 Map Manager The Map Manager is built on ESRI technology and is packed with an abundance of mapping features that seamlessly connect your project maps with the HGA database However the Map Manager goes far beyond simple mapping It also acts as a fundamental source for producing cross sections accessing borehole logs and well construction details and developing contour maps elevations concentrations water table etc The Map Manager is an integral part of HGA and is ideally suited for analyzing and presenting the S
20. 600 331 60 Station Group Monitoring Wells Rows 23 Ready 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 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 select e All Stations from the Station Groups node e The Elevation column in the Station List This will sort the values in this column from lowest to highest If you select the Elevation column again it will sort the values from highest to lowest e The Elevation column in the Station List Now you will see that the highest elevation is 340 49 and this occurs at station GB 33 Hydro GeoAnalyst Demo Project Project g Modules G Database ZZ Help H sy LT LDO 17 Project Tree Station List Station Data Data Query Data Filter 8 6 Collapse Expand 1 f151 gt i d E Kees ID Station Name X m Yim Elevation m TOC m Station Type m a Al reholes gt GB 33 53523332 481452790 341 49 Borehole ae GB 11 4814000 00 340 50 Borehole
21. B 02 select from the dropdown list The display is updated to reflect the Lithology Well Construction and Scale of the selected station The Borehole Log Plotter provides the ability to zoom in to any section of the plot a critical tool when analyzing and interpreting detailed data on a fine scale These options are available as zoom in zoom out buttons on the toolbar The Borehole Log Plotter also allows you to select Data Queries as data sources for plot depth or interval columns Using a Data Query instead of a Data Table provides more flexibility in the type of information that can be added to a BHLP for more details please consult the HGA User s Manual 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 BHLP templates 35 Saving and Printing 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 The Borehole Log Plotter allows printing to a user defined scale To specify the print scale setting Design Right click on the folder on the BHLP tree show Settings from the dialog box and the following dialog will appear BHLP Settings E5 BHLP Default for All Columns E gt Depth mBGS Header Properties Column Properties 5 E Neutron red and M 3 3 5 Plot Area Height Auto
22. Demonstration Guide RR ima E SA arm aie ert Jy l G SI s w mi magy Hydro GeoAnalyst From Data Discovery to Delivery Introduction to Hydro GeoAnalyst Hydro GeoAnalyst HGA Is the most comprehensive and yet easy to use environmental data management system providing data validation analysis and visualization The HGA 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 HGA 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 It can collect all of your previous data and reports and consolidate them into a powertul relational database system that can be queried and referenced with ease HGA operates as a desktop application based on Microsoft SOL Serv
23. ECC fee 10 Medium E E Station Data AA Queries es SG sono 2856 5056 a E ER en EE Sie TW Time Series Plots FA Crosstabs e fen ssm maoo a0 34050 Borehole a Borehole Logs L Map Piece Eero eet 5666 a ie thie E e n e owe arm f d D vows 7 fen 565 a amoo 3405 Borehole D Repons es ma TR 324260 2528 Beetle so e E EM SEEM CEE fo em ee amo jm mem toe E COR seas ean amem Jomso ee e Seea en mono a f so Djs me E 176 eee o ess sare TT Es 30 337 590 338 59 Ss S l Station Gr Boreholes Rows 44 s j gonr iad J Station Data S M 4 2 faa K H dRea Fine Sand Stations GB 02 2 Data Category 8 Well Construction x 3 Driling Protocol Casing Screen Annular Fil Monitoring Points Aband 70 E From m Toim Filling Type Filling Sand 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 05 in the station list On the Station Data tab Monitoring Event from the Data Category combo box The data for this will appear as shown In the figure below 16 Hydro GeoAnalyst SWS new install A Project g Modules fyDatabase ZZ Help E T Psy ate ed BO MW
24. F EMF and export any soil specifications to external files The geological data will be used to create Borehole Log Plots 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 Data ka H 4 1 ofi bl d REE BEER GB 01 Data Category Well Construction Drilling Protocol Casing Screen Annular Fill Monitoring Points Abandonment Fromm Tolm Diametericm Drilling Method Inclination degree Azimuth degree 1517 UOIEYS Aves ie Ea k A Hollow aeia 0 jo This will load the Well Construction data for the selected station GB 01 In this table you will see six tabs tables Drilling Protocol contains drilling information Casing contains info on well casing materials diameter etc Screen contains screen interval details Annular Fill contains info on annular fill gravel packs sand packs etc Monitoring Points contains info on monitoring intervals and probes Abandonment contains info on when a station is abandoned 14 Annular Fill tab to see the records entered in this table You will see the interval and filling materials entered for this borehole HGA comes with a List Editor tool that affords users the ability to create and customize
25. Plot Designer Plot Example Plot Page Design Designer mM trx Settings Name Plot Example Toolbar Number of Columns 2 Number of Rows 2 Spacing Width 10 Spacing Height 10 Plot Settings amp Data Source The name of the plot page oem N gass JU He The plot window contains the following items e Plot Page Design Tree list of all available plot page designs plots and series such as Lines and Standards e Designer Toolbar Toolbar buttons used for modifying the plot design e Plot Settings and Data Source Contains the settings for the selected entity and data mappings e Contains a real time view of the plot page design Adding a Plot To add a new plot sp Add button In the Name field enter the name of the plot Demo type None from the Template dropdown list box 29 Plot Details Name Demo Type Time Senes Template None ok Cancel select OK to create the plot OK Mapping Fields The next step Is to map the fields in your query to the fields required by the plot component This is done under the Data Source tab Data Source tab in the lower left corner of the window Map the following fields For the Query Time Series Chart Data from the drop down list For the Plot Grouping click on the right side of the field to load the available fields name from the list OK For the Series Grouping click on the right side of the field to load the ava
26. 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 the 3D Explorer 53 3D Visualization with HGA 3D Explorer HGA 3D Explorer is a powerful 3D visualization and animation package that is seamlessly integrated within HGA HGA 3D Explorer was designed as a tool for displaying multiple cross sections fence diagrams well locations with lithology maps contours etc all within the same 3D graphical environment HGA 3D Explorer brings your data and data queries to life and takes the guessing out of data interpretation With just one click of a button you can explore your data The HGA 3D Explorer offers a truly 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 In addition basemaps may be displayed for relating the fence diagrams to surface features The various graphical tools and presentation formats available are specifically designed for viewing geology and hydrogeology data In addition to displaying fence diagrams the HGA 3D Explorer can also be used to display Surfaces for each layer involved in the interpretation Use the HGA 3DExplorer to import basemaps to relate this to the cross section interpretations For example a contour map or DXF site map may be overlaid on top of mul
27. TNI varra abe MGL 535250 19 481431500 T 332 100 331 80 Observation Well E Lab QC Stat a MW 3 536668 13 4814036 00 334 800 332 10 Observation Well L Monitoring Wells Ow 2 53553550 4814905 00 333 900 330 90 Observation Well QC_Monitoring_Wells Ow 4 53672069 4814826 00 335 400 331 60 Observation Well Soil_Borings VDE 53554840 A812697 30 331 000 332 00 Observation Well WQ_Stations W 06 53545940 481470490 330 800 331 80 Observation Well re repa iii W 07 535476 10 481478110 330 900 331 90 Observation Well E Station Data W 08 53546950 481465270 330 600 331 60 Observation Well 5 9 Queries w 09 53548470 481454650 329 900 330 90 Observation Well Time Series Plots W 10 535626 80 481465290 329 500 330 50 Observation Well EM Crosstabs VOT 53554590 481455350 332 100 333 10 Observation Well epa VEIZ 53563770 481458290 330 200 331 20 Observation Well Saal ee es W 13 535800 00 4814637 50 329 900 330 90 Observation Well 0 3D Views w 14 53567460 481480000 330 400 331 40 Observation Well S VOR 53568740 481466530 330 500 331 50 Observation Well VOE 53539000 4814741 90 329 900 330 90 Observation Well W 17 535577 40 481447710 329 300 330 30 Observation Well Wig 535677 10 481441620 330 500 331 50 Observation Well VOS 53558450 481430000 329 900 330 90 Observation Well W 20 53559970 481437180 330 200 331 20 Observation Well W 21 53549290 4814477 20 331 100 332 10 Observation Wel
28. TO W 05 lt Data Category e amp Parameter Sample Parameter Result Water Level Meteorology Divers Diver Data Field Measurements E Sample ID Lab ID Quality Code Sample Date SampleTime Chain of Custody Collection Quarter C E EN a K v05 121996 1 1 2 1996 ue pf 1 perns H CT O O H Ranna T Tnne TTT E a a a A A IK m t Hr t Rows 5 Ready This data category contains seven tables Diver Data Data logger results for Parameter_Sample sample id date etc Parameter_Results sampling results for various chemicals Water Level results from water table elevations measurements for several dates Meteorology data from for example weather stations Divers data related to divers installed at the station this station Field Measurements measurements that may be taken in the field 7 well Profile Depth m Lithology Well Complet 10 10 12 1 16 16 18 18 r As shown below the Parameter Results table provides a list of samples collected for this well the date and time of the observation and the concentrations provided by laboratory analyses 17 Hydro GeoAnalyst SWS new install Too bob ES C Project GP Modules Tapes Help AF EUERE LTL Projet Tree Stationtist DataQuey Datafilter Wall Bale Racemi uci ash PRESTO ID lt Station Name Xm Yim Elevation m TOC m Station Type m v 05 535
29. X_Concentration ET ms E Sete 5936 17 11872 3 17808 5 23744 7 31659 6 39574 5 Geology LG Coarse Gravel E Medium Sand an Gravel E Fine Sand Y m G Silt Cia 535500 536000 L Boulder Clay X m i 28 Rotate Shit Light Postion Time Plume Browser 2 LLL LI yis Z LU Rotate model around the scteen axes X up down Y left nght Z rock side to side tive Update App 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 56 Navigation Tools Locate the field containing the Vertical Exaggeration at the top of the window and enter a new value 4 type in field Enter 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 on the Navigation Toolbars X slider bar 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 Z place a checkmark beside this option on the right side of the controls Play select the Puto to start the rotation Observe the rotation for a f
30. ayers Having done so turn on just the air photo to provide a map background and the TCE exceeds 5 mg kg layer by clicking on the check boxes beside them An example of a Map Project with a Bar Chart is shown below tree Jenaj imere ADAM ere A Ri corm Ea it dito RA a 45 Saving and Printing Once you are satisfied with the map view there are several options for 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 Editor 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 Print Report button from the toolbar X Close button to return to the Map Manager window Features in Map Manager The HGA demo project provides an additional map project that can be accessed by double clicking SiteMap2 from the Maps node This project contains examples of the other features available in HGA s Map Manager Take a minute and view some of the new features before proceeding to the next section The figure shown below indicates the new features that appear in SiteMap To read more about the graticule color shade layers an
31. bo box Close to close the Time Series module 31 Crosstab Queries Crosstab queries are special type of queries that let you store your data in a normalized manner in your database but let you produce pivoted denormalized outputs from that data In other words crosstab queries let you rotate rows to columns to see different summaries of the source data Suppose you occasionally want to get a pivoted view of your chemistry results whereby each row represents a different sample at each station and each column represents results for each analyte Another common example within the environmental industry Is to show analyte names reporting units and regulatory limits along the left column while sample names date and or depth ranges are shown along the top row and result values and qualifiers shown in the intersecting cells By using crosstab queries you can create summary views of your data for easier analysis and reporting With the crosstab query tools you can e Generate advanced crosstab queries from existing data queries e Format columns rows sorting options display color font settings or choose from over 30 predefined style templates Construct complex reports using the powerful built in Expression Editor Highlight cells that violate user defined data bounds Export a crosstab query HTML MS Excel and PDF format Print crosstab query results In the demo project there are two examples of crosstab queries From the HGA tree v
32. d intersecting map layers please refer to the HGA User s Manual In the next section you will view a pre defined cross section using the Cross Section Editor 46 Cross Section Editor Groundwater and environmental site investigations typically entail detailed analysis of lithologic data acquired from boreholes Interpreting and visualizing the borehole data Is a crucial step in understanding the subsurface regime HGA comes complete with a fully integrated cross section tool that is designed with all the features you need to create report ready geologic hydrogeologic cross section interpretations simply digitize your cross section line in the Map Manager then automatically render the cross section line to display your boreholes directly within the Cross Section Editor and begin your interpretation It s really that simple The Cross Section Editor is designed with easy to use tools for interpreting geological and hydrogeological data as well as interpreting data for groundwater flow models Generating model layers for use as modeling layer elevations in groundwater modeling packages such as Visual MODFLOW Pro has never been easier In addition the Cross Section Editor is seamlessly integrated with the HGA 3DExplorer a tool that combines and displays one or more cross sections in a 3D fence diagram view The Cross Section Editor allows for three types of data interpretations e Geologic containing lithology structure data e Hydrogeo
33. e you have a better understanding of where the contaminants lie and at what time steps you can use the more advanced options in the Plumes node in the tree this includes e advanced isoline maps with color fill and line settings e color maps with clip at cut off options e sosurface options including color from palette show borders and display volume estimation In the Style combo box select the desired display style Select from Colormap on XY XZ or YZ planes or Isosurface The Visible checkbox shows hides the current plume browser display element Time place a checkmark on the right side of the controls Play select P button to start the animation Observe the animation of the plume for a few seconds Note the time label at the top of the 3D window that shows the corresponding time interval Stop select the button to stop the animation When you are satisfied with an isosurface you can save it to the Plumes tree for further manipulation By doing so you will enable more advanced options for the isosurface and this will allow for displaying multiple colormaps and or isosurfaces Save Isosurface button 58 The new isosurface value will be added to the tree under Plumes Plume Region BTEX Isosurface 1 From here you may modify the isosurtace value display settings and also view the Volume Estimation To modify the Isosurface value you must load the Isosurface Properties to do so click on the butt
34. er Select Cross Sections Select Surfaces Select All Select All Cross Secton Name Grid Name E Elevation Grid m relief T Db E EE E FF m GG aD Select Plumes B HH Select All Select 3D Plume Project Name E BTE 3DPlume E Soil TVOC Plume Include site map 3D name HGA3D OK Cancel 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 CC EE GG place checkmark beside these cross sections Under the Plumes frame BTEX 3DPlume place checkmark beside this plume In the demo project the plume file has been created for you Enter a name for the 3D project In the field in the lower right corner Demo type in 3D Name Field 55 Export to 3D Explorer Select Cross Sections Select Surfaces Select All l Select All Select Cross Section Name rm Elevation Grid in relief Select Plumes f Select All Select 3D Plume Project Name IR BTEX_3DPlume T Soil TYOC_Plume OM Include site map 3D name Demo OK Cancel Help OK This will load the 3D Explorer window similar to the figure shown below HydroGeo Analyst 3D Explorer D Documents Demo_Project V3D Demo Lea 8 Project Edit View Objects Settings Help MN dw oe PS EAE ES Vestal Enaggeration 4 F Detauk Settings BTE
35. er technology The package supports multiple user levels for controlled data management with structured access privileges for setting up project data structures checking out data to working sub projects and submitting new or modified data Typical applications for HGA include 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 What s New in Hydro GeoAnalyst 2013 e Event Planning this new module ensures that your field activities are always completed correctly and on time Easily create multiple schedules for various stations and then create event plans that outline the details of your field activities including stations to be sampled data to be collected field checklists and more Event plans are automatically converted into reports which can be printed and given to field personnel Hydro GeoAnalyst keeps track of all your event plans and automatically reminds you in advance when scheduled field activities are due e Print Borehole Log Plots to PowerPoint Need to print out your Borehole Log Plots BHLPSs fast Use the Print BHLP to PowerPoint feature available on the Well Profile tab A borehole log for each station in the currently selected station g
36. erous features that are outside the scope of this demo tutorial For more details please refer to the HGA User s Manual Close in the lower right corner to return to the HGA main window 33 Borehole Log Plotter The Borehole Log Plotter BHLP is a built in borehole log component developed with a full range of features that support the design and plotting of professional borehole logs and well construction details Once the borehole template is defined logs can be generated quickly and efficiently for all boreholes in the project Automated data links reduce the need for user intervention You can design borehole log plots containing Lithology information for each formation patterns and descriptions Description of the geologic formation The depth and or elevation of each layer Well construction details casing screens annular fill Charts that display one or more data types collected at various depths in the well including those resulting from geophysical investigations symbols showing sample locations groundwater levels etc Unlimited number of chemical result plots Database templates include several pre designed borehole log templates Borehole log plots provide real time data entry assistance Launch logs by clicking on a well in the GIS Map Manager or 2D Cross Section Editor Add or remove data columns to the log for virtually any field in the database Generate professional log reports including logos and other box fields
37. es each performing a specific task This approach allows HGA to be memory efficient flexible and expandable The following modules are for the purposes of Data Management e Template Manager e Data Transfer System s Query Builder e Lab OA OC e List Editor e Material Specification Interpretation of geologic and hydrogeologic data is made easy with the visualization modules that are provided in HGA Using these tools raw data can be transformed into meaningful spatial data sets HGA 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 The following modules are for the purposes of Analysis and Visualization e Cross Tab Query e Time Series Plot e Borehole Log Plotter e Map Manager e Cross Section Editor e 3D Explorer Additionally HGA has a Report Designer module which allows you to push your data analysis and visualizations to a Report template Installing Demo Project A new feature implemented in HGA 2012 1 Is the ability to install the Demo Project directly from the program Simply launch HGA and select Project Install Demo Project HGA Demo Project Installation Demo Database Name SWS Project Location D Documents Demo Project You need to select the SOL Server you wish to use from the list of Available Servers or type your SOL Server By default it will give the Demo Database Name SWS
38. ew seconds then Stop select the T button to stop the rotation Z select to de select this option You can shift or zoom in out of the 3D grid using the shift options Shift tab on the Navigation Toolbars Z slider bar Drag the slider bar to the left to zoom out or to the right to zoom in The 3D Explorer window contains several controls which are not discussed in this exercise Individual cross sections and interpretation tyoes 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 For more details refer to HGA s User s Manual 57 3D Plume Visualization HGA provides the ability to display and animate 3D volumes of contaminants in the format of color maps isolines or isosurfaces a powerful visualization feature that is demonstrated below Plume Browser tab on the Navigation Toolbars The options will be displayed as shown below Ne sma Light Position Tire Pluma Browner E KI al Pre ATES Conmcentstom T aig Opine Site l bus Wibe V Saree Coloma Tire When the 3D project was created the 3D Explorer displays the plume in the form of an isosurface by default The default isosurface value will be 5 of the maximum concentration value The options in the Plume Browser tab provide you with a preliminary assessment of the plume As such there are basic options for color maps and isosurfaces Onc
39. ews 535674 60 4814800 00 330 400 81 17 Reports 53568740 4814665 30 535677 10 481441620 330 500 i ens aio i i 53558840 4814667 30 i 53621269 4814030 00 Borehol 7 4814050 00 326 000 Borehole 53607969 4814070 00 326 000 Borehole Borehole Borehole Borehole 53565269 4814030 00 Borehole 535498 69 4814040 00 Borehole Borehole Borehole Borehole Borehole 4814379 70 324 850 Borehole 481432020 323 050 Borehole 4814251 30 324 260 Borehole 326 560 Borehole 329 30 Borehole 333 92 Borehol Hr Ready Adjusting Tab Layout When opening HGA the default window displays will appear There are two tab groups one with the Project Tree and one with the other 5 tabs Station List Station Data Data Query Data Filter and Well Profile 10 You have several options to adjust the view of these tab groups You can add additional tab groups right click on any existing tab either vertical or horizontal You can rearrange the order of the tabs within a tab group by simply dragging and dropping a tab You can even drag a tab from one tab group to another Here Is an example of another way to organize your Tab Layout Hydro GeoAnalyst Demo Project Project g Modules fy Database Help A TESE ADO Project Tree _ Station List Da
40. hematic map in order to visually represent the greatest concentrations of TCE at these stations Before proceeding turn off the ContourMap layer remove the Visible status Creating a Thematic Map HGA offers thematic mapping functionality to help graphically display the distribution of a single attribute characteristic or the relationship between several attributes Some of the key features Include e Create thematic maps to define a theme from virtually any field in the database Create a map layer with thematic symbols for selected station queries Select from pie graphs bar charts or graduated polygon distributions Modify point style appearance pattern font symbol fill border size Assign a graduated color scheme for a range of values at point Manually edit minimum or maximum range values select and define color ramps using standard or custom RGB colors Assign various symbol styles to specific point values Add labels for various thematic selections Adjust thematic map layers in any preferred order For environmental professionals thematic maps are extremely useful in covering a wide variety of characteristics such as displaying the relationships between 43 Wells with head elevations above or below ground surface Artesian conditions Groundwater pumping volumes and precipitation Recharge potential Layer thickness from ground surface to subsequent layers Aggregate exploration Soil types sand versus clay and aquifer vulnerabil
41. ical lines to the plot Interact with plots and display multiple plot windows In the viewer window simultaneously Define data series ranges and modify display properties for different data ranges select fields for plot grouping or data series grouping Modity display properties including axis labels symbols legends and intervals Print plots in a report single or multiple pages save plot settings as templates for re use Export plots to graphics format Copy plots to Windows clipboard 27 In HGA the plots are saved under the Plots node in the Project tree the demo project contains several examples Feel free to take a moment and open these examples and discover the numerous options that are available Below Is a brief description of each plot diver_data Displays average depth to water level data for station W 23 over the month of November water_levels Displays water level data for multiple stations over the a period of eight months water_quailty_plots Displays water chemistry data for multiple stations over a period of several years Creating a New Plot Page Design To create a plot follow the steps below ff a i from the mian toolbar We are going to create a new plot so enter PlotExample in the dialog box that appears Time Series Plots Select an option Create new plot Plot Example Open an existing plot diver data OK The Plot designer window will appear as shown below 28 E
42. iew expand the Crosstab node and then double click on the tce btex year 2000 example tce hbtex year 2000 double click The Crosstab window will then open as shown In the following screenshot 32 tce_btex_year2000 CrossTAB report Gi ie es lt e AA e Inactive fields Sample_Date J00 1200 00 AM 5 21 2000 120000 AM 6 25 2000 1200 00 AM 8 29 2000 1200 00 AM 10 2 2000 12 00 00 AM 55 15 9 00 90 noi no Cd SE Sa E SS E E CSS ui sado 1900 2200 HT DC 360 360 aro HT ad 0 TT Chemical w a te ii 2 nn e man mo SCE O 40900 933 33 From the toolbar in the upper left corner there are several printing and exporting options available e Use the button to set the printing options e Use the L button to print the crosstab report e Use the 79 button to export the report to an HTML file A dialog will appear where you can specify a directory and filename for the HTML file e Use the RC button to export the report to an MS Excel file A dialog will appear where you can specify a directory and filename for the XLS file e Use the RG le to export the report to a PDF file A dialog will appear where you can define the page and export settings and the filename for the PDF file e Use the IS to hide the sub totals in the crosstab report e Use the button to hide the global totals in the crosstab report The crosstab query component contains num
43. ilable fields chemical name from the list OK For the Time date from the dropdown list For the Value result value from the dropdown list The plot should now be displayed as shown In the screen shot below 30 k eal aed T RE Eq a a Ee ere Dada Condor Dust Lea Semmes DUO ri li ia KT Pre bami Goo Chata rca ea 1 Ep 90906 jake end veia E ini E E HD arta ieir Lr tr mr ER de je 14 J vde ied Lai SE mis ld Pani Y L kup Help At the bottom of the Plot window there are scroll buttons to pan to the next and previous pages In this example the query and grouping options has resulted in a plot page design Spanning pages gt gt to see plot data for remaining stations in the query There are numerous plot and data series settings that can be modified under the settings tab Feel free to experiment with these features now For more details please consult the HGA User s Manual Saving Plot Template Once you have designed the current plot to your style and data needs you can save the design as a template for re use In future plots To do so Right mouse click on Demo the plot name in the tree and select Save as a plot template from the menu Enter a name for the plot template and then select OK The template will be available next time you create a new plot in the Add Plot dialog under the Templates com
44. ile field select the Open button folder with green arrow and navigate to the folder where the demo project files were extracted to Select the SWS Demo DB bak file 9 Finally click the OK button to open the demo project Note The above procedure Is only required when opening the downloaded Demo Project for the first time Next time you wish to open the Demo Project you can select Project Open and then select the Project vbh file for the Demo Project Viewing Demo Project Once you have the demo project open either of the two ways described above you will see the following window Hydro GeoAnalyst Demo Project Project 5 Modules Database E Help ae L T SN aie E 9 S L MES ad A Project Tree z Station List Station Data Data Query Data Filter Well Profile 1 8 Collapse Expand 0 0 XANA o Station Groups 7 Station Data Queries 4 Time Series Plots H sstal F us 4 S 0 Soo a q oo 2 o a C L L ns N 2 Fo Sas F a FF CAK A B 789F8 os a All spatial data in the demo project is projected according to the NAD1983 coordinate system This information is defined during project creation and can be viewed by selecting Project Properties from the HGA main menu Hydro GeoAnalyst now supports storing and displaying spatial data in localized coordinate systems Now there 1s no need to adapt your spatial data to world coordinates If you preter to work in site coordina
45. ing this feature you can display plot columns containing data such as geophysical resistivity or gamma measurement or interval columns such as well screen intervals this data can be a valuable asset when creating the cross section interpretations beside HH to close this cross section beside CC to open this cross section This cross section will now appear as shown in the screenshot below 51 You may modify which BHLP template and stations should be selected on the Cross Section using the Tools Display BHLP option from the main menu For more details please consult the HGA User s Manual Saving and Printing Once you are satisfied with the cross section view there are several avenues you can follow Save the Image as a graphics file Print the image directly as Is Insert the Image into a report View the cross section and other cross sections in 3D If you wish you may print this cross section now To do so File Print from the main menu of the Cross Section Editor select any print template from the list OK and the Cross section will be pushed to the Report Editor 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 RTF and other file formats In addition the 52 Report Editor allows for customizing the header footer and logo The image will appear similar to the one shown below Z WH repon T N
46. istory Condition i Expression Operator Expression Operator Source Condition Project We want to be able to display this query on Map later so ensure the Map Ready option Is selected Map BHLP Plot and Plume Ready checkbox on You will notice the Query will automatically add several fields to the Display Fields section of the query that are required for using the query on a map In the tree on the left side of the window expand the Soil Sampling node and then expand the Soil Result node 20 Query Builder C Station Group Query 2 Data Query Pasian Select a Query Display Fields Function Expression Als Order by E station id id El Description station v Geclocic Descrinti station V R L A station geo_paint Geo Point H Well Construction s i Stann name name hl Soil Testing J Soil Sampling Ge Soil Sample o Soil Result ER o Sa ED E x Map BHLP Plot and Plume Ready Use current projection system Chemicals Result Values Conditions Result Units it Em P D p Reporting Detection Limit Sampling Precision Fraction Code Analysis Method Qualifier E Comment T E Rock Coring E E Sail V appr E H Moisture Content po Grain Size Samnles Source Condition Locate and click on the Chemicals field Drag this field into the blank Conditions frame under the Expression column The selected field will be added automatical
47. ity to contamination Graduated value polygons for land use or contaminant source Inventories Population density versus aquifer thickness To create a Thematic Bar Chart follow the instructions below TCE exceeds 5mg per kg select layer from the Layer Control to ensure that it is active Layer Create Thematic Map Bar Chart from the Map Manager main menu A Thematic map window will appear as shown below Create Thematic Map N ame Bar Chart Fields in Table Fields for the Theme ES ES ES E t Cancel Help 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 highlight field from the left panel select button to move this field to the right panel Next button to proceed to the next window 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 44 40 type for the height 10 type for the width Result tal Height ao Points Width fi U Points Preview Back OF Cancel OK select button to create the map The thematic map Is an entity of the selected layer when this layer is hidden so too will the corresponding thematic map To visualize only this bar chart it may be helpful to hide the non essential layers by selecting View Turn off all l
48. l w2 53563520 481450380 T 330 800 331 80 Observation Well Station Group All Stations Rows 151 Station Data z Id 4 24 of151 gt DI a P ES yp GB 01 Data Category gt Desorption E Location acionada E ID Station Name X m Y m Elevation m TOC m Station Type m p 24 GB 01 me 481403000 323 500 324 50 Borehole 4 Rows 1 Ready 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 Lithology table and data for the selected station GB 01 In this table you will see soil intervals from to soil types soil descriptions soil classification names and soil patterns Soil classifications may be selected from a picklist The Demo Project is using the DIN 4023 classification HGA is packaged with the following material specification lists e Unified Soil Classifications System USCS e United States Department of Agriculture USDA e Deutsches Institut f r Normung e V DIN 4023 e International Association of Hydrogeologists IAH 13 e Geological Survey of Canada GSC e Dunham Carbonate Classification e Shell Standard Classification In addition you can quickly develop or customize your own soils specifications palettes using a wide range of graphical file formats JPG BMP GIF ICO WM
49. lder on your hard drive locate the AVI file and load it Into a supported media player Saving and Printing Once the desired view has been loaded the 3D image may be loaded into the Report Editor for printing To do so Project Print from the 3D Explorer main menu 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 the Report Editor allows for customizing the header footer and logo The image will appear similar to the one shown below Print Report button from the toolbar X Close button to return to the 3D Explorer window Then close the 3D Explorer window by selecting Project Exit from the 3D Explorer main menu 61 Report Editor Generating professional reports from groundwater and environmental projects can be a time consuming effort It becomes particularly challenging when a project includes rounds of information for various dates spanning over months or even years Furthermore many regulatory agencies require adherence to specific reporting formats To overcome these challenges HGA was designed with the Report Editor The Report Editor is a time saving component used for creating professional reports that contain any number of datasets plus include 2D and 3D views for your projects HGA s Report Editor includes the following features e SWS Repo
50. lists for any field allowing for rapid data entry Common examples of lists Include e Well drilling methods construction and casing materials e List of common chemical names with their CAS Registry numbers e Lab analysis test methods e County and State Codes e Applicable standards for various purposes regions and agencies You can review the data for additional stations by selecting a station on the station list provided on the Station Data tab o Station Data see M 412 f KH d Rana Stations L GB 02 Data Category Well Construction Annular Fil From m Filling Type Filling Volume im 3 151 UOHEIS PIH EEE a aeae Fier pae Pease T Perdar set ne This will load the Well Construction data for the newly selected station You can also see the Well Construction in the Well Profile tab 15 Hydro GeoAnalyst SWS new install Project g Modules Database Help A Park ates AL S Sand Project Tree Project Tree II Station List F Data Query Data Filter IL Well Profile 18 B Collapse Expand ile 412 of44 gt di dR E 8 mrapa 9 Station Groups D 7 Name X m Y m Elevation m TOC m Station Type m El All Stations Qdo o o Z jen Ee enon a e e tm 7 ae GB 02 53615669 481405000 326 000 327 00 Borehole Monitoring Wels Esc 481407000 326000 32700 Borehole Quero et esas e Java mm mo joio JE Quase e ear TIO
51. logic containing locations of aquifers aquitards etc e Model containing locations of model layer lines which may be used in numerical groundwater modeling The Cross Section Editor provides users with the following key features e Digitize geologic and hydrogeologic layers using the polygon draw tool e Load surface layers e g DEM from Map Manager to generate detailed topography model lines e Select standard cross section fill patterns from the Geology e Copy zones from geology layers in order to define hydrogeology zones e Display the locations of intersecting layers and other cross sections using symbols and labels e Display water table location in cross section view e Dynamically view the spatial orientation of the boreholes in the Map Preview Window simply move the mouse over the 2D borehole to highlight its location on the map 47 View the orientation of cross sections as they relate to the Map Preview Window Define properties of intersecting features other layers or cross sections Display screened interval in cross section view Modity labels for lines and polygons Zoom in out and pan features Launch cross section for viewing In the HGA 3D Explorer Export cross section view to image format Export model layer points for use In groundwater models including Visual MODFLOW send cross sections to the Report Editor to be included in a report template e Copy window to clipboard To load the cross section editor from
52. ly to the Query Conditions 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 Trichloroethylene 21 Query Builder BHE Design SQL View Previem asd Fields Station Group Quen Data Query Select a Query TCE Exceeds ma kg E arid id station l T Description station x station V E Geologic Description station geo point Geo Point Well Construction San Gee H Soil Testing Soil Sampling E Soil Sample E Soil Result ings E anz D dh x Map BHLP Plot and Plume Ready Use current projection system eT emia Conditions S qo TTT peste S arr soll result chemicals Trichloroethylene Reporting Detection Limit Sampling Precision Fraction Code Analysis Method Qualifier T Comment T E Rock Coring E E Soil V appr E Moisture Content E Grain Size Samnles SER Condition Project Advanced Close Help Next add two additional fields to the Query Conditions Locate and click on the Result values field Drag this field into the blank conditions field under the first Expression column The selected field will be added automatically to the Query Conditions For the Operator select the gt from the combo box And then for the second expression type 5 Finally repeat these steps for the Result units
53. map project e Layer Information Displays the projection system for the selected layer 39 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 Is an air photo of the site which is a helpful visual aid to relate station locations to land features Some Station Groups and queries have been loaded as a new map layer each represented by a unique symbol There are several Cross Section lines digitized on the map this feature will be discussed in further detail in the next section There Is also a color shading layer representing the topography of the area as well as contour lines of the elevations 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 select the radio button in the dialog that appears TCE Exceeds 5mg kg from the list of data queries OK OK on the Set Field Precision dialog box Hydro GeoAnalyst allows you to set the precision of numeric attributes when importing shapefiles or creating map layers trom HGA data his feature is useful when displaying numeric data on a map using the label renderer and only a certain number of decimal places is desired in the displayed data
54. on and interval information for the Station Intersecting Layers When viewing an individual cross section 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 Settings Cross Section The following dialogue will appear Intersections with Cross Section Lines TCE Contour Map Result Val sample Elevation contours ELEVATION sample LroseSechionLineS name Sample Major Railroads VEJECTIO Sample Water Courses VEJECTIO Sample DK Cancel FJ Help Click on the symbol in each layer to customize the display OK to close the dialog Cross Section tab in the Map window to return to the Cross Section editor Create Topography Lines from Surface Layers To view an example of this feature beside HH The cross section will now appear as shown in the screenshot below 50 T wevn tm ZB w w 2 5 mm 7 ms mm xo x mo ES This shows a discrepancy between the topography layer and the data entered In the database for the station i e the elevation field in the station table and could be used to validate your data In this case it may mean the elevations for the station may need to be re surveyed t 885 8 30702 Display Borehole Log Plot The Cross Section Editor allows you to display borehole log plots directly on the selected cross section Us
55. on beside Isosurface Properties Now return to the Plume Browser tab in the Navigation tools Change the display type from Isosurface to ColorMap Colormap on XY Plane from the Style combo box Use the Slider bar and set the Position to 50 as shown below Rade 3491 Laa Potem 2 l pne E ee Hnrai N al 0 Pies BTID Concent a Diyan 5 di Prise Sore PES ZED SHA aoa m zY Here Poston D baala Wibe l Tere Lelong Le Play select the Wh utton to start the animation Observe the animation of the plume for a few seconds Note the time label at the top of the 3D window that shows the corresponding time interval Stop select the U button to stop the animation Change the colormap display type Colormap on X Plane from the Style combo box Now you will animate the position of a colormap but at a fixed time Interval Time tab on the Navigation Toolbars Use the Slider bar set the time to near the end of the animation 12 1 2000 H paise Shut Ligh Position Tome Pinta Dna e E o ke o V Ee L 1 1 L ga i Plume Browser tab on the Navigation Toolbars Time check box to disable this option Browser check box to enable this option Obl ajo Options Browser Time 59 Play select the Puro to start the animation Observe the animation of the colormap for a few seconds In this scenario the color map position will be animated through the entire site domain in a loop for a fixed time
56. patial orientation of your groundwater or borehole project data some of the key features of the Map Manager are listed below Effortlessly load query or station group data from the project Import open a vast array of basemaps for your projects including o Bitmap BMP DIB JPEG JPG Tiff TIF TFF TIFF MrSID SID AutoCAD Files DXF DWG o Shapefiles SHP Import Open surface files DEM Surfer Grid and ESRI ASCII Quickly georeference raster image maps to match your project data coordinates Create various map layers from station data and query results View maps at different scales Edit map layers label and symbol properties order style color Draw polygons circles lines points Create a legend and scale for the Map Project Add descriptive text using Windows true type fonts and symbols View statistics for selected data or a group of stations Measure distances on the map Export Map view as Raster images Define single or multiple cross section lines on the map Label and symbol renderer allows for creating color ramps gradients shading etc Interpolate any data layers and save the interpolated gridded data to file Create contour lines and color shading layers Display grid lines graticule on the map Display time series plots linked to stations on the map Send maps to the Report Editor for inclusion with the report template O O O O 38 In this example you will open an existing map project and then load several data q
57. roup will be printed to a slide in a PowerPoint presentation so you can simply print them out lf you would prefer to customize your own template you can build it yourself by simply adding a query to a base printing template e Print to Excel Push your HGA queries and data tables to Excel templates for quick and easy printing You can also push HGA queries to Excel templates for charting your time series data all ready for printing All Excel templates are easily customized by you e Start Page When first launching HGA 2013 we have added a Start Page to help you do common tasks such as creating a new project or opening an existing project even installing the Demo Project There Is also a lot of valuable information such as what s new in the latest version links to online resources Including how to videos to help you learn about the new features more quickly and links to our Technical Support staff to make It easier to ask questions and report Issues e Updated Query Builder Our new Query Builder has been redesigned to make it easier for you to generate queries You no longer need to manually trigger SOL statement generation Instead we do that automatically as you design your query We also added Intellisense to assist you to write out your own SQL statements Updated List Editor We have revised the List Editor which now includes a data model tree to make It easier to find the database field you want to
58. rt Wizard offers step by step guidance for creating report templates e Dynamic linking of reports to HGA data and components make creating reports easy e Customize reports to meet regulatory report format requirements e Easy to use Report Designer environment makes creating report templates a snap Explorer and Property Tool Boxes offer complete flexibility for e Formatting objects alignment and distribution Inserting standard footer and headers including logos Adjusting text color font style size location Defining column row and field heights Create an unlimited number of report layouts and save for future use Incorporate data values time series graphs log cross sections 3D views etc Define page and printer setup Preview the complete report prior to printing Provides Barcode control Allows report bookmarks and Internet hyperlinks Export final reports to e Portable Document Format PDF Rich Text Format RTF Web ready Hypertext Markup Language HTML Microsoft Excel TM XLS Tagged Image File Format TIF Plain Text File TXT This concludes the Demo Project Guide 62
59. ta Query Data Filter S gt 8 Collapse Expand Id 4 24 td d X a P E D EQ Station Groups ID StationName Xm Yim Elevation m TOC m Station Type m E AD All Stations TN za a arer ee MWe 4814315 00 Observation Well E reholes with plot data Lab QC Stations MW 3 i 4814036 00 332 10 Observation Well A Monitoring Wells Ow 2 4814905 00 330 90 Observation Well QC Monitoring Wells 4 Ow 4 481482600 331 60 Observation Well Soil Borings W 05 4814637 30 332 00 Observation Well kater W 06 4814704 90 331 80 Observation Well lay thicker than gt lt P neram VL07 535476 10 481478110 331 90 Observation Well 33 23 Station Data j w 08 53546950 4814652 70 331 60 Observation Well H A Queries w 09 53548470 4814546 50 330 90 Observation Well c9 10 Time Series Plots VOD 53562680 T 481465290 330 50 Observation Well 99 Crosstabs 17 vet 53554590 481455350 333 10 Observation Well a ag i wei2 53563770 481458290 331 20 Observation Well 0 54 Cross Sections W 13 535800 00 4814637 50 330 90 Observation Well MR 3D Views T w 14 53567460 481480000 331 40 Observation Well F Reports 1 W 15 53568740 4814665 30 331 50 Observation Well 1 VDE 53539000 4814741 90 330 90 Observation Well W 17 53557740 481447710 330 30 Observation Well DST 53567710 T 4814416 20 33150 Observation Well VOS 53558450 481430000 330 90 Observation Well W 20 53559970 481437180 331 20 Observation Well WET 53549290 481447720 332 10 Observation Well 22 W 22 535635 20 3
60. te Systems e Seamless data validation and error checking during data import with the option to accept or reject selected records during import e mporting new stations and group them as desired e Each data transfer configuration Is saved for future use Hydro GeoAnalyst now supports different Windows regional and language settings Including the comma decimal delimiter numeric format as well as various date formats e g DD MM YYYY In this section you will see how data Is organized in the HGA database First load the Boreholes Station Group Boreholes under the Station Groups node in the Project Tree GB 01 highlight this row in the Station List 12 The Station List tab provides only the data stored within the Station table To see the additional data belonging to this station you must view the Station Data tab If you have rearranged your tabs you can now view these 2 tabs at the same time Hydro GeoAnalyst Demo Project Project g Modules Database Help HO DN z UP 0 6 d a A Project Tree Station List Data Query Data Filter Well Profile 18 i Collapse Expand ld 4 24 of 151 gt pi oP gt 4 fal ER 8 o Station Groups ID Station Name Xm Y m Elevation m TOC m Station Type m bhip_intervals All Stations Al E
61. tes The Project Tree can be easily expanded to see all the nodes and entities of the Demo project To expand the entire tree select the Expand button on the Project Tree tab Take a moment to inspect the items under each node in the Project Tree Station Groups In HGA 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 including e All Stations e Boreholes e Monitoring Wells e Soil Borings 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 Hydro GeoAnalyst Demo Project Project g Modules Database Help EE Pads Ar SO A Project Tree _ Station List Station Data Data Query Data Filter Well Profile Collapse Expand 1 f3 gt gt i d X h F ED E o Station Groups ID Station Name Xm Y m Elevation m TOC m Station Type m All Stations Al Al Boreholes gt W 05 535548 40 4814637 30 331 000
62. the Map Manager Cross Section select 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 similar to the figure shown below O Mop Project She map TE Roo e s B lop BFF aRe OCT x 3 x NZ E xo 7 mo we ns T wern im 15 ZR mM w o Ms Mm m n 48 The Cross Section Editor window contains the following Items e Menu Bar Contains program menu commands e Toolbar Contains 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 e Coordinates Displays the X Z co ordinate for the current mouse cursor location e Active Window Select between the Map Manager window and the Cross Section Editor window In the Site Map project the cross sections have already been defined for you However It Is a 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
63. tiple fence diagrams Finally use the AVI recording tools to record the auto rotation of the 3D fence diagrams for presentation purposes some of the key features of the HGA 3D Explorer are highlighted below Render colortul high impact 2D 3D views of any number of cross sections Views cross sections as geologic hydrogeology or model layers Display contaminant plumes in the form of color maps or isosurfaces Simultaneously view boreholes with lithology and cross sections in full 3D Auto rotate the model image around the X Y Z axis Record and save animations during auto rotation Import grid files containing water table elevation geologic surfaces or topography Import and overlay basemap DXF BMP Drape maps over any selected surface e g drape bmp file over ground surface set any vertical exaggeration factor Display legend relating soil names and patterns Assign various objects as transparent Save configuration settings e g white background black axis etc Export 3D view to image format JPG GIF BMP send 3D views to the Report Editor to be included in reports Copy 3D window to clipboard 54 In this demonstration you will select a few cross sections from the Site Map map project and load these into 3D Explorer From the Cross Section Editor View View 3D from the main menu or select the button from the toolbar The following dialogue will appear Export to 3D Explor
64. to display in the query results To do so locate and click on the Chemicals 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 23 Query Builder jd amp S EE Data Query gn SOL View Preview Select a Query Display Fields TCE Esceeds mg kg a Puneton lEn l is id Description station Y station y al Geologic Description station geo point Geo Pont H Well Construction ztation name name Station Group Query Soil Testing v soil result chemical Chemicals Soil Sampling E Soil Sample Soil Result E Sample IL Result Values Result Units SI eS Jt Tt Map BHLP Plot and Plume Ready Use current projection system Reporting Detection Limit Sampling Precision Conditions Fraction Code een aai a T E Analysis Method E soll result chemicals Trichloroethylene so resultresul values gt 5 so resultresul units mg kg Qualifier Comment E Rock Coring E Soil V appr E Moisture Content E Grain Size Samnlas Sauce Condition Repeat this for the Result_values and Result_units fields Once the fields have been added the Query Builder display should be similar to the one shown in the figure below 24 Query Builder DEHRA Bere Station Group Query 2 Data Query gn SQL View Preview Select a Query Display Fields TCE_Exceeds_5mg_ka a union Eapression ge i ey a id station
65. ueries that were described In the previous section First before proceeding ensure that you are viewing the main window of HGA Then to load the Map Manager expand the Map Projects node of the Project tree Site Map double click Once the Map Manager window is loaded the display should be similar to the one shown below Map Project Site map Project Layer Edit Tools View Select Settings Help Demak 286 Ne AlO L KI EES dal K DAI SI 4B deyy Boreholes All Stations TVOC Exceeds 5001 al F Elevation contours 5004 1 2 1996 Topography 356 0289 WO_Data o ka E x 4 a xl CrossSectionLineS Airport color bmp Regional Layers 4 a q Grasslands OO i e mm C E E l gt Trees F L ts ik ijt N Gs e os e LA N 4 4 e A TA 7 P U A E e Urban Areas F eS d I r Ss o U Major Railroads VT Water Courses PY N T a z 7 E R n a a Airports 1 os foot vars 7000 AL 4 16 1996 4 Layer Information Station Layer Coord GCS WGS 1984 Datum D WGS 1984 Unit Degree Feature Counts 44 NAD 1983 UTM Zone17N 536 254 4 815 461 1 8 262 The Map Manager window contains the following elements e Menu Bar Contains 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

Demonstration Guide - swstechnology.com archive

Contents

Download Pdf Manuals

Related Search

Related Contents