DIGGS Digital Interchange for Geotechnical and Geoenvironmental Specialists

DIGGS Digital Interchange for Geotechnical and Geoenvironmental Specialists Presentation to Trans. XML Workshop December 9, 2013 Marc Hoit, PI, NC State University FHWA Pooled fund study TPF-5(111) Robert Schweinfurth, PI, ASCE Geo. Isntitute Ohio DOT Grant

Caltrans Experience 30, 000 project files 2 million documents 300 projects/year 80 years of data Difficult to access information

Ohio DOT Experience 20 -30 person hours per week to retrieve information

DIGGS Evolution p Pooled Fund Study to create DIGGS n n TPF-5(111), started 2005 (run by Ohio DOT) Merger of existing XML standards: COSMOS standard (CA, Earthquake group) p AGS standard (UK) p FDOT/UF Pile standard p n n n GML Compliant (International Geo-Spatial XML standard) Version 2 to be final result from study (June 2012) Partners: USGA, EPA, COSMOS, AGS, UK-HA, UF, GINT, Key. Netix, State DOTs, FHWA, Earth. Soft

The HA Geotechnical Data Management System (HA GDMS) p p Internet-based GIS Stores data on: n n p spatial context (mapping and aerial photos) assets reports boreholes Supports UK AGS data transfer format n n n data storage/retrieval summary logs summary test sheets

HA Milestones UK Spec for GI (SISG Pt 3) AGS 3. 1 AGS M AGS 3 AGS 2 AGS 1 AGS Implementation Timeline Increased adoption by UK industry Revised GI Spec (draft) HA Specification requires AGS 2 HA Standard requires AGS data HA GDMS goes live HA GDMS update improve AGS data handling

Florida FDOT Geotechnical Database p Bridge Software Institute (BSI) has developed three unique pieces of software that can access the database p n n n FB-Deep Pile Technician Database Spreadsheets

Example of In-situ spreadsheet

The DIGGS Advantage Data Acquisition DI S GG DI Software Applications GG Database S DIGGS Data Review And Processing

Key Activities p Borehole Data n n Point Location Drilling Operations

Key Activities p Borehole Data n SAMPLES!

Data TRANSFER Site Information p Depth Information p n n n Field Lab Testing Soil and Rock

Data TRANSFER p Lab Data (results and/or test data)

Logs and Log Data p Electronic / Paper

Data TRANSFER p Borehole data n n From field to office Intraoffice (among software) Interoffice (among staff) From office to External

QC/QA Testing PDA/CAPWAP p O-Cell/SLT p

Sensor Data Manual p Automated p

Cost Savings Ohio DOT: Florida DOT: 10 -15% fewer borings per bridge Missouri DOT: Fewer borings saving $250, 000 - $500, 000 on one project Missouri DOT: 10 -20% less drilling, savings $12 -24 M per year $81, 000 savings per year in boring log preparation by using electronic data entry in the field California DOT: 20% savings ($200 k/year) with laboratory data management system implementation

Samples, Cores and Specimens 12345678452 1. 00 B 1 tests are preformed on a specimen 12345678452 1. 00 1. 00 Soft brown Clay 23 -

12345678452 12345678452 Laboratory Tests 12345678452 8452 1. 00 1. 00 Soft brown Clay 23 Tests then hang off specimen 23 <--- who tested, checked and QAd it etc <--- BS xxxyyy clause 2 -

Example 2 – Sample Taken from an Exploratory Hole, tested for NMC, LL and PL Real World Data Construction Project locations Sample collected from exploratory hole “FIELD”Hole ID = ABCD-1 samples Sample Sub-samples created in laboratory “LAB” ID = ABCD-12 Source = ABCD 1 ID = ABCD-123 Source = ABCD-12 Project ID = ABCD-124 Sample Source = ABCD-12 samples Sample ID = ABCD-12 Source = ABCD 1 Sample ID = ABCD-123 Source = ABCD-12 Sample Moisture. Content ID = ABCD-124 Source = ABCD-12 laboratory. Testin g ID = ABCD-12345 Source = ABCD-123 laboratory. Testin g 105 ° ID = ABCD-12345 Source = ABCD-123 Subsample tested for NMC Subsample tested for LL Subsample tested for PL ID = ABCD-23456 Source = ABCD-124 ID = Atterberg. Limits ABCD-23456 Source = ABCD-124 Moisture. Content Atterberg. Limits

Example 5 – Sample Taken from an Exploratory Hole, tested by 3 stage, 3 sample triaxial test Real World Data Construction Project Linkage s Hole ID = ABCD-1 locations Sample collected from exploratory hole Sample from Hole ID = ABCD-12 Source = ABCD -1 ID = ABCD-1 Sample from Sample samples Sample Three sub-samples created in laboratory ID = ABCD-12 Source = ABCD 1 ID = ABCD-20 Source = ABCD 12 ID = ABCD-123 Source = ABCD-20 Sample ID = ABCD-124 Source = ABCD-20 Sample ID = ABCD-20 Source = ABCD -12 Compressive. Streng th ID = ABCD-1234 Source = ABCD-20 Sample from sample ID = ABCD-123 Source = ABCD 20 ID = ABCD-125 Source = ABCD-20 Compressive. Streng th. Detail ID = ABCD-12345 Source = ABCD-123 Sample from sample ID = ABCD-124 Source = ABCD 20 laboratory. Testin g Compressive. Streng th Sub-samples tested in triaxial compression ID = ABCD-12345 Source = ABCD-123 ID = ABCD-23456 Source = ABCD-124 ID = ABCD-34567 Source = ABCD-125 ID = ABCD-1234 Source = ABCD-20 Compressive. Strength. Det ail Compressive. Streng th. Detail ID = ABCD-23456 Source = ABCD-124 Sample from sample ID = ABCD-125 Source = ABCD 20 Compressive. Streng th. Detail ID = ABCD-34567 Source = ABCD-125

Example 7 – Geoenvironmental: Field Quality Control Samples Real World Data Construction Project Borehole with well installed Hole This is one example of a considerable number of complex examples that have been considered ID = DMDC-BH 1 Sensors Installation water level ID = DMDCBH 1 W Samples standard sample ID = DMDC-BH 1 W_20070613 Source = DMDC-BH 1 W duplicate sample Sample ID = DMDC-BH 1 W_20070613 b Source = DMDC-BH 1 W Sample groundwater samples Sample ID = DMDC-TB 1_20070613 trip blank sample Groupings duplicate groundwater samples Group ID = DMDC-GROUP_1 ID = DMDC-BH 1 W_20070613 b duplicate group Group trip blank sample trip blank group ID ID = = DMDC-GROUP_2 DMDC-TB 1_20070613 DMDC-BH 1 W_20070613 b

http: //diggsml. com – Website

DIGGS Current Status p DIGGS Version 2. 0α - July 2012 n n Update of Data Dictionary Update of Schema Creation of “DIGGS to Excel” Tool DIGGS Website Update

DIGGS Implementation p ODOT Contract with Geo-Institute-2 years n p October 2013 – October 2015 Goals of Contract n n n Finalization of DIGGS Schema standard from 2. 0α to 2. 0β and Public Release of DIGGS 2. 0 Transition of ownership to Geo-Institute Development of Long Term Business Plan and Management Structure

DIGGS Implementation p Engagement of DIGGS Advisory Board p Survey of DIGGS User Community p DIGGS Training Materials p Pilot Testing of DIGGS 2. 0α n p State DOTs & EPA, Software/Hardware Vendors, Federal Agency Update XML Schema and Data Dictionary

DIGGS Implementation - Tools p Refining of existing “DIGGS to Excel” p AGS 3. 1 to DIGGS p Excel/Web Form to DIGGS p Validation