odot geotechnical data management system
TRANSCRIPT
![Page 1: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/1.jpg)
Project OverviewProject Overview
Kirk BeachOhio Department of Transportation
Office of Geotechnical EngineeringGeology and Exploration Section
ODOT Geotechnical Data Management System
![Page 2: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/2.jpg)
Project GoalsProject Goals
Development of a web-based GIS enterprise system for geotechnical data– Capable of serving the broad needs of
practicing geotechnical professionals– Enable internal and external customers access
to search, input, and export geotechnical information
Flexible to allow for future inclusion of new “modules”
![Page 3: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/3.jpg)
Major Components of the SystemMajor Components of the System
Electronic conversion of the historical geotechnical archivesManagement of current geotechnical dataPresentation of boring logs and laboratory testing resultsInventory and ranking of geohazard sitesRemediation cost database and application
![Page 4: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/4.jpg)
Major Components of the SystemMajor Components of the System
Geologic Site Management ProgramInstrumentation and monitoring of high risk geologic sitesGeotechnical support for construction projectsOperations and Maintenance reportingStructural Engineering support
![Page 5: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/5.jpg)
Major Components of the SystemMajor Components of the System
Geotechnical researchSoftware application interfacingWeb portal for a GIS-based enterprise system
![Page 6: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/6.jpg)
Team/ResourcesTeam/Resources
Participants– Federal Agencies: FHWA, ACE, USGS– State Agencies: OhioEPA, OhioDNR– Local Government: City & County
Engineers– Consultants– Academia
![Page 7: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/7.jpg)
Initial StudiesInitial Studies
Synthesis Study with FHWA– Practices by DOTs– Management Systems used in the UK
Needs Assessment (November, 2004)
– Justification– Begin formulation for the system
![Page 8: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/8.jpg)
AssessmentAssessment
![Page 9: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/9.jpg)
Major DiscoveriesMajor Discoveries
Oracle database with Oracle Spatial for main engine gINT for borehole logging and graphic presentation of logsESRI product for GIS applications with 3D Analysis Falcon for document management Equis for data management
![Page 10: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/10.jpg)
Geo
tech
nica
l Dat
a G
eote
chni
cal D
ata
Man
agem
ent S
yste
m
Man
agem
ent S
yste
m
![Page 11: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/11.jpg)
Data vs. DocumentData vs. DocumentProject Information
Web Application
Documents Geotechnical Data
Spatial Data Associated Spatial Data
![Page 12: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/12.jpg)
Document Management SystemDocument Management System
Goal: To develop a web-based GIS enterprise system for geotechnical data
Capable of serving the broad needs of practicing geotechnical professionals
Enable internal and external customers access to search, input, and export geotechnical information
![Page 13: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/13.jpg)
DescriptionDescription
Card Files – Database
![Page 14: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/14.jpg)
DescriptionDescription
Card FilesProject Boxes
![Page 15: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/15.jpg)
DescriptionDescription
Card Files Project BoxesPlan SheetsProject Files
![Page 16: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/16.jpg)
Scan
ning
Ref
eren
ce
![Page 17: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/17.jpg)
Document Scanning ProjectDocument Scanning ProjectOriginal Estimates (Documents in Warehouse)– 1.5 million 8.5” x 11” documents– 50,300 24” x 36” plan sheets– Value = $500 million
Revised Estimates based on ongoing project– 1.07 million 8.5” x 11” documents– 72,000 24” x 36” plan sheets– Additional 25% “Do Not Scan” (duplicates,
severe damage, etc.)
![Page 18: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/18.jpg)
Document Scanning ProjectDocument Scanning Project
Current StatusWarehouse scanning 82% completeAssessment of District documents complete (est. 800,000 documents)Perform District scanning pilot project
![Page 19: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/19.jpg)
![Page 20: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/20.jpg)
Indexing DocumentsIndexing Documents
Example of Searchable Fields– County– Route– Mile Post– Document Type– Top of Rock
![Page 21: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/21.jpg)
Document Management SystemDocument Management System
![Page 22: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/22.jpg)
![Page 23: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/23.jpg)
![Page 24: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/24.jpg)
![Page 25: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/25.jpg)
1. Minnesota DOT…savings of $20k per year in personnel time to look up borehole information
2. Missouri DOT…savings of $81k/year by implementing electronic field data entry; $20k/year in drilling by utilizing historic data
3. Florida DOT…savings of $250k to $500k in subsurface investigation on a single I-595 project by using existing data
What is the economic value?
![Page 26: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/26.jpg)
4. Ohio DOT…savings of $12M to $24M by using previously collected subsurface exploration data
5. United Kingdom Highway Agency has saved 80% of slope repair cost through proactive maintenance made possible by GDMS
What is the economic value?
![Page 27: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/27.jpg)
Future GoalFuture Goal
Can documents have a spatial component?
– Geo-referencing Documents
![Page 28: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/28.jpg)
![Page 29: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/29.jpg)
![Page 30: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/30.jpg)
Drilling Request SystemDrilling Request System
![Page 31: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/31.jpg)
![Page 32: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/32.jpg)
![Page 33: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/33.jpg)
![Page 34: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/34.jpg)
ODOTODOT’’ss Drilling ProgramDrilling Program
GPS Data Compilation– Decimal degrees for Lat & Long– Elevation Dilemma
Use of PDA or PC TabletsDoIT working with MicroSoft– Standards for Tablet and Software
• Due: Oct 24th, 2007
![Page 35: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/35.jpg)
Ohio DOTOhio DOT
Specifications for Geotechnical
Explorations
http://www.dot.state.oh.us/geotechnical/SGE/
![Page 36: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/36.jpg)
Modifications to the SGEModifications to the SGE
Reflect the new standards Implement Electronic Data Deliverable (EDD) Identify the requirements for the electronic submission of data
![Page 37: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/37.jpg)
Geotechnical Management System (GMS) Objective:
Develop geotechnical and geoenvironmental data exchange standards.
Hence… TPF-5(111), Development of Standards for Geotechnical Management Systems
The name of these standards is
Data Interchange for Geotechnical and Geoenvironmental Specialists (DIGGS)
DIGGS: Transportation Pooled Fund Project
![Page 38: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/38.jpg)
Geotechnical Management System Group:
• 11 State DOTs• FHWA• USACE• USGS• USEPA• UK Highway Agency
![Page 39: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/39.jpg)
Geotechnical Data Coalition Group:
• University of Florida• Association of Geotechnical & Geoenvironmental
Specialists (AGS)• Construction Industry Research and Information
Association (CIRIA)• Consortium of Organizations for Strong Motion
Observation Systems (COSMOS)• FHWA• Ohio DOT• Special Interest Group Managers (SIGs)
![Page 40: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/40.jpg)
• Borehole data• In-situ tests• Laboratory tests• Borehole geophysics• Deep foundations
DIGGS v1.0
![Page 41: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/41.jpg)
<sample gml:id="bf6615a0-6a74-11da-8cd6-0800200c9a66"><gml:name codeSpace=“keylab1">12345678452</gml:name> <depthTop uom="m">1.00</depthTop> <type>B</type> <reference>1</reference> <specimen> tests are preformed on a specimen
<gml:namecodeSpace=“keylab1">12345678452</gml:name>
<depthTop>1.00</depthTop> <depthBase>1.00</depthBase> <description>Soft brown Clay</description> <reference>23</reference> <remarks/> <subsamplingMethod></subsamplingMethod> <roles/> <description>-</description>
</specimen></sample>
DIGGsDIGGs
Parent – Child Folder Relationships
-Project-Borehole
-Sample-Speciman
-Test-Analysis
-Result
![Page 42: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/42.jpg)
Laboratory Information Management SystemLaboratory Information Management System
Assessment by University of Akron– Assess current hardware and software– Assess software requirements
• Determine Research NeedsStart with Drilling– PC Tablet & Software
• Interface with gINT– Sample identification
Laboratory– Testing work station
Presentation in Geotechnical Reports & Plans
![Page 43: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/43.jpg)
Geologic Hazards ProgramGeologic Hazards Program
Abandoned Underground MinesRock Falls LandslidesCost Remediation Application & Database
![Page 44: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/44.jpg)
![Page 45: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/45.jpg)
![Page 46: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/46.jpg)
Remediation Cost Database and Remediation Cost Database and WebWeb--Based ApplicationBased Application
Geohazards
![Page 47: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/47.jpg)
Types of Data Stored in RCDATypes of Data Stored in RCDA
Sites– Roadway locations
requiring remediation
Plans– Each site may have
several plansScenarios– Each plan consists
of one or more remediation method
Site
Plan
Plan
Plan
Plan Scenario
Scenario
Scenario
Scenario
ScenarioScenario
![Page 48: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/48.jpg)
List of Sites in AreaList of Sites in Area
![Page 49: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/49.jpg)
Variables for Remediation PlanVariables for Remediation Plan
![Page 50: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/50.jpg)
List
Pla
n S
cena
rios
List
Pla
n S
cena
rios
![Page 51: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/51.jpg)
1. United Kingdom Highway Agency has saved 80% of slope repair cost through proactive maintenance made possible by GDMS ($40M to $50M savings)
2. Proactive remediation of geohazards reduces the number of emergency projects and eliminated the 20% to 30% in construction costs associated with non-bid projects ($60M to $180M)
3. Reduction in liability by using “reasonable prudence” through a systematic approach to remediate geohazard with limited funding.
What is the economic value?
![Page 52: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/52.jpg)
““A key element in a successful A key element in a successful system is the ability to easily and system is the ability to easily and efficiently share geotechnical efficiently share geotechnical data.data.””
((EarthSoftEarthSoft, 2007), 2007)
![Page 53: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/53.jpg)
What Does Our Future Hold?What Does Our Future Hold?
![Page 54: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/54.jpg)
Data Management SystemData Management System
Pilot Project– PC version of Application– Testing
Enterprise Application
![Page 55: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/55.jpg)
DIGGSDIGGSXML/GMLXML/GML
FileFile
1. Intelligent Data Entry Form (IDEF) that creates DIGGS format data files
How is EarthSoft Implementing DIGGS?
![Page 56: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/56.jpg)
Valid value not found,select correct value from
pull down menu
Required field not populated,
make correction
Errors highlighted
EDDs with errorshighlighted
2. The EQuIS Data Processor (EDP) will check DIGGS files, applying validation rules
![Page 57: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/57.jpg)
DIGGSDIGGSXML/GMLXML/GML
FileFile
3. EQuIS will import DIGGS files using EDP
EQuISData
Processor(EDP)
EQuIS
![Page 58: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/58.jpg)
4. EQuIS will export data in the DIGGS XML/GML format
How is EarthSoft Implementing DIGGS?
DIGGSDIGGSXML/GMLXML/GML
FileFileEQuIS
![Page 59: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/59.jpg)
?
??
?
? ?
LIMs
![Page 60: ODOT Geotechnical Data Management System](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a6a5801a28abe72e8b4610/html5/thumbnails/60.jpg)
Questions?Questions?