Three Relational Databases in Support of Model Development for Earthquake Hazard Products
Description:
The U.S. Geological Survey (USGS)’s hazard products, including ShakeMap and the National Seismic Hazard Model, fundamentally rely on ground motion models (GMMs) provided by a broad community of developers. GMMs are needed for instrumental intensity metrics (IMs), macroseismic intensities (MI), and the relations that convert between them. The development and use of these models also require explanatory parameters such as earthquake moment magnitude, focal mechanism, site parameters (such as the time-averaged shear-wave velocity to 30-meters depth), depths to shear-wave velocity horizons, and surface geology. Given the global earthquake monitoring mission of the USGS National Earthquake Information Center, we are well positioned to provide many of the data and site parameters described above. We operate the “Did You Feel It?” system, which contains millions of MI records. We also maintain the Advanced National Seismic System Comprehensive Catalog (ComCat), which contains QuakeML (an Extensible Markup Language format for earthquake data) summaries of more than 2 million global earthquakes. Finally, our center leads the development of gmprocess, a software package used to process earthquake ground-motion data and generate IMs. Querying large numbers of QuakeML records from ComCat and associating them with IM/MI records is computationally intractable, as downloading QuakeML for many thousands of records and extracting information can take many hours. To facilitate the analysis of IMs, we are developing three relational databases for (1) instrumental IMs, (2) MIs, and (3) earthquake catalog data. The schema designs of these databases must capture all relevant information about each input data set such that users can efficiently access the information necessary to address a broad range of research and operational goals. By integrating these three databases with sources of site parameters such as surface geology, our goals are to (1) minimize time spent by researchers compiling data for engineering seismology studies and (2) optimize the process of model development to better support USGS earthquake hazard products.
Session: From Earthquake Recordings to Empirical Ground-Motion Modelling - II
Type: Oral
Date: 5/2/2024
Presentation Time: 10:30 AM (local time)
Presenting Author: Michael
Student Presenter: No
Invited Presentation:
Authors
Michael Hearne Presenting Author Corresponding Author mhearne@usgs.gov U.S. Geological Survey |
Annabelle Cunningham acunningham@usgs.gov U.S. Geological Survey |
Elijah Knodel eknodel@usgs.gov U.S. Geological Survey |
Nicholas Ambruz nambruz@usgs.gov U.S. Geological Survey |
Brad Aagaard baagaard@usgs.gov U.S. Geological Survey |
Eric Thompson emthompson@usgs.gov U.S. Geological Survey |
Charles Worden cbworden@contractor.usgs.gov U.S. Geological Survey |
|
|
Three Relational Databases in Support of Model Development for Earthquake Hazard Products
Category
From Earthquake Recordings to Empirical Ground-Motion Modelling