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 = '1464'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 1/8" deep, tamp the soil, keep moist, mulch the seed bed, remove mulch upon germination, cover seedbed with some shade
Tsuga heterophylla, also known as the Western Hemlock, is a remarkable evergreen coniferous tree that can grow up to 78 meters tall and has a trunk diameter of up to 2.7 meters. Its crown is a perfect broad conic shape in young trees with drooping lead shoots, and cylindric in older trees with pendulous branchlet tips. The noticeable feature of this species of hemlock is its slender cylindrical 1 inch cones, which contains 15-25 thin, flexible scales. Tsuga heterophylla is native to the west coast of North America, growing well in cool summer temperatures and in a moist atmosphere, typically in the U.S. Pacific Northwest where it is well suited. It is best grown in gardens within native habitats and along the U.S. Pacific Coast, specifically in wetter regions, but it is also cultivated in temperate regions worldwide. Western Hemlock’s range is essential for Pacific Northwest forests where it is a climax species, alongside its associates at low altitudes from sea level to 600 meters. It is worth noting that Western Hemlock is closely associated with temperate rain forests, and it is a notable timber tree throughout the region. It is a favourite among Pacific yew and Pacific silver fir, which are both relatively shade-intolerant. Its leaves are mid to dark green above, and the underside has two distinctive white bands of stomata with only a narrow green midrib between the bands. The Western Hemlock's bark is a source of tannin for tanning and a source of edible cambium. The tree is also known for its uses in forestry, as it is used for making doors, furniture, and joinery, and it can also be used for paper production. Western Hemlock boughs are used to collect herring eggs during the spring spawn in southeast Alaska.