Discussion about this post

User's avatar
Kathy Rourke's avatar

Your emails continue to be incredibly detailed, helpful and informative- keep them coming! Thank you!!

Expand full comment
Eric Sponberg's avatar

This is a really interesting and powerful tool. I think you can take your summary analysis one step further by putting a "TOTAL" column at the right end of the table. Total the scores and sort low-to-high. Lower score cities are more desirable--less impact from climate change. Here is how your ranking would look:

LOCATION STORM HEAT DROUGHT FLOOD FIRE TOTAL

Eugene, OR 76 18 13 1 1 109.0

Tucson, AZ 13 67 32 1 1 114.0

Spokane, WA 58 50 16 7 1 132.0

Duluth, MN 81 29 18 1 31 160.0

Santa Barbara, CA 47 7 45 76 24 199.0

Norfolk, VA 100 41 48 8 12 209.0

Our Town 97 28 29 66 1 221.0

Charleston, SC 86 36 49 70 1 242.0

Miami, FL 50 100 31 92 1 274.0

Eugene would be the most desirable to live, Miami the least desirable. Worst-case scenario would be a score of 500. Pick a limit--say any score in the bottom 30% would be desirable, so the best places would be with a score under 150.

Here are some scores for towns that mean something to me:

LOCATION STORM HEAT DROUGHT FLOOD FIRE TOTAL

Marquette, MI 73 15 11 1 1 101.0

Atlanta, GA 88 51 38 1 1 179.0

Asheville, NC 97 74 49 16 1 237.0

St. Aug. Beach, FL 74 70 58 49 1 252.0

Boulder, CO 89 88 62 27 13 279.0

Marquette is where I grew up and where I still own a vacation home. Atlanta is where our son lives. Asheville is thrown in for comparison because it is said to be a lot like St. Augustine where we last lived. Boulder is where our daughter lives, and interestingly, Boulder is also the home of the National Center for Atmospheric Research which is a US government center studying climate change.

On checking my post, the chart loses its justification so the numbers are not all in column--sorry about that.

Expand full comment
3 more comments...

No posts