Document Type
Conference Paper
Publication Date
2024
Publication Title
18th World Conference on Earthquake Engineering (WCEE2024)
Volume
2024
Pages
1-11
Conference Name
18th World Conference on Earthquake Engineering (WCEE2024), June 30-July 5, 2024, Milan, Italy
Abstract
We present an application programming interface (API) which facilitates public access to a global relational database of earthquake ground motion intensity measures, associated metadata, and time-series data. Next Generation Attenuation (NGA)-East and NGA-West2 project spreadsheets have been adapted into a relational database format composed of multiple tables through a series of primary and foreign keys. The combined dataset 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 both projects in 2011. Currently the database includes 62,449 ground motions recorded at 9,092 stations for 899 events. The database is accessible through an API, which allows users to interact with and query the database directly without detailed knowledge of structure query language (SQL). Simple queries are constructed by appending relatively straightforward query string parameters to the end of a uniform resource location (URL) that serves as an endpoint, which returns only data that satisfy the query constraints. The web-served nature of the database means that users have immediate access to ground motion data as soon as it is collected, reviewed, and uploaded. Furthermore, integrated end-to-end workflows – which do not require files to be downloaded and saved in local memory – are made possible through the API. The structure of the database has been designed to accommodate growth, with ongoing efforts to integrate global ground motion data in anticipation of the NGA-West3 project, and improve ease-of access through the API.
Rights
© 2024 The authors and International Association for Earthquake Engineering. All rights reserved.
Posted with the kind written permission of IAEE and the author.
ORCID
0000-0002-2844-4557 (Wang)
Original Publication Citation
Buckreis, T. E., Nweke, C. C., Wang, P., Brandenberg, S. J., Shams, R., Ramos-Sepulveda, M. E., Pretell, R., Mazzoni, S., & Stewart, J. P. (2024, June 30-July 5). User-interaction with a web-served global ground motion relational database [Paper presentation]. 18th World Conference on Earthquake Engineering (WCEE2024), Milan, Italy.
Repository Citation
Buckreis, T. E.; Nweke, C. C.; Wang, P.; Brandenberg, S. J.; Shams, R.; Ramos-Sepulveda, M. E.; Pretell, R.; and Mazzoni, S., "User-Interaction with a Web-Served Global Ground Motion Relational Database" (2024). Civil & Environmental Engineering Faculty Publications. 126.
https://digitalcommons.odu.edu/cee_fac_pubs/126