UpdateCursor Lat and Long

Question

We are currently trying to update existing null values with X and Y coordinates. We are getting an error: >>> Traceback (most recent call last): File "C:\FLRmodel\CalculatePlotNumberByAccess3.py", line 72, in row[2] = round(row[0], 6) TypeError: a float is required >>> with arcpy.da.UpdateCursor(projectedFC, ['SHAPE@X', 'SHAPE@Y', 'PLOT_LONG', 'PLOT_LAT'], "" , spatialRef) as cursor: for row in cursor: row[2] = round(row[0], 6) row[3] = round(row[1], 6) cursor.updateRow(row)‍‍‍‍‍‍ Why does it ask for a float?

bixb0012 · Answer

Implementing Vince's suggestion: with arcpy.da.UpdateCursor(projectedFC, ['SHAPE@X', 'SHAPE@Y', 'PLOT_LONG', 'PLOT_LAT'], "" , spatialRef) as cursor: for row in cursor: if (row[0] and row[1]): row[2] = round(row[0], 6) row[3] = round(row[1], 6) cursor.updateRow(row)‍‍‍‍‍‍ Adding the extra logical check will likely prevent the script from bombing, but it isn't going to address those records where there isn't any geometry or where the geometry is empty.

VinceAngelo · Answer

The error indicates that the source shape is also NULL (or empty). Joshua asked about the shape contents, not the target fields.  You can add a "if (row[0] and row[1]):" above your row assignment to prevent the error, with an else to report trouble.

- V

JenniferMcCarthy · Answer

we have null values that we want to update with projected coordinates. The coordinates will then be rounded to 6 decimal places.