Air Quality Monitoring Auto Stations

City of Bradford Metropolitan District Council

@ukgov.air_quality_monitoring_auto_stations11

Table List

1 table(8.62 KB)

Table 1

@ukgov.air_quality_monitoring_auto_stations11.table_1

8.62 KB
7 rows
11 columns

x X	y Y	objectid OBJECTID	name NAME	site_id SITE ID	site_type SITE TYPE	pollutants_monitored POLLUTANTS MONITORED	monitoring_technique MONITORING TECHNIQUE	distance_to_relevant_exposure DISTANCE TO RELEVANT EXPOSURE	dist_to_kerb_of_nearest_road DIST TO KERB OF NEAREST ROAD	inlet_height INLET HEIGHT
406061.175	441273.529200001	1	Keighley	CM2	Urban Centre	NO2; PM10	Chemiluminescent		5	2.7
415584.0175	434458.322899999	2	Manningham Lane	CM3	Roadside	NO2	Chemiluminescent	4	1.5	1.5
415932.2062	430566.280099999	3	Manchester Road / Mayo Avenue	CM4	Roadside	NO2	Chemiluminescent	2	2	1.5
415886.6362	433045.9582	4	Thornton Road	CM5	Roadside	NO2	Chemiluminescent		2	1.5
416974.7938	433242.6187	5	Shipley Airedale Road	CM6	Roadside	NO2; PM10	Chemiluminescent	2	2	2.7
417860.0331	430704.991699999	6	Rook Lane	CM7	Roadside	NO2	Chemiluminescent	1	1.5	1.5
419186.9734	430214.481699999	7	Tong Street	CM8	Roadside	NO2; PM10	Chemiluminescent		5.8	2.7


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "name" VARCHAR,
  "site_id" VARCHAR,
  "site_type" VARCHAR,
  "pollutants_monitored" VARCHAR,
  "monitoring_technique" VARCHAR,
  "distance_to_relevant_exposure" BIGINT,
  "dist_to_kerb_of_nearest_road" DOUBLE,
  "inlet_height" DOUBLE
);