And I can confirm it’s working correctly in 3.1.4dev! Nice! Thank you. -David
> On 21 Jul 2021, at 22:29, Paul Ramsey <[email protected]> wrote: > > Also I can run your SQL against my working copy and the right answer is there > > postgis32=# SELECT ST_AsText(ST_Transform('SRID=3006;POINT(675117 6580677)', > 4326)) ; > st_astext > --------------------------------------------- > POINT(18.078112692195987 59.32848233749213) > (1 row) > > > > On Wed, Jul 21, 2021 at 1:25 PM Paul Ramsey <[email protected] > <mailto:[email protected]>> wrote: > 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. > > P > > On Tue, Jul 20, 2021 at 5:12 PM David Stenwall <[email protected] > <mailto:[email protected]>> wrote: > Hi > Ok, so I _think_ I have the same issue as in > https://trac.osgeo.org/postgis/ticket/4949 > <https://trac.osgeo.org/postgis/ticket/4949> 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. > > 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. > > I’m using > "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" > > Example > > SELECT ST_AsText(ST_Transform('SRID=3006;POINT(675117 6580677)', 4326)) // > Sweden National Museum > > returns > > "POINT(62.973291540292465 4.080735770719003)” // Somewhere east of Africa > > That should be long/lat 18.078113 59.328482 according to epsg.io > <http://epsg.io/> > > 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? > > Regards > David > > _______________________________________________ > postgis-users mailing list > [email protected] <mailto:[email protected]> > https://lists.osgeo.org/mailman/listinfo/postgis-users > <https://lists.osgeo.org/mailman/listinfo/postgis-users> > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
