Tutorial – formatting tabular data for joining to ArcGIS features

Here is a short tutorial that outlines the steps for formatting spreadsheet (tabular) data in preparation for joining it to features (points, lines, or polygons).

If you aren’t familiar with joins, they allow you to attach attribute data that is separate from (external to) your features. In order for joins to work, a common field that contains a unique identifier is needed in both the features and the external data. A join will match records in the external data table to features in the GIS layer based on the values in the unique ID field.

An example of features and data that have this relationship is Census tracts, which change infrequently (features). To the tracts you can join any number of metrics collected or calculated by the Census bureau: residents tabulated by race, income, education; housing stock and attributes (tabular data).

This is a very generic and basic tutorial. Please email with questions or comments.

New base maps added to ArcGIS Online

ArcGIS Online continues to be improved, with additional functionality and data added. With tools to import shapefiles, text data, gps files, or KML data, it eliminates the need for a local ArcGIS installation (in some cases).

See http://www.esri.com/news/arcwatch/1211/new-content-basemaps-and-tools-added-to-arcgis-online.html

or http://blogs.esri.com/esri/arcgis/2011/10/12/new-arcgis-online-basemaps/

or http://www.esri.com/news/arcnews/fall11articles/arcgis-online-whats-new.html for more information about ArcGIS Online.

Using MapTips in ArcGIS

It is often useful in a map to enable “MapTips” for layers in an ArcMap document. When map tips are on, hovering the cursor over a feature on the map will display the contents of a field from the attribute table in a pop-up window. This eliminates the user’s need to use the Identify tool on a layer.

To turn on map tips, open properties for the layer and choose the Display tab. In the Display Expression box, select the field you would like shown in the pop-up and check “Show map tips using the display expression“.

However, you may find this option unavailable (“grayed out”) when trying to enable map tips.

This is usually caused by the layer not having a spatial index available (see this post from ESRI for more information). The solution is to build a spatial index. This may be accomplished two ways:

1) in ArcCatalog, navigate to the layer, select it, and open Properties. Choose the Indexes tab and click Add under Spatial Index.  

2) use the Add Spatial Index tool. In Arc Toolbox expand Data Management Tools > Indexes  and open the Add Spatial Index tool. Select your layer as the Input Features in the tool and click OK.

An advantage to using the ArcToolbox tool is it may be used to rebuild an existing spatial index. ArcCatalog may only be used to create an index if one does not already exist.

After creating a spatial index, the Show MapTips option should be available for your layer.