Select to view content in your preferred language

Append Reference Grid Values to Point Features for Map Index table

1295
2
02-02-2024 08:20 AM
Labels (2)
GrantKaye
Emerging Contributor

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). 

Screenshot 2024-02-02 at 8.12.19 AM.png

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"). 

Screenshot 2024-02-02 at 8.16.59 AM.png

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:

  1. Make a fishnet from the Reference Grid with same extent as the reference grid that has 26 rows and 26 columns
  2. Convert the Fishnet to a polygon feature with 26 rows and 26 columns. 
  3. Manually tag each polygon in the feature with the Row and Column (A-1 through Z-26) in the attribute table, one row and one column at a time with Field Calculator
  4. Convert the the polygon feature to a Raster with 26 rows and 26 columns, and each raster cell is the same size as a grid block and has the value from the Grid Reference (A-1 through Z-26).
  5. Extract values to Points to my point feature, from the Raster, and create a new point feature class that has each point's Grid Reference block 
  6. Export this new feature classe's Attribute table as a CSV text file
  7. Import this table into Google Sheets
  8. Format and copy and paste the PDF back into the layout. 
  9. Generate map. 

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?

 

2 Replies
DanPatterson
MVP Esteemed Contributor

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


... sort of retired...
0 Kudos
GrantKaye
Emerging Contributor

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!

0 Kudos