Describes the output data types containing the results from a vehicle routing problem analysis when using the VehicleRoutingProblemSchemaVersion.Two schema version.
Orders
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 present in the input Orders table. Fields that are updated or added in the output are listed below.
Field | Description | Data type |
---|---|---|
RouteName | El nombre de la ruta a la que se ha asignado la orden. | String |
Sequence | Esto indica la secuencia de la orden en su ruta asignada. | Integer |
| 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 Nota: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. | Integer |
FromPrevTravelTime | El tiempo de viaje transcurrido desde la parada anterior de la ruta a la parada actual. The value is in the units specified by the timeUnits property of the analysis object. | Double |
FromPrevDistance | La distancia a lo largo de la ruta desde la parada anterior hasta la parada actual. The value is in the units specified by the distanceUnits property of the analysis object. | Double |
CumulTravelTime | The cumulative travel time for the route up to arrival at the order. The value is in the units specified by the timeUnits property of the analysis object. | Double |
CumulDistance | The cumulative travel distance for the route up to arrival at the order. The value is in the units specified by the distanceUnits property of the analysis object. | Double |
CumulTime | The cumulative route duration up to and including the order. The cumulative duration includes travel times as well as service and wait times at orders. The value is in the units specified by the timeUnits property of the analysis object. | Double |
ArriveCurbApproach | Indica de qué lado del vehículo está el bordillo al llegar a la parada. Un valor de 1 significa el lado derecho del vehículo; un valor de 2 significa el lado izquierdo. | Integer |
DepartCurbApproach | Indica de qué lado del vehículo está el bordillo al salir de la parada. Un valor de 1 significa el lado derecho del vehículo; un valor de 2 significa el lado izquierdo. | Integer |
ArriveTime | La hora del día a la que la ruta llega a la parada. El valor de hora del día de este campo se encuentra en la zona horaria donde está ubicada la parada. | Date |
DepartTime | La hora del día a la que la ruta parte a la parada. El valor de hora del día de este campo se encuentra en la zona horaria donde está ubicada la parada. | Date |
ArriveTimeUTC | La hora del día a la que la ruta llega a la parada. Este valor se proporciona en la hora universal coordinada (UTC). | Date |
DepartTimeUTC | La hora del día a la que la ruta parte a la parada. Este valor se proporciona en la hora universal coordinada (UTC). | Date |
WaitTime | El tiempo de espera o relevo en la parada. Por ejemplo, un tiempo de espera se incurre cuando una ruta debe esperar en una orden para que se abra una ventana de tiempo. The value is in the units specified by the timeUnits property of the analysis object. | Double |
ViolationTime | La cantidad de tiempo transcurrido desde el final de la ventana de tiempo de la parada hasta la llegada del vehículo de ruta. The value is in the units specified by the timeUnits property of the analysis object. | Double |
CumulWaitTime | The cumulative wait time from the beginning of the route up to and including the order. The value is in the units specified by the timeUnits property of the analysis object. | Double |
CumulViolationTime | The cumulative violation time from the beginning of the route up to and including the order. The value is in the units specified by the timeUnits property of the analysis object. | Double |
Status | Indica el estado del punto con respecto a su ubicación en la red y el resultado del análisis. Los posibles valores son los siguientes:
| Integer |
Network location fields
| Conjuntamente, estas propiedades describen el punto en la red donde se encuentra el objeto. Obtener más información sobre ubicación de entradas en una red |
Depots
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 present in the input Depots table. Only fields that are added in the output are listed below.
Field | Description | Data type |
---|---|---|
Status |
Indica el estado del punto con respecto a su ubicación en la red y el resultado del análisis. Los posibles valores son los siguientes:
| Integer |
Network location fields
| Conjuntamente, estas propiedades describen el punto en la red donde se encuentra el objeto. Obtener más información sobre ubicación de entradas en una red |
DepotVisits
When a route starts, renews (unloads or reloads), 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 a vehicle routing problem solution is also included.
The data type supports the following fields:
Field | Description | Data type |
---|---|---|
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. | String |
VisitType | The reason this depot was visited. This field is constrained by a domain of values:
| Integer |
RouteName | The name of the route containing this visit. This field is a foreign key to the Name field in the Routes table. | String |
Sequence | Indicates the sequence of the visited depot on the route. The output sequence values for a route are shared across depot visits, orders, and breaks; start from 1 (at the starting depot); and are consecutive. | Integer |
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 |
CumulTravelTime | The cumulative travel time for the route up to the arrival at this depot. The value is in the units specified by the timeUnits property of the analysis object. | Double |
CumulDistance | The cumulative travel distance for the route up to the arrival at this depot. The value is in the units specified by the distanceUnits property of the analysis object. | Double |
CumulTime | The cumulative route duration up to and including the depot. The cumulative duration includes travel times as well as service and wait times at orders, depots, and breaks. The value is in the units specified by the timeUnits property of the analysis object. | Double |
ArriveTime | The arrival time at the depot. The route may arrive at the depot before the beginning of the depot's time window, in which case there is wait time at the depot. When using traffic data that covers multiple time zones, the time zone for this time-of-day value is the same as the network element on which the depot is located. | Date |
DepartTime | The departure time from the depot. When using traffic data that covers multiple time zones, the time zone for this time-of-day value is the same as the network element on which the depot is located. | Date |
ArriveTimeUTC | The date and time value indicating the arrival time in coordinated universal time (UTC) at the depot. | Date |
DepartTimeUTC | The date and time value indicating the departure time in coordinated universal time (UTC) from the depot. | Date |
WaitTime | The wait time at the depot. The value is in the units specified by the timeUnits property of the analysis object. | Double |
CumulWaitTime | The cumulative wait time from the beginning of the route up to and including the depot. The value is in the units specified by the timeUnits property of the analysis object. | Double |
CumulViolationTime | The cumulative violation time from the beginning of the route up to and including the depot. The value is in the units specified by the timeUnits property of the analysis object. | Double |
| The amount (for instance, 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
Ofrece acceso a los conductores, vehículos y vías de rutas de un análisis de problema de generación de rutas para vehículos.
The output Routes table includes all fields present in the input Routes table as well as additional fields describing how each route serviced the orders. Only fields that are added in the output are listed below.
Field name | Description | Data type |
---|---|---|
| Describes constraints violated by the route. The constraints are given as integers as described in the table below.
| Integer |
OrderCount | El número de órdenes asignadas a la ruta. | Integer |
TotalCost | El coste operativo total de la ruta, que es la suma de los siguientes valores de campo: FixedCost, RegularTimeCost, OvertimeCost y DistanceCost. | Double |
RegularTimeCost | El coste de horas de trabajo normales, excluido cualquier descanso no pagado. | Double |
OvertimeCost | El coste de trabajo en horas extra, excluidos los descansos no pagados. | Double |
DistanceCost | El componente de coste de distancia obtenido al multiplicar los valores de los campos TotalDistance y CostPerUnitDistance. | Double |
TotalTime | La duración total de la ruta. Esto incluye los tiempos de viaje, así como los tiempos de servicio y de espera en órdenes, depósitos y descansos. El valor TotalTime es la suma de los siguientes campos de atributo:
The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalOrderServiceTime | El tiempo de servicio total empleado en todas las órdenes en la ruta. The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalBreakServiceTime | El tiempo de servicio total empleado en todos los descansos en la ruta. The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalTravelTime | El tiempo de viaje total para la ruta. The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalDistance | La distancia de viaje total para la ruta. The value is in the units specified by the distanceUnits property of the analysis object. | Double |
StartTime | La hora de inicio de la ruta. La ruta puede empezar antes del comienzo de su ventana de tiempo de depósito inicial, en cuyo caso hay un tiempo de espera en el depósito inicial. El valor de hora del día de este atributo se encuentra en la zona horaria donde está ubicado el depósito inicial. | Date |
EndTime | El tiempo de finalización de la ruta. La ruta finaliza al completar el servicio en el depósito final. El valor de hora del día de este atributo se encuentra en la zona horaria donde está ubicado el depósito final. | Date |
StartTimeUTC | La hora de inicio de la ruta en la hora universal coordinada (UTC). | Date |
EndTimeUTC | La hora de finalización de la ruta en la hora universal coordinada (UTC). | Date |
TotalWaitTime | El tiempo de espera total en todas las órdenes, depósitos y descansos en la ruta. The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalViolationTime | El tiempo de infracción total en todas las órdenes y descansos en la ruta. The value is in the units specified by the timeUnits property of the analysis object. | Double |
RenewalCount | Para una ruta con reanudaciones, esto es igual al número de visitas a los depósitos para la renovación de un vehículo, es decir, cargar o descargar un vehículo. | Integer |
TotalRenewalServiceTime | Para una ruta con reanudaciones, este es el tiempo de servicio total empleado en todas las visitas de renovación en la ruta. The value is in the units specified by the timeUnits property of the analysis object. | Double |
Breaks
Describes the rest periods, or breaks, for the routes in the analysis. The output Breaks table includes the point locations where the breaks occur along the routes.
The output Breaks table includes all fields present in the input Breaks table as well as additional fields describing the location and time of the break. Only fields that are updated or added in the output are listed below.
Field | Description | Data type |
---|---|---|
Sequence | Indicates the sequence of the break on its route. | Integer |
RelativePosition | The relative position of the break. Breaks are taken somewhere between two network locations (orders or depots). A value of 0.0 indicates that the break is taken right after service completion at the preceding network location; a value of 1.0 indicates the break is taken right before starting service at the subsequent network location; and a value in between indicates where along the path from the first to the second network location the break is taken. For instance, 0.25 indicates the break is taken a quarter of the way from the previous network location to the next network location. No matter how many breaks occur between two network locations, the relative position is always reported relative to the network locations, not the other breaks. | Double |
FromPrevTravelTime | The travel time from the preceding order, depot, or break to this break. The value is in the units specified by the timeUnits property of the analysis object. | Double |
FromPrevDistance | The travel distance from the preceding order, depot, or break to this break. The value is in the units specified by the distanceUnits property of the analysis object. | Double |
CumulTravelTime | The cumulative travel time for the route up to arrival at the break. The value is in the units specified by the timeUnits property of the analysis object. | Double |
CumulDistance | The cumulative travel distance for the route up to arrival at the break. The value is in the units specified by the distanceUnits property of the analysis object. | Double |
CumulTime | The cumulative route duration up to and including the break. The cumulative duration includes travel times as well as service and wait times at orders, depots, and breaks. The value is in the units specified by the timeUnits property of the analysis object. | Double |
ArriveTime | The actual arrival time of the break. The route may arrive at the break before the beginning of the break's time window, in which case there is a wait time at the break. For a break with soft time windows, the route may also arrive at the break after the end of the time window, in which case there is a violation time at the break. If using a network dataset with multiple time zones, the time is reported in the time zone of the actual break location. | Date |
DepartTime | The time the break is completed. If using a network dataset with multiple time zones, the time is reported in the time zone of the actual break location. | Date |
ArriveTimeUTC | The date and time value indicating the arrival time in coordinated universal time (UTC). | Date |
DepartTimeUTC | The date and time value indicating the departure time in coordinated universal time (UTC). | Date |
WaitTime | The wait time at the break. The value is in the units specified by the timeUnits property of the analysis object. | Double |
ViolationTime | The violation time at the break. The value is in the units specified by the timeUnits property of the analysis object. | Double |
CumulWaitTime | The cumulative wait time from the beginning of the route up to and including the break. The value is in the units specified by the timeUnits property of the analysis object. | Double |
CumulViolationTime | The cumulative violation time from the beginning of the route up to and including the break. The value is in the units specified by the timeUnits property of the analysis object. | Double |
DirectionPoints
Especifica las indicaciones paso a paso de salida para las rutas calculadas en el análisis, representadas como ubicaciones de puntos a lo largo de las rutas donde se producen eventos de indicaciones o maniobras específicos.
Field name | Description | Data type |
---|---|---|
RouteID | El ObjectID de la entidad de salida Routes con la que está asociado este punto de indicación. | Entero |
Sequence | La secuencia de los puntos de indicación de la ruta, empezando por 1. | Entero |
DirectionPointType | El tipo de evento o maniobra de indicaciones descrito por el punto, designado por uno de los valores siguientes.
| Entero |
DisplayText | El texto de las indicaciones que se va a mostrar en la aplicación que utiliza. | Cadena |
ArrivalTime | La hora en la que ocurre el evento de indicaciones en la hora universal coordinada (UTC). | Fecha |
ArrivalUTCOffset | La diferencia en minutos entre la hora local en la ubicación de maniobra y la hora UTC mostrada en el campo ArrivalTime, en minutos. | Doble |
Name | El nombre del punto de indicaciones. | Cadena |
ExitName | El nombre de salida de carretera que aparece en la instrucción de las indicaciones. | Cadena |
AlternateName | Nombre de origen alternativo que aparece en la instrucción de las indicaciones. | Cadena |
IntersectingName | El nombre de la calle de intersección o de cruce que aparece en la instrucción de las indicaciones. | Cadena |
BranchName | El nombre de rama del poste indicador que aparece en la instrucción de las indicaciones. | Cadena |
TowardName | El nombre del poste indicador hacia el destino que aparece en la instrucción de las indicaciones. | Cadena |
Level | El nivel de edificio en el que ocurre este evento de indicaciones. Este valor corresponde a la propiedad Level definida en el dataset de red utilizado para el análisis. | Entero |
ShortVoiceInstruction | Texto corto que se utiliza como texto de la guía de voz en la aplicación que utiliza. | Cadena |
VoiceInstruction | El texto de relleno, incluidas las abreviaturas expandidas y los plurales, para utilizarlo como texto de la guía de voz en la aplicación que utiliza. | Cadena |
Azimuth | El rumbo en grados del vehículo que sale de este punto. El cero indica el norte. | Doble |
DirectionLines
Especifica las líneas de ruta de salida calculadas en el análisis dividido en zonas para representar cada segmento de ruta entre ubicaciones de eventos o maniobras de DirectionPoints.
Nombre de campo | Descripción | Tipo de datos |
---|---|---|
DirectionPointID | El ObjectID de la entidad de la tabla DirectionPoints con la que está asociada esta línea. | Entero |
RouteID | El ObjectID de la entidad de salida Routes con la que está asociada esta línea de indicación. | Entero |
DirectionLineType | El tipo de situación de indicaciones descrito por esta línea, designado por uno de los siguientes valores.
| Entero |
Meters | La longitud del segmento de línea medida en metros. | Doble |
Minutes | El tiempo de viaje a lo largo del segmento de línea en minutos. | Doble |
FromLevel | El nivel de edificio en el que se inicia este evento de indicaciones. Este valor corresponde a la propiedad Level definida en el dataset de red utilizado para el análisis. Más información sobre la configuración de indicaciones de un dataset de red | Entero |
ToLevel | El nivel de edificio en el que finaliza este evento de indicaciones. Este valor corresponde a la propiedad Level definida en el dataset de red utilizado para el análisis. | Entero |