Bogue
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.
| Numéro d’ID de bogue | BUG-000104547 |
|---|---|
| Envoi | April 18, 2017 |
| Dernière modification | August 26, 2025 |
| S’applique à | ArcSDE/Enterprise Geodatabase |
| Version trouvée | 10.4.1 |
| Version de correction | 10.5.1 |
| Statut | Fixed |
Solution de contournement
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.Étapes pour reproduire
ID de bogue: BUG-000104547
Logiciel:
- ArcSDE/Enterprise Geodatabase
Recevoir une notification lorsque le statut d’un bogue change
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support