About this Dataset

Public Toilets In South Lakeland

Public Toilet information for South Lakeland district area including any run by Town and Parish Councils and Kendal Courtesy Toilet Scheme. The dataset has been produced according to the Local Government Open Data Incentive Scheme Public Toilet Schema. Contains Ordnance Survey data © Crown Copyright and database right 2014
Publisher name: South Lakeland District Council
Last updated: 2024-09-14T17:23:08Z

Tables

2019

@ukgov.public_toilets_in_south_lakeland.n_2019

31.74 kB
52 rows
32 columns

CREATE TABLE n_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "locationtext" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" BIGINT,
  "geoy" BIGINT,
  "geopointlicensingurl" VARCHAR,
  "category" VARCHAR,
  "accessiblecategory" VARCHAR,
  "radarkeyneeded" VARCHAR,
  "babychange" VARCHAR,
  "familytoilet" VARCHAR,
  "changingplace" VARCHAR,
  "automaticpublicconvenience" VARCHAR,
  "fulltimestaffing" VARCHAR,
  "partofcommunityscheme" VARCHAR,
  "communityschemename" VARCHAR,
  "chargeamount" DOUBLE,
  "infourl" VARCHAR,
  "openinghours" VARCHAR,
  "managedby" VARCHAR,
  "reportemail" VARCHAR,
  "reporttel" VARCHAR,
  "notes" VARCHAR,
  "uprn" DOUBLE,
  "postcode" VARCHAR,
  "streetaddress" VARCHAR,
  "geoareauri" VARCHAR,
  "geoarealabel" VARCHAR
);

Public Toilets In South Lakeland

@ukgov.public_toilets_in_south_lakeland.public_toilets_in_south_lakeland

31.08 kB
49 rows
32 columns

CREATE TABLE public_toilets_in_south_lakeland (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "locationtext" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" BIGINT,
  "geoy" BIGINT,
  "geopointlicensingurl" VARCHAR,
  "category" VARCHAR,
  "accessiblecategory" VARCHAR,
  "radarkeyneeded" VARCHAR,
  "babychange" VARCHAR,
  "familytoilet" VARCHAR,
  "changingplace" VARCHAR,
  "automaticpublicconvenience" VARCHAR,
  "fulltimestaffing" VARCHAR,
  "partofcommunityscheme" VARCHAR,
  "communityschemename" VARCHAR,
  "chargeamount" DOUBLE,
  "infourl" VARCHAR,
  "openinghours" VARCHAR,
  "managedby" VARCHAR,
  "reportemail" VARCHAR,
  "reporttel" VARCHAR,
  "notes" VARCHAR,
  "uprn" DOUBLE,
  "postcode" VARCHAR,
  "streetaddress" VARCHAR,
  "geoareauri" VARCHAR,
  "geoarealabel" VARCHAR
);