1 / 40

Gathering, Managing, and Displaying Soil Data Using Automated Tools

www.geotech.com. Gathering, Managing, and Displaying Soil Data Using Automated Tools. Dr. David W. Rich drdave@geotech.com. Atlanta, GA April 28, 2013. High Level View of the Process. Plan your sample events. Store in a robust repository. Analyze and display data.

tmccloud
Download Presentation

Gathering, Managing, and Displaying Soil Data Using Automated Tools

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. www.geotech.com Gathering, Managing, and Displaying Soil Data Using Automated Tools Dr. David W. Rich drdave@geotech.com Atlanta, GA April 28, 2013

  2. High Level View of the Process Plan your sample events Store in a robust repository Analyze and display data Manage field and lab activities Manage data and quality It’s all in one location www.geotech.com

  3. Environmental Data and the “Cloud” www.geotech.com

  4. Environmental Data and the “Cloud” www.geotech.com

  5. Introduction www.geotech.com

  6. Planning Your Sample Events Entering stations www.geotech.com

  7. Container Labels www.geotech.com

  8. Planning the sample event www.geotech.com

  9. Gathering Field Results www.geotech.com

  10. Cloud-based log data entry Gathering Boring Log Data Images courtesy of LogItEasy.com www.geotech.com

  11. Gathering Continuous Data Gathering continuous downhole data Images courtesy of www.geotech.com

  12. Gathering Soil Samples www.geotech.com

  13. Specifying Import Options Import Wizard www.geotech.com

  14. Quality Control - Consistency Checking www.geotech.com

  15. Quality Control - Validation www.geotech.com

  16. Quality Control - Validation Summary www.geotech.com

  17. Bulk Data www.geotech.com

  18. Storage and Retrieval - Selection and display www.geotech.com

  19. Display Options Determine How Your Results Are Displayed Example options: • Regulatory limits • Values and flags • Unit conversion • Date display • Calculated parameters • Non-detects • Significant figures • Graph display options • Custom queries www.geotech.com

  20. Database OutputExamples - Graphs www.geotech.com

  21. Report Examples Reports ** edited www.geotech.com

  22. Database OutputExamples - Graphs www.geotech.com

  23. Storage and Retrieval - Selection and display Web Output

  24. Storage and Retrieval - Selection and display Web Output

  25. Generating Output www.geotech.com

  26. Excel Export www.geotech.com

  27. Display Using GIS • You need a base map or image • Sample locations must have coordinates • And both have to match • GIS software like ArcGIS makes the maps • Specialized software can make environmental-specific displays • Integration between the EDMS and the GIS can save time and improve quality www.geotech.com

  28. Add to the GIS as XY data Define display parameters Display Using ArcGIS www.geotech.com

  29. See Results on the Screen Note non-detect exceedence www.geotech.com

  30. Crosstab Callouts From the Database www.geotech.com

  31. Soil Borings with Values from the Database Benzene (mg/kg) Lithology Benzene (ppm) www.geotech.com

  32. Time Sequence Graphs on the Map www.geotech.com

  33. Radar Plots and Contours on the Map www.geotech.com

  34. Managing and DisplayingSite Geology • You might want to assign geology and lithology to each physical sample • This makes it easy to tie the geology to field and lab data • Or store formation “tops” by location independent of the samples • This probably better represents the actual site geology www.geotech.com

  35. Voxler Example www.geotech.com

  36. Enviro Insite Examples

  37. Benefits of better data management Decrease overhead - One industrial company was able to save $12,000 per year on just one project by moving the data management tasks to a much less expensive clerical person. Lower operating cost - Another used data management to get their regulator to approve less-frequent sampling intervals for about two of their wells per year, resulting in a savings of $9,000 each year, cumulative from year to year. Increase efficiency – For one organization, the 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 each project. An Indian tribe needed to make nine graphs/year for their EPA PM. With Excel, it took 3 months. With a database with integrated graphing, it took 10 minutes. Increase revenue - A consulting company client was able to use their Enviro Data software and expertise to land a $300,000 data management task from one of their clients.

  38. Conclusions • Environmental investigation and remediation projects are inherently complex • Efficient data management can reduce cost and improve quality • Implementing a centralized data management system makes sense for most environmental projects • Tools to do this are affordable and have a high return on investment • Is it time to retire your spreadsheet? www.geotech.com

  39. Relational Management of Site Environmental Data Enviro Title Slide Display and Analysis of Site Environmental Data www.geotech.com

  40. www.geotech.com Gathering, Managing, and Displaying Soil Data Using Automated Tools Dr. David W. Rich drdave@geotech.com Atlanta, GA April 28, 2015

More Related