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 = '585'
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
Introducing the Hesperocyparis nevadensis Piute Cypress, a medium-sized evergreen tree that can grow up to 39 meters tall. With a conic crown and sparse, fragrant foliage varying in color from dull gray-green to glaucous blue-green, this cypress tree is truly a sight to behold. The leaves are scale-like, highly glandular, resinous and aromatic, and are produced on rounded shoots. The seed cones are globose to oblong and mature to a gray or gray-brown shade 20-24 months after pollination. The male cones release pollen in February-March, making this tree a stunning sight with golden powdered male flowers. This species can only be seen in the wild by travelling on an unsurfaced clay road for 2 and a half miles, but it's worth the journey to witness this magnificent tree in all its glory. Discover the beauty of nature with the Hesperocyparis nevadensis Piute Cypress.