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 = '3817'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 1/2" deep, tamp the soil, mulch the seed bed
Nyssa sylvatica var. biflora, also known as Swamp Blackgum or Swamp Tupelo, is a beautiful ornamental tree that is commonly found in parks and large gardens. This tree is often used as a specimen or shade tree due to its attractive appearance and ability to provide shade.
In its youth, Nyssa sylvatica var. biflora develops a pyramidal shape and as it ages, it spreads out. The leaves of this tree are variable in size and shape, ranging from oval to elliptical or obovate. They are lustrous with entire, often wavy margins. During autumn, the leaves turn a stunning purple color before eventually becoming an intense bright scarlet.
Nyssa sylvatica var. biflora is native to eastern North America and can be found in a variety of upland and wetland habitats. It plays an important role in supporting biodiversity as its flowers are a significant source of honey and its fruits are consumed by many bird species. The hollow trunks of these trees also provide nesting and denning opportunities for bees and various mammals.
One interesting fact about Nyssa sylvatica var. biflora is that it is the longest living non-clonal flowering plant in Eastern North America, with the ability to live for over 650 years. The fruit of this tree is edible, both raw and cooked. It has a thin, pleasantly acidic pulp that can be enjoyed as a masticatory or used in preserves.
The wood of Nyssa sylvatica var. biflora is heavy, hard, and difficult to split. It has been historically used for making mauls, pulleys, wheel hubs, agricultural rollers, bowls, and paving blocks. Additionally, the wood is utilized for pallets, rough floors, pulpwood, and firewood.
If you are a fan of honey, you may be interested to know that honey bees make sweet tupelo honey from the nectar of these spring-blooming trees. This honey is a delicious treat with a unique flavor.
Overall, Nyssa sylvatica var. biflora, or Swamp Blackgum / Swamp Tupelo, is a versatile and beautiful tree that adds value to any landscape. Its stunning autumn foliage, ecological importance, and durable wood make it a great choice for parks, gardens, and other green areas.