On Tue, Aug 09, 2011 at 10:28:34PM +0300, Antonio Rodriges wrote:
> Thank you, Sandro,
>
> yes, I clearly understand this, but all my contours are CLOSED and
> NONE of them intersects each other. many of them contain each other.
> actually, they are like isobars on synoptic map,
>
> please, see f
Thank you, Sandro,
yes, I clearly understand this, but all my contours are CLOSED and
NONE of them intersects each other. many of them contain each other.
actually, they are like isobars on synoptic map,
please, see for ex
http://1.bp.blogspot.com/_a1AVUIK5Er8/S27QJhQijOI/I88/NUJE11Me6n4/
On Tue, Aug 09, 2011 at 04:44:48PM +0300, Antonio Rodriges wrote:
> Dear all,
>
> I have the table "contours" which stores geography column
> "coordinates" - these are closed polylines, many of them span a half
> of a globe.
Closed polylines contain each other only if there's NO point
in one of t
Dear all,
I have the table "contours" which stores geography column
"coordinates" - these are closed polylines, many of them span a half
of a globe.
When I perform
select a.id, b.id, ST_Contains(a.coordinatesgeometry,
b.coordinatesgeometry) AS result
from contours a CROSS JOIN contours b
On 09/08/11 09:04, ml ml wrote:
Hello,
i am trying to restore a postgres dump on a freshly installed Debian
Squeeze Box.
I am using postgres 8.2.20, postgis 1.4.2 and geos.3.3.0 from source.
Postgresql 8.2.20: ./configure --prefix=/usr/local/postgresql-8.2.20
--with-perl --with-openssl --with
On Tue, Aug 09, 2011 at 10:04:41AM +0200, ml ml wrote:
> I am using postgres 8.2.20, postgis 1.4.2 and geos.3.3.0 from source.
...
> pg_restore: [archiver (db)] Error from TOC entry 43383; 1255 3510237
> FUNCTION st_isvalidreason(geometry) pgsql
> pg_restore: [archiver (db)] could not execute quer
Hello,
i am trying to restore a postgres dump on a freshly installed Debian
Squeeze Box.
I am using postgres 8.2.20, postgis 1.4.2 and geos.3.3.0 from source.
Postgresql 8.2.20: ./configure --prefix=/usr/local/postgresql-8.2.20
--with-perl --with-openssl --with-libxslt --with-libxml
Geos: ./conf