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 = '587'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Other: seed can be treated with Captan (4 tablespoons/gallon of water) during stratification to prevent fungal problems
Looking for a unique, endemic tree to add to your garden? Look no further than Hesperocyparis sargentii, also known as Sargent's Cypress. Endemic to California, this coniferous tree is found from Mendocino county down to Santa Barbara county, only growing in the Coast Range mountains. It is one of the most widespread Californian cypresses and can grow up to 15 meters tall, but some famous areas like Hood Mountain in Sonoma County support a pygmy forest where the trees don't grow taller than 8-12 feet. The tree prefers serpentine soils and grows in forests with other conifers, chaparral, and other mountain habitats. If you want to add a unique, native tree to your garden or backyard, consider adding Hesperocyparis sargentii. Learn more about this tree at http://plants.usda.gov.