Leeds Allotments
Leeds City Council
@ukgov.leeds_allotments
Leeds City Council
@ukgov.leeds_allotments
CREATE TABLE council_managed_allotments_april_2014 (
"allotment_site" VARCHAR,
"location" VARCHAR,
"plot_size_0_124m2" VARCHAR,
"plot_size_125m2_249m2" DOUBLE,
"plot_size_250m2" DOUBLE,
"plot_size_250m2_acde02" DOUBLE,
"vacancies" VARCHAR,
"waiting_list_no" DOUBLE,
"facilities" VARCHAR
);
CREATE TABLE council_managed_allotments_july_2014 (
"allotment_site" VARCHAR,
"location" VARCHAR,
"plot_size_0_124m2" VARCHAR,
"plot_size_125m2_249m2" DOUBLE,
"plot_size_250m2" DOUBLE,
"plot_size_250m2_acde02" DOUBLE,
"vacancies" VARCHAR,
"waiting_list_no" DOUBLE,
"facilities" VARCHAR
);
CREATE TABLE council_managed_allotments_september_2014 (
"allotment_site" VARCHAR,
"location" VARCHAR,
"plot_size_0_124m_sq" DOUBLE,
"plot_size_125m_sq_249m_sq" DOUBLE,
"plot_size_250m_sq" DOUBLE,
"plot_size_250m_sq_94987f" DOUBLE,
"vacancies" VARCHAR,
"waiting_list_no" DOUBLE,
"facilities" VARCHAR
);
CREATE TABLE council_managed_allotments_september_2015 (
"allotment_site" VARCHAR,
"location" VARCHAR,
"plot_size_0_124m_sq" BIGINT,
"plot_size_125m_sq_249m_sq" BIGINT,
"plot_size_250m_sq" BIGINT,
"plot_size_250m_sq_94987f" BIGINT,
"vacancies" BIGINT,
"waiting_list_no" VARCHAR,
"facilities" VARCHAR
);
CREATE TABLE privately_managed_allotments_april_2014 (
"allotment_site" VARCHAR,
"location" VARCHAR,
"plot_size_0_124m2" BIGINT,
"plot_size_125m2_249m2" BIGINT,
"plot_size_250m2" BIGINT,
"plot_size_250m2_acde02" BIGINT,
"vacancies" VARCHAR,
"waiting_list_no" VARCHAR,
"facilities" VARCHAR
);
CREATE TABLE privately_managed_allotments_september_2014 (
"allotment_site" VARCHAR,
"location" VARCHAR,
"plot_size_0_124m_sq" BIGINT,
"plot_size_125m_sq_249m_sq" BIGINT,
"plot_size_250m_sq" BIGINT,
"plot_size_250m_sq_94987f" BIGINT,
"vacancies" VARCHAR,
"waiting_list_no" VARCHAR,
"facilities" VARCHAR
);
CREATE TABLE privately_managed_allotments_september_2015 (
"allotment_site" VARCHAR,
"location" VARCHAR,
"plot_size_0_124m_sq" BIGINT,
"plot_size_125m_sq_249m_sq" BIGINT,
"plot_size_250m_sq" BIGINT,
"plot_size_250m_sq_94987f" BIGINT,
"vacancies" VARCHAR,
"waiting_list_no" VARCHAR,
"facilities" VARCHAR
);
Anyone who has the link will be able to view this.