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

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.