arrow
Return

A Global Application Programming Interface–Enabled Earthquake Ground Motion Relational Database for Engineering Applications

delete2025-07-17
delete0
PRE
AI
T
Tristan E. Buckreis
C
Chukwuebuka C. Nweke
P
Pengfei Wang
S
Scott J. Brandenberg
M
María Elisa Ramos-Sepúlveda
R
Rashid Shams
S
Shako Mohammed
R
Renmin Pretell
S
Silvia Mazzoni
P
Paolo Zimmaro
J
Jonathan P. Stewart
DOI:10.1177/87552930251344978delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
We present a application programming interface (API)-enabled relational database of global earthquake ground motion intensity measures, associated metadata, and processed time-series data. Raw ground motion records were processed by the authors using either manual or semi-automated processing procedures, and every processed record has passed a quality review by a trained analyst. Computed intensity measures include peak acceleration and velocity, pseudo-spectral acceleration response spectra, cumulative absolute velocity, Arias Intensity, and Fourier amplitude spectra. The processed time-series data, associated metadata, and ground motion intensity measures were organized into a web-served relational database consisting of 32 tables connected by primary/foreign key pairs. Ground motion metadata and intensity measures (but not time-series) from the Next-Generation Attenuation (NGA)-East and NGA-West2 projects and the Hellenic Strong-Motion Database are also contained in the database. As of this writing (June 2025) the database includes intensity measures and metadata for 76,242 multi-component ground motions recorded at 9927 stations for 1391 events, and is approximately 73.5 GB in size. The database is built using the MySQL relational database management system, and is accessible through a web interface and also an API, which allows users to retrieve data using straightforward and intuitive uniform resource locators (URLs). Compared with more traditional file-download-based methods for data release, the relational database (1) increases storage efficiency, (2) improves data integrity, and (3) enables users to query the data subset they wish to retrieve rather than downloading the entire database and loading it into memory. Furthermore, the web-served nature of the database means that users have immediate access to ground motion data following collection, review, and uploading. Periodic static releases of the database will be published as a means of archiving and facilitating reproducibility. The database has been designed to accommodate growth, with ongoing efforts to integrate global ground motion data (e.g. data development for the NGA-West3 project).
Keywords:
earthquake ground motion
intensity measures
relational database
API
metadata

Journal

Earthquake Spectra cover
Earthquake Spectra
IF:
3.7
Papers:
2.3K
Citations:
9.7K

Organization

No organization information available
Cited Papers

Cited Papers

NGA-West2 Database
err2014-08-01
err1.1K
PREAI
errAncheta, Timothy D.; Darragh, Robert B.; Stewart, Jonathan P.; Seyhan, Emel; Silva, Walter J.; Chiou, Brian S. -J.; Wooddell, Katie E.; Graves, Robert W.; Kottke, Albert R.; Boore, David M.; Kishida, Tadahiro; Donahue, Jennifer L.
errShare
errSave
Data Resources for NGA-Subduction Project
err2020-03-01
err0
PREAI
errYousef Bozorgnia; Jonathan Stewart
errShare
errSave
errShare
errSave
The Engineering Strong‐Motion Database: A Platform to Access Pan‐European Accelerometric Data
err2016-06-08
err0
errOAAI
errLucia Luzi; Rodolfo Puglia; Emiliano Russo; Maria D'Amico; Chiara Felicetta; Francesca Pacor; Giovanni Lanzano; Ulubey Çeken; John Clinton; Giovanni Costa; Llambro Duni; Esmael Farzanegan; Philippe Gueguen; Constantin Ionescu; Ioannis Kalogeras; Haluk Özener; Damiano Pesaresi; Reinoud Sleeman; Angelo Strollo; Mehdi Zare
errShare
errSave
Rapid Characterization of the February 2023 Kahramanmaraş, Türkiye, Earthquake Sequence
err2023-05-23
err0
errOAAI
errDara E. Goldberg; Tuncay Taymaz; Nadine G. Reitman; Alexandra E. Hatem; Seda Yolsal-Çevikbilen; William D. Barnhart; Tahir Serkan Irmak; David J. Wald; Taylan Öcalan; William L. Yeck; Berkan Özkan; Jessica A. Thompson Jobe; David R. Shelly; Eric M. Thompson; Christopher B. DuRoss; Paul S. Earle; Richard W. Briggs; Harley Benz; Ceyhun Erman; Ali Hasan Doğan; Cemali Altuntaş
errShare
errSave
Ground motion models for shallow crustal and deep earthquakes in Hawaii and analyses of the 2018 M 6.9 Kalapana sequence
err2021-10-12
err5
PREAI
errWong, Ivan; Darragh, Robert; Smith, Sarah; Wu, Qimin; Silva, Walter; Kishida, Tadahiro
errShare
errSave
Proxy‐BasedVS30Estimation in Central and Eastern North America
err2017-01-03
err0
PREAI
errGrace A. Parker; Joseph A. Harmon; Jonathan P. Stewart; Youssef M. A. Hashash; Albert R. Kottke; Ellen M. Rathje; Walter J. Silva; Kenneth W. Campbell
errShare
errSave
researcher View more