Element Point Lookup File Format

IMPORTANT

Read more about Data Workbench’s End-of-life announcement.

Information about the element point layer columns.

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
...

On this page