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 |