Driver alert conditions table (Condition_Driver_Alerts)
Condition_Driver_Alert contains records for following condition types:
- Traffic light (Condition Type = 16)
- Traffic sign (Condition Type = 17)
- Railway crossing (Condition Type = 18)
- No overtaking (Condition Type = 19)
- Protected overtaking (condition type = 21)
For descriptions of the GlobalID and OBJECTID attributes, see Esri® system fields.
| Field name | Data type | Description |
|---|---|---|
| CONDITION_ID | Integer (4) | Unique identifier for the condition |
| TRAFFIC_SIGN_VALUE | String (100) | Specifies the traffic sign value for the condition. |
| TRAFFIC_SIGN_TYPE | Integer (4) | Specifies the traffic sign type for the condition. |
| TRAFFIC_SIGN_TYPE_DESC | String (50) | Description of the traffic sign type |
| TRAFFIC_SIGN_CATEGORY | Integer (4) | Specifies the traffic sign category for the condition. |
| TRAFFIC_SIGN_CATEGORY_DESC | String (50) | Description for traffic sign category |
| TRAFFIC_SIGN_SUBCATEGORY | Integer (4) | Specifies the traffic sign subcategory for the condition. |
| TRAFFIC_SIGN_SUBCATEGORY_DESC | String (50) | Description for traffic sign subcategory |
| GEN_WARNING_SIGN_TYPE | Integer (4) | Specifies the general warning sign type for the condition. |
| GEN_WARNING_SIGN_TYPE_DESC | String (35) | Description of the gen warning sign type |
| SIGN_DURATION | Integer (4) | Specifies the sign duration for the condition. |
| SIGN_PREWARNING | Integer (4) | Specifies the sign prewarning value for the condition. |
| SIGN_VALIDITY_TIME | Integer (4) | Specifies the sign validity time for the condition. |
| SIGN_VEHICLE_TRUCK | String (1) | Indicates whether the sign applies to trucks. |
| SIGN_VEHICLE_HEAVY_TRUCK | String (1) | Indicates whether the sign applies to heavy trucks. |
| SIGN_VEHICLE_BUS | String (1) | Indicates whether the sign applies to buses. |
| SIGN_VEHICLE_AUTO_TRAILER | String (1) | Indicates whether the sign applies to auto trailers. |
| SIGN_VEHICLE_MOTORCYCLE | String (1) | Indicates whether the sign applies to motorcycles. |
| SIGN_VEHICLE_MOTORHOME | String (1) | Indicates whether the sign applies to motorhomes. |
| WEATHER_TYPE | Integer (4) | Specifies the weather type for the condition. |
| RAILWAY_CROSSING_TYPE | Integer (4) | Specifies the railway crossing type for the condition. |
| RAILWAY_CROSSING_TYPE_DESC | String (35) | Description of the railway crossing type |
| SIGNAL_SIGN_LOCATION | Integer (4) | Specifies the signal sign location for the condition. |
| SIGNAL_SIGN_LOCATION_DESC | String (35) | Description for signal sign location |
| DIRECTION | Integer (4) | Specifies the direction for the condition. |
| DIRECTION_DESC | String (30) | Description for direction |
| IMPORTANCE_IND | SmallInteger (2) | Specifies the importance indicator for the condition. |
| ISO_COUNTRY_CODE | String (3) | ISO 3 character country code |