Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 0.523 ms
Record Count: 1
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 != '1' and
g.genus = 'Abies'
limit 1
id
113

Abies balsamea

Balsam Fir

Native to eastern & central Canada. The wood is used for paper and its also a popular Christmas tree.

  • Dark green foliage
  • Pyramidal habit
  • Very hardy

  • Category: Evergreen
  • Hardiness Zone: 3-9
  • Height: 50-75 ft
  • Spread: 15-55 ft
  • Foliage Color: Dark Green
Login for pricing