Stores detailed information about each simulated event in the time-independent catalog for the Japan Earthquake Model (Model 52).
AIREvents Database Documentation
TblModel52_TI Table
| Creation Date | 4/29/2014 3:01 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 340416 |
| Data Space Used | 70,968.00 KB |
| Index Space Used | 360.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | EventID | Unique system-provided identifier for the event. | decimal | 9 (18,0) | |||
| ModelID | Code that represents the model. | decimal | 9 (18,0) |  | |||
| Event | Identifier for the event. | decimal | 9 (18,0) | | |||
| Year | Year in the catalog that the event occurred. | decimal | 9 (18,0) | | |||
| Day | Day (within the Year) that the event occurred. | decimal | 9 (18,0) | | |||
| 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:
| nvarchar | 500 | | |||
| EQ_Depth | Depth of the earthquake's epicenter, measured in kilometers. | decimal | 9 (6,1) | | |||
| EQ_Source_Type | Source of the event.
| nvarchar | 500 | | |||
| 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. | nvarchar | 500 | | |||
| Epicenter | Indicates whether the epicenter occurred inland or offshore.
| nvarchar | 50 | | |||
| Magnitude | Moment magnitude value for the strength of the earthquake at its epicenter. | numeric | 9 (18,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. | numeric | 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. | numeric | 9 (8,3) | | |||
| AreaName | Area where the event occurred. | nvarchar | 50 | | |||
| SubAreaName | Subarea where the event occurred. | nvarchar | 50 | | |||
| TsunamiEvent | Indicates whether this event triggered a tsunami.
| varchar | 1 | |