[postgis-users] modifying xy coordinates in the geom column
Aaron Licker
aaronlicker at shaw.ca
Thu Jun 22 13:46:59 PDT 2006
Hi all,
I am trying to offset some point data that has been snapped to some lines.
Ideally a point that is on a vertical line would get offset in the x direction by 2m and in the y direction by 2m if it has an even address etc.
i am running a query such as:
update sketch_bars set the_geom = geomfromtext('POINT((x(the_geom)+2) (y(the_geom)+2))',32190) where "id" = 458
but of course i get the
ERROR: parse error - invalid geometry
any help would be much appreciated,
Aaron
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060622/81576c07/attachment.html>
More information about the postgis-users
mailing list