Python - Batch convert GPS positions to Lat Lon decimals

coordinate-transformation, coordinates, gps, python

Solution

This approach can deal with seconds and minutes being absent, and I think handles the compass directions correctly:

# -*- coding: latin-1 -*-

def conversion(old):
    direction = {'N':1, 'S':-1, 'E': 1, 'W':-1}
    new = old.replace(u'°',' ').replace('\'',' ').replace('"',' ')
    new = new.split()
    new_dir = new.pop()
    new.extend([0,0,0])
    return (int(new[0])+int(new[1])/60.0+int(new[2])/3600.0) * direction[new_dir]

lat, lon = u'''0°25'30"S, 91°7'W'''.split(', ')
print conversion(lat), conversion(lon)
#Output:
0.425 91.1166666667

Problem

Hi I have a legacy db with some positional data. The fields are just text fields with strings like this `0°25'30"S, 91°7'W`. Is there some way I can convert these to two floating point numbers for `Decimal Latitude` and `Decimal Longitude`? EDIT: So an example would be: `0°25'30"S, 91°7'W` -> `0.425`, `91.116667` where the original single field position yields two floats. Any help much appreciated.

Original source