Opened 6 years ago

Last modified 6 years ago

#2055 new defect

Intersection with a result from Intersection fails

Reported by: bscholten Owned by: pramsey
Priority: high Milestone: PostGIS GEOS
Component: postgis Version: 1.5.X
Keywords: Intersection Cc:

Description

Basic problem:

Following query gives an error:


SELECT ST_Intersection(ST_Intersection(first_column, second_column), third_column) FROM test_bug_situation


The error returned is:


NOTICE: TopologyException?: no outgoing dirEdge found at 184311.56259997687 319320.99999998196

ERROR: GEOS Intersection() threw an error!

Fout

ERROR: GEOS Intersection() threw an error! SQL status:XX000


ST_IsValid and ST_IsSimple both return true for all columns and ST_Intersection(first_column, second_column).

Switching the columns doesn't throw an error: ST_Intersection(ST_Intersection(first_column, third_column), second_column) or ST_Intersection(ST_Intersection(third_column, second_column), first_column)

Extra information:


Postgres version: "PostgreSQL 8.4.12, compiled by Visual C++ build 1400, 32-bit" Postgis full version: "POSTGIS="1.5.5" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.6.1, 21 August 2008" LIBXML="2.7.8" USE_STATS" Tested on windows platform.

See accompanying bug_report_XYZ_column_base64 for each geometry encoded in base64 Encoded WKB.

Same test with POSTGIS 1.4.2 on both Windows and Linux has same results.

Attachments (3)

intersection_bug_report.zip (185.0 KB) - added by bscholten 6 years ago.
Zip file containing geometries causing the problem
intersection_bug_report_WKB.zip (190.8 KB) - added by bscholten 6 years ago.
files containing WKB geometries
intersection_bug_report_sql.zip (164.6 KB) - added by bscholten 6 years ago.
plain sql dump of table

Download all attachments as: .zip

Change History (11)

Changed 6 years ago by bscholten

Attachment: intersection_bug_report.zip added

Zip file containing geometries causing the problem

comment:1 Changed 6 years ago by robe

Milestone: PostGIS 1.5.6PostGIS 1.5.7

comment:2 Changed 6 years ago by robe

Milestone: PostGIS 1.5.7PostGIS 1.5.8

comment:3 Changed 6 years ago by pramsey

Milestone: PostGIS 1.5.8PostGIS GEOS

comment:4 Changed 6 years ago by rajanski

Priority: mediumhigh

Hi bscholten could you be so kind and upload the geometries as WKB strings..I amexperiencing problems with the base64 format here..thanks a lot!

comment:5 Changed 6 years ago by rajanski

to be more specific: the 3rd column doesn't get imported,ERROR: invalid end sequence

Changed 6 years ago by bscholten

files containing WKB geometries

comment:6 in reply to:  4 ; Changed 6 years ago by bscholten

Replying to rajanski:

Hi bscholten could you be so kind and upload the geometries as WKB strings..I amexperiencing problems with the base64 format here..thanks a lot!

Uploaded geometries with WKB strings now, let me know if this works or if I should export them some other way.

comment:7 in reply to:  6 Changed 6 years ago by rajanski

Hi,still doesnt work..could you upload a plain sql dump of the whole table?

Replying to bscholten:

Replying to rajanski:

Hi bscholten could you be so kind and upload the geometries as WKB strings..I amexperiencing problems with the base64 format here..thanks a lot!

Uploaded geometries with WKB strings now, let me know if this works or if I should export them some other way.

Changed 6 years ago by bscholten

plain sql dump of table

comment:8 Changed 6 years ago by bscholten

added a plain sql dump now.

Note: See TracTickets for help on using tickets.