Draft manuscript submitted to Earthquake Spectra July 2009 

It can be valuable to perform seismic risk studies of buildings at the societal level, which requires an inventory of the building stock exposed to damage. HAZUS-MH offers a nationwide default building-stock inventory, but it can be difficult to use outside of HAZUS-MH (as is sometimes desirable): it is encoded in 15 tables in 2 Microsoft Access databases for each of 50 states. A new Microsoft Access database is developed here that links to the HAZUS-MH tables, and includes 54 scripted query language (SQL) queries, a macro to perform them all, and a number of supporting tables, for the purpose of extracting the HAZUS-MH inventory to a single de-normalized table, which is more practical for use by PAGER and some other applications. The table shows by census tract, county or state: square footage of construction, building value, content value, and number of indoor occupants at 2 PM, 2 AM, and 5 PM. The quantities are distributed by HAZUS-MH occupancy classification, structure type, and design level. The database and results for several states are available in the software download section of www.risk-agora.org. 

Arkansas Results

This zip file contains 3 estimated building inventory tables: one each at the census tract, county, and state level. Each table contains, by geographic area, occupancy class, structure type, and design level, the total square footage (1000s of sf), building value ($1000s in 2003), content value ($1000s in 2003), number of occupants at 2 PM, number of occupants at 2 AM, and number of occupants at 5 PM. The inventory is based on the HAZUS-MH MR3 normalized default inventory tables, but denormalized from 15 related tables into a single table for each geographic aggregation level (tract, county, or state). A draft manuscript entitled Cracking an Open Safe: Extracting HAZUS’s Building Inventory to a Single Table, also available here, explains the methodology. Each file is comma-and-quote delimited, with column headers in the 1st row for ease of reading.

The data are freely available but by downloading you agree to submit any derived products back to AGORA.

Thanks Kishor Jaiswal for producing these. 

Louisiana Results

This zip file contains 3 estimated building inventory tables: one each at the census tract, county, and state level. Each table contains, by geographic area, occupancy class, structure type, and design level, the total square footage (1000s of sf), building value ($1000s in 2003), content value ($1000s in 2003), number of occupants at 2 PM, number of occupants at 2 AM, and number of occupants at 5 PM. The inventory is based on the HAZUS-MH MR3 normalized default inventory tables, but denormalized from 15 related tables into a single table for each geographic aggregation level (tract, county, or state). A draft manuscript entitled Cracking an Open Safe: Extracting HAZUS’s Building Inventory to a Single Table, also available here, explains the methodology. Each file is comma-and-quote delimited, with column headers in the 1st row for ease of reading.

The data are freely available but by downloading you agree to submit any derived products back to AGORA.

Thanks Kishor Jaiswal for producing these. 

Mississippi Results

This zip file contains 3 estimated building inventory tables: one each at the census tract, county, and state level. Each table contains, by geographic area, occupancy class, structure type, and design level, the total square footage (1000s of sf), building value ($1000s in 2003), content value ($1000s in 2003), number of occupants at 2 PM, number of occupants at 2 AM, and number of occupants at 5 PM. The inventory is based on the HAZUS-MH MR3 normalized default inventory tables, but denormalized from 15 related tables into a single table for each geographic aggregation level (tract, county, or state). A draft manuscript entitled Cracking an Open Safe: Extracting HAZUS’s Building Inventory to a Single Table, also available here, explains the methodology. Each file is comma-and-quote delimited, with column headers in the 1st row for ease of reading.

The data are freely available but by downloading you agree to submit any derived products back to AGORA.

Thanks Kishor Jaiswal for producing these. 

New Mexico Results

This zip file contains 3 estimated building inventory tables: one each at the census tract, county, and state level. Each table contains, by geographic area, occupancy class, structure type, and design level, the total square footage (1000s of sf), building value ($1000s in 2003), content value ($1000s in 2003), number of occupants at 2 PM, number of occupants at 2 AM, and number of occupants at 5 PM. The inventory is based on the HAZUS-MH MR3 normalized default inventory tables, but denormalized from 15 related tables into a single table for each geographic aggregation level (tract, county, or state). A draft manuscript entitled Cracking an Open Safe: Extracting HAZUS’s Building Inventory to a Single Table, also available here, explains the methodology. Each file is comma-and-quote delimited, with column headers in the 1st row for ease of reading.

The data are freely available but by downloading you agree to submit any derived products back to AGORA.

Thanks Kishor Jaiswal for producing these.