[postgis-users] lat,lon or lon,lat in WGS84 WKT

[Nicolas Ribot]

Hi,

To reverse geometry coordinates, use ST_FlipCoordinates or ST_SwapOrdinates

Nicolas

On 17 November 2015 at 18:08, Paul Ramsey <pramsey at cleverelephant.ca> 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 <willybas at gmail.com>
> 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
> > postgis-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151117/7a602de3/attachment.html>