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; } } }

SelectByAttribute Problem

JonathanUrshan1

Hi, I am trying to write a script that selects a parcel number and writes it to a PDF. I am having trouble with the SelectLayerByAttribute tool. I am writing the script in PyCharm not in the Python Window of ArcMap. This is what I have gathered from various sources online. I am pretty sure its an issue with my syntax. Any help would be much appreciated. This is what I have so far.

import arcpy

mxd = arcpy.mapping.MapDocument(r"//bondserv2/USERS-COUNTY/ahuber/Desktop/Bond.mxd")

parcel = "Parcel_Point"

df = arcpy.mapping.ListDataFrames(mxd, parcel)

layer = arcpy.mapping.ListLayers(mxd, "", df)

arcpy.SelectLayerByAttribute_management(layer, "NEW_SELECTION", "[PIN] = '021101104001'")

I run the SelectLayerByAttribute tool in the python window just like the above code and it works. But trying to get it working in the PyCharm IDE is being a real pain. I'm new to python and arcpy, this is my first attempt at automating some one my everyday tasks.

Najděte více příspěvků označených jako

Accepted answers

All comments

JonathanUrshan1

Yeah saved the mxd and ran the code. I got this error.

Traceback (most recent call last):
File "C:/Users/ahuber/PycharmProjects/PrintToPDF/Print_to_PDF.py", line 7, in <module>
df = arcpy.mapping.ListDataFrames(mxd, parcel)[0]
IndexError: list index out of range

XanderBakker

Did you try the code that I posted? You are running the code as a standalone script, so to see the selection, you would have to save the mxd.

JonathanUrshan1

the variable parcel (Parcel_Point) is the layer that I am targeting, and the "021101104001" is the value I am trying to select with the field name PIN. Parcel_Point is one of the shapefiles.

XanderBakker

In your case df is a list of dataframes. Add "[0]" at the end of the line to select the first dataframe from the list. And is "Parcel_point" the name of the dataframe? because that is what you are using in this case.

Same for "layer" which is a list of layers (probably with only one layer in it). Add "[0]" at the end of the command to select the first item of the list

Maybe try this:

<SPAN class="keyword token">import</SPAN> arcpy
mxd <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"//bondserv2/USERS-COUNTY/ahuber/Desktop/Bond.mxd"</SPAN><SPAN class="punctuation token">)</SPAN>
parcel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Parcel_Point"</SPAN>

df <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListDataFrames<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> parcel<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
layer <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayers<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> parcel<SPAN class="punctuation token">,</SPAN> df<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>layer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"[PIN] = '021101104001'"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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