Canterbury Groundwater — Data Extraction Tool

Extract, compile and download the data layers needed for the offline demo model

How this works: This tool runs entirely in your browser. It contacts public APIs directly (ECan ArcGIS, Stats NZ) and the LAWA data is processed from a file you provide. No data is sent to any third party. Downloads are saved directly to your computer. Run each layer independently — they do not depend on each other.

Extraction Summary

—
ECan wells extracted
—
LAWA sites processed
—
Localities loaded
0
Files ready to download
📊
Layer 1 — LAWA Canterbury Groundwater Quality
Process the LAWA groundwater quality CSV (downloaded from lawa.org.nz) into a clean JSON lookup and CSV. Computes E. coli detection rates and nitrate statistics per monitoring site.
CC BY 4.0 386 sites expected Source: lawa.org.nz/download-data → Groundwater Quality → Canterbury
📂
Click to select the LAWA Groundwater Quality file
lawa-groundwater-quality-dataset_*.xlsx or .csv — drag and drop here
Waiting for file
🔩
Layer 2 — ECan Wells Database
Paginates through ECan's public ArcGIS API to extract all Canterbury wells with water quality records. Typically 5,000–8,000 wells across multiple batches of 2,000.
Public API No key required ECan ArcGIS MapServer/17
Ready
📍
Layer 3 — Canterbury Locality Lookup
Fetches Canterbury place names and coordinates from the Stats NZ / LINZ geographic names dataset. Used to resolve place-name queries in the offline model.
Public API CC BY 4.0 Stats NZ / LINZ Geographic Names
Ready
🧱
Layer 4 — Aquifer Classification
Generates a pre-authored Canterbury aquifer zone reference table based on ECan's published hydrogeology. This is a curated static dataset — no API required.
Static / Authored Based on ECan State of Environment reports
Ready
🌾
Layer 5 — Land Use Summary
Generates a Canterbury land use reference table by district and zone — compiled from ECan and Stats NZ agricultural census data. Static authored dataset.
Static / Authored ECan SOE report + Stats NZ Agricultural Census
Ready
🌧
Layer 6 — ECan Rainfall Gauge Network
Extracts all Canterbury rainfall monitoring gauge locations and site metadata from ECan's ArcGIS FeatureServer. Useful for coverage analysis and dynamic risk modelling.
Public API No key required ECan WaterQualityandMonitoring/FeatureServer/5
Ready
🌱
Layer 7 — S-Map Soil Attributes
Extracts drainage class, nitrogen leaching risk, bypass flow potential, and permeability from Landcare Research S-Map layer 0 hosted on ECan's ArcGIS server. All key attributes are in one layer — no cross-layer join needed.
Public API No key required ECan Landcare_SMap_Layers/MapServer/0
Ready
🏞
Layer 8 — LAWA Canterbury River Water Quality
Process a LAWA river/stream water quality CSV to extract E. coli and nitrate statistics per monitoring site. Identifies surface water contamination pathways reaching groundwater.
CC BY 4.0 File upload Source: lawa.org.nz → River Water Quality → Canterbury
📂
Click to select the LAWA River Water Quality file
LAWA_River_Water_Quality_Monitoring_Data_*.xlsx or .csv — drag and drop here
Waiting for file
🚰
Layer 9 — Community Drinking Water Supply Points
All Canterbury community drinking water supply source locations with well number, supply name, owner, supply type, aquifer classification, and protection zone linkage. Direct API extraction from ECan — no manual export needed.
Public API No key required ECan Resource_Consents/MapServer/18 + FeatureServer/12
Ready
🏔
Layer 10 — LAWA River Water Quality (State & Trend)
Per-site median concentrations and national quartile benchmarks for 11 indicators across 152 Canterbury river monitoring sites. Key surface water pressure context for nearby bores.
CC BY 4.0 File upload Source: lawa.org.nz → River Water Quality → State & Trend → Canterbury
📂
Click to select the LAWA River WQ State & Trend file
lawa-river-water-quality-state-and-trend-results_*.xlsx or .csv
Waiting for file
🦋
Layer 11 — LAWA River Ecology (Macroinvertebrates)
MCI, QMCI, ASPM and EPT taxa richness with NPS-FM attribute bands (A–D) for 178 Canterbury river sites. Accepts the State & Trend XLSX or the raw Monitoring Results XLSX — both are processed into per-site summaries.
CC BY 4.0 File upload Source: lawa.org.nz → River Ecology → Canterbury
📂
Click to select the LAWA River Ecology file
lawa-river-ecology-state-and-trend-results_*.xlsx or lawa-river-ecology-monitoring-data_*.xlsx or .csv
Waiting for file
💧
Layer 12 — LAWA Lake Water Quality
Trophic state, E. coli, cyanobacteria, nutrients and clarity for 49 Canterbury lakes. Includes NPS-FM attribute bands and 2024 median/maximum values.
CC BY 4.0 File upload Source: lawa.org.nz → Lakes → Canterbury
📂
Click to select the LAWA Lake Quality file
lawa-lake-quality-dataset_*.xlsx or .csv
Waiting for file
🗺
Layer 13 — Catchment Land Cover Summary
Process the LAWA land cover XLSX directly (lawa-land-cover-data_oct2025.xlsx). Extracts all 50 Canterbury catchments from the "Catchment Broad" sheet, computes dairy intensity, cropland, agricultural pressure index, and automatically geolocates each catchment via flow site name-matching.
CC BY 4.0 XLSX upload Source: lawa-land-cover-data_oct2025.xlsx → Catchment Broad sheet
📂
Click to select lawa-land-cover-data_oct2025.xlsx
Also accepts pre-processed JSON · Extracts Canterbury catchments + auto-geolocates
Waiting for file
🌊
Layer 14 — River Flow & Stage Monitoring Sites
Upload River_Flow_and_Stage_Monitoring_Sites.csv from Canterbury Maps, or try the API (ECan MapServer/6 is often blocked for full data queries). CSV automatically converts NZTM coordinates to WGS84.
CSV upload recommended Canterbury Maps · ECan WaterQualityandMonitoring/MapServer/6
📂
Click to select River_Flow_and_Stage_Monitoring_Sites.csv
Also accepts pre-processed JSON · 16 cols · NZTM coords converted automatically
Upload CSV or try API
💎
Layer 15 — Canterbury Aquifer Boundaries
Unconfined/semiconfined aquifer polygon boundaries from ECan's Groundwater server. Extracts per-polygon centroids by converting NZTM2000 polygon vertices to WGS84, plus bounding boxes. Returns one record per polygon (149 total) rather than a collapsed summary.
Public API No key required ECan Groundwater/MapServer/7 · NZTM→WGS84 vertex conversion
Ready
💦
Layer 16 — Irrigated Areas & Irrigation Schemes
Upload LWRP_-_Irrigation_Scheme_Area.csv from Canterbury Maps, or try the API (ECan MapServer/0 and /24 are often blocked). Stores the Canterbury-wide LWRP irrigation scheme boundary.
CSV upload recommended Canterbury Maps · ECan Irrigation/MapServer/0 + LWRP/MapServer/24
📂
Click to select LWRP_-_Irrigation_Scheme_Area.csv
Also accepts pre-processed JSON · Single Canterbury-wide boundary record
Upload CSV or try API
⚠
Layer 17 — Discharge Consents (Water & Land)
Upload Discharge_to_Water_-_Consented_Activities.csv and/or Discharge_to_Land_-_Consented_Activities.csv from ECan. Upload one then the other — both are merged. Active consents only; NZTM converted to WGS84. Land discharges use two-tier output: dairy/leachate/farm waste as point records, human effluent and stormwater as catchment summaries.
CSV upload (3.7 MB water / 22 MB land) ECan · download from ecan.govt.nz open data
📂
Click to select Discharge_to_Water or Discharge_to_Land CSV
Upload one or both (sequentially) — files are merged · Also accepts pre-processed JSON
Upload CSV file(s)
💎
Layer 18 — Canterbury Aquifer Classification
Pre-authored aquifer zone reference table — 15 Canterbury zones with aquifer type, material, vulnerability, nitrate/E. coli risk, and geographic bounding boxes for spatial lookup. Fully self-contained: click Generate — no file needed.
Static / Authored Geolocated ECan SOE hydrogeology + zone bounding boxes — no upload required
Ready
🌡
Layer 19 — NIWA Climate Station Network
Pre-processed NIWA CliFlo Canterbury climate station network — 349 stations with coordinates, available parameters, and record date ranges. Upload the niwa_climate_stations_canterbury.json file.
Pre-processed JSON File upload Source: niwa_climate_stations_canterbury.json
📂
Click to select niwa_climate_stations_canterbury.json
128 active + 221 historical Canterbury climate stations
Waiting for file
🗺
Layer 20 — Groundwater Flow Lines
Upload Groundwater_Flow_Lines.csv from Canterbury Maps. Summarises historical groundwater flow line surveys (segment counts and total length by survey name). Line geometry is not in the source CSV.
CSV upload Canterbury Maps / ECan · 4 surveys · OBJECTID, SurveyName, ShapeSTLength
📂
Click to select Groundwater_Flow_Lines.csv
3 columns · OBJECTID, SurveyName, ShapeSTLength (m)
Waiting for file
🏥
Layer 21 — Canterbury Health Context
Waterborne disease notification rates, health thresholds, risk factors and key outbreak events for Canterbury and South Canterbury. Upload the health_context_canterbury.json file.
Pre-processed JSON File upload Source: health_context_canterbury.json · EHINZ CC BY 4.0 / PHF Science CC BY 4.0
📂
Click to select health_context_canterbury.json
Disease rates, risk factors, health thresholds, key outbreak events
Waiting for file
📦
Export All — Combined JSON for Claude Project
Once layers are extracted, download a single combined JSON file ready to attach directly to your Claude Project as a knowledge file. Includes LAWA groundwater + surface water + river WQ + river ecology + lake quality, Wells, Localities, Rainfall Gauges, S-Map Soils, Drinking Water Supplies, and Catchment Land Cover.
Complete at least LAWA Groundwater + ECan Wells extractions first — additional layers enrich the combined file