Air Quality Summary Statistics

Greater London Authority

@ukgov.air_quality_summary_statistics

Table List

1 table(43.62 KB)

Annual-objectives-by-site-and-species

@ukgov.air_quality_summary_statistics.annual_objectives_by_site_and_species

43.62 KB
7449 rows
16 columns

sitecode SiteCode	sitename SiteName	sitetype SiteType	latitude Latitude	longitude Longitude	latitudewgs84 LatitudeWGS84	longitudewgs84 LongitudeWGS84	sitelink SiteLink	dataowner DataOwner	datamanager DataManager	speciescode SpeciesCode	speciesdescription SpeciesDescription	year Year	objectivename ObjectiveName	value Value	achieved Achieved
A30	Kingston - Kingston Bypass A3	Roadside	51.373553348648	-0.291969827871431	6687638.8951	-32501.9325656	http://www.londonair.org.uk/london/asp/publicstats.asp?site=A30	Kingston	King's College London	CO	Carbon Monoxide	1999	10 mg/m3 as a maximum daily running 8 hour mean		YES
A30	Kingston - Kingston Bypass A3	Roadside	51.373553348648	-0.291969827871431	6687638.8951	-32501.9325656	http://www.londonair.org.uk/london/asp/publicstats.asp?site=A30	Kingston	King's College London	CO	Carbon Monoxide	2000	10 mg/m3 as a maximum daily running 8 hour mean		YES
A30	Kingston - Kingston Bypass A3	Roadside	51.373553348648	-0.291969827871431	6687638.8951	-32501.9325656	http://www.londonair.org.uk/london/asp/publicstats.asp?site=A30	Kingston	King's College London	CO	Carbon Monoxide	2001	10 mg/m3 as a maximum daily running 8 hour mean		YES
A30	Kingston - Kingston Bypass A3	Roadside	51.373553348648	-0.291969827871431	6687638.8951	-32501.9325656	http://www.londonair.org.uk/london/asp/publicstats.asp?site=A30	Kingston	King's College London	CO	Carbon Monoxide	2002	10 mg/m3 as a maximum daily running 8 hour mean		YES
A30	Kingston - Kingston Bypass A3	Roadside	51.373553348648	-0.291969827871431	6687638.8951	-32501.9325656	http://www.londonair.org.uk/london/asp/publicstats.asp?site=A30	Kingston	King's College London	CO	Carbon Monoxide	2003	10 mg/m3 as a maximum daily running 8 hour mean		YES
A30	Kingston - Kingston Bypass A3	Roadside	51.373553348648	-0.291969827871431	6687638.8951	-32501.9325656	http://www.londonair.org.uk/london/asp/publicstats.asp?site=A30	Kingston	King's College London	CO	Carbon Monoxide	2004	10 mg/m3 as a maximum daily running 8 hour mean		YES
A30	Kingston - Kingston Bypass A3	Roadside	51.373553348648	-0.291969827871431	6687638.8951	-32501.9325656	http://www.londonair.org.uk/london/asp/publicstats.asp?site=A30	Kingston	King's College London	CO	Carbon Monoxide	2005	10 mg/m3 as a maximum daily running 8 hour mean		YES
A30	Kingston - Kingston Bypass A3	Roadside	51.373553348648	-0.291969827871431	6687638.8951	-32501.9325656	http://www.londonair.org.uk/london/asp/publicstats.asp?site=A30	Kingston	King's College London	CO	Carbon Monoxide	2006	10 mg/m3 as a maximum daily running 8 hour mean		YES
A30	Kingston - Kingston Bypass A3	Roadside	51.373553348648	-0.291969827871431	6687638.8951	-32501.9325656	http://www.londonair.org.uk/london/asp/publicstats.asp?site=A30	Kingston	King's College London	DUST	PM10 (not reference equiv.)	2004	40 ug/m3 as an annual mean	26	YES
A30	Kingston - Kingston Bypass A3	Roadside	51.373553348648	-0.291969827871431	6687638.8951	-32501.9325656	http://www.londonair.org.uk/london/asp/publicstats.asp?site=A30	Kingston	King's College London	DUST	PM10 (not reference equiv.)	2005	40 ug/m3 as an annual mean	31	YES


CREATE TABLE annual_objectives_by_site_and_species (
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "sitetype" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "latitudewgs84" DOUBLE,
  "longitudewgs84" DOUBLE,
  "sitelink" VARCHAR,
  "dataowner" VARCHAR,
  "datamanager" VARCHAR,
  "speciescode" VARCHAR,
  "speciesdescription" VARCHAR,
  "year" BIGINT,
  "objectivename" VARCHAR,
  "value" BIGINT,
  "achieved" VARCHAR
);