Define element point layers referencing lookup files

When creating an element point layer that references a lookup file to obtain latitude and longitude data, the location of the point is obtained by retrieving each element and its associated latitude and longitude from the lookup file.

To define an element point layer that references a lookup file, you must create or already have available the following:

• A dimension defined in the Transformation.cfg file or a transformation dataset include file. For information about transformation configuration files, see the Dataset Configuration Guide.

• A lookup file containing the data used to plot each data point. This file must contain at least three columns of data for each data point: the key, the longitude, and the latitude. For more information about the required format of the lookup file, see Element Point Layer File Format.

• A layer file that specifies the location of the lookup file and identifies the related dimension and metric as well as the key, longitude, and latitude column names in the lookup file. For more information about the required format of the layer file, see Element Point Layer File Format.

  NOTE

  The Zip Points.layer file, provided with the Geography profile, is an element point layer that identifies the Zipcode.dim file, the Sessions.metric file, the Zip Points.txt lookup file, and the names of the key, longitude, latitude, and name columns in the lookup file.

Element point lookup file format

The element point layer lookup file must contain at least the following three columns:

• Key column: This column should contain common key data, which enables the Data Workbench server to connect the data in the lookup file to that in the dataset. The key column must be the first column in the lookup file. Each row in this column identifies an element of the dimension.

• Longitude column: This column should contain the longitude for each data point in the Key column.

• Latitude column: This column should contain the latitude for each data point in the Key column.

• Name column (Optional): If you want to specify a name to be displayed on the map for each data point, you can include a Name column in the lookup file.

Each row in the Zip Points.txt lookup file contains a ZIP Code in the first column followed by the longitude, latitude, and associated city name.

tude, and associated city name.
ZIP_CODE LATITUDE LONGITUDE NAME
00210 +43.005895 -071.013202 PORTSMOUTH, NH
00211 +43.005895 -071.013202 PORTSMOUTH, NH
...

Element point layer file format

Each element point layer .layer file that references a lookup file must be formatted using the following template:

Layer = ElementPointLayer:
  Data Paths = vector: 1 items
    0 = Path: Maps\\Lookup File Name.txt
  Longitude Column = string: Longitude Column Name
  Latitude Column = string: Latitude Column Name
  Name Column = string: Location Column Name
  Key Column = string: Key Column Name
  Dimension = ref: wdata/model/dim/Dimension Name
  Metric = ref: wdata/model/metric/Metric Name
  Scale = double: Scale
  Color = v3d: RGB Color Vector
  Rendering Mode = int: Mode Number

The Zip Points.layer file is formatted as follows:

Layer = ElementPointLayer:
  Data Paths = vector: 1 items
    0 = Path: Maps\\Zip Points.txt
  Longitude Column = string: LONGITUDE
  Latitude Column = string: LATITUDE
  Name Column = string: NAME
  Key Column = string: ZIP_CODE
  Dimension = ref: wdata/model/dim/Zipcode
  Metric = ref: wdata/model/metric/Sessions

Business.Adobe.com resources

Data Explorer First Party Data Video Analytics Audience Segmentation Ad Hoc Analysis Predictive Analytics