@article{13ab81d9d19a445aaa8523eff005fc16,
title = "Relational database used for ground-motion model development in the NGA-sub project",
abstract = "The Next-Generation Attenuation for subduction zone regions project (NGA-Sub) has developed data resources and ground motion models for global subduction zone regions. Here we describe the NGA-Sub database. To optimize the efficiency of data storage, access, and updating, data resources for the NGA-Sub project are organized into a relational database consisting of 20 tables containing data, metadata, and computed quantities (e.g. intensity measures, distances). A database schema relates fields in tables to each other through a series of primary and foreign keys. Model developers and other users mostly interact with the data through a flatfile generated as a time-stamped output of the database. We describe the structure of the relational database, the ground motions compiled for the project, and the means by which the data can be accessed. The database contains 71,340 three-component records from 1880 earthquakes from seven global subduction zone regions: Alaska, Central America and Mexico, Cascadia, Japan, New Zealand, South America, and Taiwan. These data were processed on a component-specific basis to minimize noise effects in the data and remove baseline drifts. Provided ground motion intensity measures include peak acceleration, peak velocity, and 5%-damped pseudo-spectral accelerations for a range of oscillator periods.",
keywords = "data processing, ground motion, intensity measures, metadata, Relational database",
author = "Silvia Mazzoni and Tadahiro Kishida and Stewart, {Jonathan P.} and Victor Contreras and Darragh, {Robert B.} and Ancheta, {Timothy D.} and Chiou, {Brian S.J.} and Silva, {Walter J.} and Yousef Bozorgnia",
note = "Funding Information: The author(s) disclosed receipt of the following financial support for the research, authorship, and/or publication of this article: Core support for the NGA-Sub research project was provided by FM Global, the U.S. Geological Survey, the California Department of Transportation, and the Pacific Gas & Electric Company. The support of these organizations is gratefully appreciated. The opinions, findings, conclusions, or recommendations expressed in this publication are those of the authors and do not necessarily reflect the views of the study sponsors, or the Regents of the University of California. Funding Information: We appreciate the reviews by Sinan Akkar, Emel Seyhan, and two anonymous reviewers, which have improved the paper. The author(s) disclosed receipt of the following financial support for the research, authorship, and/or publication of this article: Core support for the NGA-Sub research project was provided by FM Global, the U.S. Geological Survey, the California Department of Transportation, and the Pacific Gas & Electric Company. The support of these organizations is gratefully appreciated. The opinions, findings, conclusions, or recommendations expressed in this publication are those of the authors and do not necessarily reflect the views of the study sponsors, or the Regents of the University of California. Publisher Copyright: {\textcopyright} The Author(s) 2021.",
year = "2022",
month = may,
doi = "10.1177/87552930211055204",
language = "British English",
volume = "38",
pages = "1529--1548",
journal = "Earthquake Spectra",
issn = "8755-2930",
publisher = "Earthquake Engineering Research Institute",
number = "2",
}