If your data has any of the following location information, you may augment the data in this stage to allow plotting on a map when building a Viewshare View in a later stage:
- city, state
- city, state, zip
- city, country
- zip code
Note: Location augmentation can fail if any subcomponent does not appear in the geocoding database used for automatic latitude/longitude lookups. Also, at this time location augmentation will not work for zip codes in zip+4 format, and it will not work if street names are included.
- Click the "Add" button in Describe screen toolbar.
- Provide a name for the new field in the text box at the top of the screen, for example: Augmented Location.
- Click on the map image to indicate the type of view the field or fields will be used in.
- The current field names of your data are displayed on the right. By clicking the "+", choose the field or fields that contain any of the location information listed above. The chosen field from which to derive the new value will move to the lefthand column. If your location data appears in more than one field (City, State, Country), select all of those fields to create more precise latitude and longitude data augmentations. For best results, drag and drop the chosen field names so they are ordered as they would typically appear on an address label.
- Continue selecting fields in this manner until you have indicated all the fields that will be used to derive the data values in the new field.
- Click the "Create" button at the bottom left hand corner of the screen to create the new field. See Figure 7.
- You will now see a new row in your data profile. Click the "Refresh Augmented Data" button at the bottom of the Describe screen to generate data values for the new field. If your augmentation is successful you will see latitude and longitude numbers in the value column of your new field.
- If your augmentation is not successful you will receive an error message at the top of the screen. Please copy this message and start a discussion in the troubleshooting forums. The more detail you can include the better we can help you.