[postgis-users] postgis help!!

Bruce Rindahl rindahl at lrcwe.com
Tue May 16 10:01:58 PDT 2006


Is it in the envelope function or the translate function?
Bruce

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
strk at refractions.net
Sent: Tuesday, May 16, 2006 11:00 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] postgis help!!

I confirm there's a bug here (1.1.2 included).
I'm working on it.

--strk;

On Tue, May 16, 2006 at 10:14:10AM -0600, Michael Fuhr wrote:
> On Tue, May 16, 2006 at 11:55:46AM +0100, Mark Cave-Ayland wrote:
> > Could you post to the list a self-contained SQL test case to recreate
your
> > problem? Also you say that you are using the latest versions - can you
> > confirm those are both PostgreSQL 8.1 and PostGIS 1.1.2 using SELECT
> > version() and SELECT postgis_full_version()?
> 
> This looks like what Brent describes:
> 
> CREATE TABLE foo (id serial PRIMARY KEY);
> SELECT AddGeometryColumn('foo', 'geom', -1, 'GEOMETRY', 2);
> INSERT INTO foo (geom) VALUES (GeomFromText('LINESTRING(-177 -44,-176
-43)'));
> UPDATE foo SET geom = Translate(geom, 360.0, 0.0, 0.0);
> SELECT AsText(geom), AsText(Envelope(geom)) FROM foo;
>            astext            |                         astext

>
-----------------------------+----------------------------------------------
-----------
>  LINESTRING(183 -44,184 -43) | POLYGON((-177 -44,-177 -43,-176 -43,-176
-44,-177 -44))
> (1 row)
> 
> Does Translate() neglect to update the bounding box?
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users




More information about the postgis-users mailing list