{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,9,20]],"date-time":"2026-09-20T13:03:40Z","timestamp":1789909420191,"version":"4.0.1"},"reference-count":30,"publisher":"Wiley","issue":"2","license":[{"start":{"date-parts":[[2023,5,1]],"date-time":"2023-05-01T00:00:00Z","timestamp":1682899200000},"content-version":"am","delay-in-days":365,"URL":"http:\/\/onlinelibrary.wiley.com\/termsAndConditions#am"},{"start":{"date-parts":[[2022,5,1]],"date-time":"2022-05-01T00:00:00Z","timestamp":1651363200000},"content-version":"vor","delay-in-days":0,"URL":"http:\/\/onlinelibrary.wiley.com\/termsAndConditions#vor"},{"start":{"date-parts":[[2022,5,1]],"date-time":"2022-05-01T00:00:00Z","timestamp":1651363200000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/doi.wiley.com\/10.1002\/tdm_license_1.1"},{"start":{"date-parts":[[2023,1,27]],"date-time":"2023-01-27T00:00:00Z","timestamp":1674777600000},"content-version":"vor","delay-in-days":271,"URL":"http:\/\/www.sagepub.com\/licence-information-for-chorus"}],"funder":[{"DOI":"10.13039\/100000001","name":"National Science Foundation","doi-asserted-by":"publisher","award":["1554714"],"award-info":[{"award-number":["1554714"]}],"id":[{"id":"10.13039\/100000001","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/100000001","name":"national science foundation","doi-asserted-by":"publisher","award":["1554714"],"award-info":[{"award-number":["1554714"]}],"id":[{"id":"10.13039\/100000001","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["journals.sagepub.com"],"crossmark-restriction":true},"short-container-title":["Earthquake Spectra"],"published-print":{"date-parts":[[2022,5]]},"abstract":"<jats:p>Systematically collected and curated data sets from historical events provide a strong basis for simulating the physical and functional effects of natural hazards on the built environment. This article develops a relational database to support post\u2010earthquake damage and recovery modeling of building portfolios. The current version of the database has been populated with information on the 3695 buildings affected by the 2014 South Napa, California, earthquake. The associated data categories include general building characteristics, site properties and shaking intensities, building damage and repair permitting (timing and type) information, and census\u2010block\u2010level sociodemographics. The Napa data set can be used to validate post\u2010earthquake recovery simulation methodologies and explore the effectiveness of different modeling techniques in predicting damage. The database can be expanded to include other earthquakes and the overall framework can be adapted to other types of natural hazards (e.g. hurricanes, flooding).<\/jats:p>","DOI":"10.1177\/87552930211061167","type":"journal-article","created":{"date-parts":[[2022,1,27]],"date-time":"2022-01-27T07:04:20Z","timestamp":1643267060000},"page":"1549-1569","update-policy":"https:\/\/doi.org\/10.1177\/sage-journals-update-policy","source":"Crossref","is-referenced-by-count":20,"title":["A relational database to support post\u2010earthquake building damage and recovery assessment"],"prefix":"10.1002","volume":"38","author":[{"given":"Morolake","family":"Omoya","sequence":"first","affiliation":[{"name":"Department of Civil &amp; Environmental Engineering The University of California Los Angeles Los Angeles CA USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Itohan","family":"Ero","sequence":"additional","affiliation":[{"name":"Department of Civil &amp; Environmental Engineering The University of California Los Angeles Los Angeles CA USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-2144-2938","authenticated-orcid":false,"given":"Mohsen","family":"Zaker Esteghamati","sequence":"additional","affiliation":[{"name":"Department of Civil and Environmental Engineering Virginia Polytechnic Institute and State University Blacksburg VA USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Henry V","family":"Burton","sequence":"additional","affiliation":[{"name":"Department of Civil &amp; Environmental Engineering The University of California Los Angeles Los Angeles CA USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-2493-592X","authenticated-orcid":false,"given":"Scott","family":"Brandenberg","sequence":"additional","affiliation":[{"name":"Department of Civil &amp; Environmental Engineering The University of California Los Angeles Los Angeles CA USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Han","family":"Sun","sequence":"additional","affiliation":[{"name":"Department of Civil &amp; Environmental Engineering The University of California Los Angeles Los Angeles CA USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Zhengxiang","family":"Yi","sequence":"additional","affiliation":[{"name":"Department of Civil &amp; Environmental Engineering The University of California Los Angeles Los Angeles CA USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Hua","family":"Kang","sequence":"additional","affiliation":[{"name":"Department of Civil &amp; Environmental Engineering The University of California Los Angeles Los Angeles CA USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-8939-571X","authenticated-orcid":false,"given":"Chukuebuka C","family":"Nweke","sequence":"additional","affiliation":[{"name":"Department of Civil &amp; Environmental Engineering The University of California Los Angeles Los Angeles CA USA"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"311","published-online":{"date-parts":[[2022,5]]},"reference":[{"key":"e_1_2_10_2_1","volume-title":"REDi\u2122: Resilience\u2010Based Earthquake Design Initiative (REDi\u2122) Rating System","author":"Almufti I","year":"2013"},{"key":"e_1_2_10_3_1","volume-title":"Procedures for Post\u2010Earthquake Building Safety Evaluation Procedures (ATC\u201020)","author":"Applied Technology Council (ATC)","year":"1995"},{"key":"e_1_2_10_4_1","doi-asserted-by":"publisher","DOI":"10.1109\/TPAMI.2018.2798607"},{"key":"e_1_2_10_5_1","doi-asserted-by":"publisher","DOI":"10.1785\/0220140234"},{"key":"e_1_2_10_6_1","doi-asserted-by":"publisher","DOI":"10.1193\/070113EQS184M"},{"key":"e_1_2_10_7_1","volume-title":"Paper presented at the 2006 fall meeting (Abstract id S51B\u20101266)","author":"Brocher TM","year":"2006"},{"key":"e_1_2_10_8_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijdrr.2019.101167"},{"key":"e_1_2_10_9_1","unstructured":"Center for Engineering Strong Motion Data (CESMD)(2018)Data for latest earthquakes. Available at:https:\/\/www.strongmotioncenter.org(accessed on January 2021)."},{"key":"e_1_2_10_10_1","unstructured":"ChenP LeeEJ(2017) UCVM 17.3.0 documentation. Available at:http:\/\/hypocenter.usc.edu\/research\/ucvm\/17.3.0\/docs\/index.html(accessed on January 2021)."},{"key":"e_1_2_10_11_1","unstructured":"City of Napa(2020a)City of Napa assessor parcel data. Available at:https:\/\/www.countyofnapa.org\/150\/Assessor\u2010Parcel\u2010Data(accessed on January 2021)."},{"key":"e_1_2_10_12_1","unstructured":"City of Napa(2020b)City of Napa community development department. Available at:https:\/\/etrakit.cityofnapa.org\/etrakit\/Search\/permit.aspx(accessed on January 2021)"},{"key":"e_1_2_10_13_1","unstructured":"Earthquake Engineering Research Institute (EERI)(2016) 2014South Napa earthquake data. Available at:http:\/\/eqclearinghouse.org\/map\/2014\u201008\u201024\u2010south\u2010napa\/(accessed on January 2021)."},{"key":"e_1_2_10_14_1","doi-asserted-by":"publisher","DOI":"10.1093\/sf\/sou120"},{"key":"e_1_2_10_15_1","volume-title":"Multi\u2010Hazard Loss Estimation Methodology\u2014Earthquake Model: HAZUS MH\u2010MR4 Technical Manual","author":"Federal Emergency Management Agency (FEMA)","year":"2003"},{"key":"e_1_2_10_16_1","volume-title":"NHERP Recommended Provisions for Seismic Regulations for New Buildings and Other Structures (FEMA 450\u20101)","author":"Federal Emergency Management Agency (FEMA)","year":"2003"},{"key":"e_1_2_10_17_1","volume-title":"Seismic Performance Assessment of Buildings","author":"Federal Emergency Management Agency (FEMA)","year":"2012"},{"key":"e_1_2_10_18_1","doi-asserted-by":"publisher","DOI":"10.1193\/012917EQS020M"},{"key":"e_1_2_10_19_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijdrr.2019.101111"},{"key":"e_1_2_10_20_1","doi-asserted-by":"publisher","DOI":"10.1177\/8755293019878137"},{"key":"e_1_2_10_21_1","first-page":"39","volume-title":"IPUMS National Historical Geographic Information System: Version 12.0 (Database)","author":"Manson S","year":"2017"},{"key":"e_1_2_10_22_1","volume-title":"A simulation model of urban disaster recovery and resilience: Implementation for the 1994 Northridge earthquake. Technical report MCEER\u201007\u20100014, 7 September","author":"Miles SB","year":"2007"},{"key":"e_1_2_10_23_1","unstructured":"MySQL(2020)Open source database. Available at:https:\/\/www.mysql.com\/(accessed on January 2021)."},{"key":"e_1_2_10_24_1","unstructured":"OmoyaM EroI Zaker EsteghamatiM BurtonHV BrandenbergS NwekeC(2021)Relational Database for Post\u2010Earthquake Damage and Recovery Assessment: 2014 South Napa Earthquake(DesignSafe\u2010CI). Available at:https:\/\/doi.org\/10.17603\/ds2\u20103nvj\u20104127(accessed on January 2021)."},{"key":"e_1_2_10_25_1","doi-asserted-by":"publisher","DOI":"10.1061\/(ASCE)NH.1527-6996.0000246"},{"key":"e_1_2_10_26_1","doi-asserted-by":"publisher","DOI":"10.1193\/063013EQS181M"},{"key":"e_1_2_10_27_1","unstructured":"United States Census(2020)United States Census Bureau. Available at:https:\/\/www.census.gov\/quickfacts\/napacountycalifornia(accessed on January 2021)."},{"key":"e_1_2_10_28_1","unstructured":"United States Geological Survey (USGS)(2020)The United States Geological Survey hazard maps. Available at:https:\/\/earthquake.usgs.gov\/ws\/designmaps\/asce7\u201016.html(accessed on January 2021)."},{"key":"e_1_2_10_29_1","doi-asserted-by":"publisher","DOI":"10.1785\/0120150105"},{"key":"e_1_2_10_30_1","doi-asserted-by":"publisher","DOI":"10.1177\/8755293020919857"},{"key":"e_1_2_10_31_1","doi-asserted-by":"publisher","DOI":"10.1080\/01944360903294556"}],"container-title":["Earthquake Spectra"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/pdf\/10.1177\/87552930211061167","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/full-xml\/10.1177\/87552930211061167","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/journals.sagepub.com\/doi\/pdf\/10.1177\/87552930211061167","content-type":"application\/pdf","content-version":"vor","intended-application":"syndication"},{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/pdf\/10.1177\/87552930211061167","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,1,25]],"date-time":"2026-01-25T13:00:57Z","timestamp":1769346057000},"score":1,"resource":{"primary":{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/10.1177\/87552930211061167"},"secondary":[{"URL":"https:\/\/pubs.geoscienceworld.org\/earthquake-spectra\/article\/38\/2\/1549\/613732\/a-relational-database-to-support-post-earthquake","label":"geoscienceworld"}]},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,5]]},"references-count":30,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2022,5]]}},"alternative-id":["10.1177\/87552930211061167"],"URL":"https:\/\/doi.org\/10.1177\/87552930211061167","archive":["Portico"],"relation":{},"ISSN":["8755-2930","1944-8201"],"issn-type":[{"value":"8755-2930","type":"print"},{"value":"1944-8201","type":"electronic"}],"subject":[],"published":{"date-parts":[[2022,5]]}}}