I have a series of individual parcels with multiple soil sample points on each parcel. I need a way to communicate the soil sample information to the landowners. There are about 500 parcels so I need a way to automate the creation of maps and a report of the soil analysis, which is in a series of related tables (Site data --> Soil Horizon Info --> Horizon Analytical Results).

One of my solutions is to flatten these tables into a database row for each point, do a spatial join and append the soil point data to the parcel polygon, but this is very time consuming to manually transpose these related records in Excel.

Is there a faster way to use data driven pages and dynamic text on the map layout displaying related data?

enter image description here

  • Can you present soil info as fields in points table? – FelixIP May 8 '18 at 21:21
  • Writing dynamic tables for map automation is covered in one of my eLearning courses at udemy.com/… That course is for ArcGIS Pro but the learnings from it could be back-applied to ArcMap. The key technique is generating "table-like feature classes" that can be placed in a separate map/data frame on the layout used by cursoring through an index feature class. – PolyGeo May 8 '18 at 23:52
  • @PolyGeo I'd like a fix that doesn't involve the payment of a time-consuming online course. Thanks. – ATomz May 9 '18 at 14:24
  • @PolyGeo can you be a little more specific in what you mean by "table-like feature classes" and putting it in a separate data frame and cursing through an index feature class? Aren't all feature classes tables as well? How would your suggestion allow me to show information on the map layout based on related tables to the soil point feature class? – ATomz May 9 '18 at 15:48
  • 1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.