On Tue, 3 May 2022 at 09:07, Andrea Aime <andrea.a...@geosolutionsgroup.com> 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 > lon/lat order system wide. > So this only applies to 4326? that may explain why I've never seen it as I rarely map using that CRS. Ian > > From a practical application point of view using GeoTools, usage might be > fine due to other bits also using flipped axis > and seeing no need for reprojection, but I'd guess a stand alone viewer > reprojecting from 4326 in UTM or web mercator > might end up showing a flipped map. > > There is a very old ticket about it, still open: > https://osgeo-org.atlassian.net/browse/GEOT-2063 > > Cheers > Andrea > > > On Tue, May 3, 2022 at 9:46 AM Ian Turton <ijtur...@gmail.com> wrote: > >> 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 see? >> >> Ian >> >> On Tue, 3 May 2022 at 05:07, 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 understanding is that PostGIS uses an XY axis order. >>> >>> This is of course having a bad affect on the location of those features. >>> >>> My plan was to override createCRS() in PostGISDialect and call >>> CRS.decode with forceXY set. This is a simple enough fix but I thought I'd >>> canvas views from the developer group first. It looks like there would be >>> quite a bit of churn in the tests go along with this change. >>> >>> My assumption is that other users of PostgisNGDataStoreFactory get the >>> right result by setting the global forceXY properties, but sadly that isn't >>> an option in my case. >>> >>> Regards >>> >>> Glenn >>> -- >>> *Glenn Walbran* >>> Software Developer >>> >>> Catalyst IT - Expert Open Source Solutions >>> Mob: +64 21 211 1301 | Tel: +64 4 499 2267 | www.catalyst.net.nz >>> >>> [image: Catalyst Logo] >>> >>> CONFIDENTIALITY NOTICE: This email is intended for the named recipients >>> only. It may contain privileged, confidential or copyright information. If >>> you are not the named recipient, any use, reliance upon, disclosure or >>> copying of this email or its attachments is unauthorised. If you have >>> received this email in error, please reply via email or call +64 4 499 2267. >>> _______________________________________________ >>> GeoTools-Devel mailing list >>> GeoTools-Devel@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/geotools-devel >>> >> >> >> -- >> Ian Turton >> _______________________________________________ >> GeoTools-Devel mailing list >> GeoTools-Devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/geotools-devel >> > > > -- > > Regards, > > Andrea Aime > > == > GeoServer Professional Services from the experts! > > Visit http://bit.ly/gs-services-us for more information. > == > > Ing. Andrea Aime > @geowolf > Technical Lead > > GeoSolutions Group > phone: +39 0584 962313 > > fax: +39 0584 1660272 > > mob: +39 333 8128928 > > https://www.geosolutionsgroup.com/ > > http://twitter.com/geosolutions_it > > ------------------------------------------------------- > > Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE > 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si > precisa che ogni circostanza inerente alla presente email (il suo > contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è > riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il > messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra > operazione è illecita. Le sarei comunque grato se potesse darmene notizia. > > This email is intended only for the person or entity to which it is > addressed and may contain information that is privileged, confidential or > otherwise protected from disclosure. We remind that - as provided by > European Regulation 2016/679 “GDPR” - copying, dissemination or use of this > e-mail or the information herein by anyone other than the intended > recipient is prohibited. If you have received this email by mistake, please > notify us immediately by telephone or e-mail > -- Ian Turton
_______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
