Tag Archives: Spatialite

Using Spatialite to store and represent our GPX data

Background A quick bit of background. As people who read this blog know, we have recorded every journey we make, every day, with a GPS since 2003 (Dan) and 2007 (Sophia). As you can imagine, this practice has evolved technologically … Continue reading

Posted in Code, Diary, GPS, Linux, Python, Software | Tagged , , , , , , , , , , , , , , , , | 1 Comment

Missing Journeys

In making the graph above, showing all our journeys for the years 2007 – 2012 (D is Dan, S is Soph, numbers on the ‘y’ axis are thousands of km), I used a custom-written piece of python software which detects … Continue reading

Posted in Code, GPS, Python, Software, Walking | Tagged , , | Comments Off on Missing Journeys

The problems with representing GPX tracks in spatial databases

This is something I’ve been wrestling with for a while, both with Spatialite and latterly with Postgis. The problems stem from the fact that a GPX track segment contains information that can be represented in two entirely different ways in … Continue reading

Posted in Diary, GPS, Software | Tagged , , , , , , , | 1 Comment