nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to remove a specific unique value with arcpy

Yaron_YosefCohen

Hi everyone

For disclosure, i asked this question in python - How to remove a specific unique value with arcpy - Geographic Information Systems Stack Exchange but didn't get useful answers.

using arcpy, i would like to remove from 50 mxd files, a specific unique value called "residence a" (exist in 3 layers) from the table of content.

enter image description here

The value of "residence a" is the number "70" in the attribute table (in field named "YEUD")

enter image description here

When i use this code:<SPAN class="pln" style="color: #000000;"></SPAN>

import arcpy,os,sys
from arcpy import env

env.workspace = r"C:\Project"
for mxdname in arcpy.ListFiles("*.mxd"):
    mxd = arcpy.mapping.MapDocument(r"C:\Project\\" + mxdname)
    df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]
    lyr = arcpy.mapping.ListLayers(mxd, "*")[0]
    if lyr.symbologyType == "UNIQUE_VALUES":
        vals = lyr.symbology.classLabels
        for v in vals:
            if v == "residence a":
                print mxdname
                print lyr.name
                print ("1 in layer " + lyr.name)
                arcpy.mapping.RemoveLayer(df, v)        
    mxd.save()
del mxd

i get en error:

<SPAN class="pun" style="color: #145680;">>>></SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="typ" style="color: #2b91af;">Project</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="pun" style="color: #145680;">-.</SPAN><SPAN class="pln" style="color: #000000;">mxd mig1 </SPAN><SPAN class="lit" style="color: #953838;">1</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="kwd" style="color: #8a4a0b;">in</SPAN><SPAN class="pln" style="color: #000000;"> layer mig1&nbsp; </SPAN><SPAN class="typ" style="color: #2b91af;">Traceback</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="pun" style="color: #145680;">(</SPAN><SPAN class="pln" style="color: #000000;">most recent call last</SPAN><SPAN class="pun" style="color: #145680;">):</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="typ" style="color: #2b91af;">File</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="str" style="color: #800000;">"C:/Users/yaron.KAYAMOT/Desktop/remove UNIQUE_VALUES in lyr.py"</SPAN><SPAN class="pun" style="color: #145680;">,</SPAN><SPAN class="pln" style="color: #000000;"> line </SPAN><SPAN class="lit" style="color: #953838;">18</SPAN><SPAN class="pun" style="color: #145680;">,</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="kwd" style="color: #8a4a0b;">in</SPAN><SPAN class="pln" style="color: #000000;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="pun" style="color: #145680;"><</SPAN><SPAN class="pln" style="color: #000000;">module</SPAN><SPAN class="pun" style="color: #145680;">></SPAN><SPAN class="pln" style="color: #000000;"> arcpy</SPAN><SPAN class="pun" style="color: #145680;">.</SPAN><SPAN class="pln" style="color: #000000;">mapping</SPAN><SPAN class="pun" style="color: #145680;">.</SPAN><SPAN class="typ" style="color: #2b91af;">RemoveLayer</SPAN><SPAN class="pun" style="color: #145680;">(</SPAN><SPAN class="pln" style="color: #000000;">df</SPAN><SPAN class="pun" style="color: #145680;">,</SPAN><SPAN class="pln" style="color: #000000;"> v</SPAN><SPAN class="pun" style="color: #145680;">)</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="typ" style="color: #2b91af;">File</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="str" style="color: #800000;">"C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\utils.py"</SPAN><SPAN class="pun" style="color: #145680;">,</SPAN><SPAN class="pln" style="color: #000000;"> line </SPAN><SPAN class="lit" style="color: #953838;">182</SPAN><SPAN class="pun" style="color: #145680;">,</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="kwd" style="color: #8a4a0b;">in</SPAN><SPAN class="pln" style="color: #000000;"> fn_ </SPAN><SPAN class="kwd" style="color: #8a4a0b;">return</SPAN><SPAN class="pln" style="color: #000000;"> fn</SPAN><SPAN class="pun" style="color: #145680;">(*</SPAN><SPAN class="pln" style="color: #000000;">args</SPAN><SPAN class="pun" style="color: #145680;">,</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="pun" style="color: #145680;">**</SPAN><SPAN class="pln" style="color: #000000;">kw</SPAN><SPAN class="pun" style="color: #145680;">)</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="typ" style="color: #2b91af;">File</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="str" style="color: #800000;">"C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\mapping.py"</SPAN><SPAN class="pun" style="color: #145680;">,</SPAN><SPAN class="pln" style="color: #000000;"> line </SPAN><SPAN class="lit" style="color: #953838;">1845</SPAN><SPAN class="pun" style="color: #145680;">,</SPAN><SPAN class="pln" style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="kwd" style="color: #8a4a0b;">in</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="typ" style="color: #2b91af;">RemoveLayer</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="kwd" style="color: #8a4a0b;">assert</SPAN><SPAN class="pln" style="color: #000000;"> isinstance</SPAN><SPAN class="pun" style="color: #145680;">(</SPAN><SPAN class="pln" style="color: #000000;">remove_layer</SPAN><SPAN class="pun" style="color: #145680;">,</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="typ" style="color: #2b91af;">Layer</SPAN><SPAN class="pun" style="color: #145680;">)</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="typ" style="color: #2b91af;">AssertionError</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="pun" style="color: #145680;">>>></SPAN><SPAN class="pln" style="color: #000000;"> 
</SPAN>

I search desperately a solution to my problem -thanks

Encontre mais publicações marcadas com

Accepted answers

All comments

Yaron_YosefCohen

i just want to remove the value "residence a" from the layers. Right now the symbology isn't important to me.

RichardFairhurst

Python will not only modify the Unique Values listed in the layer, it will reset the symbology of every unique value in the list to random simple colors. Python mapping is very limited in what it can do with symbols. Therefore the picture you showed will never retain the symbol colors you showed if you use Python. You would have to use .Net ArcObjects to maintain the rest of the symbols in the layer after removing one of the values from the list. I am afraid you are wasting your time with Python if you require the symbols for the other Unique Values to remain unchanged.

CarlSunderman

It would be

for lyr in arcpy.mapping.ListLayers(mxd, "*"): 
    if lyr.name == "<Feature Name>": 
          lyr.definitionQuery = '<Field Name> = \'<Field Value>\''
mxd.save()

for a shapefile, the format is slightly different

Yaron_YosefCohen

Hi Carl,

How can i apply definition query to the FC and query out the values in the code?

Yaron_YosefCohen

Hi Jake,

in your code you work only with one layer. I want that arcpy will iterate all layers in all 50 mxd's. i have many other layers in the mxd's with different names that including value "residence a" in them.

To your opinion, i must change the layer name every time i want to work on specific layer- this will take a lot of time

JakeSkinner

Hi Y.Y.C,

You can append the unique values to a list, remove the value you do not want to use, and then update the symbology. Below is an example that removes the value 'Philadelphia International Airport' from a unique value list, and then updates the symbology. Also, here is a helpful link.

import arcpy
mxd = arcpy.mapping.MapDocument("current")
lyr = arcpy.mapping.ListLayers(mxd, "Airports")[0]
airportList = []
rows = arcpy.da.SearchCursor(lyr, ["NAME"])
for row in rows:
  airportList.append(row[0])

#remove duplicates from list
airportList = dict.fromkeys(airportList)
airportList = airportList.keys()

#remove unique value
airportList.remove('Philadelphia International Airport')

#update symbology
if lyr.symbologyType == "UNIQUE_VALUES":
  lyr.symbology.classValues = airportList
  lyr.symbology.showOtherValues = False

arcpy.RefreshActiveView()
arcpy.RefreshTOC()
del mxd

Yaron_YosefCohen

but i don't want to remove layers mig 1 2 3 .i want to remove only value "residence a",so my TOC will be:

CarlSunderman

You aren't trying to remove the FC, just a value in the symbology, correct?

Two simple options would be to either replace the layer file in each mxd with one excluding the the residence value and another option would be to apply definition query to the FC and query out the values.

Below will replace a layer file in a directory of mxd's

import arcpy
import os
import glob

folder = <folder containing mxds>
layerName = <Existing layer name in mxd's to be replaced>
layerFile = <Layer file containing new symbology>

newLayer = arcpy.mapping.Layer(layerFile)

mxds = glob.glob(folder + '\\' + '*.mxd')
arcpy.gp.overwriteOutput = True

for mxdFile in mxds:
    mxd = arcpy.mapping.MapDocument(mxdFile)
   
    for df in arcpy.mapping.ListDataFrames(mxd):
        for lyr in arcpy.mapping.ListLayers(mxd, data_frame=df):
            if lyr.name == layerName:
                arcpy.mapping.UpdateLayer(df, lyr, newLayer, False)
    mxd.save()
del mxd, newLayer

hope this helps

DanPatterson_Retired

the assertion error suggests that it is of the wrong type. The way you have it set up 'v' is a class in classlabels. You want to remove the layer apparently which I think is 'lyr' so I suspect if you want to remove the layer if it contains that label, then you should be using arcpy.mapping.RemoveLayer(df, lyr) .

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.