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 = '1318'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 140 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Other: can be fall sown without stratification.
Rosa nutkana, also known as Nootka Rose, Bristly Rose, or Wild Rose, is a tall perennial shrub in the Rose family. Growing up to 8 ft tall, this plant has light green paired leaflets with toothed edges and sharp spines on the bottom. In early summer, the plant produces 2-3 inch pink flowers that have a pleasantly strong fragrance. The fruits of the Nootka rose are edible but somewhat bitter. It serves as the larval host of the Mourning Cloak and Grey Hairstreak butterflies and is used in wetland mitigation buffers and in native plant landscaping. Rosa nutkana is native to Western North America and grows in moist openings and less often on open hillsides. A poultice of the chewed leaves has also been used to alleviate the pain of bee stings.