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

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

DavidAlfordLPAO — Thu, 28 Apr 2022 22:23:59 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 expression Shape.STArea() > 300000 in Pro

RhettZufelt — Thu, 28 Apr 2022 22:42:06 GMT

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

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

DavidAlfordLPAO — Mon, 02 May 2022 12:19:38 GMT

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

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

DavidAlfordLPAO — Mon, 02 May 2022 12:20:31 GMT

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