TblModel19 Table

Description

Stores detailed information about each event in the catalog for the Verisk Inland Flood Model (Model 19) for Canada.

Properties

Creation Date	9/24/2025 11:40 AM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	281001
Data Space Used	34,264.00 KB
Index Space Used	8.00 KB

Columns

Column Name	Description	Datatype	Length
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 began.	int	4
EventDescription	Description of the event.	varchar	200
HourofDay	Hour (within the Day) that the event began.	int	4
Duration_Hours	Total duration of the event, in hours.	int	4
TimeToFirstRunoff_HourofYear	Hour within the year in which the first runoff occurred during the event.	int	4
TimeToLastRunoff_HourofYear	Hour within the year in which the last runoff occurred during the event.	int	4
TimeToFirstPeakFlow_HourofYear	Hour within the year in which the first high-peak of the event occurred.	int	4
TimeToLastPeakFlow_HourofYear	Hour within the year in which the last high-peak of the event occurred.	int	4
NumberCatchmentsFlooded	Total number of catchments that were affected by the event.	int	4
NumberLinksFlooded	Total number of flowing waterways between catchments (links) that were affected by the event.	int	4
AreaCatchmentsFlooded_KmSq	Total surface area, in square kilometers, of the catchments that were flooded during the event.	decimal	9 (12,4)
LengthLinksFlooded_Km	Total surface area, in square kilometer, of the flowing waterways between catchments that were flooded during the event.	decimal	9 (12,4)
Min_Latitude_Boundary	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.	decimal	9 (9,4)
Max_Latitude_Boundary	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.	decimal	9 (9,4)
Min_Longitude_Boundary	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.	decimal	9 (9,4)
Max_Longitude_Boundary	Eastern-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.	decimal	9 (9,4)

Related Objects

AIREvents Database