AIREvents Database Documentation
TblModel27_WSST Table
AIREvents Database : TblModel27_WSST Table
Description

Stores detailed information about each simulated event in the warm sea surface temperature (WSST) catalog for the North Atlantic Basinwide Hurricane Model (Model 27).

This consolidated catalog includes events for the following models:

  • Hurricane Model for the United States
  • United States Hurricane Model for Offshore Assets
  • Tropical Cyclone Model for the Caribbean
  • Tropical Cyclone Model for Central America
  • Tropical Cyclone Model for Mexico
Properties
Creation Date3/6/2019 1:35 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows149797
Data Space Used71,896.00 KB
Index Space Used280.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key Unique system-provided identifier for the event.int4   
 

Code that represents the model.

int4  
 

Identifier of the event.

int4  
 

Year in the catalog that the event occurred.

int4  
 Day (within the Year) that the event occurred.int4  
 

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:

  • Latitude
  • Longitude
  • AreaName
  • SubAreaName
varchar200  
 

Indicates whether the hurricane made landfall or bypassed at the initial measurement point for the event.

  • B = Bypass
  • L = Landfall
char1  
 

Carvill hurricane index value at the initial measurement point for the event.

decimal9 (6,3)  
 
Saffir–Simpson hurricane wind scale value at the initial measurement point for the event.
int4  
 

Grid segment where the initial measurement for the event was taken.

int4  
 

Central pressure when the initial measurement for the event was taken. Measured in mBar.

decimal9 (6,1)  
 

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.

decimal9 (6,1)  
 

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.

decimal9 (6,2)  
 

Forward momentum of the hurricane when the initial measurement for the event was taken. Measured in miles/hour.

decimal9 (6,2)  
 

Angle, in relation to North, at which the event approached the initial measurement point.

decimal9 (6,2)  
 

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.

decimal9 (9,4)  
 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.decimal9 (9,4)  
 Area for the location of the closest ZIP centroid
where the initial measurement for the event was taken.
varchar60  
 Subarea for the location of the closest ZIP
centroid where the initial measurement for the event
was taken.
varchar60  
 

Indicates whether the hurricane made landfall or bypassed at the second measurement point for the event. 

  • B = Bypass
  • L = Landfall
char1  
 

Carvill hurricane index value at the second measurement point for the event.

decimal9 (6,3)  
 Saffir-Simpson hurricane wind scale value at the second measurement point for the event.int4  
 

Grid segment where the second measurement for the event was taken.

int4  
 

Central pressure when the second measurement for the event was taken. Measured in mBar.

decimal9 (6,1)  
 

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.

decimal9 (6,1)  
 

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.

decimal9 (6,2)  
 

Forward momentum of the hurricane when the second measurement for the event was taken. Measured in miles/hour.

decimal9 (6,2)  
 

Angle, in relation to North, at which the event approached the second measurement point.

decimal9 (6,2)  
 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.decimal9 (9,4)  
 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.decimal9 (9,4)  
 Area for the location of the closest ZIP centroid
where the initial measurement for the event was taken.
varchar60  
 Subarea for the location of the closest ZIP
centroid where the initial measurement for the event
was taken.
varchar60  
 

Indicates whether the hurricane made landfall or bypassed at the third measurement point for the event. 

  • B = Bypass
  • L = Landfall
char1  
 

Carvill hurricane index value at the third measurement point for the event.

decimal9 (6,3)  
 Saffir–Simpson hurricane wind scale value at the third measurement point for the event.int4  
 

Grid segment where the third measurement for the event was taken.

int4  
 

Central pressure when the third measurement for the event was taken. Measured in mBar.

decimal9 (6,1)  
 

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.

decimal9 (6,1)  
 

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.

decimal9 (6,2)  
 

Forward momentum of the hurricane when the third landfall occurred. Measured in miles/hour.

decimal9 (6,2)  
 

Angle, in relation to North, at which the event approached the third measurement point.

decimal9 (6,2)  
 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.decimal9 (9,4)  
 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.decimal9 (9,4)  
 Area for the location of the closest ZIP centroid
where the initial measurement for the event was taken.
varchar60  
 Subarea for the location of the closest ZIP
centroid where the initial measurement for the event
was taken.
varchar60  
 

Indicates whether the hurricane made landfall or bypassed at the fourth measurement point for the event. 

  • B = Bypass
  • L = Landfall
char1  
 

Carvill hurricane index value at the fourth measurement point for the event.

decimal9 (6,3)  
 Saffir–Simpson hurricane wind scale value at the fourth measurement point for the event.int4  
 

Grid segment where the fourth measurement for the event was taken.

int4  
 

Central pressure when the fourth measurement for the event was taken. Measured in mBar.

decimal9 (6,1)  
 

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.

decimal9 (6,1)  
 

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.

decimal9 (6,2)  
 

Forward momentum of the hurricane when the fourth measurement for the event was taken. Measured in miles/hour.

decimal9 (6,2)  
 

Angle, in relation to North, at which the event approached the fourth measurement point.

decimal9 (6,2)  
 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.decimal9 (9,4)  
 Latitude coordinate where the 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.decimal9 (9,4)  
 Area for the location of the closest ZIP centroid
where the initial measurement for the event was taken.
varchar60  
 Subarea for the location of the closest ZIP
centroid where the initial measurement for the event
was taken.
varchar60  
 

Indicates whether the hurricane made landfall or bypassed at the fifth measurement point for the event. 

  • B = Bypass
  • L = Landfall
char1  
 

Carvill hurricane index value at the fifth measurement point for the event.

decimal9 (6,3)  
 Saffir–Simpson hurricane wind scale value at the fifth measurement point for the event.int4  
 

Grid segment where the fifth measurement for the event was taken.

int4  
 

Central pressure when the fifth measurement for the event was taken. Measured in mBar.

decimal9 (6,1)  
 

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.

decimal9 (6,1)  
 

Maximum wind speed when the fifth measurement for the event was taken. Measured in miles/hour.

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.

decimal9 (6,2)  
 

Forward momentum of the hurricane when the fifth measurement for the event was taken. Measured in miles/hour.

decimal9 (6,2)  
 

Angle, in relation to North, at which the event approached the fifth measurement point.

decimal9 (6,2)  
 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.decimal9 (9,4)  
 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.decimal9 (9,4)  
 Area for the location of the closest ZIP centroid
where the initial measurement for the event was taken.
varchar60  
 Subarea for the location of the closest ZIP
centroid where the initial measurement for the event
was taken.
varchar60  
 

Indicates whether the hurricane made landfall or bypassed at the sixth measurement point for the event.

  • B = Bypass
  • L = Landfall
char1  
 

Carvill hurricane index value at the sixth measurement point for the event.

decimal9 (6,3)  
 Saffir–Simpson hurricane wind scale value at the sixth measurement point for the event.int4  
 

Grid segment where the sixth measurement for the event was taken.

int4  
 

Central pressure when the sixth measurement for the event was taken. Measured in mBar.

decimal9 (6,1)  
 

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.

decimal9 (6,1)  
 

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.

decimal9 (6,2)  
 

Forward momentum of the hurricane when the sixth measurement for the event was taken. Measured in miles/hour.

decimal9 (6,2)  
 

Angle, in relation to North, at which the event approached the sixth measurement point.

decimal9 (6,2)  
 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.decimal9 (9,4)  
 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.decimal9 (9,4)  
 Area for the location of the closest ZIP centroid
where the initial measurement for the event was taken.
varchar60  
 Subarea for the location of the closest ZIP
centroid where the initial measurement for the event
was taken.
varchar60  
 

Indicates whether the hurricane made landfall or bypassed at the seventh measurement point for the event.

  • B = Bypass
  • L = Landfall
char1  
 

Carvill hurricane index value at the seventh measurement point for the event.

decimal9 (6,3)  
 Saffir–Simpson hurricane wind scale value at the seventh measurement point for the event.int4  
 

Grid segment where the seventh measurement for the event was taken.

int4  
 

Central pressure when the seventh measurement for the event was taken. Measured in mBar.

decimal9 (6,1)  
 

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.

decimal9 (6,1)  
 

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.

decimal9 (6,2)  
 

Forward momentum of the hurricane when the seventh measurement for the event was taken.  Measured in miles/hour.

decimal9 (6,2)  
 

Angle, in relation to North, at which the event approached the seventh measurement point.

decimal9 (6,2)  
 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.decimal9 (9,4)  
 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.decimal9 (9,4)  
 Area for the location of the closest ZIP centroid
where the initial measurement for the event was taken.
varchar60  
 Subarea for the location of the closest ZIP
centroid where the initial measurement for the event
was taken.
varchar60  
 

Indicates whether the hurricane made landfall or bypassed at the eighth measurement point for the event.

  • B = Bypass
  • L = Landfall
char1  
 

Carvill hurricane index value at the eighth measurement point for the event.

decimal9 (6,3)  
 Saffir–Simpson hurricane wind scale value at the eighth measurement point for the event.int4  
 Grid segment where the eighth measurement for the event was taken.int4  
 Central pressure when the eighth measurement for the event was taken. Measured in mBar.decimal9 (6,1)  
 

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.

decimal9 (6,1)  
 

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.

decimal9 (6,2)  
 

Forward momentum of the hurricane when the eighth measurement for the event was taken. Measured in miles/hour.

decimal9 (6,2)  
 

Angle, in relation to North, at which the event approached the eighth measurement point.

decimal9 (6,2)  
 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.decimal9 (9,4)  
 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.decimal9 (9,4)  
 Area for the location of the closest ZIP centroid
where the initial measurement for the event was taken.
varchar60  
 Subarea for the location of the closest ZIP
centroid where the initial measurement for the event
was taken.
varchar60  
See Also

Related Objects

AIREvents Database