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; } } }

arcpy notebook problem where clause for select analysis?

JB1234510

I have problems in ArcGIS Pro 2.8 notebooks with a where clause of two long fields of a file geodatabase feature class (FID fields after union):

where_clause_1 = '("FID_outBarriereBuffer" = -1 AND "FID_Nutzung_Weide" > -1)'
arcpy.analysis.Select(inBarriere, outWeide, where_clause_1)

With this I get the following message:

ExecuteError: ERROR 000358: Ungültiger Ausdruck ("FID_outBarriereBuffer" = -1 AND "FID_Nutzung_Weide" > -1)
Fehler beim Ausführen von (Select).

Any ideas for a solution?

Encontre mais publicações marcadas com

Accepted answers

danretired

I would do the query manually to and copy the snippet to make sure the right sql variant is used for the inputs

Select (Analysis)—ArcGIS Pro | Documentation

All comments

JB1234510

you are right the () are useless, I put them in out of despair because without it doesn't work as well 🙂

JB1234510

Thank you for your good idea. It leads then to something like this (if I build a model and export to python):

arcpy.analysis.Select(in_features=outUnion, out_feature_class=outUnion_Select, where_clause="FID_Nutzung_Weide > -1 And FID_outBarriereBuffer = -1")

but doesn't work in the notebook.

Think I will use the select by attribute + copy feature solution to get to an end ...

Anonymous User

Maybe try it without the ( ).

danretired

I would do the query manually to and copy the snippet to make sure the right sql variant is used for the inputs

Select (Analysis)—ArcGIS Pro | Documentation

JB1234510

If I use select layer by attribute and copy feature there is no problem?

arcpy.management.MakeFeatureLayer(outUnion, outUnionLayer)

arcpy.management.SelectLayerByAttribute(outUnionLayer, 'NEW_SELECTION', 
                                        '"FID_Nutzung_Weide" > -1 And "FID_outBarriereBuffer" = -1')

arcpy.management.CopyFeatures(outUnionLayer, outWeide)

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.