Any ideas why I am having problems by trying to have user input a string value for a feature, then have the feature selected. #Import Modules import os , arcpy mxd = arcpy . mapping . MapDocument ( 'CURRENT' ) df = arcpy . mapping . ListDataFrames ( mxd , "Layers" ) [ 0 ] #os.chdir(r'C:\Users\dunderwood\Documents\MY_TEMPLATES\WASTEWATER_EDIT_TEMPLATE') # Set the parameters InputFeatureClass = arcpy . GetParameterAsText ( 0 ) InputField = arcpy . GetParameterAsText ( 1 ) InputValue = arcpy . GetParameterAsText ( 2 ) whereClause = FACILITYID == InputValue" arcpy . SelectLayerByAttribute_management ( InputFeatureClass , "NEW_SELECTION" , whereClause ) df . zoomToSelectedFeatures ( ) arcpy . RefreshActiveView ( )

Line 4 was missing a quotation. Should be like the following. whereclause = """{} = '{}'""".format(arcpy.AddFieldDelimiters(InputFeatureClass,InputField),InputValue) It works now, thanks. I need the last part of the tool to work which I have the following python, so I can have a Boolean tool parameter to edit. Familiar with arcpy editing ? # Set Editing workspace = r 'C:\xyz' edit = arcpy . da . Editor ( workspace ) edit . startEditing ( False , True ) edit . startOperation ( ) edit = arcpy . GetParameterAsText ( 3 )

I don't know. The following example works for me. Try hardcoding your parameters to something you're confident should work. Also, try manually running the SelectLayerByAttribute tool through the GUI, and looking at the syntax in the Results window to see the Python syntax it generates (right-click -> Copy as Python Snippet). InputFeatureClass = 'points' InputField = 'bearing' InputValue = '30' whereclause = """{} = {}""".format(arcpy.AddFieldDelimiters(InputFeatureClass,InputField),InputValue) arcpy.SelectLayerByAttribute_management(InputFeatureClass,"NEW_SELECTION",whereclause)

I removed it from the group and same error.

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

Python Tool - User input then Select by Attribute

DevinUnderwood2

Any ideas why I am having problems by trying to have user input a string value for a feature, then have the feature selected.

<SPAN class="comment token">#Import Modules</SPAN>
<SPAN class="keyword token">import</SPAN> os<SPAN class="punctuation token">,</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><SPAN class="string token">'CURRENT'</SPAN><SPAN class="punctuation token">)</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><SPAN class="string token">"Layers"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token">#os.chdir(r'C:\Users\dunderwood\Documents\MY_TEMPLATES\WASTEWATER_EDIT_TEMPLATE')</SPAN>
<SPAN class="comment token"># Set the parameters</SPAN>
InputFeatureClass <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>
InputField <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN>
InputValue <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN>

whereClause <SPAN class="operator token">=</SPAN> FACILITYID <SPAN class="operator token">==</SPAN> InputValue"
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>InputFeatureClass<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> whereClause<SPAN class="punctuation token">)</SPAN>
df<SPAN class="punctuation token">.</SPAN>zoomToSelectedFeatures<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>RefreshActiveView<SPAN class="punctuation token">(</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

DevinUnderwood2

Does it need 'FACILITYID' since it is referenced in InputValue ?

I tried this line and still having difficulty.

DarrenWiens2

I believe you can just use this for your case:

whereClause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""{} = {}"""</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>InputFeatureClass<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'FACILITYID'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>InputValue<SPAN class="punctuation token">)</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

DevinUnderwood2

Thank you for the quick responses.

I will work on this, at first glance, I need brackets and/or add field delimiter, etc. I am taking away from this that my sql clause needs work.

DanPatterson_Retired

Select analysis has a code snippet and links to formulating sql queries that will work. Your query lacks the proper quotation sequence

DarrenWiens2

The problem is your where clause. See here for how to specify a query in Python, especially the last example: Specifying a query in Python—ArcPy Get Started | ArcGIS Desktop

e.g.

whereclause = """{} = 2""".format(arcpy.AddFieldDelimiters(fc, fieldname))<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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