A proposed seismic velocity profile database model

Shamsher Sadiq, Okan Ilhan, Sean K. Ahdi, Yousef Bozorgnia, Youssef M.A. Hashash, Dong Youp Kwak, Duhee Park, Alan Yong, Jonathan P. Stewart

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

We describe the data model that we intend to use in a publicly available site profile database under development for the United States. The initial implementation of the database contains data from California. Currently, our prototype data model consists of JavaScript Object Notation (JSON) format files for storing metadata and data. For a site to be included in the database, the minimum metadata requirements are geodetic coordinates and elevation values, and the minimum data requirement is a shear-wave velocity profile. The JSON files are structured in a hierarchal manner to store metadata and data using a nested structure consisting of location, velocity profiles, dispersion curve data (for surface-wave methods), geotechnical data, and horizontal-to-vertical spectral ratios. The database schema at the current stage of the project, and as we continue to develop the data model we will consider including other relevant data, as well as evaluate other file formats to increase the efficiency of data storage and querying. In the current data model, location information includes site geodetic values (latitude, longitude, and elevation) and various site descriptors related to surface geology, geomorphic terrain category, slope gradient at various resolutions, and a geotechnical site category. Velocity data include the geophysical method(s) used to obtain the shear-wave velocity profile, type of data recorded, modeled primary- and shear-wave velocity as a function of depth, modeled profile maximum depth, and the calculated VS30 value. In the case of surface-wave based data, dispersion curve data can be recorded in data structure as phase velocity versus either wavelength or frequency. Geotechnical data includes boring logs penetration resistance, cone penetration test sounding logs, and laboratory index test results. Horizontal-to-vertical spectral ratio plots are given as a function of frequency.

Original languageEnglish (US)
Title of host publication11th National Conference on Earthquake Engineering 2018, NCEE 2018
Subtitle of host publicationIntegrating Science, Engineering, and Policy
PublisherEarthquake Engineering Research Institute
Pages4274-4283
Number of pages10
ISBN (Electronic)9781510873254
StatePublished - 2018
Event11th National Conference on Earthquake Engineering 2018: Integrating Science, Engineering, and Policy, NCEE 2018 - Los Angeles, United States
Duration: Jun 25 2018Jun 29 2018

Publication series

Name11th National Conference on Earthquake Engineering 2018, NCEE 2018: Integrating Science, Engineering, and Policy
Volume7

Conference

Conference11th National Conference on Earthquake Engineering 2018: Integrating Science, Engineering, and Policy, NCEE 2018
Country/TerritoryUnited States
CityLos Angeles
Period6/25/186/29/18

ASJC Scopus subject areas

  • Geotechnical Engineering and Engineering Geology

Fingerprint

Dive into the research topics of 'A proposed seismic velocity profile database model'. Together they form a unique fingerprint.

Cite this