When one of the installations in the Rooted in Art project went up next door, and I discovered that all of the trees in the city have an ID number, as part of an “urban tree inventory,” I got very curious about that data, and I requested a copy from the City of Charlottetown. This request was turned around quickly: I needed to sign and return a “digital data agreement,” and I received a CSV file with records on 10,000 trees shortly thereafter.
It turns out that the inventory is not of every tree in the city, only the “street trees,” as described here. One of the things I gleaned from that explainer is that we have too many maple trees. Apparently a diverse tree population doesn’t have more than 10% of the same species; the inventory counts 24% Norway maples.
To run this test myself, I imported the CSV file into a MySQL table, and ran this query:
select count(*) from `trees`.`UrbanTreeInventory` where `species` = 'Maple Norway (Acer platanoides)'
Sure enough, there are 2,384 Norway Maple trees in the inventory – 24% of the total.
There are 133 species in the inventory in all; here are the top 10, by count:
2384 Maple Norway (Acer platanoides)
1372 Spruce White (Picea glauca)
787 Linden Littleleaf (Tilia cordata)
537 Birch White (Betula papyrifera)
451 Maple Red (Acer rubrum)
374 Oak Red (Quercus rubra)
362 Ash Green (Fraxinus pennsylvanica)
220 Maple Sugar (Acer saccharum)
166 Maple Silver (Acer saccharinum)
138 Ash White (Fraxinus americana)
This comes from this MySQL query:
select species,count(*) as howmany from `trees`.`UrbanTreeInventory` group by species order by howmany DESC
The diameter of each tree is in the inventory too; there are 73 trees with a diameter of more than 100 cm. To see these I used this MySQL query:
select species,latitude,longitude,diameter from `trees`.`UrbanTreeInventory` where diameter >= 100 order by diameter DESC
I exported the result from that query as a CSV and imported it into geojson.io to see these big trees on a map:

The tree with the largest diameter is 155 cm across, a silver maple in St. Clair Park in Brighton. I had to go and take a look at this tree for myself, so I stopped writing this blog post, grabbed my bicycle, and went to do some field research:

Careful map-readers will note that I made two stops along the way: first at Lady Baker’s Tea to pick up some organic Assam tea (with th bonus of a chat with friends Sandy and Katherine), second at Brighton Clover Farm to purchase some sumac and some green wheat.
Continuing on through to deepest, toniest Brighton, I came to the aforementioned St. Clair Park, upon which I’d never laid eyes; truth be told, I’d never noticed that St. Clair Avenue runs up the western side of West Kent Elementary School.
Once I arrived at the park, I took advantage of having added the large silver maple to OpenStreetMap just before I left; this allowed me to walk right up to it, phone in hand:

And it is, indeed, a grand tree:

It’s 155 cm diameter can be explained, in part, by it’s hydra-headed base:

St. Clair Park turns out to be home to eight of the top-100 trees, by diameter, all of them silver maples:

While I was standing in St. Clair Park, looking at its impressive community of trees, I wanted to know more about each one, but I didn’t have ready access to the inventory database on my phone. Which has me thinking that a mobile “hey, what’s that tree?” app might need to be added to my project list.
So, what do we do about having too many maples?
Here’s what the city has to say:
- Plant fewer maple trees… but don’t stop planting them as we don’t want a big gap in the succession of the urban forest where there are no maples
- Stop planting Norway maples – they are invasive. The City has not been planting Norway maples in our Parks for over 13 years and have not been planted as street trees for a number of years
- Look for and plant alternate tree species that serve the same purpose (foliage color, shade tree, etc.) in the urban forest. More tree species means greater biodiversity and forest health
We may have too many maple trees for our own good, but those ones in St. Clair Park are awfully impressive, and I recommend you pay the park a visit while they are still in leaf; it’s a wonderful part of the urban landscape to experience in the autumn.