← All calculations

Calculation report · proof of concept · SKD-POC-03

Auckland: the Anniversary Weekend flood, 27 January 2023

Auckland cell hex_015_010, yearly peak rainfall above normal, 2012 to 2023
Auckland, cell hex_015_010: highest 72-hour IMERG rainfall above the cell's own normal per year, 2012 to 2022 (backtest years) and the January 2023 event. One cell = 25 mm; the line is the cell's 1-in-10 tier at 137.8 mm; amber cells reached it. Backtest on public data.
Peril
Extreme rainfall · pluvial flood
Source
NASA IMERG satellite rainfall
Period
Event of 26 to 28 Jan 2023, normals from 2008 to 2022
Backtest
Not scored against losses
Rainfall data
CHIRPS v2 production ends after December 2026; new work uses CHIRPS v3, with a re-backtest.
Cells triggered73 / 26910 km hexagons
Event payoutEUR 7.8Mlimit EUR 250k per cell
Share of exposure paid11.6%one event, not a rate on line
Trigger window72 hrain above the cell’s own normal
hex_015_010 peak 182 mm above normal
1-in-10 · 138 → 20% 1-in-25 · 159 → 50% 1-in-50 · 175 → 100% Jan 2023 event · T3
Cell hex_015_010, one of the cells paying in full. 72-hour IMERG rainfall above this cell’s own normal, January 2023, against its 1-in-10 / 25 / 50 ladder (paying 20 / 50 / 100%).

Context

Peak 72-hour rainfall above each cell's own seasonal normal, across the largest insured weather loss in New Zealand's history.

On the evening of 27 January 2023 Auckland recorded 280 mm of rain in under 24 hours and 211 mm in under six, at Albert Park. NIWA assessed it as at least a 1-in-200-year rainfall. It produced 59,189 insurance claims worth NZ$1.98 billion (ICNZ, to 1 March 2024), the largest insured weather loss in the country's record.

This is PLUVIAL flood: rain falling faster than drainage can carry it away. It is not river flooding, and the two are deliberately not mixed. Cyclone Gabrielle's Hawke's Bay flooding three weeks later was fluvial, a different hazard variable with a different index.

The hazard is IMERG satellite rainfall, chosen on evidence rather than convenience. ERA5 was tested and never ranks this event first in its own year: zero of 35 cells around Auckland put it first, and every one of them ranked Cyclone Gabrielle above it, inverting the loss ordering. CHIRPS cannot express a sub-daily extreme at all: its daily values are a five-day total redistributed by cloud duration. At the cell over central Auckland IMERG ranks the event first at every window tested, as do about two in three cells around the city, and it puts its peak intensity at 18:30 that evening, about ninety minutes after the documented 5 p.m. onset of the flooding.

The index is a departure from normal, not a raw depth. Each IMERG grid cell is compared against its OWN 72-hour normal for that day of the year, built from 15 years of record pooled over a fifteen-day window, which gives 225 samples per calendar day. Thresholds are per grid cell too, fitted to that cell's own annual maxima, so the same rainfall is ordinary in a wet place and exceptional in a dry one. The payout units are 269 hexes of 10 km circumradius, kept whole where their centre is on land. A hex takes its wettest grid cell against the mean of its cells' thresholds, so a hex reaches its first tier in about one year in six rather than one in ten.

The thresholds are fitted on 2008-2022, so any cost quoted from those same years is in-sample and flatters a fitted tail: the ladder already knows how big the biggest years were. IMERG's record starts in 1998, so the ladder was re-scored on 1998-2007, a decade neither the climatology nor the thresholds have ever seen, with nothing refitted. It costs 5.7% of exposure out of sample against 5.9% in sample, a ratio of 0.97. The pricing is therefore not an artefact of the years it was built on, which is the one thing an in-sample number cannot tell you.

Where the method stops

Limits of this calculation.

  1. 01

    Return periods are this index's own, not the atmosphere's. NIWA called the rainfall 1-in-200 at a gauge; the same event falls between this index's 1-in-5 and 1-in-10 levels for the 100 km² grid cell over that gauge, while the hex containing it reached tier 1 through a wetter neighbouring cell. A tier means 'the 1-in-N event for a 100 km² cell as measured by IMERG', never 'a 1-in-N rainfall'.

  2. 02

    IMERG reads 43-56% of a rain gauge inside the same cell. The under-read cancels in the trigger only because the thresholds come from the same instrument.

  3. 03

    Rainfall is the CAUSE of pluvial flooding, not the flooding itself. Drainage capacity, antecedent wetness and imperviousness all sit between the two.

  4. 04

    IMERG Final lags about 3.5 months, so this is a backtest and pricing input. The Early run at ~4 hours is the live path, and is not what this POC runs on.

  5. 05

    Payout-versus-loss is unscored. No per-location loss series exists: the Auckland property categorisation measures future risk to life rather than 2023 damage, and NHC claims cover residential land only.

  6. 06

    The upper two tiers extrapolate beyond the 15-year record (1-in-50 is 3.3 times it) and are flagged as such in the artifact. A 1-in-100 tier was rejected for that reason.

Want this run on your own trigger?