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 = '975'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/8" deep, tamp the soil, mulch the seed bed
Discover the stunning beauty of Picea sitchensis, commonly known as the majestic Sitka spruce. Growing up to almost 100 meters tall and with a trunk diameter exceeding 5 meters, this evergreen conifer is the largest species of spruce and the fifth-largest conifer in the world. Its bark is thin and scaly while its flattened needle-like leaves are dark glaucous blue-green above with two or three thin lines of stomata, and blue-white below with two dense bands of stomata. Sitka spruce is native to the west coast of North America and is closely associated with temperate rainforests. While known for being an important source of lumber and paper production, it is also valued for its fast-growing abilities and regular knot-free rings, making it an excellent conductor of sound. Explore the beauty of this lovely native tree in Alaska to California, but remember it requires cool moist growing conditions to flourish, making it less suited to the eastern U.S. Order your Sitka spruces today and enjoy the allure of its gentle giant presence.