Forum Sensor.Community

How to find the Chip ID

Hello everybody from Mallorca, where we have recently set up a network of sensors in the town of Sóller. I’m looking forward to learning lots and, eventually, helping others. Perhaps somebody can help me today, though.

Given that the sensor ID on the map is not the same as the Chip ID (the one that begins with esp8266, for example), is there any way I can access the very useful information on the Grafana dashboard without knowing the Chip ID? For example, I’d like to inspect and download data for certain time frames from sensors that I don’t control in nearby towns for comparative purposes. I’d also like to build iframes for them to put them on our website (for example: Grafana).

But I don’t think I can do this without knowing the Chip ID (in this case [esp8266-786206])

Of course, I can access these sensors at the archive of sensor community. But I haven’t found an easy way to compile monthly data for a sensor from there, like I can do via the Grafana dashboard.

Our website is https://sollerperlaire.org/

Thanks everybody!

Barry

This method you should know:
https://api-rrd.madavi.de/grafana/d/GUaL5aZMz/pm-sensors?orgId=1&var-chipID=esp8266-786206 (Look at the ID in the URL, it can be replaced)

This address works with the map ID (look in the code of the map):
https://maps.sensor.community/grafana/d/000000004/single-sensor-view-for-map?orgId=1&var-node=54307 (Look at the var-node in the URL)

In Grafana, you can share iframes:

Capture d’écran 2021-02-12 à 11.04.24

Inspect data:
Capture d’écran 2021-02-12 à 11.06.14

Export csv:

I wrote a python script for exporting from the archives:

import requests
#Put the map ID in the array separated with comma
sensor_id = ["54307"]
#Date in format 'YYYY-MM-DD' separated with comma. You can produce the list easily with Excel
dates = ["2019-01-01","2019-01-02","2019-01-03","2019-01-04","2019-01-05","2019-01-06","2019-01-07","2019-01-08","2019-01-09","2019-01-10","2019-01-11","2019-01-12","2019-01-13","2019-01-14"]
url_deb = 'http://archive.sensor.community/'

for n1 in range(0,len(dates)):

date = dates[n1]
url_ok = url_deb + date
r1 = requests.get(url_ok)
source_code = r1.text

for n2 in range(0,len(sensor_id)):

    test = 'sensor_'+sensor_id[n2]+'.csv'
        
    if test in source_code:

        split1 = source_code.split(test)[0]
        split2 = split1.split('<a href="')[-1]
        url_fin = url_ok + '/' + split2 + test
        #print(url_fin)
        r2 = requests.get(url_fin)
        data = r2.text
        #Print the data in terminal. You can then copy/paste in Excel 
        print(data)

It should still work and produce something like that:
Capture d’écran 2021-02-12 à 11.23.07

Tell me whan you have done something with this. I am reaaly curious to see the viz and comparison.

Hi Pjg.
Thanks so much for taking the time to answer. I suppose I’m looking for a mode that combines these! I’ve used both for different purposes.
It’s easy to get the var-node from the map, but it doesn’t behave like the var-chipID=esp8266. I’ve tried pasting the var-node into various parts of the address I use for my own sensors, but it doesn’t work! I suppose what I’m asking is if there is any way to open up the world of possibilities on the grafana dashboard if I only know the var-node…
I’m pretty new to all this, so I’ll have to look up how to use python and then putvtonuse the code you kindly shared. Right now I wouldn’t know where to put it!
Thanks again,
Barry.

I’ve tried pasting the var-node into various parts of the address I use for my own sensors, but it doesn’t work!

I don’t understand where the problem is.

You must use this address:
https://maps.sensor.community/grafana/d/000000004/single-sensor-view-for-map?orgId=1&var-node=<HERE THE IDs OF THE MAP>

On your site:

Use those number and you’ll get exactly what you have in your internet site. Just contact me per email (pierre_jean@…) and we can plan a videocall. Because it is a lot easier as you think.

Dear Pierre.
Thank you so much. That’s what I was trying to get, or I’m 90% there now. I will play with it tomorrow and let you know. Once again, thanks. Have a great weekend, with lots of fresh air!
Regards from Mallorca.
Barry