By Nora Tooher

Area residents are not among the most confident in the country about their retirement prospects, according to the New Retirement Mindscape: City Pulse Index. The report ranks Cleveland-Akron 26th among 30 large metropolitan areas for individuals’ level of confidence about their retirement.

San Francisco reclaimed the No. 1 spot, which it also held two years ago. Detroit was No. 2, up from 17th. Minneapolis followed New Haven-Hartford, Conn., in the fourth place and Seattle came in fifth.

The City Pulse Index by Ameriprise Financial measures consumers’ preparation and confidence about retirement by asking them about their savings habits and expectations for their financial futures.

Residents of the three most confident cities had much higher than average participation rates in contributing to IRAs or other personal – not workplace-related – investment accounts.

Two of five of Detroit respondents said they have a financial advisor – compared with a national average of only 29 percent – and more than half have contributed to a workplace-sponsored retirement plan such as a 401k. Half of Detroit-area respondents feel they are on track for retirement and 71 percent report positive feelings about retirement.

In addition to Detroit, other metros that improved 10 or more spots in the rankings included Sacramento, Calif., No. 7; Baltimore, No. 8; Washington, D.C., No. 12 and Indianapolis, No. 15.

Surprisingly, warmer locales that typically draw retirees looking for a new home, these places were areas where residents are the least confident about their retirement futures. Cities at the bottom of the list were Houston, 27th; Nashville, Tenn., 28th; Los Angeles, 29th and Orlando, Fla., 30th.

Metros dropping more than 10 spots in 2013 were Pittsburgh, 22; Raleigh, N.C., 23; Philadelphia, 24; Houston, 27 and Nashville, 28.