Tag Archives: QGIS

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

Memorialisation of Tempelhofer Feld Outcomes I

For those of you waiting for the drawing I made together with students from the HZT BA Choreography course during our ‘Choreographing the City’ workshop, here is a preliminary outcome. Each student’s line is a different colour. It was quickly … Continue reading

Posted in Diary, GPS, Walking | Tagged , , , , | Comments Off on Memorialisation of Tempelhofer Feld Outcomes I

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