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 = '1171'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: fall sowing in mulched beds is prefered to artificial stratification
Douglas Fir, scientifically known as Pseudotsuga menziesii, is a popular evergreen conifer species native to western North America. The name is misleading since it is not a true fir but named after Scottish botanist David Douglas. It is often used as a specimen tree or in mass screenings and is a popular Christmas tree. Its quick growth and useful wood make it the crop of choice for many timber companies. The tree produces seeds which are an important food source for small mammals. It grows in coastal regions from British Columbia to central California and can be found in the Sierra Nevada mountain region. The interior Douglas fir can be found in the Cascades of northern Washington and southern British Columbia.