Stores detailed information about each event in the catalog for the United States and Canada Earthquake Model (Model 11).
AIREvents Database Documentation
TblModel11 Table
| Creation Date | 5/3/2019 12:48 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 186 |
| Data Space Used | 40.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| Actual_Year | Year the event occurred. | int | 4 |  | |||
| Event_Name | Name of the event. | varchar | 255 | | |||
| Catalog_Type | Code that represents the catalog type.
| char | 4 | ||||
| EventID | Unique system-provided identifier for the event. | int | 4 | ||||
| ModelID | Code that represents the model. | int | 4 | | |||
| Event | Identifier of 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 both the magnitude and the area 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. | numeric | 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 | | |||
| Fault_Segments | Number of fault segments that ruptured during the event. | 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. | numeric | 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. | 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. | varchar | 60 | | |||
| SubAreaName | Subarea where the event occurred. | varchar | 60 | | |||
| TsunamiEvent | Indicates whether this event triggered a tsunami.
| char | 1 | |