[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