Stores detailed information about each event in the catalog for the North Atlantic Basinwide Hurricane Model (Model 27).
AIREvents Database Documentation
TblModel27 Table
| Creation Date | 4/8/2022 2:22 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 137 |
| Data Space Used | 80.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/CRESTA 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 | | |||
| CHI1 | Carvill hurricane index value at the initial measurement point for the event. | numeric | 9 (6,3) | | |||
| 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. | numeric | 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. | numeric | 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. | numeric | 9 (6,2) | | |||
| Speed1 | Forward momentum of the hurricane when the initial landfall occurred. Measured in miles/hour. | numeric | 9 (6,2) | | |||
| Angle1 | Angle, in relation to North, at which the event approached the initial measurement point. | numeric | 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 | | |||
| CHI2 | Carvill hurricane index value at the second measurement point for the event. | numeric | 9 (6,3) | | |||
| 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 initial measurement for the event was taken. Measured in mBar. | numeric | 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. | numeric | 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. | numeric | 9 (6,2) | | |||
| Speed2 | Forward momentum of the hurricane when the second landfall occurred. Measured in miles/hour. | numeric | 9 (6,2) | | |||
| Angle2 | Angle, in relation to North, at which the event approached the second measurement point. | numeric | 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 | | |||
| Landfall3 | Indicates whether the hurricane made landfall or bypassed at the third measurement point for the event.
| char | 1 | | |||
| CHI3 | Carvill hurricane index value at the third measurement point for the event. | numeric | 9 (6,3) | | |||
| SaffSimpson3 | Saffir–Simpson hurricane wind scale value at the third measurement point for the event. | int | 4 | | |||
| SegmentID3 | Grid segment where the third measurement for the event was taken. | int | 4 | | |||
| CenPress3 | Central pressure when the third measurement for the event was taken. Measured in mBar. | numeric | 9 (6,1) | | |||
| MaxWind3 | Maximum wind speed sustained for one minute at 10 meters in height over water at RadMax3 when the third measurement for the event was taken. Measured in miles/hour. | numeric | 9 (6,1) | | |||
| RadMax3 | Radius of maximum wind (RMW), which is the distance between the center of a hurricane and its band of strongest winds, when the third measurement for the event was taken. Measured in miles. | numeric | 9 (6,2) | | |||
| Speed3 | Forward momentum of the hurricane when the third landfall occurred. Measured in miles/hour. | numeric | 9 (6,2) | | |||
| Angle3 | Angle, in relation to North, at which the event approached the third measurement point. | numeric | 9 (6,2) | | |||
| Longitude3 | Longitude coordinate where the third 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) | | |||
| Latitude3 | Latitude coordinate where the third 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) | | |||
| AreaName3 | Area for the location of the closest ZIP centroid where the third measurement for the event was taken. | varchar | 60 | | |||
| SubAreaName3 | Subarea for the location of the closest ZIP centroid where the third measurement for the event was taken. | varchar | 60 | | |||
| Landfall4 | Indicates whether the hurricane made landfall or bypassed at the fourth measurement point for the event.
| char | 1 | | |||
| CHI4 | Carvill hurricane index value at the fourth measurement point for the event. | numeric | 9 (6,3) | | |||
| SaffSimpson4 | Saffir–Simpson hurricane wind scale value at the fourth measurement point for the event. | int | 4 | | |||
| SegmentID4 | Grid segment where the fourth measurement for the event was taken. | int | 4 | | |||
| CenPress4 | Central pressure when the fourth measurement for the event was taken. Measured in mBar. | numeric | 9 (6,1) | | |||
| MaxWind4 | Maximum wind speed sustained for one minute at 10 meters in height over water at RadMax4 when the fourth measurement for the event was taken. Measured in miles/hour. | numeric | 9 (6,1) | | |||
| RadMax4 | Radius of maximum wind (RMW), which is the distance between the center of a hurricane and its band of strongest winds, when the fourth measurement for the event was taken. Measured in miles. | numeric | 9 (6,2) | | |||
| Speed4 | Forward momentum of the hurricane when the fourth landfall occurred. Measured in miles/hour. | numeric | 9 (6,2) | | |||
| Angle4 | Angle, in relation to North, at which the event approached the fourth measurement point. | numeric | 9 (6,2) | | |||
| Longitude4 | Longitude coordinate where the fourth 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. | numeric | 9 (6,2) | | |||
| Latitude4 | Latitude coordinate where the fourth measurement for the event was taken. Values will be positive for locations north of the equator and negative south of the equator. | numeric | 9 (6,2) | | |||
| AreaName4 | Area for the location of the closest ZIP centroid where the fourth measurement for the event was taken. | varchar | 60 | | |||
| SubAreaName4 | Subarea for the location of the closest ZIP centroid where the fourth measurement for the event was taken. | varchar | 60 | | |||
| Landfall5 | Indicates whether the hurricane made landfall or bypassed at the fourth measurement point for the event.
| char | 1 | | |||
| CHI5 | Carvill hurricane index value at the fifth measurement point for the event. | numeric | 9 (6,3) | | |||
| SaffSimpson5 | Saffir–Simpson hurricane wind scale value at the fifth measurement point for the event. | int | 4 | | |||
| SegmentID5 | Grid segment where the fifth measurement for the event was taken. | int | 4 | | |||
| CenPress5 | Central pressure when the fifth measurement for the event was taken. Measured in mBar. | numeric | 9 (6,1) | | |||
| MaxWind5 | Maximum wind speed sustained for one minute at 10 meters in height over water at RadMax5 when the fifth measurement for the event was taken. Measured in miles/hour. | numeric | 9 (6,1) | | |||
| RadMax5 | Radius of maximum wind (RMW), which is the distance between the center of a hurricane and its band of strongest winds, when the fifth measurement for the event was taken. Measured in miles. | numeric | 9 (6,2) | | |||
| Speed5 | Forward momentum of the hurricane when the fifth landfall occurred. Measured in miles/hour. | numeric | 9 (6,2) | | |||
| Angle5 | Angle, in relation to North, at which the event approached the fifth measurement point. | numeric | 9 (6,2) | | |||
| Longitude5 | Longitude coordinate where the fifth 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. | numeric | 9 (6,2) | | |||
| Latitude5 | Latitude coordinate where the fifth measurement for the event was taken. Values will be positive for locations north of the equator and negative south of the equator. | numeric | 9 (6,2) | | |||
| AreaName5 | Area for the location of the closest ZIP centroid where the fifth measurement for the event was taken. | varchar | 60 | | |||
| SubAreaName5 | Subarea for the location of the closest ZIP centroid where the fifth measurement for the event was taken. | varchar | 60 | | |||
| Landfall6 | Indicates whether the hurricane made landfall or bypassed at the sixth measurement point for the event.
| char | 1 | | |||
| CHI6 | Carvill hurricane index value at the sixth measurement point for the event. | numeric | 9 (6,3) | | |||
| SaffSimpson6 | Saffir–Simpson hurricane wind scale value at the sixth measurement point for the event. | int | 4 | | |||
| SegmentID6 | Grid segment where the sixth measurement for the event was taken. | int | 4 | | |||
| CenPress6 | Central pressure when the sixth measurement for the event was taken. Measured in mBar. | numeric | 9 (6,1) | | |||
| MaxWind6 | Maximum wind speed sustained for one minute at 10 meters in height over water at RadMax6 when the sixth measurement for the event was taken. Measured in miles/hour. | numeric | 9 (6,1) | | |||
| RadMax6 | Radius of maximum wind (RMW), which is the distance between the center of a hurricane and its band of strongest winds, when the sixth measurement for the event was taken. Measured in miles. | numeric | 9 (6,2) | | |||
| Speed6 | Forward momentum of the hurricane when the sixth landfall occurred. Measured in miles/hour. | numeric | 9 (6,2) | | |||
| Angle6 | Angle, in relation to North, at which the event approached the sixth measurement point. | numeric | 9 (6,2) | | |||
| Longitude6 | Longitude coordinate where the sixth 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. | numeric | 9 (6,2) | | |||
| Latitude6 | Latitude coordinate where the sixth measurement for the event was taken. Values will be positive for locations north of the equator and negative south of the equator. | numeric | 9 (6,2) | | |||
| AreaName6 | Area for the location of the closest ZIP centroid where the sixth measurement for the event was taken. | varchar | 60 | | |||
| SubAreaName6 | Subarea for the location of the closest ZIP centroid where the sixth measurement for the event was taken. | varchar | 60 | | |||
| Landfall7 | Indicates whether the hurricane made landfall or bypassed at the seventh measurement point for the event.
| char | 1 | | |||
| CHI7 | Carvill hurricane index value at the seventh measurement point for the event. | numeric | 9 (6,3) | | |||
| SaffSimpson7 | Saffir–Simpson hurricane wind scale value at the seventh measurement point for the event. | int | 4 | | |||
| SegmentID7 | Grid segment where the seventh measurement for the event was taken. | int | 4 | | |||
| CenPress7 | Central pressure when the seventh measurement for the event was taken. Measured in mBar. | numeric | 9 (6,1) | | |||
| MaxWind7 | Maximum wind speed sustained for one minute at 10 meters in height over water at RadMax7 when the seventh measurement for the event was taken. Measured in miles/hour. | numeric | 9 (6,1) | | |||
| RadMax7 | Radius of maximum wind (RMW), which is the distance between the center of a hurricane and its band of strongest winds, when the seventh measurement for the event was taken. Measured in miles. | numeric | 9 (6,2) | | |||
| Speed7 | Forward momentum of the hurricane when the seventh landfall occurred. Measured in miles/hour. | numeric | 9 (6,2) | | |||
| Angle7 | Angle, in relation to North, at which the event approached the seventh measurement point. | numeric | 9 (6,2) | | |||
| Longitude7 | Longitude coordinate where the seventh 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. | numeric | 9 (6,2) | | |||
| Latitude7 | Latitude coordinate where the seventh measurement for the event was taken. Values will be positive for locations north of the equator and negative south of the equator. | numeric | 9 (6,2) | | |||
| AreaName7 | Area for the location of the closest ZIP centroid where the seventh measurement for the event was taken. | varchar | 60 | | |||
| SubAreaName7 | Subarea for the location of the closest ZIP centroid where the seventh measurement for the event was taken. | varchar | 60 | | |||
| Landfall8 | Indicates whether the hurricane made landfall or bypassed at the eighth measurement point for the event.
| char | 1 | | |||
| CHI8 | Carvill hurricane index value at the eighth measurement point for the event. | numeric | 9 (6,3) | | |||
| SaffSimpson8 | Saffir–Simpson hurricane wind scale value at the eighth measurement point for the event. | int | 4 | | |||
| SegmentID8 | Grid segment where the eighth measurement for the event was taken. | int | 4 | | |||
| CenPress8 | Central pressure when the eighth measurement for the event was taken. Measured in mBar. | numeric | 9 (6,1) | | |||
| MaxWind8 | Maximum wind speed sustained for one minute at 10 meters in height over water at RadMax8 when the eighth measurement for the event was taken. Measured in miles/hour. | numeric | 9 (6,1) | | |||
| RadMax8 | Radius of maximum wind (RMW), which is the distance between the center of a hurricane and its band of strongest winds, when the eighth measurement for the event was taken. Measured in miles. | numeric | 9 (6,2) | | |||
| Speed8 | Forward momentum of the hurricane when the eighth landfall occurred. Measured in miles/hour. | numeric | 9 (6,2) | | |||
| Angle8 | Angle, in relation to North, at which the event approached the eighth measurement point. | numeric | 9 (6,2) | | |||
| Longitude8 | Longitude coordinate where the eighth 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. | numeric | 9 (6,2) | | |||
| Latitude8 | Latitude coordinate where the eighth measurement for the event was taken. Values will be positive for locations north of the equator and negative south of the equator. | numeric | 9 (6,2) | | |||
| AreaName8 | Area for the location of the closest ZIP centroid where the eighth measurement for the event was taken. | varchar | 60 | | |||
| SubAreaName8 | Subarea for the location of the closest ZIP centroid where the eighth measurement for the event was taken. | varchar | 60 | |