Watertown, SD Climate

Summary Graph

The summary climate graph for Watertown, SD shows a selection of temperature, rainfall and snow minimum, mean and maximum measures over the course of a year. Click on each of the measures in the key to toggle them on and off.

loading — Graph of average and extreme temperature ranges by day for Watertown, SD.

Temperature

The warmest month in Watertown Regional Airport, Watertown, South Dakota is July with an average high temperature of 84.3°F. The hottest day on record was May 10 1948 when the temperature hit 120.2°F. During January the overnight temperature drops to an average of 3.8°F with the lowest temperature of -35.1°F being recorded on February 9 1994.

Warmest Days

Warmest Months

Coldest Days

Coldest Months

The warmest days on record are:

10 May 1948	120.2°F
25 Jun 1988	105.1°F
10 Jul 1976	102.9°F
30 Jul 2006	102.9°F
31 Jul 1988	102°F

The warmest months on average were:

July 1976	92°F
August 1983	91.6°F
July 1988	90.8°F
August 1976	90.5°F
June 1988	90°F

The coldest days on record are:

9 Feb 1994	-35.1°F
15 Jan 2009	-34.1°F
1 Jan 1974	-33.2°F
19 Jan 1985	-32.3°F
2 Feb 1996	-32.1°F

The coldest months on average were:

February 1948	0°F
January 1982	-10.4°F
January 1978	-10.2°F
January 1977	-9.1°F
January 1979	-9.1°F

Rain

The wettest month by average rainfall in Watertown, SD is June with an average of 2.7 inches of rain falling on 9 to 10 days.Although in May it typically rains on more days with 2.0 inches falling in 10 to 11 days. The driest month by average rainfall in Watertown, SD is December with an average of 0.4 inches of rain falling on 2 to 3 days. Although in January it typically rains on less days with 0.4 inches falling in 1 to 2 days

Wettest Days

The wettest days on record are:

2 September 2006	3.2 inches
16 September 2010	2 inches
8 September 1985	1.8 inches
4 September 1999	1.6 inches
8 September 1976	1.5 inches

Wettest Months

The wettest months on record are:

June 1977	8.6 inches
June 1990	6.8 inches
September 2010	6.6 inches
June 1993	6.3 inches
June 1980	6.3 inches

Driest Months

The driest months on record are:

February 1948	0 inches
March 1948	0 inches
April 1948	0 inches
May 1948	0 inches
June 1948	0 inches

BENCHMARKS

Loading Time: Base Classes	0.0069
Controller Execution Time ( Climate / Summary )	0.3279
Total Execution Time	0.3349

GET DATA

No GET data exists

MEMORY USAGE

2,375,292 bytes

POST DATA

No POST data exists

URI STRING

climate/summary/united-states/south-dakota/watertown-regional-airport

CLASS/METHOD

climate/summary

DATABASE: xrssweather0-climatespy QUERIES: 36 (Show)

0.0007	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `urlState` = 'south-dakota' AND `urlName` = 'watertown-regional-airport' LIMIT 1
0.0020	SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTemp, AVG(`meanMaxTemp`) AS meanMaxTemp FROM (`aggMonthly`) WHERE `locationId` = '4296' GROUP BY `monthNo`
0.0023	SELECT MIN(`minTemp`) AS minMin, MAX(`minTemp`) AS maxMin, MIN(`maxTemp`) AS minMax, MAX(`maxTemp`) AS maxMax FROM (`aggMonthly`) WHERE `locationId` = '4296' GROUP BY `monthNo`
0.0020	SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTemp, AVG(`meanMaxTemp`) AS meanMaxTemp FROM (`aggMonthly`) WHERE `locationId` = '4296' GROUP BY `monthNo`
0.0019	SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTemp, AVG(`meanMaxTemp`) AS meanMaxTemp FROM (`aggMonthly`) WHERE `locationId` = '4296' GROUP BY `monthNo`
0.0016	SELECT `maxTemp`, `monthName`, `dayNo`, `dimDate`.`year`, `dimLocation`.`locationId`, `dimLocation`.`countryName`, `dimLocation`.`stateName`, `dimLocation`.`presentationName`, `dimLocation`.`urlCountry`, `dimLocation`.`urlState`, `dimLocation`.`urlName` FROM (`aggMonthly`) JOIN `dimLocation` ON `dimLocation`.`locationId` = `aggMonthly`.`locationId` JOIN `dimDate` ON `dimDate`.`dateId` = `aggMonthly`.`maxTempDate` WHERE `aggMonthly`.`locationId` = '4296' ORDER BY `maxTemp` desc LIMIT 1
0.0016	SELECT `minTemp`, `monthName`, `dayNo`, `dimDate`.`year`, `dimLocation`.`locationId`, `dimLocation`.`countryName`, `dimLocation`.`stateName`, `dimLocation`.`presentationName`, `dimLocation`.`urlCountry`, `dimLocation`.`urlState`, `dimLocation`.`urlName` FROM (`aggMonthly`) JOIN `dimLocation` ON `dimLocation`.`locationId` = `aggMonthly`.`locationId` JOIN `dimDate` ON `dimDate`.`dateId` = `aggMonthly`.`minTempDate` WHERE `aggMonthly`.`locationId` = '4296' ORDER BY `minTemp` asc LIMIT 1
0.0013	SELECT `monthNo`, `year`, `meanMinTemp` FROM (`aggMonthly`) WHERE `locationId` = '4296' ORDER BY `meanMinTemp` LIMIT 5
0.0013	SELECT `monthNo`, `year`, `meanMaxTemp` FROM (`aggMonthly`) WHERE `locationId` = '4296' ORDER BY `meanMaxTemp` desc LIMIT 5
0.1877	`select min(count_days) as min_days, avg(count_days) as average_days, max(count_days) as max_days from (select year, count(*) as count_days from factDaily fd join dimDate dd on (dd.dateId = fd.DateId) where fd.locationId = 4296 and minTemp <= 32 group by year) as count_freezing`
0.0436	`select min(count_days) as min_days, avg(count_days) as average_days, max(count_days) as max_days from (select year, count(*) as count_days from factDaily fd join dimDate dd on (dd.dateId = fd.DateId) where fd.locationId = 4296 and maxTemp <= 32 group by year) as count_freezing`
0.0052	SELECT AVG(`sumRainfall`) AS sumRainfall, AVG(`daysRainfall`) AS daysRainfall, AVG(`daysSnow`) AS daysSnow, AVG(`daysTornado`) AS daysTornado, AVG(`daysThunder`) AS daysThunder, `monthNo` FROM (`aggMonthly`) WHERE `locationId` = '4296' GROUP BY `monthNo`
0.0026	SELECT AVG(`sumRainfall`) AS sumRainfall, AVG(`daysRainfall`) AS daysRainfall, AVG(`daysSnow`) AS daysSnow, AVG(`daysTornado`) AS daysTornado, AVG(`daysThunder`) AS daysThunder, `monthNo` FROM (`aggMonthly`) WHERE `locationId` = '4296' GROUP BY `monthNo` ORDER BY `sumRainfall` desc LIMIT 1
0.0023	SELECT AVG(`sumRainfall`) AS sumRainfall, AVG(`daysRainfall`) AS daysRainfall, AVG(`daysSnow`) AS daysSnow, AVG(`daysTornado`) AS daysTornado, AVG(`daysThunder`) AS daysThunder, `monthNo` FROM (`aggMonthly`) WHERE `locationId` = '4296' GROUP BY `monthNo` ORDER BY `daysRainfall` desc LIMIT 1
0.0011	SELECT `monthNo`, `year`, `sumRainfall` FROM (`aggMonthly`) WHERE `locationId` = '4296' ORDER BY `sumRainfall` desc LIMIT 5
0.0011	SELECT `monthNo`, `year`, `sumRainfall` FROM (`aggMonthly`) WHERE `locationId` = '4296' ORDER BY `sumRainfall` LIMIT 5
0.0112	SELECT AVG(`sumRainfall`) AS sumRainfall, AVG(`daysRainfall`) AS daysRainfall, AVG(`daysSnow`) AS daysSnow, AVG(`daysTornado`) AS daysTornado, AVG(`daysThunder`) AS daysThunder, `monthNo` FROM (`aggMonthly`) WHERE `locationId` = '4296' GROUP BY `monthNo` ORDER BY `sumRainfall` asc LIMIT 1
0.0024	SELECT AVG(`sumRainfall`) AS sumRainfall, AVG(`daysRainfall`) AS daysRainfall, AVG(`daysSnow`) AS daysSnow, AVG(`daysTornado`) AS daysTornado, AVG(`daysThunder`) AS daysThunder, `monthNo` FROM (`aggMonthly`) WHERE `locationId` = '4296' GROUP BY `monthNo` ORDER BY `daysRainfall` asc LIMIT 1
0.0016	SELECT `maxTemp`, `monthName`, `dayNo`, `dimDate`.`year`, `dimLocation`.`locationId`, `dimLocation`.`countryName`, `dimLocation`.`stateName`, `dimLocation`.`presentationName`, `dimLocation`.`urlCountry`, `dimLocation`.`urlState`, `dimLocation`.`urlName` FROM (`aggMonthly`) JOIN `dimLocation` ON `dimLocation`.`locationId` = `aggMonthly`.`locationId` JOIN `dimDate` ON `dimDate`.`dateId` = `aggMonthly`.`maxTempDate` WHERE `aggMonthly`.`locationId` = '4296' ORDER BY `maxTemp` desc LIMIT 5
0.0003	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0004	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0005	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0005	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0005	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0016	SELECT `minTemp`, `monthName`, `dayNo`, `dimDate`.`year`, `dimLocation`.`locationId`, `dimLocation`.`countryName`, `dimLocation`.`stateName`, `dimLocation`.`presentationName`, `dimLocation`.`urlCountry`, `dimLocation`.`urlState`, `dimLocation`.`urlName` FROM (`aggMonthly`) JOIN `dimLocation` ON `dimLocation`.`locationId` = `aggMonthly`.`locationId` JOIN `dimDate` ON `dimDate`.`dateId` = `aggMonthly`.`minTempDate` WHERE `aggMonthly`.`locationId` = '4296' ORDER BY `minTemp` asc LIMIT 5
0.0005	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0005	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0005	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0005	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0005	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0019	SELECT `maxRainfall`, `monthName`, `dayNo`, `dimDate`.`year`, `dimLocation`.`locationId`, `dimLocation`.`countryName`, `dimLocation`.`stateName`, `dimLocation`.`presentationName`, `dimLocation`.`urlCountry`, `dimLocation`.`urlState`, `dimLocation`.`urlName` FROM (`aggMonthly`) JOIN `dimLocation` ON `dimLocation`.`locationId` = `aggMonthly`.`locationId` JOIN `dimDate` ON `dimDate`.`dateId` = `aggMonthly`.`maxRainfallDate` WHERE `aggMonthly`.`locationId` = '4296' AND `dimDate`.`monthNo` = '9' ORDER BY `maxRainfall` desc LIMIT 5
0.0005	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0005	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0005	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0005	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1
0.0005	SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '4296' LIMIT 1

HTTP HEADERS (Show)

CONFIG VARIABLES (Show)

HTTP_ACCEPT	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
HTTP_USER_AGENT	CCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_CONNECTION	Keep-Alive
SERVER_PORT	80
SERVER_NAME	www.climatespy.com.fqdns.net
REMOTE_ADDR	54.162.159.33
SERVER_SOFTWARE	Apache (Unix)
HTTP_ACCEPT_LANGUAGE
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/1.1
QUERY_STRING
HTTP_ACCEPT_ENCODING	gzip
HTTP_X_FORWARDED_FOR

base_url	http://www.climatespy.com.fqdns.net/
enable_profile	1
show_profile
index_page
uri_protocol	AUTO
url_suffix
language	english
charset	UTF-8
enable_hooks
subclass_prefix	MY_
permitted_uri_chars	a-z 0-9~%.:_\-
allow_get_array	1
enable_query_strings
controller_trigger	c
function_trigger	m
directory_trigger	d
log_threshold	1
log_path
log_date_format	Y-m-d H:i:s
cache_path
encryption_key
sess_cookie_name	ci_session
sess_expiration	7200
sess_expire_on_close
sess_encrypt_cookie
sess_use_database
sess_table_name	ci_sessions
sess_match_ip
sess_match_useragent	1
sess_time_to_update	300
cookie_prefix
cookie_domain
cookie_path	/
cookie_secure
global_xss_filtering
csrf_protection
csrf_token_name	csrf_test_name
csrf_cookie_name	csrf_cookie_name
csrf_expire	7200
compress_output	1
time_reference	local
rewrite_short_tags
proxy_ips