FYI - Futher reading about what the Cell Tower location table is

[stoner]

It's a cache of Cell Tower locations, if you look you will see a large batch of cell towers entries made at one time.

I'm still investigating my data but here is some further reading:

http://www.macgeekery.com/opinion/concerning_core_location_paranoia
https://alexlevinson.wordpress.com/2011/04/21/3-major-issues-with-the-latest-iphone-tracking-discovery/

[stoner]

Also the Cell Towers IDs/locations are only in the list once the table has a PRIMARY KEY (MCC, MNC, LAC, CI)) which is a Cell Towers ID.

So once you have the Cell tower location in your cache these are not requested again, until a certain period of time has elapsed, I would guess this is the 'years' worth of data people are seeing, henceI got a massive refresh of cell towers in a single day, home and to work.

So the only things that are tracked are you moving the first time into new areas.

[stoner]

What is more concerning is the WifiLocation table.

This is disabled in the application as released, but when it is enabled the table is bigger than the cell locations.

Also since WiFi points are turn on and off you get more coverage for the regular areas.

The locations of the Wifi seem to have greater accuracy.

The big question is this just a cache, or is this the iPhone finding new WiFi points and then location them via it's GPS?