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:
No detailed data within SF.