SelctbyAttributes

jaykapalczynski

Where am I going wrong here.

countiesFeatureClass <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"E:/ArcGISProjects/CountySelection/adminjk_NWTL@Rack30.sde/Counties_1_Dissolved"</SPAN>

queryCounties <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>countiesFeatureClass<SPAN class="punctuation token">,</SPAN>
                                                        <SPAN class="string token">'NEW_SELECTION'</SPAN><SPAN class="punctuation token">,</SPAN>
                                                        <SPAN class="string token">'"FIPS2"=3 OR "FIPS2"=12'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Write the selected features to a new featureclass</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN>queryCounties<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'countiesSelected'</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>

Traceback (most recent call last):
File "E:\ArcGISProjects\CountySelection\Python\Update_v4.py", line 32, in <module>
'"FIPS2"=3 OR "FIPS2"=12')
File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\management.py", line 7744, in SelectLayerByAttribute
raise e
ExecuteError: Failed to execute. Parameters are not valid.
The value cannot be a feature class
ERROR 000840: The value is not a Raster Layer.
ERROR 000840: The value is not a Mosaic Layer.
Failed to execute (SelectLayerByAttribute).

JoshuaBixby

Oh,  you should be using Select Layer By Attribute and not Select Layer by Location.  You are passing the syntax for one into the other.