Stores detailed information about each simulated event in the catalog for the Verisk Inland Flood Model for Malaysia and Indonesia (M017).
AIREvents 2025 (13.1) Database Documentation
TblModel17 Table
Stores detailed information about each simulated event in the catalog for the Verisk Inland Flood Model for Malaysia and Indonesia (M017).
| Creation Date | 9/24/2025 11:40 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 167897 |
| Data Space Used | 19,920.00 KB |
| Index Space Used | 8.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 yield event. | int | 4 | | |||
| Year | Year in the catalog that the event occurred. | int | 4 | | |||
| Day | Represents the day/date in a year. | int | 4 | | |||
| EventDescription | Name/description of the event. Note that the description includes the area code. For more precise information regarding the specific area affected by the event, see the following fields:
| 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. | int | 4 | | |||
| LengthLinksFlooded_Km | Total surface area, in square kilometer, of the flowing waterways between catchments that were flooded during the event. | int | 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) | |