<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Function to change order of lon/lat in WKT-string?</TITLE>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7601.17537"></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143534111-03032011>Well its a new function in the upcoming PostGIS 2.0,
but sadly doesn't exist in prior versions of PostGIS.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143534111-03032011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143534111-03032011><A
href="http://www.postgis.org/documentation/manual-svn/ST_FlipCoordinates.html">http://www.postgis.org/documentation/manual-svn/ST_FlipCoordinates.html</A></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143534111-03032011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143534111-03032011>If you don't have issues with running a not yet
released version of PostGIS, then you can use it.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143534111-03032011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143534111-03032011>Hope that helps,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143534111-03032011>Regina</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143534111-03032011><A
href="http://www.postgis.us">http://www.postgis.us</A></SPAN></FONT></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Swärd
Mårten<BR><B>Sent:</B> Thursday, March 03, 2011 4:14 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
Function to change order of lon/lat in WKT-string?<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-gb><FONT size=1 face=Verdana>Hello folks!</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-gb></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-gb><FONT size=1 face=Verdana>We</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1
face=Verdana>, an</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1
face=Verdana>d</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1 face=Verdana>
by</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-gb> <FONT size=1 face=Verdana>”</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1
face=Verdana>we</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1
face=Verdana>”</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1 face=Verdana></FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-gb> <FONT size=1
face=Verdana>I</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1 face=Verdana> mean the developer
team that I currently work in, are lookning f</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1
face=Verdana>o</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1 face=Verdana>r a
PostGIS-function that can</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb> <FONT size=1 face=Verdana>change the order
of the coordinates in a WKT-string</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1 face=Verdana>
(lat/lon)</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-gb><FONT size=1 face=Verdana> to the</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-gb> <FONT size=1
face=Verdana>“</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1
face=Verdana>correct</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1
face=Verdana>”</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1 face=Verdana> way (lon/lat).
</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-gb><FONT size=1 face=Verdana>1.</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-gb> <FONT size=1
face=Verdana>Is there such a function already in place? I can</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1
face=Verdana>’</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1 face=Verdana>t find
any..</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-gb></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT size=1 face=Verdana>2. If not, does anyone
know if its on it</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1
face=Verdana>’</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1 face=Verdana>s
way?</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb> <FONT
size=1 face=Verdana>2b.</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb> <FONT size=1 face=Verdana>If not.. Should we
try to create such a function</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1 face=Verdana> our
self</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-gb><FONT size=1 face=Verdana>? A</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-gb><FONT size=1
face=Verdana>nd is anyone else interested in this so we should try to commit it
in to PostGIS?</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-gb></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT size=1 face=Verdana>Best regards, Mårten
Swärd</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-gb></SPAN></P></BODY></HTML>