Geocode (Process operations)

Connects to the Google Maps geocoding service. A 'Application Key' is required to use this geocoder.

Address

The street address or plus code to be queried, as an expression or as a string, eg 'AddressS + PostCodeS’, or '1600 Amphitheatre Parkway. Mountain View. CA’

Language

Language in which to return results

Connects to the Microsoft Bing Maps geocoding service. A Microsoft Bing Maps 'Application Key' is required to use this geocoder.

Culture

The 'culture' to use for the request. Select from drop-down list.

Include neighbourhood

Indicate if the response should include neighbourhoods with the address

Query string*

The unstructured string to be queried as an expression or as a string, e.g. 'Address$ + PostCode$', or '1 Microsoft Way Redmond WA'.

Connects to the OS Data Hub Names API geocoding service.

Query string*

The unstructured string to be queried as an expression or as a string, e.g. 'Address$ + PostCode$', or '1 Microsoft Way Redmond WA'.

Type*

The type of resource to search for (e.g. 'SG1');

Connects to the OS Data Hub Places API geocoding service.

Language*

Language in which to return results.

Query string*

The unstructured string to be queried as an expression or as a string, e.g. 'Address$ + PostCode$', or '1 Microsoft Way Redmond WA'.

Example

When you have address items with address information and post code but no x or y values, use the expression below. Coalesce can be used to handle empty values if records do not have a second address line or city/town.

Addressline1$", " Coalesce(Addressline2$,"") ", " Coalesce(CityorTown$) ", " postcode$

Note: Any items that are not geo-coded will remain with the _class$ = “Empty”. This can be used to locate the ones that have failed.

Items that are geo-coded will be tagged with extra information on the matching data.

Searches OS (GB) Code-Point Open data, by postcode.

Postcode*

The postcode to be queried as an expression or as a string, e.g. 'Postcode$', or SG1 2JY'.

Type*

The postcode type to query: Unit (e.g. 'SG1 2JY'); Sector (e.g. 'SG1 2'); District (e.g. 'SG1'); or Area (e.g. 'SG').

Matches search strings against OS (GB) National Grid References.

Grid Reference*

The grid reference to be queried, as an expression or as a string, e.g. 'Postcode$' or SG1 2JY'.

Matches search strings against OS (GB) National Grid References for Jersey.

Grid Reference*

The Jersey grid reference to be queried, as an expression or as a string, e.g. 'GridRef$' or S'WV 2340 2349'.

Example:

RefXX$ +Lpad(Str(Easting12345&),5,"0")+Lpad(Str(Northing12345&),5,"0")

Here the user has three columns: the OS Grid a Y and Y. Because the leading 0 were being stripped, LPAD is being used to force the string to be 5 characters in length.

Connects to the whatwords API, matching search strings against what3words addresses. A what3words ‘Application Key’ is required to use this geocoder

Locale

The ‘locale’ to use for the request, or blank to use the default

Query string**

The what3words address to be queried, as an expression or as a string. eg ‘First$ + + Second$ + + Thirds’, or 'daring.lion.race'