Alexa is far from perfect, but it has weather down. Things may have changed or my memory is imperfect, but one of the first things the iOS app asks you is for your home zip code. Even without that, "What's the weather in San Francisco?" works fine.