I have a map that has a layout with a Reference Grid, with rows 1-26 and Columns A-Z. On the map are 626 point features that are each within a certain cell in the Reference Grid. The point feature attribute table has an empty Column for "GridRef" (Grid Reference).
I need to create an index table below the map frame on the eventual printed map that shows where each feature is located in the grid (e.g. "Feature 17 is located in cell G-4").
How would I go about 1) appending the location information to the Feature attribute table, and 2) Generating this table on the layout?
The convoluted "workaround" workflow I have developed is:
There must be a better way, or a tool, to do this extremely common cartographic task. I'm sure I just can't find it. Or perhaps some snazzy Python code.
Can anyone help?
spatial join of the polygons to the points
assuming that the polygons have a grid id attribute, you can use that field in a field calculation to transfer the id to the field in your point table
carry on from there
Thanks Dan. I was aware of the Spatial Join option but it just still seems clunky to me. Is there no tool that can do this for us? It's 2024 after all we can dictate entire JavaScript websites into AI!