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