๐ŸŒณ torontotrees
May 2026 ยท data archaeology ยท 689,013 rows, three weird ones

Three trees I can't explain

Toronto's street-tree dataset has 689,013 rows. Most of them are exactly what you would expect โ€” a Norway maple in front of a 1960s North York bungalow, a honey locust on a Liberty Village condo block, a young Kentucky coffeetree on a freshly-planted Bayview boulevard. Reasonable trees in reasonable places, recorded with reasonable accuracy.

But it's a 689,013-row dataset, and 689,013-row datasets always have a long tail of what. Anomalies. Typos. Trees that physically can't exist where the data says they exist. Categories that quietly contain ten percent of the city's cherry trees because nobody had time to identify them. Single specimens of species that aren't supposed to grow this far north and probably do anyway.

Here are three I keep coming back to.

1. The 250-centimetre hawthorn at 44 Antioch Drive

Anomaly: physically impossible

According to treeto.ca, the largest catalogued tree at 44 Antioch Drive in Eringate-Centennial-West Deane is a hawthorn (Crataegus) with a trunk diameter at breast height of 250 centimetres. A trunk diameter of 250 cm is two and a half metres across. You could roll a refrigerator through it.

Hawthorns do not get this big. Anywhere. The largest documented hawthorn trunks in the world max out around 70 cm DBH, and those are veteran specimens in English hedgerows three centuries old. A typical mature city hawthorn โ€” and Toronto plants them as small ornamentals โ€” runs 15 to 30 cm. The 44 Antioch tree is, on the data's own terms, eight times the species's biological maximum.

The explanation is buried in the dataset's processing pipeline. The City of Toronto stores DBH as an integer in centimetres, and at some point in the inventory's history a value of 250 appears to have been used as either a cap or a default. Four trees in the dataset are exactly 250 cm โ€” the hawthorn at Antioch, a corkscrew willow at 73 Leggett Ave (also implausible at 2.5 m), an unidentified "Oak" at 293 Chaplin Crescent (possible but very large), and a silver maple at 78 Burnhamthorpe (the only one of the four that's plausibly real). My data pipeline now caps DBH at 200 cm to drop these from leaderboards, but the raw value is still in the source.

I don't know what's actually at 44 Antioch. There is a hawthorn there, presumably. It is presumably 25 cm across. Someone in 2014 typed 250 instead of 25 in a city database and it has been there ever since.

2. Four thousand six hundred cherries the city can't tell apart

Anomaly: institutional ambiguity

If you query the dataset for trees with the botanical name Prunus spp. โ€” the genus Prunus, the species deliberately left blank, "spp." being shorthand for "species, take your pick" โ€” you get 4,664 trees. That is a third of all the cherry, plum, and almond trees the City of Toronto plants on its streets. Two-thirds of all street trees in the genus Prunus are catalogued precisely; one-third are catalogued with botanical handwave.

Some of this is plausible. Prunus is a genus that hybridizes promiscuously and produces hundreds of cultivars; in the field, distinguishing a Prunus serrulata 'Kanzan' from a Prunus subhirtella 'Pendula' from a Prunus ร— yedoensis 'Akebono' requires looking at flowers, leaves, bark, and growth form together. An arborist measuring a leafless street cherry in November may not be able to tell which species it is, and choosing not to guess is the conscientious option.

But the geographic pattern is suspicious. The "Prunus spp." catch-all clusters in Oakwood Village (174 of them), Stonegate-Queensway (161), Briar Hill-Belgravia (131), Mimico-Queensway (113). These are all neighbourhoods with substantial post-1990 boulevard plantings of ornamental cherries. Somewhere there is โ€” or was โ€” a contractor who planted these, and a city inspector who walked them, and an entry-form workflow that didn't make species identification mandatory.

So 4,664 of Toronto's street trees are essentially "some kind of cherry; figure it out yourself in April." There is something quietly wonderful about this. It also means every analysis we do on cherry-blossom timing, cherry-tree density, or cherry species diversity is missing one tree in three.

3. Toronto's only pawpaw, on Macdonell Avenue

Anomaly: real, marvellous, alone

The pawpaw (Asimina triloba) is the largest fruit native to Canada. It is a Carolinian-zone tree at the very northern edge of its range in southern Ontario, producing a custard-like tropical fruit that tastes, by reliable account, like a cross between mango, banana, and butterscotch. It does not transplant, doesn't ship, doesn't ripen off the tree, and isn't sold in grocery stores anywhere in Canada except a small ring of pick-your-own farms in Niagara. Most Torontonians have never seen one and most have never tasted the fruit.

Toronto has, in its street-tree inventory, exactly one.

It is at 39 Macdonell Avenue in Roncesvalles. It has a trunk diameter of 6 cm โ€” meaning it is young, recently planted, probably under fifteen years old. Whoever requested it from the city's Request-a-Tree program in the early 2010s either knew exactly what they were asking for or got astonishingly lucky. (The City's own current planting list does not include pawpaw.)

It is featured as Stop 4 on the Roncesvalles rare-tree walk. If you have never seen one, this is the easiest pawpaw in central Toronto to walk past.

I cannot explain how it got there. I love that it is there.

What this teaches you about a public dataset

The City of Toronto Street Tree Data is, on the whole, an extraordinary civic artefact. 689,013 trees catalogued, georeferenced to within metres, species-identified on most rows, freely downloadable, refreshed irregularly but kept current as the inventory grows. Treeto.ca exists at all because this data exists.

And it has typos. It has cap-truncation artefacts. It has 4,664 trees the city couldn't be bothered (or couldn't manage) to identify down to species. It has solitary specimens of trees that probably shouldn't have been planted in 2010 and definitely shouldn't have been planted before 1990. It is the work of thousands of inspectors and contractors and arborists across forty years of inventory campaigns, and it carries every fingerprint of the human process behind it.

The strangest entries are the ones I trust most.

โ† All posts