An Amsterdam visitor-service team is preparing a toilet site directory for a kiosk. The kiosk must distinguish explicitly public access from restricted and unknown access; an unlabeled record must never be presented as public. The handover also has a null position and a stale repeated source row.
Prepare the downloaded amsterdam-toilet-access-raw layer and upload one GeoPackage layer named toilet_sites.
| Incoming issue | Required delivery |
|---|---|
Repeated toilet_id | Keep the lowest source_order. |
| Missing geometry | Omit that row. |
access_raw differs in case or padding | Trim and lowercase. Map yes/public to public, private/customers to restricted, all other or missing values to unknown. |
Return exactly toilet_id (text) and access_class (text), with Point geometry genuinely reprojected to EPSG:28992 (Amersfoort / RD New). The file format is GeoPackage and its layer is toilet_sites.
amsterdam-toilet-access-raw — GeoJSON, EPSG:4326, Point / geometry. The fields arrive under these names:
| field | type | meaning |
|---|---|---|
toilet_id | text | OSM node reference |
access_raw | text | Incoming access tag or unknown |
source_order | integer | Priority order in incoming file |
Converting this layer to a Shapefile cuts a field name to ten characters — source_order becomes source_ord — so read the names back after any conversion rather than assuming them.
These are where the teaching is. Read them twice.
Modelled on a Amsterdam GIS data handover using © OpenStreetMap contributors (ODbL 1.0). ISO 19157-1:2023 frames quality as fitness against the stated product specification.
Download the data from the Data tab, prepare it in the tool you use — QGIS, ArcGIS Pro, FME, GDAL or a script — and upload what came out.
Deliver as GeoPackage, layer toilet_sites, in EPSG:28992.
Read shows what the file was read as; Submit grades it. The file itself is not kept — what was read from it is.
6 scored, 0 informational
Toilet identities, classes and positions match the rules
45%GeoPackage contains the named toilet layer
15%Coordinates are in the Dutch national CRS
10%Access class is an explicit three-value domain
10%Every accepted toilet has point geometry
10%Only kiosk fields are delivered
10%
