laptop and a wrench

Bug

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.

Zuletzt veröffentlicht: August 25, 2014 No Product Found
Bug-ID-Nummer NIM044399
EingereichtApril 16, 2009
Zuletzt geändertJune 5, 2024
Gilt fürNo Product Found
Gefunden in Version9.3
Behoben in Version9.4
StatusFixed

Workaround

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))

Schritte zur Reproduzierung

Bug-ID: NIM044399

Software:

  • No Product Found

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Esri Community

Nach zugehörigen Informationen suchen

Training

Nach Schulungen zu diesem Thema suchen

ArcGIS Ideas

Ideen erkunden und Feedback geben

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln