Air Quality Monitoring Sites

Leeds City Council

@ukgov.air_quality_monitoring_sites7

Table List

1 table(6.02 KB)

Automatic Monitoring Sites

@ukgov.air_quality_monitoring_sites7.automatic_monitoring_sites

6.02 KB
11 rows
7 columns

site_id Site ID	site_name Site Name	site_type Site Type	x_os_grid_ref X OS Grid Ref	y_os_grid_ref Y OS Grid Ref	distance_to_kerbside_m2 Distance To Kerbside (m2)	inlet_height_m Inlet Height (m)
A1	Leeds Centre (AURN)	Urban Centre	429969	434259	N/A	2.7
A2	Corn Exchange	Kerbside	430358	433422	1	2.7
A3	Headingley (AURN Affiliated)	Kerbside	427989	436045	1	2.7
A6	Haslewood Close	Roadside	431268	433701	7	3.3
A9	Jack Lane, Hunslet	Roadside	430731	431911	5	2.7
A17	Kirkstall Rd	Roadside	427147	434789	5	2.7
A18	Temple Newsam	Other	435940	432271	N/A	2.4
A19	Tilbury Terrace	Roadside	428830	431657	15	1.5
A20	International Pool	Roadside	429329	433672	4	1.5
A21	Bishopgate Street	Roadside	429932	433370	3	1.5


CREATE TABLE automatic_monitoring_sites (
  "site_id" VARCHAR,
  "site_name" VARCHAR,
  "site_type" VARCHAR,
  "x_os_grid_ref" BIGINT,
  "y_os_grid_ref" BIGINT,
  "distance_to_kerbside_m2" VARCHAR,
  "inlet_height_m" DOUBLE
);