Relational database for post-earthquake damage and recovery assessment: 2014 South Napa earthquake

Morolake Omoya; Itohan Ero; mohsen zaker esteghamati; Henry Burton; Scott Brandenberg; Chukwuebuka Nweke

doi:10.17603/ds2-3nvj-4127

Unsupported Browser

Your browser is not supported by DesignSafe. Please switch to Chrome or Firefox if you experience issues.

PRJ-3025 | Relational database for post-earthquake damage and recovery assessment: 2014 South Napa earthquake

Cite This Data:

Omoya, M., I. Ero, m. zaker esteghamati, H. Burton, S. Brandenberg, C. Nweke (2021). Relational database for post-earthquake damage and recovery assessment: 2014 South Napa earthquake. DesignSafe-CI. https://doi.org/10.17603/ds2-3nvj-4127

Authors	; ; ; ; ;
Data Type(s)	Database
Natural Hazard Type(s)	Earthquake
Date of Publication	2021-02-01
Facilities
Awards	CAREER: From Performance-Based Engineering to Resilience and Sustainability: Design and Assessment Principles for the Next Generation of Buildings \| 1554714
Keywords	Relational database, 2014 South Napa earthquake, damage, recovery
DOI	10.17603/ds2-3nvj-4127
License	Open Data Commons Attribution
Version	2

Description:

The Earthquake Recovery relational database uploaded to DesignSafe contains damage and recovery information for buildings affected by the 2014 South Napa earthquake. This project contains a Jupyter notebook (RecoveryDatabaseExampleQueries.ipynb) that runs several basic queries on the Earthquake Recovery relational database. The Jupyter notebook establishes a connection to the database and illustrates how to query information about the buildings affected by the 2014 South Napa earthquake including various properties (e.g. geometry, structural and occupancy), the type and level of damage, the recovery and census-level sociodemographic. Edit: Please use file "RecoveryDatabaseExampleQueries-NewConnection.ipynb" instead to account for the new Jupyter image (updated March 2022) and be sure to restart the kernel to avoid errors on the first cell. The MySQL file (EarthquakeRecovery.sql) containing the database is attached to this project. The relational database schema (Earthquakerecoveryschema.png) and a spreadsheet showing the number of entries for each attribute (EarthquakeRecoveryAttributeEntries.xslx) are also included.