CEDE 9.0 Database Reference
tHazardAttribute Table
AIRReference Database : tHazardAttribute Table
Description

Stores the possible the attributes of a hazard.

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows108
Data Space Used16.00 KB
Index Space Used48.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Code that represents the hazard attribute.

  • 101 = Earthquake 100 Year Loss Level
  • 102 =  Earthquake 250 Year Loss Level
  • 103 = Earthquake Average Annual Loss
  • 104 = Earthquake Relative Risk County
  • 105 = Earthquake Relative Risk State
  • 106 = Earthquake Soil Type
  • 107 = Earthquake California DOI Zone
  • 108 = Earthquake Liquefaction Potential
  • 109 = Earthquake Landslide Zone
  • 110 = Earthquake Alquist-Priolo Fault Zone
  • 111 = Earthquake Intensity by Probability of Exceedance (PE)
  • 112 = Earthquake Intensity by Return Period
  • 113 = Earthquake Nearest Fault Name
  • 114 = Earthquake Distance to Nearest Fault
  • 115 = Earthquake Distance to Nearest Faults
  • 116 = Historical Earthquakes
  • 117 = Top Historical Earthquake Name
  • 118 = Top Historical Earthquake Date
  • 119 = Top Historical Earthquake Magnitude
  • 120 = Earthquake MMI PE VI
  • 121 = Earthquake MMI PE VII
  • 122 = Earthquake MMI PE VIII
  • 123 = Earthquake MMI PE IX
  • 124 = Earthquake MMI PE X
  • 125 = Earthquake MMI PE XI
  • 126 = Earthquake MMI PE XII
  • 127 = Earthquake 100 Year MMI Intensity by Return Period
  • 128 = Earthquake 200 Year MMI Intensity by Return Period
  • 129 = Earthquake 250 Year MMI Intensity by Return Period
  • 130 = Earthquake 475 Year MMI Intensity by Return Period
  • 201 = Tropical Cyclone 100 Year Loss Level
  • 202 = Tropical Cyclone  250 Year Loss Level
  • 203 = Tropical Cyclone  Average Annual Loss
  • 204 = Tropical Cyclone  Relative Risk County
  • 205 = Tropical Cyclone  Relative Risk State
  • 206 = Tropical Cyclone  Storm Surge Potential
  • 207 = Tropical Cyclone  Distance to effective (AIR) coast
  • 208 = Tropical Cyclone  Distance to actual (ISO) coast
  • 209 =  Tropical Cyclone  Coastal County
  • 210 =  Tropical Cyclone  Elevation
  • 211 = Tropical Cyclone  Terrain
  • 212 = Tropical Cyclone  Florida Wind Mitigation – Exposure Area
  • 213 = Tropical Cyclone  Florida Wind Mitigation – Wind Speed Region
  • 214 = Tropical Cyclone  Florida Wind Mitigation – Windborne Debris Region
  • 215 = Tropical Cyclone  Florida Wind Mitigation – High Velocity Wind Region
  • 216 = Historical Hurricanes
  • 217 = Top Historical Hurricane Name
  • 218 = Top Historical Hurricane Date of Landfall
  • 219 = Top Historical Hurricane Intensity at Closest Location
  • 220 = SS Storm Surge Category
  • 221 = Shortest Distance to 100 Year SS Storm Surge
  • 222 = Shortest Distance to 250 Year SS Storm Surge
  • 223 = Shortest Distance to 500 Year SS Storm Surge
  • 224 = Depth for 100 year Storm Surge
  • 225 = Depth for 250 year Storm Surge
  • 226 = Depth for 500 year Storm Surge
  • 227 = Florida Wind Mitigation – Exposure Area 2010
  • 228 = Florida Wind Mitigation – Wind Speed Region 2010 
  • 229 = Florida Wind Mitigation – Windborne Debris Region 2010
  • 230 = Florida Wind Mitigation – High Velocity Wind Region 2010
  • 301 = Severe Thunderstorm 100 Year Loss level
  • 302 = Severe Thunderstorm 250 Year Loss Level
  • 303 = Severe Thunderstorm Average Annual Loss
  • 304 = Severe Thunderstorm Relative Risk County
  • 305 = Severe Thunderstorm Relative Risk State
  • 306 = Severe Thunderstorm Tornado Frequency
  • 307 = Severe Thunderstorm Hail Storm Frequency
  • 308 = Severe Thunderstorm Straight-Line Wind Storm Frequency
  • 309 = Severe Thunderstorm Nearest Historical Tornados
  • 310 = Severe Thunderstorm Nearest Historical Hail Storms
  • 311 = Severe Thunderstorm Nearest Historical Straight-Line Windstorms
  • 312 = Severe Thunderstorm Nearest Historical Tornados Date
  • 313 = Severe Thunderstorm Nearest Historical Tornados Severity
  • 314 = Severe Thunderstorm Nearest Historical Hail Storms Date
  • 315 = Nearest Historical Hail Storm Severity
  • 316 = Nearest Historical Straight-Line Wind Storms Date
  • 317 = Severe Thunderstorm Nearest Historical Straight-Line Windstorms Severity
  • 401 = Winter Storm 100 Year Loss Level
  • 402 = Winter Storm 250 Year Loss Level
  • 403 = Winter Storm Average Annual Loss
  • 404 = Winter Storm Relative Risk County
  • 405 = Winter Storm Relative Risk State
  • 406 = Winter Storm Damaging Wind Frequency
  • 407 = Winter Storm Damaging Snow Frequency
  • 501 = Flood Source
  • 502 = Flood Zone
  • 503 = FEMA Flood Zone
  • 504 = Elevation
  • 505 = Shortest Distance to FEMA Water Body
  • 506 = Shortest Distance to 100-year Flood Plain
  • 507 = Shortest Distance to 500-year Flood Plain
  • 508 = Base Flood Elevation
  • 509 = AIR Flood Zone Category
  • 510 = AIR Shortest Distance to 100-year Flood Plain
  • 511 = AIR Shortest Distance to 500-year Flood Plain
  • 601 = Terrorism 100 Year Loss Level
  • 602 = Terrorism 250 Year Loss Level
  • 603 = Terrorism Average Annual Loss
  • 604 = Terrorism Relative Risk County
  • 605 = Terrorism Relative Risk State
  • 606 = Terrorism Distance to Nearest Landmark
  • 607 = Terrorism Landmark Type
  • 701 = Construction
  • 702 = Occupancy
  • 703 = Replacement Value A
  • 704 = Replacement Value B
  • 705 = Replacement Value C
  • 706 = Replacement Value D
smallint2   
 

Code that represents the output type.

For a complete list of codes, see tOutputType Table.

varchar10   
 

Code that represents the hazard attribute type, which is used to indicate if the attribute takes a range of value or just single value.

For a complete list of codes, see tHazardAttributeType Table.

varchar5   
 

Code that represents the hazard attribute subset hierarchy when applicable.  

For example, HazardAttributeCodes 117, 118, and 119 have a SubsetHazardAttributeCode of 116. 

The codes are the same as listed in HazardAttributeCode.

smallint2  
 

Name of the hazard attribute.

Corresponds to the code in HazardAttributeCode.

varchar255  
 Name for the hazard attribute type.varchar255  
 SQL data type used to display  the hazard field information.varchar40  
 

Description of the hazard attribute.

varchar1024  
 

Code that represents the reference table for the hazard attribute.

For a complete list of codes, see tHazardAttributeTableReference Table.

smallint2  
 

Identifies whether this is a default value.

  • 1 = Yes (default)
  • 0 = No (not default)
varchar1024  
Objects that tHazardAttribute depends on
 Database ObjectObject TypeDescriptionDep Level
tHazardAttributeType tabletHazardAttributeTypeTable

Stores information regarding the possible hazard attribute types.

1
See Also

Related Objects

AIRReference Database