[postgis-tickets] [PostGIS] #2564: Implement the inverse of the ST_AsLatLonText function

[PostGIS]

#2564: Implement the inverse of the ST_AsLatLonText function
-------------------------+--------------------------------------------------
 Reporter:  andrewxhill  |       Owner:  pramsey      
     Type:  enhancement  |      Status:  new          
 Priority:  low          |   Milestone:  PostGIS 2.2.0
Component:  postgis      |     Version:  2.1.x        
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by dbaston):

 Interesting.

 I was getting hung up on how to write a format string that could handle
 undelimited versions of both

 99°59'59.999" and 100°00'00.000" ?

 It seems like you'd have to go with

 DMMSS.SSS : you specify the number of digits for minutes and seconds, and
 everything leftover on the left is taken to be degrees?  Minutes and
 seconds would have to be left-padded with zeros for correct
 interpretation...

 Of course, with input that rigid, it would be pretty easy to use a
 substring function to build the geometry too.  Just thinking out loud...

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2564#comment:7>
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.