Appendix E: Job Aids for Step 3 Table 3-1. Inventory Data Provided with HAZUS-MH Four columns: Inventory Asset Category, Used for HAZUS-MH Model (that is in earthquake, flood, or hurricane), HAZUS-MH Provided Data Source (Year), and Examples of Potential Local Sources for Data Inventory Asset Category: General Building Stock HAZUS-MH data source: U.S. Census Bureau and Dun & Bradstreet (2000) Potential sources for data: Tax assessors offices, zoning departments, regional and local planning commissions Essential Facilities Medical Care American Hospital Association (2000) Electronic Yellow Pages, State EMA, LEPC Emergency Response InfoUSA, Inc. (2001) State EMA, LEPC Schools National Center for Education Statistics, Department of Education (2003) Board of Education, Electronic Yellow Pages Fire Stations InfoUSA, Inc. (2001) State EMA, LEPC, Fire Chief Police Stations InfoUSA, Inc. (2001) State EMA, LEPC, Police Commissioner HazMat Facilities Toxic Release Inventory Database, EPA (1999) State EMA, LEPC, Fire Department, State and local environmental organizations High Potential Loss Facilities Dams National Inventory of Dams, USACE (2003) Local or regional authorities, State EMA, state and local planning department Levees N/A Local flood mitigation organizations, ASFPM Nuclear Power Facilities U.S. Nuclear Regulatory Commission (2003) Not applicable Military Installations N/A State Reserve Units (to supplement Federal data) Transportation Systems Highway Segments Tiger/Line Files, U.S. Census Bureau (2000) State or local DOT, regional or local planning commissions Highway Bridges National Bridge Inventory Database, FHWA (2001) State or local DOT, regional or local planning commissions Highway Tunnels National Bridge Inventory Database, FHWA (2001) State or local DOT, regional or local planning commissions Rail Segments National Rail Network Database, Bureau of Transportation Statistics (2000) State or local DOT, regional or local planning commissions Rail Bridges National Bridge Inventory Database, FHWA (2001) State or local DOT, regional or local planning commissions Rail Tunnels National Bridge Inventory Database, FHWA (2001) State or local DOT, regional or local planning commissions Rail Facilities N/A State or local DOT, regional or local planning commissions Light Rail Segments Fixed-Guideway Transit and Ferry Network Database, BOTS, U.S. DOT (2000) State or local DOT, regional or local planning commissions Light Rail Bridges National Bridge Inventory Database, FHWA (2001) State or local DOT, regional or local planning commissions Light Rail Tunnels National Bridge Inventory Database, FHWA (2001) State or local DOT, regional or local planning commissions Light Rail Facilities N/A State or local DOT, regional or local planning commissions Bus InfoUSA, Inc. (2001) State or local DOT, regional or local planning commissions, Electronic Yellow Pages Port Port and Waterway Facilities Database, USACE (2000) State or local DOT, regional or local planning commissions Ferry Port and Waterway Facilities Database, USACE (2000) State or local DOT, regional or local planning commissions, Electronic Yellow Pages Airport Facilities BOTS, U.S. DOT (1999) State or local DOT, regional or local planning commissions, Electronic Yellow Pages Airport Runways BOTS, U.S. DOT (1999) State or local DOT, regional or local planning commissions Utility Systems Potable Water Pipelines EPA Envirofacts Data Warehouse LRT Tool (2001) State or local water departments, private utilities, regional or local planning commissions Potable Water Distribution Pipes (by Census tract) EPA Envirofacts Data Warehouse LRT Tool (2001) State or local water departments, private utilities, regional or local planning commissions Potable Water Network System Pumps EPA Envirofacts Data Warehouse LRT Tool (2001) State or local water departments, private utilities, regional or local planning commissions Potable Water Control Vaults and Control Stations EPA Envirofacts Data Warehouse LRT Tool (2001) State or local water departments, private utilities, regional or local planning commissions Potable Water Network System Tanks EPA Envirofacts Data Warehouse LRT Tool (2001) State or local water departments, private utilities, regional or local planning commissions Potable Water Network System Wells EPA Envirofacts Data Warehouse LRT Tool (2001) State or local water departments, private utilities, regional or local planning commissions, well logs (local environmental agency water division) Potable Water System Facilities EPA Envirofacts Data Warehouse LRT Tool (2001) State or local water departments, private utilities, regional or local planning commissions Wastewater Pipelines EPA Envirofacts Data Warehouse LRT Tool (2001) State or local water departments, private utilities, regional or local planning commissions Wastewater Distribution Sewers (by Census tract) EPA Envirofacts Data Warehouse LRT Tool (2001) State, county, or local sewer commission/department Wastewater Treatment Plants EPA Envirofacts Data Warehouse LRT Tool (2001) State EMA Wastewater Vaults and Control Stations EPA Envirofacts Data Warehouse LRT Tool (2001) State EMA Wastewater Lift Stations EPA Envirofacts Data Warehouse LRT Tool (2001) State EMA Wastewater System Facilities EPA Envirofacts Data Warehouse LRT Tool (2001) State EMA Crude and Refined Oil Pipelines EPA Envirofacts Data Warehouse LRT Tool (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Oil Refineries State and local fire departments, environmental agencies, State EMA and LEPC, private companies Oil Pumping Plants EPA Envirofacts Data Warehouse LRT Tool (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Oil Tank Farm EPA Envirofacts Data Warehouse LRT Tool (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Oil Control Vaults and Control Stations EPA Envirofacts Data Warehouse LRT Tool (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Crude and Refined Oil Pipeline Facilities EPA Envirofacts Data Warehouse LRT Tool (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Natural Gas Pipelines EPA Envirofacts Data Warehouse LRT Tool (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Natural Gas Distribution Pipes (by Census tract) EPA Envirofacts Data Warehouse LRT Tool (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Natural Gas Compressor Plants EPA Envirofacts Data Warehouse LRT Tool (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Natural Gas Control Vaults and Control Stations EPA Envirofacts Data Warehouse LRT Tool (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Natural Gas Facilities EPA Envirofacts Data Warehouse LRT Tool (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Electric Power Plants EPA Envirofacts Data Warehouse LRT Tool (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Electric Power Substations EPA Envirofacts Data Warehouse LRT Tool (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Electric Power EPA Envirofacts Data Warehouse LRT Tool (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Communication Central Offices and Switching Stations Broadcast Auxiliary Microwave File, FCC (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Communication Vaults and Control Stations Broadcast Auxiliary Microwave File, FCC (2001) State and local fire departments, environmental agencies, State EMA and LEPC, private companies Communication Broadcast Facility Broadcast Auxiliary Microwave File, FCC (2001) Electronic Yellow Pages Communications Broadcast Auxiliary Microwave File, FCC (2001) Electronic Yellow Pages Demographics U.S. Census Bureau and Dun & Bradstreet (2000) Regional and local planning commissions, Tax assessor’s offices, zoning departments, regional and local planning commissions Notes: EPA = U.S. Environmental Protection Agency State EMA = State Emergency Management Agency FCC = U.S. Federal Communications Commission LEPC = Local Emergency Planning Committee BOTS = Bureau of Transportation Statistics USACE = U.S. Army Corps of Engineers ASFPM = American Society of Floodplain Managers DOT= Department of Transportation FHWA = Federal Highway Administration LRT = Locational Reference Table Job Aid: 3-2: Inventory Data by Category with Data Fields For example: Inventory category: Emergency Response General fields: ID Number, Building Class, Tract, Name, Address, City, Zip Code, State, Contact, Phone Number, Year Built, Number of Stories, Replacement Cost, Backup Power, Shelter Capacity, Building Area, Kitchen, Latitude, Longitude, Comment Hazard-Specific Fields For Earthquakes: Building Type, Building Quality, Design Level, Soil Type, Liquefaction Susceptibility, Landslide Susceptibility, Water Depth For Flood: Design Level, Foundation Type, First Floor Height, Building Damage Fnld, Content Damage Fnld, Flood Protection, BU Power For Hurricane: Hurricane Building Type, Hurricane Scheme Name