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

322
3
04-28-2022 03:23 PM
DavidAlfordLPAO
New Contributor II

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

0 Kudos
3 Replies
RhettZufelt
MVP Frequent Contributor

I have Pro 2.9.2 and Shape.STArea() > 300000 is working fine for me in either definition expression or label  expression.

R_

DavidAlfordLPAO
New Contributor II

???? Then I am at a loss....

 

0 Kudos
DavidAlfordLPAO
New Contributor II

Weird thing is that expression works in ArcMap , but not Pro.

0 Kudos