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 = '992'
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
The Swiss Pine, also known as Arolla Pine or Pinus cembra, is a majestic species of pine tree found in the Alps and Carpathian Mountains of central Europe. With its shiny dark green needles, it makes a striking specimen in any landscape. Growing at altitudes of 1,200-2,300 meters, this slow-growing tree can reach heights of up to 35 meters with a trunk diameter of 1.5 meters. It is known for its resilience, flourishing in most situations, including north-facing slopes and moist heavy clay soils.
The Swiss Pine is highly adaptable, tolerating temperatures as low as -30°C, making it suitable for cold climates. It is a member of the white pine group and produces needle-like leaves in bundles of five. The cones, which contain the seeds, are 4-8 centimeters long, and the seeds have a vestigial wing, facilitating their dispersal by spotted nutcrackers.
Not only is the Swiss Pine a beautiful addition to any park or garden, but it also serves various purposes. It is highly valued for its wood, which has been used for carvings in Val Gardena since the 17th century. The seeds are harvested and sold as pine nuts, and the cones are used to flavor schnapps. In fact, the cone of the Swiss Pine has historical significance, as it was the field sign of the Roman legion stationed in Rhaetia in 15 BC. Additionally, the Swiss Pine is of great importance in maintaining the ecosystem, as it helps minimize the risk of avalanches and soil erosion.
With its longevity of up to 1000 years, the Swiss Pine has become a symbol of endurance and stability. Whether you are looking for a visually appealing tree or a species that can withstand harsh conditions, the Swiss Pine is an excellent choice. Explore the beauty and resilience of this remarkable tree by planting it in your landscape today.