Stores hazard intensity information for events that cause loss to locations during a hazard analysis.
Touchstone 2022 Database Reference
tRRRR_HAZ_Intensity Table
| Creation Date | 4/11/2022 6:15 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 16.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| SliceID | For internal use. | smallint | 2 | ((1)) | |||
| CatalogTypeCode | Code that represents the catalog type. For a complete list of codes, see dbo.tCatalogType Table. | varchar | 10 | ||||
| PerilTypeCode | Code that represents the peril type. For a complete list of codes, see dbo.tPeril Table | int | 4 | ||||
| YearID | Unique identifier that tracks the scenario. In multi-year catalogs, each scenario actually consists of five modeled years. | int | 4 | ||||
| EventID | Unique system-provided identifier of the event that produced the loss. | int | 4 | ||||
| ExposureDataSourceSID | Unique system-generated sequential identifier for the exposure data source record. For a complete list of records, see dbo.tDataSource Table. | int | 4 | ||||
| LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see dbo.tLocation Table. | int | 4 | ||||
| ModelCode | Code that represents the catastrophe model. For a complete list of codes, see tModel Table. | smallint | 2 | ||||
| DisaggregationSID | Unique system-generated sequential identifier for the disaggregated location record. | int | 4 | ||||
| MaxWindSpeed | Maximum wind speed value for a tropical cyclone event. | float | 9 |  | |||
| MaxWindSpeedUnit | Code for the unit of measure used to express the wind speed. For a complete list of codes, see dbo.tUnit Table. | varchar | 10 | | |||
| Duration | Duration of the tropical cyclone event. | float | 9 | | |||
| DurationUnit | Code for the unit of measure used to express the duration. For a complete list of codes, see dbo.tUnit Table. | varchar | 10 | | |||
| StormSurgeDepth | Depth of the storm surge for a tropical cyclone event. | float | 9 | | |||
| StormSurgeDepthUnit | Code for the unit of measure used to express the storm surge depth. For a complete list of codes, see dbo.tUnit Table. | varchar | 10 | | |||
| OnPlainPrecipitationDepth | On-Plain or riverine flood depth of the tropical cyclone event due to precipitation. | float | 9 | | |||
| OnPlainPrecipitationDepthUnit | Code for the unit of measure used to express the OnPlainPrecipitationDepth value. Note: The term 'PrecipitationDepth' represents the flood or inundation depth for typhoon and non-typhoon flooding events. | varchar | 10 | | |||
| OffPlainPrecipitationDepth | Off-plain flood depth of the tropical cyclone event due to precipitation. | float | 9 | | |||
| OffPlainPrecipitationDepthUnit | Code for the unit of measure used to express the OffPlainPrecipitationDepth value. Note: The term 'PrecipitationDepth' represents the flood or inundation depth for typhoon and non-typhoon flooding events. | varchar | 10 | | |||
| PGA | Peak ground acceleration value for an earthquake event. | float | 9 | | |||
| PGAUnit | Code for the unit of measure used to express the peak ground acceleration. For a complete list of codes, see dbo.tUnit Table. | varchar | 10 | | |||
| SA03 | Spectral Acceleration 0.3 seconds value for an earthquake event. | float | 9 | | |||
| SA03Unit | Code for the unit of measure used to express the SA03 value. For a complete list of codes, see dbo.tUnit Table. | varchar | 10 | | |||
| SA10 | Spectral Acceleration 1.0 seconds value for an earthquake event. | float | 9 | | |||
| SA10Unit | Code for the unit of measure used to express the SA10 value. For a complete list of codes, see dbo.tUnit Table. | varchar | 10 | | |||
| IOnPlainFloodDepth | On-Plain or riverine flood depth of the inland flood event. | float | 9 | | |||
| IOnPlainFloodDepthUnit | Code for the unit of measure used to express the IOnPlainFloodDepth value. For a complete list of codes, see tUnit Table. | varchar | 10 | | |||
| IOffPlainFloodDepth | Off-plain flood depth of the inland flood event. | float | 9 | | |||
| IOffPlainFloodDepthUnit | Code for the unit of measure used to express the IOffPlainFloodDepth value. For a complete list of codes, see tUnit Table. | varchar | 10 | | |||
| Latitude | Latitude coordinate for the city. Values will be positive for locations north of the equator and negative south of the equator. | float | 9 | | |||
| Longitude | Longitude 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. | float | 9 | | |||
| LocationID | User-provided identifier for the location. | varchar | 100 | |