Stores detailed information about each simulated event in the time-independent catalog for the New Zealand Earthquake Model (Model 53).
AIREvents Database Documentation
TblModel53_TI Table
| Creation Date | 4/5/2019 10:45 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 36747 |
| Data Space Used | 6,008.00 KB |
| Index Space Used | 32.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | EventID | Unique system-provided identifier for the event. | int | 4 | |||
| ModelID | Code that represents the model. | int | 4 |  | |||
| Event | Identifier for the event. | int | 4 | | |||
| Year | Year in the catalog that the event occurred. | int | 4 | | |||
| Day | Day (within the Year) that the event occurred. | int | 4 | | |||
| EventDescription | Name/description of the event. Note that the description includes the magnitude of earthquake and the subarea code(s) affected by the earthquake. For more information regarding the specific area affected by an event, see fields:
| varchar | 200 | | |||
| EQ_Depth | Depth of the earthquake's epicenter, measured in kilometers. | decimal | 9 (6,1) | | |||
| EQ_Source_Type | Source of the event.
| varchar | 200 | | |||
| EQ_Fault_Name | When EQ_Source_Type is Crustal Fault or Subduction-Fault, this identifies the name of the fault associated with the event. Otherwise this field is not applicable. | varchar | 200 | | |||
| Fault_Type | Identifies the type of fault associated with the event.
| char | 1 | | |||
| Rupture_Length | Length in kilometers of the area on the fault that ruptured during the event. | decimal | 9 (6,1) | | |||
| Rupture_Width | Width in kilometers of the area on the fault that ruptured during the event. | decimal | 9 (6,1) | | |||
| Dip | Angle between the rupture plane and the surface of the Earth. | int | 4 | | |||
| Dip_Azimuth | 90 degrees clockwise of the rupture azimuth, where the rupture azimuth is the angle between true North and the line of intersection between the rupture plane and the surface of the Earth, measured clockwise from north as viewed from above. | int | 4 | | |||
| Epicenter | Indicates whether the epicenter occurred inland or offshore.
| char | 1 | | |||
| Magnitude | Moment magnitude value for the strength of the earthquake at its epicenter. | decimal | 9 (6,3) | | |||
| Longitude | Longitude coordinate where the epicenter of the event occurred. 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. | decimal | 9 (8,3) | | |||
| Latitude | Latitude coordinate where the epicenter of the event occurred. Values will be positive for locations north of the equator and negative south of the equator. | decimal | 9 (8,3) | | |||
| AreaName | Area where the event occurred. | varchar | 60 | | |||
| SubAreaName | Subarea where the event occurred. | varchar | 60 | | |||
| TsunamiEvent | Indicates whether the event triggered a tsunami.
| char | 1 | | |||
| TransientSeismicity | Indicates whether the event represents a Transient Elevated Localized Seismicity (TELS) event. TELS events represent the temporary increase in seismicity for surrounding areas of recent events, including the 2010/2011 Canterbury Earthquake Swarm (CES) and the 2016 Kaikoura Earthquake.
| char | 1 | |