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 = '993'
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: warm stratify for 60 days, cold stratify for 120 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Introducing the Siberian Pine, a unique variety within the Pinus cembra species. Some botanists consider it to be a subspecies of the Swiss Pine due to its similarities, with slight differences in cone size and needle resin canals. This variety belongs to the white pine group and is classified under Pinus subgenus Strobus. The leaves, or needles, are bundled in fascicles of five and have a deciduous sheath. Growing up to 10 cm in length, the Siberian Pine's cones can range from 5 to 9 cm. Its seeds, measuring 9 to 12 mm with a vestigial wing, are dispersed by Spotted Nutcrackers.
Not only does the Siberian Pine provide edible seeds that are collected and exported from Siberia, but it also serves as a vital food source for indigenous peoples and wildlife. Birds, particularly the Siberian nutcracker, distribute the large, wingless seeds, just like the pinon and P. albicaulis pines. Moreover, this pine variety is highly resistant to White Pine Blister Rust, making it essential for research on hybridization and genetic modification to develop rust resistance in related species.
The Swiss Pine, also known as the Arolla Pine, is closely related to the Siberian Pine. It thrives in the Alps and Carpathian Mountains, reaching altitudes of 1,200 to 2,300 meters. With a mature height of 25 to 35 meters and a trunk diameter of 1.5 meters, this pine often reaches the alpine tree line in its habitat. Similar to the Siberian Pine, the Swiss Pine also produces edible seeds in significant quantities.
Both the Siberian and Swiss Pine are members of the white pine group and belong to the Pinaceae family. They offer an impressive growth habit and enhance any landscape with their majestic presence. While the Siberian Pine flourishes in wet slopes and soils, usually found in association with Picea obovata and Abies sibirica, the Swiss Pine's distribution spans across various European and Asian countries.
For more information on these extraordinary pine trees, please visit our website or explore the USDA's plant database at http://plants.usda.gov.