Geospatial · Geocoding and routing

Optimize stops

Puts stops in the visiting order with the least total travel time or distance on the road, for one or several vehicles.

Also known as: Route optimization, delivery route

How it works

Pick the Latitude and Longitude columns of the stops, a Travel mode (Car by default, or Bike, Walk or Truck) and the Routing tiles. Optimise by chooses the cost to minimise, Time (the default) or Distance. Route shape sets the ends: Open path starts at the first input row and ends anywhere, Fixed start + end also pins the last input row as the end, and Round trip (return to start) closes the loop. Vehicles (1 by default) splits the stops across several routes; Capacity per vehicle (optional) with a Demand column (optional) keeps each route within a load.

Every input column is kept, and the node appends vehicle, visit_order, leg_distance_m, leg_duration_s, cumulative_distance_m and cumulative_duration_s. If an input column already uses one of those names the new one gets a numeric suffix.

Inputs and outputs

Settings

{
  lat: string
  lon: string
  costing: "auto"|"bicycle"|"pedestrian"|"truck"
  optimizeBy: "duration"|"distance"
  routeShape: "open"|"fixed-ends"|"round-trip"
  vehicles?: number
  capacity?: number
  demandColumn?: string
}

Example

A van must deliver 30 parcels and return to the depot, which is the first row. Set Route shape to Round trip (return to start), Optimise by to Time and Travel mode to Car, then Sort by visit_order for the driver's sheet.

More in Geocoding and routing

• Geocode — Finds the latitude and longitude for addresses or place names and adds a point. Works offline at city level, at street level with an address index you build, or through an online service you opt into.
• Reverse Geocode — Finds the nearest place or street address for each point and adds place, region, country, street, city and postcode columns. Works offline at city level, at street level with an address index you build, or through an online service you opt into.
• Route — Works out the road route between each row's start and end point, with distance, travel time and the route line. By car, bicycle, foot or truck.
• Isochrone — Draws the area you can reach from each point within a time or distance, such as a 15-minute drive.
• Matrix — Works out road distance and travel time between every pair of points, or from each start to each destination. For example, drive time from every store to every customer.
• Map-match — Snaps noisy GPS points onto the road network, one matched path per trip or each point with its confidence.