consolidated.db

[zenzen]

In the postfile section (http://www.wigle.net/gps/gps/main/postfile), it says:

Consolidated.db: This is an sqlite file that is synced from an iphone/ipad to a host computer. OSX details. Windows details. An easy way to get a copy in your home dir on OSX is to start Terminal and run this (as a single line):
cp "`grep -l CellLocation /Users/$USER/Library/Application*Support/MobileSync/Backup/????????????????????????????????????????/*`" consolidated.db

This breaks on my system, and presumably on others. Rather than $USER you might try $HOME, but even using that breaks due to the regexp glob blowing up ("/usr/bin/grep: Argument list too long") In addition if you have multiple backup dirs and corresponding consolidated.db files (like on my sys ) even if the glob worked the cp will break.

I haven't seen any definitive documentation for this stuff out there... but assuming that the directory in question is the most recent in the backup list, you could do something like:

Code: Select all

cp "`dirname \"$(/bin/ls -t1 $HOME/Library/Application\ Support/MobileSync/Backup/*/Manifest.mbdb |head -1)\"`/4096c9ec676f2847dc283405900e284a7c815836" $HOME/consolidated.db

Not sure if the forum thing allows long lines, but that should be all one line. This leans on my belief that the consolidated.db file *seems* to be always named "4096c9ec676f2847dc283405900e284a7c815836". This also assumes you only want one of the DBs (and the most recent one), which may or may not be correct. I don't have access to enough systems to write a proper little line or script, but perhaps this will help data sucks in this vein.

[pejacoby]

FWIW, on my OS X 10.6.7 iMac with iTunes 10.2.2, the consolidated.db file in the backup directory for my iPod Touch 3G is also named "4096c9ec676f2847dc283405900e284a7c815836"

[bobzilla]

Same filename as on mine too, nice that that's constant. We'll change the simple instructions.

[york2600]

This is an amazing new feature. I never realized how many networks my iPhone has been around in the last year. My 2 files had a total of 195,000 networks in them! This is going to hugely increase the total networks if everyone using Wigle pulls their DBs

[pejacoby]

My iPod Touch 3G had 14,474 entries, of which 5000+ were new to WiGLE. That's pretty amazing considering this is my main stumbling device, running WiFiFoFum pretty much every day.

Going to upload the files from our other two iPod Touches (a 2G and a 4G) and see what's in there!

[pejacoby]

Results from uploading three different consolidated.db files. The 3G is the best traveled unit, but the 4G is just kicking butt for retained data!

iPod Touch 2G, iOS 4.2.1 - 2,076 entries - 48 new APs
iPod Touch 3G, iOS 4.2.1 - 14,747 entries - 5,611 new APs
iPod Touch 4G, iOS 4.2.1 - 34,404 entries - 15,849 new APs!

My stats just got mucho better

[toothpaste]

I followed the instructions on this thread and the page linked for the consolidated.db. all three times it was a failure, can you admins check out what happened?

thanks

[uhtu]

please send the affected transaction id's to wigle-admin@wigle.net, thanks

-uhtu