topic Re: Error creating SQL label expression for Shape.STArea() >300000 in ArcGIS Pro in ArcGIS Enterprise Questions

Error creating SQL label expression for Shape.STArea() >300000 in ArcGIS Pro

DavidAlfordLPAO — Thu, 28 Apr 2022 22:22:15 GMT

I am trying to recreate a SQL expression in ArcGIS Pro that I have in ArcMap. It is a label expression that was in ArcMap to label the parcel # for parcels with Shape_Area > 300000 in my FGDB. I have migrated my FGDB to SQL and are trying to write the same expression. In SQL the Shape_Area field is now Shape.STArea() will not work with the expression Shape.STArea() >300000. I can recreate that expression in ArcMap connected to SQL, but not Pro. I am on Pro 2.9.2 and ArcMap 10.9.1

Re: Error creating SQL label expression for Shape.STArea() >300000 in ArcGIS Pro

JohannesLindner — Fri, 29 Apr 2022 09:19:31 GMT

There are 2 ways to do this.

You can have the condition in the Arcade expression:

if($feature.Shape_Area > 300000) { return $feature.OBJECTID } // if $feature.Shape_Area doesn't work, you can also try Area($feature)

Or you can have the condition as SQL statement, making the expression very simple:

return $feature.OBJECTID

Re: Error creating SQL label expression for Shape.STArea() >300000 in ArcGIS Pro

alex_friant — Thu, 07 Mar 2024 17:45:12 GMT

Did you ever figure out a solution, @DavidAlfordLPAO?

I'm in ArcGIS Pro 3.2.2 and I'm getting the same error message/alert in Notifications.

What's perplexing is that the query is confirmed as "valid" by the label tool, but when you apply it to the label class the error message appears. It has something to do with the "()" I believe, but if it did then why does the validation check say it's okay? So strange.

Also, this exact same expression works perfectly well in the Definition Query and as a regular "Select By Attributes" query. This must be a bug in the labelling stack. I'll call Esri Support and see what I can learn.

Re: Error creating SQL label expression for Shape.STArea() >300000 in ArcGIS Pro

NickMcNamara — Fri, 06 Dec 2024 14:53:46 GMT

I'm running into a similar problem, but in model builder, running a query. It was fine in Oracle, but after moving to SQL Server and changing the field names, it just doesn't like them. I'm not sure how to change the query to make it work.

Re: Error creating SQL label expression for Shape.STArea() >300000 in ArcGIS Pro

alex_friant — Fri, 06 Dec 2024 16:08:45 GMT

It might be related to this known bug in Pro 3.2. The issue is fixed in Pro 3.3.

BUG-000164308

Re: Error creating SQL label expression for Shape.STArea() >300000 in ArcGIS Pro

NickMcNamara — Fri, 06 Dec 2024 19:03:58 GMT

I deleted the query and used the picker to recreate it instead of typing it in. It was exactly the same (I checked them in notepad). But now it works OK. /shrug

Re: Error creating SQL label expression for Shape.STArea() >300000 in ArcGIS Pro

alex_friant — Fri, 06 Dec 2024 21:04:01 GMT

Isn't that how it always works LOL. Glad it's working now.