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”

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”

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”

String2Image – A Web Utility To Convert Strings Into Graphics

Why Strings As Graphics, you ask? There are a myriad of reasons and/or applications where strings need to converted to graphics and one such, probably most commonly seen, application is to put our email address on the web. We want it there but we don’t want anyone (the bots) stealing it. If nothing else, this web based utility should help us a bit in that regard.

As I have done previously for other utilities – LaTeX2Graphics and KannadaLaTeX2Graphics – I have used Andreas Reigber‘s simple yet elegant (command line) utility called TeX2Im. Using this web-based utility is pretty simple. Just type-in (or paste) the string in the form and copy/save the graphic to your computer.

Continue reading … “String2Image – A Web Utility To Convert Strings Into Graphics”

WordPress – Plugin To Keep Track Of Visitors

I understand there are very many plugins available for WordPress that help keep track of a variety of stats. This one, wp-visitors, is simple and light-weight. Myself and couple friends (Adam & Karen and Tim Obermann) have been using it without any trouble – in some form or the other – for over a year now. I am sure this plugin will see further updates – a few bells and whistles (geographical resolution of IP address), etc. As with all WordPress hosted plugins, this too is released under GPL. So, if you like it and like to make it better, please be my guest 🙂

Continue reading … “WordPress – Plugin To Keep Track Of Visitors”

WordPress – Legacy of comments.php For 2.7 And Beyond

During the State Of The Word address in not-so-recently held WordCamp New York, Matt Mullenweg gave a sneak preview of a plethora of new (and cool) features being included into the next WordPress release (2.7). I had since then been toying around with the almost ? version (of nightly builds) for a while and now that it is in ? stage, I believe I can discuss one of the really cool features and some code-change required to make some pre-2.7 themes incorporate it.

Continue reading … “WordPress – Legacy of comments.php For 2.7 And Beyond”

PHP – Displaying Gravatars In A Non-WordPress Application

Citing their website, an Automattic.com joint:,

A gravatar, or globally recognized avatar, is quite simply an avatar image that follows you from weblog to weblog appearing beside your name when you comment on gravatar enabled sites. Avatars help identify your posts on web forums, so why not on weblogs?

It’s free and with one account, one can register and assign multiple email address the same (or different) avatar(s).

Continue reading … “PHP – Displaying Gravatars In A Non-WordPress Application”

WordPress – Different Sidebars In Different Places

It might, at some point in a WordPress powered blog, become necessary to a show some widgets/stuff in some places (the main page, archives, etc.) while show a different set of widgets/stuff in some other places (static pages – about me, product reviews, etc.). To keep track of things and may be understand the process better, let us suppose that only those pages written in Product Reviews Template will use a different sidebar (Sidebar #2) while rest of the blog uses a common sidebar (Sidebar #1). Thanks to my dear friend, Amy – if not for her, I probably would have never learned about this hack.

Continue reading … “WordPress – Different Sidebars In Different Places”