Latest Contributions by RandyBurton

You might try two spaces between Zone and 6S.  I ran into a similar problem with Desktop, and the extra space was the fix. I think the extra space is used for aligning single and double digits. >>> sr = arcpy.SpatialReference("WGS 1984 UTM Zone 10N") >>> print sr.name WGS_1984_UTM_Zone_10N >>> sr = arcpy.SpatialReference("WGS 1984 UTM Zone 6S") # single space Runtime error Traceback (most recent call last): File "<string>", line 1, in <module> File "c:\program files (x86)\arcgis\desktop10.5\arcpy\arcpy\arcobjects\mixins.py", line 992, in __init__ self._arc_object.createFromFile(item, vcs) RuntimeError: ERROR 999999: Error executing function. >>> sr = arcpy.SpatialReference("WGS 1984 UTM Zone 6S") # double space >>> print sr.name WGS_1984_UTM_Zone_6S   ... View more

The search cursor is returning a tuple of 3 elements matching the three fields requested.  The check for None is being done on the tuple when it should be the first element which matches the 'Pin' field.  Try: with arcpy.da.SearchCursor(fc,['Pin','Perm_COUNT','P_Num']) as cursor: for row in cursor: if row[0] not in (None, "", " "): # row[0] checks 'Pin' ... View more

It doesn't look like the x/y coordinates are in longitude/latitude (WGS 84) in the URL request: inSR=4326 &outSR=26912 &geometries={"geometryType":+"esriGeometryPoint",+"geometries":+[{"x":+-12456757.481260095,+"y":+4974725.271437088}]} %0D%0A &transformation=108190 &transformForward=true &vertical=false &f=html Project  documentation. ... View more

@JoeBorgioneand @Anonymous User  offer good solutions.  But you also need to use the  proper form in your query since 'week_a' is a variable name and not the actual field name.   def weekly_update(week_a, hours_a, week_b, hours_b): with arcpy.da.UpdateCursor (fc, ['OBJECTID_1', week_a,hours_a, week_b,hours_b], "{} LIKE '%Planned%'".format(week_a)) as cursor:   Or, with Jeff's idea: fldList = ["Wk25_Oct12Oct15_ACTIV", "Wk25_HRS", "Wk26_Oct19Oct22_ACTIV", "Wk26_HRS"] def weekly_update(fldList): with arcpy.da.UpdateCursor (fc, fldList, "{} LIKE '%Planned%'".format(fldList[0])) as cursor: .... ... View more

Then set row[1] = None.  Using the update cursor you can move the value of row[1] into row[2], then delete (set to None) the value in row[1]. with arcpy.da.UpdateCursor (fc, ['SITE_ID', 'Wk3_May11May14_ACTIV','Wk4_May18May21_ACTIV'], "Wk3_May11May14_ACTIV LIKE '%Planned%'") as cursor: for row in cursor: row[2] = row[1] row[1] = None cursor.updateRow(row)   ... View more

Both Joe and Dan have good suggestions.  You are also quoting "Point" in the block where you are setting the definition query.  Since you were using the old SearchCursor, I will assume you are using Desktop.  Try:   mxd = arcpy.mapping.MapDocument("CURRENT") Point = "MyFeature" # your code sets this # picking up with: pointList = [] with arcpy.da.SearchCursor(Point,['OBJECTID']) as cursor: for row in cursor: pointList.append(str(row[0])) # row[0] is ObjectID defQuery = "OBJECTID IN ({})".format(",".join(pointList)) # print defQuery # to verify, if needed for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name == Point: # remove quotes around Point lyr.definitionQuery = defQuery # continue       ... View more