Stores detailed information about each event in the catalog for the Japan Inland Flood Model (Model 18).
AIREvents Database Documentation
TblModel18 Table
| Creation Date | 4/11/2019 3:03 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 6 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| Actual_Year | Year the event occurred. | int | 4 |  | |||
| Event_Name | Name of the event. | varchar | 255 | | |||
| Catalog_Type | Code that represents the catalog type.
| varchar | 4 | | |||
| 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 occurred. | int | 4 | | |||
| EventDescription | Name/description of the event. Note that the description includes the area code(s) that were affected by the flood. For more information regarding the specific area affected by an event, see the following fields:
| varchar | 200 | | |||
| 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) | |