Air Quality Diffusion Tubes
City of York Council
@ukgov.diffusion_tubes_locations
City of York Council
@ukgov.diffusion_tubes_locations
CREATE TABLE air_quality_diffusion_tubes (
"x" BIGINT,
"y" BIGINT,
"objectid" BIGINT,
"site_id" VARCHAR,
"site_name" VARCHAR,
"site_type" VARCHAR,
"xos" BIGINT,
"yos" BIGINT,
"aqma" VARCHAR,
"relevant_e" DOUBLE,
"kerb" DOUBLE,
"f2015_mean" DOUBLE,
"f2016_mean" DOUBLE,
"f2017_mean" DOUBLE,
"f2018_mean" DOUBLE,
"f2019_mean" DOUBLE,
"f2005_mean" DOUBLE,
"f2006_mean" DOUBLE,
"f2007_mean" DOUBLE,
"f2008_mean" DOUBLE,
"f2009_mean" DOUBLE,
"f2010_mean" DOUBLE,
"f2011_mean" DOUBLE,
"f2012_mean" DOUBLE,
"f2013_mean" DOUBLE,
"f2014_mean" DOUBLE,
"f2020_mean" DOUBLE,
"f2021_mean" DOUBLE,
"f2022_mean" DOUBLE,
"f2023_mean" DOUBLE
);
Anyone who has the link will be able to view this.