🌉

What neighborhood in SF has the best weather?

What dimensions do we care about?

  • Low crime and homelessness (crime reports).
  • Beautiful views (elevation).
  • Location.
  • Backyards, ideally connectable.
  • Square footage of houses: 3k-8k.
  • Number of bedrooms in the house: ideally, 2-6.
  • High turnover.
  • Nice weather. Twin Peaks
  • Quiet/low traffic/culdesacs. It's surprisingly great to be on a quiet street with less traffic. Feels safer for kids, too.

Weather data

1:36 PM: looking for weather data. What data source shows 4 months of fog in Twin Peaks?

Wunderground has a lot of bugs, and you need to own a station to have an API key. Unlikely that I'd be able to get their historical data with their API.

Also, a bug in showing historical data means that no matter what station you put in, it always shows weather data from KSFO (SFO). See https://www.wunderground.com/history/weekly/us/ca/san-francisco/KSFO/date/2020-10-12 and https://www.wunderground.com/history/weekly/us/ca/san-francisco/KCASANFR1217/date/2020-10-12. Note the different location IDs, different coordinate locations, but same data.

Accuweather API is limited to forecast information and current conditions. https://developer.accuweather.com/packages

weather.gov has monthly stats for the whole city: https://www.weather.gov/wrh/Climate?wfo=mtr

Zip codes.
Zip codes.
No detailed data within SF.
No detailed data within SF.

Data looks like this:

image

https://www.forecastadvisor.com/California/SanFrancisco/94131/

image

This API looks promising: https://www.aerisweather.com/support/docs/toolkits/

Would rather find a data dump, though.

https://weather.com/weather/monthly/l/3b921f00bcf37f7b9e5d0fc6691162840e3f125024f48f2b9bc2f7521138d6a3

This dump isn't zipcode granularity - just city level. Bah.

image

Instantaneous estimates might be the best we can do:

https://www.wunderground.com/wundermap

image

This doesn't even seem that accurate, though.

Really excellent visualizations that allow for at-a-glance comparisons across the world, using the NCEI data from above:

https://weatherspark.com/map

image
image
image
image

NYC property sales dataset: https://www.kaggle.com/new-york-city/nyc-property-sales

Zillow countrywide Zestimate data, up to 2017 (?): https://www.kaggle.com/zillow/rent-index

532 other real estate datasets: https://www.kaggle.com/datasets?tags=11122-Real+Estate