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 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 <ijtur...@gmail.com> wrote:
>
>
>
> 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 <http://www.catalyst.net.nz>
>
> 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
> <http://bit.ly/gs-services-us>for more information.==Ing.
> Andrea Aime @geowolfTechnical Lead
>
> GeoSolutions Groupphone: +39 0584 962313
>
> fax: +39 0584 1660272
>
> mob: +39 333 8128928
>
>
> https://www.geosolutionsgroup.com/
> <https://www.geosolutionsgroup.com/>
>
> http://twitter.com/geosolutions_it
> <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
>
>
>
> --
>
> Regards,
>
> Andrea Aime
>
> ==GeoServer Professional Services from the experts!
>
> Visit http://bit.ly/gs-services-us <http://bit.ly/gs-services-us>for
> more information.==Ing. Andrea Aime @geowolfTechnical Lead
>
> GeoSolutions Groupphone: +39 0584 962313
>
> fax: +39 0584 1660272
>
> mob: +39 333 8128928
>
>
> https://www.geosolutionsgroup.com/ <https://www.geosolutionsgroup.com/>
>
> http://twitter.com/geosolutions_it <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
--
*Glenn Walbran*
Software Developer
Catalyst IT - Expert Open Source Solutions
Mob: +64 21 211 1301 | Tel: +64 4 499 2267 | www.catalyst.net.nz
<http://www.catalyst.net.nz>
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
