Projects | ZOO-trees | Tree_Size_Summary

Model | Table | Browse | Export as CSV

Elapsed 6 msec

       

Class Small  
Count 220   🛈 sum(table('Tree_Survey')[Class = $self/Class]/Onsite_Trees)
Unsuitable Count 2   🛈 sum(table('Tree_Survey')[Class = $self/Class] [starts-with(BS5837_Category,"U")]/Onsite_Trees)
Low Quality Count 196   🛈 sum(table('Tree_Survey')[Class = $self/Class][starts-with(BS5837_Category,"C")]/Onsite_Trees)
Medium Quality Count 20   🛈 sum(table('Tree_Survey')[Class = $self/Class] [starts-with(BS5837_Category,"B")]/Onsite_Trees)
High Quality Count 2   🛈 sum(table('Tree_Survey')[Class = $self/Class][starts-with(BS5837_Category,"A")]/Onsite_Trees)