The output data types containing the results from a last mile delivery analysis are described below.
Orders
The output is a copy of the input Orders table with additional information about which route served each order, the arrival and departure times, and the order sequence.
The output Orders table includes all fields from the input Orders table. Fields that are updated or added to the output are listed in the following table:
| Field | Description | Data type |
|---|---|---|
ObjectID | ID d’objet de l’entité. | ObjectID |
RouteName | Nom de l'itinéraire auquel l'ordre est attribué. This field corresponds to the Name field in the output Routes table. | Text |
Sequence | Ce champ indique la séquence de l'ordre sur son itinéraire attribué. Output sequence values for a route are shared across depot visits and orders. The sequences start from 0 at the starting depot and are consecutive. The smallest possible output sequence value for a routed order is 1. This is the case even if the route begins at a virtual depot. | Long |
| These fields contain a summary of violated constraints and are set after a solve operation. Each field will contain one violation. If an order has more than one violation, the next ViolatedConstraint_* field will be used.
Learn more about troubleshooting network analyses Remarque :The violated constraint field value of an unrouted order may or may not describe all its violations. If the violation is severe enough to immediately exclude the order from further consideration, the solver does so, which prevents any other violations from being discovered for that order. If a violation is encountered that doesn't automatically stop a solution from being generated, the violation is noted in violated constraint fields, and the solver continues to consider the order. Any further violations such as these are added to the violated constraint fields until either the solver finds a violation that prematurely stops the solve process for that particular order, or the solver finds an overall solution to the problem. | Long |
FromPrevTravelTime | Temps de trajet écoulé entre le précédent arrêt et l’arrêt actuel. The value is in the units specified by the timeUnits property of the analysis object. | Double |
FromPrevDistance | Distance sur l’itinéraire entre le précédent arrêt et l’arrêt actuel. The value is in the units specified by the distanceUnits property of the analysis object. | Double |
ArriveCurbApproach | Côté du véhicule sur lequel se trouve le trottoir lorsque l’arrêt est atteint. La valeur 1 indique le côté droit du véhicule ; la valeur 2 le côté gauche. | Long |
DepartCurbApproach | Côté du véhicule sur lequel se trouve le trottoir au départ de l’arrêt. La valeur 1 indique le côté droit du véhicule ; la valeur 2 le côté gauche. | Long |
ArriveTime | The time of day the route arrives at the order. The route may arrive at the order before the beginning of the order's time window, in which case there is a wait time at the order. For an order with a soft time window, the route may also arrive at the order after the end of the time window, in which case there is a violation time at the order. This arrival time reflects the travel times that were used during the optimization by the solver. For a network with traffic data, traffic conditions for specific times of day are not used; rather, the solver uses the time neutral average travel times for this optimization phase. The time zone for the ArriveTime field value is derived from the network element on which the order is located. | Timestamp Offset |
DepartTime | The time of day the route departs from the order. The route departs from the order upon completion of service. This departure time reflects the travel times that were used during the optimization by the solver. For a network with traffic data, traffic conditions for specific times of day are not used; rather, the solver uses the time neutral average travel times for this optimization phase. The time zone for the DepartTime field value is derived from the network element on which the order is located. | Timestamp Offset |
WaitTime | The wait time or layover at the order. For example, a wait time is incurred when a route must wait at an order for a time window to open. The value is in the units specified by the timeUnits property of the analysis object. | Double |
ViolationTime | The amount of time elapsed from the end of the order's time window to the arrival of the route vehicle. The value is in the units specified by the timeUnits property of the analysis object. | Double |
Status | Spécifie le statut du point par rapport à son emplacement sur le réseau et au résultat de l’analyse. Les valeurs possibles sont les suivantes :
| Long |
Network location fields
| Ensemble, ces propriétés décrivent le point sur le réseau où se trouve l'objet. Pour en savoir plus sur la localisation des entrées sur un réseau |
Depots
The output is a copy of the input Depots table with additional information about how the depots were located on the network.
The output Depots table includes all fields from the input Depots table. Only fields that are added to the output are listed in the following table:
| Field | Description | Data type |
|---|---|---|
ObjectID | ID d’objet de l’entité. | ObjectID |
Status |
Spécifie le statut du point par rapport à son emplacement sur le réseau et au résultat de l’analyse. Les valeurs possibles sont les suivantes :
| Long |
Network location fields
| Ensemble, ces propriétés décrivent le point sur le réseau où se trouve l'objet. Pour en savoir plus sur la localisation des entrées sur un réseau |
DepotVisits
When a route starts or ends at a depot, a depot visit is created. Depot visits provide information regarding why a route visited a depot and what happened there. The quantity of goods loaded on or unloaded from a vehicle at the depot is recorded in the properties of a depot visit. Additional information that is useful in interpreting the analysis solution is also included.
The data type supports the following fields:
| Field | Description | Data type |
|---|---|---|
ObjectID | ID d’objet de l’entité. | ObjectID |
DepotName | The name of the visited depot. This field is a foreign key to the Name field in the Depots table. If the route uses a virtual depot, which means the route starts or ends at an order instead of a depot, DepotName is null. | Text |
VisitType | The reason the depot was visited. This field is constrained by a domain of values:
| Long |
RouteName | The name of the route containing this visit. This field is a foreign key to the Name field in the Routes table. | Text |
Sequence | The sequence of the visited depot on the route. Output sequence values for a route are shared across depot visits and orders. The sequences start from 0 at the starting depot and are consecutive. | Long |
ServiceTime | The service time (such as loading or unloading) at the depot. The value is in the units specified by the timeUnits property of the analysis object. | Double |
FromPrevTravelTime | The travel time from the preceding visit on the route to the depot. The value is in the units specified by the timeUnits property of the analysis object. | Double |
FromPrevDistance | The travel distance from the preceding visit on the route to the depot. The value is in the units specified by the distanceUnits property of the analysis object. | Double |
ArriveTime | The arrival time at the depot. The arrival time reflects the travel times that were used during the optimization by the solver. For a network with traffic data, traffic conditions for specific times of day are not used; rather, the solver uses the time neutral average travel times for this optimization phase. The time zone for the ArriveTime field value is derived from the network element on which the depot is located. | Timestamp Offset |
DepartTime | The departure time from the depot. The departure time reflects the travel times that were used during the optimization by the solver. For a network with traffic data, traffic conditions for specific times of day are not used; rather, the solver uses the time neutral average travel times for this optimization phase. The time zone for the DepartTime field value is derived from the network element on which the depot is located. | Timestamp Offset |
| The amount (for example, volume, weight, quantity) being loaded at the depot. If there are multiple capacities, the amounts in the LoadedQuantity_1 through LoadedQuantity_9 fields correspond to the matching Capacity_1 through Capacity_9 fields in the Routes input table. | Double |
| The amount (for example, volume, weight, quantity) being unloaded at the depot. If there are multiple capacities, the amounts in the UnloadedQuantity_1 through UnloadedQuantity_9 fields correspond to the matching Capacity_1 through Capacity_9 fields in the Routes input table. | Double |
Routes
This provides access to the drivers, vehicles, and route paths of the last mile delivery analysis.
The output Routes table includes all fields from the input Routes table as well as additional fields describing how each route serviced the orders. Only fields that are added to the output are listed below.
| Field name | Description | Data type |
|---|---|---|
ObjectID | ID d’objet de l’entité. | ObjectID |
| Describes constraints violated by the route. The constraints are given as integers as described in the table below.
| Long |
OrderCount | Nombre d’ordres attribués à l’itinéraire. | Long |
TotalCost | Coût opérationnel total de l’itinéraire, qui correspond à la somme des valeurs des champs suivants : FixedCost, RegularTimeCost, OvertimeCost et DistanceCost. | Double |
RegularTimeCost | The cost of regular work time. | Double |
OvertimeCost | The cost of overtime work. | Double |
DistanceCost | Composante du coût de distance obtenue en multipliant les valeurs des champs TotalDistance et CostPerUnitDistance. | Double |
TotalTime | The total route duration. This includes travel times as well as service and wait times at orders and depots. The TotalTime value is the sum of the following attribute fields:
The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalOrderServiceTime | Durée totale de service passé à tous les ordres de l’itinéraire. The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalTravelTime | Temps de trajet total de l’itinéraire. The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalDistance | Distance totale de trajet de l’itinéraire. The value is in the units specified by the distanceUnits property of the analysis object. | Double |
StartTime | The starting time of the route. The time zone for the StartTime field value is derived from the network element on which the starting depot is located or the first order if the route starts at a virtual depot. | Timestamp Offset |
EndTime | The ending time of the route. The route ends upon completion of service at the ending depot. The time zone for the EndTime field value is derived from the network element on which the ending depot or final order is located. | Timestamp Offset |
TotalWaitTime | The total wait time at all orders and depots on the route. The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalViolationTime | The total violation time at all orders on the route. The value is in the units specified by the timeUnits property of the analysis object. | Double |
DirectionPoints
Il s’agit de la feuille de route détaillée en sortie pour les itinéraires calculés au cours de l’analyse, représentée sous forme d’emplacements ponctuels le long des itinéraires pour lesquels des événements de feuille de route ou des manœuvres spécifiques ont lieu.
| Field name | Description | Data type |
|---|---|---|
ObjectID | ID d’objet de l’entité. | ObjectID |
RouteID | The ObjectID value of the output Routes feature with which this direction point is associated. | Long |
Sequence | Séquence des points de direction pour l’itinéraire, en commençant par 1. | Long |
DirectionPointType | Spécifie le type d’événement de feuille de route ou de manœuvre décrit par le point, désigné par l’une des valeurs ci-dessous.
| Long |
OrderID | The ObjectID value of the output Orders feature with which this direction point is associated. | Long |
DepotVisitID | The ObjectID value of the output DepotVisits feature with which this direction point is associated. | Long |
BreakVisitID | Remarque :This field is not used for last mile delivery analyses. | Long |
DisplayText | Texte de feuille de route qui s’affiche dans l’application consommatrice. | Texte |
ArrivalTime | Heure à laquelle se produit l’événement de feuille de route, spécifiée en temps universel coordonné (UTC). | Date |
ArrivalUTCOffset | Différence en minutes entre l’heure locale à l’emplacement de la manœuvre et l’heure UTC affichée dans le champ ArrivalTime. | Double |
Name | Nom du point de direction. | Texte |
ExitName | Nom de la sortie d’autoroute qui apparaît sur la feuille de route. | Texte |
AlternateName | Nom alternatif de la source qui apparaît sur la feuille de route. | Texte |
IntersectingName | Nom de la rue à l’intersection ou au croisement qui apparaît sur la feuille de route. | Texte |
BranchName | Nom du panneau qui apparaît sur la feuille de route. | Texte |
TowardName | Nom du panneau vers la destination qui apparaît sur la feuille de route. | Texte |
Level | Niveau du bâtiment auquel l’événement de feuille de route se produit. Cette valeur correspond à la propriété Level définie dans le jeu de données réseau utilisé pour l’analyse. | Long |
ShortVoiceInstruction | Texte court qui est utilisé comme texte de guidage vocal dans l’application consommatrice. | Texte |
VoiceInstruction | Texte supplémentaire, y compris avec les abréviations développées et les pluriels, qui est utilisé comme texte de guidage vocal dans l’application consommatrice. | Texte |
Azimuth | Relèvement en degrés du véhicule partant de ce point. Zéro correspond au nord. | Double |
DirectionLines
Il s’agit des lignes d’itinéraire en sortie calculées dans l’analyse, sous forme de tranches afin de représenter chaque segment d’itinéraire entre les événements DirectionPoints ou les emplacements de manœuvre.
| Nom du champ | Description | Type de données |
|---|---|---|
ObjectID | ID d’objet de l’entité. | ObjectID |
DirectionPointID | Valeur ObjectID de l’entité de la table DirectionPoints à laquelle est associée cette ligne. | Long |
RouteID | Valeur ObjectID de l’entité Routes en sortie à laquelle est associée cette ligne de direction. | Long |
DirectionLineType | Spécifie le type de situation de feuille de route décrit par cette ligne, désigné par l’une des valeurs suivantes :
| Long |
Meters | Longueur du segment de ligne, en mètres. | Double |
Minutes | Temps de trajet le long du segment de ligne, en minutes. | Double |
FromLevel | Niveau du bâtiment auquel l’événement de feuille de route débute. Cette valeur correspond à la propriété Level définie dans le jeu de données réseau utilisé pour l’analyse. En savoir plus sur la configuration de la feuille de route d’un jeu de données réseau | Long |
ToLevel | Niveau du bâtiment auquel l’événement de feuille de route se termine. Cette valeur correspond à la propriété Level définie dans le jeu de données réseau utilisé pour l’analyse. | Long |
Vous avez un commentaire à formuler concernant cette rubrique ?