[postgis-users] GEOS Intersection() threw an error, help please

Mark Cave-Ayland mark.cave-ayland at ilande.co.uk
Wed Dec 13 05:35:08 PST 2006


On Wed, 2006-12-13 at 10:16 +0800, Alex Chew wrote:
> Hi,Martin
>  
> This error is seperate from Intersection() error. Please show me some
> tips, I am still underground.


Hi Alex,

The only function in your example that can cause the error is
intersection(), so the error is being caused by one of the geometries in
your roadurban table which is being selected by your WHERE clause.

What Martin is asking for is for you to determine which geometry in your
roadurban table causes the POSTGIS2GEOS error using something like:

SELECT intersection(GeomFromText('...', -1),
GeometryFromText('POLYGON((1.835401366666667E7
3440267.666666667,1.844584833333333E7
3440267.666666667,1.844584833333333E7
3371624.333333333,1.835401366666667E7
3371624.333333333,1.835401366666667E7 3440267.666666667))',-1)

on each geometry that matches the WHERE clause, and then post the WKT
representation of this geometry that causes the error to the list.


Kind regards,

Mark.







More information about the postgis-users mailing list