About this Dataset

Car Parks In South Lakeland

Details the car parks that are owned or managed by South Lakeland District Council. Includes opening hours, charging periods, tariff rates and pay by phone information Contains Ordnance Survey data © Crown Copyright and database right 2014
Publisher name: South Lakeland District Council
Last updated: 2024-09-10T23:31:57Z

Tables

Car Parks In South Lakeland

@ukgov.car_parks_in_south_lakeland.car_parks_in_south_lakeland

28.76 kB
57 rows
30 columns

CREATE TABLE car_parks_in_south_lakeland (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "carparklocationtext" VARCHAR,
  "carparkname" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" DOUBLE,
  "geoy" DOUBLE,
  "geopointlicensingurl" VARCHAR,
  "sldcown_manage" VARCHAR,
  "sldcownspaces" DOUBLE,
  "singlespaces" DOUBLE,
  "disabledspaces" DOUBLE,
  "coachspaces" DOUBLE,
  "electricchargingpoint" VARCHAR,
  "postcode" VARCHAR,
  "geoareauri" VARCHAR,
  "geoarealabel" VARCHAR,
  "opentimes" VARCHAR,
  "charge" VARCHAR,
  "chargeperiod" VARCHAR,
  "charges_allunitspounds_pence" VARCHAR  -- Charges(AllUnitsPounds.Pence),
  "motorcyclesfree" VARCHAR,
  "paybyphone" VARCHAR,
  "paybyphonenumber" VARCHAR,
  "notes" VARCHAR,
  "infourl" VARCHAR,
  "unnamed_29" VARCHAR  -- Unnamed: 29
);

2018

@ukgov.car_parks_in_south_lakeland.n_2018

35.49 kB
56 rows
35 columns

CREATE TABLE n_2018 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "carparklocationtext" VARCHAR,
  "carparkname" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" BIGINT,
  "geoy" BIGINT,
  "geopointlicensingurl" VARCHAR,
  "sldcown_manage" VARCHAR,
  "sldcownspaces" BIGINT,
  "singlespaces" BIGINT,
  "disabledspaces" BIGINT,
  "coachspaces" DOUBLE,
  "electricchargingpoint" BIGINT,
  "postcode" VARCHAR,
  "geoareauri" VARCHAR,
  "geoarealabel" VARCHAR,
  "opentimes" VARCHAR,
  "charge" VARCHAR,
  "tarifftype" VARCHAR,
  "chargeperiod" VARCHAR,
  "charges_allunitspounds_pence" VARCHAR  -- Charges(AllUnitsPounds.Pence),
  "bluebadgecharge" VARCHAR,
  "sldcparkingpermitaccepted" VARCHAR,
  "n_3and7daypassesaccepted" VARCHAR  -- 3And7DayPassesAccepted,
  "specialoffer" VARCHAR,
  "motorcyclesfree" VARCHAR,
  "paybyphone" VARCHAR,
  "paybyphonenumber" VARCHAR,
  "heightrestriction" VARCHAR,
  "notes" VARCHAR,
  "infourl" VARCHAR
);

2019

@ukgov.car_parks_in_south_lakeland.n_2019

38.7 kB
56 rows
39 columns

CREATE TABLE n_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "carparklocationtext" VARCHAR,
  "carparkname" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" BIGINT,
  "geoy" BIGINT,
  "geopointlicensingurl" VARCHAR,
  "sldcown_manage" VARCHAR,
  "sldcownspaces" BIGINT,
  "singlespaces" BIGINT,
  "disabledspaces" BIGINT,
  "coachspaces" DOUBLE,
  "electricchargingpoint" BIGINT,
  "bicyclespaces" BIGINT,
  "motorcyclespaces" BIGINT,
  "parentandchildspaces" BIGINT,
  "reservedspaces" BIGINT,
  "postcode" VARCHAR,
  "geoareauri" VARCHAR,
  "geoarealabel" VARCHAR,
  "opentimes" VARCHAR,
  "charge" VARCHAR,
  "tarifftype" VARCHAR,
  "chargeperiod" VARCHAR,
  "charges_allunitspounds_pence" VARCHAR  -- Charges(AllUnitsPounds.Pence),
  "bluebadgecharge" VARCHAR,
  "sldcparkingpermitaccepted" VARCHAR,
  "n_3and7daypassesaccepted" VARCHAR  -- 3And7DayPassesAccepted,
  "specialoffer" VARCHAR,
  "motorcyclesfree" VARCHAR,
  "paybyphone" VARCHAR,
  "paybyphonenumber" VARCHAR,
  "heightrestriction" VARCHAR,
  "notes" VARCHAR,
  "infourl" VARCHAR
);