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 = '1031'
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 180 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Pinus peuce, also known as Macedonian Pine or Balkan Pine, is a species of pine native to the mountains of Macedonia, Bulgaria, Albania, Montenegro, Kosovo, Serbia, and Greece. It thrives at altitudes of (600-) 1,000-2,200 (-2,300) meters and can even reach the alpine tree line in this region. This majestic tree can grow up to 35-40 meters in height, with a trunk diameter of 1.5 meters. The needles of Pinus peuce are dark green or gray-green, measuring up to 4 inches in length, and it has a narrow pyramidal or columnar habit.
Pinus peuce is widely recognized for its beauty and resilience. It prefers full sun, good drainage, and moist soil. It is an attractive tree that adds a touch of elegance to any landscape. This species is particularly valuable for its resistance to white pine blister rust (Cronartium ribicola), a fungal disease that has caused significant damage to native white pines in North America. Consequently, Macedonian pine is of great importance for research into hybridization and genetic modification to develop rust resistance in these species.
Apart from its ecological significance, Pinus peuce is also a popular ornamental tree in parks and large gardens due to its reliable, steady growth. It can adapt to a wide range of environmental conditions and is highly tolerant of severe winter cold, making it a suitable choice for regions with harsh climates. This pine tree is even locally naturalized in Punkaharju, eastern Finland.
Additionally, Macedonian Pine has various practical applications. Its durable wood is highly valued in construction, furniture production, wood-carving, and cooperage. The tree's resin is used by the local population to cure wounds, pectoral, skin, and stomach diseases, as well as varicose veins and other illnesses.
In summary, Pinus peuce, or Macedonian Pine, is a remarkable species of pine that is native to the Balkans. It boasts impressive height and trunk diameter and is known for its dark green or gray-green needles. This tree is highly resistant to white pine blister rust and holds great potential for research in developing rust resistance in other species. It is widely cultivated in parks and gardens for its attractive appearance and adaptability. Furthermore, its versatile wood and medicinal properties make it even more valuable.