Breathe London AQMesh Pods

Greater London Authority

@ukgov.breathe_london_aqmesh_pods

Table List

2 tables(4.36 MB)

Monitoring Data

@ukgov.breathe_london_aqmesh_pods.monitoring_data

4.34 MB
757357 rows
10 columns

pod_id_location Pod Id Location	pod_id Pod Id	location_name Location Name	latitude Latitude	longitude Longitude	date_utc Date Utc	pm2_5_ugm3 Pm2–5 Ugm3	ratification_status_pm2_5 Ratification Status Pm2–5	no2_ugm3 No2 Ugm3	ratification_status_no2 Ratification Status No2
1245	1245	Dollis Road	51.604486	-0.206551	Fri Feb 15 2019 13:00:00 GMT+0000 (Coordinated Universal Time)		P
1245	1245	Dollis Road	51.604486	-0.206551	Fri Feb 15 2019 14:00:00 GMT+0000 (Coordinated Universal Time)	19.46	P
1245	1245	Dollis Road	51.604486	-0.206551	Fri Feb 15 2019 15:00:00 GMT+0000 (Coordinated Universal Time)	20.91	P
1245	1245	Dollis Road	51.604486	-0.206551	Fri Feb 15 2019 16:00:00 GMT+0000 (Coordinated Universal Time)	36.42	P
1245	1245	Dollis Road	51.604486	-0.206551	Fri Feb 15 2019 17:00:00 GMT+0000 (Coordinated Universal Time)	22.59	P	105.38	P
1245	1245	Dollis Road	51.604486	-0.206551	Fri Feb 15 2019 18:00:00 GMT+0000 (Coordinated Universal Time)	17.6	P	114.95	P
1245	1245	Dollis Road	51.604486	-0.206551	Fri Feb 15 2019 19:00:00 GMT+0000 (Coordinated Universal Time)	17.37	P	124.39	P
1245	1245	Dollis Road	51.604486	-0.206551	Fri Feb 15 2019 20:00:00 GMT+0000 (Coordinated Universal Time)	21.44	P	114.77	P
1245	1245	Dollis Road	51.604486	-0.206551	Fri Feb 15 2019 21:00:00 GMT+0000 (Coordinated Universal Time)	22.8	P	101.42	P
1245	1245	Dollis Road	51.604486	-0.206551	Fri Feb 15 2019 22:00:00 GMT+0000 (Coordinated Universal Time)	25.75	P	89.04	P


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
);