ttnmapper / ttnmapper-web

TTN Mapper production source code
https://ttnmapper.org
GNU General Public License v3.0
15 stars 5 forks source link

Add ability to view all gateways seen from a given measurement point #16

Open BNNorman opened 2 years ago

BNNorman commented 2 years ago

In advanced maps I can look at the measurement points associated with one gateway over a period of time. However, it would be useful to be able to view which gateways picked up a signal sent from a given measurement point. This would indicate the resilience of installing a device at a given location. If a location can be seen by two or more gateways then it is less likely to suffer loss of data if someone's electricity meter runs out.

Perhaps a hotspot/selector of, say, 50m radius could be used to select measurement points to be considered and perhaps the 'selector' could be dragged around the Heatmap page to make the selection for radar lines.

Many thanks for this useful tool. Regards Brian

jpmeijers commented 2 years ago

Interesting idea. I like it! I'll think about how we can implement this.

BNNorman commented 2 years ago

Hoping to be helpful - but tell me to shut up if I'm tyelling you something you already know.

The TTN MQTT message ["uplink_message"]["rx_metadata"] lists all the gateways seen by a transmission - I'm sure you already know that but I don't know if you store the information. I don't know which database your backend uses but MYSQL supports geospatial extensions:-

See: https://stackoverflow.com/questions/21168380/use-mysql-spatial-extensions-to-select-points-inside-circle

An example of a scrollable magnifier is here:-

https://www.w3schools.com/howto/howto_js_image_magnifier_glass.asp

I'm glad you like the idea.

BNNorman commented 1 month ago

Is this still stuck in your to-do list?