laptop and a wrench

Bug

ST_Geometry: ST_Relate returns invalid value when presented with an empty geometry as an input parameter

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM006581
SubmittedFebruary 6, 2007
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found9.2
Version Fixed9.3
StatusFixed

Workaround

Checking for an output of 1 from ST_Relate will still indicate that the features are equal, except in the case where both input parameters are empty. A more robust method is to check whether geometries are empty when calling ST_Relate. If both are empty, they may be considered equal. If one is empty and the other is not, then they are not equal. For example, to find all combinations of matching features in TBL1 and TBL2select (TBL1.OBJECTID, TBL2.OBJECTID) from TBL1, TBL2 WHERE ST_Relate(TBL1.SHAPE,TBL2.SHAPE, 'T*F**FFF*') = 1 OR ( ST_IsEmpty(TBL1.SHAPE) = 0 AND ST_IsEmpty(TBL2.SHAPE) = 0 );

Steps to Reproduce

Bug ID: NIM006581

Software:

  • No Product Found

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