Overview of The COSMOSPEERLL Geotechnical Virtual Data Center GVDC and Data Provider Perspectives

1
Overview of The COSMOS/PEER-LL Geotechnical
Virtual Data Center (GVDC)and Data Provider
Perspectives
CUS Borehole Geo-observatory Workshop May 3-4,
2007 Fedex Institute of TechnologyUniversity
of Memphis

• Carl Stepp, COSMOS (PI)
• Jean Benoit, UNH
• John Bobbit, POSC
• Dan Ponti, USGS
• Charles Real, CGS
• Jennifer Swift, USC
• Loren Turner, Caltrans
• Mindy Squibb, UCSB

2
Overview

• Motivation for new data management tools
• Project 2L01
• Project 2L02
• Project 2L03
• Data Provider tasks and perspectives

3
Geotechnical Data Management

• Many organizations are paper-based.
• Need more efficient information systems.

4
Vision Single Agency
Design Engineer
Drafter
Data files are transferred to a central repository
Data is collected in the field electronically
Other Staff
5
Vision Multiple Agencies

• Partner agencies benefit through data exchange.

Private Firms
COSMOS GVDC
Design Engineer
6
Data Provider Motivation

• USGS - FOQUS-LA Corehole and Well Database
• Support geologic and ground water modeling
  projects supported by USGS in the Los Angeles
  region
• Developed a repository for detailed core and pore
  fluid chemical analyses conducted by USGS using
  in-house developed FileMaker-based core logging
  system
• Desire centralized access to broad range of
  subsurface information from various sources
  GVDC connects to this database
• Caltrans - Cone Penetration Test (CPT) Archive
• Caltrans has a mobile testing unit that is
  deployed statewide, approximately 350 soundings
  per year
• Digital archives currently contain 10 years of
  data (gt3300 records)
• Developed internal Online CPT Data Viewer
  GVDC can connect to database
• CGS - Geotechnical Database SHMA Mandate
• Support Designation of Regulatory Seismic Hazard
  Zones per year, for Analysis of Ground Shaking
  Hazard and Earthquake-Induced Ground Failures
• Update/Revise Seismic Hazard Zones
• Developed SHMP WebMap site GVDC can connect to
  this database

7
Background of 2L Projects

• 1992 NSF/FHWA sponsors the National Geotechnical
  Experiment Sites.
• 1996 The ROSRINE project pioneers web
  dissemination of geotechnical data.
• 1998 USC Workshop highlights growing need for
  geotechnical data management and exchange.
• 1999 PEER Lifelines initiates Project 2L01.
• 2001 Project 2L01 Held a workshop to assess
  user needs and build consensus to develop a
  Geotechnical Virtual Data Center (GVDC).
• 2004 Project 2L02 Unveiled a pilot GVDC that
  demonstrated the feasibility of the technology.
• 2005 Project 2L03 Initiated.

8
Project 2L01 Planning for a Geotechnical
Virtual Data Center

• Flexible and extensible
• Translation-based system
• Central index, single portal to data not a
  central repository
• Data quality
• Data exchange standards
• Control of data and attribution
• Security and liability

9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
Project 2L03 Project Objective

• Task 1 Modify the server-side and client-side
  COSMOS/PEER-LL Pilot GVDC system architecture,
  and upgrade the system server to support a larger
  user-base.
• Replace MySQL Database with PostgreSQL
• Server and Client Side Exchange Protocols
• GML compliant schema
• Server Side Data Mapping and Translator Apps
• Server Side Data Previewers
• Server Side Front End Interactive Map
• Search Results and Data Download code
• Java-based previewer for seismic velocity logs
  and suspension velocity logs
• Hardware upgrade and redundancy
• Documentation, Users Manual and Final Report

21
Project 2L03 Project Objective

• Task 2 Expansion of the Data Dictionary Standard
  to include data standards for
• Seismic velocity PS-Logging, Downhole Receiver,
  Crosshole velocity data, SASW, Generic structure
  for other downlhole logs
• Laboratory Atterberg, Grain size, Unit Weight,
  Specific Gravity, Direct Shear, Triaxial,
  Consolidation, Moisture, Unconfined Compression,
  Falling Head/Constant Head Permeability
• Task 3 Development of an Operation and
  Maintenance Plan

22
Project 2L03 Expanded Task 1

• Support Data Interchange for Geotechnical and
  Geoenvironmental Specialists (DIGGS) - GML
  compliant schema
• Upgrade the GVDC system to ease data provider
  participation, to support a larger user-base
• Replace MySQL Database with PostgreSQL
• Re-design Server and Client Side Exchange
  (Harvesting) Develop MetaDIGGS application
• Develop new Data Mapping and Translator
  applications
• Update Front End Interactive Map, Search Results
  and Data Download code

23
Project 2L03 Expanded Task 2

• Upgrade existing data previewers
• Support Data Interchange for Geotechnical and
  Geoenvironmental Specialists (DIGGS)
• Modularize to facilitate future updates
• Revise CPT data previewer
• Create a COSMOS Geotechnical Data XML
  Schema-to-DIGGS translator
• Updating original concept of geophysical data
  previewer, to a modular curve previewer

24
Project 2L03 Expanded Task 3

• Collaborative effort with the Federal Highway
  Administration (FHWA) and the Association of
  Geotechnical Geoenvironmental Specialists
  (AGS)
• 2L03 participation in Transportation Pooled Fund
  project recently launched by DOTs led by Ohio
  DOT and FHWA
• Funding 650k over 3 years
• Develop consensus data interchange format,
  DIGGS, based on AGS and COSMOS-PEER-LL formats
• Potential for broad national and international
  adoption of standard
• COSMOS/PEER-LL GVDC will implement DIGGS (Task 1)

25
Data Sources
Custom-coded Translator
Current Data Provider Server
OAIB Application
Open Archives-in-a-Box
Harvester
GVDC Database
Current GVDC Server
ArcIMS ASP JScript
GVDC Website - Map and Document Searches -
Administrative Tools
26
Data Sources
Updated Data Provider Server
DIGGS Generator
Transform
MetaDIGGS Invoker
Java Wrapper
MetaDIGGS Application
Harvester
Transform
GVDC Database
Updated GVDC Server

• GVDC Website
• - Map and Document Searches
• Administrative Tools
• Draft Google Maps Interface
• Connectivity to COSMOS Strong Motion Data Center

ArcIMS ASP JScript
27
To Become a GVDC Data Provider

• Tasks
• Collect and maintain geotechnical and/or
  geophysical data, and required associated
  metadata
• Assist in custom data mapping and translator
  development Data Providers native format to
  DIGGS XML Schema
• Install open source application to allow the GVDC
  to harvest the search parameter data from the
  native database
• Develop Privacy and Data Use Policies for each
  Data Provider

28
New 2L03 Tasks To Facilitate Data Providers Role

• Improvement of GVDC
• Allow hole coordinates to be in any standard
  coordinate system
• View XML as simple tables, in popups
• Allow null data
• DIGGS Data Mapping and Translator Applications
• Improve GVDC Connection (harvesting)
• Evaluate revising GVDC Front End Mapping
  application (ERSI ArcIMS) to Open Source Software
  (Google Maps)
• Anticipated completion of all 2L03 Tasks
  December 2007

29
Additional Efforts

• Establish Connectivity between the COSMOS Strong
  Motion VDC and Geotechnical VDCOnline Data
  Mapping
• User searching for both Strong Motion and
  Geotechnical data only has to conduct one search
• The existing flow and functionality of both data
  centers are maintained
• Provides Google Maps (separate interface)
  functionality for viewing both types of data
• Funded by USC WiSE (Women in Science and
  Engineering) Program
• Anticipated project completion date September
  2007
• Revise existing Borehole Previewer same modular
  technology as new curve previewer
• Gather feedback on GVDC updates, previewers and
  VDC-GVDC connectivity
• Seek long-term funding opportunities

30
COSMOS Strong-Motion Virtual Data
Centerhttp//db.cosmos-eq.org
Professor Ralph J. Archuleta Associate Research
Seismologist Jamison Steidl IT Analyst Mindy
Squibb Institute for Crustal Studies, University
of California, Santa Barbara
31
Sponsors and Partners