Intersection with result from intersection --> TopologyException Error

[rajanski]

I have three geometries (Attached).

I am intersecting the first two,and then intersect the result with the third geometry.

Follows the error message

Error performing intersection: TopologyException: found non-noded intersection between LINESTRING (15.1068 51.0102, 15.0974 51.0034) and LINESTRING (15.1068 51.0102, 15.0976 51.0036) at 15.101547860470001 51.006448703862588

but only when Iam directly taking the geometries from a table (see attachment)

When I produce the geometries with st_geomfromtext, it works.

When I take the geometries from the table, transform themto text,and then back to geometry,it also works.

[rajanski]

Creates a table and inserts the geometries. Then conducts the intersections.

[rajanski]

sorry forgot Postgres version: "PostgreSQL 9.1.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit" Postgis Version 2.1.0SVN, proj: "Rel. 4.7.1, 23 September 2009", GEOS "3.3.3-CAPI-1.7.4"

[rajanski]

Hi all, we need this problem solved (i.e. GEOS debugged) for a large project over here.

There is a budget and we invite devs to make offers.

We are located in Berlin, Germany.

Kind regards

[strk]

Where to send proposals ? (no email address given).

[rajanski]

Oh yes of course. Please send your offers to geosbug@…. Your Information will be kept confidental.

regards

Replying to strk:

Where to send proposals ? (no email address given).

[rajanski]

geosbug at gmail dott c o m

[strk]

Was this problem fixed with latest releases ?

[strk]

Just tested this, works fine with 3.3.9.

[rajanski]

enterprisedb havent yet integrated GEOS>= 3.3.9 in their Linux installers, although its saying Postgis 2.1.1

Also see:

​http://forums.enterprisedb.com/posts/list/3903.page

Is there an ubuntu ppa around from which i can install postgres + postgis 2.x with geos >=3.3.9 ?

Cheers!