topic Re: Unselect features from arcpy.GetCounty_management in Python Questions

Unselect features from arcpy.GetCount_management

CCWeedcontrol — Sun, 12 Dec 2021 02:55:28 GMT

I have a script that runs in arcmap Python window. It does a select layer by location then exports the selected features but i need to remove features with Null or empty attributes in a specific filed before acpy.TableToTable but some times there will be none with Null or empty attributes. I am not sure how to do that so if someone could show me how to this it would be awesome.

Currently this is the code i have.

TA = "TAXLOTS"
SP4 = "SUBJECT_PROPERTY"

arcpy.SelectLayerByLocation_management(TA, "WITHIN_A_DISTANCE", SP4, "600 Feet", "NEW_SELECTION")

try:
    if int(arcpy.GetCount_management("TAXLOTS").getOutput(0)) > 0:
        arcpy.TableToTable_conversion("TAXLOTS", wp, "NOTIFIED_LOTS.dbf")

    arcpy.SelectLayerByAttribute_management("TAXLOTS", "CLEAR_SELECTION")
except:
    pass‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Unselect features from arcpy.GetCounty_management

JoshuaBixby — Wed, 31 May 2017 18:51:48 GMT

How many fields are in this layer? Do you want to exclude records if a certain field or two has a NULL or empty, or do you want to drop a record if any field has a NULL or empty?

Re: Unselect features from arcpy.GetCounty_management

CCWeedcontrol — Wed, 31 May 2017 20:10:11 GMT

There is about 10 fields in the layer. Of the selected I would like to exclude records if a certain field is NULL or empty .

Re: Unselect features from arcpy.GetCounty_management

DarrenWiens2 — Wed, 31 May 2017 20:15:51 GMT

You remove features from a selection using the same tool as you use to add them:

Select Layer By Attribute—Help | ArcGIS for Desktop

Select Layer By Location—Help | ArcGIS for Desktop

Check the 'selection_type' parameter, 'REMOVE_FROM_SELECTION' option.

Re: Unselect features from arcpy.GetCount_management

CCWeedcontrol — Wed, 31 May 2017 21:35:41 GMT

I figured i was over looking something simple.

Will line 2 this handle NULL's ?

if int(arcpy.GetCount_management("TAXLOTS").getOutput(0)) > 0:
arcpy.SelectLayerByAttribute_management("TAXLOTS", "REMOVE_FROM_SELECTION", "\"DXF_TEXT\" = ' '")

Re: Unselect features from arcpy.GetCount_management

curtvprice — Sun, 12 Dec 2021 02:55:30 GMT

Will line 2 this handle NULL's ?

No, you need to handle both cases - blank and null.

if int(arcpy.GetCount_management("TAXLOTS").getOutput(0)) > 0:
    arcpy.SelectLayerByAttribute_management(
        "TAXLOTS",
        "REMOVE_FROM_SELECTION",
        "DXF_TEXT = ' ' OR DXF_TEXT IS NULL")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Unselect features from arcpy.GetCount_management

CCWeedcontrol — Sun, 12 Dec 2021 02:55:33 GMT

With i run the following in ArcMap python window  
if int(arcpy.GetCount_management("TAXLOTS").getOutput(0)) > 0:
    arcpy.SelectLayerByAttribute_management("DXF_TEXT = ' ' OR DXF_TEXT IS NULL" 
I get error,
ERROR 000732: Selecting Features: Dataset DXF_TEXT = '' OR DXF_TEXT IS NULL does not exist or is not supported
Failed to execute (SelectLayerByLocation).

The blank and NULL records don't get removed.

Re: Unselect features from arcpy.GetCount_management

curtvprice — Tue, 06 Jun 2017 19:19:46 GMT

You are missing the first two arguments for the Select Layer By Attribute tool.

Re: Unselect features from arcpy.GetCount_management

CCWeedcontrol — Tue, 06 Jun 2017 19:49:47 GMT

oh my bad i had 'Select by Location' instead of 'Select layer by attribute'.