topic Different between Shape area and calculate geometry in Geodatabase Questions

Different between Shape area and calculate geometry

Greta — Fri, 28 Feb 2020 01:36:59 GMT

I have a feature class in an SDE geodatabase but the shape area is different if I compare it to a calculated area (using the tool Calculate Geometry (area field). Shouldn't it be the same area?

If the feature class is in file geodatabase the shape area field = area field

Hope I have an answer

Thanks

Greta

Re: Different between Shape area and calculate geometry

DanPatterson_Retired — Fri, 28 Feb 2020 01:51:17 GMT

Add Geometry Attributes—Data Management toolbox | Documentation

Did you try Area Geodesic?

Does it get worse or better?

And since most of your shapes seem to agree pretty well, what it is about those polygons?

Are they multipart polygons?

I would try to isolate those cases where things disagree, and work back from there... maybe the ST_area is wrong, who knows

Re: Different between Shape area and calculate geometry

George_Thompson — Fri, 28 Feb 2020 11:23:00 GMT

Take a look at this help doc on file geodatabases and Feature class Storage - Feature class basics—ArcGIS Help | Documentation

Like Dan said if there are issues, I would reach out to tech support on this.

Re: Different between Shape area and calculate geometry

JoshuaBixby — Fri, 28 Feb 2020 22:51:08 GMT

Given this is an enterprise geodatabase (EGDB/SDE) it is important to state what back-end DBMS you are using and whether the data is versioned or not.

Re: Different between Shape area and calculate geometry

SterlingLoetz — Thu, 18 Mar 2021 22:04:52 GMT

I am experiencing the same issue here: Feature Geometry Calculated In ArcGIS Pro vs SQL Server

"I need help understanding the difference in feature geometry area calculations in an SQL Server sde geodatabase vs calculated area values in ArcGIS Pro via the calculate geometry tool.

I have a feature class with impervious areas within an sql sde geodatabase. The area geometry field automatically added to the feature class upon creation is Shape.STArea(). The dataset uses the Colorado State Plane Central (Feet) coordinate system.

I added two additional fields, Planer Sqft & Geodesic Sqft, and calculated their geometries using the Calculate Geometry gp tool using the Planer or Geodesic method respectively in square feet. See the image for example values.

I understand the difference between the calculated geodesic value and planer value. I do not understand how the Shape.STArea() geometry field is calculated. Shouldn't this value be the same as either the planer or geodesic values? Is there another method that sql uses to calculate area geometry values? The difference in this case between the STArea() and Planer values is about 9.86. The amount of discrepancy seems to be related to polygon size.

In terms of best practices, which values is more accurate and should be used, the sql STArea() or the calculated area value in ArcGIS Pro?"

Re: Different between Shape area and calculate geometry

JoshuaBixby — Mon, 22 Mar 2021 15:24:03 GMT

@SterlingLoetz, see my reply on your other discussion.