Bug
ST_INTERSECT provides wrong results in ArcGIS for Desktop 10.4.1 and ArcGIS Desktop 10.5 when compared with the same SQL query run on a 10.1, 10.2.x or 10.3.x geodatabase.
| Bug-ID-Nummer | BUG-000104547 |
|---|---|
| Eingereicht | April 18, 2017 |
| Zuletzt geändert | August 26, 2025 |
| Gilt für | ArcSDE/Enterprise Geodatabase |
| Gefunden in Version | 10.4.1 |
| Behoben in Version | 10.5.1 |
| Status | Fixed |
Workaround
Work with a different SRID which spatial reference is more accurate altering geometry using function ST_TRANSFORM. Step by step: 1. Have a custom SRID from a spatial reference 2154 using XY tolerance and resolution more accurate.From ArcCatalog > crate a new feature class > set name 'C300008' > put spatial reference 2154 > Alter XT tolerance, from 0.001 à 0.00001, uncheck 'Accept default resolution' > don't change XY resolution value (0.000005) and then leave the default settings. 2. Get AUTH_SRID value from feature class named 'C300008' using following SQL Query:Select l.TABLE_NAME, l.SRID, sr.AUTH_SRID, sr.xycluster_tol, sr.srtext from layers l INNER JOIN spatial_references sr ON l.SRID=sr.SRID where l.table_name in ('C300008','ENVOI1');In my sample, AUTH_SRID value is equal to 300004. So now we used it under ST_TRANSFORM function. 3. Using the following Query:select sde.st_astext(sde.st_intersection(sde.st_transform(sde.st_geometry(bpp, 2154),300004),sde.st_geometry(ilo, 2154))) into res from DUAL;Careful to use ST_TRANSFORM as the first parameter of the function ST_INTERSECTION like above.Schritte zur Reproduzierung
Bug-ID: BUG-000104547
Software:
- ArcSDE/Enterprise Geodatabase
Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert
Weitere Informationen zu diesem Thema erkunden
Nach zugehörigen Informationen suchen
Nach Schulungen zu diesem Thema suchen
Ideen erkunden und Feedback geben
Unterstützung durch ArcGIS-Experten anfordern
Esri Support App herunterladen