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”

Subversion – Backing Up Repository

Subversion Subversion (SVN) is a version control system initiated in 2000 by CollabNet Inc. It is used to maintain current and historical versions of files such as source code, web pages, and documentation. Its goal is to be a mostly-compatible successor to the widely used Concurrent Versions System (CVS). Subversion is well-known in the open source community and is used on many open source projects.

Subversion was started in 2000 as an effort to write a free version control system which operated much like CVS but with fixed bugs and misfeatures in CVS. By 2001, Subversion was sufficiently developed to be capable of hosting its own source code. More information, including this above paragraph, is here.

Continue reading … “Subversion – Backing Up Repository”

Heading Home

As I may [not] have mentioned, I have been on the move for the last 8 days or so. Unlike the last time I moved, I took enough time to plan out the journey as much as possible. If you are short of time, just know that I am now in the same place where my heart & soul are and that the 1600 mile journey from the Garden State to Great Lakes State was smoother than I had anticipated. But if you do have time, then read on 🙂

Continue reading … “Heading Home”

New Jersey – It Ain’t Just About Turn Pike And Parkway

As the only new state that is old enough to be called only by its last name and still make the exact same sense [think about it – New Hampshire, New Mexico, New York all still need the New specification], it gets a lot of bad rap for more than one reason: for much of the rest of the country, it’s a piece of land that follows New York City during day time and takes a backseat to Philadelphia around/after sunset; if you ask the residents of Jersey City and Camden, they probably would rather be considered as suburbs of New York City and Philadelphia than a part of New Jersey; for most New Yorkers and Philadelphians, it’s an unnecessary clump of landmass that adds 100+ miles to the commute between their respective cities [ask the Giants/Eagles fans, or the Mets/Phillies faithfuls, if you don’t want to trust me].

Continue reading … “New Jersey – It Ain’t Just About Turn Pike And Parkway”

Git – Migrating From Subversion

Git Citing their website, Git is a free & open source, distributed version control system designed to handle everything from small to very large projects with speed and efficiency. Every Git clone is a full-fledged repository with complete history and full revision tracking capabilities, not dependent on network access or a central server. Branching and merging are fast and easy to do. Git is used for version control of files, much like tools such as Mercurial, Bazaar, Subversion, CVS, Perforce, and Visual SourceSafe.

Continue reading … “Git – Migrating From Subversion”