Enrich your data
Mapping the data in your spreadsheet offers insight into spatial patterns and allows for quick visual analysis, but there may be times when you want to quickly and easily add contextual information about the area surrounding that data. Esri's geoenrichment capabilities allow you to answer questions about locations that you can't answer with maps alone, for example, What kind of people live here? What do people like to do in this area? What are their habits and lifestyles? What kind of businesses are in this area?
Enriching your data allows you to add new columns of contextual data to your spreadsheet. You can choose from a number of demographic, business, landscape, and policy data collections. Each collection has multiple variables that can be added to your spreadsheet to help you better understand the area around your locations.
If you plan to enrich your data, it's highly recommended that you format your data as an Excel table before you add it to the map. Using an Excel table allows ArcGIS Maps for Office to add columns containing new information to the dataset. If the layer was not created from an Excel table, you can overwrite the contents of an existing column for each demographic variable selected. For more information, see Tables and named ranges.
- Click the Enrich data button on the map ribbon.
The Enrich layer window opens.
- Click the layer drop-down arrow and choose the layer you want to enrich.
- Click the country drop-down arrow and choose the country for which you want to see demographics.
The list of collections changes depending on the available collections for the selected country.
- Optionally, type keywords in the search field to search for specific variables. Press Enter or click the magnifying glass to search.
- Choose a data collection.
On the next screen, you can search for variables within the collection, choose one of the popular variables within the collection, or show all variables within the collection.
- Choose the variables you want to add to your spreadsheet, and click Next.
The basket icon in the upper right corner of the window shows the number of variables you've chosen. Click the basket to view its contents. To remove a variable, click the X beside its name.
- The Enrich layer window shows a summary of the selected data collections, the type of areas that will be enriched, the number of variables selected, and the number of ArcGIS service credits you'll be charged based on the number of currently selected variables. To add or remove individual variables, expand the data collections, and check the box beside each variable you want to include.
- By default, for point layers, data will be returned for a 1-mile circle surrounding each location. To change this value to a different distance or to a drive-time polygon, click Edit and make the appropriate changes.
- Map layers containing polygons will return results for the area within each polygon.
- To append the new variables to your spreadsheet, leave <Create new> in the drop-down box beside the selected variables. This option is available only if the layer was originally created from an Excel table (to learn more about creating a table from your data, see Tables and named ranges). If the layer was not created from an Excel table, click <None> and choose the column from your original data to overwrite with the demographic data. Note that overwriting data in your spreadsheet cannot be undone.
- Click Add data to system to begin the enrichment process.
Once the enrichment process begins, your account is charged for the transaction. Do not close the window, click Cancel, close Excel, or otherwise interfere with the process, or you will not receive the enriched data for which you were charged.
When the process is complete, a confirmation message appears over the map. Click OK.
Geographic data enrichment consumes ArcGIS credits based on the number of variables added to your spreadsheet and the number of features in the selected layer. For more information, see Understand credits.