laptop and a wrench

Bug

ST_Difference returns wrong results for areas of a feature polygon or even errors with either "ERROR: ESRI: error finding shape difference [-154]" in a Postgres geodatabase or ORA-20817 within an Oracle geodatabase.

ArcGIS Pro
Bug ID Number BUG-000177905
SubmittedJuly 15, 2025
Last ModifiedJuly 31, 2025
Applies toArcGIS Pro
Version found3.5.1
Operating SystemWindows Server
Operating System Version2016 64 Bit
StatusIn Review

Workaround

Use a syntax like this one:

st_area(g.shape) - st_area(st_intersection(g.shape,k.shape))

Steps to Reproduce

Bug ID: BUG-000177905

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options