laptop and a wrench

Bogue

Utilizing the st_geometry SQL API functions of st_difference and st_intersection would return incorrect results, they have been altered to return correct results.

Dernière publication: August 25, 2014 No Product Found
Numéro d’ID de bogue NIM044399
EnvoiApril 16, 2009
Dernière modificationJune 5, 2024
S’applique àNo Product Found
Version trouvée9.3
Version de correction9.4
StatutFixed

Solution de contournement

Fix precision when geometry is returned as TEXT. Example:sde=#select ST_ASTEXT(ST_DIFFERENCE(ST_GEOMETRY('polygon ((1 1, 1 3, 3 3, 3 1, 1 1), (1.5 1.5, 1.5 2.5, 2.5 2.5, 2.5 1.5, 1.5 1.5))', 0), ST_GEOMETRY('polygon ((1 1, 1 2, 2 2, 2 1, 1 1))', 0)));POLYGON (( 1 2, 1.50000000 2.00000000, 1.50000000 2.50000000, 2.50000000 2.50000000, 2.50000000 1.50000000, 2.00000000 1.50000000, 2 1, 3 1, 3 3, 1 3, 1 2))Above is the correct result. The result reported in the initial CR was incorrect. Expected (as reported in the CR): POLYGON (( 1 2, 1.5 2, 1.5 2.5, 2.5 2.5, 2.5 1.5, 2 1, 2 1, 3 1, 3 3, 1 3, 1 2))sde=#select ST_ASTEXT(ST_Intersection(ST_GEOMETRY('multipolygon (((1 1, 4 1, 4 4, 1 4, 1 1)),((5 1, 8 1, 8 4, 5 4, 5 1)))', 0), ST_GEOMETRY('multilinestring ((2 2, 3 3),(2 2.2, 3 3.2))', 0)));MULTILINESTRING (( 2 2, 3 3),( 2.00000000 2.20000000, 3.00000000 3.20000000))

Étapes pour reproduire

ID de bogue: NIM044399

Logiciel:

  • No Product Found

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Esri Community

Rechercher des informations associées

Training

Rechercher une formation sur ce sujet

ArcGIS Ideas

Explorer des pistes et donner un avis

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement