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 = '162'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow 1-2" deep, tamp the soil, mulch the seed bed
Other: fall sowing in mulched beds is prefered to artificial stratification
Discover the captivating beauty of the Aesculus sylvatica, commonly known as the Dwarf or Painted Buckeye. This deciduous tree, native to the southeastern USA, is well suited to nutrient-rich forests, lower slopes, and ravines. The Painted Buckeye consumes up to 10-20 feet of vertical space, manifesting either as a grand shrub or small tree. Expect an early display of attractive palmate leaves, usually donning a fascinating greenish-yellow to sometimes pink or red flowers, from March-April.
Painted buckeye preferably likes a sunny to partially shaded spot with moist, well-drained soil. Be sure to provide some afternoon shade in a woodland or naturalized area.
Renowned for its fast growth, this thicket-forming shrub or tree is prevalent in Piedmont plateau bottom lands and along the coastal plain. In spring and fall, witness the glorious sight of palmate-compound leaves with distinctive yellow to orange midveins. Flower clusters present a stunning display in showy upright patterns resembles a paintbrush hence where its common name comes from. The fruit, a brown leathery capsule, holds 1 to 3 shiny, dark brown seeds, famously known as Buckeyes. Poisonous if ingested.
Choose the Aesculus Sylvatica, a remarkable specimen with showy spring flowers, whether as a premium landscape ornament or a single to multi-trunked small tree or large shrub.