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 = '1447'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: requires light for germination, surface sow and keep moist, tamp the soil, cover seedbed with some shade
Other: fall sowing in mulched beds is prefered to artificial stratification
Thuja plicata, also known as Western Red Cedar, is an evergreen coniferous tree native to western North America. It can live for well over a thousand years, making it a long-lived species. It is also the Provincial tree of British Columbia. The leaves have been used in the treatment of colds, and the inner bark has been used for making baskets. Thuja plicata can be used as a hedge or as part of a shelterbelt. The wood has a distinct appearance and aroma and is highly resistant to decay, making it ideal for outdoor construction such as posts, decking, shingles, and siding. Thuja plicata is also grown as an ornamental tree and for screens and hedges in gardens and parks worldwide. Its extensive history of use by Native Americans includes constructing housing, totem poles, and ceremonial objects, as well as crafting many other objects such as masks, utensils, canoes, and vessels. Thuja plicata played a significant role in indigenous societies as a source of basic materials.