Treffer: A Global Application Programming Interface-Enabled Earthquake Ground Motion Relational Database for Engineering Applications

Title:
A Global Application Programming Interface-Enabled Earthquake Ground Motion Relational Database for Engineering Applications
Authors:
Buckreis, Tristan E., Nweke, Chukwuebuka C., Wang, Pengfei, Brandenberg, Scott J., Ramos-Sepúlveda, Maria E., Shams, Rashid, Mohammed, Shako, Pretell, Renmin, Mazzoni, Silvia, Zimmaro, Paolo, Steward, Jonathan P.
Source:
Civil & Environmental Engineering Faculty Publications
Publisher Information:
ODU Digital Commons
Publication Year:
2025
Collection:
Old Dominion University: ODU Digital Commons
Subject Terms:
Application programming interfaces (API), Application programs, Computer systems programming, Digital storage, Distributed database systems, Earthquake engineering, Earthquakes, Electronic document exchange, Information management, Management information systems, Metadata, Time series, Websites, Civil and Environmental Engineering, Databases and Information Systems, Environmental Engineering, Geotechnical Engineering
Document Type:
Fachzeitschrift text
File Description:
application/pdf
Language:
unknown
Relation:
https://digitalcommons.odu.edu/cee_fac_pubs/146; https://digitalcommons.odu.edu/context/cee_fac_pubs/article/1148/viewcontent/Wang_2025_AGlobalApplicationProgrammingInterfaceEnabledOCR.pdf
DOI:
10.1177/87552930251344978
Availability:
https://digitalcommons.odu.edu/cee_fac_pubs/146
https://doi.org/10.1177/87552930251344978
https://digitalcommons.odu.edu/context/cee_fac_pubs/article/1148/viewcontent/Wang_2025_AGlobalApplicationProgrammingInterfaceEnabledOCR.pdf
Rights:
© The Authors 2025. This article is distributed under the terms of the Creative Commons Attribution 4.0 International (CC BY 4.0) License which permits any use, reproduction and distribution of the work without further permission provided the original work is attributed as specified on the SAGE and Open Access pages ( https://us.sagepub.com/en-us/nam/open-access-at-sage ).
Accession Number:
edsbas.5955B59C
Database:
BASE

Weitere Informationen

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 ...