earthobservations / luftdatenpumpe

Luftdatenpumpe

About

Process live and historical data from luftdaten.info, irceline and OpenAQ. Filter by station-id, sensor-id and sensor-type, apply reverse geocoding, store into TSDB and RDBMS databases (InfluxDB and PostGIS), publish to MQTT or just output as JSON.

Features

1. Luftdatenpumpe acquires the measurement readings either from the livedata API of luftdaten.info or from its archived CSV files published to archive.luftdaten.info. To minimize impact on the upstream servers, all data gets reasonably cached.
2. While iterating the readings, it optionally filters on station-id, sensor-id or sensor-type and restrains information processing to the corresponding stations and sensors.
3. Then, each station's location information gets enhanced by
   • attaching its geospatial position as a Geohash.
   • attaching a synthetic real-world address resolved using the reverse geocoding service Nominatim by OpenStreetMap.
4. Information about stations can be
   • displayed on STDOUT or STDERR in JSON format.
   • filtered and transformed interactively through jq, the swiss army knife of JSON manipulation.
   • stored into RDBMS databases like PostgreSQL using the fine dataset package. Being built on top of SQLAlchemy, this supports all major databases.
   • queried using advanced geospatial features when running PostGIS, please follow up reading the Luftdatenpumpe PostGIS tutorial.
5. Measurement readings can be
   • displayed on STDOUT or STDERR in JSON format, which allows for piping into jq again.
   • forwarded to MQTT.
   • stored to InfluxDB and then
   • displayed in Grafana.

Synopsis

# List networks
luftdatenpumpe networks

# List LDI stations
luftdatenpumpe stations --network=ldi --station=28,297 --reverse-geocode

# Store list of LDI stations and metadata into RDBMS database (PostgreSQL), also display on STDERR
luftdatenpumpe stations --network=ldi --station=28,1071 --reverse-geocode --target=postgresql://luftdatenpumpe@localhost/weatherbase

# Store LDI readings into InfluxDB
luftdatenpumpe readings --network=ldi --station=28,1071 --target=influxdb://luftdatenpumpe@localhost/luftdaten_info

# Forward LDI readings to MQTT
luftdatenpumpe readings --network=ldi --station=28,1071 --target=mqtt://mqtt.example.org/luftdaten.info

For a full overview about all program options including meaningful examples, you might just want to run luftdatenpumpe --help on your command line or visit luftdatenpumpe --help.

Screenshots

Luftdaten-Viewer displays stations and measurements from luftdaten.info (LDI) in Grafana.

Map display and filtering

• Filter by different synthesized address components and sensor type.
• Display measurements from filtered stations on Grafana Worldmap Panel.
• Display filtered list of stations with corresponding information in tabular form.
• Measurement values are held against configured thresholds so points are colored appropriately.

Map popup labels

• Humanized label computed from synthesized OpenStreetMap address.
• Numeric station identifier.
• Measurement value, unit and field name.

Installation

If you are running Python 3 already, installing the program should be as easy as:

pip install luftdatenpumpe

At this point, you should be able to conduct simple tests like luftdatenpumpe stations as seen in the synopsis section above. At least, you should verify the installation succeeded by running:

luftdatenpumpe --version

However, you might have to resolve some prerequisites so you want to follow the detailed installation instructions at install Luftdatenpumpe.

Luftdaten-Viewer

About

Using Luftdatenpumpe, you can build user-friendly interactive GIS systems on top of PostGIS, InfluxDB and Grafana. We are calling this "Luftdaten-Viewer".

Without further ado, you might enjoy reading about existing "Luftdaten-Viewer" installations at Testimonials for Luftdatenpumpe.

Instructions

These installation instructions outline how to setup the whole system to build similar interactive data visualization compositions of map-, graph- and other panel-widgets like outlined in the "Testimonials" section.

• Luftdaten-Viewer Applications
• Luftdaten-Viewer Databases
• Luftdaten-Viewer Grafana

License

This program is free software; you can redistribute it and/or modify it under the terms of the GNU Affero General Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU Affero General Public License along with this program; if not, see: <http://www.gnu.org/licenses/agpl-3.0.txt>, or write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA

Content attributions

The copyright of particular images and pictograms are held by their respective owners, unless otherwise noted.

Icons and pictograms

• Water Pump Free Icon from Icon Fonts is licensed by CC BY 3.0.