[postgis-users] Problem with intersection from postgresql 8.0.7 to8.1.3 win32

[Bruce Rindahl]

Has the srid been set for both geometries and are they the same?

 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of René
F. Viancos S.
Sent: Thursday, February 16, 2006 3:33 PM
To: PostGIS Users Discussion
Subject: [postgis-users] Problem with intersection from postgresql 8.0.7
to8.1.3 win32

 

Dear users

i have the following SQL sentence that work's fine with postgreSQL
8.0.7, win32, and PostGIS

SELECT DISTINCT(intersection((SELECT collect(the_geom) FROM ejes_13
WHERE nombre = 'BALMACEDA' AND nom_com1 = 'PUENTE ALTO'),(SELECT
collect(the_geom) FROM ejes_13 WHERE nombre = 'EYZAGUIRRE' AND
nom_com1 = 'PUENTE ALTO'))) FROM ejes_13 WHERE (nombre = 'BALMACEDA'
OR nombre = 'EYZAGUIRRE') AND nom_com1 = 'PUENTE ALTO';

this sql sentence give the point for the intersection of two streets,
where "ejes_13" is the table with the street geometry, "nombre" is the
field with the name of the street, and "nom_com1" is the field with the
town name. 

when i run this sentence in postgreSQL 8.1.3, win32, and PostGIS, the
data engine gives me the following error.

ERROR: GEOS Intersection() threw an error!

does somebody any ideas about this.....

Regards


-- 
René F. Viáncos S.
Director de Geomática y TIC
Vicerrectoría de Investigación y Desarrollo
Universidad de Chile
Tel (56-2) 632 62 09
Cel (56 9) 933 72 66
rviancos at uchile.cl
rviancos at gmail.com
www.investigacion.uchile.cl 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060216/d41728e5/attachment.html>