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 = '45'
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
Abies magnifica, also known as the California Red Fir or Red Fir, is an evergreen tree that grows well in heavy clay soils. It requires a cool position in a good moist but not water-logged soil. It is very shade tolerant, especially when young, but growth may be slower in dense shade. The tree prefers growing on a north-facing slope. This large tree can grow up to 40-60 m tall and 2 m trunk diameter, and is typically found in the mountains of southwest Oregon and California in the United States. The Red Fir is a high elevation tree, usually found at elevations between 1,400–2,700 metres, though it rarely reaches tree line. The bark of old trees gives the tree its name, as it becomes a beautiful orange-red color. Red Fir is an important forest tree and its wood is used for general structural purposes, paper manufacture, and it is also a popular Christmas tree. Its high-quality young Silvertip Firs, with dense dark-green needles, sell for top prices as Christmas trees. The Red Fir dominates large areas of high country, which are a major source of water, especially in California. This makes the Red Fir a significant tree for those interested in preserving the environment and ecology of natural forests.