Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

The Geocoder transform includes options that control how geocoding data is appended to your data.

Report and analysis

Option

Description

Generate Report Data

Specifies whether to generate report data for this transform.
Yes: Generates report data for this transform.
No: Turns off report data generation. If you do not need to generate reports (during testing, for example), you should set this option to No to improve performance.

Reference files

Reference files are directory paths required by the Geocoder transform to process your data.
You can use a substitution variable for the directory location. The substitution variable for reference files is $$RefFilesGeocoder. Use this substitution variable if you installed the directories in the path relative to where Data Services is installed; for example, x:/Business Objects/BusinessObjects Data Services/DataQuality/reference_data. If you installed to a different location, you can change the substitution variable while designing the workflow.
 
You can duplicate this path by right-clicking and selecting Duplicate option to point to additional directory paths. However, you cannot have the same directory file located in both directories. In the Directory Path option, only specify the path. Do not specify the directory file names.

Geocoder options

Specifies the assignment level options. This option group is required.

Option

Description

Best Assignment Level

Specifies the depth of assignment for the latitude and longitude output fields. This option is used for address and point-of-interest geocoding, and also for reverse geocoding when an address is used as the input reference point.
Preferred: Assigns to the finest depth. For example, the latitude and longitude of the house number. By default, this will assign to the Primary Number level.
Primary Number: Assigns to the finest depth. For example, the latitude and longitude of the house number. The software first attempts to assign to the primary number, then postcode, and finally locality if primary number and postcode are not found. If data is found for primary number, then postcode and locality are also assigned.
Postcode: Assigns to the postcode level. You will not receive a primary number assignment.
Locality: Assigns to the locality, city or suburb level. You will not receive a primary number or postcode assignment.
Smallest Area: Assigns to the finest depth based on the size of the locality and postcode. The software first attempts to assign to the primary number. If the primary number is not returned, then it assigns based on postcode or locality, depending on which level is the smaller area. If data is found for primary number, then postcode and locality are also assigned. Geocoder compares the locality data to the postcode data, and then assigns to the level based on the smallest area. For example, the French postcode 75014 is a smaller area than the locality of Paris.

Default Max Records

Specifies the maximum number of records that can be returned. You can enter a number up to 100.
The value of the Max_Records input field takes precedence over the value of the Default Max Records option. The value of the Default Max Records option is only used if the Max_Records input field is not mapped or is blank.

Default Radius

The distance from a specified reference point used to identify an area in which matching records are located.
The value of the Radius input field takes precedence over the value of the Default Radius option. The value of the Default Radius option is only used if the Radius input field is not mapped or is blank. If a radius is not specified, a default radius of one kilometer is used.

Distance Unit

Specifies the unit of distance used for the radius.
Kilometers
Miles

Locality Assignment Threshold

Limits the level of locality centroid assignment. For example, setting the option to Locality1 excludes Locality2-4 during assignment, even though the software may return values at those levels. However, if you set the option to Locality4 and there is no Locality4 data, the finest available data will be shown, even if that is a Locality2 level.
This option is used for address and point-of-interest geocoding, and also for reverse geocoding when an address is used as the input reference point.
Locality1-4:Returns the locality level that you choose. Locality1 is the most general and Locality4 is the most specific.
None: Skips the specific assignment level. Use this setting if you do not want to return an assignment threshold on locality.
Preferred: Assigns the finest depth. For example, the latitude and longitude of the city.

Offset Coordinates

Specifies whether the offset values of latitude and longitude are returned when the side of the street is known. This option is used for address and point-of-interest geocoding, and also for reverse geocoding when an address is used as the input reference point.
Yes: Returns the offset values.
No: Returns the center value regardless of whether the side of the street is known.

Postcode Assignment Threshold

Limits the level of postcode centroid assignment. For example, setting the option to Postcode1 excludes the other levels during assignment, even though the application may return values at those levels.
This option is used for address and point-of-interest geocoding, and also for reverse geocoding when an address is used as the input reference point.
Postcode Full: Assigns to the entire extended postcode. For example, in the USA, it assigns to the 5-digit postcode and all four digits of the ZIP+4.
Postcode1: Assigns to the city or postcode area. For example, in the USA, it assigns to the 5-digit ZIP Code.
Postcode2 Partial: Assigns to the first few characters of the extended postcode. For example, in the USA, it assigns the 5-digit postcode and the first two digits of the ZIP+4.
Preferred: Assigns the finest depth. For example, the latitude and longitude of the city or postcode area.
None: Skips the specific assignment level. Use this setting if you do not want to return an assignment threshold on postcode.


Geocoder Transform
  • No labels