Touchstone 4.0 Database Documentation
tRRRR_HAZ_Detail Table
Description
Stores basic information about the results of a Hazard analysis.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 RowNumberUnique integer identifier for the row.Integer4   
Primary Key ExposureDataSourceSID

Unique system-generated sequential identifier for the exposure data source record.

For a complete list of records, see tDataSource Table.

Integer4   
Primary Key LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4   
 LocationIDUser-provided identifier for the location.VarChar100  
 ContractIDUser-provided identifier for the contract.VarChar100  
 CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

VarChar15  
 CountryNameName of the country.VarChar255  
 AreaCode

Area code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 AreaNameName of the area.VarChar255  
 SubareaCode

Subarea code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 SubareaNameName of the subarea.VarChar255  
 PostalCode

Postal code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 PostalNameName for the postal code.VarChar255  
 AddressStreet address for the location.VarChar255  
 CityCity in which the location resides.VarChar255  
 LatitudeLatitude coordinate for the city.  Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (9,6)  
 LongitudeLongitude coordinate for the city.  Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian.Numeric9 (9,6)  
 GeoMatchLevelCode

Code for the level at which geocode match occurred.

For a complete list of codes, see tGeoMatchLevel Table.

VarChar10  
 TotalReplacementValueTotal replacement value for all coverage combined. Double9  
 EQ100YearLossLevelRiskCode

Code that represents the loss level expected to occur due to earthquakes in the area analyzed during 1 year out of 100, or with a probability of 1% in any single year. Loss level risk is presented as a percentage of total value.

For a complete list of codes, see tLossLevelRisk Table.

SmallInt2  
 EQ250YearLossLevelRiskCode

Code that represents the loss level expected to occur due to earthquakes in the area analyzed during 1 year out of 250, or with a probability of 0.4% in any single year. Loss level risk is presented as a percentage of total value.

For a complete list of codes, see tLossLevelRisk Table.

SmallInt2  
 EQAverageAnnualLossLong-term average annual loss or the expected annual loss at the location analyzed due to an earthquake. Presented as a percentage of total value.Double9  
 EQSubareaRelativeRiskCode

Code that represents relative risk of a particular location due to an earthquake compared to the risk at other locations within the same subarea (county). Relative risk is presented as a percentile ranking.

For a complete list of codes, see tRelativeRisk Table.

SmallInt2  
 EQAreaRelativeRiskCode

Code that represents the relative risk of a particular location due to an earthquake compared to the risk at other locations within the same area (state). Relative risk is presented as a percentile ranking.

For a complete list of codes, see tRelativeRisk Table.

SmallInt2  
 EQSoilTypeCode

Code that represents the National Earthquake Hazards Reduction Program (NEHRP) soil type.  For more information, see http://earthquake.usgs.gov/regional/nca/soiltype/.

For a complete list of codes, see tSoilType Table.

SmallInt2  
 EQCaliforniaDOIZoneCode

Code that represents the California Department of Insurance Earthquake Zone Code. CA DOI Zone codes range from A1 – H, where A1 is the highest risk zone and H is the lowest risk zone.

For a complete list of codes, see tCaliforniaDOIZone Table.

SmallInt2  
 EQLiquefactionPotentialCode

Code that represents the soil liquefaction potential during an earthquake. For details, see http://quake.abag.ca.gov/liquefaction/.

For a complete list of codes, see tLiquefactionPotential Table.

SmallInt2  
 EQLandslideZone

Indicates whether the location being analyzed is within an earthquake landslide zone. 

  • 1 = Yes (within zone)
  • 0 = No (not within zone)

For more information, see http://quake.abag.ca.gov/landslides/  

Boolean1  
 EQAlquistPrioloFaultZone

Indicates whether the analyzed location is within an Alquist-Priolo Earthquake Fault zone . 

  • 1 = Yes (within zone)
  • 0 = No (not within zone)

For details, see maps at http://www.quake.ca.gov/gmaps/ap/ap_maps.htm .

Boolean1  
 EQIntensityByPEIntensity by Probability of Exceedance (PE); from tHazardAttribute Table.Xml16  
 EQIntensityByReturnPeriodIntensity by return period; from tHazardAttribute Table.Xml16  
 EQNearestFaultNameName of the fault nearest to the analyzed location. This information is saved in binary files. Touchstone calculates the name of the nearest fault using the latitude/longitude of the location.VarChar255  
 EQDistanceToNearestFaultDistance to the fault nearest to the analyzed location, in feet or miles. This information is saved in binary files. Touchstone calculates the distance to the nearest fault using the latitude/longitude of the location.Double9  
 EQDistanceToNearestFaultsNames of nearby faults and their distances from the analyzed location. This information is saved in binary files. Touchstone calculates the distance to the nearest faults using the latitude/longitude of the location.Xml16  
 EQHistoricalEarthquakesLocation, date, time, and magnitude of the most severe historical earthquakes that occurred near the analyzed location. For a list of historical earthquakes, see Appendix I of the California Earthquake Zoning and Probable Maximum Loss Evaluation Program document.Xml16  
 EQTopHistoricalEarthquakeNameName of the earthquake with the greatest magnitude in the area analyzed. Touchstone determines this information using the latitude and longitude of the analyzed area, along with information stored in binary files.VarChar255  
 EQTopHistoricalEarthquakeDateDate of the earthquake with the greatest magnitude in the analyzed area.VarWChar10  
 EQTopHistoricalEarthquakeMagnitudeMagnitude of the earthquake with the greatest magnitude in the analyzed area.Double9  
 TC100YearLossLevelRiskCode

Code that represents the level of loss expected to occur due to tropical cyclones (hurricanes) in the area analyzed during one year out of 100, or with a probability of 1% in any single year. Loss level risk is presented as a percentage of total value.

For a complete list of codes, see tLossLevelRisk Table.

SmallInt2  
 TC250YearLossLevelRiskCode

Code that represents the level of loss expected to occur due to tropical cyclones (hurricanes) in the area analyzed during one year out of 250, or with a probability of 0.4% in any single year. Loss level risk is presented as a percentage of total value.

For a complete list of codes, see tLossLevelRisk Table.

SmallInt2  
 TCAverageAnnualLossLong-term average annual loss , or the expected annual loss at the location analyzed due to a tropical cyclone. Presented as a percentage of total value.Double9  
 TCSubareaRelativeRiskCode

Code that represents the relative risk of a specified location due to a tropical cyclone compared to the risk at other locations within the same subarea (county). Relative risk is presented as a percentile ranking.

For a complete list of codes, see tRelativeRisk Table.

SmallInt2  
 TCAreaRelativeRiskCode

Code that represents the relative risk of a specified location due to a tropical cyclone compared to the risk at other locations within the same area (state). Relative risk is presented as a percentile ranking.

For a complete list of codes, see tRelativeRisk Table.

SmallInt2  
 TCStormSurgePotential

Indicates whether the location being analyzed is affected by storm surge.

  • 1 = Yes (affected by storm surge)
  • 0 = No (not affected by storm surge )
Boolean1  
 TCEffectiveDistanceToCoastCode

Code that represents the distance of a location from the “effective” coastline defined by AIR. An AIR “effective coastline” is smoothed for inlets, bays, and other irregularities. Touchstone excludes small inland waterways because their effect on hurricane wind speed is negligible.

For a complete list of codes, see tEffectiveDistanceToCoast Table.

SmallInt2  
 TCActualDistanceToCoastDistance of a location from the actual physical coastline. This is the distance used in ISO’s risk assessment tools.Double9  
 TCCoastalCounty

Indicates whether the location being analyzed is within a coastal county. 

  • 1 = Yes (within  a coastal county)
  • 0 = No (not within a coastal county)
Boolean1  
 TCElevationCode

Code that represents the elevation, in feet, above the mean sea level.

For a complete list of codes, see tElevation Table.

SmallInt2  
 TCTerrainCode

Code that represents the land use surrounding the location.

For a complete list of codes, see tTerrain Table.

SmallInt2  
 TCFWMExposureAreaCode

Code that represents the Tropical Cyclone Florida Wind Mitigation Exposure Area Code, which is the state-defined wind loss mitigation exposure area code. Applicable for Florida locations only.

For a complete list of codes, see tFWMExposureArea Table.

SmallInt2  
 TCFWMWindSpeedRegionCode

Code that represents the Tropical Cyclone Florida Wind Mitigation Wind Speed Region Code, which is the state-defined wind speed range at a specified location, in miles/hr. Applicable for Florida locations only. values include:

For a complete list of codes, see tFWMWindSpeedRegion Table.

SmallInt2  
 TCFWMWindborneDebrisRegion

Applicable to Florida locations only; Indicates whether the location being analyzed is within a Tropical Cyclone Florida Wind Mitigation Windborne Debris Region.

  • 1 = Yes (within windborne region)
  • 0 = No (not within a windborne region)
Boolean1  
 TCFWMHighVelocityWindRegion

Applicable to Florida locations only; Indicates whether the location being analyzed is within a Tropical Cyclone Florida Wind Mitigation High Velocity Wind Region.

  • 1 = Yes (within high velocity wind region)
  • 0 = No (not within high velocity wind region)
Boolean1  
 TCHistoricalHurricanesXML string that defines the historical hurricanes binary files.Xml16  
 TCTopHistoricalHurricaneNameName of the historical hurricane.VarChar255  
 TCTopHistoricalHurricaneDateOfLFLandfall date for the historical hurricane that occurred closest to the analyzed location.VarWChar10  
 TCTopHistoricalHurricaneIntensityToClosestIntensity of the top historical hurricane closest to the location analyzed, expressed as Category level.Double9  
 TS100YearLossLevelRiskCode

Code that represents the level of loss expected to occur due to thunder storms in the area analyzed during one year out of 100, or with a probability of 1% in any single year. Loss level risk is presented as a percentage of total value.

For a complete list of codes, see tLossLevelRisk Table.

SmallInt2  
 TS250YearLossLevelRiskCode

Code that represents the level of loss expected to occur due to thunder storms in the area analyzed during one year out of 250, or with a probability of 0.4% in any single year. Loss level risk is presented as a percentage of total value.

For a complete list of codes, see tLossLevelRisk Table.

SmallInt2  
 TSAverageAnnualLossLong-term average annual loss , or the expected annual loss at the location analyzed due to a thunder storm. Presented as a percentage of total value.Double9  
 TSSubareaRelativeRiskCode

Code that represents the relative risk of a specified location due to a thunder storm compared to the risk at other locations within the same subarea (county). Relative risk is presented as a percentile ranking.

For a complete list of codes, see tRelativeRisk Table.

SmallInt2  
 TSAreaRelativeRiskCode

Code that represents the relative risk of a specified location due to a thunder storm compared to the risk at other locations within the same area (state). Relative risk is presented as a percentile ranking.

For a complete list of codes, see tRelativeRisk Table.

SmallInt2  
 TSTornadoFrequencyCode

Code that represents the frequency of a tornado.

For a complete list of codes, see tTornadoFrequency Table.

SmallInt2  
 TSHailStormFrequencyCode

Code that represents the hail storm frequency.

For a complete list of codes, see tHailStormFrequency Table.

SmallInt2  
 TSSLWindStormFrequencyCode

Code that represents the frequency of straight line winds. 

For a complete list of codes, see tSLWindStormFrequency Table.

SmallInt2  
 TSNHTornadosNearest historical tornadoes; from tHazardAttribute Table.Xml16  
 TSNHHailStormsNearest historical hail storms; from tHazardAttribute Table.Xml16  
 TSNHStraightLineWindStormsNearest historical straight-line wind storms; from tHazardAttribute Table.Xml16  
 WS100YearLossLevelRiskCode

Code that represents the level of loss expected to occur due to winter storms in the area analyzed during one year out of 100, or with a probability of 1% in any single year. Loss level risk is presented as a percentage of total value.

For a complete list of codes, see tLossLevelRisk Table.

SmallInt2  
 WS250YearLossLevelRiskCode

Code that represents the level of loss expected to occur due to winter storms in the area analyzed during one year out of 250, or with a probability of 0.4% in any single year. Loss level risk is presented as a percentage of total value.

For a complete list of codes, see tLossLevelRisk Table.

SmallInt2  
 WSAverageAnnualLossLong-term average annual loss , or the expected annual loss at the location analyzed due to a winter storm. Presented as a percentage of total value.Double9  
 WSSubareaRelativeRiskCode

Code that represents the relative risk of a specified location due to a winter storm compared to the risk at other locations within the same subarea (county). Relative risk is presented as a percentile ranking.

For a complete list of codes, see tRelativeRisk Table.

SmallInt2  
 WSAreaRelativeRiskCode

Code that represents the relative risk of a specified location due to a winter storm compared to the risk at other locations within the same area (state). Relative risk is presented as a percentile ranking. 

For a complete list of codes, see tRelativeRisk Table.

SmallInt2  
 WSDamagingWindFrequencyCode

Code that represents the frequency of wind damage during a winter storm.

For a complete list of codes, see tDamagingWindFrequency Table.

SmallInt2  
 WSDamagingSnowFrequencyCode

Code that represents the frequency of damage from snow during a winter storm. 

For a complete list of codes, see tDamagingSnowFrequency Table.

SmallInt2  
 FLFloodSourceCode

Code that represents the source of the flood data.

For a complete list of codes, see tFloodSource Table.

SmallInt2  
 FLFloodZoneCode

Code that represents the flood zone code, which indicates the proximity of the analyzed location to a flood zone.

For a complete list of codes, see tFloodZone Table.

SmallInt2  
 FLFEMAFloodZoneCode

Code that represents the FEMA zone code, which indicates the proximity of the analyzed location to a flood zone.

For a complete list of codes, see tFEMAFloodZone Table.

SmallInt2  
 FLElevationCode

Code that represents the elevation, in feet, above the mean sea level.

For a complete list of codes, see tElevation Table.

SmallInt2  
 FLShortestDistanceToFEMAWaterBodyDistance, in miles or feet, from the analyzed location to the closest FEMA-defined body of water, such as an ocean, large lake, or large river.Double9  
 FLShortestDistanceTo100YearFloodPlainDistance, in miles or feet, from the analyzed location to the nearest 500-year flood plain. A 500-year flood plain is an area in which the flood boundary has a 1% or greater chance of being equaled or exceeded in any single year.Double9  
 FLShortestDistanceTo500YearFloodPlainDistance, in miles or feet, from the analyzed location to the nearest 500-year flood plain. A 500-year flood plain is an area in which the flood boundary has a 0.2% or greater chance of being equaled or exceeded in any single year.Double9  
 TE100YearLossLevelRiskCode

Code that represents the level of loss expected to occur due to terrorism events in the area analyzed during one year out of 100, or with a probability of 1% in any single year. Loss level risk is presented as a percentage of total value. 

For a complete list of codes, see tLossLevelRisk Table.

SmallInt2  
 TE250YearLossLevelRiskCode

Code that represents the level of loss expected to occur due to terrorism events in the area analyzed during one year out of 250, or with a probability of 0.4% in any single year. Loss level risk is presented as a percentage of total value. 

For a complete list of codes, see tLossLevelRisk Table.

SmallInt2  
 TEAverageAnnualLossLong-term average annual loss , or the expected annual loss at the location analyzed due to a terrorism event. Presented as a percentage of total value.Double9  
 TESubareaRelativeRiskCode

Code that represents the relative risk of a specified location due to a terrorism event compared to the risk at other locations within the same subarea (county). Relative risk is presented as a percentile ranking.

For a complete list of codes, see tRelativeRisk Table.

SmallInt2  
 TEAreaRelativeRiskCode

Code that represents the relative risk of a specified location due to a terrorism event compared to the risk at other locations within the same area (state). Relative risk is presented as a percentile ranking.

For a complete list of codes, see tRelativeRisk Table.

SmallInt2  
 TEDistanceToNearestLandmarkIndicates the distance of a terrorism event to the nearest landmark.Double9  
 TENearestLandMarkTypeIndicates the type of landmark that was closest to the terrorism event.VarChar340  
 TENearestLandMarkTypeCode

Code that represents the type of landmark that was closest to the terrorism event.

For a complete list of codes, see tLandmarkType Table.

VarChar10  
 AIRConstructionCode

Code that represents the AIR construction class.

For a complete list of codes, see tAIRConstruction Table.

SmallInt2  
 AIROccupancyCode

Code that represents the AIR occupancy class.

For a complete list of codes, see tAIROccupancy Table.

SmallInt2  
 ReplacementValueAAccumulated Replacement Value for Coverage A.Double9  
 ReplacementValueBAccumulated Replacement Value for Coverage B.Double9  
 ReplacementValueCAccumulated Replacement Value for Coverage C.Double9  
 ReplacementValueDAccumulated Replacement Value for Coverage D.Double9  
 FLBaseFloodElevationCode

Code that represents the elevation of the base flood, measured in feet.

For a complete list of codes, see tBaseFloodElevation Table.

SmallInt2  
 FLAIRFloodZoneCategoryCodeAIR flood zone category; from tHazardAttribute Table.SmallInt2  
 FLAIRShortestDistanceTo100YearFloodPlainAIR shortest distance to 100-year flood plain; from tHazardAttribute Table.Double9  
 FLAIRShortestDistanceTo500YearFloodPlainAIR shortest distance to 500-year flood plain; from tHazardAttribute Table.Double9  
 TSNHTornadosDateDate of the nearest historical tornado; from tHazardAttribute Table.DBTimeStamp4  
 TSNHTornadosSeveritySeverity of the the nearest historical tornado; from tHazardAttribute Table.Double9  
 TSNHHailStormsDateDate of the nearest historical hail storm; from tHazardAttribute Table.DBTimeStamp4  
 TSNHHailStormsSeveritySeverity of the the nearest historical hail storm; from tHazardAttribute Table.Double9  
 TSNHStraightLineWindStormsDateDate for the nearest historical straight-line windstorm; from tHazardAttribute Table.DBTimeStamp4  
 TSNHStraightLineWindStormsSeveritySeverity of the the nearest historical straight-line windstorm; from tHazardAttribute Table.Double9  
 SSStormSurgeZoneCodeCode that defines the storm surge category, from tHazardAttribute Table.SmallInt2  
 SSShortestDistanceTo100YearStormSurgeAIR shortest distance to 100-year storm surge zone; from tHazardAttribute Table.Double9  
 SSShortestDistanceTo250YearStormSurgeAIR shortest distance to 250-year storm surge zone; from tHazardAttribute Table.Double9  
 SSShortestDistanceTo500YearStormSurgeAIR shortest distance to 500-year storm surge zone; from tHazardAttribute Table.Double9  
 SSDepthFor100YearStormSurgeAIR storm surge depth for 100-year storm surge zone; from tHazardAttribute Table.SmallInt2  
 SSDepthFor250YearStormSurgeAIR storm surge depth for 250-year storm surge zone; from tHazardAttribute Table.SmallInt2  
 SSDepthFor500YearStormSurgeAIR storm surge depth for 500-year storm surge zone; from tHazardAttribute Table.SmallInt2  
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.