13 Routing Engine
The Spatial and Graph routing engine (often referred to as the routing engine) enables you to host an XML-based web service that provides the following features:
-
Simple route requests return route information between the two locations.
-
Simple multi-address route requests return route information between three or more locations. The ordering of the locations in the response is user specified and is not optimized.
-
Traveling salesperson (TSP) route requests are a form of multi-address route request and also return route information between three or more locations. The ordering of some or all of the locations in the response can be reordered to optimize the overall route.
-
Batched route requests are a batch of one or more simple or multi-address route requests. This can be a mix of simple, simple multi-address and TSP requests. Each individual request looks like a single request but is encapsulated in a <batch_route_request> element. The routing engine differentiates batched requests from batch mode requests when it finds a <route_request> element embedded in the <batch_route_request> element.
-
Batch mode route requests return multiple responses, each with the same start location but different end locations.
For all requests, the start, intermediate, and end locations are identified by addresses, pre-geocoded addresses, or longitude/latitude coordinates.
Multi-address routes are explained in Section 13.1.
The Oracle Routing engine is implemented as a Java 2 Enterprise Edition (J2EE) Web application that can be deployed in an application server such as Oracle WebLogic Server.
Figure 13-1 shows the basic flow of action with the routing engine: a client locates a remote routing engine instance, sends a route request, and processes the route response returned by the routing engine instance.
Figure 13-1 Basic Flow of Action with the Spatial and Graph Routing Engine
Description of "Figure 13-1 Basic Flow of Action with the Spatial and Graph Routing Engine"
This chapter contains the following major sections:
This chapter does not include information about administering the routing engine. That information, which is for advanced users with specialized needs, is in Appendix E, "Routing Engine Administration".
13.1 Routing
Routes are computed between location elements. There are three types of location elements: <start_location>, <location> (intermediate locations or waypoints), and <end_location>. A location element can be specified as an address that is geocoded; as a pre-geocoded address, edge id/percentage pair; or as a latitude/longitude pair that is reverse geocoded.
This section includes the following topics:
13.1.1 Simple Route Request
Simple route requests must contain both a <start_location> and <end_location> element. The response for a simple route request is a single route from the start location to the end location.
Several attributes in a simple route request control how the route is computed and what is returned in the route response. These attributes are discussed in Section 13.3, "Routing Engine XML API".
13.1.2 Simple Multi-address Route Request
Simple multi-address route requests must contain at least three locations, including a required <start_location> element. Multi-address route requests must also contain one or more <location> elements, and optionally an <end_location> element.
The result of a simple multi-address route request is a single route from the start location, through each intermediate location, to the end location. This single route consists of multiple subroutes. Subroutes are the routes between each of the individual locations.
In a simple multi-address route request, the optimize_route attribute must be absent or set to FALSE. In simple multi-address route requests, all locations are fixed. There is no attempt to optimize the order in which the locations are visited. The locations in the route are visited in the order in which they were specified in the request.
Simple multi-address route requests use the route_type attribute to classify the route as an open or closed tour:
-
Open tour: The route ends at the final intermediate location or a specified end location.
-
Closed tour: The route returns to the start location.
If a simple multi-address closed tour route is requested, the
<start_location>element specification also used as the end location during route computation. If an<end_location>element is specified in a simple multi-address closed tour route request, an error is returned.
Example: Simple Multi-address Open Tour Route Request
Assume you want to drive from your workplace to customer A, then to customer B, and then to customer C.
-
The route request has your workplace as the start location, customers A and B as intermediate locations, and customer C as the end location.
-
The returned route has three subroutes: (1) workplace to customer A, (2) customer A to customer B, and (3) customer B to customer C.
-
Each subroute probably has multiple segments, each one associated with a specific driving direction step.
Example: Simple Multi-address Closed Tour Route Request
Assume you want to drive from your workplace to customer A, then to customer B, then to customer C, and then back to your workplace.
-
The route request has your workplace as the start location, and customers A, B, and C as intermediate locations. Your workplace is also used as the end location. An
<end_location>element .should not be specified in the route request. The routing engine adds the subroute from customer C to the workplace automatically when it sees a request for a closed tour. -
The returned route has four subroutes: (1) workplace to customer A, (2) customer A to customer B, (3) customer B to customer C, and (4) customer C back to the workplace.
-
Each subroute probably has multiple segments, each one associated with a specific driving direction step.
Simple multi-address requests can contain several attributes specific to each subroute. These attributes include return_subroutes, return_subroute_edge_ids, and return_subroute_geometry. These attributes are explained in Section 13.3.2, "Route Request XML Schema Definition".
13.1.3 Traveling Salesperson (TSP) Route Request
A traveling salesperson (TSP) route request must have at least three locations. Unlike simple multi-address route requests, the <start_location> element is optional.
TSP route requests are multi-address requests that have the optimize_route attribute present and set to TRUE. TSP route requests attempt to reorder the unfixed locations in the request to optimize the overall route.
All the locations in a TSP request are classified as unfixed or fixed:
-
Unfixed location: If a location is specified with the
<location>element, it is considered an unfixed location and is subject to reordering during route computation. -
Fixed location: If the location is specified with a
<start_location>or<end_location>element, it is considered a fixed location and is not subject to reordering during route computation.If intermediate locations need to be fixed, a simple multi-address route request should be used instead of a TSP route request.
TSP route requests use the route_type attribute to classify the route as an open or closed tour.:
-
Open tour: The route does not return to the start location.
-
Closed tour: The route returns to the start location.
If a TSP closed tour route is requested, the
<start_location>element must be specified. This start location is also used as the end location during route computation. If an<end_location>element is specified in a TSP closed tour route request, an error is returned. By definition, TSP closed tour routes use a single fixed start and end location but the intermediate locations are still subject to reordering.
Example: TSP Open Tour Route Request
To drive from your workplace, visiting customers A, B, and C:
-
The route has the workplace as a fixed start location.
-
The route has customers A, B, and C as unfixed intermediate locations. These locations are reordered to optimize the overall route.
-
The returned route is an optimized open tour route from the workplace to the first reordered location, through the second reordered location, to the final location.
Example: TSP Closed Tour Route Request
To drive from your workplace, visiting customers A, B, and C, and then returning to your workplace:
-
The route has the workplace as a fixed start location. The workplace is also used as a fixed end location. An
<end_location>element should not be specified in the route request. The routing engine adds the subroute from last unfixed location to the workplace automatically when it sees a request for a closed tour. -
The route has customers A, B, and C as unfixed intermediate locations. These locations are reordered to optimize the overall route.
-
The returned route is an optimized closed tour route from the workplace to the first reordered location, through the second and third reordered locations, and finally back to the start location.
TSP route requests can contain several attributes specific to each subroute. These attributes include return_subroutes, return_subroute_edge_ids, and return_subroute_geometry. These attributes are explained in Section 13.3.2, "Route Request XML Schema Definition".
13.1.4 Batched Route Request
Batched route requests are a hybrid of batch mode requests (explained in Section 13.1.5) and individual route requests. Batched route requests are a way to process multiple simple, simple multi-address, and TSP route requests in one request to the routing engine. Batching of batch mode requests is not allowed.
Like a batch mode request, the outermost element of a batched route request is <batch_route_request>. Unlike a batch mode request, batched route requests have one or more <route_request> elements nested inside the batch request.
In a batched route request, all attributes associated with the encompassing <batch_route_request> element are ignored. Instead, the attributes associated with the nested <route_request> elements are used when processing each individual route. This allows users to mix simple, simple multi-address, and TSP requests in a single batched individual route request.
The batched route request is useful for submitting multiple variations of a single route request with differing attributes and comparing the results, for example, for comparing the fastest route with the shortest route.
The individual route requests in a batched route request can use any of the attributes from simple route requests. They can also use any of the subroute-specific attributes of simple multi-address and TSP route requests.
All of the individual route requests in a batched route request are standalone; they have no effect on any other route request in the batch.
13.1.5 Batch Mode Route Request
A batch mode route request contains one <start_location> element and one or more <end_location> elements.
The result of a batch mode route request contains multiple routes. Each route is from the start location to one of the end locations. Each route in a batch mode request is completely separate from all the other routes except for the shared start location.
Batch mode route requests may contain several batch mode specific attributes. These attributes include cutoff_distance and sort_by_distance. These attributes are explained in Section 13.3.2, "Route Request XML Schema Definition".
13.2 Deploying the Routing Engine
Deploying the routing engine involves the following major tasks:
13.2.1 Preparing WebLogic Server
Before you deploy the routing engine, a Managed Server should be created in WebLogic Server (WLS). The managed server should have at least four gigabytes of memory in the heap. The more memory that is allocated to the heap, the more local partitions can be kept in the cache. Being able to keep more partitions in the cache is the single best way to improve the performance of the routing engine.
For the routing engine to be successfully deployed on a managed server, the server must have a data source associated with it. This data source provides a pool of connections to the database schema that contains the road network data and user data.
It is recommended that a WLS Work Manager be created and associated with the managed server. A work manager stores constraints on the number of requests that can run concurrently on the managed server. It also stores a constraint on the number of requests that can be queued before the managed server starts rejecting requests.
13.2.2 Unpacking the routeserver.ear File
To unpack the routeserver.ear.zip file, follow these steps.
In examples in these steps, the following values are used:
-
The WebLogic Server Home ($WLS_HOME) is
/scratch/software/Oracle/Middleware/user_projects/domains/spatial/. -
The application deployment directory is
$WLS_HOME/applications/.
However, use the values appropriate for your environment if they are different.
-
Copy
routeserver.ear.zipto the application deployment directory:cp routeserver.ear.zip $WLS_HOME/applications/
-
Unzip
routeserver.ear.zip:cd $WLS_HOME/applications/ unzip routeserver.ear.zip
13.2.3 Editing the web.xml File
This section describes changes to parameter values in the web.xml file that you must make for the routing engine to deploy properly. (There are also additional parameters that you can change to alter how the routing engine operates.)
-
Change the
container_dsparameter to be the JNDI Name of the data source associated with the managed server. For example:JNDI/NorthAmericanDS -
Change the
routeserver_network_nameparameter to the name of the Network Data Model (NDM) network built on the routing engine road network data. For example:NorthAmericanNetwork -
If the WLS Managed Server has a Work Manager associated with it, change the
wl-dispatch-policyparameter value to the name of the Work Manager. For example:NorthAmericanWM -
Check to be sure the
geocoder_typeparameter is set tohttpclientorNone. (thinclientis no longer supported.)-
If set to httpclient, then also set
geocoder_http_urlto the URL of the Geocoder servlet. For example:http://localhost:8888/geocoder/gcserver -
If an HTTP proxy is being used, then also specify
geocoder_http_proxy_hostandgeocoder_http_proxy_port. If no proxy exists, these two parameters can be ignored
-
-
If necessary, change the
logfile_nameparameter value. By default, thelogfile_nameparameter is set tolog/RouteServer.log. This default relative path includes a subdirectory namedlog, relative to where the routing engine is installed. Thelogfile_nameparameter can also be set to an absolute path, for example:/scratch/logs/RouteServer.log. -
Change the
partition_cache_sizeparameter. The default value for this parameter is 70, but it will probably need to be changed depending on the amount of memory allocated to the heap on the managed server. The following formula can be used to get a good starting point for a cache size.partition_cache_size = (NodesPerGigabyte/AvgNodesPartition)*UsableMemoryWhere:
-
NodesPerGigabyteis the number of nodes per gigabyte. (This value should not change. In the data sets as of December 2013, this value is 15000000, that is, 1.5 million.) -
AvgNodesPartitionis the average number of nodes per local partition. This does not include the highway partition 0. The memory for the highway partition is accounted for in the 1 gigabyte subtracted from the allocated heap size. For the North American data set, theAvgNodesPartitionvalue is around 26000. You can check the actual average nodes per partition by using the following query:SELECT AVG(COUNT(node_id)) FROM node WHERE partition_id>0 GROUP BY partition_id; -
UsableMemoryisthe managed server allocated heap size in Gigabytes minus 1 Gigabyte.
This formula generates a safe number for the
partition_cache_sizeparameter. Depending on the types of user information being used and the average number of concurrent requests being processed, it may be possible to add another 15% to 20% to this number. Use the WLS console to monitor the heap usage before changing this number.The heap can then be monitored while the routing engine is running to tune this number up or down. However, setting this value too high may cause the managed server to run out of memory.
-
13.2.4 Deploying the Routing Engine on WebLogic Server
To deploy the routing engine on WebLogic Server, follow these steps:
-
Log into the WLS console.
-
Click Deployments > Install.
-
Make sure that Path is set to the application deployment directory (as explained in Section 13.2.2).
-
Select routeserver.ear (a directory) and click Next.
-
Ensure that the Install this deployment as an application targeting style is selected, and click Next.
-
In the list of potential servers to which to deploy the routing engine, select the name of the managed server that you created, and click Next.
-
Ensure that the deployment name is routeserver, and click Finish.
After the routing engine is deployed, you can test the deployment with a set of routing engine test queries. For example, if the managed server was set up to run on port 7003, the routing engine servlet can be tested from http://localhost:7003/routeserver/.
These queries can run a variety of different types of route requests. These queries contain North American addresses, but the addresses can easily be manipulated on the web page for other data sets.
13.3 Routing Engine XML API
This section explains how to submit route requests in XML format to the routing engine, and it describes the XML Schema Definitions (XSDs) for the route requests (input) and responses (output). XML is widely used for transmitting structured documents using the HTTP protocol. If an HTTP request (GET or POST method) is used, it is assumed the request has a parameter named xml_request whose value is a string containing the XML document for the request.
A request to the routing engine servlet has the following format:
http://hostname:port/route-server-servlet-path?xml_request=xml-request
In this format:
-
hostname is the network path of the server on which the routing engine is running.
-
port is the port on which the application server listens.
-
route-server-servlet-path is the routing engine servlet path (for example,
routeserver/servlet/RouteServerServlet). -
xml-request is the URL-encoded XML request submitted using the HTML GET or POST method.
The input XML is required for all requests. The output will be an XML document.
In a simple route request, you must specify a route ID, and you can specify one or more of the following attributes:
-
route_preference:fastestorshortest(default) -
road_preference:highway(default) orlocal -
return_driving_directions(whether to return driving directions):trueorfalse(default) -
return_hierarchical_directions(whether to return hierarchical directions):trueorfalse(default) -
return_locations(return geocoded results for the start and end locations of the route and any subroutes):trueorfalse(default) -
return_subroutes(whether to return subroutes):true(default if a multi-address route, ignored for a single-address route) orfalse -
return_route_geometry(whether to return the line string coordinates for the route):trueorfalse(default) -
return_subroute_geometry(whether to return the line string coordinates for each subroute):trueorfalse(default for multi-address routes) -
return_segment_geometry(whether to return the line string coordinates for each maneuver in the route):trueorfalse(default) -
return_detailed_geometry:true(default; returns detailed geometries) orfalse(returns generalized geometries) -
language: language used to generate driving directions (ENGLISH(default),FRENCH,GERMAN,ITALIAN, orSPANISH) -
distance_unit:kilometer,mile(default), ormeter -
length_unit:usfor feet (default) ormetricfor meters -
time_unit:hour,minute(default), orsecond -
weight_unit:usfor tons (default) ormetricfor metric tons -
pre_geocoded_locations(whether the start and end locations are input locations (address specifications or points) or previously geocoded locations):true(previously geocoded locations) orfalse(default; input locations) -
driving_directions_detail:high,medium(default) orlow -
optimize_route:trueorfalse(default) -
route_type:open(default) orclosed -
vehicle_type:auto(default) ortruck -
truck_type:delivery,public,resident, ortrailer; (no default) -
truck_height: floating-point number inlength_units -
truck_length: floating-point number inlength_units -
truck_per_axle_weight: floating-point number inweight_units -
truck_weight: floating-point number inweight_units -
truck_width: floating-point number inlength_units
Batched route requests are groups of one or more simple (single, multi-address, or TSP) requests encapsulated in a <batch_route_request> element. All attributes associated with the <batch_route_request> element are ignored. Because all encapsulated requests are simple requests, they use the preceding listed attributes.
In a batch mode route request, you must specify a request ID, a start location, and one or more end locations. Each location must have an ID attribute. Most of the attributes used for simple requests have no meaning for batch mode. You can use one or more of the following attributes in a batch mode route request, but using an attribute not in this list will cause an exception to be raised.
-
route_preference:fastestorshortest(default) -
road_preference:highway(default) orlocal -
distance_unit:kilometer,km,mile(default), ormeter -
time_unit:hour,minute(default), orsecond -
sort_by_distance(whether to sort the returned routes in ascending order by distance of the end location from the start location):trueorfalse(default) -
cutoff_distance(returning only routes where the end location is less than or equal to a specified number of distance units from the start location): (number; default = no limit) -
pre_geocoded_locations(whether the start and end locations are input locations (address specifications or points) or previously geocoded locations):true(previously geocoded locations) orfalse(default; input locations)
This section includes the following topics:
13.3.1 Route Request and Response Examples
This section contains XML examples of route requests and the responses generated by those requests. One request uses specified addresses, another uses points specified by longitude and latitude coordinates, and another uses previously geocoded locations. For reference information about the available elements and attributes, see Section 13.3.2 for requests and Section 13.3.3 for responses.
Example 13-1 shows a simple request for the fastest route, preferably using highways, between two offices at specified addresses (in Waltham, Massachusetts and Nashua, New Hampshire) in a 5.67 metric ton delivery truck. The response contains driving directions for each segment using kilometers for distances and minutes for times. This request also returns the geocode information for the start and end location.
Example 13-1 Route Request with Specified Addresses
<?xml version="1.0" standalone="yes"?>
<route_request
id="8"
route_preference="fastest"
road_preference="highway"
vehicle_type="truck"
truck_type="delivery"
truck_weight="5.67"
return_driving_directions="true"
return_locations="true"
distance_unit="km"
time_unit="minute"
weight_unit="metric">
<start_location>
<input_location id="1">
<input_address>
<us_form1
street="1000 Winter St"
lastline="Waltham, MA" />
</input_address>
</input_location></start_location>
<end_location>
<input_location id="2">
<input_address>
<us_form1
street="1 Oracle Dr"
lastline="Nashua, NH" />
</input_address>
</input_location>
</end_location>
</route_request>
Example 13-2 shows the response generated by the request in Example 13-1. (The output is reformatted for readability.)
Example 13-2 Response for Route Request with Specified Addresses
<!-- Oracle Routeserver version 12.1.0.1.0 (data version 11.1.0.7.1) -->
<route_response>
<route id="8" step_count="12"
distance="46.07216796875" distance_unit="km"
time="31.133371988932293" time_unit="minute"
start_location="1" end_location="2">
<start_location>
<location id="1"
longitude="-71.25962" latitude="42.39741"
house_number="399" street="WINTER ST"
city="WALTHAM" state="MA" country="US"
driving_side="R"
postal_code="02451"
edge_id="906810462" percent="0.0"/>
</start_location>
<segment sequence="1"
instruction="Start out on Winter St (Going Southwest)"
distance="0.0" time="0.0"/>
<segment sequence="2"
instruction="Turn RIGHT onto Wyman St (Going North)"
distance="0.3453199939727783" time="0.3597083270549774"/>
<segment sequence="3"
instruction="Take RAMP toward Peabody"
distance="0.43125000953674314" time="0.3478285253047943"/>
<segment sequence="4"
instruction="Merge onto I-95 N/RT-128 N (Going North)"
distance="9.598520091056823" time="6.1528975268205"/>
<segment sequence="5"
instruction="Continue on toward Burlington"
distance="0.0" time="0.0"/>
<segment sequence="6"
instruction="Stay STRAIGHT to go onto RAMP (Going East)"
distance="0.22952000427246094" time="0.23908333778381347"/>
<segment sequence="7"
instruction="Continue on toward Lowell"
distance="0.5157099990844727" time="0.5371979157129924"/>
<segment sequence="8"
instruction="Stay STRAIGHT to go onto US-3 N (Going Northwest)"
distance="33.26371000862122" time="21.322891048093638"/>
<segment sequence="9"
instruction="Take EXIT 1 toward S. Nashua"
distance="0.6134100036621094" time="0.5454034169514974"/>
<segment sequence="10"
instruction="Continue on toward So. Nashua"
distance="0.27333999633789063" time="0.41415150960286456"/>
<segment sequence="11"
instruction="Turn LEFT onto Spit Brook Rd (Going West)"
distance="0.8013799934387207" time="1.2142121195793152"/>
<segment sequence="12"
instruction="Turn RIGHT onto Oracle Dr (Going North)"
distance="0.0" time="0.0"/>
<end_location>
<location id="2"
longitude="-71.45937" latitude="42.70783"
house_number="1" street="ORACLE DR"
city="NASHUA" state="NH" country="US"
driving_side="R"
postal_code="03062"
edge_id="22325991" percent="0.0"/>
</end_location>
</route>
</route_response>
Example 13-3 shows a request for a closed tour TSP shortest route, preferably using highways, between four locations specified as longitude/latitude points. (The points are associated with four locations in San Francisco, California: the World Trade Center, Golden Gate Park, 3001 Larkin Street, and 100 Flower Street.) The route starts and ends at a fixed location at the World Trade Center, but the other three locations are subject to reordering to produce an optimal route. The information from the geocoder is returned for all location in the route. The geometry is displayed at the subroute level, and edge IDs are displayed with the driving directions at the segment level.
Example 13-3 Route Request with Locations Specified as Longitude/Latitude Points
<?xml version="1.0" standalone="yes"?>
<route_request id="8"
route_preference="shortest"
route_type="closed"
optimize_route="true"
road_preference="highway"
return_locations="true"
return_driving_directions="true"
return_subroutes="true"
return_route_geometry="false"
return_subroute_geometry="true"
return_segment_geometry= "false"
return_segment_edge_ids= "true"
>
<start_location>
<input_location id="1" longitude="-122.39436" latitude="37.79579"/>
</start_location>
<location>
<input_location id="2" longitude="-122.45412" latitude="37.7714" />;
</location>
<location>
<input_location id="3" longitude="-122.422" latitude="37.80551" />
</location>
<location>
<input_location id="4" longitude="-122.40459" latitude="37.74211" />
</location>
</route_request>
Example 13-4 shows the response generated by the request in Example 13-3. (The output is reformatted for readability.)
Example 13-4 Response for Route Request with Locations Specified as Longitude/Latitude Points
<!-- Oracle Routeserver version 12.1.0.2.0 (data version 11.1.0.7.1) -->
<route_response>
<route id="8" step_count="88"
distance="15.105344411681319" distance_unit="mile"
time="35.63843688964844" time_unit="minute"
start_location="1" end_location="1">
<subroute id="1" step_count="5"
distance="1.8589950065634127" distance_unit="mile"
time="4.305604044596354" time_unit="minute"
start_location="1" end_location="3">
<subroute_geometry>
<LineString><coordinates>
-122.39436,37.79579 -122.39436,37.79579 -122.39454,37.79601
-122.39467,37.79614 -122.39486,37.79633 -122.39499,37.79647
-122.39529,37.79678 -122.39558,37.79709 -122.39592,37.79747
-122.3963,37.7979 -122.39646,37.79808 -122.3969,37.79858
-122.39741,37.79916 -122.39755,37.79929 -122.39776,37.79918
-122.39793,37.79907 -122.39811,37.79899 -122.39821,37.79896
-122.39836,37.79892 -122.39867,37.79889 -122.39986,37.79874
-122.40104,37.7986 -122.40223,37.79845 -122.40302,37.79835
-122.40308,37.79834 -122.40349,37.79828 -122.40384,37.79824
-122.40466,37.79813 -122.40545,37.79802 -122.40549,37.79802
-122.4062,37.79794 -122.40622,37.79794 -122.40664,37.79789
-122.40707,37.79816 -122.40789,37.79872 -122.40846,37.7991
-122.40898,37.7995 -122.41017,37.80031 -122.41038,37.80045
-122.41078,37.80073 -122.41089,37.8008 -122.41094,37.80084
-122.41136,37.80112 -122.41143,37.80118 -122.41248,37.80188
-122.41254,37.80193 -122.41289,37.80218 -122.41367,37.80274
-122.41488,37.80355 -122.41547,37.80396 -122.41607,37.80441
-122.41657,37.80475 -122.41681,37.80492 -122.4172,37.80519
-122.4178,37.8056 -122.41837,37.80598 -122.41873,37.80593
-122.42035,37.80573 -122.422,37.80551
-122.42199999992847,37.805509999663826
</coordinates></LineString>
</subroute_geometry>
<start_location>
<location id="1"
longitude="-122.39436" latitude="37.79579"
house_number="" street="HERB CAEN WAY"
city="SAN FRANCISCO" state="CA" country="US"
driving_side="R"
postal_code="94111"
edge_id="724791174" percent="1.0"/>
</start_location>
<segment sequence="1"
instruction="Start out on The Embarcadero (Going Northwest)"
distance="0.29822904401544625" time="0.49993750055631003">
<segment_edge_ids><edge_ids>
724791174, 724791175, 733049363, 915793201, 915793202, 830932896,
112011102, 112011103, 830934259, 830934260, 726169597, 112011105,
37830229
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="2"
instruction="Turn LEFT onto Broadway (Going Southwest)"
distance="0.5093705394140182" time="1.2420151789983114">
<segment_edge_ids><edge_ids>
-24571168, -724946174, -724946173, -23598782, -23621077, -23598783,
-23598784, -23598786, -23598787, -23598788, -23598789, -23598791,
-23598792
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="3"
instruction="Turn SLIGHT RIGHT onto Columbus Ave (Going Northwest)"
distance="0.8505250718279074" time="2.07386361459891">
<segment_edge_ids><edge_ids>
23601001, 23601002, 23601003, 23601004, 830239101, 830239102,
799420615, 23601006, 23601007, 23601008, 23737804, 23601009,
23601010, 23601011, 23737805, 23601012, 754219681, 754219682,
23622414, 754224948, 754224949
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="4"
instruction="Turn SLIGHT LEFT onto North Point St (Going West)"
distance="0.20086994241069608" time="0.48978787660598755">
<segment_edge_ids><edge_ids>
-23612405, -23612406, -23612407
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="5"
instruction="Turn LEFT onto Larkin St (Going South)"
distance="2.3560371803568745E-8" time="5.744803956986288">
<segment_edge_ids><edge_ids>
-23609029
</edge_ids></segment_edge_ids>
</segment>
<end_location>
<location id="3"
longitude="-122.42199999966279" latitude="37.80551000007165"
house_number="2999" street="LARKIN ST" city="SAN FRANCISCO"
state="CA" country="US"
driving_side="R"
postal_code="94109"
edge_id="23609029" percent="0.9999996412873026"/>
</end_location>
</subroute>
<subroute id="2" step_count="32"
distance="4.0150478493172495" distance_unit="mile"
time="9.790025838216145" time_unit="minute"
start_location="3" end_location="2">
<subroute_geometry>
<LineString><coordinates>
-122.42199999992847,37.805509999663826 -122.422,37.80551
-122.42364,37.8053 -122.42345,37.80436 -122.42327,37.80342
-122.42482,37.80322 -122.42496,37.8032 -122.42545,37.80314
-122.42656,37.803 -122.42638,37.80207 -122.4262,37.80111
-122.42782,37.8009 -122.42947,37.80069 -122.43111,37.80048
-122.43276,37.80026 -122.43439,37.80006 -122.43605,37.79985
-122.43597,37.79943 -122.43588,37.79896 -122.43751,37.79874
-122.43742,37.79828 -122.43733,37.79781 -122.43895,37.79759
-122.43877,37.79667 -122.44041,37.79645 -122.44025,37.79554
-122.4419,37.7953 -122.44173,37.79439 -122.44153,37.79343
-122.44308,37.79323 -122.44317,37.79322 -122.44328,37.79321
-122.44476,37.79302 -122.44487,37.79301 -122.44496,37.793
-122.44643,37.7928 -122.4463,37.79188 -122.44614,37.79099
-122.44595,37.79011 -122.44577,37.78924 -122.44559,37.78836
-122.44697,37.78818 -122.44688,37.78775 -122.44687,37.78769
-122.44678,37.78726 -122.44676,37.78705 -122.44671,37.78679
-122.44675,37.78651 -122.4468,37.78635 -122.44689,37.78618
-122.44697,37.78603 -122.44749,37.7855 -122.44766,37.78538
-122.44792,37.78513 -122.448,37.78507 -122.44814,37.78496
-122.44929,37.78468 -122.45012,37.78448 -122.45015,37.78432
-122.4502,37.78418 -122.45034,37.78396 -122.45041,37.78383
-122.45043,37.78369 -122.45012,37.78218 -122.45112,37.78205
-122.45109,37.78192 -122.45082,37.78064 -122.45186,37.78049
-122.45287,37.78037 -122.45385,37.78023 -122.45374,37.77943
-122.45367,37.77905 -122.45349,37.77817 -122.45339,37.77781
-122.45332,37.77763 -122.45318,37.77685 -122.45303,37.77596
-122.45299,37.77574 -122.45283,37.77499 -122.45297,37.77497
-122.45287,37.77443 -122.45279,37.77404 -122.45262,37.7731
-122.45241,37.77215 -122.45276,37.77206 -122.45301,37.77195
-122.45346,37.77172 -122.45387,37.77153 -122.45398,37.77148
-122.45412868777395,37.77142244344235
</coordinates></LineString>
</subroute_geometry>
<start_location>
<location id="3"
longitude="-122.42199999966279" latitude="37.80551000007165"
house_number="2999" street="LARKIN ST" city="SAN FRANCISCO"
state="CA" country="US"
driving_side="R"
postal_code="94109"
edge_id="23609029" percent="0.9999996412873026"/>
</start_location>
<segment sequence="1"
instruction="Start out on Larkin St (Going North)"
distance="2.3560371803568745E-8" time="5.7448039569862884E-8">
<segment_edge_ids><edge_ids>
23609029
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="2"
instruction="Turn LEFT onto North Point St (Going West)"
distance="0.09072267445473188" time="0.22121211687723796">
<segment_edge_ids><edge_ids>
-23612408
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="3"
instruction="Turn LEFT onto Polk St (Going South)"
distance="0.1314981638707435" time="0.3206363519032796">
<segment_edge_ids><edge_ids>
-23614397, -23614396
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="4"
instruction="Turn RIGHT onto Francisco St (Going West)"
distance="0.1819921735430389" time="0.443757571776708">
<segment_edge_ids><edge_ids>
-23604420, -120906034, -916007650, -916007649
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="5"
instruction="Turn LEFT onto Franklin St (Going South)"
distance="0.13209470069661014" time="0.32209091186523436">
<segment_edge_ids><edge_ids>
-23604500, -23604499
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="6"
instruction="Turn RIGHT onto Lombard St (Going West)"
distance="0.544926363604202"
time="1.3287121295928954">
<segment_edge_ids><edge_ids>
-23609690, -23609691, -23609692, -23609693, -23609694,
-23609695
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="7"
instruction="Turn LEFT onto Fillmore St (Going South)"
distance="0.06220717119887626"
time="0.15168182055155435">
<segment_edge_ids><edge_ids>
-23604040, -23604039
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="8"
instruction="Turn RIGHT onto Greenwich St (Going West)"
distance="0.09030634551112576"
time="0.22019697825113932">
<segment_edge_ids><edge_ids>
-23605619
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="9"
instruction="Turn LEFT onto Steiner St (Going South)"
distance="0.06502205890116725" t
time="0.15854545434316">
<segment_edge_ids><edge_ids>
-23618095, -23618094
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="10"
instruction="Turn RIGHT onto Filbert St (Going West)"
distance="0.08977195129603127"
time="0.21889394124348957">
<segment_edge_ids><edge_ids>
-23603994
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="11"
instruction="Turn LEFT onto Pierce St (Going South)"
distance="0.06433853285001388"
time="0.15687878926595053">
<segment_edge_ids><edge_ids>
-23614117
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="12"
instruction="Turn RIGHT onto Union St (Going West)"
distance="0.09084695019464499"
time="0.22151514689127605">
<segment_edge_ids><edge_ids>
-23619255
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="13"
instruction="Turn LEFT onto Scott St (Going South)"
distance="0.06349965975356134"
time="0.15483333269755045">
<segment_edge_ids><edge_ids>
-23616716
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="14"
instruction="Turn RIGHT onto Green St (Going West)"
distance="0.09162990537119692"
time="0.2234242598215739">
<segment_edge_ids><edge_ids>
-23605539
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="15"
instruction="Turn LEFT onto Divisadero St (Going South)"
distance="0.13081463781959013"
time="0.3189696947733561">
<segment_edge_ids><edge_ids>
-23602190, -23602189
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="16"
instruction="Turn RIGHT onto Broadway (Going West)"
distance="0.2711613656927398"
time="0.6611817995707194">
<segment_edge_ids><edge_ids>
-829713884, -829713883, -829713879, -829713878,
-829713874, -829713887,-829713886
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="17"
instruction="Turn LEFT onto Lyon St (Going South)"
distance="0.3103461147339876"
<segment sequence="16"
instruction="Turn RIGHT onto Broadway (Going West)"
distance="0.2711613656927398"
time="0.6611817995707194">
<segment_edge_ids><edge_ids>
-829713884, -829713883, -829713879, -829713878,
-829713874, -829713887,-829713886
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="17"
instruction="Turn LEFT onto Lyon St (Going South)"
distance="0.3103461147339876"
time="0.7567272663116456">
<segment_edge_ids><edge_ids>
-28479560, -23609965, -23609964, -23609963, -23609962
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="18"
instruction="Turn RIGHT onto Sacramento St (Going West)"
distance="0.07639346451339481"
time="0.18627273241678874">
<segment_edge_ids><edge_ids>
-23615823
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="19"
instruction="Turn LEFT onto Presidio Ave (Going South)"
distance="0.09716025402078811"
time="0.23690908749898273">
<segment_edge_ids><edge_ids>
-754763527, -754763526,-23747787
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="20"
instruction="Turn SLIGHT RIGHT onto RAMP (Going South)"
distance="0.054849932668282114"
time="0.1337424119313558">
<segment_edge_ids><edge_ids>
-23747788
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="21"
instruction="Turn SLIGHT RIGHT onto Masonic Ave (Going Southwest)"
distance="0.09798048860074304"
time="0.23890908559163412">
<segment_edge_ids><edge_ids>
-723450070, -723450073
</edge_ids></segment_edge_ids>
</segment>
time="0.7567272663116456">
<segment_edge_ids><edge_ids>
-28479560, -23609965, -23609964, -23609963, -23609962
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="18"
instruction="Turn RIGHT onto Sacramento St (Going West)"
distance="0.07639346451339481"
time="0.18627273241678874">
<segment_edge_ids><edge_ids>
-23615823
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="19"
instruction="Turn LEFT onto Presidio Ave (Going South)"
distance="0.09716025402078811"
time="0.23690908749898273">
<segment_edge_ids><edge_ids>
-754763527, -754763526,-23747787
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="20"
instruction="Turn SLIGHT RIGHT onto RAMP (Going South)"
distance="0.054849932668282114"
time="0.1337424119313558">
<segment_edge_ids><edge_ids>
-23747788
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="21"
instruction="Turn SLIGHT RIGHT onto Masonic Ave (Going Southwest)"
distance="0.09798048860074304"
time="0.23890908559163412">
<segment_edge_ids><edge_ids>
-723450070, -723450073
</edge_ids></segment_edge_ids>
</segment>
<end_location>
<location id="2"
longitude="-122.45412868707837" latitude="37.771422441619094"
house_number="" street="JOHN F KENNEDY DR"
city="SAN FRANCISCO" state="CA" country="US"
driving_side="R"
postal_code="94118"
edge_id="728011751" percent="0.5203619908971352"/>
</end_location>
</subroute>
<subroute id="3" step_count="36"
distance="4.848880093441248" distance_unit="mile"
time="11.788133748372395" time_unit="minute"
start_location="2" end_location="4">
<subroute_geometry>
<LineString><coordinates>
-122.45412868777395,37.77142244344235 -122.45429,37.77136
-122.4546,37.77123 -122.45483,37.77114 -122.4551,37.77103
-122.4552,37.77097 -122.45533,37.77086 -122.45501,37.77098
-122.4547,37.77107 -122.45447,37.77116 -122.45424,37.77124
-122.45396,37.77135 -122.45384,37.7714 -122.45382,37.77141
-122.45369,37.77143 -122.45358,37.77144 -122.45347,37.77143
-122.4529,37.77133 -122.45222,37.77123 -122.45205,37.77031
-122.45043,37.77051 -122.45021,37.76958 -122.44967,37.76964
-122.44945,37.76872 -122.44839,37.76885 -122.44756,37.76895
-122.44672,37.76907 -122.44593,37.76917 -122.44555,37.76733
-122.44473,37.76743 -122.44467,37.76702 -122.44456,37.76645
-122.44451,37.76631 -122.44418,37.76596 -122.44361,37.76539
-122.44347,37.76536 -122.44273,37.76532 -122.44246,37.7653
-122.44232,37.76529 -122.44192,37.76527 -122.44202,37.76513
-122.44229,37.76511 -122.44232,37.76508 -122.44232,37.765
-122.44219,37.76499 -122.44209,37.76496 -122.44107,37.76443
-122.43976,37.76376 -122.4392,37.76348 -122.43908,37.76344
-122.43795,37.76329 -122.43781,37.7633 -122.43709,37.76333
-122.43528,37.76346 -122.43523,37.76312 -122.43519,37.76283
-122.43516,37.76264 -122.43515,37.76258 -122.43511,37.76207
-122.43504,37.76128 -122.435,37.76089 -122.43388,37.76095
-122.43278,37.76101 -122.43057,37.76115 -122.43048,37.76036
-122.43039,37.75958 -122.42824,37.75972 -122.42816,37.7589
-122.42805,37.75806 -122.42789,37.75807 -122.42583,37.75821
-122.42566,37.75822 -122.42347,37.75836 -122.42126,37.75851
-122.42047,37.75854 -122.42028,37.75695 -122.41999,37.75696
-122.4197,37.75698 -122.41892,37.75702 -122.41874,37.75545
-122.41766,37.75553 -122.41659,37.75557 -122.41549,37.75563
-122.41533,37.75405 -122.41425,37.75412 -122.41385,37.75414
-122.41312,37.75417 -122.41204,37.75424 -122.41109,37.75428
-122.4102,37.75433 -122.41004,37.75276 -122.40913,37.75282
-122.40818,37.75287 -122.40733,37.75292 -122.40713,37.75133
-122.40617,37.75138 -122.40614,37.75103 -122.40613,37.75096
-122.40611,37.75088 -122.40602,37.75067 -122.40599,37.75051
-122.40578,37.75013 -122.40565,37.74987 -122.40529,37.74937
-122.40518,37.74924 -122.40506,37.74913 -122.40483,37.74896
-122.4045,37.74873 -122.40441,37.74867 -122.40437,37.74864
-122.4041,37.74845 -122.40393,37.74827 -122.40384,37.74815
-122.40378,37.74801 -122.40375,37.74785 -122.40381,37.74762
-122.40397,37.74719 -122.4043,37.74633 -122.40434,37.74618
-122.40434,37.74603 -122.40431,37.74594 -122.4042,37.74554
-122.40416,37.7453 -122.40417,37.74515 -122.40431,37.74464
-122.40445,37.74427 -122.40461,37.74393 -122.40479,37.74362
-122.40522,37.74304 -122.40538,37.74284 -122.40565,37.7425
-122.40517,37.74233 -122.40459,37.74211
</coordinates></LineString>
</subroute_geometry>
<start_location>
<location id="2"
longitude="-122.45412868707837" latitude="37.771422441619094"
house_number="" street="JOHN F KENNEDY DR"
city="SAN FRANCISCO" state="CA" country="US"
driving_side="R"
postal_code="94118"
edge_id="728011751" percent="0.5203619908971352"/>
</start_location>
<segment sequence="1"
instruction="Start out on John F Kennedy Dr (Going West)"
distance="0.02898340160626114"
time="0.07067119280497233">
<segment_edge_ids><edge_ids>
-728011751, -728011750
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="2"
instruction="Stay STRAIGHT to go onto Kezar Dr (Going Southwest)"
distance="0.04787796125753919"
time="0.11674242814381917">
<segment_edge_ids><edge_ids>
-23747756
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="3"
instruction="Turn SHARP LEFT onto John F Kennedy Dr (Going East)"
distance="0.08222829797036355"
time="0.20049999952316283">
<segment_edge_ids><edge_ids>
23747762, 728012586, 724789094
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="4"
instruction="Stay STRAIGHT to go onto Oak St (Going Northeast)"
distance="0.09773193475050901"
time="0.2383030315240224">
<segment_edge_ids><edge_ids>
724764533, 724764534, -23738012
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="5"
instruction="Turn RIGHT onto Shrader St (Going South)"
distance="0.06425775409315192"
time="0.15668182373046874">
<segment_edge_ids><edge_ids>
-23617167
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="6"
instruction="Turn LEFT onto Page St (Going East)"
distance="0.08957932247692126"
time="0.21842424074808756">
<segment_edge_ids><edge_ids>
23613434
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="7"
instruction="Turn RIGHT onto Cole St (Going South)"
distance="0.06538868039329745"
time="0.1594394048055013">
<segment_edge_ids><edge_ids>
-23600911
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="8"
instruction="Turn LEFT onto Haight St (Going East)"
distance="0.02978934855322748"
time="0.07263635794321696">
<segment_edge_ids><edge_ids>
23605814
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="9"
instruction="Turn RIGHT onto Belvedere St (Going South)"
distance="0.06471136481056884"
time="0.1577878793080648">
<segment_edge_ids><edge_ids>
-23598189
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="10"
instruction="Turn LEFT onto Waller St (Going East)"
distance="0.1948176204828599"
time="0.4750302950541178">
<segment_edge_ids><edge_ids>
23620205, 23620204, 23620203, 23620202
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="11"
instruction="Turn RIGHT onto Delmar St (Going South)"
distance="0.12885726410065712"
time="0.3141969680786133">
<segment_edge_ids><edge_ids>
-23602039
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="12"
instruction="Turn LEFT onto Frederick St (Going East)"
distance="0.04533026592197986"
time="0.11053029696146648">
<segment_edge_ids><edge_ids>
23604508
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="13"
instruction="Turn RIGHT onto Masonic Ave (Going South)"
distance="0.2072702425733493"
time="0.5053939501444499">
<segment_edge_ids><edge_ids>
-932510459, -932510458, -23610757, -23610758,
-814886921
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="14"
instruction="Stay STRAIGHT to go onto Roosevelt Way (Going East)"
distance="0.04439197258915798"
time="0.1082424263159434">
<segment_edge_ids><edge_ids>
-814886920, -799371986, -799371985
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="15"
instruction="Turn RIGHT onto Levant St (Going Southwest)"
distance="0.03410178286259032"
time="0.0831515113512675">
<segment_edge_ids><edge_ids>
-799371984, -799371983
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="16"
instruction="Turn LEFT onto States St (Going Southeast)"
distance="0.4172186714314114"
time="1.0173182010650634">
<segment_edge_ids><edge_ids>
-829568337, -936352352, -936352351, -932495104,
932495103, 799475779
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="17"
instruction="Turn RIGHT onto Castro St (Going South)"
distance="0.1783259826221157"
time="0.4348181843757629">
<segment_edge_ids><edge_ids>
-754012004, -833349280, -833349279, -905543898,
-905543897, -753950604, -753950603
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="18"
instruction="Turn LEFT onto 18th St (Going East)"
distance="0.24272664830496957"
time="0.5918484846750895">
<segment_edge_ids><edge_ids>
23594648, 23594647, 23594646
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="19"
instruction="Turn RIGHT onto Sanchez St (Going South)"
distance="0.10895420615626991"
time="0.26566667556762696">
<segment_edge_ids><edge_ids>
-23616290, -23616291
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="20"
instruction="Turn LEFT onto 19th St (Going East)"
distance="0.11787733607670552"
time="0.2874242464701335">
<segment_edge_ids><edge_ids>
23594737
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="21"
instruction="Turn RIGHT onto Church St (Going South)"
distance="0.115211584951289"
time="0.2809242566426595">
<segment_edge_ids><edge_ids>
-23600503, -23600504
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="22"
instruction="Turn LEFT onto 20th St (Going East)"
distance="0.4155409305719238"
time="1.0132273137569427">
<segment_edge_ids><edge_ids>
732180611, 732180612, 23747712, 23594835,
23594834, 23594833
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="23"
instruction="Turn RIGHT onto Lexington St (Going South)"
distance="0.11038339612853318"
time="0.5921333312988282">
<segment_edge_ids><edge_ids>
-23609398
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="24"
instruction="Turn LEFT onto 21st St (Going East)"
distance="0.07448580061634548"
time="0.18162120978037516">
<segment_edge_ids><edge_ids>
23594883, 23594882, 23594881
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="25"
instruction="Turn RIGHT onto Mission St (Going South)"
distance="0.10895420141545431"
time="0.26566665967305503">
<segment_edge_ids><edge_ids>
-23611414
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="26"
instruction="Turn LEFT onto 22nd St (Going East)"
distance="0.17805878047745186"
time="0.4341666539510091">
<segment_edge_ids><edge_ids>
23594956, 23594955, 23594954
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="27"
instruction="Turn RIGHT onto Shotwell St (Going South)"
distance="0.10955073824132096"
time="0.2671212196350098">
<segment_edge_ids><edge_ids>
-23617156
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="28"
instruction="Turn LEFT onto 23rd St (Going East)"
distance="0.28101037926858485"
time="0.6851969718933105">
<segment_edge_ids><edge_ids>
23595024, 799561724, 799561725, 23595022,
23595021, 23595020
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="29"
instruction="Turn RIGHT onto Florida St (Going South)"
distance="0.10886099698092727"
time="0.26543939908345543">
<segment_edge_ids><edge_ids>
-23604143
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="30"
instruction="Turn LEFT onto 24th St (Going East)"
distance="0.14851177530603368"
time="0.3621212085088094">
<segment_edge_ids><edge_ids>
23595090, 23595089, 23595088
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="31"
instruction="Turn RIGHT onto Hampshire St (Going South)"
distance="0.11043310832082466"
time="0.26927274068196616">
<segment_edge_ids><edge_ids>
-23605909
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="32"
instruction="Turn LEFT onto 25th St (Going East)"
distance="0.05257565439032596"
time="0.1281969706217448">
<segment_edge_ids><edge_ids>
23595179
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="33"
instruction="Turn RIGHT onto Potrero Ave (Going South)"
distance="0.050077673617465915"
time="0.1221060593922933">
<segment_edge_ids><edge_ids>
-724773368, -724773367
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="34"
instruction="Take RAMP toward Bayshore Blvd"
distance="0.03984341188503202"
time="0.09715151786804199">
<segment_edge_ids><edge_ids>
-915517048
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="35"
instruction="Stay STRAIGHT to go onto Bayshore Blvd(Going Southeast)"
distance="0.5910582184784158"
time="1.0831619163354238">
<segment_edge_ids><edge_ids>
-915517047, -120885637, -830210066, -776735343,
-776735342, -756632225, -756632224, -127815508,
-23621037, -23621038, -23621034, -756635722,
-756635721, -23597820, -756635724, -756635723
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="36"
instruction="Turn LEFT onto Flower St (Going East)"
distance="0.06390356064909457"
time="0.15581818421681723">
<segment_edge_ids><edge_ids>
-23604154, -23604155
</edge_ids></segment_edge_ids>
</segment>
<end_location>
<location id="4"
longitude="-122.40459" latitude="37.74211"
house_number="99" street="FLOWER ST" city="SAN FRANCISCO"
state="CA" country="US"
driving_side="R"
postal_code="94124"
edge_id="23604155" percent="0.0"/>
</end_location>
</subroute>
<subroute id="4" step_count="15"
distance="4.382421462359411" distance_unit="mile"
time="9.754673258463542" time_unit="minute"
start_location="4" end_location="1">
<subroute_geometry>
<LineString><coordinates>
-122.40459,37.74211 -122.40459,37.74211 -122.40431,37.74253
-122.40366,37.74342 -122.40322,37.74381 -122.40289,37.74515
-122.40268,37.74635 -122.40295,37.74675 -122.40311,37.747
-122.40327,37.74723 -122.40332,37.74737 -122.40342,37.74753
-122.40348,37.74767 -122.40354,37.74787 -122.40365,37.74821
-122.40367,37.74839 -122.40366,37.74857 -122.40358,37.74883
-122.40353,37.74897 -122.40343,37.74916 -122.40336,37.74926
-122.40329,37.74932 -122.4032,37.74936 -122.40306,37.7494
-122.40283,37.74944 -122.40283,37.74994 -122.40281,37.75019
-122.4028,37.75044 -122.40276,37.7505 -122.40266,37.75057
-122.40221,37.7506 -122.40231,37.75197 -122.40242,37.75326
-122.40254,37.75452 -122.40163,37.75458 -122.40178,37.75614
-122.40187,37.75714 -122.40198,37.75826 -122.40199,37.75842
-122.4021,37.75969 -122.40222,37.76095 -122.40235,37.76223
-122.40248,37.76352 -122.40254,37.76478 -122.40268,37.7661
-122.40282,37.76738 -122.40295,37.76865 -122.40306,37.76983
-122.40351,37.76981 -122.40363,37.76989 -122.40378,37.76999
-122.40382,37.77002 -122.40386,37.77004 -122.4036,37.77025
-122.40285,37.77086 -122.40226,37.77134 -122.40203,37.77153
-122.40166,37.77183 -122.40131,37.77211 -122.40113,37.77226
-122.39968,37.7734 -122.39956,37.7735 -122.39943,37.77361
-122.39723,37.77535 -122.39539,37.77679 -122.39499,37.77711
-122.39457,37.77743 -122.3943,37.77764 -122.3939,37.77795
-122.39356,37.77823 -122.39344,37.77832 -122.3933,37.77843
-122.39275,37.77886 -122.39259,37.77899 -122.39256,37.77902
-122.39239,37.77915 -122.39222,37.77929 -122.39203,37.77944
-122.39141,37.77994 -122.39108,37.7802 -122.39052,37.78062
-122.38974,37.78123 -122.38923,37.78161 -122.38911,37.78166
-122.38896,37.78173 -122.38863,37.78179 -122.38841,37.78181
-122.38814,37.7818 -122.38813,37.78195 -122.38811,37.7823
-122.38811,37.78254 -122.3881,37.78266 -122.38806,37.78316
-122.38802,37.78335 -122.38791,37.78477 -122.38789,37.78504
-122.3878,37.7861 -122.3878,37.78615 -122.38771,37.78707
-122.3877,37.78722 -122.38769,37.78747 -122.3877,37.78766
-122.38772,37.78791 -122.38779,37.78835 -122.38788,37.7888
-122.38794,37.78896 -122.38816,37.78937 -122.38838,37.78965
-122.38859,37.78984 -122.38935,37.79047 -122.38978,37.79082
-122.38992,37.79095 -122.39013,37.7912 -122.39028,37.79141
-122.39041,37.79166 -122.39049,37.79181 -122.39061,37.79205
-122.39071,37.79226 -122.39093,37.79252 -122.39117,37.79276
-122.3915,37.79303 -122.392,37.79344 -122.39233,37.79374
-122.39246,37.79387 -122.39257,37.79397 -122.39275,37.79414
-122.39303,37.7944 -122.39319,37.79455 -122.39335,37.79471
-122.39357,37.79494 -122.39374,37.79511 -122.39382,37.79518
-122.39407,37.79546 -122.39436,37.79579
</coordinates></LineString>
</subroute_geometry>
<start_location>
<location id="4"
longitude="-122.40459" latitude="37.74211"
house_number="99" street="FLOWER ST" city="SAN FRANCISCO"
state="CA" country="US"
driving_side="R"
postal_code="94124"
edge_id="23604155" percent="0.0"/>
</start_location>
<segment sequence="1"
instruction="Start out on Flower St (Going East)"
distance="0.0"
time="0.0">
<segment_edge_ids><edge_ids>
-23604155
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="2"
instruction="Turn LEFT onto Loomis St (Going Northeast)"
distance="0.1399739006534103"
time="0.341303030649821">
<segment_edge_ids><edge_ids>
23609757, 23609756
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="3"
instruction="Turn SLIGHT LEFT onto Barneveld Ave (Going North)"
distance="0.1780836365735976"
time="0.43422727584838866">
<segment_edge_ids><edge_ids>
23597607
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="4"
instruction="Turn SLIGHT LEFT onto Jerrold Ave (Going Northwest)"
distance="0.06884359716369064"
time="0.16786363919576008">
<segment_edge_ids><edge_ids>
127821131
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="5"
instruction="Stay STRAIGHT to go onto RAMP (Going Northwest)"
distance="0.04681538329577495"
time="0.11415150960286459">
<segment_edge_ids><edge_ids>
127821133
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="6"
instruction="Stay STRAIGHT to go onto Cesar Chavez (Going North)"
distance="0.1321568397517706"
time="0.22154166897137959">
<segment_edge_ids><edge_ids>
23621025, 830210057, 830210058, 120885622
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="7"
instruction="Turn LEFT onto Vermont St (Going North)"
distance="0.06916050646352936"
time="0.16863636970520018">
<segment_edge_ids><edge_ids>
754243248, 754243249
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="8"
instruction="Turn SLIGHT RIGHT onto 26th St (Going East)"
distance="0.036668115529443365"
time="0.08940908908843995">
<segment_edge_ids><edge_ids>
23595258
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="9"
instruction="Turn LEFT onto Kansas St (Going North)"
distance="0.27153420476451817"
time="0.6620909055074056">
<segment_edge_ids><edge_ids>
23608261, 23608260, 23608259
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="10"
instruction="Turn RIGHT onto 23rd St (Going East)"
distance="0.049897472846428766"
time="0.12166666984558105">
<segment_edge_ids><edge_ids>
23595010
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="11"
instruction="Turn LEFT onto Rhode Island St (Going North)"
distance="1.0569688657972653"
time="2.5772424399852754">
<segment_edge_ids><edge_ids>
933038005, 933038006, 933038001, 933038002,
23615271, 23615270, 23615269, 23615268,
23615267, 23615266, 23615265, 23615264,
23615263
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="12"
instruction="Turn LEFT onto Division St (Going West)"
distance="0.043919717429223945"
time="0.10709091226259868">
<segment_edge_ids><edge_ids>
-23602204, 829577422, 829577423
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="13"
instruction="Stay STRAIGHT to go onto RAMP (Going Northwest)"
distance="0.0055987076548075785"
time="0.013651515046755472">
<segment_edge_ids><edge_ids>
24552756
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="14"
instruction="Turn RIGHT onto Townsend St (Going Northeast)"
distance="1.192965882328057"
time="2.9088484485944113">
<segment_edge_ids><edge_ids>
916742043, 916742044, 916742041, 916742042,
916637669, 916637670, 916637671, 916637672,
23618959, 724706739, 724706740, 915025718,
915025719, 915025717, 23618956, 915025720,
915025721, 23618954, 916135978, 916135979,
916135980, 916135981, 916135982, 799424055,
23618951, 23618950, 799362044, 799362045,
724686775, -23841533
</edge_ids></segment_edge_ids>
</segment>
<segment sequence="15"
instruction="Turn LEFT onto The Embarcadero (Going North)"
distance="1.0898340975809355"
time="1.8269479304552079">
<segment_edge_ids><edge_ids>
807424014, 807424015, 733049265, 830425790,
830425791, 112011086, 799424653, 799424654,
724665449, 830416191, 830416192, 120886507,
120886508, 112011094, 112011097, 725001298,
830434313, 830434314, 724945050, 724945051,
830222369, 830222370, 23841522, 825450115,
825450116, 127810052, 724791171, 724791172,
799417573, 799417574, 724791173, 724791174
</edge_ids></segment_edge_ids>
</segment>
<end_location>
<location id="1"
longitude="-122.39436" latitude="37.79579"
house_number="" street="HERB CAEN WAY" city="SAN FRANCISCO"
state="CA" country="US"
driving_side="R" postal_code="94111"
edge_id="724791174"percent="1.0"/>
</end_location>
</subroute>
</route>
</route_response>
Example 13-5 shows a batched request for the a route between the same two points as an auto requesting the fastest route, an auto requesting the shortest route, a truck requesting the fastest route, and a truck requesting the shortest route. The locations in all the requests are the same, but they are specified in a mix of input addresses, pre-geocoded locations, and longitude/latitude points.
Example 13-5 Batched Route Request with Locations Specified as Addresses, Pre-geocoded Locations, and Longitude/Latitude Points
<?xml version="1.0" standalone="yes"?>
<batch_route_request id="1">
<route_request id="1"
route_preference="fastest"
road_preference="highway"
return_locations="true"
return_driving_directions="true"
vehicle_type="auto"
distance_unit="mile"
time_unit="minute"
>
<start_location>
<input_location id="1">
<input_address>
<us_form1
street="875 ALMA ST"
lastline="94301"/>
</input_address>
</input_location>
</start_location>
<end_location>
<input_location id="2">
<input_address>
<us_form1
street="660 BLOSSOM HILL RD"
lastline="95123" />
</input_address>
</input_location>
</end_location>
</route_request>
<route_request id="2"
route_preference="shortest"
road_preference="highway"
pre_geocoded_locations="true"
return_locations="true"
return_driving_directions="true"
vehicle_type="auto"
distance_unit="mile"
time_unit="minute"
>
<start_location>
<pre_geocoded_location id="1">
<edge_id>23694266</edge_id>
<percent>0.0</percent>
<side>R</side>
</pre_geocoded_location>
</start_location>
<end_location>
<pre_geocoded_location id="2">
<edge_id>812218080</edge_id>
<percent>0.0</percent>
<side>R</side>
</pre_geocoded_location>
</end_location>
</route_request>
<route_request id="3"
route_preference="fastest"
road_preference="highway"
return_locations="true"
return_driving_directions="true"
vehicle_type="truck"
truck_height="13.6"
truck_length="75"
truck_weight="30"
distance_unit="mile"
time_unit="minute"
>
<start_location>
<input_location id="1"
longitude="-122.15901"
latitude="37.4403" />
</start_location>
<end_location>
<input_location id="2"
longitude="-121.83459"
latitude="37.25125" />
</end_location>
</route_request>
<route_request id="4"
route_preference="shortest"
road_preference="highway"
pre_geocoded_locations="true"
vehicle_type="truck"
truck_height="13.6"
truck_length="75"
truck_weight="30"
return_driving_directions="true"
distance_unit="mile"
time_unit="minute"
>
<start_location>
<pre_geocoded_location id="1">
<edge_id>23694266</edge_id>
<percent>0.0</percent>
<side>R</side>
</pre_geocoded_location>
</start_location>
<end_location>
<pre_geocoded_location id="2">
<edge_id>812218080</edge_id>
<percent>0.0</percent>
<side>R</side>
</pre_geocoded_location>
</end_location>
</route_request>
</batch_route_request>
Example 13-6 shows the response to the request in Example 13-5. (The output is reformatted for readability.)
Example 13-6 Response for Batched Route Request with Locations Specified as Addresses, Pre-geocoded Locations, and Longitude/Latitude Points
<!-- Oracle Routeserver version 12.1.0.2.0 (data version 11.1.0.7.1) -->
<batch_route_response>
<route_response>
<route id="1" step_count="15"
distance="26.103862121729946" distance_unit="mile"
time="26.6184814453125" time_unit="minute"
start_location="1" end_location="2">
<start_location>
<location id="1"
longitude="-122.15901" latitude="37.4403"
house_number="898" street="ALMA ST" city="PALO ALTO"
state="CA" country="US"
driving_side="R"
postal_code="94301"
edge_id="23694266" percent="0.0"/>
</start_location>
<segment sequence="1"
instruction="Start out on Alma St (Going Southeast)"
distance="1.3587211956625542"
time="2.504421416918437"/>
<segment sequence="2"
instruction="Take RAMP toward Oregon Expwy"
distance="0.12862735113732848"
time="0.215624996026357"/>
<segment sequence="3"
instruction="Stay STRAIGHT togo onto Oregon Expy (Going Northeast)"
distance="1.3840054698278719"
time="2.3200833360354105"/>
<segment sequence="4"
instruction="Take RAMP toward San Jose"
distance="0.2647486517044605"
time="0.44381250540415446"/>
<segment sequence="5"
instruction="Stay STRAIGHT to go onto US-101 S (Going Southeast)"
distance="11.747225529883993"
time="10.16387637803952"/>
<segment sequence="6"
instruction="Take RAMP toward Guadalupe Pkwy"
distance="0.40232399596959373"
time="0.6744375069936116"/>
<segment sequence="7"
instruction="Stay STRAIGHT to go onto CA-87 S (Going Southeast)"
distance="2.6388802347934055"
time="2.2831989218791326"/>
<segment sequence="8"
instruction="Stay STRAIGHT to go onto CA-87 S (Going Southeast)"
distance="5.839967669586142"
time="5.052827918032805"/>
<segment sequence="9"
instruction="Stay STRAIGHT to go onto RAMP (Going South)"
distance="0.1527496425121632"
time="0.15757692654927571"/>
<segment sequence="10"
instruction="Continue on toward Gilroy"
distance="0.8405766344600814"
time="0.8671410039067269"/>
<segment sequence="11"
instruction="Stay STRAIGHT to go onto CA-85 S (Going East)"
distance="0.3956813619067624"
time="0.34234946966171265"/>
<segment sequence="12"
instruction="Take RAMP toward Blossom Hill Road"
distance="0.22891319287702547"
time="0.38373958468437197"/>
<segment sequence="13"
instruction="Turn LEFT onto Blossom Hill Rd (Going East)"
distance="0.49810476095097306"
time="0.8349999914566676"/>
<segment sequence="14"
instruction="Turn LEFT onto Snell Ave (Going North)"
distance="0.011060709151221367"
time="0.01854166587193807"/>
<segment sequence="15"
instruction="Turn LEFT onto Blossom Hill Rd (Going West)"
distance="0.21227241518009607"
time="0.35584374765555066"/>
<end_location>
<location id="2"
longitude="-121.83459" latitude="37.25125"
house_number="499" street="BLOSSOM HILL RD" city="SAN JOSE"
state="CA" country="US"
driving_side="R"
postal_code="95123"
edge_id="812218080" percent="0.0"/>
</end_location>
</route>
</route_response>
<route_response>
<route id="2" step_count="18"
distance="24.879477393121235" distance_unit="mile"
time="39.014546712239586" time_unit="minute"
start_location="1" end_location="2">
<start_location>
<location id="1"
longitude="" latitude=""
house_number="" street="" city=""
state="" country=""
driving_side="N"
postal_code=""
edge_id="23694266" percent="0.0"/>
</start_location>
<segment sequence="1"
instruction="Start out on Alma St (Going Southeast)"
distance="0.2592928618616754"
time="0.6322424242893855"/>
<segment sequence="2"
instruction="Turn LEFT onto Kingsley Ave (Going Northeast)"
distance="0.08879637204118493"
time="0.2165151596069336"/>
<segment sequence="3"
instruction="Turn SLIGHT RIGHT onto Embarcadero Rd (Going East)"
distance="0.6481327160471586"
time="1.5803636133670806"/>
<segment sequence="4"
instruction="Turn RIGHT onto Middlefield Rd (Going Southeast)"
distance="2.96746411421623"
time="7.235666685303053"/>
<segment sequence="5"
instruction="Stay STRAIGHT to go onto Old Middlefield Way (Going East)"
distance="0.8495432761786168"
time="1.789845637480418"/>
<segment sequence="6"
instruction="Stay STRAIGHT to go onto RAMP (Going East)"
distance="0.22642142849860966"
time="0.37956250508626305"/>
<segment sequence="7"
instruction="Stay STRAIGHT to go onto US-101 S (Going Southeast)"
distance="9.176685525492026"
time="7.939806487659613"/>
<segment sequence="8"
instruction="Take RAMP toward Brokaw Road"
distance="0.20942024511139234"
time="0.3510625004768372"/>
<segment sequence="9"
instruction="Stay STRAIGHT to go onto Old Bayshore Hwy (Going East)"
distance="0.1670850676627406"
time="0.2800937493642171"/>
<segment sequence="10"
instruction="Turn SLIGHT RIGHT onto N 1st St (Going Southeast)"
distance="1.9476604686858663"
time="3.9989981204271317"/>
<segment sequence="11"
instruction="Turn LEFT onto Jackson St (Going Northeast)"
distance="0.07099981550357595"
time="0.17312120993932087"/>
<segment sequence="12"
instruction="Turn RIGHT onto 2nd St (Going Southeast)"
distance="2.3224258991749434"
time="5.6628484646479285"/>
<segment sequence="13"
instruction="Stay STRAIGHT to go onto S 1st St (Going Southeast)"
distance="0.18884608205270126"
time="0.31657291650772096"/>
<segment sequence="14"
instruction="Stay STRAIGHT to go onto Monterey Rd (Going Southeast)"
distance="3.887951286200716"
time="5.287046383817991"/>
<segment sequence="15"
instruction="Turn SLIGHT RIGHT onto RAMP (Going South)"
distance="0.0414465897894999"
time="0.1010606050491333"/>
<segment sequence="16"
instruction="Turn RIGHT onto Skyway Dr (Going Southwest)"
distance="0.34504443027423093"
time="0.5849081456661225"/>
<segment sequence="17"
instruction="Turn LEFT onto Snell Ave (Going East)"
distance="1.279357478030909"
time="2.1446562389532726"/>
<segment sequence="18"
instruction="Turn RIGHT onto Blossom Hill Rd (Going West)"
distance="0.20292052293456395"
time="0.34016666412353513"/>
<end_location>
<location id="2"
longitude="" latitude=""
house_number="" street="" city=""
state="" country=""
driving_side="N"
postal_code=""
edge_id="812218080" percent="0.0"/>
</end_location>
</route>
</route_response>
<route_response>
<route id="3" step_count="14"
distance="25.906590792580626" distance_unit="mile"
time="29.140561930338542" time_unit="minute"
start_location="1" end_location="2">
<start_location>
<location id="1"
longitude="-122.15901" latitude="37.4403"
house_number="900" street="ALMA ST" city="PALO ALTO"
state="CA" country="US"
driving_side="R"
postal_code="94301"
edge_id="23694267" percent="1.0"/>
</start_location>
<segment sequence="1"
instruction="Start out on Alma St (Going Northwest)"
distance="0.0"
time="0.0"/>
<segment sequence="2"
instruction="Turn RIGHT onto Channing Ave(Going Northeast)"
distance="2.1771018293093087"
time="5.30849996805191"/>
<segment sequence="3"
instruction="Turn RIGHT onto W Bayshore Rd (Going Southwest)"
distance="0.12998197519156232"
time="0.31693938573201497"/>
<segment sequence="4"
instruction="Turn LEFT onto Embarcadero Rd (Going Northeast)"
distance="0.006878766976215882"
time="0.016772727171579998"/>
<segment sequence="5"
instruction="Take RAMP toward San Jose"
distance="0.4222705568230516"
time="0.707875007390976"/>
<segment sequence="6"
instruction="Stay STRAIGHT to go onto US-101 S (Going Southeast)"
distance="11.747225529883993"
time="10.16387637803952"/>
<segment sequence="7"
instruction="Take RAMP toward Guadalupe Pkwy"
distance="0.40232399596959373"
time="0.6744375069936116"/>
<segment sequence="8"
instruction="Stay STRAIGHT to go onto CA-87 S (Going Southeast)"
distance="2.6388802347934055"
time="2.2831989218791326"/>
<segment sequence="9"
instruction="Stay STRAIGHT to go onto CA-87 S (Going Southeast)"
distance="4.708519202974121"
time="4.073881677289804"/>
<segment sequence="10"
instruction="Take EXIT 1D toward Capitol Expwy Auto Mall"
distance="0.23860684637032842"
time="0.3948361724615097"/>
<segment sequence="11"
instruction="Turn LEFT onto W Capitol Expy (Going East)"
distance="1.2198347095111897"
time="1.4871818164984385"/>
<segment sequence="12"
instruction="Turn SLIGHT RIGHT onto RAMP (Going East)"
distance="0.029621573459855412"
time="0.049656248092651366"/>
<segment sequence="13"
instruction="Turn SLIGHT RIGHT onto Snell Ave (Going Southeast)"
distance="1.9824209209108623"
time="3.3232395708560944"/>
<segment sequence="14"
instruction="Turn RIGHT onto Blossom Hill Rd (Going West)"
distance="0.20292052293456395"
time="0.34016666412353513"/>
<end_location>
<location id="2"
longitude="-121.83459" latitude="37.25125"
house_number="499" street="BLOSSOM HILL RD" city="SAN JOSE"
state="CA" country="US"
driving_side="R"
postal_code="95123"
edge_id="812218080" percent="0.0"/>
</end_location>
</route>
</route_response>
<route_response>
<route id="4" step_count="28"
distance="25.43010499518424" distance_unit="mile"
time="41.812373860677084" time_unit="minute"
start_location="1" end_location="2">
<segment sequence="1"
instruction="Start out on Alma St (Going Southeast)"
distance="2.512197865475656"
time="4.438056838512421"/>
<segment sequence="2"
instruction="Turn RIGHT onto W Meadow Dr (Going Southwest)"
distance="0.259249367249032"
time="0.6321363727251689"/>
<segment sequence="3"
instruction="Turn LEFT onto El Camino Way (Going Southeast)"
distance="0.19732181646496028"
time="0.48113636175791424"/>
<segment sequence="4"
instruction="Stay STRAIGHT to go onto RAMP (Going Southwest)"
distance="0.009935996875112263"
time="0.02422727147738139"/>
<segment sequence="5"
instruction="Turn LEFT onto El Camino Real (Going Southeast)"
distance="0.7259305251035061"
time="1.2169166604677837"/>
<segment sequence="6"
instruction="Stay STRAIGHT to go onto El Camino Real (Going Southeast)"
distance="10.18052570327847"
time="17.06616668154796"/>
<segment sequence="7"
instruction="Turn RIGHT onto Madison St (Going Southeast)"
distance="0.1341639244777912"
time="0.32713637351989744"/>
<segment sequence="8"
instruction="Turn LEFT onto Harrison St (Going East)"
distance="0.06893059350020074"
time="0.16807576020558676"/>
<segment sequence="9"
instruction="Turn RIGHT onto Monroe St (Going Southeast)"
distance="0.0705648403396469"
time="0.1720606009165446"/>
<segment sequence="10"
instruction="Turn LEFT onto Fremont St (Going East)"
distance="0.07203753203577691"
time="0.17565151850382488"/>
<segment sequence="11"
instruction="Turn RIGHT onto Jackson St (Going Southeast)"
distance="0.2098303612161659"
time="0.5116363684336345"/>
<segment sequence="12"
instruction="Turn LEFT onto Homestead Rd (Going East)"
distance="0.13950164667868017"
time="0.3401515007019043"/>
<segment sequence="13"
instruction="Turn RIGHT onto Washington St (Going Southeast)"
distance="0.14307462872056173"
time="0.3488636334737142"/>
<segment sequence="14"
instruction="Turn LEFT onto Santa Clara St (Going East)"
distance="0.06947120055412777"
time="0.16939393679300943"/>
<segment sequence="15"
instruction="Turn RIGHT onto Lafayette St (Going Southeast)"
distance="0.06759460559205673"
time="0.16481818358103434"/>
<segment sequence="16"
instruction="Turn LEFT onto Market St (Going East)"
distance="0.17456658015544202"
time="0.4256515165170034"/>
<segment sequence="17"
instruction="Turn RIGHT onto The Alameda (Going Southeast)"
distance="2.317572876182314"
time="4.207776539524397"/>
<segment sequence="18"
instruction="Stay STRAIGHT to go onto W Santa Clara St (Going East)"
distance="0.03303921082684557"
time="0.05538541873296102"/>
<segment sequence="19"
instruction="Stay STRAIGHT to go onto CA-82 (Going East)"
distance="0.05555210434715647"
time="0.09312500158945719"/>
<segment sequence="20"
instruction="Stay STRAIGHT to go onto W Santa Clara St (Going East)"
distance="0.17006772690279195"
time="0.33163256843884786"/>
<segment sequence="21"
instruction="Turn RIGHT onto Delmas Ave (Going Southeast)"
distance="0.49640216162493195"
time="1.2103939274946849"/>
<segment sequence="22"
instruction="Take CA-87 RAMP toward Guadalupe Pky"
distance="0.1178586975602079"
time="0.197572918732961"/>
<segment sequence="23"
instruction="Stay STRAIGHT to go onto CA-87 S (Going Southeast)"
distance="3.628403629205081"
time="3.139349430302779"/>
<segment sequence="24"
instruction="Take EXIT 1D toward Capitol Expwy Auto Mall"
distance="0.23860684637032842"
time="0.3948361724615097"/>
<segment sequence="25"
instruction="Turn LEFT onto W Capitol Expy (Going East)"
distance="0.9895544609762458"
time="1.2064318120479585"/>
<segment sequence="26"
instruction="Turn SLIGHT RIGHT onto Rosenbaum Ave (Going East)"
distance="0.49535202237807563"
time="1.2078333616256713"/>
<segment sequence="27"
instruction="Turn RIGHT onto Snell Ave (Going Southeast)"
distance="1.649872606747162"
time="2.7657708187898"/>
<segment sequence="28"
instruction="Turn RIGHT onto Blossom Hill Rd (Going West)"
distance="0.20292052293456395"
time="0.34016666412353513"/>
</route>
</route_response>
</batch_route_response>
13.3.2 Route Request XML Schema Definition
The following is the XML Schema Definition for a route request. The main elements and attributes of the Schema Definition are explained in sections that follow.
<!-- Schema definition for an XML Route Request to the routing engine -->
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema
elementFormDefault="qualified">
<xsd:include schemaLocation "geocoder_request.xsd" />
<xsd:simpleType name="positiveDecimal">
<xsd:restriction base="xsd:decimal">
<xsd:minExclusive value="0"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="distanceUnit">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="mile"/>
<xsd:enumeration value="km"/>
<xsd:enumeration value="kilometer"/>
<xsd:enumeration value="meter"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="timeUnit">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="minute"/>
<xsd:enumeration value="hour"/>
<xsd:enumeration value="second"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="unitType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="us"/>
<xsd:enumeration value="metric"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="edgePercentage">
<xsd:restriction base="decimal">
<xsd:minInclusive value="0.0"/>
<xsd:maxInclusive value="1.0"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="roadPreference">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="highway"/>
<xsd:enumeration value="local"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="routePreference">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="shortest"/>
<xsd:enumeration value="fastest"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="truckType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="delivery"/>
<xsd:enumeration value="public"/>
<xsd:enumeration value="resident"/>
<xsd:enumeration value="trailer"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="vehicleType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="auto"/>
<xsd:enumeration value="truck"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:complexType name="pregeocodedType">
<xsd:all>
<xsd:element name="edge_id" type="xsd:long" />
<xsd:element name="percent" type="edgePercentage"/>
<xsd:element name="side">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="L"/>
<xsd:enumeration value="R"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:all>
</xsd:complexType>
<xsd:complexType name="routerInputLocation">
<xsd:choice>
<xsd:element name="router_input_location" type="input_locationType"/>
<xsd:element name="router_pregeocoded_location" type="pregeocodedType"/>
</xsd:choice>
</xsd:complexType>
<xsd:element name="batch_route_request" type="batchRouteRequest" />
<xsd:complexType name="batchRouteRequest">
<xsd:sequence>
<xsd:element name="route_request" type="routeRequest"
minOccurs="1" maxOccurs="unbounded"/>
</xsd:sequence>
<xsd:attribute name="id" type="xsd:nonNegativeInteger" use="required"/>
</xsd:complexType>
<xsd:element name="route_request" type="routeRequest" />
<xsd:complexType name="routeRequest">
<xsd:sequence>
<xsd:element name="start_location" type="routerInputLocation"
minOccurs="0" maxOccurs="1"/>
<xsd:element name="location" type="routerInputLocation"
minOccurs="0" maxOccurs="unbounded"/>
<xsd:element name="end_location" type="routerInputLocation"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:attribute name="id" type="xsd:nonNegativeInteger" use="required"/>
<xsd:attribute name="pre_geocoded_locations" type="xsd:boolean"
use="optional"/>
<xsd:attribute name="route_preference" type="routePreference"
use="optional"/>
<xsd:attribute name="road_preference" type="roadPreference"
use="optional"/>
<xsd:attribute name="optimize_route" type="xsd:boolean" use="optional"/>
<xsd:attribute name="route_type" use="optional">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="open"/>
<xsd:enumeration value="closed"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="driving_directions_detail" use="optional">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="medium"/>
<xsd:enumeration value="high"/>
<xsd:enumeration value="low"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="language" use="optional">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="English"/>
<xsd:enumeration value="French"/>
<xsd:enumeration value="German"/>
<xsd:enumeration value="Italian"/>
<xsd:enumeration value="Spanish"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="distance_unit" type="distanceUnit" use="optional"/>
<xsd:attribute name="length_unit" type="unitType" use="optional"/>
<xsd:attribute name="time_unit" type="timeUnit" use="optional"/>
<xsd:attribute name="weight_unit" type="unitType" use="optional"/>
<xsd:attribute name="return_locations" type="xsd:boolean"
use="optional"/>
<xsd:attribute name="return_subroutes" type="xsd:boolean"
use="optional"/>
<xsd:attribute name="return_driving_directions" type="xsd:boolean"
use="optional"/>
<xsd:attribute name="return_hierarchical_directions" type="xsd:boolean"
use="optional"/>
<xsd:attribute name="return_route_geometry" type="xsd:boolean"
use="optional"/>
<xsd:attribute name="return_subroute_geometry" type="xsd:boolean"
use="optional"/>
<xsd:attribute name="return_segment_geometry" type="xsd:boolean"
use="optional"/>
<xsd:attribute name="return_detailed_geometry" type="xsd:boolean"
use="optional"/>
<xsd:attribute name="return_route_edge_ids" type="xsd:boolean"
use="optional"/>
<xsd:attribute name="return_subroute_edge_ids" type="xsd:boolean"
use="optional"/>
<xsd:attribute name="return_segment_edge_ids" type="xsd:boolean"
use="optional"/>
<xsd:attribute name="vehicle_type" type="vehicleType" use="optional"/>
<xsd:attribute name="truck_type" type="truckType" use="optional"/>
<xsd:attribute name="truck_height" type="positiveDecimal"
use="optional"/>
<xsd:attribute name="truck_length" type="positiveDecimal"
use="optional"/>
<xsd:attribute name="truck_per_axle_weight" type="positiveDecimal"
use="optional"/>
<xsd:attribute name="truck_weight" type="positiveDecimal"
use="optional"/>
<xsd:attribute name="truck_width" type="positiveDecimal" use="optional"/>
</xsd:complexType>
</xsd:schema>
13.3.2.1 route_request Element
The <route_request> element has the following definition:
<xsd:element name="route_request" type="routeRequest" />
The root element of a route request is always named route_request.
The <start_location> child element specifies the start location for the route, as an address specification, a geocoded address, or longitude/latitude coordinates. Depending on the route request, there can be 0 or 1 <start_location> elements. A simple route request requires a <start_location> element, whereas an open tour TSP request does not.
The <location> child element specifies a location for a segment, as an address specification, a geocoded address, or longitude/latitude coordinates. In a simple route request there are no <location> elements; if there are one or more <location> elements, it is a multi-address route.
The <end_location> child element specifies the end location for the route, as an address specification, a geocoded address, or longitude/latitude coordinates. Depending on the route request, there can be 0 or 1 <end_location> elements. A simple route request requires an <end_location> element, whereas a closed tour multi-address or TSP tour must not contain an <end_location> element.
In a route request:
-
If
<start_location>is an address specification or longitude/latitude coordinates, each<end_location>and<location> element can be either an address specification or longitude/latitude coordinate; however, it cannot be a pre-geocoded address. -
If
<start_location>is a pre-geocoded address,<end_location>and any<location>specifications must also be pre-geocoded addresses.
In a batched route request, each of the individual route requests must follow the preceding rules. However, within the batch, because the individual requests are independent, you can mix address, pre-geocoded, and longitude/latitude locations, as long as they are consistent within an individual request.
13.3.2.2 route_request Attributes
The root element <route_request> has a number of attributes, most of them optional. The attributes are defined as follows.
vendor is an optional attribute whose default value identifies the routing provider as Oracle.
id is a required attribute that specifies an identification number to be associated with the request.
route_preference is an optional attribute that specifies whether you want the route with the lowest estimated driving time (FASTEST) or the route with the shortest driving distance (SHORTEST, the default).
road_preference is an optional attribute that allows the routing process to have a preference for highways (HIGHWAY, the default) or local roads (LOCAL).
return_driving_directions is an optional attribute that specifies whether driving directions for the route are returned. TRUE returns driving directions; FALSE (the default) does not return driving directions.
return_hierarchical_driving_directions is an optional attribute that specifies whether driving directions for the route are returned in an expandable and collapsible hierarchy. TRUE returns driving directions in an expandable and collapsible hierarchy; FALSE (the default) returns driving directions in a list with no hierarchy.
return_locations is an optional attribute that specifies whether to return the geocode information for all the locations in the route. TRUE returns the geocode information; FALSE (the default) does not.
return_subroutes is an optional attribute that specifies whether to return the subroutes in a multi-address route. TRUE (the default for multi-address routes) returns subroutes; FALSE does not return subroutes. (This attributed is ignored for simple routes.)
return_route_geometry is an optional attribute that specifies whether to return the coordinates of the line string that represents the route. TRUE returns the coordinates; FALSE (the default) does not return the coordinates.
return_subroute_geometry is an optional attribute that specifies whether to return the coordinates of the line strings that represent the subroutes within a route. TRUE returns the coordinates; FALSE (the default for multi-address routes) does not return the coordinates. (This attributed is ignored for simple routes.)
return_segment_geometry is an optional attribute that specifies whether to return the coordinates of the line strings that represent maneuvers of a route. TRUE returns the coordinates; FALSE (the default) does not return the coordinates. If return_segment_geometry is TRUE, driving directions for the route are returned regardless of the value of the return_driving_directions attribute.
return_detailed_geometry is an optional attribute that indicates the level of detail to be included in returned geometries. TRUE (the default) returns detailed geometries; FALSE returns generalized geometries (usually with fewer coordinates).
return_route_edge_ids is an optional attribute that specifies whether to return the edge ID values of the edges in the route. TRUE returns the edge ID values; FALSE (the default) does not return the edge ID values.
return_subroute_edge_ids is an optional attribute that specifies whether to return the edge ID values of the edges in the subroutes. TRUE returns the edge ID values; FALSE (the default for multi-address routes) does not return the edge ID values. (This attributed is ignored for simple routes.)
return_segment_edge_ids is an optional attribute that specifies whether to return the edge ID values of the edges of all maneuvers in the route. TRUE returns the edge ID values; FALSE (the default) does not return the edge ID values. If return_segment_edge_ids is TRUE, driving directions for the route are returned regardless of the value of the return_driving_directions attribute.
language is an optional attribute that overrides the default language used to generate the driving directions. The default language for is set in the web.xml file; you can use this attribute to override the default on a per-request basis. The following attribute values are supported: ENGLISH, FRENCH, GERMAN, ITALIAN, and SPANISH.
distance_unit is an optional attribute that specifies the unit of measure for distance values that are returned: KILOMETER or KM for kilometer, MILE (the default) for mile, or METER for meter.
length_unit is an optional attribute that specifies the length measurement system used for input length values: US for feet (the default) or METRIC for meters. This attribute is used to specify the height, length, and/or width of trucks.
time_unit is an optional attribute that specifies the unit for time values that are returned: HOUR for hour, MINUTE (the default) for minute, or SECOND for second.
weight_unit is an optional attribute that specifies the weight measurement system used for input weight values: US for tons (the default) or METRIC for metric tons. This attribute is used to specify the weight of trucks.
pre_geocoded_locations is an optional attribute that indicates how locations are specified. TRUE means that both are previously geocoded locations specified using the <pre_geocoded_location> element; FALSE (the default) means that both are addresses or longitude/latitude pairs specified using the <input_location> element.
driving_directions_detail is an optional attribute that influences the level of detail and the number of separate steps in driving instructions. The available values are HIGH (most details and steps), MEDIUM (the default), and LOW (fewest details and steps). For example, LOW might treat a segment as a single step even if it involves slight maneuvers to the right or left. The effect of a value for this attribute on the length of returned driving directions will vary, depending on the exact names of elements and maneuvers. This attribute is ignored if you do not specify TRUE for return_driving_directions or return_hierarchical_driving_directions.
optimize_route is an optional attribute that specifies whether a multi-address route request should have its unfixed locations reordered to optimize the overall route. TRUE reorders the locations to optimize the overall route (Traveling Salesperson); FALSE (the default) does not reorder the locations (multi-address). Since multi-address requests are not optimized, all locations are returned in the order specified in the request. In multi-address and TSP open tour requests, the START_LOCATION and END_LOCATION are optional. If they are specified they are fixed locations and are not subject to reordering in TSP requests. In multi-address and TSP requests, one or more intermediate locations (LOCATION) must be specified, and they are unfixed locations and are subject to reordering in a TSP request.
route_type is an optional attribute that specifies whether a multi-address route is an OPEN (the default) or CLOSED tour. An open tour routes from the START_LOCATION, or first LOCATION, to the END_LOCATION, or last LOCATION. In a closed tour the START_LOCATION is required and is used as both the starting and ending location. If an END_LOCATION is specified for a closed tour, an exception is raised.
vehicle_type is an optional attribute that specifies that the type of vehicle is an AUTO (the default) or a TRUCK. For the truck description subattributes to be used, the vehicle type must be set to TRUCK; if the vehicle type is AUTO, these subattributes are ignored.
truck_type is an optional attribute and a subattribute to vehicle_type being set to TRUCK. This attribute describes a specific type of truck, allowing it to potentially override more generalized truck rules. The following attribute values are supported: DELIVERY, PUBLIC, RESIDENT, and TRAILER. The DELIVERY, PUBLIC, and RESIDENT truck types provide exceptions to truck rules for trucks of these types. Garbage and public utility trucks are examples of PUBLIC trucks. The RESIDENT truck type describes trucks that are local to a neighborhood. The TRAILER truck type describes extra restrictions that semi-trailer trucks are subject to are that the other trucks are not.
truck_height is an optional attribute and a subattribute to vehicle_type being set to TRUCK. This attribute specifies, as a floating-point number, the height of a truck in length_units. This height is used to check against any height restrictions that may exist on an edge being considered as part of a route.
truck_length is an optional attribute and a subattribute to vehicle_type being set to TRUCK. This attribute specifies, as a floating-point number, the length of a truck in length_units. This length is used to check against any length restrictions that may exist on an edge being considered as part of a route.
truck_per_axle_weight is an optional attribute and a subattribute to vehicle_type being set to TRUCK. This attribute specifies, as a floating-point number, the per axle weight of a truck in weight_units. This weight is used to check against any per axle weight restrictions that may exist on an edge being considered as part of a route.
truck_weight is an optional attribute and a subattribute to vehicle_type being set to TRUCK. This attribute specifies, as a floating-point number, the weight of a truck in weight_units. This weight is used to check against weight restrictions that may exist on an edge being considered as part of a route.
truck_width is an optional attribute and a subattribute to vehicle_type being set to TRUCK. This attribute specifies, as a floating-point number, the width of a truck in length_units. This width is used to check against width restrictions that may exist on an edge being considered as part of a route.
13.3.2.3 input_location Element
The <input_location> element specifies an address in a format that satisfies the Oracle Spatial and Graph geocoding request XML Schema, which is described in Section 11.7.2. You can specify the input location using either a longitude/latitude pair or the <input_address> element. Example 13-1 in Section 13.3.1 shows the start and end addresses specified using the <input_location> element and its child element <input_address>.
To use the <input_location> element, you must ensure that the value of the pre_geocoded_locations attribute is FALSE (the default) in the <route_request> element. You can use longitude/latitude pairs and <input_address> elements together in a request.
13.3.2.4 pre_geocoded_location Element
The <pre_geocoded_location> element specifies a geocoded location in terms of how far along a street (an edge) the address is and on which side of the street. Example 13-5 in Section 13.3.1 shows the start and end addresses specified using the <pre_geocoded_location> element.
To use the <pre_geocoded_location> element, you must specify pre_geocoded_locations="TRUE" in the <route_request> element, and you must use the <pre_geocoded_location> element to specify all locations.
13.3.3 Route Response XML Schema Definition
The following is the XML Schema definition for a route response:
<?xml version="1.0" encoding="UTF-8"?>
<!-- XML Schema definition for Route Response from the routing engine -->
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:gml="http://www.opengis.net/gml"
elementFormDefault="qualified">
<xsd:simpleType name="nonNegativeDecimal">
<xsd:restriction base="xsd:decimal">
<xsd:minInclusive value="0"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="positiveDecimal">
<xsd:restriction base="xsd:decimal">
<xsd:minExclusive value="0"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="distanceUnit">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="mile"/>
<xsd:enumeration value="km"/>
<xsd:enumeration value="kilometer"/>
<xsd:enumeration value="meter"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="timeUnit">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="minute"/>
<xsd:enumeration value="hour"/>
<xsd:enumeration value="second"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="edgeIdElement">
<xsd:restriction base="xsd:string">
<xsd:pattern value="[-0-9,]+"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="edgeIdList">
<xsd:list itemType="edgeIdElement"/>
</xsd:simpleType>
<xsd:simpleType name="emptyString">
<xsd:restriction base="string">
<xsd:maxLength value="0"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="latitude">
<xsd:restriction base="decimal">
<xsd:minInclusive value="-90.0">
<xsd:maxInclusive value="90.0">
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="longitude">
<xsd:restriction base="decimal">
<xsd:minInclusive value="-180.0">
<xsd:maxInclusive value="180.0">
</xsd:restriction>
</xsd:simpleType>
<xsd:complexType name="geometry">
<xsd:sequence>
<xsd:element ref="gml:LineString"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="outputLocation">
<xsd:attribute name="id" type="xsd:positiveInteger" use="required"/>
<xsd:attribute name="longitude" use="required">
<xsd:simpleType>
<xsd:union memberTypes="longitude emptyString" />
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="latitude" use="required">
<xsd:simpleType>
<xsd:union memberTypes="latitude emptyString" />
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="house_number" type="xsd:string" use="required"/>
<xsd:attribute name="street" type="xsd:string" use="required"/>
<xsd:attribute name="city" type="xsd:string" use="required"/>
<xsd:attribute name="state" type="xsd:string" use="required"/>
<xsd:attribute name="country" type="xsd:string" use="required"/>
<xsd:attribute name="driving_side" use="required">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="L"/>
<xsd:enumeration value="N"/>
<xsd:enumeration value="R"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="postal_code" type="xsd:string" use="required"/>
<xsd:attribute name="edge_id" type="xsd:long" use="required"/>
<xsd:attribute name="percent" type="edgePercentage" use="required"/>
</xsd:complexType>
<xsd:complexType name="segmentType">
<xsd:sequence>
<xsd:element name="segment_geometry" type="geometry"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="segment_edge_ids" type="edgeIdList"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:attribute name="sequence" type="xsd:positiveInteger" use="required"/>
<xsd:attribute name="instruction" type="xsd:string" use="required"/>
<xsd:attribute name="distance" type="nonNegativeDecimal" use="required"/>
<xsd:attribute name="time" type="nonNegativeDecimal" use="required"/>
</xsd:complexType
<xsd:element name="route_response">
<xsd:sequence>
<xsd:element name="route" minOccurs="1" maxOccurs="1">
<xsd:simpleType>
<xsd:union memberTypes="multiRouteType routeType"/>
</xsd:simpleType>
</xsd:element>
</sequence>
</xsd:element>
<xsd:complexType name="multiRouteType">
<xsd:sequence>
<xsd:element name="route_geometry" type="geometry"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="route_edge_ids" type="edgeIdList"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="start_location" type="outputLocation"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="end_location" type="outputLocation"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="subroute" minOccurs="1" maxOccurs="unbounded"/>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="subroute_geometry" type="geometry"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="subroute_edge_ids" type="edgeIdList"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="start_location" type="outputLocation"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="segment" type="segmentType"
minOccurs="0" maxOccurs="unbounded"/>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="end_location" type="outputLocation"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:attribute name="id" type="xsd:nonNegativeInteger"
use="required"/>
<xsd:attribute name="step_count" type="xsd:nonNegativeInteger"
use="required"/>
<xsd:attribute name="distance" type="nonNegativeDecimal"
use="required"/>
<xsd:attribute name="distance_unit" type="distanceUnit"
use="required"/>
<xsd:attribute name="time" type="nonNegativeDecimal" use="required"/>
<xsd:attribute name="time_unit" type="timeUnit" use="required"/>
<xsd:attribute name="start_location" type="xsd:positiveInteger"
use="required"/>
<xsd:attribute name="end_location" type="xsd:positiveInteger"
use="required"/>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="routeType">
<xsd:sequence>
<xsd:element name="route_geometry" type="geometry"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="route_edge_ids" type="edgeIdList"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="start_location" type="outputLocation"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="segment" type="segmentType"
minOccurs="0" maxOccurs="unbounded"/>
</xsd:sequence>
<xsd:sequence>
<xsd:element name="end_location" type="outputLocation"
minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:attribute name="id" type="xsd:nonNegativeInteger" use="required"/>
<xsd:attribute name="step_count" type="xsd:nonNegativeInteger"
use="required"/>
<xsd:attribute name="distance" type="nonNegativeDecimal" use="required"/>
<xsd:attribute name="distance_unit" type="distanceUnit" use="required"/>
<xsd:attribute name="time" type="nonNegativeDecimal" use="required"/>
<xsd:attribute name="time_unit" type="timeUnit" use="required"/>
<xsd:attribute name="start_location" type="xsd:positiveInteger"
use="required"/>
<xsd:attribute name="end_location" type="xsd:positiveInteger"
use="required"/>
</xsd:complexType>
</xsd:schema>
13.3.4 Batch Mode Route Request and Response Examples
This section contains XML examples of batch mode route requests and the responses generated by those requests. One request uses specified addresses, and the other request uses previously geocoded locations. For reference information about the available elements and attributes, see Section 13.3.5 for requests and Section 13.3.6 for responses.
Example 13-7 shows a batch route request using specified addresses. The request is for the fastest routes, preferably using highways, between an office in Waltham, Massachusetts and three end locations (an Oracle office in Nashua, New Hampshire; the town offices in Concord, Massachusetts; and Boston City Hall), using miles for distances and minutes for times. The request calls for the returned routes to be sorted by distance between the start and end location, and for no routes over 35 miles to be returned.
Example 13-7 Batch Route Request with Specified Addresses
<?xml version="1.0" standalone="yes"?>
<batch_route_request
id="8"
route_preference="fastest"
road_preference="highway"
return_driving_directions="false"
sort_by_distance = "true"
cutoff_distance="35"
distance_unit="mile"
time_unit="minute">
<start_location>
<input_location id="1">
<input_address>
<us_form1
street="399 Winter St"
lastline="Waltham, MA" />
</input_address>
</input_location>
</start_location>
<end_location>
<input_location id="10">
<input_address>
<us_form1
street="1 Oracle Dr"
lastline="Nashua, NH" />
</input_address>
</input_location>
</end_location>
<end_location>
<input_location id="11">
<input_address>
<us_form1
street="2 Monument Sq"
lastline="Concord, MA" />
</input_address>
</input_location>
</end_location>
<end_location>
<input_location id="12">
<input_address>
<us_form1
street="1 City Hall Plaza"
lastline="Boston, MA" />
</input_address>
</input_location>
</end_location>
</batch_route_request>
Example 13-8 shows the response generated by the request in Example 13-7. (The output is reformatted for readability.) Note that because sort_by_distance = "true" was specified in the request, the routes returned are not in order by route IDs (11, 12, 10), but instead by route distances.
Example 13-8 Batch Route Response with Specified Addresses
<!-- Oracle Routeserver version 12.1.0.2.0 (data version 11.1.0.7.1) -->
<batch_route_response id="8">
<route id="11" step_count="0"
distance="7.796855460254458" distance_unit="mile"
time="11.343014526367188" time_unit="minute"/>
<route id="12" step_count="0"
distance="17.201688768020258" distance_unit="mile"
time="21.577909342447917" time_unit="minute"/>
<route id="10" step_count="0"
distance="28.628700657894736" distance_unit="mile"
time="31.133371988932293" time_unit="minute"/>
</batch_route_response>
Example 13-9 shows a batch route request using previously geocoded locations. The request is for the fastest routes, preferably using highways, between one location and three other locations, using miles for distances and minutes for times. The request calls for the returned routes to be sorted by distance between the start and end location, and for no routes over 28.5 miles to be returned.
Example 13-9 Batch Route Request with Previously Geocoded Locations
<?xml version="1.0" standalone="yes"?>
<batch_route_request id="8"
route_preference="fastest"
road_preference="highway"
return_driving_directions="false"
distance_unit="mile"
time_unit="minute"
pre_geocoded_locations="true"
cutoff_distance="28.5"
sort_by_distance="true">
<start_location>
<pre_geocoded_location id="1">
<edge_id>906810462</edge_id>
<percent>0.0</percent>
<side>R</side>
</pre_geocoded_location>
</start_location>
<end_location>
<pre_geocoded_location id="11">
<edge_id>22325991</edge_id>
<percent>0.0</percent>
<side>R</side>
</pre_geocoded_location>
</end_location>
<end_location>
<pre_geocoded_location id="12">
<edge_id>22027853</edge_id>
<percent>0.0</percent>
<side>R</side>
</pre_geocoded_location>
</end_location>
<end_location>
<pre_geocoded_location id="13">
<edge_id>31102851</edge_id>
<percent>0.0</percent>
<side>R</side>
</pre_geocoded_location>
</end_location>
</batch_route_request>
Example 13-10 shows the response to the request in Example 13-9. Only two routes are returned, because the third route is longer than the specified cutoff distance of 28.5 miles. (The output is reformatted for readability.)
Example 13-10 Batch Route Response with Previously Geocoded Locations
<!-- Oracle Routeserver version 12.1.0.2.0 (data version 11.1.0.7.1) -->
<batch_route_response id="8">
<route id="11" step_count="0"
distance="7.796855460254458" distance_unit="mile"
time="11.343014526367188" time_unit="minute"/>
<route id="12" step_count="0"
distance="17.201688768020258" distance_unit="mile"
time="21.577909342447917" time_unit="minute"/>
</batch_route_response>
13.3.5 Batch Route Request XML Schema Definition
The following is the XML Schema definition for a batch route request. The main elements and attributes of the XML Schema Definition are explained in sections that follow.
<?xml version="1.0" encoding="UTF-8"?>
<!-- XML Schema definition for a Batch Route Request to the routing engine ->
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
elementFormDefault="qualified">
<xsd:include schemaLocation "geocoder_request.xsd" />
<xsd:simpleType name="positiveDecimal">
<xsd:restriction base="xsd:decimal">
<xsd:minExclusive value="0"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="distanceUnit">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="mile"/>
<xsd:enumeration value="km"/>
<xsd:enumeration value="kilometer"/>
<xsd:enumeration value="meter"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="timeUnit">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="minute"/>
<xsd:enumeration value="hour"/>
<xsd:enumeration value="second"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="unitType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="us"/>
<xsd:enumeration value="metric"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="roadPreference">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="highway"/>
<xsd:enumeration value="local"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="routePreference">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="shortest"/>
<xsd:enumeration value="fastest"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="truckType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="delivery"/>
<xsd:enumeration value="public"/>
<xsd:enumeration value="resident"/>
<xsd:enumeration value="trailer"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="vehicleType">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="auto"/>
<xsd:enumeration value="truck"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:complexType name="routerInputLocation">
<xsd:choice>
<xsd:element name="router_input_location" type="input_locationType"/>
<xsd:element name="router_pregeocoded_location" type="pregeocodedType"/>
</xsd:choice>
</xsd:complexType>
<xsd:element name="batch_route_request" type="batch_route_requestType" />
<xsd:complexType name="batch_route_requestType">
<xsd:sequence>
<xsd:element name="start_location" type="routerInputLocation"
minOccurs="1" maxOccurs="1"/>
<xsd:element name="end_location" type="routerInputLocation"
minOccurs="1" maxOccurs="unbounded"/>
</xsd:sequence>
<xsd:attribute name="id" type="xsd:nonNegativeInteger" use="required"/>
<xsd:attribute name="pre_geocoded_locations" type="xsd:boolean"
use="optional"/>
<xsd:attribute name="route_preference" type="routePreference"
use="optional"/>
<xsd:attribute name="road_preference" type="roadPreference"
use="optional"/>
<xsd:attribute name="distance_unit" type="distanceUnit" use="optional"/>
<xsd:attribute name="length_unit" type="unitType" use="optional"/>
<xsd:attribute name="time_unit" type="timeUnit" use="optional"/>
<xsd:attribute name="weight_unit" type="unitType" use="optional"/>
<xsd:attribute name="vehicle_type" type="vehicleType" use="optional">
<xsd:attribute name="truck_type" type="truckType" use="optional"/>
<xsd:attribute name="truck_height" type="positiveDecimal" use="optional"/>
<xsd:attribute name="truck_length" type="positiveDecimal" use="optional"/>
<xsd:attribute name="truck_per_axle_weight" type="positiveDecimal"
use="optional"/>
<xsd:attribute name="truck_weight" type="positiveDecimal" use="optional"/>
<xsd:attribute name="truck_width" type="positiveDecimal" use="optional"/>
<xsd:attribute name="cutoff_distance" type="positiveDecimal"
use="optional"/>
<xsd:attribute name="sort_by_distance" type="xsd:boolean" use="optional"/>
</xsd:complexType>
</xsd:schema>
13.3.5.1 batch_route_request Element
The root element of a batch mode route request is always named batch_route_request.
The <start_location> child element specifies the start location for the route, as an address specification, a pre-geocoded address, or longitude/latitude point.
Each of the one or more <end_location> child elements specifies the end location for the route, as an address specification, a geocoded address, or longitude/latitude point.
The <location> child element is never used in batch mode route requests.
13.3.5.2 batch_route_request Attributes
The root element <batch_route_request> has a number of attributes, most of them optional. The attributes are defined in this section.
The <batch_route_request> element shares a number of attributes with the <route_request> element. These attributes share the same meaning as their counterpart <route_request> attributes, which are explained in Section 13.3.5.2. In addition, the sort_by_distance and cutoff_distance attributes do not apply to single route requests.
sort_by_distance is an optional attribute that specifies whether you want the routes returned in ascending order by distance of the end location from the start location. TRUE sorts the returned routes by distance; FALSE (the default) does not sort the returned routes by distance.
cutoff_distance is an optional attribute that causes routes to be returned only where the end location is less than or equal to a specified distance from the start location. By default, all routes are returned.
Note:
If any route is within the batch generates a<router_error> element in the response (see Section 13.3.6), the route is removed from the response and not shown.13.3.6 Batch Route Response XML Schema
The following is the XML Schema definition for a batch route response:
<?xml version="1.0" encoding="UTF-8"?>
<!-- XML Schema definition for a Batch Mode Route Request -->
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
elementFormDefault="qualified">
<xsd:simpleType name="nonNegativeDecimal">
<xsd:restriction base="xsd:decimal">
<xsd:minInclusive value="0"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="distanceUnit">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="mile"/>
<xsd:enumeration value="km"/>
<xsd:enumeration value="kilometer"/>
<xsd:enumeration value="meter"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="timeUnit">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="minute"/>
<xsd:enumeration value="hour"/>
<xsd:enumeration value="second"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:element name="batch_route_response">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="route" maxOccurs="unbounded">
<xsd:complexType>
<xsd:attribute name="id" type="xsd:nonNegativeInteger"
use="required"/>
<xsd:attribute name="step_count" type="xsd:nonNegativeInteger"
fixed="0" use="required"/>
<xsd:attribute name="distance" type="nonNegativeDecimal"
use="required"/>
<xsd:attribute name="distance_unit" type="distanceUnit"
use="required"/>
<xsd:attribute name="time" type="nonNegativeDecimal"
use="required">
<xsd:attribute name="time_unit" type="timeUnit" use="required"/>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
<xsd:attribute name="id" type="xsd:nonNegativeInteger" use="required"/>
</xsd:complexType>
</xsd:element>
</xsd:schema>
13.4 Data Structures Used by the Routing Engine
Older versions of the routing engine (before Release 12.1) must have the following tables in their schema:
-
EDGE
-
NODE
-
PARTITION
-
SIGN_POST
The EDGE and NODE tables store edge and node information about the street network used by the routing engine. To understand how edges and nodes are used to represent street segments, intersections, and other entities in a street network, you must be familiar with the Oracle Spatial and Graph Network Data Model Graph, which is described in Oracle Spatial and Graph Topology Data Model and Network Data Model Graph Developer's Guide.
The following sections describe the tables used by the routing engine, in alphabetical order by table name:
13.4.1 EDGE Table
The EDGE table contains one row for each directed edge in a street network. Each street segment (a part of a road between two nodes) is an undirected edge that corresponds to one or more directed edges in the EDGE table. The EDGE table contains the columns shown in Table 13-1.
| Column Name | Data Type | Description |
|---|---|---|
|
EDGE_ID |
NUMBER |
Edge ID number. (Primary key.) |
|
START_NODE_ID |
NUMBER |
Node ID number of the start node of this edge. |
|
END_NODE_ID |
NUMBER |
Node ID number of the end node of this edge. |
|
PARTITION_ID |
NUMBER |
Partition ID number of the network partition that contains this edge. |
|
FUNC_CLASS |
NUMBER |
Functional road class: a number from 1 through 5, with 1 indicating a large, high-speed, high-volume road, and each successive class generally smaller in size, speed, and volume. Class 2 roads have consistent speeds and are used to get traffic to and from class 1 roads. Class 3 roads have high volume and are used to connect class 2 roads. Class 4 roads move volumes of traffic between neighborhoods (for example, a busy main road in a city). Class 5 roads are all other roads (for example, a small, low-volume street in a neighborhood). |
|
LENGTH |
NUMBER |
Length of this edge, in meters. |
|
SPEED_LIMIT |
NUMBER |
Assigned speed limit for this edge, in meters per second. |
|
GEOMETRY |
SDO_GEOMETRY |
Line string geometry representing this edge, with the coordinates ordered from the start node to the end node. |
|
NAME |
VARCHAR2(128) |
Name of this edge. |
|
DIVIDER |
VARCHAR2(1) |
A value of |
13.4.2 NODE Table
The NODE table contains one row for each node that is the start node or end node of one or more edges in the street network. A node often corresponds to an intersection (the intersection of two edges); however, a node can be independent of any intersection (for example, the end of a "dead end" or "no outlet" street). The NODE table contains the columns shown in Table 13-2.
13.4.3 PARTITION Table
The PARTITION table is generated by the routing engine based on the contents of the EDGE and NODE tables. The PARTITION table contains the columns shown in Table 13-3.
| Column Name | Data Type | Description |
|---|---|---|
|
PARTITION_ID |
NUMBER |
Partition ID number.(Primary key.) |
|
SUBNETWORK |
BLOB |
Part of the network included in this partition. |
|
NUM_NODES |
NUMBER |
Number of nodes in this partition. |
|
NUM_NON_BOUNDARY_EDGES |
NUMBER |
Number of edges in this partition that are edges that are completely contained within the partition. |
|
NUM_OUTGOING_BOUNDARY_EDGES |
NUMBER |
Number of edges in this partition that start in this partition and terminate in another partition. (An edge cannot be in more that two partitions; for example, an edge cannot start in one partition, go through a second partition, and end in a third partition.) |
|
NUM_INCOMING_BOUNDARY_EDGES |
NUMBER |
Number of edges in this partition that start in another partition and terminate in this partition. (An edge cannot be in more that two partitions; for example, an edge cannot start in one partition, go through a second partition, and end in a third partition.) |
13.4.4 SIGN_POST Table
The SIGN_POST table stores sign information that is used to generate driving directions. For example, a sign might indicate that Exit 33A on US Route 3 South goes toward Winchester. A SIGN_POST row might correspond to a physical sign at an exit ramp on a highway, but it does not need to correspond to a physical sign. The SIGN_POST table contains the columns shown in Table 13-4.
| Column Name | Data Type | Description |
|---|---|---|
|
FROM_EDGE_ID |
NUMBER |
Edge ID number of the edge to which this sign applies (for example, the street segment containing the exit ramp).(Primary key.) |
|
TO_EDGE_ID |
NUMBER |
Edge ID number of the edge to which this sign points (for example, the street segment to which the exit ramp leads). |
|
RAMP |
VARCHAR2(64) |
Ramp text (for example, |
|
EXIT |
VARCHAR2(8) |
Exit number (for example, |
|
TOWARD |
VARCHAR2(64) |
Text indicating where the exit is heading (for example, |
|
LANGUAGE_CODE |
CHAR (3 CHAR) |
A three-letter language code indicating the language used on the sign. Examples |
13.5 User Data Structures Used by the Routing Engine
The routing engine uses user data as well as routing engine data. Some user data, such as turn restriction user data, must be present in the routing engine schema. Other user data, such as trucking user data, is optional.
Note:
Effective with Release 12.1, the routing engine running against Release 12.1 or later data expects turn restriction user data to be present. However, the routing engine can also be run against earlier data versions; but if this is done, a much more limited version of the turn restriction data from the PARTITION table is used.This section explains tables used for the following types of user data:
13.5.1 Turn Restriction User Data
Turn restrictions are described in the following tables:
An edge (or a link) is an undirected edge that corresponds to one or more directed edges in the EDGE table (explained in Section 13.4.1). Turn restrictions are applied to a navigation strand (nav_strand) that is a group of two or more edges. A simple turn restriction would be applied to a two-edge nav_strand: the edge where the turn would have started and the edge where the turn would have ended. A nav_strand can have more than two edges to describe very complex restricted maneuvers.
13.5.1.1 ROUTER_CONDITION Table
The ROUTER_CONDITION table contains the raw data used to build the turn restriction user data for simple conditions. This table is not used during the routing process. Instead it is used to build the ROUTER_TURN_RESTRICTION_DATA user data table. It is part of routing engine data set so the turn restriction user data can be rebuilt if the routing engine data is repartitioned. The ROUTER_CONDITION table contains the columns shown in Table 13-5.
13.5.1.2 ROUTER_NAV_STRAND Table
The ROUTER_NAV_STRAND table contains the raw data used to build the turn restriction user data for complex maneuvers. This table is not used during the routing process. Instead, it is used to build the ROUTER_TURN_RESTRICTION_DATA user data table. It is part of routing engine data set, so the turn restriction user data can be rebuilt if the routing engine data is repartitioned. The ROUTER_NAV_STRAND table contains the columns shown in Table 13-6.
Table 13-6 ROUTER_NAV_STRAND Table
| Column Name | Data Type | Description |
|---|---|---|
|
NAV_STRAND_ID |
NUMBER |
A unique ID number for a nav_strand that contains this edge. |
|
SEQ_NUM |
NUMBER |
The edge ID's position within the nav_strand. |
|
LINK_ID |
NUMBER |
Link (edge) ID of an edge that is part of this nav_strand. |
|
NODE_ID |
NUMBER |
Node id of the node that connects the first and second link id in the nav_strand. This is zero for all other links in the nav_strand. |
|
APPLIES_TO |
NUMBER |
A number representing a list of vehicles to which the turn restriction applies. |
13.5.1.3 ROUTER_TURN_RESTRICTION_DATA Table
The ROUTER_TURN_RESTRICTION_DATA table contains the user data that describes turn restrictions. This table is used to enforce turn restrictions during the routing process. This table is partitioned to match the partitioning of the EDGE table. When a particular routing engine data partition is brought into the cache, the turn restriction User Data partition of the same number is also brought into the cache.
The ROUTER_TURN_RESTRICTION_DATA table contains the columns shown in Table 13-7.
Table 13-7 ROUTER_TURN_RESTRICTION_DATA Table
| Column Name | Data Type | Description |
|---|---|---|
|
PARTITION_ID |
NUMBER |
The routing engine data partition ID with which this turn restriction user data is associated. |
|
NUM_EDGES |
NUMBER |
Number of edges with turn restrictions on them. |
|
TURN_RESTRICTION_DATA |
BLOB |
BLOB containing the nav_strand information describing the turn restriction and the edges to which the turn restriction applies. |
13.5.2 Trucking User Data
Trucking information is described in the following tables:
13.5.2.1 ROUTER_TRANSPORT Table
The ROUTER_TRANSPORT table contains the raw data used to build the trucking user data. This table is not used during the routing process. Instead, it is used to build the ROUTER_TRUCKING_DATA Table (a user data table). It is part of routing engine data set so that the trucking user data can be rebuilt if the routing engine data is repartitioned.
When to ROUTER_TRANSPORT table is first imported into the routing engine schema, you must execute the SDO_ROUTER_PARTITION.CREATE_TRUCKING_DATA procedure (see Section E.4.4) to produce the ROUTER_TRUCKING_DATA partitioned user data table.
The ROUTER_TRANSPORT table contains the columns shown in Table 13-8.
Table 13-8 ROUTER_TRANSPORT Table
| Column Name | Data Type | Description |
|---|---|---|
|
EDGE_ID |
NUMBER |
Edge ID number of the edge to which the restriction applies. |
|
MAINTYPE |
NUMBER(2) |
Type of truck restriction: height, length, per axle weight, weight, width or legal. |
|
SUBTYPE |
NUMBER(2) |
Subtype used to extend or provide exceptions to the main type of restriction. For example, a delivery subtype might allow delivery trucks access where other trucks are forbidden. |
|
VALUE |
NUMBER(6,2) |
A value associated with the main type: for example a value of 20 associated with a weight main type to indicate that any truck in excess of 20 metric tons will not be allowed access to the edge. |
13.5.2.2 ROUTER_TRUCKING_DATA Table
The ROUTER_TRUCKING_DATA contains the user data that describes truck restrictions. This table is used to enforce truck restrictions during the routing process. This table is partitioned to match the partitioning of the EDGE table. When a particular routing engine data partition is brought into the cache, the truck restriction User Data partition of the same number is also brought into the cache if the vehicle being routed is a truck.
The ROUTER_TRUCKING_DATA table contains the columns shown in Table 13-9.
Table 13-9 ROUTER_TRUCKING_DATA Table
| Column Name | Data Type | Description |
|---|---|---|
|
PARTITION_ID |
NUMBER |
ID of the routing engine data partition with which this trucking data is associated. |
|
NUM_EDGES |
NUMBER |
Number of edges in this partition with trucking restrictions. |
|
TRUCKING_DATA |
BLOB |
Trucking restrictions for this partition in BLOB format. |