Feature #15270
Record well sensor data (mqtt)
0%
Description
Ram (rkris@wisense.in) has set up a "gateway" to collect well water sensor (to start with).
The mqtt messages arrive directly on the server. See:
Sensor data published by the GW to this topic "/v1/telemetry" in JSON format. See example below.
{
"Name":"WSN-0012f82e",
"MacId":"00:12:f8:2e",
"RSSI":-19,
"LQI":13,
"0x78":"2.97",
"0x33":"215.00",
"0x58":"0.40",
"Sequence_number":64
}
History
#1 Updated by Philippe May 5 months ago
- Assignee changed from Philippe May to Giulio Di Anastasio
Giulio, which well (id) is the first sensor in?
#2 Updated by Giulio Di Anastasio 5 months ago
- File Kindergarten dashboard.png View added
- File Alok well dashboard.png View added
The first sensor has been installed in Alok's well, well id is 119, MAC id is 00:12:f8:2e
Then another sensor has been installed at Kindergarten, well id is 238, MAC id is 00:12:df:f4
See attached screenshots
#3 Updated by Philippe May 5 months ago
Done most of the job, but i have a doubt, and i must be missing something: how to compute the level from the top of the well?
For example we get such value: 21545 (mm), which i remember Ram saying it's the height of the column of water above the probe. But we don't know at which depth is the probe. It has to de with the calibration linear function. @giulio, can you enlighten me?
#4 Updated by Giulio Di Anastasio 5 months ago
The depth of the sensor is known, as well as the elevation of the ground and that of top of casing.
The depth of the sensor is decided upfront, and it is different for each well, as it depends on local setup of the well. The sensor is installed at that depth (example: 45 meters from top of casing), then knowing the height of the column of water above the sensor it is wasy to calculate the depth of water.
So, before we set up everything in the database for this, we still need to test the good functioning of the setup: for instance, day before yesterday the sensor in Alok’s well suddenly stopped transmitting. Vijai went and replaced the battery in the transmitting device, and replaced the sensor. But we still don’t know what happened, and that requires some observation.
The best is that we get from Vijai the depth of the sensor even if it temporary, and then finalize it once we have understood what is reLly going on inside the well.
I hope this was clear, of course itnis better to meet in person and clarify all these points, and raise some more…
Cheers
#5 Updated by Philippe May 5 months ago
For sensors out of the ICITI (Aurinoco) network, we have several options (order of priority/easiness), discussed with Ram:
- Aurinoco forwards MQTT traffic coming to gis.avcsr.org public IP address to CSR network. I created a ticket for that: https://redmine.auroville.org.in/issues/15280
- Get the remote devices to use MQTT over websocket, which seems to be a common solution for a setup like ours (private LAN)
- Use a public MQTT "broker", such as https://mqtthq.com/
- VPN (software or using dedicated hardware box)
- Point to point radio link between remote location (Auro Orchard) and CSR (involved setting up some hardware)