SLDC Parking Account
South Lakeland District Council
@ukgov.sldc_parking_account
South Lakeland District Council
@ukgov.sldc_parking_account
CREATE TABLE parking_account_2018_to_2019 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"on_streetparkingincometype" VARCHAR,
"on_streetparkingincomeamount" DOUBLE,
"off_streetparkingincometype" VARCHAR,
"off_street_parkingincomeamount" DOUBLE,
"expendituretype" VARCHAR,
"expenditureamount" DOUBLE,
"surplusamount" DOUBLE,
"surplusspendtype" VARCHAR,
"surplusspendamount" DOUBLE,
"parkingspacesnumber" DOUBLE,
"freeparkingspacesnumber" DOUBLE,
"charged_forparkingspacesnumber" DOUBLE
);
CREATE TABLE sldc_parking_account (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"on_streetparkingincometype" VARCHAR,
"on_streetparkingincomeamount" DOUBLE,
"off_streetparkingincometype" VARCHAR,
"off_street_parkingincomeamount" DOUBLE,
"expendituretype" VARCHAR,
"expenditureamount" DOUBLE,
"surplusamount" DOUBLE,
"surplusspendtype" VARCHAR,
"surplusspendamount" VARCHAR,
"parkingspacesnumber" DOUBLE,
"freeparkingspacesnumber" DOUBLE,
"charged_forparkingspacesnumber" DOUBLE
);
Anyone who has the link will be able to view this.