On Dec 18, 2009, at 6:52 PM, Anthony McClure wrote:
Hi,
I have a problem that I cannot find a solution to. I have the X and
Y coordinates reversed in
the geometries within my database. I need the X's to become Y's and
the Y's to become X's.
The geometries are all polygons or multi-polygons. Is there
anything within PostGIS I can
execute SQL wise to do this?
That's a pure hack (never been designed for this)
But if you have SVN PostGIS (with libxml2) :
SELECT st_astext(st_geomfromgml(st_asgml(3, st_astext('POINT(1 0)'),
8, 16)));
Will output:
POINT(0 1)
--
Olivief
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
