PHP – Computing Total Travel Distance From GPS Tracks

Amongst other things, I like to keep a detailed track of where I have been [especially during hiking in the woods, venturing into areas that I have never been before, etc.]. For this purpose, I have configured my Garmin GPSMap 60CSx to record location/date-time data every three seconds and a while ago, I described another API I wrote to store these track points in MySQL. Added advantage of this, as I have mentioned before in previous posts, is that it can be used for geotagging my photographs. For completeness sake, the MySQL table structure that holds track data is given below:

Continue reading … “PHP – Computing Total Travel Distance From GPS Tracks”

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 that holds Geonames data is given below:

Continue reading … “MySQL – Finding Locations Nearest To A Given Pair Of GPS Coordinates”

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 that holds Geonames data is given below:

Continue reading … “PHP – Calculating Distance Between Two Locations Given Their GPS Coordinates”

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 but from a personal perspective, it’s very much worth the effort. My camera and GPS unit are in sync with respect to time – enabling me to easily locate the GPS coordinates nearest in time to a photograph’s time-stamp – and, I can then use those GPS coordinates to look up the Geonames data [stored in my local MySQL database] and get details regarding the country, region/state, city/town/village. Once these details, they can be written into EXIF.

Continue reading … “MySQL – Finding Nearest Record In Date/Time”

Importing Geonames.org Data Into MySQL

What is Geonames.org, you wonder? It’s a website [or an web-institution, if you like to phrase it that way] that provides – amongst other things – [pretty] useful information that maps geological data [country, region, city/town/village, etc.] to the GPS coordinates. The one database that I personally use corresponds to allCountries [download size is about 170MB ; requires about 800MB upon uncompressing it].

Continue reading … “Importing Geonames.org Data Into MySQL”

PHP – Storing GPS Track Points In MySQL

Garmin GPSMap 60CSxThough the term waypoint has come into fairly common use in recent times, the concept has existed for as long as we have been navigating. Waypoints have traditionally been associated with distinctive features of the physical world – such as mountains, rock formations, lakes, buildings, and so on. With the advancement of technology and times, waypoints have become increasingly abstract, often having no obvious relationship to any distinctive feature of the physical world. Such waypoints are used to define invisible routing paths for navigation. And for the sake of this discussion/article, we will stick to the following definition of a waypoint: a set of co-ordinates – latitude & longitude, and sometimes altitude – to uniquely identify a point in our physical universe.

Continue reading … “PHP – Storing GPS Track Points In MySQL”

PHP – Storing GPS Waypoints In MySQL

Garmin GPSMap 60CSxThough the term waypoint has come into fairly common use in recent times, the concept has existed for as long as we have been navigating. Waypoints have traditionally been associated with distinctive features of the physical world – such as mountains, rock formations, lakes, buildings, and so on. With the advancement of technology and times, waypoints have become increasingly abstract, often having no obvious relationship to any distinctive feature of the physical world. Such waypoints are used to define invisible routing paths for navigation. And for the sake of this discussion/article, we will stick to the following definition of a waypoint: a set of co-ordinates – latitude & longitude, and sometimes altitude – to uniquely identify a point in our physical universe.

Continue reading … “PHP – Storing GPS Waypoints In MySQL”

Garmin GPSMap 60CSx – My New Travel Companion

It was a mid Summer early afternoon – 07.07.07 to be precise – that I was out in the Silver Mountains area searching for a much sought after (by myself) Sturgeon Falls/Gorge. The parking area and trail head were very well marked but the trail itself disappeared after about 300 feet into the woods. Fortunately, I found some broken tree branches and bent plants (signs of human activity) and managed to get to a (not very useful) sign. It only said which way one should go but didn’t say how far one should go! Although the trail was quite wide (an old logging road), but plant growth was in abundance hinting dearth of human activity in this area. After walking for nearly a mile and not knowing how far I had to go (I wasn’t hearing any water sound either), I decided to return back to the parking area. It was then that my proud mapping/hiking skills left me high and dry – leaving me lost for about (what seemed like the longest) 30 minutes (of my life) before eventually finding the trail. But for my Swiss Army Knife, I probably would have been part of Upper Michigan’s wilderness forever!!

Continue reading … “Garmin GPSMap 60CSx – My New Travel Companion”