After a lot of complicated file manipulations, the data is in a format or better in a location or just is set up to be usable. Well, it is not exactly complicated to handle the data, I was just not quite sure how best to store it. The main problem is the date format, a misinterpretation seems to happen during one of the steps, still have to figure out where exactly.
So it took a few trial and error investigations to figure out what might be usable. The solution for the moment is gpx to csv to database and then to put into Google Earth or GeoTime it has to go back into a csv to Excel.
So from Excel it can simply be linked to GeoTime. While installing GeoTime it will automatically install the GeoTime Excel Plug-In that can then be use to link the open spreadsheet to GeoTime. There is a setup to be made but this is rather straightforward, basically telling GeoTime which column of the spreadsheet contains what kind of information. Several different settings can be saved for later use, which is great, as it is likely that the same source will be used a number of times. Then the data is in GeoTime after some processing.

Image by urbanTick – Screen shot from GeoTime
Funny enough, this time the meeting query tool works. After failing to use it in my first go with the Plymouth365 data, I was tempted to get this to work with the new UD data set. And there you go it worked right away. I guess I was just not patient enough with the larger PLY365 set, it probably just takes long, longer than I was willing to wait….
Anyway, interesting who has meet during this first week of data collection. Surprisingly, some people who do not know one another have actually met within a few minutes time difference in the same location. According to the data they just crossed path briefly, but still.



Screen shots from GeoTime, showing meetings in space and time – by urbanTick
Telling from those screen shots, GeoTime’s ability to output information apart from the screen is pretty bad. As a designer and visual person I want much more control over this than this program offers. It is essentially a screen shot in png format. It should at least offer an option to output some vector format to allow further use and especially endless sizing options.
Read More