About this Dataset

Breathe London AQMesh Pods

The Breathe London stationary network is made up of 100 AQMesh pods, each containing a collection of small sensor-based air quality monitors that offer near real-time localised air quality information. They measure nitrogen dioxide (NO₂) and nitric oxide (NO) using electrochemical sensors; particulate matter (PM) in various size cuts (PM₂.₅ and PM10 are reported) using a light-scattering optical particle counter; and carbon dioxide (CO₂) using a non-dispersive infrared absorbance sensor. In some locations, the pods measure ozone (O3), also using electrochemical sensors. The pods measure temperature, humidity and air pressure for the purposes of correction for environmental conditions. Each sensor pod is set up to collect data continuously for 10-second intervals and to create an average every 1-15 minutes, synchronised to the top of each hour. More information can be found on the Breathe London website.
Publisher name: Greater London Authority
Last updated: 2024-09-14T08:29:19Z

Tables

Meta Data

@ukgov.breathe_london_aqmesh_pods.meta_data

21.35 kB
181 rows
16 columns

CREATE TABLE meta_data (
  "pod_id_location" BIGINT,
  "start_date_utc" TIMESTAMP,
  "end_date_utc" TIMESTAMP,
  "relocate_date_utc" TIMESTAMP,
  "scaling_method" VARCHAR,
  "location_name" VARCHAR,
  "borough" VARCHAR,
  "type" VARCHAR,
  "ulez" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "x_coord" DOUBLE,
  "y_coord" DOUBLE,
  "distance_from_road" DOUBLE,
  "height" DOUBLE,
  "pollutant" VARCHAR
);

Monitoring Data

@ukgov.breathe_london_aqmesh_pods.monitoring_data

4.55 MB
757,357 rows
10 columns

CREATE TABLE monitoring_data (
  "pod_id_location" BIGINT,
  "pod_id" BIGINT,
  "location_name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "date_utc" TIMESTAMP,
  "pm2_5_ugm3" DOUBLE,
  "ratification_status_pm2_5" VARCHAR,
  "no2_ugm3" DOUBLE,
  "ratification_status_no2" VARCHAR
);