Re: [Geotools-devel] PostGIS axis order

2022-05-03 Thread Glenn Walbran via GeoTools-Devel
I've created https://github.com/geotools/geotools/pull/3873 to fix the original issue reported. One of the downstream geoserver tests is failing. ResourcePoolTest.testConcurrencyOnFeatureTypeCache() which looks like it would be unrelated. On 4/05/22 09:23, Glenn Walbran via GeoTools-Devel wrote:

Re: [Geotools-devel] PostGIS axis order

2022-05-03 Thread Glenn Walbran via GeoTools-Devel
Thanks for the responses. I've worked through the test changes now and they aren't too bad. I hope to have a PR for this soon. Cheers Glenn On 3/05/22 20:23, Andrea Aime wrote: > It applies to any CRS that has a North/East definition in the EPSG > database... all geographic ones do AFAIK, but

Re: [Geotools-devel] PostGIS axis order

2022-05-03 Thread Andrea Aime
It applies to any CRS that has a North/East definition in the EPSG database... all geographic ones do AFAIK, but also a number of projected ones, e.g. this one is oriented south/west: https://epsg.org/crs_2065/S-JTSK-Ferro-Krovak.html Cheers Andrea On Tue, May 3, 2022 at 10:11 AM Ian Turton

Re: [Geotools-devel] PostGIS axis order

2022-05-03 Thread Ian Turton
On Tue, 3 May 2022 at 09:07, Andrea Aime wrote: > The report is legit, the CRS attached from a GeoTools out of the box has a > lat and lon order, while ordinates > in the database are indeed always stored in lon/lat. > In GeoServer we never see the issue because we use the sysvar to force the >

Re: [Geotools-devel] PostGIS axis order

2022-05-03 Thread Andrea Aime
The report is legit, the CRS attached from a GeoTools out of the box has a lat and lon order, while ordinates in the database are indeed always stored in lon/lat. In GeoServer we never see the issue because we use the sysvar to force the lon/lat order system wide. >From a practical application

Re: [Geotools-devel] PostGIS axis order

2022-05-03 Thread Ian Turton
I'd always assumed that the order the axes are stored in the database was irrelevant to the end user and the datastore should honour the CRS requested. I've certainly never needed to force an axis order when using PostGIS stores. Do you have a specific case where this isn't working that we can

Re: [Geotools-devel] PostGIS axis order

2022-05-03 Thread Andrea Aime
On Tue, May 3, 2022 at 6:07 AM Glenn Walbran via GeoTools-Devel < geotools-devel@lists.sourceforge.net> wrote: > Hello Geotools developers > > I've recently noticed that when reading data from PostGIS with > PostgisNGDataStoreFactory the feature source has a CRS with a YX axis order. > > My