Native to: Alabama, Arkansas, Colorado, Connecticut, Delaware, District of Columbia, Georgia, Illinois, Indiana, Iowa, Kansas, Kentucky, Maine, Manitoba, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, New Brunswick, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Nova Scotia, Ohio, Oklahoma, Ontario, Oregon, Pennsylvania, Québec, Rhode I., South Carolina, South Dakota, Tennessee, Utah, Virginia, Washington, West Virginia, Wisconsin, Wyoming
Introduced to: Austria, Belarus, Belgium, Bulgaria, Czechoslovakia, Denmark, France, Germany, Great Britain, Greece, Hungary, Ireland, Italy, Kazakhstan, Krym, Netherlands, North Caucasus, Northwest European R, Norway, Poland, Romania, South European Russi, Sweden, Switzerland, Transcaucasus, Turkmenistan, Ukraine, Uzbekistan, Yugoslavia
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 = '1536'
group by i.id
Native to: Alabama, Arkansas, Colorado, Connecticut, Delaware, District of Columbia, Georgia, Illinois, Indiana, Iowa, Kansas, Kentucky, Maine, Manitoba, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, New Brunswick, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Nova Scotia, Ohio, Oklahoma, Ontario, Oregon, Pennsylvania, Québec, Rhode I., South Carolina, South Dakota, Tennessee, Utah, Virginia, Washington, West Virginia, Wisconsin, Wyoming
Introduced to: Austria, Belarus, Belgium, Bulgaria, Czechoslovakia, Denmark, France, Germany, Great Britain, Greece, Hungary, Ireland, Italy, Kazakhstan, Krym, Netherlands, North Caucasus, Northwest European R, Norway, Poland, Romania, South European Russi, Sweden, Switzerland, Transcaucasus, Turkmenistan, Ukraine, Uzbekistan, Yugoslavia
Native
Introduced
Bring the beauty of the New England landscape to your garden with Symphyotrichum novae-angliae, also known as the New England Aster. This large and showy flowering plant is a herbaceous perennial that grows over 6 feet in height. Its hairy, clasping leaves are densely arranged on its stout stems, and bright, rose-purple flowers with orange-yellow centers bloom profusely at the tips of the leafy branches. The flower color varies from lavender and blue to white, and a pink variety of this species is sometimes grown commercially. Native to almost every area in North America east of the Rocky Mountains, the New England Aster is a must-have for any garden looking to add a splash of color and showiness to its landscape. Grow yours today and see why this magnificent plant has become a popular choice among gardeners.