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 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
_______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
