[postgis-tickets] [PostGIS] #3468: ST_GeogFromText should swap longitude when latitude crosses 90 deg
PostGIS
trac at osgeo.org
Wed Feb 24 10:54:44 PST 2016
#3468: ST_GeogFromText should swap longitude when latitude crosses 90 deg
----------------------------+---------------------------
Reporter: tomvantilburg | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.2.2
Component: postgis | Version: 2.2.x
Resolution: | Keywords:
----------------------------+---------------------------
Comment (by munderwood):
I agree that the current behaviour poses a problem. Silently turning (10,
91) into (-170, 89) would definitely be better than turning it into (10,
89) as happens now.
An even better option might be to throw an error, preventing the
INSERT/UPDATE operation that is trying to set a latitude greater than 90.
Best of all would be if there were a flag with which the DBA could make
the choice of behaviour. Something like {{{SET out_of_range_latitudes TO
wrap|reject|reflect}}}, for example. (I personally don't see any reason to
have the "reflect" option for new databases, but it could be used in
existing databases for backward compatibility of behaviour.)
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3468#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list