Hi, Look at st_translate, st_scale and st_transcale.
Nicolas On 5 November 2013 12:51, Pietro Rossin <[email protected]> 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 > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
