Stores detailed information about each event in the catalog for the Canada Tropical Cyclone Model (Model 30).
AIREvents Database Documentation
TblModel30 Table
| Creation Date | 4/11/2019 3:03 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 13 |
| Data Space Used | 8.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.
| varchar | 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 Saffir–Simpson hurricane wind scale and the area code(s) affected by the hurricane. For more information regarding the specific area(s) affected by an event, see fields:
| varchar | 200 | | |||
| Landfall1 | Indicates whether the hurricane made landfall or bypassed at the initial measurement point for the event.
| char | 1 | | |||
| SaffSimpson1 | Saffir–Simpson hurricane wind scale value at the initial measurement point for the event. | int | 4 | | |||
| SegmentID1 | Grid segment where the initial measurement for the event was taken. | int | 4 | | |||
| CenPress1 | Central pressure when the initial measurement for the event was taken. Measured in mBar. | decimal | 9 (6,1) | | |||
| MaxWind1 | Maximum wind speed sustained for one minute at 10 meters in height over water at RadMax1 when the initial measurement for the event was taken. Measured in miles/hour. | decimal | 9 (6,1) | | |||
| RadMax1 | Radius of maximum wind (RMW), which is the distance between the center of a hurricane and its band of strongest winds, when the initial measurement for the event was taken. Measured in miles. | decimal | 9 (6,2) | | |||
| Speed1 | Forward momentum of the hurricane when the initial landfall occurred. Measured in miles/hour. | decimal | 9 (6,2) | | |||
| Angle1 | Angle, in relation to North, at which the event approached the initial measurement point. | decimal | 9 (6,2) | | |||
| Longitude1 | Longitude coordinate where the initial measurement for the event was taken. 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 (9,4) | | |||
| Latitude1 | Latitude coordinate where the initial measurement for the event was taken. Values will be positive for locations north of the equator and negative south of the equator. | decimal | 9 (9,4) | | |||
| Areaname1 | Area for the location of the closest ZIP centroid where the initial measurement for the event was taken. | varchar | 60 | | |||
| SubAreaName1 | Subarea for the location of the closest ZIP centroid where the initial measurement for the event was taken. | varchar | 60 | | |||
| Landfall2 | Indicates whether the hurricane made landfall or bypassed at the second measurement point for the event.
| char | 1 | | |||
| SaffSimpson2 | Saffir–Simpson hurricane wind scale value at the second measurement point for the event. | int | 4 | | |||
| SegmentID2 | Grid segment where the second measurement for the event was taken. | int | 4 | | |||
| CenPress2 | Central pressure when the second measurement for the event was taken. Measured in mBar. | decimal | 9 (6,1) | | |||
| MaxWind2 | Maximum wind speed sustained for one minute at 10 meters in height over water at RadMax2 when the second measurement for the event was taken. Measured in miles/hour. | decimal | 9 (6,1) | | |||
| RadMax2 | Radius of maximum wind (RMW), which is the distance between the center of a hurricane and its band of strongest winds, when the second measurement for the event was taken. Measured in miles. | decimal | 9 (6,2) | | |||
| Speed2 | Forward momentum of the hurricane when the second landfall occurred. Measured in miles/hour. | decimal | 9 (6,2) | | |||
| Angle2 | Angle, in relation to North, at which the event approached the second measurement point. | decimal | 9 (6,2) | | |||
| Longitude2 | Longitude coordinate where the second measurement for the event was taken. 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 (9,4) | | |||
| Latitude2 | Latitude coordinate where the second measurement for the event was taken. Values will be positive for locations north of the equator and negative south of the equator. | decimal | 9 (9,4) | | |||
| Areaname2 | Area for the location of the closest ZIP centroid where the second measurement for the event was taken. | varchar | 60 | | |||
| SubAreaName2 | Subarea for the location of the closest ZIP centroid where the second measurement for the event was taken. | varchar | 60 | |