How can I assign grid values to the squares of a fishnet grid?

RyanGardner-Cook

Hello,

I am working with a fishnet grid that I created but cannot figure out how to populate the attribute table of the shapefile with the corresponding grid designation. 

The details of the grid are as follows:
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.  Each grid square is 5x5 meters.

There must be something I am missing in order to assign grid values to each square.  I have played around a bit with attribute assist, and editing a grid template for Make Grids and Graticules Layer (both of which are new to me).  I have also started playing around with creating rows and columns of polygons named according to the grid and named accordingly and spatially joining them with the grid squares...  I haven't quite been able to figure it out with any of these, and I figure there must be a simpler way, right?

Cheers,

Ryan

XanderBakker

And to give an example:

Was created using this code:

import arcpy

def main():
    # the fishnet featureclass
    fc = r"C:\Forum\FishIndex\test.gdb\indexgrid01"

    # fields to will be updated (should exist)
    fld_row = "row"
    fld_col = "col"
    fld_idx = "GridIndex"

    # extent (all lower left of fishnet polygons)
    xmin = 150000
    ymin = 450000
    xmax = 150725
    ymax = 450730
    width = 5
    height = 5

    # update features
    flds = ("SHAPE@", fld_row, fld_col, fld_idx)
    with arcpy.da.UpdateCursor(fc, flds) as curs:
        for row in curs:
            ext = row[0].extent
            rownum = getRowNumber(ext.YMin, ymax, height)
            colnum = getColNumber(ext.XMin, xmin, width)
            idxnum = getIndex(colnum, rownum)
            row[1] = rownum
            row[2] = colnum
            row[3] = idxnum
            curs.updateRow(row)

def getRowNumber(yi, ymax, height):
    return int((ymax - yi) / height + 1)

def getColNumber(xi, xmin, width):
    return int((xi - xmin) / width + 1)

def getIndex(col, row):
    col = correctCol(col)
    # http://stackoverflow.com/questions/19153462/python-get-excel-style-column-names-from-column-number
    LETTERS = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
    result = []
    while col:
        col, rem = divmod(col-1, 26)
        result[:0] = LETTERS[rem]
    return ''.join(result) + str(row)

def correctCol(col):
    # YE through ZZ, then A through CT
    YE, ZZ = 655, 702
    if col <= (ZZ - YE + 1):
        return col + YE -1
    else:
        return col - (ZZ - YE + 1)
    return col

if __name__ == '__main__':
    main()