select i.*, as2.state_abbr
from inventory_item_manage i
left outer join sheffields_2017.address_states as2 on (as2.state_name = i.CollectionLocale or as2.state_abbr = i.CollectionLocale)
where i.inventory_id = '1038'
group by i.id
Looking for a beautiful and unique addition to your garden or landscape? Look no further than Pinus pumila, also known as the Dwarf Siberian Pine or Japanese Stone Pine. This slow-growing evergreen shrub ranges from 3-10 ft in height, but can have individual branches that extend farther along the ground. Its dense, low-growing form makes it perfect for rock gardens or borders. The needles are 1.5-2.5 inches long and are formed in bundles of five. The cones are 1-1.75 inches long and contain large nut-like seeds, which are harvested and dispersed by the Spotted Nutcracker. Pinus pumila is also prized for its ornamental value and is grown in parks and gardens. And if you're looking for a tasty treat, you can even eat the seeds raw or cooked! So add some unique beauty to your landscape with Pinus pumila.