Point to address lookup
Point to address lookup returns the closest address for points in the list, also known as reverse geocoding. Point to address lookup requires a Qlik Geocoding license.
Point to address lookup requires a license for Qlik Geocoding. The functionality offered by Qlik Geocoding with Address to point lookup and Point to address lookup is distinct from other location lookup features. Qlik Geocoding allows lookups at the address level, whereas other Qlik location lookups are only as precise as the ZIP code level.
For more information, see Qlik Geocoding.
Points that are close to streets will return street level addresses. Otherwise, Point to address lookup returns postal area or city-level results. For points too far away from any known address, no data is returned.
Point to address lookup returns the following fields:
-
<dataset key field>: The key field from the input dataset.
-
Address: The found address, formatted to the address standards of the country.
-
Geometry: The point for the found item.
-
HouseNumber: The house number for the found item.
-
Street: The street for the found item.
-
PostalCode: The postal code for the found item.
-
City: The name of the city-level administrative division for the found item.
-
Adm1: The name or abbreviated name for the first order administrative division (state) for the found item.
-
CountryIso2: The country code for the found item.
-
Distance: Distance in meters to the found address.
-
All fields except the key field from dataset, prefixed with the dataset name.
Returned fields might be empty where not applicable or where data is not available.
Do the following:
-
Under Data connections, click on your Qlik GeoOperations connection.
-
Under Operation, select Point to address lookup.
-
Under Language, enter the two-letter language code for the language in which you want the address data returned.
If no language is specified, it the address data is returned in the default language for the lookup location.
-
Under Dataset 1, select the type of data source to use in the operation and its parameters.
The data types and parameters are the same as those in the Load operation. For information on each of the dataset parameters, see:
-
Under Tables, select the table to load.
-
Under Fields, select the fields to load.
-
Click Insert script.