Hi, To reverse geometry coordinates, use ST_FlipCoordinates or ST_SwapOrdinates
Nicolas On 17 November 2015 at 18:08, Paul Ramsey <[email protected]> wrote: > We Leave It To You, in that the ordering in the WKT will be reflective > of the ordering you've stored your data in. > However. > If you want to reproject or do any other Nice Things with your data, > store it in X/Y order. Otherwise you'll need a special spatial_ref_sys > entry for your data that indicates the axis ordering you've chosen, > using the +axis proj4 argument. > > http://gis.stackexchange.com/questions/6221/how-can-i-specify-a-proj-4-projection-with-the-north-pointing-down > By default we assume data in SRID 4326 (and other spherical systems) > are X/Y ordered. > P > > > On Tue, Nov 17, 2015 at 7:09 AM, Willy-Bas Loos <[email protected]> > wrote: > > Hi, > > > > I have a couple of questions about the order of lattitude and longitude > in > > WKT representations of geometries: > > > > Is there an objective reference that states in what order WGS84 > (geographic) > > coordinates should be represented in a WKT? Is it lon, lat (because of > x,y) > > or lat,lon (because it's geodetic) ? > > Does postgis use the correct representation? > > Is there a way to switch lat and lon for a polygon when representing as > WKT? > > All i think of is looping through all points, switching x and y and then > > returning astext(g) > > > > Cheers, > > > > -- > > Willy-Bas Loos > > > > _______________________________________________ > > postgis-users mailing list > > [email protected] > > http://lists.osgeo.org/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users
