[UPDATE: Check out the latest installment, "iPhone/SpyPhone?—The Music Video!", with a soundtrack by David Byrne. You can also download a higher-res version of the video, my code changes for Pete Warden's iPhoneTracker, a prebuilt version of iPhoneTracker like the one I used to make the video, and a complete copy of The Wired CD, with a bunch of great, Creative Commons-licensed tunes from David Byrne, Spoon, Gilberto Gil, the Beastie Boys and many others for you to rip, reuse and remix! Read this post now, or weep tears the size of October cabbages later!]
[UPDATE: I've taken a closer look at the data by dumping out the database's CellLocation table to a spreadsheet, and mapping it over time. I've made a copy of the spreadsheet with the data available for download. See here for details.]
There’s been a lot of discussion of the discovery that there’s a database file called “consolidated.db” on your iPhone, full of latitude and longitude coordinates. Most of it has been completely hysterical, and not based on an actual look at the data involved.
I downloaded Peter Warden’s iPhoneTracker program, as well as the source code for it, and played around with it a good bit yesterday. I’m not done—I haven’t done a raw dump of the locations in the file yet—but I’ve been able to determine several things, the most important of which is that the iPhone is not “tracking your every move”, by any stretch of the imagination.
The default version of the program deliberately muddies the location by restricting the locations to a certain level of precision, and also aggregates its data by week. I modified it to increase that resolution by ten times, and to aggregate the data on an daily, rather than a weekly basis. I discovered a number of interesting things.
First, note that there’s a slider along the bottom of the window, which is set to the extreme right, to show all locations no matter when they were collected. On the left side of the slider, there’s a “Play” button, which will animate the locations captured. You can also drag the slider’s “thumb” to see the data for an individual week (in the default version) or day, in my modified version.
Pete Warden’s iPhoneTracker program can be found here. If anyone wants to reproduce the various tweaks I made to adjust the location and time resolution to be finer, drop me a note, and I’ll get you some details.
First, here’s a map of Amsterdam, showing every single location it collected there during my time there last July 23. As you can see, for 24 hours time, it’s not showing very much detail at all as far as my movements go.
Second, here’s a shot showing all of the data for the following day, July 24. I spent that day in Amsterdam until the late afternoon, when I took a train down to Den Haag:
As you can see pretty clearly, my ride on a train between Amsterdam and Den Haag is not depicted with even the slightest degree of fidelity or accuracy.
I’ve noticed that the amount and timing of the data collected is very odd as well: I’ve got multi-day gaps in the data, as long as almost two weeks on one occasion. Some days’ data clearly contains information that couldn’t possible have been collected on that day.
A good example is the set of locations dated Christmas Day of last year:
I was in the Central Valley, in Le Grand (about 15 miles south of Merced) all day Christmas Day and I never left the house. Not only does this show locations stretching from Santa Cruz in the West to Merced in the East (a distance of some 130-140 miles), but it shows movement up and down I5 for a distance of about 80 miles or so.
So, it’s entirely unclear to me what this data actually represents. What it most certainly doesn’t represent is the phone’s “tracking your every move” as the histrionic writers at Wired and The Atlantic would like you to think…
[UPDATE: Exactly the same kind of information seems to be getting stored on Android phones. Here's an application you can use to dump it out...]
[UPDATED UPDATE: I've put up a follow-on posting, with some additional interesting information...]












