[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