select i.*, substring_index(group_concat(distinct pa.country order by rsi.date_added desc),',',-1) as source_country
from inventory_item_manage i
left outer join sheffields_2017.receiving_shipments_item_has_inventory_item hrsi on i.id = hrsi.inventory_item_id
left outer join sheffields_2017.receiving_shipments_item rsi on rsi.id = hrsi.receiving_shipments_item_id
left outer join sheffields_2017.po on rsi.po_id = po.id
left outer join sheffields_2017.po_address pa on pa.po_id = po.id
where i.inventory_id = '5465'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: seed may start to germinate in cold strat., sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: fall sowing in mulched beds is often prefered to artificial strat and spring sowing
Abies balsamea, commonly known as the Balsam Fir, is a small to medium-size evergreen tree that grows up to 20 meters tall, with a narrow conic crown. Its needles are very aromatic and have a symmetrical, cone-shaped habit, especially when young. This tree prefers cool and moist conditions and is usually found in association with black spruce, white spruce, and trembling aspen. Balsam Fir is widely popular as a Christmas tree, especially in the northeastern USA and is the provincial tree of New Brunswick. Its resin is known for its antiseptic and healing properties, which are used internally to treat coughs, sore throats, and other complaints. The buds, resin, and/or sap of the Balsam Fir are used in folk remedies for treating cancers, corns, and warts. The resin is also antiscorbutic, diaphoretic, diuretic, stimulant, and tonic. Additionally, Balsam Fir oil is an EPA approved non-toxic rodent repellent. This species is a slow-growing tree that is suitable for lumber and veneer products, as well as Christmas tree and nursery stock. The Abies balsamea is a perennial tree that is native to most of eastern and central Canada and the northeastern United States.