Drinking Water Points - New Zealand - OSM data
This dataset geolocates drinking water fountains and points in New Zealand. It is based on OpenStreetMap data, which is then compiled and processed by Opendatasoft. It is updated weekly to retrieve the most recent OpenStreetMap elements. Fields prefixed with 'meta_' are additional information pro...
Trust score
How is this computed?Weighted across five axes. Tap a ring for what it measures.
Data schema (16 fields)
Click a field to see example values.
| Fill | Field | Type | Description |
|---|---|---|---|
| — | name | text | — |
| — | operator | text | — |
| — | accepts_bottleBottle-friendly | text | Is it easy to fill a bottle (yes/no)? |
| — | fee | text | Is access paid (yes/no)? |
| — | indoor | text | Is the fountain located indoors (yes/no)? |
| — | offers_cold_waterCold Water | text | Does the fountain provide cold water (yes/no)? |
| — | offers_warm_waterWarm Water | text | Does the fountain provide warm water (yes/no)? |
| — | offers_hot_waterHot Water | text | Does the fountain provide hot water (yes/no)? |
| — | description | text | Additional descriptions |
| — | meta_geo_pointOSM Point | geo_point_2d | OSM entity geolocation |
| 100% | meta_osm_idOSM Id | text | OSM entity identifier |
| 100% | meta_osm_urlOSM URL | text | OSM entity URL |
| 100% | meta_first_updateOSM Creation date | datetime | OSM entity creation date |
| 100% | meta_last_updateOSM Last update | date | OSM entity update date |
| 100% | meta_versions_numberOSM Versions | int | Number of versions for the OSM entity |
| 100% | meta_users_numberOSM Contributors | int | Number of OSM contributors |
Schema captured from opendatasoft 1 hour ago.
Query the data
Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.
Sample data (5 records)
Record 1fee: yes · name: Shining Star Beachfront Accommodation
{
"fee": "yes",
"name": "Shining Star Beachfront Accommodation",
"indoor": null,
"operator": null,
"description": null,
"meta_osm_id": "88292110",
"meta_osm_url": "https://www.openstreetmap.org/way/88292110",
"accepts_bottle": null,
"meta_geo_point": {
"lat": -42.7071214828874,
"lon": 170.974024014863
},
"meta_last_update": "2025-05-03",
"offers_hot_water": null,
"meta_first_update": "2010-12-06T21:53:37+00:00",
"meta_users_number": 12,
"offers_cold_water": null,
"offers_warm_water": null,
"meta_versions_number": 21
}Record 2fee: — · name: Hastings Top 10 Holiday Park
{
"fee": null,
"name": "Hastings Top 10 Holiday Park",
"indoor": null,
"operator": null,
"description": null,
"meta_osm_id": "149093756",
"meta_osm_url": "https://www.openstreetmap.org/way/149093756",
"accepts_bottle": null,
"meta_geo_point": {
"lat": -39.6481619556694,
"lon": 176.861394478671
},
"meta_last_update": "2026-03-25",
"offers_hot_water": null,
"meta_first_update": "2012-02-07T05:59:42+00:00",
"meta_users_number": 2,
"offers_cold_water": null,
"offers_warm_water": null,
"meta_versions_number": 8
}Record 3fee: — · name: Manapouri Motel and Holiday Park
{
"fee": null,
"name": "Manapouri Motel and Holiday Park",
"indoor": null,
"operator": null,
"description": null,
"meta_osm_id": "215815220",
"meta_osm_url": "https://www.openstreetmap.org/way/215815220",
"accepts_bottle": null,
"meta_geo_point": {
"lat": -45.5592448647627,
"lon": 167.620886504624
},
"meta_last_update": "2025-05-03",
"offers_hot_water": null,
"meta_first_update": "2013-04-06T19:10:00+00:00",
"meta_users_number": 9,
"offers_cold_water": null,
"offers_warm_water": null,
"meta_versions_number": 15
}Record 4fee: — · name: Lake Ferry Holiday Park
{
"fee": null,
"name": "Lake Ferry Holiday Park",
"indoor": null,
"operator": null,
"description": null,
"meta_osm_id": "280413668",
"meta_osm_url": "https://www.openstreetmap.org/way/280413668",
"accepts_bottle": null,
"meta_geo_point": {
"lat": -41.3899550986591,
"lon": 175.145180993681
},
"meta_last_update": "2025-01-23",
"offers_hot_water": null,
"meta_first_update": "2014-05-09T02:13:47+00:00",
"meta_users_number": 3,
"offers_cold_water": null,
"offers_warm_water": null,
"meta_versions_number": 8
}Record 5fee: yes · name: Driftaway Queenstown Holiday Park
{
"fee": "yes",
"name": "Driftaway Queenstown Holiday Park",
"indoor": null,
"operator": null,
"description": null,
"meta_osm_id": "385512122",
"meta_osm_url": "https://www.openstreetmap.org/way/385512122",
"accepts_bottle": null,
"meta_geo_point": {
"lat": -45.0172354756368,
"lon": 168.725549013199
},
"meta_last_update": "2026-04-19",
"offers_hot_water": null,
"meta_first_update": "2015-12-12T03:37:00+00:00",
"meta_users_number": 4,
"offers_cold_water": null,
"offers_warm_water": null,
"meta_versions_number": 15
}Live sample captured at profiling time — values may have changed upstream.
Using the API
Configuration
- Base URL
- https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water
License
- ✓ Redistributable
- ✓ Attribution required
Query examples
curl -s 'https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water/records?limit=20' -H 'Accept: application/json'First 20 records of the dataset as JSON.
Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.
Rate limits
Dataset
Volume & freshness
License
No license declared upstream.
Source: opendatasoft
Machine-readable & source
Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.