Open thclark opened 1 year ago
As discussed before, the goal to introduce "measurement campaign" concept for easier data retrieval/filtering. Essentially it is similar to "installation", depending on how you define installation. It is surely possible to get a table that contains information similar to the "measuremnt campaign" one using the following query on sensor data:
SELECT installation_reference, min(datetime) as start, max(datetime) as finish, node_id, sensor_type_reference FROM `aerosense-twined.greta.sensor_data`
GROUP BY installation_reference, node_id, sensor_type_reference
Now, whether "measurement campaign" is sufficiently narrower than the "installation" to warrant it's own existence, is a separate topic. But the idea is to have additional metadata, particularly: "On a specific installation, what nodes and sensor were active during certain period of time and for what purpose ?" I guess the question is "what should be the "primary key" (not entirely correct term, but you get the idea) to get the desired data series?
Feature request
The measurement campaign reference is set automatically using a coolname if it's not set in the configuration. It's not at all obvious what this is for, and it's undocumented. What differentiates this from the label field??
Also, long coolnames are a pain. If it has to be a coolname, just two words will give a more easily searchable and less weird-and-esoteric value whilst remaining sufficiently unique
Suggested improvement