Messages and GPX

I found gpsvisualiser.com a nice web site to convert my .GPX files from my Garmin hand-held GPS into lines on Google maps and Google Earth. I posted the results from Saturday and Monday separately in the Bumbershoot music posts. If I was better with HTML and on the right web sight I could embed the working widget.

GPX files define a path made up of multiple tracks. I hand coded a script to create path, track and point tables in the Informix database. The latitude and longitude values use 8 digits after the decimal point, up to +/-180 in the integer part. 32 bits overflows, so you either have to shoehorn it into 32 bits (throw out the last digit), or save 2 numbers, a 32 bit fraction and an integer portion.

I coded up some python to decode the .GPX files and write the results to the database tables I created. After some debugging and fiddling I got that working.

Next I need to write a script that takes each message and searches the points for the closest prior and after and all points that "hit" during the message. Add code to extrapolate new start and end points between the prior and first points based on how close the time is to each point. You now have 2 or more points for each message - the location in time and space of the recording, tot he best of our ability. Now output a new Google Earth script embedded in an HTML doc showing the map with adornments for the messages linking them to the map UI.