[postgis-users] ST_overlap problem

[Jørn Vegard Røsnes]

On Wednesday 17 October 2007 18:24, Paul Ramsey wrote:
> ST_Overlaps has a very particular meaning (partly in, partly out). Do
> you mean ST_Intersects (which is equivalent to NOT ST_Disjoint()) ?
> P
>

Thanks.
I had to do my homework :-)
By reading something like this
http://edndoc.esri.com/arcsde/9.1/general_topics/understand_spatial_relations.htm

cheers
Jørn Vegard

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