<div dir="ltr">Also I can run your SQL against my working copy and the right answer is there<br><br>postgis32=# SELECT ST_AsText(ST_Transform('SRID=3006;POINT(675117 6580677)', 4326)) ;<br> st_astext <br>---------------------------------------------<br> POINT(18.078112692195987 59.32848233749213)<br>(1 row)<br><br><br></div><br><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">pramsey@cleverelephant.ca</a>> wrote:<br></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"><div>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><br></div><div>P<br></div></div><br><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">david.stenwall@icloud.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div dir="auto">Hi</div><div dir="auto">Ok, so I _think_ I have the same issue as in <a href="https://trac.osgeo.org/postgis/ticket/4949" target="_blank">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"> <br><div>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><br></div><div>I’m using</div><div>"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><br></div><div>Example</div><div><br></div><div>SELECT ST_AsText(ST_Transform('SRID=3006;POINT(675117 6580677)', 4326)) // Sweden National Museum</div><div><br></div><div>returns</div><div><br></div><div>"POINT(62.973291540292465 4.080735770719003)” // Somewhere east of Africa</div><div><br></div><div>That should be long/lat 18.078113 59.328482 according to <a href="http://epsg.io" target="_blank">epsg.io</a></div><div><br></div><div>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><br></div><div>Regards</div><div>David</div><div><br></div></div></div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote></div>
</blockquote></div>