Description
Stores the possible the attributes of a hazard.
Properties
Creation Date | 2/16/2011 6:00 PM |
File Group | PRIMARY |
Text File Group | |
System Object | |
Published for Replication | |
Rows | 108 |
Data Space Used | 16.00 KB |
Index Space Used | 48.00 KB |
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula |
| HazardAttributeCode | 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
| smallint | 2 | | | |
| OutputTypeCode | Code that represents the output type.
For a complete list of codes, see tOutputType Table. | varchar | 10 | | | |
| HazardAttributeTypeCode | 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. | varchar | 5 | | | |
| SubsetHazardAttributeCode | 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. | smallint | 2 | | | |
| HazardAttribute | Name of the hazard attribute.
Corresponds to the code in HazardAttributeCode. | varchar | 255 | | | |
| HazardFieldName | Name for the hazard attribute type. | varchar | 255 | | | |
| HazardFieldType | SQL data type used to display the hazard field information. | varchar | 40 | | | |
| Description | Description of the hazard attribute. | varchar | 1024 | | | |
| HazardAttributeTableReferenceCode | Code that represents the reference table for the hazard attribute.
For a complete list of codes, see tHazardAttributeTableReference Table. | smallint | 2 | | | |
| DefaultValue | Identifies whether this is a default value.
- 1 = Yes (default)
- 0 = No (not default)
| varchar | 1024 | | | |
Objects that tHazardAttribute depends on
| Database Object | Object Type | Description | Dep Level |
| tHazardAttributeType | Table | Stores information regarding the possible hazard attribute types. | 1 |
See Also