View Single Post
gnuite's Avatar
Posts: 1,245 | Thanked: 421 times | Joined on Dec 2005
#551
Originally Posted by oilinki View Post
I wish to export recorded tracks automatically from Maemo-Mapper (2.4.1-os2008) and place the tracks on an web page so that I could see those later on with google-maps.

This is possible to do manually, saving tracks from the mapper application (Tracks -> Save) and then converting the gpx tracks with gpsbabel to kml.

But. I wish the device to do this automatically when I connect to my home network.

With sqlplus I can get the data out, but in the format that I do not recognize.

tracks$ echo "select * from track_path;" | sqlite3 -csv paths.db | head
1,0,0,0,0
2,418612967,247747092,1216545784,5
3,418612989,247747075,1216545788,3
4,418612997,247747044,1216545790,3
5,418613009,247747016,1216545792,2

What is this format and how to convert it to gpx or kml format. Or at least, is there an easy way to convert it to lat/lon/alt format? I would prefer to use gpsbabel for the conversion.

Thanks for your help.

An example of the manually exported track. This can be really helpfull when looking at the new places.

http://maps.google.com/maps?q=http:/...sericenter.kml

Br, Pekka
Each row in the table contains three integers:
1. Point number (monotonically increasing counter, basically)
2. "unitx"
3. "unity"
4. Timestamp (seconds since epoch)
5. Altitude (in meters)

"unitx" and "unity" are Maemo Mapper's way of modeling latitude and longitude. Take a look at the unit2latlon macro in defines.h for the code that translates from unitx/unity to lat/lon.