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 = '955'
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
Picea glauca 'Densata' Black Hills Spruce is a hardy and slow-growing evergreen tree that boasts a compact and symmetrical habit. Native to the Black Hills of South Dakota, this species of spruce is widely planted in the U.S. and adapts well to a variety of conditions. Its shiny green or blue-green needles and green cones make it a popular choice for hedges, windbreaks, and specimen trees. It thrives in full sun and prefers moist loamy soil with a pH of 4.0 to 7.5. This tree is fairly drought resistant but needs additional moisture during droughts. It grows up to 60 feet in height and is perfect for farmstead and field windbreaks, wildlife habitats, and agroforestry products. With its aromatic crushed leaves and ability to withstand harsh weather, Picea glauca 'Densata' is an excellent addition to any landscape.