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 = '416'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 24 hours, repeat process on seed that did not imbibe
Stratification: cold stratify for 90 days
Germination: can be sown outdoors in the fall for spring germination, sow seed 1/4" deep, keep moist, mulch the seed bed, remove mulch upon germination
Other: if boiling water treatment does not allow seed to imbibe, sulfuric acid treatment is required
Discover the beautiful Cercis occidentalis, commonly known as Western Redbud or California Redbud. A member of the legume family, this small tree or shrub is native to the American Southwest, flourishing from California to Utah. Western Redbud stands out in the landscape with its shiny brown branches dotted with heart-shaped leaves that progress from light green to a deeper shade as they age, often transitioning to gold or red in cooler weather at higher elevations. From March until May, the shrub comes alive with clusters of striking pink or magenta flowers, creating an incredible burst of color. Beyond its visual appeal, the Western Redbud also serves a practical purpose. Indigenous Californians traditionally use its thin, dry, 3-inch-long brown legume pods and twigs to weave baskets, often pruning the shrub to encourage new growth. The bark of the tree provides a subtly reddish dye for the finished basketry, adding another layer of beauty and utility. Whether you're seeking a vibrant ornamental plant for your garden or a native species suited to a wildlife- or drought-tolerant environment, Western Redbud is a captivating and versatile choice.