How to get variables into Python code block of arcpy.management.CalculateField

TomGeo

I have one calculation where it works great getting a variable in:

 

 

arcpy.management.CalculateField(sector_angle, 'Buffer', "getBuffer(!Area!)", "PYTHON3", 
                                f"""def getBuffer(area):
                                    if area < {median_area}:
                                            return 1
                                    if area > {median_area}:
                                            return 2""", 
                                "TEXT", "NO_ENFORCE_DOMAINS")

 

 

And I have another calculation on the same feature class where it does not work.

 

 

arcpy.management.CalculateField(sector_angle, 'Buffer_Radius', "setDistance(!Buffer!)", "PYTHON3", 
                                f"""def setDistance(buffer):
                                    if buffer == 1:
                                            return {pnt[2]}
                                    elif buffer == 2:
                                            return {pnt[3]}""", "FLOAT")

 

 

Some example on how the variables look:

pnt[2] = 2043.8900146484375

pnt[3] = 4087.780029296875

The type of both variables is float, but the resulting 'Buffer_Radius' field contains only NaN.

 

I tried all sorts of stuff on how to get the variables into the code block, but while it was so easy in the first function, I don't have luck with the second one. How do I get my variables into the 'Buffer_radius' field?

 

TomGeo

Thanks for all the valuable thoughts and inputs. In the end, since I had all the logic anyway in Python, I ended up using an update cursor. Time wise, it is almost the same if I run those two CalculateField runs, slightly slower...

I tried the whole thing of course straight in ArcGIS Pro and there my code block works. However, I think @RogerDunnGIS has a fair point talking about the format of fields. The first CalculateField run is creating the buffer field, as 'TEXT'! But my second CalculateField run is using integers in the if-statement...

I haven't had time to try it, but 1 should not be '1', and thereby the error source is once more found about 40 cm in front of the screen. 😅