Environmental Data White Paper- Brochure

The New Industry Leader in Environmental Database Management SolutionsA Flexible, Easy-to-Use Program For Storing and Displaying Environmental Quality DataPress Page Down to advance the slidesFeaturingwww.geotech.comYour situation ...The solution …Geotech will help you better manage your project data from start to finish with software that is easy to learn and useThis will let you:Reduce your expensesGain a competitive advantageIncrease your revenueIntroductionOrganize your project data with Enviro DataSave time in sampling, analysis, and reportingLab data checkingElectronic transfer of lab dataAutomated verification and validation assistanceStandard report generationCustomize reportsLaunch other software packages for site evaluation and displayIncrease your revenue by …Selling a data management plan to your clientBalancing the workload between officesAnd you won't need to invest much of your time and money to learn and use itGoing beyond the data…We bring you the expertise and support to create a company-wide standard database that is central to all your site data workflow applications - from the lab all the way to the regulatorsSchematicSometimes you need to see your data to answer a project questionOften it helps to see a graph over time to answer questions about contaminant movementOther times it helps to see a map of concentrations to help visualize the distribution of site contaminationOr perhaps you need a formatted report with limits to submit to your regulatorsAn interactive GIS map created with ArcGIS allows you to probe into the data at your facilityOr create a complete 3-D display using EVS for maximum impact in presenting your ideasAdd some perspective for better insight into spatial relationshipsThis stereo pair was created with the popular Surfer program using data from Enviro DataBoring logUse boring log software with Enviro DataFence diagramCreate cross sections and fence diagramsWhat do all these displays have in common?They were created using Enviro Data as a database - an easy to learn and use software package starting at just $2000Now we'll see how Enviro Data makes it easy to:Import data from labs and the fieldPerform validation if requiredView your data in the databaseGenerate reports Over 40 standard reports Customize these reports for project needs Create your own queries and reportsProvide data to other applications Export common industry formats Or connect directly to the dataSave time and money on your projectsIt starts with Enviro Data’s main menuJust point and click on what you want to doElectronic data entry and editingStart with our well-defined file formats: Full format with lab QC data Basic format with field QC data Simplified format for historical data And many othersThe client prepares their databaseThe client generates a reference fileThe lab tests the import using the reference fileThe lab delivers clean dataThe client performs the final importThe following figure shows these stepsEnviro Data’s closed-loop reference file system lets your labs check your data for consistency before they send it to you – a great time saverStep one is to gather the dataYour data can come from the field, the lab, or existing digital filesEnviro Data's Wizard-assisted import makes it easy to quickly and cleanly bring in digital data in different formatsOr you can enter and edit data by handData transfer standardData import starts with the Data Transfer StandardThe Data Transfer Standard defines the formats for electronic data deliverablesThis helps you obtain complete and accurate data from your laboratoriesAutomated CheckingThis example screen from the Import Wizard tells Enviro Data how to help you check and clean up your dataAutomated CheckingEnviro Data helps you overcome problems in the data being importedHere it is helping with a mis-spelled station nameStep two is to validate your dataEnviro Data provides a complete set of tools for managing the quality of your dataThis starts with consistency checking during import as shown earlierFor projects that need it, the next step is data verification and assistance with validation (called Validation in this presentation)Enviro Data has a powerful and flexible verification/validation systemThis screen helps you set up some of the validation criteriaThe Validation tool includes various statistical calculations and reportsThis is just one exampleStep three is to select and view your dataEnviro Data provides the easiest tools in the industry to retrieve and present your dataYou can drill down to a specific result in just a few mouse clicksOr you can use the Select Data screen to filter just the data you needThen use Enviro Data and its companion products to create exactly the displays you needTreeView is the quickest way to get to your dataExpand and contract branches like Windows ExplorerSee any result in the database in just three mouse clicksThe Select Data form gives you complete control over just what data is displayedDrop-down boxes help you easily make your selectionsEnviro Data tracks how many records you have selectedIt’s easy to use for people who aren’t database expertsBut powerful enough for power usersStep four is to generate reports and other outputAfter selecting your data, you can choose from a variety of output formatsEnviro Data has over 40 standard reports that you can use as-is or modify It can also display graphs, with regulatory limits if necessaryEnviro Data can even display your data on a map without an external mapping programNow you can get the most from your dataText reports are used for screen displayLook at the data, or copy it to the clipboard to paste elsewhereYou can reorder and resize columns, or change the sortingThis screen lets you select reports for printing Select from among dozens of useful report formats to see the data just the way you need it for your projectsThis is a cross-tab display with comparison to regulatory limitsYou can easily create this type of report for your regulatorsReport with Multiple Regulatory Limits 2This report shows comparison to multiple limits at one time.Groundwater Calculations and Graph 2This ground- water graph shows water levels and NAPL thickness along with a dissolved constituent (benzene). It shows marked seasonality in the data.Display options determine how your results are displayed You have complete control over: Regulatory limits for comparison Values and flags Unit conversion Date display Calculated parameters Handling of non-detects Significant figures Graph display options And much moreYou can save multiple display definitions for various needsAnd the choices you make apply to ALL of Enviro Data’s output options for consistency across all of your deliverables Enviro Data’s graphs help you better understand your data Enviro Data lets you graph multiple stations and parametersThe graphs scale automatically to fit your dataDisplay your selected regulatory limit if you wishEnviro Data's functionality can be easily expanded with your own custom queriesUse this capability to expand on Enviro Data’s existing functionality to suit your specific requirementsThis example query finds problem water samples where the sample top is less than the sample bottomAnyone can learn to use this standard Access query formUse the same tool that Geotech used to build Enviro DataEnviro Data gives you total flexibility to get just the results you needYou can even change Enviro Data’s standard reports to match specific project requirementsOpen the report in the Access design viewMake the changes that you need and save the new reportWith Enviro Data you get exactly the format you needMaking maps in Enviro Data is very easy Use a CAD drawing as a base map for each siteDisplay stations and values with user-defined cutoffsEasily see where site contamination is locatedStep Five is to use your data in other applicationsEnviro Data is the center of your data systemIt has many internal tools to display dataIt also has export formats for popular industry software tools that you may already have, such as Excel, Surfer, ArcView, EVS, RockWorks and othersOr, you can connect directly from many programs into Enviro Data without intermediate filesSupplying data for other applicationsYou can use Enviro Data as a data source for other applicationsThis can be done by exporting data to a file, or by connecting directly to your dataFirst we'll show you an example of exporting data and making a contour map in SurferThen we’ll show how to connect ArcGIS to data selected in Enviro DataFirst, use the Select Data screen to filter just the data you want - data for one parameter for one siteChoose output formatThen Enviro Data creates the data file for youNext, choose the output formatTell Enviro Data how to handle multiple values at the same locationChoose data file in SurferIn Surfer, choose the data file and specify how to grid the dataIf you want you can add a base mapThen choose the contour intervalDisplay contoursIn just a few seconds you have Surfer displaying a contour map of your data You can post the values and display the map in a variety of waysOther Surfer displaysHere are some examples of Surfer displaysAnd Enviro Data works with many other programs just as easilyEnviro Data helps you get the most out of the investment you have made in your dataWith ArcGIS you can connect directly to your Enviro Data databaseThen your data is displayed as a layer that you can manipulate as necessaryNote non-detect exceedenceTalk to Geotech about additional ArcGIS display capabilities coming soonThis example shows Stiff water quality diagrams located at monitoring wellsERPIMS and Other ExportsERPIMS (Air Force) export now completeGIS Key export also completeERIS (Army), NEDD (Navy) and SEDD (EPA) coming soonSurfer, EVS, Quicklog, GINT and others completeRockWorks/LogPlot coming soonConcurrent Use LicensingUsers can share licensesSave thousands over individual licensesCheck out licenses to take away from the networkAllows “occasional” license overuseBenefits of good data managementDecrease overhead - One client was able to save $12,000 per year on just this project by moving the data management tasks for a complex project from an expensive project scientist to a much less expensive clerical person. Since this project was being managed on a lump sum basis, this went straight to the bottom line.Lower operating cost - Another client was able to use their database system to identify monitoring wells where the constituents of concern were consistently below target levels. Each year their regulator approved less-frequent sampling intervals for about two of their wells, resulting in a savings of $9,000 each year, cumulative from year to year.Increase efficiency - Using the closed-loop reference file system, one data administrator reported that their time to process an electronic deliverable decreased from an average of 30 minutes to 5 minutes, resulting in an annual savings of $5,000 per year on that one project.Increase revenue - A consulting company client was able to use their Enviro Data software and expertise to land a $300,000 data management task. 20% of that went into data management technology, resulting in a $240,000 gross profit on that one task.About the CompanyFounded in 1986, worldwide clienteleProvider of software products and servicesEarth science and business clientsRecognized experts in environmental data management (we wrote the book)Focus on customer satisfactionStrong industry relationshipsHundreds of satisfied customersWoman-owned small businesswww.geotech.comWoman-Owned Small Business StatusGeotech is certified/listed as a Woman-Owned and/or small business with several entities:Currently certified or listed:U. S. Small Business Administration Pro-NetU. S. Dept. of Defense Central Contract RegistrationCity and County of DenverPending:Colorado Department of Transportation, othersGeotech - Some of our present and past clientsEnvironmental/Engineering - ARCADIS, CH2M Hill, Corporate Environmental Advisors, Inc., Delta Environmental, ECC, EG&G, ENSR, ERM, Environmental Systems & Technology, Foster-Wheeler Environmental, Hydrometrics, Inc., MACTEC Inc., Montgomery Watson Harza, Pacific Western Technologies, Scientech Inc., SECOR, Severn Trent Laboratories, Shaw Environmental, Shield Environmental, Waste Management, Weston Solutions, URSMining - ASARCO, Inc., BHP Utah, Inc., Kaiser Cement Company, Kennecott Copper Company, Newmont Exploration, Peabody Development Company, U.S. Borax Petroleum - Bass Energy, Inc., ChevronTexaco, Coastal Oil and Gas Corporation, ConocoPhillips, Coors Energy, Enserch Exploration, Inc., ExxonMobil, Gulf Oil Company, Kerr-McGee Corporation, Marathon Oil Company, Maxus Energy, Meridian Oil Company, Northwest Pipeline Corp., Shell Oil Company, Sinclair Oil Corp., Sun Exploration and Production Company, Union Pacific ResourcesAgricultural - ETS Laboratories, Farmland Industries, Louisiana Pacific Corp., Vineyard Investigations/TerraSpase, Western Farm ServiceGovernment - City and County of Denver, Colorado Geological Survey, Connecticut Dept. of Envir. Protection, Denver Water, Indiana Department of Envir. Management, Kansas Corporation Commission, Kansas Geological Survey, Kentucky Geological Survey, Lake County (FL), Los Alamos National Laboratory, Louisiana Dept. of Natural Resources, Miami Dade County (FL), Minerals Management Service, New York Geological Survey, States of California, Colorado, Connecticut, Tennessee, Texas Railroad Commission, U.S. Army Corps of Engineers, U.S. Bureau of Land Management, U.S. Bureau of Mines, U.S. Bureau of Reclamation, U.S. Department of the Interior, U.S. Department of Energy, U.S. Geological Survey, U.S. Social Security Administration, United Nations, Utah Geological Survey, Virginia Dept. of Waste Management, West Virginia Geological SurveyService Companies and Resellers - Schlumberger, IBM, Perot Systems, Scientific Software Group, Western GeophysicalEducation - Arizona State University, Bryn Mawr College, California State University, Colorado School of Mines, Georgia State University, Harvard University, Kuwait University, Ohio Weslayan University, Oklahoma State University, Smith College, State University of New York, Tulane University, Universities of Alabama, British Columbia, Colorado, Illinois, Kansas, Louisville, Michigan, Milan (Italy), Minnesota, Nevada Las Vegas, Oklahoma, Rhode Island, South Carolina, Tulsa, Wisconsin, Wyoming, Zimbabwe, Utah State University, Yamagata University (Japan)Native American - Blackfeet Tribe, Fort Peck Tribes, Southern Ute TribeUtilities - Virginia Power, Williams Pipeline/Transco Finally - answers to your environmental data management questionsThe Definitive TextNow available from Lewis Publishers / CRC PressCat. #: L1591 ISBN: 1566705916Relational Management and Display of Site Environmental Data provides you with the skills needed to effectively implement and operate an environmental data management system. The concepts covered can be applied to any system, from stand-alone through client-server to Web-based. This text/reference book combines the fundamentals of data management and display with the author's many years of experience to help you create your own data management system or more intelligently select and use a commercial solution.Conclusion - Enviro Data gives you the greatest return on the investment you have made in sampling, analysis, and reportingLab data checkingElectronic transfer of lab dataAutomated verification and validation assistanceStandard report generationCustomized reportsLaunch other software packages for site evaluation and displayIncrease your revenue by …Selling a data management plan to your clientBalancing the workload between officesAnd you won't need to invest much of your time and money to learn and use itContact Geotech (www.geotech.com) now to put Enviro Data to work for you