gpsparse.py

from struct import *
def wkbToLatLng(coord):
    byt = bytearray.fromhex(coord)
    (d, t, lng, lat) = unpack('<?idd', byt)
    return {"lat": lat, "lng": lng}

points=[]
with open('gpsmerge.csv') as csvfile:
    reader = csv.DictReader(csvfile, delimiter=',')
    for row in reader:
        try:
            time = datetime.datetime.strptime(row['timestamp'][:19],"%Y-%m-%d %H:%M:%S")
        except:
            print(row['timestamp'])
        try:
            point = wkbToLatLng(row['point'])
        except: 
            print(row['point'])
        points.append({"ts": time, 
                       "point": point})
#sort
points = sorted(points, key=lambda k: k['ts']) 


lats = []
lngs = []
for p in points:
    lats.append(p['point']['lat'])
    lngs.append(p['point']['lng'])