AIREvents Database Documentation
TblModel76 Table
AIREventsHistorical Database : TblModel76 Table
Description

Stores detailed information about each event in the catalog for the Earthquake Model for Central America (Model 76).

Countries modeled include Belize, Costa Rica, El Salvador, Guatemala, Honduras, Nicaragua, and Panama.

Properties
Creation Date4/11/2019 3:03 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows16
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 Year the event occurred.int4  
 Name of the event.varchar255  
 

Code that represent the catalog type.

Code that represent the catalog type.

  • HIST = Historical
  • EDS = Extreme Disaster Scenario
  • RDS = Lloyd's Realistic Disaster Scenarios
  • GOVT = Government
varchar4  
 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 magnitude and the country code(s) affected by the earthquake.For more information regarding the specific area affected by the event, see fields:

  • Latitude
  • Longitude
  • AreaName
  • SubAreaName
varchar200  
 Depth of the earthquake's epicenter, measured in  kilometers.decimal9 (6,1)  
 

Indicates whether the epicenter occurred inland or offshore.

  • O = Offshore
  • I = Inland
char1  
 Richter scale value for the strength of the earthquake at its epicenter.decimal9 (6,3)  
 Longitude coordinate where the epicenter of the event occurred. 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 (8,3)  
 Latitude coordinate where the epicenter of the event occurred.  Values will be positive for locations north of the equator and negative south of the equator.decimal9 (8,3)  
 Area where the event occurred.varchar60  
 Subarea where the event occurred.varchar60  
See Also

Related Objects

AIREventsHistorical Database