Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[IRCELINE] Troubles with "is_active" indicator #24

Closed
amotl opened this issue Feb 13, 2020 · 1 comment
Closed

[IRCELINE] Troubles with "is_active" indicator #24

amotl opened this issue Feb 13, 2020 · 1 comment

Comments

@amotl
Copy link
Member

amotl commented Feb 13, 2020 •
edited

We are synthesizing a field called is_active within PostGIS based on the sensor_last_date field coming from the SOS service where we are ingesting sensor data of the IRCELINE sensor network from.

The implementation for IRCELINE has been done within 0c3ec97, with a minor fixup through fb1301a. The gist is

ABS(DATE_PART('day', sensor_last_date - now())) <= 7 AS is_active

@d-roet is having troubles with this is_active indicator, see also https://source.irceline.be/vaquums/grafana_luftdatenpumpe/issues/27. Let's investigate this here.

cc @wetterfrosch
@amotl amotl changed the title [LDI, IRCELINE] Troubles with "is_active" indicator [IRCELINE] Troubles with "is_active" indicator Feb 13, 2020
@amotl
Copy link
Member Author

amotl commented Feb 13, 2020

We found the culprit: Updating of the station for IRCELINE was missing from the respective cronjob on the production system. Sorry for the noise.

Regarding a respective implementation for LDI, we are diverting that to #26.

@amotl amotl closed this as completed Feb 13, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@amotl