Since your boss only speaks Excel, it might be nice to get your stores spreadsheet back with all these enriching variables added. This can be accomplished via a simple table join from the enriched service areas back onto the delivery points.
- In the ArcGIS Online map viewer, open your Delivery analysis map from the previous section of the lesson.
- Click Analysis, and click Summarize Data > Join Features.
- Set up the join with delivery as the target layer and the Enriched travel time polygons as the join layer. Use the Join settings to specify the Name and Facility: Name fields as the target and join fields, respectivelyy.
It may not always be a safe choice to do a join on a name field if there is the possibility of repeated names. In this case, it is fine because the name field contains a unique store number.
You might have wondered why we didn't do a spatial join. This is because a store location could conceivably fall within two or more service areas. Doing an attribute join ensures a one-to-one relationship between a store and its polygon.
- Give the result layer a name and run the join operation. Once you see the layer appear on your map, open the attribute table on this layer and see all your enriched variables.
- Let’s make a map with this layer. How about the percent smartphone ownership for each service area symbolized by proportionally sized circles?
- In the left-hand layer list, hover over the layer name of Join Features to delivery and click the Styles button in the toolbar to the right.
- Choose to symbolize the Percent Smartphone attribute, and select an option like Counts and Amounts using the High to Low theme.
- Play around with the symbol properties until you find something you like.
- Turn off the other layers, and examine your resulting map of smartphone ownership rates within each store’s service area.
- Save your map.
That’s enough mapping for the time being. Let’s get back to exporting this data to a spreadsheet.
- Click Analysis, and choose Manage Data > Extract Data.
- Choose to extract your Join features to delivery layer.
- Leave the output format as CSV, and choose an output file name.
- Click Run.
- In another browser window, browse to your content in ArcGIS Online.
- Find your extracted CSV, and click on its name to see its item details. (If it's not there, wait a few minutes and refresh.)
- Click the Download button to save the CSV to your local computer.
- Open the spreadsheet in a program such as Excel, and verify that it contains all the original information about your four stores, plus the enriched variables. As a bonus, you’ll notice the data also comes with Lat and Lon fields since it was geocoded by your software.