Stores detailed information about each simulated event in the catalog for the Northwest Pacific Basinwide Typhoon Model (Model 60).
This consolidated catalog includes events for the following models:
| Creation Date | 10/9/2017 11:44 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 198167 |
| Data Space Used | 132,184.00 KB |
| Index Space Used | 504.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 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 country 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 first 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 measurement for the event was taken. 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 initial 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 measurement for the event was taken. 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 | | |||
| Landfall3 | Indicates whether the hurricane made landfall or bypassed at the third measurement point for the event.
| char | 1 | | |||
| 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 | Saffir–Simpson hurricane wind scale value at the third measurement point for the event. | 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 measurement for the event was taken. 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 | | |||
| Landfall4 | Indicates whether the hurricane made landfall or bypassed at the fourth measurement point for the event.
| char | 1 | | |||
| 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 measurement for the event was taken. 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 | | |||
| Landfall5 | Indicates whether the hurricane made landfall or bypassed at the fifth measurement point for the event.
| char | 1 | | |||
| 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 measurement for the event was taken. 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 | | |||
| Landfall6 | Indicates whether the hurricane made landfall or bypassed at the sixth measurement point for the event.
| char | 1 | | |||
| 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. | decimal | 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. | decimal | 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. | decimal | 9 (6,2) | | |||
| Speed6 | Forward momentum of the hurricane when the sixth measurement for the event was taken. Measured in miles/hour. | decimal | 9 (6,2) | | |||
| Angle6 | Angle, in relation to North, at which the event approached the sixth measurement point. | decimal | 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. | decimal | 9 (9,4) | | |||
| 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. | decimal | 9 (9,4) | | |||
| 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 | | |||
| 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. | decimal | 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. | decimal | 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. | decimal | 9 (6,2) | | |||
| Speed7 | Forward momentum of the hurricane when the seventh measurement for the event was taken. Measured in miles/hour. | decimal | 9 (6,2) | | |||
| Angle7 | Angle, in relation to North, at which the event approached the seventh measurement point. | decimal | 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. | decimal | 9 (9,4) | | |||
| 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. | decimal | 9 (9,4) | | |||
| 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 | | |||
| 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. | decimal | 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. | decimal | 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. | decimal | 9 (6,2) | | |||
| Speed8 | Forward momentum of the hurricane when the eighth measurement for the event was taken. Measured in miles/hour. | decimal | 9 (6,2) | | |||
| Angle8 | Angle, in relation to North, at which the event approached the eighth measurement point. | decimal | 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. | decimal | 9 (9,4) | | |||
| 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. | decimal | 9 (9,4) | | |||
| 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 | | |||
| Landfall9 | Indicates whether the hurricane made landfall or bypassed at the ninth measurement point for the event.
| char | 1 | | |||
| SaffSimpson9 | Saffir–Simpson hurricane wind scale value at the ninth measurement point for the event. | int | 4 | | |||
| SegmentID9 | Grid segment where the ninth measurement for the event was taken. | int | 4 | | |||
| CenPress9 | Central pressure when the ninth measurement for the event was taken. Measured in mBar. | decimal | 9 (6,1) | | |||
| MaxWind9 | Maximum wind speed sustained for one minute at 10 meters in height over water at RadMax9 when the ninth measurement for the event was taken. Measured in miles/hour. | decimal | 9 (6,1) | | |||
| RadMax9 | Radius of maximum wind (RMW), which is the distance between the center of a hurricane and its band of strongest winds, when the ninth measurement for the event was taken. Measured in miles. | decimal | 9 (6,2) | | |||
| Speed9 | Forward momentum of the hurricane when the ninth measurement for the event was taken. Measured in miles/hour. | decimal | 9 (6,2) | | |||
| Angle9 | Angle, in relation to North, at which the event approached the ninth measurement point. | decimal | 9 (6,2) | | |||
| Longitude9 | Longitude coordinate where the ninth 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) | | |||
| Latitude9 | Latitude coordinate where the ninth 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) | | |||
| Areaname9 | Area for the location of the closest ZIP centroid where the ninth measurement for the event was taken. | varchar | 60 | | |||
| SubAreaName9 | Subarea for the location of the closest ZIP centroid where the ninth measurement for the event was taken. | varchar | 60 | | |||
| Landfall10 | Indicates whether the hurricane made landfall or bypassed at the tenth measurement point for the event.
| char | 1 | | |||
| SaffSimpson10 | Saffir–Simpson hurricane wind scale value at the tenth measurement point for the event. | int | 4 | | |||
| SegmentID10 | Grid segment where the tenth measurement for the event was taken. | int | 4 | | |||
| CenPress10 | Central pressure when the tenth measurement for the event was taken. Measured in mBar. | decimal | 9 (6,1) | | |||
| MaxWind10 | Maximum wind speed sustained for one minute at 10 meters in height over water at RadMax10 when the tenth measurement for the event was taken. Measured in miles/hour. | decimal | 9 (6,1) | | |||
| RadMax10 | Radius of maximum wind (RMW), which is the distance between the center of a hurricane and its band of strongest winds, when the tenth measurement for the event was taken. Measured in miles. | decimal | 9 (6,2) | | |||
| Speed10 | Forward momentum of the hurricane when the tenth measurement for the event was taken. Measured in miles/hour. | decimal | 9 (6,2) | | |||
| Angle10 | Angle, in relation to North, at which the event approached the tenth measurement point. | decimal | 9 (6,2) | | |||
| Longitude10 | Longitude coordinate where the tenth 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) | | |||
| Latitude10 | Latitude coordinate where the tenth 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) | | |||
| Areaname10 | Area for the location of the closest ZIP centroid where the tenth measurement for the event was taken. | varchar | 60 | | |||
| SubAreaName10 | Subarea for the location of the closest ZIP centroid where the tenth measurement for the event was taken. | varchar | 60 | | |||
| Landfall11 | Indicates whether the hurricane made landfall or bypassed at the eleventh measurement point for the event.
| char | 1 | | |||
| SaffSimpson11 | Saffir–Simpson hurricane wind scale value at the eleventh measurement point for the event. | int | 4 | | |||
| SegmentID11 | Grid segment where the eleventh measurement for the event was taken. | int | 4 | | |||
| CenPress11 | Central pressure when the eleventh measurement for the event was taken. Measured in mBar. | decimal | 9 (6,1) | | |||
| MaxWind11 | Maximum wind speed sustained for one minute at 10 meters in height over water at RadMax11 when the eleventh measurement for the event was taken. Measured in miles/hour. | decimal | 9 (6,1) | | |||
| RadMax11 | Radius of maximum wind (RMW), which is the distance between the center of a hurricane and its band of strongest winds, when the eleventh measurement for the event was taken. Measured in miles. | decimal | 9 (6,2) | | |||
| Speed11 | Forward momentum of the hurricane when the eleventh measurement for the event was taken. Measured in miles/hour. | decimal | 9 (6,2) | | |||
| Angle11 | Angle, in relation to North, at which the event approached the eleventh measurement point. | decimal | 9 (6,2) | | |||
| Longitude11 | Longitude coordinate where the eleventh 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) | | |||
| Latitude11 | Latitude coordinate where the eleventh 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) | | |||
| Areaname11 | Area for the location of the closest ZIP centroid where the eleventh measurement for the event was taken. | varchar | 60 | | |||
| SubAreaName11 | Subarea for the location of the closest ZIP centroid where the eleventh measurement for the event was taken. | varchar | 60 | | |||
| Landfall12 | Indicates whether the hurricane made landfall or bypassed at the twelfth measurement point for the event.
| char | 1 | | |||
| SaffSimpson12 | Saffir–Simpson hurricane wind scale value at the twelfth measurement point for the event. | int | 4 | | |||
| SegmentID12 | Grid segment where the twelfth measurement for the event was taken. | int | 4 | | |||
| CenPress12 | Central pressure when the twelfth measurement for the event was taken. Measured in mBar. | decimal | 9 (6,1) | | |||
| MaxWind12 | Maximum wind speed sustained for one minute at 12 meters in height over water at RadMax1 when the twelfth measurement for the event was taken. Measured in miles/hour. | decimal | 9 (6,1) | | |||
| RadMax12 | Radius of maximum wind (RMW), which is the distance between the center of a hurricane and its band of strongest winds, when the twelfth measurement for the event was taken. Measured in miles. | decimal | 9 (6,2) | | |||
| Speed12 | Forward momentum of the hurricane when the twelfth measurement for the event was taken. Measured in miles/hour. | decimal | 9 (6,2) | | |||
| Angle12 | Angle, in relation to North, at which the event approached the twelfth measurement point. | decimal | 9 (6,2) | | |||
| Longitude12 | Longitude coordinate where the twelfth 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) | | |||
| Latitude12 | Latitude coordinate where the twelfth 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) | | |||
| Areaname12 | Area for the location of the closest ZIP centroid where the twelfth measurement for the event was taken. | varchar | 60 | | |||
| SubAreaName12 | Subarea for the location of the closest ZIP centroid where the twelfth measurement for the event was taken. | varchar | 60 | |