Leeds Clean Air Zone - Compliance Modelling 2021
Leeds City Council
@ukgov.leeds_clean_air_zone_compliance_modelling_2021
Leeds City Council
@ukgov.leeds_clean_air_zone_compliance_modelling_2021
CREATE TABLE appendix_7_clean_air_zone_modelling_data_2018 (
"siteid" VARCHAR,
"x" BIGINT,
"y" BIGINT,
"validation_zone" VARCHAR,
"n_2015" DOUBLE,
"n_2020" DOUBLE,
"n_2022" DOUBLE,
"unnamed_7" VARCHAR,
"n_2020_caz_b" DOUBLE,
"n_2022_caz_b" DOUBLE,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR
);
CREATE TABLE appendix_7_clean_air_zone_modelling_data_2020 (
"siteid" VARCHAR,
"x" BIGINT,
"y" BIGINT,
"validation_zone" VARCHAR,
"dm20_anpr" DOUBLE,
"dm21_anpr" DOUBLE,
"dm21_contraflow_a_anpr" DOUBLE,
"dm21_contraflow_b_anpr" DOUBLE,
"unnamed_8" VARCHAR,
"dm21_contraflow_a_anpr_105" DOUBLE,
"dm21_contraflow_b_anpr_105" DOUBLE,
"unnamed_11" VARCHAR,
"dm20_anpr_bus50" DOUBLE,
"dm20_anpr_bus70" DOUBLE
);
Anyone who has the link will be able to view this.