I inherited two tables like so
db=# select ST_Extent(the_geom) from t1;
st_extent
-------------------------------------------------
BOX(-180 5.67656603969958,180 89.9999951703269)
(1 row)
db=# select ST_Extent(the_geom) from t2;
st_extent
-----------------------------------------------------------
BOX(-3666182.8927 1296299.9824,4440422.8742 8820425.3008)
(1 row)
I want to convert t2 to match t1. So, I tried the following --
db=# UPDATE t2 SET the_geom = ST_Transform(the_geom, 4326);
UPDATE 1354
But that didn't do it.
db=# select ST_Extent(the_geom) from t2;
st_extent
-----------------------------------------------------------
BOX(-3666182.8927 1296299.9824,4440422.8742 8820425.3008)
(1 row)
What do I do to transform t2 so its geometry matches t1?
--
Puneet Kishor
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
