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 = '762'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 120 days
Germination: sow 1-2" deep, tamp the soil, mulch the seed bed
Discover the remarkable Eastern Black Walnut (Juglans nigra), with its beautifully grained wood that makes it a highly prized timber tree, possibly the most sought after in North America. This species grows prominent in various zones, from central Texas to southeast South Dakota, stretching eastward to northern Florida and southern Ontario. Apart from its high-value timber, this tree is also known for its nutritious nuts, often used in creating delicious candies and ice creams. Its hard shell has commercial uses in abrasive cleaning, cosmetics, oil well drilling, and water filtration.
A mature Eastern Black Walnut attains heights of 30–40 feet and develops a short bole and broad crown when grown openly. It has grey-black bark and deeply furrowed twigs with air spaces in the pith. Its leaves are odd-pinnate with 15-23 leaflets. Its male flowers form drooping catkins, while female flowers cluster at the terminal, ripening into brown corrugated nuts in autumn.
The tree has been appreciated since 1629 when it was introduced to Europe. It flourishes best in warmer regions, on fertile, lowland soils with a high water table. The wood from this tree serves many purposes, including crafting furniture, flooring and rifle stocks. Furthermore, oil is pressed from the seeds for various uses. Interestingly, approximately 65% of the annual wild harvest comes from the U.S. state of Missouri.