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 = '1180'
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
Pseudotsuga menziesii, commonly known as Douglas Fir, is an evergreen conifer species native to western North America. Named after Scottish botanist David Douglas and physician/naturalist Archibald Menzies, this tree is often used as a specimen or screening tree and is a popular choice as a Christmas tree. Its fast growth and useful wood make it a preferred crop for timber companies, who frequently replant clear-cut areas with Douglas Fir. Small mammals rely heavily on its seeds for food, with estimates indicating that they consume up to 65% of the seed crop in western Oregon. Coast Douglas Fir is commonly found along the coastal region from British Columbia to central California and can grow up to 1,800m above sea level in the California Mountains. Its range also extends to the Rocky Mountains and even Mexico. As an ideal conifer species, Pseudotsuga menziesii is a great addition to any landscape.