[postgis-users] how to move geometries to a fraction of their position?

[Nicolas Ribot]

Hi,

Look at st_translate, st_scale and st_transcale.

Nicolas

On 5 November 2013 12:51, Pietro Rossin <pierigis at gmail.com> wrote:
> I have a geomedia mdb that I moved to postgis.
> All geometries (metric coordinates) are hundred times greater on x and y of
> what they should be..
> Let's say if a coordinate sould be 3,4 it indeed is 300,400. I don't know
> why..
>
> By the way, with point I updated the geometry column using this sql
> UPDATE mytable
>    SET geom= ST_SetSRID(st_makepoint(st_x(geom)/100,st_y(geom)/100),SRID)
>
> How can I perform this shifting with polylines and polygon?
> Thanks for any help
> Pietro
>
>
>
> --
> View this message in context: http://postgis.17.x6.nabble.com/how-to-move-geometries-to-a-fraction-of-their-position-tp5004728.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users