Re: Tutorial: Query the Apple database with Python for your access point BSSID

On Thu, 12/18/2025 4:29 PM, Marian wrote:
> Marian wrote:
>>   BSSID: 8c:85:80:d1:be:37
>>   Latitude: 32.45985031
>>   Longitude: -93.81759643000001
>>     BSSID: 8e:76:3f:f8:5d:cd
>>   Latitude: 32.4594841
>>   Longitude: -93.8175888
>>     BSSID: 92:76:3f:f8:5d:cd
>>   Latitude: 32.4594841
>>   Longitude: -93.81756591
>>     BSSID: 92:95:51:b5:b6:ae
>>   Latitude: 32.45910644
>>   Longitude: -93.81759643000001
> 
> Does anyone have any idea why the highly insecure Apple WPS database
> contains GPS entries to this illogically numerous set of decimal places?
> 
> BSSID: 8c:85:80:d1:be:37
> <https://wavedigger.networksurvey.app/?tab=bssid&bssid=8c-85-80-d1-be-37>
> 
> BSSID: 8e:76:3f:f8:5d:cd
> <https://wavedigger.networksurvey.app/?tab=bssid&bssid=8e-76-3f-f8-5d-cd>
> 
> BSSID: 92:76:3f:f8:5d:cd
> <https://wavedigger.networksurvey.app/?tab=bssid&bssid=92-76-3f-f8-5d-cd>
> 
> BSSID: 92:95:51:b5:b6:ae
> <https://wavedigger.networksurvey.app/?tab=bssid&bssid=92-95-51-b5-b6-ae>

Well, check the NMEA messages and see what they contain.

First, you have to be aware of the conversion steps.

   https://stackoverflow.com/questions/66978496/parsing-and-converting-output-from-a-gps-dongle

     import pynmea2

     line = "$GPGLL,3745.81303,N,12214.62049,W,175033.00,A,D*7C"    # degrees minutes fractions-of-a-minute
     nmeaobj = pynmea2.parse(line)

     coord = f'{nmeaobj.latitude} {nmeaobj.longitude}'
     print(coord)
     # 37.763551 -122.243675                                        # Degrees fractions-of-a-degree

       https://en.wikipedia.org/wiki/Decimal_degrees#Precision

I just shifted the stuff over here, to see how many digits they give.
The GLL seems to give me eight digits. The GGA less so.

GLL

https://gocut.tiwri.com/gll_geographic_position___latitude_longitude.htm

    $GPGLL,5943.432134,N,01020.998301,E,080920.91,A,A*6C       # degrees minutes fractions-of-a-minute

    Latitude in dd mm,mmmm format (0-7 decimal places).     59.43432134 as  59. 43.432134
    Latitude N or S.
    Longitude in ddd mm,mmmm format (0-7 decimal places).  010.20998301 as 010. 20.998301
    Longitude E or W.

GGA

https://w3.cs.jmu.edu/bernstdh/web/common/help/nmea-sentences.php

    $GPGGA,210230,3855.4487,N,09446.0071,W,1,07,1.1,370.5,M,-29.5,M,,*7A  # degrees minutes fractions-of-a-minute

    Latitude (in DDMM.MMM format)     38.554487 as   38. 55.4487
    Latitude compass direction
    Longitude (in DDDMM.MMM format)  094.460071 as  094. 46.0071
    Longitude compass direction

We don't want to go into the minutiae to dismiss the crap on the end of -93.81759643000001

  Paul