Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 18.9 ms
Record Count: 0
Cached: No
Lazy: No
SQL:
select g.id
from tb_plant_genusoverview_substitutions s
inner join tb_plant_genusOverview g on (g.id = s.genus_id)
where g.delete_date is null and g.isactive = 1 and
g.id != '187' and
g.genus = 'Gymnocladus'
limit 1
id

Gymnocladus dioicus

Kentucky Coffeetree

A fast growing, pest resistant shade tree. Has the largest leaves of any tree in Canada.

  • Medium to coarse texture
  • Horizontal, ascending branching

Login for pricing
Exposure
Full Sun
Foliage Color
Green
Soil Moisture
Average Water
Attributes
Fast Growing
Native
Shade Tree
Habit
Spreading
Upright
Season of Interest (Flowering)
Summer