SelectLayerByAttribute issue

MarkWingfield — Mon, 16 Jun 2014 08:59:37 GMT

I have had issues whereby a SelectLayerByAttribute CLEAR_SELECTION and NEW_SELECTION is producing "The value cannot be a feature class" messages.

I googled this and found that I should make my class a layer either by using MakeFeatureLayer or MakeTableView for the layer to be selected.

I tried both these but still get the same message.

Any help would be appreciated. My code is below:

import arcpy, sys, math, os, datetime, traceback
import arcpy.mapping as map
from arcpy import da, env

XYPointsLayer = layerMemory + os.sep + "XYPointsLayer"
XYPointsLayerIntersect = layerMemory + os.sep + "XYPointsLayerIntersect"
#arcpy.MakeXYEventLayer_management(WorkLayerName, viewName  + ".GRID_X", viewName  + ".GRID_Y", XYPointsLayer)
arcpy.MakeXYEventLayer_management(fullviewName, "GRID_X", "GRID_Y", XYPointsLayer)
#### Note looks like using the view directly may work instead of the MakeQueryTable option
arcpy.MakeTableView_management(XYPointsLayer, XYPointsLayerIntersect)
#arcpy.MakeFeatureLayer_management(XYPointsLayer, XYPointsLayerIntersect)

viewName = "DWOP.DBO.VWO_MDPAG_DPA_WORK"
fullviewName = arcpy.env.workspace + os.sep + viewName


arcpy.SelectLayerByAttribute_management(XYPointsLayerIntersect,"CLEAR_SELECTION")
arcpy.SelectLayerByAttribute_management(XYPointsLayerIntersect,"NEW_SELECTION","TIMESTAMP0 = '20140613 08:59:58.063' and FK_ROADLINK_TOID = 'PEGASUS005108964' and AP_ID_ARRAY1 = '141863003'")

The SelectLayerByAttribute is within an "for" statement in the original code so i am wondering if this may be an issue? Also, the "NEW_SELECTION" criteria are in a variable in the original code but I have traced this and cut and pasted these in just to show the criteria used. However, it fails on the CLEAR_SELECTION first.

The issue seems to be the basic interpretation of what XYPointsLayerIntersect actually is.

Any ideas?

Re: SelectLayerByAttribute issue

DouglasSands — Sat, 11 Dec 2021 16:34:02 GMT

Perhaps try this?


import arcpy, sys, math, os, datetime, traceback
import arcpy.mapping as map
from arcpy import da, env

XYPointsLayer = layerMemory + os.sep + "XYPointsLayer"
#XYPointsLayerIntersect = layerMemory + os.sep + "XYPointsLayerIntersect"
#arcpy.MakeXYEventLayer_management(WorkLayerName, viewName  + ".GRID_X", viewName  + ".GRID_Y", XYPointsLayer)
arcpy.MakeXYEventLayer_management(fullviewName, "GRID_X", "GRID_Y", XYPointsLayer)
#### Note looks like using the view directly may work instead of the MakeQueryTable option
XYPointsLayerIntersect = arcpy.MakeTableView_management(XYPointsLayer, "Test")
#arcpy.MakeFeatureLayer_management(XYPointsLayer, XYPointsLayerIntersect)

viewName = "DWOP.DBO.VWO_MDPAG_DPA_WORK"
fullviewName = arcpy.env.workspace + os.sep + viewName


arcpy.SelectLayerByAttribute_management(XYPointsLayerIntersect,"CLEAR_SELECTION")
arcpy.SelectLayerByAttribute_management(XYPointsLayerIntersect,"NEW_SELECTION","TIMESTAMP0 = '20140613 08:59:58.063' and FK_ROADLINK_TOID = 'PEGASUS005108964' and AP_ID_ARRAY1 = '141863003'")

The only thing that I can think of is that arcpy is interpreting the string value you were setting for XYPointsLayerIntersect as a file path, not a layer name.

topic SelectLayerByAttribute issue in Python Questions

SelectLayerByAttribute issue

Re: SelectLayerByAttribute issue