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 | 訪問先が割り当てられるルートの名前。 | String |
Sequence | このフィールドは、訪問先に割り当てられたルートでの訪問先の順序を示します。 | 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 注意: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 | 前のストップから現在のストップまでに経過した移動時間。 The value is in the units specified by the timeUnits property of the analysis object. | Double |
FromPrevDistance | 前のストップから現在のストップまでのルート沿いの距離。 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 | 車両がストップに到着するときに、アプローチを車両のどちら側にするかを示します。 値が 1 の場合は車両の右側、値が 2 の場合は車両の左側です。 | Integer |
DepartCurbApproach | 車両がストップから出発するときに、アプローチを車両のどちら側にするかを示します。 値が 1 の場合は車両の右側、値が 2 の場合は車両の左側です。 | Integer |
ArriveTime | ルートがストップに到着する時間。 このフィールドの時間値は、ストップがある場所のタイム ゾーン内にあります。 | Date |
DepartTime | ルートがストップを出発する時間。 このフィールドの時間値は、ストップがある場所のタイム ゾーン内にあります。 | Date |
ArriveTimeUTC | ルートがストップに到着する時間。 この値は、UTC (協定世界時) で指定します。 | Date |
DepartTimeUTC | ルートがストップを出発する時間。 この値は、UTC (協定世界時) で指定します。 | Date |
WaitTime | ストップでの待ち時間または待ち合わせ時間。 たとえば、ルートが訪問先でタイム ウィンドウが開くまで待機する必要がある場合は、待ち時間が発生します。 The value is in the units specified by the timeUnits property of the analysis object. | Double |
ViolationTime | ストップのタイム ウィンドウの終了からルート車両の到着までの経過時間。 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 | ネットワーク上の位置を基準としたその地点のステータスと解析の結果を示します。 出力される可能性のある値は次のとおりです。
| Integer |
Network location fields
| これらのプロパティを組み合わせて、オブジェクトが配置されているネットワーク上のポイントを表します。 |
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 |
ネットワーク上の位置を基準としたその地点のステータスと解析の結果を示します。 出力される可能性のある値は次のとおりです。
| Integer |
Network location fields
| これらのプロパティを組み合わせて、オブジェクトが配置されているネットワーク上のポイントを表します。 |
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
配車ルート解析の運転手、車両、およびルート パスへのアクセスを提供します。
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 | ルートに割り当てられる訪問先の数。 | Integer |
TotalCost | ルートの合計運用コストです。これは、次のフィールドの値の合計です。FixedCost、RegularTimeCost、OvertimeCost、および DistanceCost。 | Double |
RegularTimeCost | 無給の休憩を除外した規定労働時間のコスト。 | Double |
OvertimeCost | 無給の休憩を除外した規定外労働のコスト。 | Double |
DistanceCost | TotalDistance フィールドと CostPerUnitDistance フィールドの値を乗算して得られた距離のコスト要素。 | Double |
TotalTime | 合計ルート所要時間。 これには、移動時間に加えて、訪問先、拠点、休憩でのサービス時間および待ち時間も含まれます。 TotalTime 値は次の属性フィールド値の合計です。
The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalOrderServiceTime | ルート上のすべての訪問先で費やされる合計サービス時間。 The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalBreakServiceTime | ルート上のすべての休憩で費やされる合計サービス時間。 The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalTravelTime | ルートの合計移動時間。 The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalDistance | ルートの合計移動距離。 The value is in the units specified by the distanceUnits property of the analysis object. | Double |
StartTime | ルートの開始時刻。 ルートは、開始拠点のタイム ウィンドウが始まる前に出発することがあります。この場合、開始拠点では待ち時間が発生します。 この属性の時間値は、開始拠点がある場所のタイム ゾーン内にあります。 | Date |
EndTime | ルートの終了時刻。 ルートは、終了拠点でのサービス完了時に終了します。 この属性の時間値は、終了拠点がある場所のタイム ゾーン内にあります。 | Date |
StartTimeUTC | UTC (協定世界時) でのルートの開始時刻。 | Date |
EndTimeUTC | UTC (協定世界時) でのルートの終了時刻。 | Date |
TotalWaitTime | ルート上のすべての訪問先、拠点、および休憩での合計待ち時間。 The value is in the units specified by the timeUnits property of the analysis object. | Double |
TotalViolationTime | ルート上のすべての訪問先および休憩での合計超過時間。 The value is in the units specified by the timeUnits property of the analysis object. | Double |
RenewalCount | リニューアルを持つルートの場合、これは、車両をリニューアル (つまり、車両の荷積みまたは荷降ろし) する目的による拠点での訪問数に相当します。 | Integer |
TotalRenewalServiceTime | リニューアルを持つルートの場合、ルート上のすべてのリニューアル拠点で費やされたサービス時間の合計を示します。 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
解析で算出されたルートに対して出力されるルート案内を示します。特定のルート案内イベントまたはマヌーバーが発生したルートに沿ったポイント位置として表されます。
| Field name | Description | Data type |
|---|---|---|
RouteID | 該当するルート案内ポイントが関連付けられている出力ルート フィーチャの ObjectID 値。 | Integer |
Sequence | 該当するルートのルート案内ポイントの順番 (1 から始まる)。 | Integer |
DirectionPointType | ポイントで記述されたルート案内イベントまたはマヌーバー タイプ。次のいずれかの値で表されます。
| Integer |
DisplayText | 使用中のアプリケーションで表示するルート案内テキスト。 | String |
ArrivalTime | UTC (協定世界時) でのルート案内イベントの発生時刻。 | Date |
ArrivalUTCOffset | マヌーバー位置の現地時間と ArrivalTime フィールドに示された UTC 時間との差異 (分単位)。 | Double |
Name | ルート案内ポイントの名前。 | String |
ExitName | ルート案内指示に表示される高速道路出口名。 | String |
AlternateName | ルート案内指示に表示される代替ソース名。 | String |
IntersectingName | ルート案内指示に表示される交差点または交差道路の名前。 | String |
BranchName | ルート案内指示に表示される分岐標識名。 | String |
TowardName | ルート案内指示に表示される目的地までの方向標識名。 | String |
Level | 該当するルート案内イベントが発生した建物の階。 この値は、解析用のネットワーク データセット内に定義された Level プロパティに相当します。 | Integer |
ShortVoiceInstruction | 使用中のアプリケーションで音声ガイダンス テキストとして使用する短い形式のテキスト。 | String |
VoiceInstruction | 使用中のアプリケーションで音声ガイダンス テキストとして使用する追加のテキスト (展開された略語と複数形の語句を含む)。 | String |
Azimuth | この地点を出発する車両の方位 (度単位)。 ゼロは北を示します。 | Double |
DirectionLines
解析で算出され、DirectionPoints イベント位置間またはマヌーバー位置間の各ルート セグメントを表すためにスライスされた出力ルート ラインを示します。
| フィールド名 | 説明 | データ タイプ |
|---|---|---|
DirectionPointID | 該当するラインが関連付けられている DirectionPoints テーブル内のフィーチャの ObjectID 値。 | Integer |
RouteID | 該当するルート案内ラインが関連付けられている出力ルート フィーチャの ObjectID 値。 | Integer |
DirectionLineType | 該当するラインで記述されたルート案内状況のタイプ。次のいずれかの値で表されます。
| Integer |
Meters | メートル単位で計測されたライン セグメントの長さ。 | Double |
Minutes | 分単位でのライン セグメントに沿った移動時間。 | Double |
FromLevel | 該当するルート案内イベントが始まる建物の階。 この値は、解析用のネットワーク データセット内に定義された Level プロパティに相当します。 | Integer |
ToLevel | 該当するルート案内イベントが終わる建物の階。 この値は、解析用のネットワーク データセット内に定義された Level プロパティに相当します。 | Integer |