Esri Routing service request not optimising

TrisKent — Sun, 19 Jan 2025 12:36:28 GMT

Hi im trying to optimise a route in a test scenario.
I have a drive location and some stops.

my script gets the multiple driver locations and stops into the request with the driver location being first.
then i get the result for each driver.
the result is then passed into a url in the order it is recieved from the request in a csv

using this url below and authenticating using a web connection (cliend id and secret )https://route-api.arcgis.com/arcgis/rest/services/World/Route/NAServer/Route_World/solve

These are the parameters I'm sending, i'm finding that no matter what parameters i set the route is not optimised at all , it just returns the route in the order i gave it. I have set "findBestSequence": "true"

here are the parameters

Stops Parameter: 152.88844866600004,-27.55606990399997;152.9154993647696,-27.55711911755536;152.94965997832725,-27.557727861245567;152.8859595770001,-27.56771165699996

Request Parameters for stops: {

"f": "json",

"token": "xyzxyzx", (removed)

"stops": "152.88844866600004,-27.55606990399997;152.9154993647696,-27.55711911755536;152.94965997832725,-27.557727861245567;152.8859595770001,-27.56771165699996",

"useTraffic": "true",

"startTime": "now",

"returnDirections": "false",

"returnStops": "true",

"findBestSequence": "true",

"returnToStart": "false",

"impedanceAttribute": "time",

"preserveFirstStop": "false",

"preserveLastStop": "false"

}

here is the result in google 2-36 Lather Rd, Bellbowrie QLD 4070 to Weekes Rd, Bellbowrie QLD 4070 - Google Maps you can see its not in a good order

here is my code

import requests import logging import json import csv from arcgis.gis import GIS # Client ID and Client Secret CLIENT_ID = 'xyzxy' CLIENT_SECRET = 'xyzxyzx' # OAuth2 token endpoint token_url = "https://www.arcgis.com/sharing/rest/oauth2/token/" params = { 'client_id': CLIENT_ID, 'client_secret': CLIENT_SECRET, 'grant_type': 'client_credentials' } # Request token response = requests.post(token_url, data=params) token_response = response.json() access_token = token_response.get('access_token') if not access_token: raise Exception("Failed to retrieve access token") print("Access token acquired successfully!") # Setup logging for debugging logging.basicConfig(level=logging.DEBUG) # Route service URL route_service_url = ( "https://route-api.arcgis.com/arcgis/rest/services/World/Route/NAServer/Route_World/solve" ) # Authenticate with ArcGIS Online using the token gis = GIS("https://www.arcgis.com", token=access_token) # Access the driver feature service driver_item_id = "xyzxyzxyz" driver_item = gis.content.get(driver_item_id) # Access the stops feature service stops_item_id = "xyzxyzxyzxyz" stops_item = gis.content.get(stops_item_id) # Open CSV file for writing output_filename = "Driver_Routes.csv" with open(output_filename, mode='w', newline='', encoding='utf-8') as csvfile: csvwriter = csv.writer(csvfile) # Write header row csvwriter.writerow(["Driver Name", "Google Maps URL"]) if driver_item and hasattr(driver_item, "layers") and stops_item and hasattr(stops_item, "layers"): driver_layer = driver_item.layers[0] stops_layer = stops_item.layers[0] # Query drivers drivers = driver_layer.query(out_fields="Name, SHAPE", return_geometry=True).features # Query stops stops_features = stops_layer.query(out_fields="Name, SHAPE", return_geometry=True).features # Generate route and URL for each driver for driver in drivers: driver_name = driver.attributes["Name"] driver_geometry = driver.geometry driver_start_point = f"{driver_geometry['x']},{driver_geometry['y']}" # Filter stops for the current driver assigned_stops = [ f"{feature.geometry['x']},{feature.geometry['y']}" for feature in stops_features if feature.attributes["name"] == driver_name ] if not assigned_stops: print(f"No stops assigned for {driver_name}. Skipping...") continue # Combine driver start location with assigned stops all_stops = [driver_start_point] + assigned_stops stops_param = ";".join(all_stops) # Log the stops sequence being sent to the API print(f"\nDriver: {driver_name}") print(f"Stops Parameter: {stops_param}") # Query parameters params = { "f": "json", "token": access_token, "stops": stops_param, "useTraffic": "true", "startTime": "now", "returnDirections": "false", "returnStops": "true", "findBestSequence": "true", "returnToStart": "false", "impedanceAttribute": "time", "preserveFirstStop": "false", "preserveLastStop": "false" } # Log the full request being sent print(f"Request Parameters for {driver_name}: {json.dumps(params, indent=2)}") # Make the GET request try: response = requests.get(route_service_url, params=params) response.raise_for_status() # Parse the JSON response response_json = response.json() logging.debug(f"Response JSON for {driver_name}: {response_json}") # Check for valid stops if "stops" in response_json and "features" in response_json["stops"]: # Generate Google Maps URL coordinates_for_url = [f"{feature['geometry']['y']},{feature['geometry']['x']}" for feature in response_json["stops"]["features"]] google_maps_base_url = "https://www.google.com/maps/dir/" google_maps_url = google_maps_base_url + "/".join(coordinates_for_url) # Print driver-specific URL print(f"Google Maps URL for {driver_name}:") print(google_maps_url) # Write driver name and URL to CSV csvwriter.writerow([driver_name, google_maps_url]) else: print(f"Failed to retrieve stops for {driver_name}: {response_json.get('error', {}).get('details', 'Unknown error')}") except requests.exceptions.RequestException as e: print(f"HTTP Request failed for {driver_name}: {e}") except Exception as e: print(f"An error occurred for {driver_name}: {e}") else: print("No layers found in the specified items.") print(f"Driver routes saved to '{output_filename}'")

topic Esri Routing service request not optimising in ArcGIS REST APIs and Services Questions

Esri Routing service request not optimising