Stores detailed information about each simulated event in the catalog for the Hawaii Tropical Cyclone Model (Model 23).
AIREvents Database Documentation
TblModel23 Table
| Creation Date | 5/13/2014 2:25 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 2106 |
| Data Space Used | 656.00 KB |
| Index Space Used | 16.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 both the Saffir–Simpson hurricane wind scale and the subarea code(s) affected by the hurricane. For more information regarding the specific area(s) affected by an event, see fields:
| varchar | 200 | | |||
| Landfall | 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 | | |||
| 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 | | |||
| 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. | decimal | 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. | decimal | 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. | decimal | 9 (6,2) | | |||
| Speed3 | Forward momentum of the hurricane when the third landfall occurred. Measured in miles/hour. | decimal | 9 (6,2) | | |||
| Angle3 | Angle, in relation to North, at which the event approached the third measurement point. | decimal | 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 | | |||
| 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. | decimal | 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. | decimal | 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. | decimal | 9 (6,2) | | |||
| Speed4 | Forward momentum of the hurricane when the fourth landfall occurred. Measured in miles/hour. | decimal | 9 (6,2) | | |||
| Angle4 | Angle, in relation to North, at which the event approached the fourth measurement point. | decimal | 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. | decimal | 9 (9,4) | | |||
| 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. | decimal | 9 (9,4) | | |||
| 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 | | |||
| 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. | decimal | 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. | decimal | 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. | decimal | 9 (6,2) | | |||
| Speed5 | Forward momentum of the hurricane when the fifth landfall occurred. Measured in miles/hour. | decimal | 9 (6,2) | | |||
| Angle5 | Angle, in relation to North, at which the event approached the fifth measurement point. | decimal | 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. | decimal | 9 (9,4) | | |||
| 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. | decimal | 9 (9,4) | | |||
| 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 | |