I am working on a pretty complicated grid system and cannot figure out a way to name each of the points in my shapefile.
The X of the grid originally started with A and ended with AX. We have since had to broaden it both east and west to include YE through ZZ, then A through CT (so 146 columns in the grid). The Y of the grid is 1 through 147.
To further complicate things, there is a great deal of overlap with the points that meet at the vertices of the grid. This is because we have to name each corner of the square according to the grid AND the cardinal direction (e.g. A1_SE, which overlaps with B1_SW, A2_NE, and B2_NW). Each of these will be associated with the projected coordinates (e.g. A1_SE at 700000, 300000).
I have tried playing around with some excel formulas, autofill lists, etc, but cannot figure out how to assign these IDs. I am using ArcGIS 10.3 and don't yet have experience with python and extremely limited experience with R.
A simpler question: How can I populate the attributes of the grid squares (in the polygon shapefile) with the grid name info? e.g. A1, ZX146, CD56