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 = '3704'
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
The Cupressus cashmeriana, also known as Bhutan Cypress or Kashmir Cypress, is a species of cypress native to the eastern Himalaya in Bhutan and adjacent areas of Arunachal Pradesh in northeastern India. It can also be found in China and Nepal. This medium to large coniferous tree can grow up to 45 meters tall, with a trunk diameter of up to 3 meters. The foliage consists of pendulous sprays of blue-green, slender shoots. The leaves are scale-like, measuring 1-2 mm long, and up to 5 mm long on strong lead shoots. Young trees have soft needle-like leaves. The tree produces ovoid seed cones that are dark green and mature to a dark brown color. The pollen cones are smaller and release pollen in early spring. This species is often associated with Buddhist religious places in Bhutan and is the official national tree. It is widely cultivated as an ornamental tree in temperate climates, both within its native region and internationally. Many named cultivars are available with specific forms, textures, or foliage colors. The Cupressus cashmeriana has been granted the Royal Horticultural Society's Award of Garden Merit. However, the natural populations of this species are fragmented and face conservation challenges.