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

[Pietro Rossin]

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.