This macro can be used to generate A to B routes to display on a map, along with turn-by-turn directions and summary features such as total travel time.
This macro runs off a single input data file.
The input data must include four fields:
- Latitude and longitude fields for the
- Latitude and longitude fields for the
If you have your origins and destinations in separate files, then the
Append Fields tool can be used to combine them into the required single input data file.
Application ID and
Application Key must be filled in with your API key details.
If you don’t already have an API key, you can get a trial key here.
- Select Latitude Field - select the field from the input data that specifies the latitude of the origins
- Select Longitude Field - select the field from the input data that specifies the longitude of the origins
- Select Latitude Field - select the field from the input data that specifies the latitude of the destinations
- Select Longitude Field - select the field from the input data that specifies the longitude of the destinations
Arriving By- calculates routes arriving by the Search Date Time
Departing At- calculates routes departing at the Search Date Time
- Summarized - this option returns one data row for each A to B route
- Detailed - this option returns multiple rows of data for each A to B route (one for each
legof the journey)
- Set Specific Transport Method - chose the method of transport (if multiple options are selected, multiple routes will be returned for each pair of origins/destinations)
- Select Transport Method from Field - use a field in the input data to select the transport method
Get Fare Data?
- Whether to include fare data in the output. NB – fare data is only currently available in the UK. Requesting fare data in other countries will cause the macro to return an error.
Search Date Time
- Set Specific Date Time - set the date and time to be used as the
- Set Date Time from Field - use a field in the input data to select the date and time for
- The desired time zone to be used can be selected from the
Select Time Zonedropdown
- This time zone will also be used in the
arrival_timefields in the results
The advanced parameters can be used to configure the most granular features of the request.
These are pre-populated with
realistic estimates, and so in the majority of cases will not require updating.
Time needed to board public transport vehicle - the time (in mins) taken to board a train/bus/coach etc.
Maximum walking time - the maximum time (in mins) allowed for walking from the origin to a station/stop, and from a station/stop to the destination.
Maximum driving time to station - the maximum time (in mins) allowed for driving from the origin to the station (when using
Driving and Traintransport type).
Maximum cycling time to station - the maximum time (in mins) allowed for cycling from the origin to the station (when using
Cycling and Public Transporttransport type).
Time required to park a car or bike - the time (in mins) taken to park a car or bike.
Time required to board a ferry - the time (in mins) taken to board a ferry.
This macro returns 2 outputs:
Soutput - rows that have successfully generated a route
Foutput - rows that have not successfully generated a route, along with the HTTP status, error code, description of the error, and link to where the error codes are documented
When multiple transport methods are selected, multiple routes will be returned.
For successful results, the macro will append a number of fields onto the end of the input data. These will differ between the Summarized and Detailed output types selected in the configuration.
- Distance - the total journey distance (in metres). NB - distances are not returned for public transport routes
- Travel_time - the total journey time (in seconds)
- Arrival_time / Departure/time - the actual arrival/departure times for the specific route
- Fares - single/weekly/monthly/annual fare costs in GBP (only for routes involving public transport)
- Route - the calculated route (NB - use a Browse tool to view on a map)
- Query details - these fields record the specific parameters used for each query so that they can be easily identified.
Tip - selecting a Record will highlight the corresponding Isochrone on the map, and vice versa
Documentation for the API endpoint used by this macro can be found here: