search

earthobservations / luftdatenpumpe

Acquire and process live and historical air quality data without efforts. Filter by station-id, sensor-id and sensor-type, apply reverse geocoding, store into time-series and RDBMS databases, publish to MQTT, output as JSON, or visualize in Grafana. Data sources: Sensor.Community (luftdaten.info), IRCELINE, and OpenAQ.
https://luftdatenpumpe.readthedocs.io/
GNU Affero General Public License v3.0
34 stars 3 forks source link

[IRCELINE] Troubles with "is_active" indicator #24

Closed amotl closed 4 years ago

amotl commented 4 years ago

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 0c3ec979, with a minor fixup through fb1301a0. 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 commented 4 years ago

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.