AIREvents Database Documentation
TblModel90 Table
AIREvents Database : TblModel90 Table
Description

Stores detailed information about each simulated event in the catalog for the Inland Flood Model for Central Europe (Model 90).

Countries modeled include Germany, Austria, Czech Republic, and Switzerland.

Properties
Creation Date4/5/2019 10:45 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows123179
Data Space Used15,840.00 KB
Index Space Used48.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key Unique system-provided identifier for the event.int4   
 Code that represents the model.int4  
 Identifier for the event.int4  
 Year in the catalog that the event occurred.int4  
 Day (within the Year) that the event began.int4  
 

Name/description of the event. 

Note that the description includes the country code(s) that were affected by the flood. For more information regarding the specific area affected by an event, see fields:

  • Min_Latitude_Boundary
  • Max_Latitude_Boundary
  • Min_Longitude_Boundary
  • Max_Longitude_Boundary
varchar200  
 

Hour (within the Day) that the event began.

int4  
 

Total duration of the event, in hours.

int4  
 Hour from the event start in which the first runoff occurred.int4  
 Hour from the event start in which the last runoff occurred.int4  
 Hour from the event start in which the first high-peak of the event occurred.int4  
 Hour from the event start in which the last high-peak of the event occurred.int4  
 

Total number of catchments that were affected by the event.

int4  
 

Total number of flowing waterways between catchments (links) that were affected by the event.

int4  
 

Mean of event rainfall over all affected catchments.  Measured in mm/hr.

float9  
 

Mean of event rainfall-excess over all affected catchments. Measured in mm/hour.

float9  
 

Mean of normalized peak flows (normalized by Q2) among affected river links. Because of normalization, this value is dimensionless.  

float9  
 Southern-most latitude coordinate for the surface area affected by the event.  Values will be positive for locations north of the equator and negative south of the equator.decimal9 (9,4)  
 Northern-most latitude coordinate for the surface area affected by the event.  Values will be positive for locations north of the equator and negative south of the equator.decimal9 (9,4)  
 Western-most longitude coordinate for the surface area affected by the event.  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)  
 Western-most longitude coordinate for the surface area affected by the event.  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)  
See Also

Related Objects

AIREvents Database