Latest Contributions by 2Quiker

This was very helpful! ... View more

Sorry about that, I didn't see the option to address the syntax. Even after select Python as the syntax there is not numbers for each row. The following is given me an error and it seems no what I do the script always stops at a certain process no matter if I change the process. but I just run just the #Creat SelParsA1 section in the projects python window it will run but not in the script so I am not sure what I am doing wrong.   import arcpy, string, os from importlib import reload #Zooms to selected parcel in layout #arcpy.env.addOutputsToMap = True arcpy.env.overwriteOutput = True aprx = arcpy.mp.ArcGISProject("CURRENT") map = aprx.listMaps()[0] lyr = map.listLayers("TAXLOTS")[0] lyt = aprx.listLayouts()[0] mf = lyt.listElements("MAPFRAME_ELEMENT")[0] arcpy.env.workspace = os.path.dirname(aprx.filePath) wp = os.path.dirname(aprx.filePath) values = arcpy.GetParameterAsText(0) fieldName = "DXF_TEXT" values = values.split(";") # split values into list values = ["'{0}'".format(v) for v in values] # add single quotes whereClause = "{0} IN ({1})".format(fieldName, ",".join(values)) arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", whereClause) Name = arcpy.GetParameterAsText(1) for lyt in aprx.listLayouts(): for elm in lyt.listElements("TEXT_ELEMENT","Text"): if elm.text == "Template": elm.text = (Name) #Zooms to selected parcel ext = mf.getLayerExtent(lyr) mf.camera.setExtent(ext) mf.camera.scale *= 16 #Exports the selected parcels for SUBJECT_PROPERTY. if int(arcpy.GetCount_management("TAXLOTS").getOutput(0)) > 0: arcpy.Select_analysis("TAXLOTS", "SUBJECT_PROPERTY") arcpy.SelectLayerByAttribute_management("TAXLOTS", "CLEAR_SELECTION") #Update Subject Property symbology #layer = m.listLayers('SUBJECT_PROPERTY')[0] #arcpy.ApplySymbologyFromLayer_management(str(layer), "Symbology_SUBJECT_PROPERTY.lyrx") del aprx, map, lyr, mf, lyt ''' #Remove layer Subject property aprx = arcpy.mp.ArcGISProject("CURRENT") m = aprx.listMaps()[0]# assumes data to be added to first map listed lyr = m.listLayers()[0] m.removeLayer(lyr) del aprx, m,lyr, ''' #Udpate Subject Property datasource aprx = arcpy.mp.ArcGISProject("CURRENT") map = aprx.listMaps()[0] lyt = aprx.listLayouts()[0] lyr = map.listLayers("SUBJECT_PROPERTY")[0] mf = lyt.listElements("MAPFRAME_ELEMENT",'*')[0] try: cp = lyr.connectionProperties cp['connection_info']['database'] = wp cp['dataset'] = 'SUBJECT_PROPERTY.shp' lyr.updateConnectionProperties(lyr.connectionProperties, cp) except: pass del aprx, map, lyt, lyr, mf reload(arcpy) arcpy.ClearWorkspaceCache_management() #Creat SelParsA1 aprx = arcpy.mp.ArcGISProject("CURRENT") map = aprx.listMaps()[0] lyt = aprx.listLayouts()[0] lyr = map.listLayers("SUBJECT_PROPERTY")[0] mf = lyt.listElements("MAPFRAME_ELEMENT",'*')[0] arcpy.env.workspace = os.path.dirname(aprx.filePath) wp = os.path.dirname(aprx.filePath) TAX = "TAXLOTS" SP2 = "SUBJECT_PROPERTY" arcpy.SelectLayerByLocation_management(TAX, "WITHIN_A_DISTANCE", SP2, "600 Feet", "NEW_SELECTION") try: if int(arcpy.GetCount_management("TAXLOTS").getOutput(0)) > 0: arcpy.SelectLayerByAttribute_management("TAXLOTS", "REMOVE_FROM_SELECTION", "DXF_TEXT = ' ' OR DXF_TEXT IS NULL") #"\"DXF_TEXT\" = ' '" arcpy.FeatureClassToFeatureClass_conversion("TAXLOTS", wp, "SelParsA1") except: pass arcpy.SelectLayerByAttribute_management("TAXLOTS", "CLEAR_SELECTION") del lyr lyr = map.listLayers("SelParsA1")[0] try: cp = lyr.connectionProperties cp['connection_info']['database'] = wp cp['dataset'] = 'SelParsA1.shp' lyr.updateConnectionProperties(lyr.connectionProperties, cp) except: pass     Error: Traceback (most recent call last): File "D:\GIS Folder\Python_ArcGISPro\NotificationMapScripts\NotificationMapScriptTest_E.py", line 86, in <module> arcpy.SelectLayerByLocation_management(TAX, "WITHIN_A_DISTANCE", SP2, "600 Feet", "NEW_SELECTION") File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 8909, in SelectLayerByLocation raise e File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 8906, in SelectLayerByLocation retval = convertArcObjectToPythonObject(gp.SelectLayerByLocation_management(*gp_fixargs((in_layer, overlap_type, select_features, search_distance, selection_type, invert_spatial_relationship), True))) File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 511, in <lambda> return lambda *args: val(*gp_fixargs(args, True)) arcgisscripting.ExecuteError: ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds. The base table definition string "SUBJECT_PROPERTY" is invalid. The database was not found. Failed to execute (SelectLayerByLocation). Failed to execute (NotificatonMapScript).     Runs in projects python window but not not included in the script posted above import arcpy, string, os from importlib import reload aprx = arcpy.mp.ArcGISProject("CURRENT") m = aprx.listMaps()[0] lyt = aprx.listLayouts()[0] lyr = m.listLayers("SUBJECT_PROPERTY")[0] mf = lyt.listElements("MAPFRAME_ELEMENT",'*')[0] arcpy.env.workspace = os.path.dirname(aprx.filePath) wp = os.path.dirname(aprx.filePath) TAX = "TAXLOTS" SP2 = "SUBJECT_PROPERTY" arcpy.SelectLayerByLocation_management(TAX, "WITHIN_A_DISTANCE", SP2, "600 Feet", "NEW_SELECTION") try: if int(arcpy.GetCount_management("TAXLOTS").getOutput(0)) > 0: arcpy.SelectLayerByAttribute_management("TAXLOTS", "REMOVE_FROM_SELECTION", "DXF_TEXT = ' ' OR DXF_TEXT IS NULL") #"\"DXF_TEXT\" = ' '" arcpy.FeatureClassToFeatureClass_conversion("TAXLOTS", wp, "SelParsA1") except: pass arcpy.SelectLayerByAttribute_management("TAXLOTS", "CLEAR_SELECTION") del lyr   ... View more

It appears that the toolbox script has issues in Pro python, this same script runs fine in ArcMap. I got past the Symobology by deleting  m, lyr, lyt, mt after the first process but I had to re-add them before the Symobology process. Not sure why it's holding on to these, is there a way to clear the processes in Pro?   Changed the last process of ApplySymobologyFromLayer_Managment to Add field #Add field to lyr SP = "SUBJECT_PROPERTY" arcpy.AddField_management(SP,"BUFF_DIST","DOUBLE")  SP is a layer that is created by the first process and is in my layout in Pro, it's not being used by any process other than it's in the current layout . I do see 4 "SUBJECT_PROPERTY.shp.*****.11336.8984.sr.lock" in the explorer. Error after trying to use Add Field with the same script; ERROR 000464: Cannot get exclusive schema lock. Either being edited or in use by another application or service. Failed to execute (AddField).   ... View more

I was able to move the layer. Thanks.   aprx = arcpy.mp.ArcGISProject("CURRENT") m = aprx.listMaps()[0] for lyr in m.listLayers(): print("Map: {0} Layers".format(lyr.name)) for lyr in m.listLayers(): if lyr.name == "Sections": moveLayer = lyr if lyr.name == "Taxparcels": refLayer = lyr m.moveLayer(refLayer,moveLayer,"BEFORE") ... View more

I tried to use the following but get error.   import arcpy aprx = arcpy.mp.ArcGISProject("CURRENT") m = aprx.listMaps()[0] #for lyr in m.listLayers(): m.moveLayer("Taxparcels","Sections","BEFORE")   Error; Traceback (most recent call last): File "<string>", line 7, in <module> File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\utils.py", line 191, in fn_ return fn(*args, **kw) File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\_mp.py", line 1802, in moveLayer return convertArcObjectToPythonObject(self._arc_object.moveLayer(*gp_fixargs((reference_layer, move_layer, insert_position), True))) ValueError: Sections ... View more

I had to call the text element name and in my case it was 'Text 1' not the 'Template', like below. import arcpy Name = arcpy.GetParameterAsText(1) aprx = arcpy.mp.ArcGISProject("CURRENT") for lyt in aprx.listLayouts(): for elm in lyt.listElements("TEXT_ELEMENT", "Text 1"): elm.text = Name ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

That part of the code works fine, the parcel ParID's are selected and it zooms to the ParID's. The text element in the layout doesn't get updated by the arcpy.GetParameterAsText. This part doesn't do anything and I don't get any error. Name = arcpy.GetParameterAsText(1) for lyt in aprx.listLayouts():     for elm in lyt.listElements("TEXT_ELEMENT"):         if elm.text == "Template":             elm.text = Name   ... View more

That part of my codes works fine, with your recommendation gives me an error. values = ["{0}".format(v) for v in vals] ERROR 000358: Invalid expression‍.Failed to execute (SelectLayerByAttribute).‍ ... View more

Aw I didn't think of that. fc = 'featureclass' tx = ['City1 State','City2 State','City3 State','City4 State', 'City5 State'] with arcpy.da.UpdateCursor(fc, ['field1']) as cursor: for row in cursor: row[0] = " ".join(row[0].split()[:-2]) cursor.updateRow(row) del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I did notice that it did remove ones like 12345 StreetA St city State -->12345 StreetA St # What I wanted 0 StreetB St --> 0 # This is the issues, I would prefer if it just stayed 0 StreetB St. ... View more

I wasn't getting what I needed from the code you provided but I was able to make the following work based on the code you provided. It's not as clean as yours but I am a newbie to python. Thanks. #populate F_ID3 & F_ID4 dict1 = dict() with arcpy.da.SearchCursor(fc,['F_ID1','F_ID3','F_ID2']) as cursor: for row in cursor: dict1.setdefault(row[0],[]).append(str(row[2])) with arcpy.da.UpdateCursor(fc,['F_ID1','F_ID3','F_ID4']) as cursor: for row in cursor: row[2] = ",".join(dict1[row[0]]) cursor.updateRow(row) #Populate F_ID3 with arcpy.da.UpdateCursor(fc, ["F_ID1", "F_ID3"]) as cur: cnt = Counter(row[0] for row in cur) cur.reset() for row in cur: cur.updateRow([row[0], cnt.pop(row[0], None)])‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Awesome, thanks for the explanation on this. ... View more