SQL SELECT on Wigle database ?

Suggestions for WiGLE/JiGLE/DiGLE

5 posts • Page 1 of 1

Postby MDofPerth » Mon Jan 14, 2013 10:08 am

Is it possible to issue an SQL select on the whole Wigle Database (the one at wigle.net) via an SQL client, to get the same table columns that are in our own WiGLEWiFi.SQLITE database Location and Network tables?

I tried the online form (http://wigle.net/gps/gps/GPSDB/query/) to query Lat/Lons around my vicinity but found BSSID and SSID, Lat, Lon and time, but I would like to get Capabilities (from the Network Table), plus Altitude, and Accuracy (from the Location table). Also, I would like to be able to do a download of a CSV, TSV or similar instead of one web-page of 100 entries at a time.

Is the source code for the /gps/gps/GPSDB/query/ and /gps/gps/main/confirmquery/ available?

Cheers, Mark.
Image

Postby uhtu » Mon Jan 14, 2013 11:14 am

no, and no.
also, what makes you think it is a sql database?

-uhtu

Postby MDofPerth » Mon Jan 14, 2013 11:42 am

no, and no.
Ok. Thanks for that. Is there a reason for that ? Is it 'no, and no, not ever', or 'no, but maybe sometime in the future'?
also, what makes you think it is a sql database?
Just a hunch based on what I've seen of the project so far. The Android war-driving client uses the super-cool lightweight SQlite :)

Cheers, Mark.
Image

Postby uhtu » Tue Jan 15, 2013 1:28 am

no, never!
what, never?
well, hardly ever!

Postby MDofPerth » Wed Jan 16, 2013 5:03 am

no, never!
what, never?
well, hardly ever!
Excellent, we both love G&S. :D
Image

5 posts • Page 1 of 1

Return to “WiGLE Project Suggestions”

Who is online

Users browsing this forum: Google [Bot] and 8 guests