Parking Spaces Manchester
Manchester City Council
@ukgov.http_www_manchester_gov_uk_open_download_downloads_id__d4bed47e
Manchester City Council
@ukgov.http_www_manchester_gov_uk_open_download_downloads_id__d4bed47e
CREATE TABLE parking_spaces_2016 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"effective_date" VARCHAR,
"order_type" VARCHAR,
"street_name" VARCHAR,
"start" VARCHAR,
"finish" VARCHAR,
"estparkingplaces" BIGINT
);
CREATE TABLE parking_spaces_2017 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"date_from" TIMESTAMP,
"order_type" VARCHAR,
"street_nam" VARCHAR,
"start" VARCHAR,
"finish" VARCHAR,
"estparkingplaces" BIGINT
);
CREATE TABLE parking_spaces_2018 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"effective_date" VARCHAR,
"order_type" VARCHAR,
"street_nam" VARCHAR,
"start" VARCHAR,
"finish" VARCHAR,
"estparkingplaces" BIGINT
);
CREATE TABLE parking_spaces_2019 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"effective_date" VARCHAR,
"order_type" VARCHAR,
"street_nam" VARCHAR,
"start" VARCHAR,
"finish" VARCHAR,
"estparkingplaces" BIGINT
);
CREATE TABLE parking_spaces_2021 (
"effective" VARCHAR,
"order_type" VARCHAR,
"street_nam" VARCHAR,
"start" VARCHAR,
"finish" VARCHAR,
"estparkingplaces" BIGINT
);
CREATE TABLE parking_spaces_2023 (
"effective" TIMESTAMP,
"order_type" VARCHAR,
"street_nam" VARCHAR,
"start" VARCHAR,
"finish" VARCHAR,
"estparkingplaces" BIGINT
);
CREATE TABLE parking_spaces_2024 (
"effective" TIMESTAMP,
"order_type" VARCHAR,
"street_nam" VARCHAR,
"start" VARCHAR,
"finish" VARCHAR,
"estparkingplaces" DOUBLE
);
Anyone who has the link will be able to view this.