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 = '1007'
group by i.id
Australia, Austria, Belgium, Bulgaria, Colombia, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Netherlands, New Zealand, Poland, Portugal, Romania, Slovak Republic, Slovenia, Spain, Sweden, Switzerland, Turkey, United Kingdom
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
"Discover the Beauty of Pinus glabra Spruce Pine"
Pinus glabra, commonly known as Spruce Pine, is a stunning tree that can be found on the coastal plains of the southern United States. With its straight-growing nature and medium-sized stature, reaching heights of 20-40 meters, this pine is truly a sight to behold.
One of the unique features of Pinus glabra is its adaptation to thrive in moist woodland habitats within mixed hardwood forests. Unlike most other pines, this tree does not occur in largely pure pine forests. Instead, it can be found as scattered trees, competing successfully in shady environments due to its greater shade tolerance.
The leaves of Pinus glabra are needle-like, appearing in bundles of two and measuring around 5-8 cm long. They are slender, about 1 mm thick, and have a glossy dark green color, adding a touch of elegance to this majestic tree. The small and slender cones, measuring 4-6 cm long, form on the tree with weak prickles on the scales that are soon shed.
Spruce Pine is often established in the shade of hardwoods such as magnolia, gum, hickory, beech, and oak. Over time, it may even overtop these trees, showcasing its resilience and strength. This tree is typically associated with various other tree species, including different types of pine, elm, holly, cherry, and more. Shrubs and woody vines, such as beautyberry and grape, also find their place among the Spruce Pine's habitat.
The climate in the Southeastern United States, where Pinus glabra thrives, is characterized by long, hot, and humid summers, as well as mild winters. With an average rainfall of about 1270 mm distributed evenly throughout the year, this tree can thrive in these conditions. The growing season spans approximately 240 days, and the average annual temperature is 16°C.
Notably, Pinus glabra is less susceptible to insect and disease damage compared to other southern pines, thanks to its dispersed growth pattern. It is immune to infection by certain pathogens and pests and shows great resilience within its natural range. However, it is highly susceptible to fire due to its thin bark, making it essential to take precautions to protect and preserve these remarkable trees.
In terms of reproduction, Spruce Pine starts producing cones at around 10 years of age, with peak cone production between 20 and 40 years. The trees are monoecious, with pollen cones below the seed cones, and conelets appear as early as March in its distribution range.
If you are captivated by the beauty and unique qualities of Pinus glabra Spruce Pine, consider incorporating this remarkable tree into your landscape. Its elegant foliage, straight growth, and adaptability to various environments make it a standout addition to any garden or woodland area. Embrace the beauty of nature with Pinus glabra Spruce Pine in your space.