It was Saturday, 9th May 2009 – and the weatherman had predicted mostly cloudy weather with highs of around upper 40s and Sun was expected to make a guest appearance or two. About halfway through our first practice session, weather conditions made a fool of weatherman’s prediction and fairy tale like snow flakes gave our [...]
You are currently browsing through the archives for August, 2009.
PHP – GPS Tracks In Google KML Format
Amongst other things, I have the habit of keeping a detailed track of where I have been and for this purpose, I use my Garmin GPSMap 60CSx. I have configured this GPS to save track information every 3 seconds. If this information can be written in KML format, then the tracks can be visualized using [...]
MySQL – Finding Locations Nearest To A Given Pair Of GPS Coordinates
Amongst other things, I have the habit of geotagging my photographs and for this purpose, I use my Garmin GPSMap 60CSx, an API I wrote to store tracks in MySQL & Geonames data in a MySQL [please refer to this if you wish to do so as well]. For completeness sake, the MySQL table structure [...]
PHP – Calculating Distance Between Two Locations Given Their GPS Coordinates
Amongst other things, I have the habit of geotagging my photographs and for this purpose, I use my Garmin GPSMap 60CSx, an API I wrote to store tracks in MySQL & Geonames data in a MySQL [please refer to this if you wish to do so as well]. For completeness sake, the MySQL table structure [...]
MySQL – Finding Nearest Record In Date/Time
Amongst other things, I have the habit of geotagging my photographs and for this purpose, I use my Garmin GPSMap 60CSx, an API I wrote to store tracks in MySQL & Geonames data in a MySQL [please refer to this if you wish to do so as well]. The work-flow might seem a bit complicated [...]


