topic Re: Writing Geometry to Records with Empty Geometry Based on Matching IDs in Python Questions

Writing Geometry to Records with Empty Geometry Based on Matching IDs

deleted-user-PUOLzzPmi8Uz — Fri, 21 Feb 2020 15:38:20 GMT

I have a polyline feature class with a related table attached. Is there a good way to write the feature class line geometry to the records in the related table? Goal is to create a feature class with lines with duplicate geometry, e.g. stacked. Any py code out that can accomplish this?

Thanks!

Re: Writing Geometry to a Related Table

DavidPike — Fri, 21 Feb 2020 15:41:19 GMT

I dont quite get what you want to achieve, can you give more detail? Geometry objects can be accessed with a search cursor and SHAPE@

Re: Writing Geometry to a Related Table

deleted-user-PUOLzzPmi8Uz — Fri, 21 Feb 2020 16:08:30 GMT

Hi David. Thanks for the quick reply. Essentially, I have a polyline feature class that contains records with geometry and without geometry. Records with geometry are related to those without geometry (Shape_Length = 0) by an ID. Thought it might be easier to break those no geometry records out to a related table, but now I am thinking it would be easier and more straightforward not to do that and just have a cursor write geometry to no geometry records based on matching IDs it encounters in the attribute table. Please to see below table.

Re: Writing Geometry to a Related Table

DavidPike — Fri, 21 Feb 2020 17:28:55 GMT

Yep I'd recommend that. Let me know if you need a hand with the script.

I thought you meant a related table 'joins and relates'.

Re: Writing Geometry to a Related Table

deleted-user-PUOLzzPmi8Uz — Sat, 11 Dec 2021 22:00:13 GMT

Thanks David. Yeah, was able to cobble together so py code and create a data dictionary. From there, not sure how to write the SHAPE@ to the records with NULL Geometry based on the matching ID that has Geometry. Any help/guidance is much appreciated. Thanks!

import arcpy

inFC = #path toExample.gdb\Lines
inFields = ['ID', 'SHAPE@']
valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(inFC, inFields)}

print(valueDict)

with arcpy.da.UpdateCursor(inFC, inFields) as updateRows:
    for updateRow in updateRows:
        keyValue = updateRow[0]
        print(keyValue)
        if keyValue in valueDict:
            updateRow[1] = valueDict[keyValue][0]
            print(valueDict[keyValue][0])
            updateRows.updateRow(updateRow)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Writing Geometry to a Related Table

DavidPike — Sat, 11 Dec 2021 22:00:15 GMT

import arcpy

inFC = #path toExample.gdb\Lines
inFields = ['ID', 'SHAPE@', "Shape_Length"]
valueDict = {r[0]:r[1] if int(r[2])!= 0 for r in arcpy.da.SearchCursor(inFC, inFields)}

print(valueDict)

with arcpy.da.UpdateCursor(inFC, inFields) as cursor:
    for row in cursor:

        row[1] = valueDict[row[0]]
        print(row[1])
        row.updateRow(row)‍‍‍‍‍‍‍‍‍‍‍‍‍‍

my dictionary comprehension might be wrong, I always get confused doing them.

the rest miiiight work..

Re: Writing Geometry to a Related Table

deleted-user-PUOLzzPmi8Uz — Sat, 11 Dec 2021 22:00:18 GMT

Thanks David. I got snippet to update the geometry, but unfortunately it only takes the first geometry and applies it to the rest of the non-geometry records. Thinking there needs to be a where clause that says if ID = ID and has geometry, apply geometry to non-geometry records with same ID. Anyways thanks a look. I appreciate the help. I'll keep at it!

import arcpy

inFC = #".\Example.gdb\Lines"
fields = ['SHAPE@','Unique_ID']

#Update cursor
with arcpy.da.UpdateCursor(inFC, fields) as cursor:
    #Set up dictionary to store previous non-null non-empty values
    lastNonNullVals={}
    for field in fields:
        lastNonNullVals[field]="" #set a starting value for each field
    for row in cursor:
        for field in fields:
            #Check if the current cell is null or empty
            if row[fields.index(field)] in [None,"", " "]:
                #Check if the previous value for the field exists
                if lastNonNullVals[field] not in [None,"", " "]:
                    #Set the cell to the previous non-null non-empty value
                    row[fields.index(field)]=lastNonNullVals[field]
            else:
                #if there is a value for the cell, set it so it can be used in the next row(s)
                lastNonNullVals[field]=row[fields.index(field)]
        cursor.updateRow(row)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Writing Geometry to Records with Empty Geometry Based on Matching IDs

DavidPike — Fri, 21 Feb 2020 20:18:45 GMT

I can't see why it's doing that. Could you show the prints or resend the feature as it wouldnt open in arc

Re: Writing Geometry to Records with Empty Geometry Based on Matching IDs

deleted-user-PUOLzzPmi8Uz — Fri, 21 Feb 2020 20:27:08 GMT

Here is the feature class.

Re: Writing Geometry to Records with Empty Geometry Based on Matching IDs

DavidPike — Fri, 21 Feb 2020 20:58:13 GMT

Wifi down so back to phone.

The last line in my previous should be cursor.updateRow(row)

Re: Writing Geometry to Records with Empty Geometry Based on Matching IDs

deleted-user-NvcfpBOWaKwr — Sat, 11 Dec 2021 22:00:21 GMT

David, With your previous code it was updating rows with Null or None Geometry to the matching rows that contained geometry. I updated your code to exclude the "None" geometry type from the dictionary so there wouldn't be an accidental overwrite to features that contained geometry.

import arcpy

inFC = r""
inFields = ['Unique_ID', 'SHAPE@']
#valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(inFC, inFields)}

valueDict = {}

for r in arcpy.da.SearchCursor(inFC, inFields):
    if r[1] == None:
        pass
    else:
        valueDict[r[0]] = r[1:]

print(valueDict)

with arcpy.da.UpdateCursor(inFC, inFields) as updateRows:

    for updateRow in updateRows:
        keyValue = updateRow[0]
        print(keyValue)

        if keyValue in valueDict:
            updateRow[1] = valueDict[keyValue][0]
            print(valueDict[keyValue][0])
            updateRows.updateRow(updateRow)
            print("Updated {}".format(keyValue))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Writing Geometry to Records with Empty Geometry Based on Matching IDs

deleted-user-PUOLzzPmi8Uz — Fri, 21 Feb 2020 21:28:09 GMT

David / Jeremy. Thank you both so much. This works!

Re: Writing Geometry to Records with Empty Geometry Based on Matching IDs

deleted-user-NvcfpBOWaKwr — Fri, 21 Feb 2020 21:44:19 GMT

Jason, don't forget to give credit to David since he did all of the heavy lifting. Plus I'm sure he would like the points for a correct answer.

Have a good weekend!

Re: Writing Geometry to Records with Empty Geometry Based on Matching IDs

JoshuaBixby — Fri, 21 Feb 2020 21:44:44 GMT

Please mark a response as Correct to close out the question. If multiple responses helped, pick the one that helped the most and mark the others helpful.

Re: Writing Geometry to Records with Empty Geometry Based on Matching IDs

deleted-user-PUOLzzPmi8Uz — Fri, 21 Feb 2020 21:47:03 GMT

Yep. Special props to David for helping me this! I learned quite a bit today.

Re: Writing Geometry to Records with Empty Geometry Based on Matching IDs

DavidPike — Fri, 21 Feb 2020 21:53:21 GMT

Jeremy, nice one. Why I tried to edit the dictionary comprehension i dont know. I'm sticking to iterators!

I think that may mislead others with incorrect solutions, but thanks anyway. Theres a points system??

Re: Writing Geometry to Records with Empty Geometry Based on Matching IDs

deleted-user-NvcfpBOWaKwr — Fri, 21 Feb 2020 21:54:48 GMT

Haha.. Can i give the points to David please? I just swooped in to fix a dictionary issue and don't deserve the correct answer points.