Transport conditions table (Condition_Transport)
The Condition_Transport table stores additional transport-condition attributes for the Truck Extension product. This table populates fields on Streets and Routing_Streets with transport-vehicle restrictions and costs in the HGDS Truck edition Esri® network.
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 |
| WIDTH_RESTRICTION | Double (8) | Specifies the width restriction for the transport condition. |
| LENGTH_RESTRICTION | Double (8) | Specifies the length restriction for the transport condition. |
| HEIGHT_RESTRICTION | Double (8) | Specifies the height restriction for the transport condition. |
| WEIGHT_RESTRICTION | Double (8) | Specifies the total weight restriction for the transport condition. |
| WEIGHT_PER_AXLE_RESTRICTION | Double (8) | Specifies the weight per axle restriction for the transport condition. |
| HAZARDOUS_MATERIAL_TYPE | Integer (4) | Specifies the hazardous material type for the transport condition. |
| HAZMAT_TYPE_DESC | String (35) | Description of the hazard material type |
| DIRECTION_CLOSURE | String (1) | Specifies the direction closure for the transport condition. |
| DIRECTION_CLOSURE_DESC | String (35) | Description for direction closure |
| TRAILER_TYPE | Integer (4) | Specifies the trailer type for the transport condition. |
| TRAILER_TYPE_DESC | String (40) | Description of the trailer type |
| PHYSICAL_STRUCTURE_TYPE | Integer (4) | Specifies the physical structure type for the transport condition. |
| PHYSICAL_STRUCTURE_DESC | String (35) | Description for physical structure |
| NUMBER_OF_AXLES | Integer (4) | Specifies the number of axles for the transport condition. |
| NUMBER_OF_AXLES_DESC | String (35) | Description for number of axles |
| KPRA_LENGTH | Integer (4) | Specifies the KPRA length restriction for the transport condition. |
| TRANSPORT_SPEED_LIMIT | Integer (4) | Specifies the transport speed limit for the transport condition. |
| TRANSPORT_SPEED_TYPE | Integer (4) | Specifies the transport speed type for the transport condition. |
| TRANSPORT_SPEED_TYPE_DESC | String (30) | Description of the transport speed type |
| SPEED_LIMIT_TYPE | Integer (4) | Specifies the speed limit type for the transport condition. |
| SPEED_LIMIT_TYPE_DESC | String (35) | Description of the speed limit type |
| DIRECTION | Integer (4) | Specifies the direction for the transport condition. |
| DIRECTION_DESC | String (30) | Description for direction |
| PREFERRED_ROUTE_TYPE | Integer (4) | Specifies the preferred route type for the transport condition. |
| PREFERRED_ROUTE_DESC | String (50) | Description for preferred route |
| WEIGHT_DEPENDENT | Integer (4) | Indicates whether the transport condition is weight dependent. |
| WEATHER_TYPE | Integer (4) | Specifies the weather type for the transport condition. |
| TIME_OVERRIDE | Integer (4) | Indicates whether time-based modifiers override default behavior |
| GROSS_VEHICLE_MASS | String (1) | Specifies the gross vehicle mass restriction for the transport condition. |
| PAYLOAD_CAPACITY | Integer (4) | Specifies the payload capacity restriction for the transport condition. |
| EMPTY_WEIGHT | Integer (4) | Specifies the empty weight restriction for the transport condition. |
| NUMBER_OF_WHEELS | SmallInteger (2) | Specifies the number of wheels restriction for the transport condition. |
| AXLE_GROUP_WPA | SmallInteger (2) | Specifies the axle group WPA restriction for the transport condition. |
| ISO_COUNTRY_CODE | String (3) | ISO 3 character country code |