Relational Database for California Strong Ground Motions
Publication: Geo-Congress 2023
ABSTRACT
We present a relational database of earthquake ground motion intensity measures and associated metadata for the state of California. NGA-West2 project spreadsheets have been adapted into a relational database format, and the data set has been expanded to include contributions from earthquakes, generally with magnitudes greater than M3.9, that have occurred since the conclusion of the data synthesis component of the NGA-West2 project in 2011. Aside from the newly added information, some site metadata fields have been updated for some ground motion stations. The relational-database is composed of multiple tables connected through a series of primary and foreign keys. We use various data types (beyond integers and floats) to increase the storage efficiency for several types of data. Currently the database includes 33,422 ground motions recorded at 2,739 stations for 478 events within or close to California. The database was designed to also accommodate the various fields included in other NGA databases, including NGA-East and NGA-Sub. This will eventually allow for certain database tables to be merged for all event types (e.g., a single site table could be created) in one central location.
Get full access to this article
View all available purchase options and get full access to this chapter.
REFERENCES
Ahdi, S. K., Mazzoni, S., Kishida, T., Wang, P., Nweke, C. C., Kuehn, N. M., Contreras, V., Rowshandel, B., Stewart, J. P., and Bozorgina, Y. (2020). “Engineering characteristics of ground motions recorded in the 2019 Ridgecrest Earthquake Sequence,” Bull. Seismol. Soc. Am., 110, 1474–1494.
Boore, D. M. (2010). Orientation-independent, nongeometric-mean measures of seismic intensity from two horizontal components of motion. Bull. Seis. Soc. Of Am., 100, 1830–1835.
Bozorgnia, Y., Abrahamson, N. A., and Al Atik, L. (2014). NGA-West2 research project, Earthquake Spectra, 30, 973–987.
Bozorgnia, Y., Abrahamson, N. A., and Ahdi, S. K. (2022). NGA-Subduction research program, Earthquake Spectra, 38, 783–798.
Buckreis, T. E., Brandenberg, S. J., and Stewart, J. P. (2021). Regional path effects for ground motion analysis in Sacramento-San Joaquin River Delta, California, Seismological Research Letters, 92 (2B), p 1419, abstract.
Goulet, C. A., et al. Y. (2018). Effective Amplitude Spectrum (EAS) as a metric for ground motion modeling using Fourier amplitudes, In: Seismology of the Americas Meeting, Miami, FL, 14–17 May.
Goulet, C. A., Bozorgnia, Y., Kuehn, N., Al Atik, L., Youngs, R. R., Graves, R. W., and Atkinson, G. M. (2021a). NGA-East Ground-Motion Characterization model part I: Summary of products and model development Earthquake Spectra. 2021;37(1_suppl):1231–1282.
Goulet, C. A., et al. (2021b). PEER NGA-East database, Earthquake Spectra, 37, 1331–1353.
Kuyuk, S. H., and Allen, R. M. (2013). Optimal seismic network density for earthquake early warning: A case study from California, Seismological Research Letters, 84 (6), 946–954.
Mazzoni, S., Kishida, T., Stewart, J. P., Contreras, V., Darragh, R. B., Ancheta, T. D., Chiou, B. S. J., Silva, W. J., and Bozorgnia, Y. (2022). Relational database used for ground-motion model development in the NGA-sub project. Earthquake Spectra. 38 (2), 1529–1548.
Nweke, C. C., Stewart, J. P., Wang, P., and Brandenberg, S. J. (2022). Site response of sedimentary basins and other geomorphic provinces in southern California, Earthquake Spectra, https://doi.org/10.1177/87552930221088609.
Wang, P. (2020). Predictability and Repeatability of Non-Ergodic Site Response for Diverse Geological Conditions. Ph.D. thesis. UC Los Angeles.
Information & Authors
Information
Published In
Geo-Congress 2023
Pages: 461 - 470
History
Published online: Mar 23, 2023
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.
Cited by
- Rashid Shams, Chukwuebuka C. Nweke, Capturing the Path Dependency of Site Response in Basin and Non-Basin Southern California Locations, Geo-Congress 2024, 10.1061/9780784485316.043, (411-419), (2024).