CSV Lint ALPHA

Back to Recent Schemas

Schema Information

http://schemas.opendata.esd.org.uk/publictoilets/PublicToilets.json?v=0.43

Download schema

Fields

Index Column Heading Required Unique Type Value Constraints Title/Description
1 ExtractDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
 Extract Date
The date that the data was last extracted from its source database or manually updated
2 OrganisationURI Yes No URI Organisation URI
URI from ODC of publishing organisation
3 OrganisationLabel Yes No String Organisation Label
Label of publishing organisation. If empty uses this will be the same as the publishing organisation
4 ServiceTypeURI Yes No URI Service Type URI
Service URI from http://id.esd.org.uk/list/services
5 ServiceTypeLabel Yes No String Service Type Label
Label of the Service Type URI
6 LocationText Yes No String Location Text
Name of building, street, park etc.
7 CoordinateReferenceSystem Yes No String Pattern: (WGS84|OSGB36|)
 Co-ordinate Reference System
‘WGS84’ (http://en.wikipedia.org/wiki/WGS84) or ‘OSGB36’ (http://en.wikipedia.org/wiki/Ordnance_Survey_National_Grid). WGS84 is the default.
8 GeoX Yes No Float Geo X
Longitude or east grid reference for centroid of application boundary
9 GeoY Yes No Float Geo Y
Latitude or north grid reference for centroid of application boundary
10 GeoPointLicensingURL Yes No URI Geo Point Licensing URL
URL of any page that describes any licensing restrictions on using the northing and easting.
11 Category Yes No String Pattern: (Female|Male|Female and Male|Unisex|Male urinal|Children only|None|)
 Category
Use `None` if only accessible
12 AccessibleCategory Yes No String Pattern: (Female|Male|Female and Male|Unisex|Male urinal|Children only|None|)
 Accessible Category
Use `None` if not accessible
13 RADARKeyNeeded Yes No String Pattern: (true|True|TRUE|false|False|FALSE|yes|Yes|YES|no|No|NO|)
 RADAR Key Needed
Flag to show whether a RADAR Key is needed
14 BabyChange Yes No String Pattern: (true|True|TRUE|false|False|FALSE|yes|Yes|YES|no|No|NO|)
 Baby Change
Flag to show whether there are baby changing facilities
15 FamilyToilet Yes No String Pattern: (true|True|TRUE|false|False|FALSE|yes|Yes|YES|no|No|NO|)
 Family Toilet
Flag to show whether there is a family toilet
16 ChangingPlace Yes No String Pattern: (true|True|TRUE|false|False|FALSE|yes|Yes|YES|no|No|NO|)
 Changing Place
Flag to indicate whether the toilet includes changing facilities for people with profound and multiple learning disabilities and their carers, as well as many other disabled people. See http://www.changing-places.org/
17 AutomaticPublicConvenience Yes No String Pattern: (true|True|TRUE|false|False|FALSE|yes|Yes|YES|no|No|NO|)
 Automatic Public Convenience
Flag to indicate whether this is an automatic public convenience (aka superloo)
18 FullTimeStaffing Yes No String Pattern: (true|True|TRUE|false|False|FALSE|yes|Yes|YES|no|No|NO|)
 Full Time Staffing
Flag to indicate whether there is full time staffing
19 PartOfCommunityScheme Yes No String Pattern: (true|True|TRUE|false|False|FALSE|yes|Yes|YES|no|No|NO|)
 Part Of Community Scheme
Flag to indicate whether it is part of a community scheme
20 CommunitySchemeName Yes No String Community Scheme Name
The name of the community scheme
21 ChargeAmount Yes No Float Charge Amount
Charge amount in GBP to two decimal places. Omit the currency symbol
22 InfoURL Yes No URI Info URL
URL of web page describing the facilities
23 OpeningHours Yes No String Opening Hours
Opening Hours
24 ManagedBy Yes No String Managed By
Name of organisation managing the toilet
25 ReportEmail Yes No String Pattern: (^[a-zA-Z0-9.!#$%&'*+/=?^_`{|}~-]+@[a-zA-Z0-9](?:[a-zA-Z0-9-]{0,61}[a-zA-Z0-9])?(?:.[a-zA-Z0-9](?:[a-zA-Z0-9-]{0,61}[a-zA-Z0-9])?)*$|)
 Report Email
Email address for reporting problems
26 ReportTel Yes No String Report Telephone
Telephone number for reporting problems
27 Notes Yes No String Notes
Notes on reporting, accesibility, hours or anything else
28 UPRN Yes No String UPRN
Unique Property Reference Number of the toilet
29 Postcode Yes No String Pattern: (^([A-PR-UWYZ0-9][A-HK-Y0-9][AEHMNPRTVXY0-9]?[ABEHMNPRVWXY0-9]? {1,2}[0-9][ABD-HJLN-UW-Z]{2}|GIR 0AA)$|)
 Postcode
Postcode of the toilet
30 StreetAddress Yes No String Street Address
Street address of the toilet
31 GeoAreaURI Yes No String Geo Area URI
A predefined spatial area that the application is contained in. Note that these can be derived from X/Y co-ordinates. Comma delimit in spreadsheet where there is more than one
32 GeoAreaLabel Yes No String Geo Area Label
Labels of the Geo Area URI. Comma delimit in spreadsheet where there is more than one
Download Example CSV File