[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Problem with intersection from postgresql 8.0.7
From: "=?ISO-8859-1?Q?Ren=E9_F._Viancos_S.?=" <rviancos () gmail ! com>
Date: 2006-02-18 20:29:12
Message-ID: 842c1e660602181229v1065a185r () mail ! gmail ! com
[Download RAW message or body]
i have solved the problem.
in postgis 1.0.4 the collect function does not accept GeometryCollection
arguments, i have tried with HOSTGIS Linux and it version of postgres,
giving the following error (more complete)
NOTICE: IllegalArgumentException: This method does not support
GeometryCollection arguments
ERROR: GEOS Intersection() threw an error!
with this in mind, i have replaced the collect function (the work's fine
with the 8.0.3 package of postgresql for win32) by geomunion, and the query
works fine again.
SELECT DISTINCT(astext(intersection((SELECT geomunion(the_geom) as the_geom
FROM r13_ejes_32719 WHERE nombre = 'LOS RECUERDOS'), (SELECT
geomunion(the_geom) as the_geom FROM r13_ejes_32719 WHERE nombre = 'LOS
NOGALES')))) AS the_geom FROM r13_ejes_32719 WHERE (nombre = 'LOS RECUERDOS'
OR nombre = 'LOS NOGALES');
thank strk for your assistance... case solved...
Best Regards from Chile
René Viancos (-: RENIX :-)
2006/2/18, strk@refractions.net <strk@refractions.net>:
>
> On Sat, Feb 18, 2006 at 04:04:58PM -0300, René F. Viancos S. wrote:
> > 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.
>
> You don't want to use postgis 0.9.2.
> You want latest postgis release compiled against latest GEOS release.
>
> If the problem persists with them, we'll be happy to look at it.
>
> --strk;
> _______________________________________________
> postgis-users mailing list
> postgis-users@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@uchile.cl
rviancos@gmail.com
www.investigacion.uchile.cl
[Attachment #3 (text/html)]
i have solved the problem.<br><br>in postgis 1.0.4 the collect function does not \
accept GeometryCollection arguments, i have tried with HOSTGIS Linux and it version \
of postgres, giving the following error (more complete)<br> <br>NOTICE: \
IllegalArgumentException: This method does not support GeometryCollection \
arguments<br><br><br>ERROR: GEOS Intersection() threw an error!<br><br>with \
this in mind, i have replaced the collect function (the work's fine with the 8.0.3 \
package of postgresql for win32) by geomunion, and the query works fine \
again.<br><br>SELECT DISTINCT(astext(intersection((SELECT geomunion(the_geom) as \
the_geom FROM r13_ejes_32719 WHERE nombre = 'LOS RECUERDOS'), (SELECT \
geomunion(the_geom) as the_geom FROM r13_ejes_32719 WHERE nombre = 'LOS NOGALES')))) \
AS the_geom FROM r13_ejes_32719 WHERE (nombre = 'LOS RECUERDOS' OR nombre = 'LOS \
NOGALES'); <br><br>thank strk for your assistance... case solved... \
<br><br>Best Regards from Chile<br><br>René Viancos (-: RENIX \
:-)<br><br><br><br><div><span class="gmail_quote">2006/2/18, <a \
href="mailto:strk@refractions.net">strk@refractions.net </a> <<a \
href="mailto:strk@refractions.net">strk@refractions.net</a>>:</span><blockquote \
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt \
0pt 0.8ex; padding-left: 1ex;">On Sat, Feb 18, 2006 at 04:04:58PM -0300, René F. \
Viancos S. wrote: <br>> I have tried with the following SQL sentence (posrgreSQL \
8.1.7)<br>> POSTGIS="1.0.4" GEOS="2.1.4" PROJ="Rel. \
4.4.9, 29 Oct 2004"<br>> USE_STATS DBPROC=" 0.3.0" RELPROC=" \
0.3.0"<br>><br>> SELECT DISTINCT(astext(intersection((SELECT \
astext(collect(the_geom)) as<br>> the_geom FROM r13_ejes_32719 WHERE nombre = 'LOS \
NOGALES'), (SELECT<br>> astext(collect(the_geom)) as the_geom FROM r13_ejes_32719 \
WHERE nombre = <br>> 'LOS RECUERDOS')))) FROM r13_ejes_32719 WHERE (nombre = 'LOS \
NOGALES' OR<br>> nombre = 'LOS RECUERDOS');<br>><br>> and the output is the \
following:<br>><br>> ERROR: GEOS Intersection() threw an error! \
<br>><br>> i´have a question, how can i compile postgis 0.9.2 linked with geos \
on<br>> fedora 4 ? i have doengraded to geos 2.1.1, like the package of \
postgreSQL<br>> 8.0.3 for win32 and the preserves the error, but i don't know how \
to compile <br>> postgis 0.9.2 linked with GEOS 2.1.1 on fedora 4.<br><br>You \
don't want to use postgis 0.9.2.<br>You want latest postgis release compiled against \
latest GEOS release.<br><br>If the problem persists with them, we'll be happy to look \
at it. <br><br>--strk;<br>_______________________________________________<br>postgis-users \
mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a \
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"> \
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote></div><br><br \
clear="all"><br>-- <br>René F. Viáncos S.<br>Director de Geomática y \
TIC<br>Vicerrectoría de Investigación y Desarrollo<br>Universidad de Chile <br>Tel \
(56-2) 632 62 09<br>Cel (56 9) 933 72 66<br><a \
href="mailto:rviancos@uchile.cl">rviancos@uchile.cl</a><br><a \
href="mailto:rviancos@gmail.com">rviancos@gmail.com</a><br><a \
href="http://www.investigacion.uchile.cl"> www.investigacion.uchile.cl</a>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic