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
The only data for ncei.noaa.gov is at the locations in the below map. All of the below sources are built on this national data:
Data looks like this:
https://www.forecastadvisor.com/California/SanFrancisco/94131/
This API looks promising: https://www.aerisweather.com/support/docs/toolkits/
Would rather find a data dump, though.
This dump isn't zipcode granularity - just city level. Bah.
Instantaneous estimates might be the best we can do:
https://www.wunderground.com/wundermap
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:
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