Page 1 of 1

50mb KML file too big

Posted: Thu Aug 22, 2013 11:26 pm
by mobileshaun
Hi

I downloaded my entire DB from wigle, into a KML, but it's too big to import into google maps, and since it's already a kml file, I can't use giskismet to strip out what I need, does anyone know a software that will let me strip out what I need? like only certain SSID's, or by encryption?

thanks

Re: 50mb KML file too big

Posted: Fri Aug 23, 2013 5:40 pm
by mtbrandao
Try google fusiontables. (On google drive)
That would work better if you export the the sqlite file (http://goo.gl/CdvmYL) and import the file on fusiontables.

Re: 50mb KML file too big

Posted: Fri Aug 30, 2013 12:44 am
by mobileshaun
Thanks, It kinda worked, although I can only use the first 100 rows, whereas my my filtered file still has 1500+

Any other ideas?

Re: 50mb KML file too big

Posted: Mon Sep 02, 2013 1:45 pm
by mtbrandao
I did with more than 100 rows
https://www.google.com/fusiontables/Dat ... I#map:id=6

I got the sqlfile on the wiglewifi folder, opened it with the firefox plugin sqlite manager (link on last post), and imported it on google fusion tables.

From there it was just a matter of selecting the geolocation columns and creating the map.