nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Re: Populate fields using python (cumulative)

TerryGustafson

Ok I think I’m close but need a little more help. I have a
table like the one attached. I’m trying to create a line segment from it
that goes from 22.473 to 27.346 but they are on separate lines. I need a
python script to calculate the to_measure from OBJECTID 1 equal to the
to_measure from OBJECTID2. Do you think that is possible?

example.png

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

TerryGustafson

I created sever types of table and set the table variable but seems to keep throwing the syntax at line 1. Here is an example of an exported table and the code I used.

table = "Export_Output"
ridList = []
with arcpy.da.SearchCursor(table, ["RID"]) as cursor:
    for row in cursor:
        ridList.append(row[0])
del cursor
ridList = set(ridList)
for RID in ridList:
    toMeasList = []
    with arcpy.da.SearchCursor(table, ["RID", "to_MEAS"], "RID = '" + RID + "'") as cursor:
        for row in cursor:
            toMeasList.append(row[1])
    del cursor
    toMeasList.sort()
    with arcpy.da.UpdateCursor(table, ["to_MEAS"], "RID = '" + RID + "'") as cursor:
        for row in cursor:
            row[0] = toMeasList[-1]
            cursor.updateRow(row)
    del cursor

Export_Output.dbf.zip

TerryGustafson

I did that, the table is called result. Does it have to be a certain type of table?

jskinner

Yes, you will need to update the 'table' variable with the feature class/table in the Table of Contents. Ex:

table = 'RoutingTable'

TerryGustafson

Says syntax error line 1 which is declaring the table correct?

TerryGustafson

I get a 000539 : Error message from Python. It seems like it should work. At the end its taking the row[0] array and setting the toMeasList equal to it minus 1 record correct?

jskinner

You can iterate through each RID and update the to_MEAS field. Ex:

table = "Sample"

ridList = []

with arcpy.da.SearchCursor(table, ["RID"]) as cursor:
    for row in cursor:
        ridList.append(row[0])

del cursor

ridList = set(ridList)

for RID in ridList:
    toMeasList = []
    with arcpy.da.SearchCursor(table, ["RID", "to_MEAS"], "RID = '" + RID + "' ") as cursor:
        for row in cursor:
            toMeasList.append(row[1])
    del cursor
    toMeasList.sort()

    with arcpy.da.UpdateCursor(table, ["to_MEAS"], "RID = '" + RID + "'") as cursor:
        for row in cursor:
            row[0] = toMeasList[-1]
            cursor.updateRow(row)
    del cursor

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.