About this Dataset

Public Toilets

This dataset is no longer updated. For details of public conveniences managed by Leeds City Council please visit the Council Land and Building Assets dataset. This dataset shows a list of public conveniences in Leeds. The list contains those toilets mainly managed by Leeds City Council however we would like to expand this list to include other locations e.g. in shopping centres. If you would like to contribute to this list, please contact us at the email address below. Local Government Association/Open Data Institute ------------------------------------------------ Leeds City Council is participating in a scheme run by the LGA and ODI to standardise datasets from local authorities. Public toilets, premises licences, and planning datasets have been identified first to pilot this scheme.
Publisher name: Leeds City Council
Last updated: 2024-09-11T01:48:05Z

Tables

05/11/2015

@ukgov.public_toilets_datamill.n_05_11_2015

24.76 KB
30 rows
32 columns


CREATE TABLE n_05_11_2015 (
  "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" VARCHAR,
  "postcode" VARCHAR,
  "streetaddress" VARCHAR,
  "geoareauri" VARCHAR,
  "geoarealabel" VARCHAR
);

12/12/2016

@ukgov.public_toilets_datamill.n_12_12_2016

26.13 KB
37 rows
32 columns


CREATE TABLE n_12_12_2016 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "locationtext" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" DOUBLE,
  "geoy" DOUBLE,
  "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" VARCHAR,
  "postcode" VARCHAR,
  "streetaddress" VARCHAR,
  "geoareauri" VARCHAR,
  "geoarealabel" VARCHAR
);

14/10/2014

@ukgov.public_toilets_datamill.n_14_10_2014

24.55 KB
31 rows
32 columns


CREATE TABLE n_14_10_2014 (
  "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" BIGINT,
  "infourl" VARCHAR,
  "openinghours" VARCHAR,
  "managedby" VARCHAR,
  "reportemail" VARCHAR,
  "reporttel" VARCHAR,
  "notes" VARCHAR,
  "uprn" VARCHAR,
  "postcode" VARCHAR,
  "streetaddress" VARCHAR,
  "geoareauri" VARCHAR,
  "geoarealabel" VARCHAR
);

23/09/2014

@ukgov.public_toilets_datamill.n_23_09_2014

24.63 KB
32 rows
32 columns


CREATE TABLE n_23_09_2014 (
  "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" BIGINT,
  "infourl" VARCHAR,
  "openinghours" VARCHAR,
  "managedby" VARCHAR,
  "reportemail" VARCHAR,
  "reporttel" VARCHAR,
  "notes" VARCHAR,
  "uprn" VARCHAR,
  "postcode" VARCHAR,
  "streetaddress" VARCHAR,
  "geoareauri" VARCHAR,
  "geoarealabel" VARCHAR
);