AnsweredAssumed Answered

ArcPy SelectLayerByAttribute_management with a domain

Question asked by bill@poconogis.com on Apr 30, 2020
Latest reply on Apr 30, 2020 by jborgion

Hi,

 

I want to subset my database and when I tried 

arcpy.SelectLayerByAttribute_management ("OHlyr3", "NEW_SELECTION", " [SUBTYPECD]" LIKE \'%Overhead\' ) 

I was getting an error on the sql expression. Than I found out the field "SUBTYPECD" is really a domain. 

 

What I need is to query against part of it's value like Overhead where I have "Single Phase Overhead" as a domain value  It's coded number is 2 if that's easy. 

 

Any ideas?

 

Outcomes