Touchstone 4.0 Database Documentation
tRRRR_HAZ_Intensity Table
Description
Stores detailed hazard information for events that cause loss to specific locations during a hazard analysis.
Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
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 CatalogTypeCode

Code that represents the catalog type.

For a complete list of codes, see dbo.tCatalogType Table.

VarChar10   
Primary Key PerilTypeCode

Code that represents the peril type.

For a complete list of codes, see dbo.tPeril Table 

Integer4   
Primary Key YearIDUnique identifier that tracks the scenario. In multi-year catalogs, each scenario actually consists of five modeled years.Integer4   
Primary Key EventIDUnique system-provided identifier of the event that produced the loss.Integer4   
Primary Key ExposureDataSourceSID

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

For a complete list of records, see dbo.tDataSource Table.

Integer4   
Primary Key LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see dbo.tLocation Table.

Integer4   
Primary Key ModelCode

Code that represents the catastrophe model.

For a complete list of codes, see tModel Table.

UnsignedTinyInt1   
Primary Key DisaggregationSID

Unique system-generated sequential identifier for the disaggregated location record.

Integer4   
 MaxWindSpeedMaximum wind speed value for a tropical cyclone event.Double9  
 MaxWindSpeedUnit

Code for the unit of measure used to express the wind speed.

For a complete list of codes, see dbo.tUnit Table.

VarChar10  
 DurationDuration of the tropical cyclone event.Double9  
 DurationUnit

Code for the unit of measure used to express the duration.

For a complete list of codes, see dbo.tUnit Table.

VarChar10  
 StormSurgeDepthDepth of the storm surge for a tropical cyclone event.Double9  
 StormSurgeDepthUnit

Code for the unit of measure used to express the storm surge depth.

For a complete list of codes, see dbo.tUnit Table.

VarChar10  
 PGAPeak ground acceleration value for an earthquake event.Double9  
 PGAUnit

Code for the unit of measure used to express the peak ground acceleration.

For a complete list of codes, see dbo.tUnit Table.

VarChar10  
 SA03Spectral Acceleration 0.3 seconds value for an earthquake event.Double9  
 SA03Unit

Code for the unit of measure used to express the SA03 value.

For a complete list of codes, see dbo.tUnit Table.

VarChar10  
 SA10Spectral Acceleration 1.0 seconds value for an earthquake event.Double9  
 SA10Unit

Code for the unit of measure used to express the SA10 value.

For a complete list of codes, see dbo.tUnit Table.

VarChar10  
 EventSetSID

Unique system-generated sequential identifier for the event set record.

For a complete list of records, see dbo.tEventSet Table.

Integer4  
 LatitudeLatitude coordinate for the city.  Values will be positive for locations north of the equator and negative south of the equator.Double9  
 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.Double9  
 LocationID

User-provided identifier for the location.

VarChar100  
See Also

Related Objects

AIRExposureSummary Database

 

 


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.