Comments (1)
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?
from data-gateway.
Related Issues (20)
- Create a separate table/tables with sensor coordinates information. HOT 9
- Add sessions table HOT 4
- Poetry installation prevents tests from running in CI HOT 1
- Create a separate BigQuery table for "Connection statistics" and "Battery state" sensor_type. HOT 2
- Add CLI or gateway configuration option to control maximum local storage limit.
- Update sensor conversion constants in configuration HOT 1
- Cloud function fails to add sensor data. HOT 3
- Add a --reboot-nodes flag to the CLI (Allow daemonisation)
- problem in parsing the config file on fire-fly HOT 3
- Main service does not log to the Balena Dashboard Logs Window. HOT 1
- Reduce BigQuery costs HOT 6
- Implement WaitUntilSetComplete and timestamp synchronisation HOT 2
- log handling not idempotent across tests
- Cannot persist cloud data HOT 1
- Allow configurations of more than 8KiB HOT 1
- Parallelise cloud function deployment workflow
- Allow cloud functions to be deployed manually
- Remove `sensor_type_reference` field from sensor data materialised views
- Conflicting routine file warning message
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from data-gateway.