Geospatial · Geocoding and routing

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.

Also known as: Distance matrix, origin–destination

How it works

Pick the Latitude and Longitude columns, a Travel mode (Car by default, or Bike, Walk or Truck) and the Routing tiles. With only the first input wired the node routes every pair of points in that table. Wire a second table into the destinations input for an origins-to-destinations matrix; the same column names are read from both. An optional Label column carries each point's name into the result.

The output is long-form, one row per pair: origin_index, destination_index, origin_lat, origin_lon, destination_lat, destination_lon, origin_label and destination_label when a Label column is set, route_distance_m and route_duration_s. Both endpoints ride each row, so the result plots without joining back to the points.

Inputs and outputs

Settings

{
  lat: string
  lon: string
  labelColumn?: string
  costing: "auto"|"bicycle"|"pedestrian"|"truck"
}

Example

You want the drive time from each of 10 stores to each of 200 customers; the node stops with an error above 2,500 pairs. Wire stores into the first input and customers into the second, set Label column to a name column both tables have (labels are only written when both tables have it), then Top N by route_duration_s per customer to find the nearest store.

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.
• 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.