[postgis-users] ST_overlap problem

[Paul Ramsey]

ST_Overlaps has a very particular meaning (partly in, partly out). Do  
you mean ST_Intersects (which is equivalent to NOT ST_Disjoint()) ?
P

On 17-Oct-07, at 7:01 AM, Jørn Vegard Røsnes wrote:

> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users