{"id":"7b1041ff-dcd1-43eb-b093-cc478f377ce8","type":"API","name":"Drinking Water Points - New Zealand - OSM data","slug":"drinking-water-points-new-zealand-osm-data","description":"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...","free_access_class":"UNKNOWN","auth_type":"UNKNOWN","homepage_url":"https://public.opendatasoft.com/explore/dataset/osm-new-zealand-drinking-water/","docs_url":"https://public.opendatasoft.com/explore/dataset/osm-new-zealand-drinking-water/","repo_url":null,"status":"ACTIVE","verification_state":"UNVERIFIED","tags":[],"logo_url":"https://s3-eu-west-1.amazonaws.com/aws-ec2-eu-1-opendatasoft-staticfileset/public/favicon?tstamp=17592198215867405","primary_source_url":"https://public.opendatasoft.com/explore/dataset/osm-new-zealand-drinking-water/","extraction_confidence":"0.00","created_at":"2026-07-25T02:28:04.996Z","updated_at":"2026-07-25T03:47:08.910Z","last_verified_at":null,"deprecated_at":null,"ranking_score":0,"last_ranked_at":null,"last_seen_at":null,"last_validated_at":null,"last_uptime_at":null,"search_vector":"'addit':49B 'additional':100B 'and':65B,80B 'are':99B 'base':21B 'based':72B 'by':82B 'compil':28B 'compiled':79B 'data':7A,24B,58A,75B 'dataset':9B,60B 'drink':1A,11B 'drinking':52A,62B 'element':43B 'elements':94B 'field':44B 'fields':95B 'fountain':13B 'fountains':64B 'geoloc':10B 'geolocates':61B 'in':67B 'inform':50B 'information':101B 'is':71B,77B,85B 'it':70B,84B 'meta':47B,98B 'most':91B 'new':4A,17B,55A,68B 'on':73B 'opendatasoft':32B,83B 'openstreetmap':23B,42B,74B,93B 'osm':6A,57A 'point':3A,15B 'points':54A,66B 'prefix':45B 'prefixed':96B 'pro':51B,102B 'process':30B 'processed':81B 'recent':41B,92B 'retriev':38B 'retrieve':89B 'the':90B 'then':78B 'this':59B 'to':88B 'updat':35B 'updated':86B 'water':2A,12B,53A,63B 'week':36B 'weekly':87B 'which':76B 'with':97B 'zealand':5A,18B,56A,69B","popularity_score":"0.0000","maintenance_score":"0.0000","institution_id":null,"institution_type":null,"country_code":"FR","official_confidence":0,"proof_summary":"Confidence: 0%","source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-25T16:39:59.667Z","geographic_scope":"NATIONAL","name_en":null,"description_en":null,"native_lang":null,"access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":13.75,"access":{"level":"direct","primary":{"kind":"download","label":"Export CSV","method":"GET","url":"https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},"actions":[{"kind":"download","label":"Export CSV","method":"GET","url":"https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"List records","method":"GET","url":"https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water/records?limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Select & filter","method":"GET","url":"https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water/records?select=name%2Coperator%2Caccepts_bottle&where=name+is+not+null&limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"API base URL","method":"GET","url":"https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water","source":"base_url","runnable":false},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://public.opendatasoft.com/explore/dataset/osm-new-zealand-drinking-water/","source":"docs","runnable":false}],"formats":["CSV"]},"api_details":{"id":"e1f59a28-2630-4730-abed-218265922f90","entry_id":"7b1041ff-dcd1-43eb-b093-cc478f377ce8","base_url":"https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water","openapi_url":null,"graphql_url":null,"api_version":null,"spec_format":null,"endpoints_count":null,"endpoints":[],"rate_limit_info":null,"free_tier_limits":null,"ping_url":"https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water","created_at":"2026-07-25T02:28:05.162Z","updated_at":"2026-07-25T02:28:05.162Z"},"dataset_details":{"id":"beecc5d6-51fa-4f5a-aa14-102b24cbc888","entry_id":"7b1041ff-dcd1-43eb-b093-cc478f377ce8","upstream_issued":null,"upstream_modified":"2026-06-30T12:04:25.000Z","themes":[],"update_frequency":"monthly","temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":null,"license_id":null,"license_raw":null,"has_documentation":false,"has_data_dictionary":false,"has_versioning":false,"source_portal":"opendatasoft","source_portal_url":"https://public.opendatasoft.com","created_at":"2026-07-25T02:37:59.672Z","updated_at":"2026-07-25T02:37:59.672Z","publisher":null,"publisher_url":null,"distributions":[],"license":null},"license":{"id":"odbl-1.0","spdx_id":"ODbL-1.0","name":"Open Data Commons Open Database License 1.0","url":"https://opendatacommons.org/licenses/odbl/1-0/","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"open_data","notes":null,"created_at":"2026-06-12T16:29:19.729Z"},"license_raw":"https://www.opendatacommons.org/licenses/odbl/1.0/","latest_check":null,"data_profile":{"id":"92d02e7c-12ff-4bb0-baa4-a355ba7e0012","entry_id":"7b1041ff-dcd1-43eb-b093-cc478f377ce8","profile_source":"opendatasoft","profile_kind":"dataset","dataset_id":"osm-new-zealand-drinking-water","fields":[{"name":"name","type":"text","label":null,"filterable":true,"description":null},{"name":"operator","type":"text","label":null,"filterable":true,"description":null},{"name":"accepts_bottle","type":"text","label":"Bottle-friendly","filterable":true,"description":"Is it easy to fill a bottle (yes/no)?"},{"name":"fee","type":"text","label":null,"filterable":true,"description":"Is access paid (yes/no)?"},{"name":"indoor","type":"text","label":null,"filterable":true,"description":"Is the fountain located indoors (yes/no)?"},{"name":"offers_cold_water","type":"text","label":"Cold Water","filterable":true,"description":"Does the fountain provide cold water (yes/no)?"},{"name":"offers_warm_water","type":"text","label":"Warm Water","filterable":true,"description":"Does the fountain provide warm water (yes/no)?"},{"name":"offers_hot_water","type":"text","label":"Hot Water","filterable":true,"description":"Does the fountain provide hot water (yes/no)?"},{"name":"description","type":"text","label":null,"filterable":true,"description":"Additional descriptions"},{"name":"meta_geo_point","type":"geo_point_2d","label":"OSM Point","filterable":false,"description":"OSM entity geolocation"},{"name":"meta_osm_id","type":"text","label":"OSM Id","fill_pct":100,"filterable":true,"description":"OSM entity identifier"},{"name":"meta_osm_url","type":"text","label":"OSM URL","fill_pct":100,"filterable":true,"description":"OSM entity URL"},{"name":"meta_first_update","type":"datetime","label":"OSM Creation date","fill_pct":100,"filterable":true,"description":"OSM entity creation date"},{"name":"meta_last_update","type":"date","label":"OSM Last update","fill_pct":100,"filterable":true,"description":"OSM entity update date"},{"name":"meta_versions_number","type":"int","label":"OSM Versions","fill_pct":100,"filterable":true,"description":"Number of versions for the OSM entity"},{"name":"meta_users_number","type":"int","label":"OSM Contributors","fill_pct":100,"filterable":true,"description":"Number of OSM contributors"}],"field_count":16,"sample_records":[{"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},{"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},{"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},{"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},{"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}],"record_count":"1890","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water/records?limit=20","curl":"curl -s 'https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water/records?limit=20' -H 'Accept: application/json'","label":"List records","method":"GET","description":"First 20 records of the dataset as JSON."},{"url":"https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water/records?select=name%2Coperator%2Caccepts_bottle&where=name+is+not+null&limit=20","curl":"curl -s 'https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water/records?select=name%2Coperator%2Caccepts_bottle&where=name+is+not+null&limit=20' -H 'Accept: application/json'","label":"Select & filter","method":"GET","description":"Project specific fields (name, operator, accepts_bottle) and filter with ODSQL where clauses."},{"url":"https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water/exports/csv","curl":"curl -sL 'https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/osm-new-zealand-drinking-water/exports/csv' -o dataset.csv","label":"Export CSV","method":"GET","description":"Full dataset export as CSV (also available: json, parquet, xlsx)."}],"status":"ok","error_message":null,"profiled_at":"2026-07-25T02:37:59.170Z","run_id":"6c8df4cb-cd53-4491-aaa4-28bff6320eaf","created_at":"2026-07-25T02:37:59.170Z","updated_at":"2026-07-25T02:37:59.170Z","license_raw":"https://www.opendatacommons.org/licenses/odbl/1.0/","license_id":"odbl-1.0","previewable":true},"datasets":[],"limits":[{"id":"775fc11d-c84a-4b5f-8b8e-28b0f0fee43c","entry_id":"7b1041ff-dcd1-43eb-b093-cc478f377ce8","limit_type":"requests_per_day","value":"10000000","unit":"requests","period":"day","scope":"per-ip","source_id":null,"claim_type":"measured","confidence":"0.90","observed_at":"2026-07-25T02:37:59.834Z"}]}