<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">And I can confirm it’s working correctly in 3.1.4dev! Nice! Thank you.<div class=""><br class=""></div><div class="">-David<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 21 Jul 2021, at 22:29, Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca" class="">pramsey@cleverelephant.ca</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Also I can run your SQL against my working copy and the right answer is there<br class=""><br class="">postgis32=# SELECT ST_AsText(ST_Transform('SRID=3006;POINT(675117 6580677)', 4326)) ;<br class=""> st_astext <br class="">---------------------------------------------<br class=""> POINT(18.078112692195987 59.32848233749213)<br class="">(1 row)<br class=""><br class=""><br class=""></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jul 21, 2021 at 1:25 PM Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca" class="">pramsey@cleverelephant.ca</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr" class=""><div class="">The fix is not in any released version yet. If you pull the code from git and build you can confirm it works for your case (I'm going to guess that it will, your description matches the other N/E systems.</div><div class=""><br class=""></div><div class="">P<br class=""></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jul 20, 2021 at 5:12 PM David Stenwall <<a href="mailto:david.stenwall@icloud.com" target="_blank" class="">david.stenwall@icloud.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class=""><div dir="auto" class="">Hi</div><div dir="auto" class="">Ok, so I _think_ I have the same issue as in <a href="https://trac.osgeo.org/postgis/ticket/4949" target="_blank" class="">https://trac.osgeo.org/postgis/ticket/4949</a> since Sweref99 is also an N/E-type projection, also the National Projection of Sweden. I tried updating to 3.1.3 but no success.</div><div dir="auto" class=""> <br class=""><div class="">I’m using ST_Transform to convert between lat/long and Sweref99 but the axis get reversed and a point in sweden ends up in the Indian ocean.</div><div class=""><br class=""></div><div class="">I’m using</div><div class="">"POSTGIS=""3.1.3 008d2db"" [EXTENSION] PGSQL=""130"" GEOS=""3.9.1-CAPI-1.14.2"" PROJ=""7.2.1"" LIBXML=""2.9.10"" LIBJSON=""0.15"" LIBPROTOBUF=""1.4.0"" WAGYU=""0.5.0 (Internal)"" TOPOLOGY"</div><div class=""><br class=""></div><div class="">Example</div><div class=""><br class=""></div><div class="">SELECT ST_AsText(ST_Transform('SRID=3006;POINT(675117 6580677)', 4326)) // Sweden National Museum</div><div class=""><br class=""></div><div class="">returns</div><div class=""><br class=""></div><div class="">"POINT(62.973291540292465 4.080735770719003)” // Somewhere east of Africa</div><div class=""><br class=""></div><div class="">That should be long/lat 18.078113 59.328482 according to <a href="http://epsg.io/" target="_blank" class="">epsg.io</a></div><div class=""><br class=""></div><div class="">So am I missing something or is the fix in 3.1.3 not working or is this a similar problem but not the same thing?</div><div class=""><br class=""></div><div class="">Regards</div><div class="">David</div><div class=""><br class=""></div></div></div>_______________________________________________<br class="">
postgis-users mailing list<br class="">
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" class="">postgis-users@lists.osgeo.org</a><br class="">
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank" class="">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br class="">
</blockquote></div>
</blockquote></div>
_______________________________________________<br class="">postgis-users mailing list<br class=""><a href="mailto:postgis-users@lists.osgeo.org" class="">postgis-users@lists.osgeo.org</a><br class="">https://lists.osgeo.org/mailman/listinfo/postgis-users<br class=""></div></blockquote></div><br class=""></div></body></html>