[kismac] Re: prototype Google Earth .kismac server

  • From: Robin L Darroch <robin@xxxxxxxxxxxxx>
  • To: kismac@xxxxxxxxxxxxx
  • Date: Tue, 11 Apr 2006 20:42:59 +0800

Nice. Perhaps you could get the .kismac entries from the Kismac file...

Actually, the idea is that once this is all working, I'd really like to see it run from the main .kismac server from the whole 171000+ nets in that database. In fact, I think it just about *is* all working now... but perhaps we can extend the trial where it is now until Mick's got time to have input on putting it on the server.

I have another idea: A point on the local HDD as a KML file, updating every second, placed there by Kismac to show your current place and accesspoints you've found on Google Earth as you do them.

That's certainly possible - and was kind-of raised during the initial ideal of KML export - but I'm inclined to leave the real-time aspect of KisMAC in the built-in map, then later on you can use the export features and (once it's running) the Google Earth/.kismac server to look at it all in the Google Earth setting. If nothing else, adding real-time Google Earth tracking would be yet another thing to keep updated during run-time, and yet another preference or switch to turn off and on. It's not a bad idea, but maybe best to leave it for now.

I tested it with mine, it's awesome! Uploaded about 460 networks.

Excellent! About the only thing I wonder is whether it's worth adding an algorithm to try and pick nets more intelligently (to make the returned nets as widely distributed within the view as possible) or to return more nets (currently 200 in the view). Unfortunately, I can't think of any way to do the first in a manner that is at all efficient on the server-side... but perhaps I can come up with something, or someone else can!

The current SQL query is:

SELECT latitude*1.000000 as lat,longitude*1.000000 as lon,ssid,type,bssid,encryption,lastseen FROM networks WHERE (latitude BETWEEN $bl_lat AND $tr_lat) AND (longitude BETWEEN $bl_lon AND $tr_lon) ORDER BY lastseen DESC LIMIT 200;

($bl|tr_lat|lon are the limiting latitude & longitude of the view area)

Might do some more digging in the SQL syntax.

Other than that, all suggestions welcome!

 Robin L. Darroch - PO Box 2715, South Hedland WA 6722 - +61 421 503 966
      robin@xxxxxxxxxxxxx - robin@xxxxxxxxxxx - robin@xxxxxxxxxxxxx

Other related posts: