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 = '971'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Looking for a beautiful and vibrant addition to your garden or landscape? Look no further than the Picea pungens var. glauca, also known as the Blue Spruce or Colorado Blue Spruce.
This medium-sized evergreen tree can reach heights of 25-30 meters, with exceptional specimens growing up to 46 meters tall. The Blue Spruce has a conic crown in its younger years, which transforms into a cylindrical shape as it matures. The bark is thin and scaly, with small circular plates that flake off.
One of the most striking features of the Blue Spruce is its stunning blue color. The Kaibab source, our second best for blue color, produces seedlings with intensely blue needles. In fact, a high percentage of seedlings will exhibit this lovely blue hue. If you're looking for an even better blue color, our Majestic seed source is the one to choose.
The Blue Spruce is not only known for its beauty but also for its resilience. With a deeply penetrating root system, this tree is firmly anchored against winds. It is commonly found along streamsides in mountain valleys, where the soil moisture levels are greater than the often low rainfall in the area would suggest.
Native to western North America, the Blue Spruce is commonly planted as an ornamental tree far beyond its native range. It is also grown for the cut Christmas tree industry. The leaves are needle-like and can vary in color from dull gray-green to bright glaucous blue. The tip of the leaves is sharply pointed, giving the specific epithet "pungens."
If you're looking to add a touch of majestic beauty to your garden, the Blue Spruce is the perfect choice. Its stunning blue color, deeply penetrating root system, and resilience against winds make it a popular choice for both ornamental and practical purposes. Don't miss the opportunity to add this iconic tree to your landscape.