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 = '364'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours, repeat process daily for 4 days
Stratification: cold stratify for 120 days
Germination: sow 1-2" deep, keep moist, mulch the seed bed, can be sown outdoors in the fall for spring germination
Carya ovata, also known as the Shagbark Hickory, is a large and distinguishable deciduous tree that grows up to 27 meters tall and can live up to 200 years. Its unique shaggy bark is only found on mature trees, while young specimens have smooth bark. The edible nuts of the Shagbark Hickory have a very sweet taste and were a significant food source for native Algonquian Indians and wildlife such as squirrels, raccoons, and birds. This tree seed can be started in November for spring planting. Though unsuitable for commercial production, the nuts can be used as a substitute for pecans and have similar culinary functions. Shagbark Hickory wood is known for its toughness and resilience, used in implements and tools such as axles, axe handles, plows, and skis. Though rarely used as an ornamental, it is a valuable addition to any landscape. Plant a Shagbark Hickory to enjoy its unique features and benefits for generations to come.