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

For a complete list of records, see tDataSource Table.

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

User-provided identifier for the location.

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

For a complete list of codes, see tCountry Table.

Name of the country.

Area code for the location.

For a complete list of codes, see tGeography Table.

Subarea code for the location.

For a complete list of codes, see tGeography Table.

Postal code for the location.

For a complete list of codes, see tGeography Table.

Code for the level at which geocode match occurred.

For a complete list of codes, see tGeoMatchLevel Table.

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.

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.

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.

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.

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.

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.

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.

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/  

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 .

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.

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.

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.

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.

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

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

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.

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

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

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

For a complete list of codes, see tElevation Table.

Code that represents the land use surrounding the location.

For a complete list of codes, see tTerrain Table.

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.

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.

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)     

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)

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.

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.

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.

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.

Code that represents the frequency of a tornado.

For a complete list of codes, see tTornadoFrequency Table.

Code that represents the hail storm frequency.

For a complete list of codes, see tHailStormFrequency Table.

Code that represents the frequency of straight line winds.

For a complete list of codes, see tSLWindStormFrequency Table.

Nearest historical tornadoes from tHazardAttribute Table.

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.

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

For a complete list of codes, see tDamagingWindFrequency Table.

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

For a complete list of codes, see tDamagingSnowFrequency Table.

Code that represents the source of the flood data.

For a complete list of codes, see tFloodSource Table.

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

For a complete list of codes, see tFloodZone Table.

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.

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

For a complete list of codes, see tElevation Table.

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.

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.

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

For a complete list of codes, see tLandmarkType Table.

Code that represents the AIR construction class.

For a complete list of codes, see tAIRConstruction Table.

Code that represents the AIR occupancy class.

For a complete list of codes, see tAIROccupancy Table.

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

For a complete list of codes, see tBaseFloodElevation Table.

Code that represents the 2010 vintage of 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.

Code that represents the 2010 vintage of Tropical Cyclone Florida Wind Mitigation Wind Speed Region Code, which is the state-defined wind loss mitigation speed region code. Applicable for Florida locations only.

For a complete list of codes,

see tFWMWindSpeedRegion Table.

Code that represents the 2010 vintage of Tropical Cyclone Florida Wind Mitigation Wind borne Debris Region Code, which is state-defined wind loss debris region code. Applicable for Florida locations only.

Code that represents the geocode resource.

Geo = AIRGeography
RMS = RMS
SYNCSORT = Syncsort
TIG = Tiger
TOM = TOMTOM
TRI = Trillium
UN = Unknown
The premium geocodes obtained by licensing this feature are restricted for use only within Touchstone and cannot be used outside of Touchstone. These are identified by the GeocoderCode = 'Syncsort' column in Touchstone AIRExposure, AIRReference and AIRResults databases. For the Export feature, these premium geocodes are either encrypted or removed during export to comply with these contractual restrictions. Direct extracts of premium geocodes from the Touchstone databases are also contractually prohibited.