laptop and a wrench

Bug

st_intersects gets stuck on large amounts of features if they are without st_envintersects on RHEL 5.3.

Last Published: December 18, 2015 ArcGIS Server (Java)
Bug ID Number NIM057453
SubmittedMay 18, 2010
Last ModifiedApril 2, 2025
Applies toArcGIS Server (Java)
Version found10.0
Version Fixed10
StatusFixed

Workaround

Add sde.st_EnvIntersect to the where filter: SELECT /*+ USE_NL(Z9_COORD SEC_POLY) */ Z9_COORD.ZIP5,Z9_COORD.ZIP4,'V' FROM SUBMIT_MST_ZIP9_COORD Z9_COORD,wadown.SUBMIT_WAP_SECTION_POLYGON SEC_POLY WHERE SDE.ST_EnvINTERSECTS(Z9_COORD.SHAPE,SEC_POLY.SHAPE) = 1 AND SDE.ST_INTERSECTS(Z9_COORD.SHAPE,SEC_POLY.SHAPE) = 1 AND z9_COORD.FACILITY_NBR = 191 AND SEC_POLY.FACILITY_NBR = 191 AND SEC_POLY.WORK_AREA_PLAN_ID = 265538 AND Z9_COORD.data_vendor_type = 'NTQ' AND Z9_COORD.GEOCODE_SCORE IN (0, 1, 2, 3, 5);

Steps to Reproduce

Bug ID: NIM057453

Software:

  • ArcGIS Server (Java)

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