[postgis-users] ST_overlap problem
Jørn Vegard Røsnes
jorn at spacetec.no
Wed Oct 17 07:01:06 PDT 2007
Hi,
I have just upgraded my database with the following
PostgreSQL 8.1.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (pre
3.3.5 20040809)
Postgis 1.3.1 - 2007-10-17 12:46:11
GEOS: 3.0.0rc4-CAPI-1.3.3
PROJ: Rel. 4.5.0, 22 Oct 2006
The problem is that ST_overlap doesn't seems to work
select st_overlaps (GeomFromText('POLYGON((-27.7124 86.6147,39.5851
86.6147,39.5851 26.4173,-27.7124 26.4173,-27.7124 86.6147))',4326), geom)
from dataset;
st_overlaps
-------------
f
f
(2 rows)
select astext(geom) from dataset;
astext
-----------------------------------------------------------------------------------------------
POLYGON((18.1855 58.0681,11.2994 57.2716,12.9173 53.8532,19.2302
54.6196,18.1855 58.0681))
POLYGON((-3.81808 50.6748,-9.6857 51.425,-10.5383 48.1472,-5.04416
47.4111,-3.81808 50.6748))
(2 rows)
From \d dataset:
Check constraints:
"enforce_dims_geom" CHECK (ndims(geom) = 2)
"enforce_geotype_geom" CHECK (geometrytype(geom) = 'POLYGON'::text OR geom
IS NULL)
"enforce_srid_geom" CHECK (srid(geom) = 4326)
As far as I can see, the first query should have returned true for both
datasets.
Can someone see the problem?
kind regards
Jørn Vegard
More information about the postgis-users
mailing list