Sample Queries

Economic query:

• connection between seismic risk and scenario risk
• this has been done in Excel by Murray Generate loss curve for a geographic area

• spatial visualization of loss ratio (point centroids for density grid, or choropleth)
• bivariate maps better (3x3 matrix) - bins are already defined for exposure
  • could use social vulnerability score as well which would show who is exposed
• has aggregation (not spatial)
• disaggregate results by category
  • residential, commercial, etc...
• annual average loss calculation would be useful (Phil)
  • this is computed in the loss table (Murray)
  • we can use the PML table (probable maximum loss)
  • src_loss table for disaggregating for earthquake type affect on loss

PSRA:

• show me areas that are the highest hit

DSRA:

• show me the areas with the highest risk

Multi

• areas that have greatest threat for a given hazard

Disaggregate the results:

• Show me, who or what is most impacted (buildings, assets, etc.)