Hacker News new | comments | show | ask | jobs | submit login

There are two (relevant) tables in the SQL Lite database. One is called CellLocation, the other is called WiFi Location.

The data collected includes:

    * Timestamp (in seconds since Jan 2001 GMT)
    * Latitude 
    * Longitude 
    * HorizontalAccuracy 
    * Altitude
    * VerticalAccuracy
    * Speed 
    * Course
    * Confidence
The above are self-explanatory. More opaque (to me, anyway) are the following:

    * MNC
    * LAC
    * CI
    * MCC
If anyone has knowledge of what these mean, please post.

Those are Mobile Network Code, Location Area Code, Cell Identity, and Mobile Country Code.

LAC: Location code CI Cell ID MCC: Mobile Country Code MNC: Mobile Network Code

I cant see primary on my db copy, and my wifi location also contains 33000 MAC addresses.

Indecently, couldn't get the py script up and running on win7, but if you sort by date modified, the size is around 5 meg and you can open the db directly in an sqlite viewer

Applications are open for YC Winter 2018

Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | DMCA | Apply to YC | Contact