Historical changes of annual temperature and precipitation indices at selected 210 U.S. cities

This dataset provide:

Annual average temperature, total precipitation, and temperature and precipitation extremes calculations for 210 U.S. cities.

Historical rates of changes in annual temperature, precipitation, and the selected temperature and precipitation extreme indices in the 210 U.S. cities.

Estimated thresholds (reference levels) for the calculations of annual extreme indices including warm and cold days, warm and cold nights, and precipitation amount from very wet days in the 210 cities.

Annual average of daily mean temperature, Tmax, and Tmin are included for annual average temperature calculations. Calculations were based on the compiled daily temperature and precipitation records at individual cities.

Temperature and precipitation extreme indices include: warmest daily Tmax and Tmin, coldest daily Tmax and Tmin , warm days and nights, cold days and nights, maximum 1-day precipitation, maximum consecutive 5-day precipitation, precipitation amounts from very wet days.

Number of missing daily Tmax, Tmin, and precipitation values are included for each city.

Rates of change were calculated using linear regression, with some climate indices applied with the Box-Cox transformation prior to the linear regression.

The historical observations from ACIS belong to Global Historical Climatological Network - daily (GHCN-D) datasets. The included stations were based on NRCC’s “ThreadEx” project, which combined daily temperature and precipitation extremes at 255 NOAA Local Climatological Locations, representing all large and medium size cities in U.S. (See Owen et al. (2006) Accessing NOAA Daily Temperature and Precipitation Extremes Based on Combined/Threaded Station Records).

Resources:

See included README file for more information.

Additional technical details and analyses can be found in: Lai, Y., & Dzombak, D. A. (2019). Use of historical data to assess regional climate change. Journal of climate, 32(14), 4299-4320. https://doi.org/10.1175/JCLI-D-18-0630.1

Other datasets from the same project can be accessed at: https://kilthub.cmu.edu/projects/Use_of_historical_data_to_assess_regional_climate_change/61538

ACIS database for historical observations: http://scacis.rcc-acis.org/

GHCN-D datasets can also be accessed at: https://www.ncei.noaa.gov/data/global-historical-climatology-network-daily/

Station information for each city can be accessed at: http://threadex.rcc-acis.org/

• 2024 August updated -

  Annual calculations for 2022 and 2023 were added.

  Linear regression results and thresholds for extremes were updated because of the addition of 2022 and 2023 data.

  Note that future updates may be infrequent.

• 2022 January updated -

  Annual calculations for 2021 were added.

  Linear regression results and thresholds for extremes were updated because of the addition of 2021 data.

• 2021 January updated -

  Annual calculations for 2020 were added.

  Linear regression results and thresholds for extremes were updated because of the addition of 2020 data.

• 2020 January updated -

  Annual calculations for 2019 were added.

  Linear regression results and thresholds for extremes were updated because of the addition of 2019 data.

  Thresholds for all 210 cities were combined into one single file – Thresholds.csv.

• 2019 June updated -

  Baltimore was updated with the 2018 data (previously version shows NA for 2018) and new ID to reflect the GCHN ID of Baltimore-Washington International AP. city_info file was updated accordingly.

  README file was updated to reflect the use of "wet days" index in this study. The 95% thresholds for calculation of wet days utilized all daily precipitation data from the reference period and can be different from the same index from some other studies, where only days with at least 1 mm of precipitation were utilized to calculate the thresholds. Thus the thresholds in this study can be lower than the ones that would've be calculated from the 95% percentiles from wet days (i.e., with at least 1 mm of precipitation).

In 2024, Louisiana recorded 71.25 inches of precipitation. This was the highest precipitation within the 48 contiguous U.S. states that year. On the other hand, Nevada was the driest state, with only 9.53 inches of precipitation recorded. Precipitation across the United States Not only did Louisiana record the largest precipitation volume in 2024, but it also registered the highest precipitation anomaly that year, around 14.36 inches above the 1901-2000 annual average. In fact, over the last decade, rainfall across the United States was generally higher than the average recorded for the 20th century. Meanwhile, the driest states were located in the country's southwestern region, an area which – according to experts – will become even drier and warmer in the future. How does global warming affect precipitation patterns? Rising temperatures on Earth lead to increased evaporation which – ultimately – results in more precipitation. Since 1900, the volume of precipitation in the United States has increased at an average rate of 0.20 inches per decade. Nevertheless, the effects of climate change on precipitation can vary depending on the location. For instance, climate change can alter wind patterns and ocean currents, causing certain areas to experience reduced precipitation. Furthermore, even if precipitation increases, it does not necessarily increase the water availability for human consumption, which might eventually lead to drought conditions.

U.S. 15 Minute Precipitation Data is digital data set DSI-3260, archived at the National Climatic Data Center (NCDC). This is precipitation data. The primary source of data for this file is approximately 2,000 mostly U.S. weather stations operated or managed by the U.S. National Weather Service. Stations are primary, secondary, or cooperative observer sites that have the capability to measure precipitation at 15 minute intervals. This dataset contains 15-minute precipitation data (reported 4 times per hour, if precip occurs) for U.S. stations along with selected non-U.S. stations in U.S. territories and associated nations. It includes major city locations and many small town locations. Daily total precipitation is also included as part of the data record. NCDC has in archive data from most states as far back as 1970 or 1971, and continuing to the present day. The major parameter is precipitation amounts at 15 minute intervals, when precipitation actually occurs.

Analysis of ‘U.S. 15 Minute Precipitation Data’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/a6756804-ab85-43c9-8728-1d54e5c3ba0a on 27 January 2022.

--- Dataset description provided by original source is as follows ---

U.S. 15 Minute Precipitation Data is digital data set DSI-3260, archived at the National Climatic Data Center (NCDC). This is precipitation data. The primary source of data for this file is approximately 2,000 mostly U.S. weather stations operated or managed by the U.S. National Weather Service. Stations are primary, secondary, or cooperative observer sites that have the capability to measure precipitation at 15 minute intervals. This dataset contains 15-minute precipitation data (reported 4 times per hour, if precip occurs) for U.S. stations along with selected non-U.S. stations in U.S. territories and associated nations. It includes major city locations and many small town locations. Daily total precipitation is also included as part of the data record. NCDC has in archive data from most states as far back as 1970 or 1971, and continuing to the present day. The major parameter is precipitation amounts at 15 minute intervals, when precipitation actually occurs.

--- Original source retains full ownership of the source dataset ---

Description

This dataset contains hourly data on the traffic volume for westbound I-94, a major interstate highway in the US that connects Minneapolis and St Paul, Minnesota. The data was collected by the Minnesota Department of Transportation (MnDOT) from 2012 to 2018 at a station roughly midway between the two cities.

Key Features

• holiday: a categorical variable that indicates whether the date is a US national holiday or a regional holiday (such as the Minnesota State Fair).
• temp: a numeric variable that shows the average temperature in kelvin.
• rain_1h: a numeric variable that shows the amount of rain in mm that occurred in the hour.
• snow_1h: a numeric variable that shows the amount of snow in mm that occurred in the hour.
• clouds_all: a numeric variable that shows the percentage of cloud cover.
• weather_main: a categorical variable that gives a short textual description of the current weather (such as Clear, Clouds, Rain, etc.).
• weather_description: a categorical variable that gives a longer textual description of the current weather (such as light rain, overcast clouds, etc.).
• date_time: a datetime variable that shows the hour of the data collected in local CST time.
• traffic_volume: a numeric variable that shows the hourly I-94 reported westbound traffic volume.

Potential Use Cases

The dataset can be used for regression tasks to predict the traffic volume based on the weather and holiday features. It can also be used for exploratory data analysis to understand the patterns and trends of traffic volume over time and across different conditions.

In this study, we develop urban ecosystem accounts in the U.S., using the System of Environmental-Economic Accounting Experimental Ecosystem Accounting (SEEA EEA) framework. Most ecosystem accounts focus on regional and national scales, which are appropriate for many ecosystem services. However, ecosystems provide substantial services in cities, improving quality of life and contributing to resiliency for substantial parts of the population. Our models estimate energy savings for indoor cooling resulting from heat mitigated by trees and rainfall intercepted by trees. Both models cover major cities in the contiguous U.S. and report the results through physical supply and use tables for multiple accounting periods (2011 and 2016). Using conservative assumptions, urban trees provide substantial heat mitigation (4,098 and 4,229 GWh, valued at $523 and $539 million in 2011 and 2016, respectively) and rainfall interception (2,422 and 2,627 million m3, valued at $434 and $425 million for 2011 and 2016, respectively). Interannual differences largely reflect variations in weather patterns. Our work shows how Earth observation data can support urban ecosystem accounting. We provide model code within a public repository to facilitate model runs elsewhere, enabling the SEEA EEA and Earth observation user communities to reuse our models and provide feedback for improvement.

Urban streams in the Denver, Colorado, USA region flow more often than undeveloped grassland streams. We sought to identify the sources of this increased flow using water stable isotope data and an analysis of streamflow responses to rain events. We collected and assessed 402 urban stream, 522 tap, and 38 precipitation samples across 2019, 2021, and 2022. Two endmember mixing analysis was utilized to obtain the percentage of precipitation-derived groundwater and tap water contributing to urban baseflow. Our endmember mixing results revealed that a major portion of stream water came from tap water, through excess lawn irrigation returning to the stream and leaking water pipes. The average portions of streamflow that come from tap water and lawn irrigation return flow were 76% and 47% respectively across 2019, 2021, and 2022. Uncertainty related to estimation of tap contribution and lawn irrigation return flow ranged from 3 – 29%. We also observed an increasing correlation between lawn irrigation return flow in urban streams and imperviousness of the watersheds in the Denver area. In semi-arid and arid cities in the USA, including in Denver, urban irrigation consumes a large portion of city water. Through an analysis of spatiotemporal variations in streamflow, we observed that tap water is a larger contributor to urban streamflow than increased stormflow during most months. The joint contributions of tap water and directly-connected impervious area driving increased stormwater lead to profound alterations in the urban streamflow regime compared to grassland streamflow. This study provides insights into how urban irrigation and stormwater together increase streamflow, aiding water managers in implementing effective water management strategies in water-scarce cities.

The continued provision of water from rivers in the southwestern United States to downstream cities, natural communities and species is at risk due to higher temperatures and drought conditions in recent decades. Snowpack and snowfall levels have declined, snowmelt and peak spring flows are arriving earlier, and summer flows have declined. Concurrent to climate change and variation, a century of fire suppression has resulted in dramatic changes to forest conditions, and yet, few studies have focused on determining the degree to which changing forests have altered flows. In this study, we evaluated changes in flow, climate, and forest conditions in the Salt River in central Arizona from 1914–2012 to compare and evaluate the effects of changing forest conditions and temperatures on flows. After using linear regression models to remove the influence of precipitation and temperature, we estimated that annual flows declined by 8–29% from 1914–1963, coincident with a 2-fold increase in basal area, a 2-3-fold increase in canopy cover, and at least a 10-fold increase in forest density within ponderosa pine forests. Streamflow volumes declined by 37–56% in summer and fall months during this period. Declines in climate-adjusted flows reversed at mid-century when spring and annual flows increased by 10–31% from 1964–2012, perhaps due to more winter rainfall. Additionally, peak spring flows occurred about 12 days earlier in this period than in the previous period, coincident with winter and spring temperatures that increased by 1–2°C. While uncertainties remain, this study adds to the knowledge gained in other regions that forest change has had effects on flow that were on par with climate variability and, in the case of mid-century declines, well before the influence of anthropogenic warming. Current large-scale forest restoration projects hold some promise of recovering seasonal flows.