Development of Standards for Geotechnical Management Systems

Print
General Information
Study Number: TPF-5(111)
Lead Organization: Ohio Department of Transportation
Contract Start Date: Aug 10, 2005
Solicitation Number: 918
Partners: CA, CT, FHWA, GADOT, IN, KY, MN, MO, NC, OH, TN
Status: Closed
Est. Completion Date:
Contract/Other Number:
Last Updated: Nov 04, 2014
Contract End Date: Jun 30, 2008
Financial Summary
Contract Amount: $695,000.00
Total Commitments Received: $720,000.00
100% SP&R Approval: Approved
Contact Information
Lead Study Contact(s): Cynthia Jones
cynthia.jones@dot.ohio.gov
Phone: 614-466-1975
Organization Year Commitments Technical Contact Name Funding Contact Name Contact Number Email Address
California Department of Transportation 2005 $25,000.00 Loren Turner Osama Elhamshary Osama_Elhamshary@dot.ca.gov
California Department of Transportation 2006 $100,000.00 Loren Turner Osama Elhamshary Osama_Elhamshary@dot.ca.gov
California Department of Transportation 2007 $100,000.00 Loren Turner Osama Elhamshary Osama_Elhamshary@dot.ca.gov
Connecticut Department of Transportation 2006 $12,500.00 Leo Fontaine James Sime 860-258-0309 james.sime@ct.gov
Connecticut Department of Transportation 2007 $12,500.00 Leo Fontaine James Sime 860-258-0309 james.sime@ct.gov
Federal Highway Administration 2005 $40,000.00
Georgia Department of Transportation 2006 $25,000.00 Cyprian Fonge Supriya Kamatkar 404-347-0552 skamatkar@dot.ga.gov
Indiana Department of Transportation 2006 $25,000.00 Tommy Nantung 765-463-1521 ext 248 tnantung@indot.in.gov
Kentucky Transportation Cabinet 2005 $35,000.00 Will Holmes Marcie Mathews 502-564-3730 marcie.mathews@ky.gov
Kentucky Transportation Cabinet 2006 $35,000.00 Will Holmes Marcie Mathews 502-564-3730 marcie.mathews@ky.gov
Kentucky Transportation Cabinet 2007 $35,000.00 Will Holmes Marcie Mathews 502-564-3730 marcie.mathews@ky.gov
Kentucky Transportation Cabinet 2008 $35,000.00 Will Holmes Marcie Mathews 502-564-3730 marcie.mathews@ky.gov
Kentucky Transportation Cabinet 2009 $35,000.00 Will Holmes Marcie Mathews 502-564-3730 marcie.mathews@ky.gov
Minnesota Department of Transportation 2005 $25,000.00 Gary Person Lisa Jansen 651-366-3779 lisa.jansen@state.mn.us
Missouri Department of Transportation 2006 $10,000.00 Mike Fritz Jennifer Harper 573-526-3636 Jennifer.Harper@modot.mo.gov
Missouri Department of Transportation 2007 $10,000.00 Mike Fritz Jennifer Harper 573-526-3636 Jennifer.Harper@modot.mo.gov
Missouri Department of Transportation 2008 $10,000.00 Mike Fritz Jennifer Harper 573-526-3636 Jennifer.Harper@modot.mo.gov
North Carolina Department of Transportation 2006 $15,000.00 Mrinmay Biswas 919-508-1865 biswas@ncdot.gov
Ohio Department of Transportation 2006 $20,000.00 Cynthia Jones Jill Martindale 6146448173 jacquelin.martindale@dot.ohio.gov
Ohio Department of Transportation 2007 $20,000.00 Cynthia Jones Jill Martindale 6146448173 jacquelin.martindale@dot.ohio.gov
Ohio Department of Transportation 2008 $20,000.00 Cynthia Jones Jill Martindale 6146448173 jacquelin.martindale@dot.ohio.gov
Tennessee Department of Transportation 2005 $25,000.00 Stephanie Vincent 615.741.2203 Stephanie.Vincent@tn.gov
Tennessee Department of Transportation 2006 $25,000.00 Stephanie Vincent 615.741.2203 Stephanie.Vincent@tn.gov
Tennessee Department of Transportation 2007 $25,000.00 Stephanie Vincent 615.741.2203 Stephanie.Vincent@tn.gov

Study Description

A number of state and federal agencies are developing Geotechnical Databases which may be queried for information used for maintenance of existing projects as well as design, construction, etc. of nearby projects. Unfortunately, through the lack of a standard data definition for Geotechnical data, there exists significant difficulty in archiving, reusing and sharing data. This problem has been exacerbated with the dependence on computer software as the standard for design, construction, and maintenance of new and existing infrastructure projects. For instance, numerous computer programs have been developed to electronically collect and present geotechnical in-situ data by hardware manufacturers (i.e. CPT, PMT, etc.), as well as borehole/boring logs or fence diagrams. However, each software suite has developed its own data needs and formats. Some commonality exists in the definition of data through the use of standards such as ASTM, AASHTO, ANSI and others. However, some state DOTs and federal agencies, as well as software vendors may have adopted variations of the standards. In order to collect, view, and share geotechnical data there is a great need to establish a Geotechnical Data Dictionary from which a national standard XML (GML compliant) data interchange format schema may be established. The establishment of standards for the development of geotechnical management systems will provide the means for state DOTs to efficiently capture, store, retrieve, and share geotechnical data and information internally as well as with external agencies and user groups. The standards will also provide the means for IT departments and software developers to build components or modules for geotechnical management systems that would meet each state DOTs needs and be compatible with other modules developed by other software providers. These standards will reduce each States time and cost involving software development, maintenance, and updates. In addition, the standards, if adopted by other local, state and federal agencies, would provide the means to electronically share geotechnical data obtained by other sources near DOT highway projects.

Objectives

A first step in this process is to survey state and federal agencies and their consultants to define their geotechnical field and laboratory testing practices and the types of geotechnical data that they collect, archive and reuse through a web based survey method. Specifically of interest is the type of field and laboratory tests that are routinely performed, associated data collected, as well as metadata (data describing data: type of equipment, etc). Also of concern is the uniformity of testing practices (i.e. ASTM, AASHTO, etc.), and description of the data (e.g. soil classification, strengths, etc.). The survey will cover data at the dictionary level and will require very detailed and specific information. From the survey information, develop a consensus of data definitions to be accepted in the standard schema. The data dictionary specifies the meaning of the terms used in the data base.

The second objective involves the development of an open and flexible XML (GML compliant) based data structure and data dictionary geotechnical management systems. The data structure will define the form and content (alpha or numeric) of the data, the precision, the units, the field size, the type of data acquired, other data attributes, and the relationships between the attributes.

Scope of Work

The survey and schema development will be a collaborative effort by a core team consisting of technical representatives from the University of Florida, Department of Civil Engineering (UF), Association of Geotechnical and Geoenvironmental Specialists in the United Kingdom (AGS), and the Consortium of Organizations for Strong-Motion Observation Systems (COSMOS). Oversight of development by the core team will be provided by the Geotechnical Data Coalition with representation from UF, AGS, COSMOS, Construction Industry Research and Information Association (CIRIA), Federal Highway Administration (FHWA) and the Ohio Department of Transportation (ODOT). A Geotechnical Management System Group (GMS group) composed of representatives from 12 State DOTs, FHWA, US EPA, US Army Corps of Engineers, and the US Geological Survey has been formed to govern the development of the standards for all geotechnical data and to provide all final decisions for this project.

The UF group has developed a data dictionary, database and XML exchange format for the Florida DOT that allows web based sharing of geotechnical laboratory test data, classification data, in-situ test data and as-built construction data. The AGS membership is comprised of UK organizations and individuals having a common interest in the business of site investigation, geotechnics, geoenvironmental engineering, engineering geology, geochemistry, hydrogeology, and other related disciplines. AGS has a flat file exchange format that has been used for 14 years in the UK, Europe and Asia which handles geotechnical field data, lab data, and chemical and hydrological data. They also have a draft standard for an XML version that is GML compliant. COSMOS has developed a data dictionary and a virtual data center for sharing borehole data on the internet, as well as an ongoing project on geotechnical lab data.

A survey of information needs will be developed by the core team in close cooperation with the GMS group. The survey will cover basic demographic data, methods of collection, and specific data needs. The survey will be sent to a wide group of stakeholders that use Geotechnical data including state and federal agencies, civil software developer/vendors, consulting and design firms as well as others specified with the help of the GMS group.

The Geotechnical Data Field and Laboratory Data survey is the most difficult and time consuming part of the standards development. The survey will identify the types of tests and hardware, as well as data description necessary for the development of a data dictionary. Consequently, it is envisioned that over half the effort will occur in this phase compared to the development of a final data dictionary and XML (GML compliant) schema. The results of the survey will be used as the data requirements and definitions for defining a standard schema.

The contents of the survey will be developed by a small core team. A draft version will be created by the core team by merging all the data definitions found in the UF system, AGS, COSMOS and the Army Corps of Engineers and COSMOS survey results. The draft will be a prototype data dictionary merging the existing dictionaries and any determined missing data. The draft version of the survey will be presented to the GMS group and refined based on their input.

The survey will also ask questions about metadata for equipment, location, contractor/person etc., as well as general questions about Geohazard and Geotechnical asset inventory and condition data to prepare for a further phase in defining a dictionary for that data. The final data dictionary delivered from this project may or may not include Geohazard and asset condition information. The determination will be based upon the amount of time required to develop them which will largely depend upon whether sufficiently refined data definitions exist for this data.

Subjects: Bridges, Other Structures, and Hydraulics and Hydrology Soils, Geology, and Foundations

Documents Attached
Title File/Link Type Privacy Download
DIGGS Final Report http://ntl.bts.gov/lib/46000/46700/46732/134254_FR.pdf Final Report Public
Closeout Letter TPF-5(111) -- Close out Memo - Signed.pdf Memorandum Public
Project Graphic of completion - March 2010 Project Graphic of completion-March 10.xls Other Public
Project Graphic of Completion - March 2011 Project Graphic of completion-March 11.xls Other Public
Results Presentation Slideshow http://www.dot.state.oh.us/Divisions/Planning/SPR/Research/Training/Documents/Presentations/134254DIGGS2012June22.pdf Other Public
Results Presentation - Video http://media.dot.state.oh.us/DOTMediasite/SilverlightPlayer/Default.aspx?peid=1c4bf18ca1de4b9aa03e144c02dc10e0 Other Public
Closeout Funding Spreadsheet TPF-5(111) Closeout Funding Spreadsheet 10-22-14.pdf Other Public
Quarterly Report - December 31, 2005 quarterly_report_12-31-05.pdf Quarterly Progress Report Public
Quarterly Report - March 31, 2006 quarterly_report_03-31-06.pdf Quarterly Progress Report Public
Quarterly Report - June 30, 2006 quarterly_report_06-30-06.pdf Quarterly Progress Report Public
Quarterly Report - September 30, 2006 quarterly_report_09-30-06.pdf Quarterly Progress Report Public
Quarterly Report - December 31, 2006 quarterly_report_12-31-06.pdf Quarterly Progress Report Public
Quarterly Report - March 31, 2007 quarterly_report_03-31-07.pdf Quarterly Progress Report Public
Quarterly Report - June 30, 2007 quarterly_report_06-30-07.pdf Quarterly Progress Report Public
Quarterly Report - September 30, 2007 quarterly_report_09-30-07.pdf Quarterly Progress Report Public
Quarterly Report - June 30, 2008 quarterly_report_06-30-08.pdf Quarterly Progress Report Public
Quarterly Report - September 30, 2008 quarterly_report_09-30-08.pdf Quarterly Progress Report Public
Quarterly Report - December 31, 2008 quarterly_report_12-31-08.pdf Quarterly Progress Report Public
Quarterly Report - March 31, 2009 quarterly_report_03-31-09.pdf Quarterly Progress Report Public
Quarterly Report - March 31, 2010 March31_10-QuarterlyReportOhio.pdf Quarterly Progress Report Public
Quarterly Report - March 31, 2011 March 30- 11-Quarterly Report Ohio.pdf Quarterly Progress Report Public
DIGGS Executive Summary http://ntl.bts.gov/lib/46000/46700/46731/134254_ES.pdf Study Summary Public
Documents Attached
Title File/Link Type Privacy Download
Development of Standards for Geotechnical Management Systems 918.pdf Solicitation Public

Development of Standards for Geotechnical Management Systems

General Information
Study Number: TPF-5(111)
Lead Organization: Ohio Department of Transportation
Contract Start Date: Aug 10, 2005
Solicitation Number: 918
Partners: CA, CT, FHWA, GADOT, IN, KY, MN, MO, NC, OH, TN
Status: Closed
Est. Completion Date:
Contract/Other Number:
Last Updated: Nov 04, 2014
Contract End Date: Jun 30, 2008
Financial Summary
Contract Amount: $695,000.00
Total Commitments Received: $720,000.00
100% SP&R Approval:
Contact Information
Lead Study Contact(s): Cynthia Jones
cynthia.jones@dot.ohio.gov
Phone: 614-466-1975
Commitments by Organizations
Organization Year Commitments Technical Contact Name Funding Contact Name Contact Number Email Address
California Department of Transportation 2005 $25,000.00 Loren Turner Osama Elhamshary Osama_Elhamshary@dot.ca.gov
California Department of Transportation 2006 $100,000.00 Loren Turner Osama Elhamshary Osama_Elhamshary@dot.ca.gov
California Department of Transportation 2007 $100,000.00 Loren Turner Osama Elhamshary Osama_Elhamshary@dot.ca.gov
Connecticut Department of Transportation 2006 $12,500.00 Leo Fontaine James Sime 860-258-0309 james.sime@ct.gov
Connecticut Department of Transportation 2007 $12,500.00 Leo Fontaine James Sime 860-258-0309 james.sime@ct.gov
Federal Highway Administration 2005 $40,000.00
Georgia Department of Transportation 2006 $25,000.00 Cyprian Fonge Supriya Kamatkar 404-347-0552 skamatkar@dot.ga.gov
Indiana Department of Transportation 2006 $25,000.00 Tommy Nantung 765-463-1521 ext 248 tnantung@indot.in.gov
Kentucky Transportation Cabinet 2005 $35,000.00 Will Holmes Marcie Mathews 502-564-3730 marcie.mathews@ky.gov
Kentucky Transportation Cabinet 2006 $35,000.00 Will Holmes Marcie Mathews 502-564-3730 marcie.mathews@ky.gov
Kentucky Transportation Cabinet 2007 $35,000.00 Will Holmes Marcie Mathews 502-564-3730 marcie.mathews@ky.gov
Kentucky Transportation Cabinet 2008 $35,000.00 Will Holmes Marcie Mathews 502-564-3730 marcie.mathews@ky.gov
Kentucky Transportation Cabinet 2009 $35,000.00 Will Holmes Marcie Mathews 502-564-3730 marcie.mathews@ky.gov
Minnesota Department of Transportation 2005 $25,000.00 Gary Person Lisa Jansen 651-366-3779 lisa.jansen@state.mn.us
Missouri Department of Transportation 2006 $10,000.00 Mike Fritz Jennifer Harper 573-526-3636 Jennifer.Harper@modot.mo.gov
Missouri Department of Transportation 2007 $10,000.00 Mike Fritz Jennifer Harper 573-526-3636 Jennifer.Harper@modot.mo.gov
Missouri Department of Transportation 2008 $10,000.00 Mike Fritz Jennifer Harper 573-526-3636 Jennifer.Harper@modot.mo.gov
North Carolina Department of Transportation 2006 $15,000.00 Mrinmay Biswas 919-508-1865 biswas@ncdot.gov
Ohio Department of Transportation 2006 $20,000.00 Cynthia Jones Jill Martindale 6146448173 jacquelin.martindale@dot.ohio.gov
Ohio Department of Transportation 2007 $20,000.00 Cynthia Jones Jill Martindale 6146448173 jacquelin.martindale@dot.ohio.gov
Ohio Department of Transportation 2008 $20,000.00 Cynthia Jones Jill Martindale 6146448173 jacquelin.martindale@dot.ohio.gov
Tennessee Department of Transportation 2005 $25,000.00 Stephanie Vincent 615.741.2203 Stephanie.Vincent@tn.gov
Tennessee Department of Transportation 2006 $25,000.00 Stephanie Vincent 615.741.2203 Stephanie.Vincent@tn.gov
Tennessee Department of Transportation 2007 $25,000.00 Stephanie Vincent 615.741.2203 Stephanie.Vincent@tn.gov

Study Description

Study Description

A number of state and federal agencies are developing Geotechnical Databases which may be queried for information used for maintenance of existing projects as well as design, construction, etc. of nearby projects. Unfortunately, through the lack of a standard data definition for Geotechnical data, there exists significant difficulty in archiving, reusing and sharing data. This problem has been exacerbated with the dependence on computer software as the standard for design, construction, and maintenance of new and existing infrastructure projects. For instance, numerous computer programs have been developed to electronically collect and present geotechnical in-situ data by hardware manufacturers (i.e. CPT, PMT, etc.), as well as borehole/boring logs or fence diagrams. However, each software suite has developed its own data needs and formats. Some commonality exists in the definition of data through the use of standards such as ASTM, AASHTO, ANSI and others. However, some state DOTs and federal agencies, as well as software vendors may have adopted variations of the standards. In order to collect, view, and share geotechnical data there is a great need to establish a Geotechnical Data Dictionary from which a national standard XML (GML compliant) data interchange format schema may be established. The establishment of standards for the development of geotechnical management systems will provide the means for state DOTs to efficiently capture, store, retrieve, and share geotechnical data and information internally as well as with external agencies and user groups. The standards will also provide the means for IT departments and software developers to build components or modules for geotechnical management systems that would meet each state DOTs needs and be compatible with other modules developed by other software providers. These standards will reduce each States time and cost involving software development, maintenance, and updates. In addition, the standards, if adopted by other local, state and federal agencies, would provide the means to electronically share geotechnical data obtained by other sources near DOT highway projects.

Objectives

A first step in this process is to survey state and federal agencies and their consultants to define their geotechnical field and laboratory testing practices and the types of geotechnical data that they collect, archive and reuse through a web based survey method. Specifically of interest is the type of field and laboratory tests that are routinely performed, associated data collected, as well as metadata (data describing data: type of equipment, etc). Also of concern is the uniformity of testing practices (i.e. ASTM, AASHTO, etc.), and description of the data (e.g. soil classification, strengths, etc.). The survey will cover data at the dictionary level and will require very detailed and specific information. From the survey information, develop a consensus of data definitions to be accepted in the standard schema. The data dictionary specifies the meaning of the terms used in the data base.

The second objective involves the development of an open and flexible XML (GML compliant) based data structure and data dictionary geotechnical management systems. The data structure will define the form and content (alpha or numeric) of the data, the precision, the units, the field size, the type of data acquired, other data attributes, and the relationships between the attributes.

Scope of Work

The survey and schema development will be a collaborative effort by a core team consisting of technical representatives from the University of Florida, Department of Civil Engineering (UF), Association of Geotechnical and Geoenvironmental Specialists in the United Kingdom (AGS), and the Consortium of Organizations for Strong-Motion Observation Systems (COSMOS). Oversight of development by the core team will be provided by the Geotechnical Data Coalition with representation from UF, AGS, COSMOS, Construction Industry Research and Information Association (CIRIA), Federal Highway Administration (FHWA) and the Ohio Department of Transportation (ODOT). A Geotechnical Management System Group (GMS group) composed of representatives from 12 State DOTs, FHWA, US EPA, US Army Corps of Engineers, and the US Geological Survey has been formed to govern the development of the standards for all geotechnical data and to provide all final decisions for this project.

The UF group has developed a data dictionary, database and XML exchange format for the Florida DOT that allows web based sharing of geotechnical laboratory test data, classification data, in-situ test data and as-built construction data. The AGS membership is comprised of UK organizations and individuals having a common interest in the business of site investigation, geotechnics, geoenvironmental engineering, engineering geology, geochemistry, hydrogeology, and other related disciplines. AGS has a flat file exchange format that has been used for 14 years in the UK, Europe and Asia which handles geotechnical field data, lab data, and chemical and hydrological data. They also have a draft standard for an XML version that is GML compliant. COSMOS has developed a data dictionary and a virtual data center for sharing borehole data on the internet, as well as an ongoing project on geotechnical lab data.

A survey of information needs will be developed by the core team in close cooperation with the GMS group. The survey will cover basic demographic data, methods of collection, and specific data needs. The survey will be sent to a wide group of stakeholders that use Geotechnical data including state and federal agencies, civil software developer/vendors, consulting and design firms as well as others specified with the help of the GMS group.

The Geotechnical Data Field and Laboratory Data survey is the most difficult and time consuming part of the standards development. The survey will identify the types of tests and hardware, as well as data description necessary for the development of a data dictionary. Consequently, it is envisioned that over half the effort will occur in this phase compared to the development of a final data dictionary and XML (GML compliant) schema. The results of the survey will be used as the data requirements and definitions for defining a standard schema.

The contents of the survey will be developed by a small core team. A draft version will be created by the core team by merging all the data definitions found in the UF system, AGS, COSMOS and the Army Corps of Engineers and COSMOS survey results. The draft will be a prototype data dictionary merging the existing dictionaries and any determined missing data. The draft version of the survey will be presented to the GMS group and refined based on their input.

The survey will also ask questions about metadata for equipment, location, contractor/person etc., as well as general questions about Geohazard and Geotechnical asset inventory and condition data to prepare for a further phase in defining a dictionary for that data. The final data dictionary delivered from this project may or may not include Geohazard and asset condition information. The determination will be based upon the amount of time required to develop them which will largely depend upon whether sufficiently refined data definitions exist for this data.

Subjects: Bridges, Other Structures, and Hydraulics and Hydrology Soils, Geology, and Foundations

Title File/Link Type Private
DIGGS Final Report Final Report Public
Closeout Letter TPF-5(111) -- Close out Memo - Signed.pdf Memorandum Public
Project Graphic of completion - March 2010 Project Graphic of completion-March 10.xls Other Public
Project Graphic of Completion - March 2011 Project Graphic of completion-March 11.xls Other Public
Results Presentation Slideshow Other Public
Results Presentation - Video Other Public
Closeout Funding Spreadsheet TPF-5(111) Closeout Funding Spreadsheet 10-22-14.pdf Other Public
Quarterly Report - December 31, 2005 quarterly_report_12-31-05.pdf Quarterly Progress Report Public
Quarterly Report - March 31, 2006 quarterly_report_03-31-06.pdf Quarterly Progress Report Public
Quarterly Report - June 30, 2006 quarterly_report_06-30-06.pdf Quarterly Progress Report Public
Quarterly Report - September 30, 2006 quarterly_report_09-30-06.pdf Quarterly Progress Report Public
Quarterly Report - December 31, 2006 quarterly_report_12-31-06.pdf Quarterly Progress Report Public
Quarterly Report - March 31, 2007 quarterly_report_03-31-07.pdf Quarterly Progress Report Public
Quarterly Report - June 30, 2007 quarterly_report_06-30-07.pdf Quarterly Progress Report Public
Quarterly Report - September 30, 2007 quarterly_report_09-30-07.pdf Quarterly Progress Report Public
Quarterly Report - June 30, 2008 quarterly_report_06-30-08.pdf Quarterly Progress Report Public
Quarterly Report - September 30, 2008 quarterly_report_09-30-08.pdf Quarterly Progress Report Public
Quarterly Report - December 31, 2008 quarterly_report_12-31-08.pdf Quarterly Progress Report Public
Quarterly Report - March 31, 2009 quarterly_report_03-31-09.pdf Quarterly Progress Report Public
Quarterly Report - March 31, 2010 March31_10-QuarterlyReportOhio.pdf Quarterly Progress Report Public
Quarterly Report - March 31, 2011 March 30- 11-Quarterly Report Ohio.pdf Quarterly Progress Report Public
DIGGS Executive Summary Study Summary Public
Title File/Link Type Private
Development of Standards for Geotechnical Management Systems 918.pdf Solicitation Public

Currently, Transportation Pooled Fund is not supported on mobile devices, please access this Web portal using a desktop or laptop computer.