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 select_analysis where clause for numeric field

PitersonPaulgek

Hi,

I get error "Invalid expression" for:

where_clause ='"Yr" IS NULL'
arcpy.Select_analysis(InFC, OutFC, where_clause)

What is the correct syntax?

Finde mehr Beiträge mit dem Tag

Accepted answers

DanPatterson_Retired

Piterson, from what is given, then it appears field delimiters are not needed, which seems to be consistent with the suggestions in ArcGIS Pro ... now I am assuming that you hide your layer and field names to preserve anonymity given the syntax .... Select_analysis (in_features, out_feature_class, {where_clause}) ...

since ***, and *** are not obviously going to work in a python script. You could try a simple script to test. by replacing the in_features and out_feature_class with the path to a file (shapefile or featurelayer in a gdb) for source and destination.

All comments

PitersonPaulgek

Fortunatelly, I run the simple test (Delete and Select) - it worked in ModelBuilder and then exported to PythonScript with syntax :

arcpy.Select_analysis(in_features,out_features, "Yr IS NOT NULL")

Thanks for help!!!

DanPatterson_Retired

You got it to work in modelbuilder as you indicate. Could you export the model to a python script and report the syntax from the script? Don't run the script, just produce the format. Perhaps there is a difference in the translation from model to script that doesn't work, or at least you will have the correct syntax to use from a standalone script.

PitersonPaulgek

Thanks Mitch,

I did - it works fine in ArcMap Select By Attributes (SQL wizard). The syntax is: Yr IS NOT NULL

No quotes!

Any ideas, please!

PitersonPaulgek

Datasource for the feature layer - FGDB feature class.

Datatype of the field YR - Long Integer

(Datatype of the field Prime - Text (it work fine - see comments above))

DarrenWiens2

What is the datasource for the feature layer (FGDB feature class, PGDB feature class, shapefile, other) and what is the datatype of the field YR?

MitchHolley1

Do a Select By Attributes on the table in ArcMap, then copy that SQL syntax to your Python code.

PitersonPaulgek

Thanks Darren,

I tried: the same error: Invalid expression.

I definitely got working with ModelBuilder first, then exported to Python.

So,

In GUI (ModelBuilder) (with SQL Query Builder wizard):

Yr IS NOT NULL (it works in ModelBuilder without any quotes)

in Python (*.py):

I tried:

1) where_clause ='Yr IS NULL' - ERROR

2) where_clause ='"Yr" IS NULL' - ERROR

3) where_clause =""""Yr" IS NULL""" - ERROR
arcpy.Select_analysis(InFC, OutFC, where_clause)

For another field (text) it works fine in Python

arcpy.Select_analysis(InFC, OutFC, "Prime = 'Iron Ore'")

I've noticed that I work with layer(not feature class). I do MakeFeatureLayer that is the input for Select. Could it have an impact?

DarrenWiens2

Try 'Yr IS NULL'. Otherwise, verify your expression in the tool GUI, and consult: Building a query expression—Help | ArcGIS for Desktop

edit: it's also good practice to use AddFieldDelimiters to ensure correct field delimiters (brackets, quotes, or none).

edit 2: once you get something to work through the GUI, you can right-click in the results window and copy as Python snippet to see the syntax. It looks like ArcGIS will accept this syntax: where_clause=""""YR" IS NULL""" (four double-quotes at the beginning, three at the end)

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.