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 = '602'
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: none required
Germination: pick out seeds that imbibe, re-treat others, sow imbibed seeds 1/4" deep,, tamp the soil, mulch the seed bed
Other: boiling water can be used if hot water does not scarify the seed
The Delonix regia , also known as Flame Tree and Royal Poinciana, is an exceptionally striking sight with its vivid red, vermilion, orange, and yellow flowers. Native to Madagascar, it is found in the dry deciduous forests, where it is endangered. However, it is widely cultivated worldwide for its ornamental value and use as a shade tree in tropical conditions. Its fern-like, doubly compound leaves provide dense foliage and full shade. In areas with a marked dry season, it sheds its leaves during the drought, but in other areas, it is virtually evergreen. Flame Tree is much loved in the Caribbean and is featured in many Puerto Rican paintings. It can also be found in The Bahamas, Hawaii, and Israel, among other places. It is the national flower of St. Kitts and Nevis and is regarded as naturalized in many of the locations where it is grown. The tree blooms from May to September and is propagated by seeds or semi-hardwood cuttings. Delonix regia holds cultural significance in various parts of the world, including India, where it is believed that Jesus’ blood was shed over the flowers of the tree, and in the song "Poinciana," inspired by the presence of this tree in Cuba.