Weather data at nearby airports are usually used in building energy simulation to estimate energy use in buildings or evaluate building design or retrofit options. However, due to urbanization and geography characteristics, local weather conditions can differ significantly from those at airports. This study presents the visualization of 10-year hourly weather data measured at 27 sites in San Francisco, aiming to provide insights into the urban microclimate and urban heat island effect in San Francisco and how they evolve during the recent decade. The 10-year weather data are used in building energy simulations to investigate its influence on energy use and electrical peak demand, which informs the city’s policy making on building energy efficiency and resilience. The visualization feature is implemented in CityBES, an open web-based data and computing platform for urban building energy research.