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.
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:
https://catalog.data.gov/dataset/global-surface-summary-of-the-day-gsod
https://www.almanac.com/weather/history/zipcode/94131/2021-10-11
https://www.climate.gov/maps-data/dataset/past-weather-zip-code-data-table
https://www.usclimatedata.com/climate/san-francisco/california/united-states/usca0987
No detailed data within SF.