[postgis-users] Update "spatial_ref_sys" with "+towgs84" parameters

Shane Spencer shane at bogomip.com
Mon Sep 10 09:12:14 PDT 2007


you could create a new entry, new srid, then update the geometry columns
table. I'm unsure on if you have to translate your data table to another
data table to update the srid per row/field.

I personally wouldn't modify any row of the spatial_ref_sys for
compatibility reasons.

Can you translate the coordinates after you query them and avoid updating
anything?

On 9/10/07, feurbano at clix.pt <feurbano at clix.pt> wrote:
>
> Hi,
> i need to update the epsg 23033 in spatial_ref_sys table adding the
> "+towgs84" parameters: (towgs84=-104.1,-49.1,-9.9,0.971,-2.917,0.714,-
> 11.68).
>
> do i have just to overwrite the original:
> "+proj=utm +zone=33 +ellps=intl +units=m +no_defs "
> with
> "+proj=utm +zone=33 +ellps=intl +units=m +no_defs +towgs84=-104.1,-49.1,-
> 9.9,0.971,-2.917,0.714,-11.68 "
> ?
>
> Thanks,
> Ferdinando
> ---- _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070910/d1dd1d2a/attachment.html>


More information about the postgis-users mailing list