Breathe London AQMesh Pods

Greater London Authority

@ukgov.breathe_london_aqmesh_pods

Table List

2 tables(4.36 MB)

Meta Data

@ukgov.breathe_london_aqmesh_pods.meta_data

20.85 KB
181 rows
16 columns

pod_id_location Pod Id Location	start_date_utc Start Date Utc	end_date_utc End Date Utc	scaling_method Scaling Method	location_name Location Name	borough Borough	type Type	ulez Ulez	latitude Latitude	longitude Longitude	x_coord X Coord	y_coord Y Coord	distance_from_road Distance From Road	height Height	pollutant Pollutant
1245	Fri Feb 15 2019 16:45:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 17 2019 23:59:00 GMT+0000 (Coordinated Universal Time)	Gold Pod Colocation	Dollis Road	Barnet	Kerbside	No	51.604486	-0.206551	524299.9229199999	191038.626708	1.2	3.1	no2
2245	Sun May 05 2019 01:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 17 2019 23:59:00 GMT+0000 (Coordinated Universal Time)	Network Based Calibration	Great Ormond St Hospital	Camden	Roadside	Yes	51.52188	-0.1204339999999999	530499.42614	182002.318099	2.5	2.8	no2
3245	Thu Oct 04 2018 18:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 17 2019 23:59:00 GMT+0000 (Coordinated Universal Time)	Gold Pod Colocation	Savernake Road	Camden	Urban Background	No	51.5554849	-0.1523385	528191.724024	185682.958666	5	2.297	no2
5245	Mon Nov 26 2018 10:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 17 2019 23:59:00 GMT+0000 (Coordinated Universal Time)	Network Based Calibration	Garrett Lane	Wandsworth	Kerbside	No	51.440399	-0.186775	526117.994405	172825.445928	1	3.445	no2
6245	Fri Jan 11 2019 14:45:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 17 2019 23:59:00 GMT+0000 (Coordinated Universal Time)	Network Based Calibration	Hanworth Road	Hounslow	Kerbside	No	51.468625	-0.35977	514028.370572	175680.724203	1.2	3.2	no2
7245	Thu Sep 20 2018 13:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 17 2019 23:59:00 GMT+0000 (Coordinated Universal Time)	Gold Pod Colocation	Greenwich Church Street	Greenwich	Kerbside	No	51.4813	-0.0098599999999999	538290.731868	177691.813574	0.5	3	no2
8245	Mon Mar 11 2019 15:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 17 2019 23:59:00 GMT+0000 (Coordinated Universal Time)	Gold Pod Colocation	Geraldine Street	Southwark	Urban Background	Yes	51.49562	-0.1054119999999999	531617.141645	179108.998027	21	2.225	no2
9245	Thu Apr 04 2019 07:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 17 2019 23:59:00 GMT+0000 (Coordinated Universal Time)	Gold Pod Colocation	Whitehall	Westminster	Kerbside	Yes	51.504566	-0.126167	530148.429639	180066.301618	1.2	2.9	no2
10245	Tue Apr 09 2019 15:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 17 2019 23:59:00 GMT+0000 (Coordinated Universal Time)	Gold Pod Colocation	Borough High Street	Southwark	Roadside	Yes	51.506131	-0.088654	532747.542696	180309.973221	3	5	no2
11245	Fri Apr 05 2019 03:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 17 2019 23:59:00 GMT+0000 (Coordinated Universal Time)	Gold Pod Colocation	Cadogan Gardens	Kensington & Chelsea	Roadside	No	51.493217	-0.158772	527919.975156	178747.26442	2.3	1.7619999999999998	no2


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