Velotracker map of Köniz
---
Here is the result:
![](https://hackmd.io/_uploads/Byrr2gKGT.jpg)
How was it made?
First, for about 100 Swiss Francs, I bought a rugged, battery+solar powered TTN Velotracker from Luond Electronics, some nice people on the Zürisee. Of course, I could attach my own contraption, but it would never survive the hilly roads and weather conditions through which I bike.
![](https://www.velotracker.ch/wp-content/uploads/2020/01/IMG_8644_hero.jpg)
Get your own at velotracker.ch - and connect it to The Things Network. Note that your bike will only be tracked if it's within range of an open gateway. Here's the current view on Bern in TTNmapper.org - clearly there are will be many gaps in reception:
![](https://hackmd.io/_uploads/HJJY-Q9G6.jpg)
For better coverage, Velotracker gives you the option of connecting to Swisscom's LoRaWAN network for a monthly fee.
![](https://hackmd.io/_uploads/Hy2Y_bFz6.png)
After you've biked around a bit (I collected 8 months of data for the image above), export a CSV file from the PWA app. This should look like this:
![](https://hackmd.io/_uploads/HJsbFWFzp.png)
Then import it into a QGIS delimited text layer. The import dialog helps you to make sure the "lan" and "lot" columns are properly attributed.
![](https://hackmd.io/_uploads/B127t-KGp.png)
Then create a grid (hexagons are the bestagons!) and adjust the spacing until you're happy.
![](https://hackmd.io/_uploads/BJ5W_ZYGa.jpg)
Use the handy Count Points in Polygon tool with your Grid and point-layer:
![](https://hackmd.io/_uploads/SJ9WubYfp.jpg)
Finally add a dynamic opacity on the NUMPOINTS attribute that the tool has generated:
![](https://hackmd.io/_uploads/BJo-_bFM6.jpg)
You probably need to multiply it by a factor of 20 or so:
![](https://hackmd.io/_uploads/S12bO-KzT.jpg)
Tweak the result, then hang it on your wall and be proud of your proof of spatial awareness!
![](https://hackmd.io/_uploads/SyC-_-tMa.jpg)
Thanks to the TTN Bern community for all the gateways that make this tracking possible `<3`