[postgis-users] Problem with intersection from postgresql 8.0.7 to 8.1.3 win32

[René F. Viancos S.]

I have tried with the following SQL sentence (posrgreSQL 8.1.7)
POSTGIS="1.0.4" GEOS="2.1.4" PROJ="Rel. 4.4.9, 29 Oct 2004"
USE_STATS DBPROC=" 0.3.0" RELPROC="0.3.0"

SELECT DISTINCT(astext(intersection((SELECT astext(collect(the_geom)) as
the_geom FROM r13_ejes_32719 WHERE nombre = 'LOS NOGALES'), (SELECT
astext(collect(the_geom)) as the_geom FROM r13_ejes_32719 WHERE nombre =
'LOS RECUERDOS')))) FROM r13_ejes_32719 WHERE (nombre = 'LOS NOGALES' OR
nombre = 'LOS RECUERDOS');

and the output is the following:

ERROR:  GEOS Intersection() threw an error!

i´have a question, how can i compile postgis 0.9.2 linked with geos on
fedora 4 ? i have doengraded to geos 2.1.1, like the package of postgreSQL
8.0.3 for win32 and the preserves the error, but i don't know how to compile
postgis 0.9.2 linked with GEOS 2.1.1 on fedora 4.

Regards, RENIX.


2006/2/18, strk at refractions.net <strk at refractions.net>:
>
> On Sat, Feb 18, 2006 at 12:30:04PM -0300, René F. Viancos S. wrote:
> > i have a problem with the following query.
> >
> > SELECT DISTINCT(intersection((SELECT collect(the_geom) FROM
> r13_ejes_32719
> > WHERE nombre = 'LOS RECUERDOS'),(SELECT collect(the_geom) FROM
> > r13_ejes_32719 WHERE nombre = 'LOS NOGALES'))) FROM r13_ejes_32719 WHERE
> > (nombre = 'LOS RECUERDOS' OR nombre = 'LOS NOGALES');
> >
> > where 'r13_ejes_32719' is the table with the street data, 'nombre' the
> flied
> > with the street name.
> >
> > In postgresql 8.0.3 works fine, but doesn't in postgresql 8.1.7 and i
> have
> > executed the postgis_full_version() in both versions;
> >
> > postgresql 8.0.3, win32 binary package, has the folowing:
> > POSTGIS="0.9.1" GEOS="2.1.1" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS
> > DBPROC=" 0.0.1" RELPROC="0.0.1"
> >
> > postgresql 8.1.7, win32 binary package, has the folowing;
> > POSTGIS="1.0.4" GEOS="2.1.4" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS
> > DBPROC=" 0.3.0" RELPROC="0.3.0"
>
> While you only report difference in PostgreSQL version you're
> indeed using two different versions of PostGIS as well of GEOS !!
>
> I bet this has to do with the fact that starting with PostGIS 1.0.0
> coordinates are kept with an higher precision.
>
> Try reducing precision by passing by a text representation
> (which was forced with 0.9.1)
>
> intersection((select astext(collect...)), (select astext(collect...)));
>
> --strk;
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



--
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/20060218/501e7a5e/attachment.html>