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 = '698939'
group by i.id
Scarification: Germination can be difficult due to the hard seed coat, and is improved by scarification with a knife or sandpaper.
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, keep moist, mulch the seed bed
Other: Germination takes 8 - 70 days.
Welcome to the world of Thespesia populnea, commonly known as the Portia Tree! This beautiful flowering plant belongs to the mallow family and has a pantropical distribution, growing in coastal areas around the world. The Portia Tree is a small tree or shrub that reaches a height of 6-10m and has a trunk diameter of 20-30cm. It can grow in a wide range of soil types, from sand to limestone and basalt, and prefers neutral soils with a pH of 6-7.4. This adaptable tree grows in areas that receive 500-1600mm of rainfall, with elevations varying from sea level to 275m. While it is possibly indigenous to the Hawaiian Islands and other areas in the Pacific, it is thought to be native only to the Old World, most likely originating in India. Early Polynesians may have spread the Portia Tree for its useful wood and bast fibers. Discover more about this fascinating plant species on the USDA website.