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

Marian wrote:
> Note that we can plot those ~400 entries on a map with Python's folium 
> library so you can visually explore the cluster instead of scrolling.

Here's how to display those hundreds of BSSID:GPS pairs on a local map.

Download the folium source archive <https://pypi.org/project/folium/#files>
<https://files.pythonhosted.org/packages/c7/76/84a1b1b00ce71f9c0c44af7d80f310c02e2e583591fe7d4cb03baecd0d3f/folium-0.20.0.tar.gz>
Name: folium-0.20.0.tar.gz
Size: 109932 bytes (107 KiB)
SHA256: A0D78B9D5A36BA7589CA9AEDBD433E84E9FCAB79CD6AC213ADBCFF922E454CB9
C:\app\archiver\7zip\7z.exe xfolium-0.20.0.tar.gz
C:\app\archiver\7zip\7z.exe x folium-0.20.0.tar
xcopy /E /I folium-0.20.0\folium C:\app\os\python\Lib\site-packages\folium
53 files copied
C:\app\os\python\python.exe -c "import folium; print(folium.__version__)"

Download the latest branca release from PyPI:
<https://pypi.org/project/branca/#files>
https://files.pythonhosted.org/packages/32/14/9d409124bda3f4ab7af3802aba07181d1fd56aa96cc4b999faea6a27a0d2/branca-0.8.2.tar.gz
Name: branca-0.8.2.tar.gz
Size: 27890 bytes (27 KiB)
SHA256: E5040F4C286E973658C27DE9225C1A5A7356DD0702A7C8D84C0F0DFBDE388FE7
C:\app\archiver\7zip\7z.exe x branca-0.8.2.tar.gz
C:\app\archiver\7zip\7z.exe x branca-0.8.2.tar

xcopy /E /I branca-0.8.2\branca C:\app\os\python\Lib\site-packages\branca

10 files copied
C:\app\os\python\python.exe -c "import branca; print(branca.__version__)"

Download Jinja2 source archive
<https://pypi.org/project/Jinja2/#files>
https://files.pythonhosted.org/packages/df/bf/f7da0350254c0ed7c72f3e33cef02e048281fec7ecec5f032d4aac52226b/jinja2-3.1.6.tar.gz
Name: jinja2-3.1.6.tar.gz
Size: 245115 bytes (239 KiB)
SHA256: 0137FB05990D35F1275A587E9AEE6D56DA821FC83491A0FB838183BE43F66D6D
C:\app\archiver\7zip\7z.exe x Jinja2-3.1.6.tar.gz
C:\app\archiver\7zip\7z.exe x Jinja2-3.1.6.tar
xcopy /E /I Jinja2-3.1.6\src\jinja2 C:\app\os\python\Lib\site-packages\jinja2
26 files copied
C:\app\os\python\python.exe -c "import jinja2; print(jinja2.__version__)"

Since this is getting tedious, I'll install pip:
C:\app\os\python\python.exe -m ensurepip

And then I'll install the rest of the dependencies.
C:\app\os\python\python.exe -m pip install markupsafe
C:\app\os\python\python.exe -m pip install numpy
C:\app\os\python\python.exe -m pip install xyzservices

Test:
C:\app\os\python\python.exe -c "import folium; print(folium.__version__)"
C:\app\os\python\python.exe -c "import folium; m = folium.Map(location=[0,0], zoom_start=2); m.save('test_map.html'); print('OK')"

python plot_bssid.py
Map saved to bssid_map.html

start msedge "C:\app\os\python\apple_bssid_locator\bssid_map.html" 
Voila! Up to 400 nearest access points on the map in a single query.