I have been working a bit with the influx integration and recently the LPP codec. I have some observations and suggestions to consider for future functionality.
With regards to using location based data, there are some limitations that make it difficult to use the influx integration. I am finding it particularly difficult because the data decoded using the LPP codec is not tagged with the location data. Moreover, the location data is written to fields (“latitude”, “longitude” and “geohash”) in a metric dedicated to the location. The data values are written into fields of separate metrics. A compounding issue relates to the separation of the altitude from the latitude and longitude. It too is written to a separate metric.
There are a couple issues with influx that compound the difficulty. One, InfluxQL cannot join two queries. So, one cannot combine data that are located in separate metrics. Two, Influx does not have a geohash query. So, one cannot query the db and group by a geohash with a given radius or fence.
I think it would be helpful if we could add the geohash (or lat / lon) as a tag to the data.
It would also be helpful in situations where the device’s location was static to be able to add a geohash based on the device eui or device name (which themselves are added as other tags).
Finally, I think it would generally be helpful if there was a capability to add conditional metadata tags to the data on the way to the database.
Does anyone else have any thoughts on this?