Geospatial · Geocoding and routing

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.

Also known as: Directions, drive distance

How it works

Pick the four columns that hold each row's start and end: Origin latitude, Origin longitude, Destination latitude and Destination longitude. Choose a Travel mode (Car by default, or Bike, Walk or Truck) and the Routing tiles to route on; the node runs offline against the tile set installed in the app. Every input column is kept and three are added: route_distance_m, route_duration_s and route_geometry, the road route as a line. A pair that cannot be routed leaves those columns NULL.

Inputs and outputs

Settings

{
  originLat: string
  originLon: string
  destLat: string
  destLon: string
  costing: "auto"|"bicycle"|"pedestrian"|"truck"
}

Example

You have orders with the depot and the customer coordinates on each row. Set the origin columns to depot_lat and depot_lon, the destination columns to cust_lat and cust_lon, Travel mode to Truck, then Aggregate route_distance_m per driver.

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.
• 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.
• Optimize stops — Puts stops in the visiting order with the least total travel time or distance on the road, for one or several vehicles.