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 = '412'
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 60 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: if boiling water treatment does not allow seed to imbibe, sulfuric acid treatment is required
Cercis canadensis, commonly known as the Eastern Redbud, Southern Eastern Redbud or Southern Redbud, is a small tree with a sturdy trunk that branches into stout limbs to form a broad, flat head. This native of the Mississippi River valley can grow in shade and often thrives as undergrowth in the forest. Its heart-shaped leaves turn bright yellow in the fall and its purple flowers add a pop of color in the spring. Cercis canadensis is highly adaptable to most soils and pH types, but does not like wet soils, especially those that are clay-based. Its flowers have a refreshing, acid taste and are rich in vitamin C, making them a great addition to salads or pickled. While difficult to grow as far west as western Kansas and Colorado, this tree grows well in New York State and southward. Offering a hardy yet ornamental option for any landscape, Cercis canadensis is routinely available for purchase.