Skip to content
About the data
About the data

How to read 142,387 recorded plants, and what sits behind them

Every number in this app comes from the same 5,456 records. This page says what a record is, what is still open, how precise the history can be, and how the totals check against WRT’s own workbook.

Recorded plants, not verified plantings

The planting history was not counted in the ground. It was filled in from the nursery’s allocation sheets: the Plants Out Master was updated from what was allocated to each site, then retyped into the master workbook. So each figure is what the records say was sent to a site for a season, which is why this app says recorded plants and never “planted”.

Read a total as the best written record of what went to a site, not as a count of what is growing there today. Survival and losses are not in the history, and neither are the dates plants went in.

Where a figure is still open for a WRT ruling, this app keeps it visible beside the total rather than folding it in or leaving it out. The bars use green for plants on records that need no ruling and amber for those that do.

What still needs a WRT ruling

142,387recorded plants in all
127,097 resolved · 15,290 on 629 records needing review (11%)

629 records (12%) carry 15,290 recorded plants (11%) that WRT has to rule on or confirm once. Until then the plants stay in the totals, flagged, and are never removed or guessed at.

A ruling is a decision only WRT can make, such as whether two names are one species. A confirmation is a quick check that a site was matched to the right column. Notes that only say how a site was mapped (mapping notes) do not flag a record.

Threatened species: marked by WRT, but on what basis?

Needs WRT’s answer before any threatened-species figure is reported. 16 species carry a threatened mark, but no file says which threat list or year the mark follows, and WRT’s two lists disagree on 8 of them.

WRT marks threatened species in two places: a T in the Master Plant List of the Plants Out Master (13 species), and a # before the name in the Te Kakano restoration plant species list (11 species). They agree on 8.

Why this has to be asked rather than looked up: a threatened mark should be checkable against the list it came from. Here there is nothing to check it against. Neither list names its source or the year it was set, and threat rankings change over time. Mānuka and kānuka are the clearest case: Te Kakano marks them, the Plants Out Master does not.

Species WRT marks threatened, by list
SpeciesPlants Out Master (T)Te Kakano list (#)Lists agree?Recorded plantsSites
Olearia lineata✓✓Both mark it5,875317 need review27
Olearia fimbriata✓✓Both mark it4,672175 need review25
MākakaCarmichaelia petriei✓✓Both mark it2,720106 need review22
Coprosma virescens✓✓Both mark it2,335160 need review19
Hectors tree daisyOlearia hectorii✓✓Both mark it2,249202 need review24
Coprosma intertexta✓✓Both mark it91727 need review15
MatagouriDiscaria toumatou✓✓Both mark it7155 need review8
Fragrant tree daisyOlearia fragrantissima✓✓Both mark it50115 need review12
Scented tree daisyOlearia odorata✓–Plants Out Master only5,884253 need review22
MānukaLeptospermum scoparium–✓Te Kakano only2,182148 need review20
Fierce lancewoodPseudopanax ferox✓–Plants Out Master only85513 need review15
Veronica cupressoides✓–Plants Out Master only661661 need review14
RōhutuLophomyrtus obcordata✓–Plants Out Master only17325 need review8
Carmichaelia crassicaulis✓–Plants Out Master only2525 need review1
Kunzea robusta–✓Te Kakano onlyNot in the history–
Kunzea serotina–✓Te Kakano onlyNot in the history–

Questions for WRT

  1. Which threat list, and which year, does the mark follow? For example the national threat classification for plants, and its edition. Without that, nobody can check a mark or keep it up to date.
  2. Should mānuka, Kunzea robusta and Kunzea serotina be marked? The Te Kakano list marks them; the Plants Out Master does not.
  3. Should the 5 species marked only in the Plants Out Master stay marked? They are scented tree daisy, fierce lancewood, Veronica cupressoides, rōhutu and Carmichaelia crassicaulis.
  4. Is the yearly threatened-plants count reported to anyone (DOC, the council, a funder)? The workbook counted it from 2015 to 2023 and then stopped.
See the marked species in the species list →

The app shows WRT’s marks as they are. It does not add, remove or correct any until WRT answers.

How precise the records are

Most records know only four things: a site, a species, a season and a quantity. There are no planting dates, event types, volunteer numbers, photographs, coordinates or polygons anywhere in the history, so none are shown. Detail below the level of a parcel is recorded on 12 records.

By precision

ParcelRecorded against a registered parcel within a site. 3,028 records · 55%81,6686,952 need review
SiteRecorded against a whole site. 2,243 records · 41%56,7036,841 need review
SchemeRecorded against an order scheme, not a place. 160 records · 3%1,4571,457 need review
Planting areaRecorded against a named area inside a parcel. 12 records · <1%200
UnknownThe source column did not say where. 13 records · <1%2,35940 need review

By confidence

High confidenceSite and species matched cleanly. 4,214 records · 77%88,619
Medium confidenceA site or species needed a judgement call. 1,055 records · 19%52,07113,593 need review
Low confidenceAn order scheme, or the source did not say where. 187 records · 3%1,6971,697 need review

Bars are drawn to the same scale within each list. Amber is the part still needing review.

Checked against WRT’s own totals

All 23 seasons match. For every season, the records add to exactly the total WRT’s workbook states for it.

Each season’s total from the records against the total cell in the workbook
SeasonRecords add toWorkbook totalResult
Autumn 20152,0682,068Matches
Spring 20153,4833,483Matches
Autumn 20163,1763,176Matches
Spring 20164,3314,331Matches
Autumn 20174,5164,516Matches
Spring 20174,6674,667Matches
Autumn 20184,5894,589Matches
Spring 20183,4583,458Matches
Autumn 20195,0785,078Matches
Spring 20195,4005,400Matches
Autumn 2020996996Matches
Spring 20207,5727,572Matches
Autumn 20215,1335,133Matches
Spring 20215,3565,356Matches
Autumn 20225,8695,869Matches
Spring 20225,0145,014Matches
Autumn 20234,8864,886Matches
Spring 20235,7205,720Matches
Autumn 202413,65713,657Matches
Spring 202429,82629,826Matches
Autumn 20254,4694,469Matches
Spring 20256,2486,248Matches
Autumn 20264,5564,556Matches

Where the data comes from

Read from the Trust's Supabase database, imported from the MASTER sheet of WRT's Plants Out Master workbook: one line per species, site and season.

Every record keeps its origin. It carries the site, species and season exactly as they were typed, plus the source workbook, sheet and cell. Open Source on any row of a record table to see them, for example the planting records.

The app reads the Supabase database. The workbook history was imported separately, and every record keeps the source cell it came from.

seasons24 rows
species164 rows
sites39 rows
areas79 rows
planting lines5,456 rows

What this version does not do

  • It does not edit anything. This is a reading copy of the history. Corrections go back to WRT and the source files, not into this app.
  • It does not show current nursery stock, seed lots or potting. It covers plants that went out, not plants being grown.
  • It has no maps. The history holds no coordinates or boundaries, so a map would have to invent them.
  • The numbers will change. When WRT rules on the open questions above, flagged plants move into the resolved totals, are merged or are set aside, and the figures here will be re-checked against the workbook.

38 sites, 97 species, 24 seasons loaded.