Search Database

A variety of special data searches can be performed with this option. Large data files can be quickly scanned for extremes, averages, totals, or occurrences of various input criteria. Occurrences can be evaluated in terms of consecutive days, frequencies, or first and last events in a given time period. Date limits can also refine the search results.

First the Search Type is selected from the drop-down menu, then the weather parameter (Maximum Temp, Minimum Temp, etc.) is selected. Optionally, the Beginning Date and Ending Date can be changed to limit the months or years used in the search.

The number of records that will be displayed in the "Highest", "Lowest" and "Consecutive Days" search can be changed with the "Number of Records" slidebar.

Search Types

  1. Highest
  2. Lowest
  3. Consecutive Days
  4. Daily Frequencies
  5. Daily Averages
  6. First/Last Dates
  7. Monthly Frequencies
  8. Monthly Avgs/Totals
  9. Average
  1. Back to Top
  2. Return to Climate Map

Highest

This search displays the highest single day values for the period set by the beginning and ending dates. Also, the highest average values for the entire period are displayed in a second column.

The number of days shown is set with the Show Top XX Results button.

  1. Back to Top
  2. Return to Climate Map

Lowest

This search displays the lowest single day values for the period set by the beginning and ending dates. Also, the highest average values for the entire period are displayed in a second column

The number of days shown is set with the Show Top XX Results button.

  1. Back to Top
  2. Return to Climate Map

Consecutive Days

This search finds the longest periods where user designated limiting criteria were met in consecutive days.

For example, the most days in a row without any precipitation, or the most days in in a row with minimum temperatures below -40. These criteria can be either greater than " > " or less than " < " a numeric value and are set by selecting either the Greater or Less Than radio button and entering the number in the following text box. To search for precipitation values greater or less than a trace, enter a T in the text box.

  1. Back to Top
  2. Return to Climate Map

Daily Frequencies

This search displays the number of days that an event occurred per calendar date, for all of the years selected in the search.

The criteria can be either greater than " > " or less than " < " a numeric value and are set by selecting either the Greater or Less Than radio button and entering the number in the following text box. To search for precipitation values greater or less than a trace, enter a T in the text box. Column and row totals are included.

  1. Back to Top
  2. Return to Climate Map

Daily Averages

This search displays the averages by calendar day for all of the years selected in the search.

The criteria can be either greater than " > " or less than " < " a numeric value and are set by selecting either the Greater or Less Than radio button and entering the number in the following text box. To search for precipitation values greater or less than a trace, enter a T in the text box. Column and row totals are included.

  1. Back to Top
  2. Return to Climate Map

First/Last Dates

This search finds the earliest and latest dates that an event first occurred in a period, and the same for when it last occurred. Also, the most and least days between first and last events is determined. Averages for all three categories are calculated as well.

The criteria can be either greater than " > " or less than " < " a numeric value and are set by selecting either the Greater or Less Than radio button and entering the number in the following text box. To search for precipitation values greater or less than a trace, enter a T in the text box. Column and row totals are included.

  1. Back to Top
  2. Return to Climate Map

Monthly Frequencies

This search display the number of days that an event occurs in each month/year within the date limits set. The results are displayed in a table of months vs years. Column and row totals are included.

The criteria can be either greater than " > " or less than " < " a numeric value and are set by selecting either the Greater or Less Than radio button and entering the number in the following text box. To search for precipitation values greater or less than a trace, enter a T in the text box. Column and row totals are included.

  1. Back to Top
  2. Return to Climate Map

Monthly Avgs/Totals

This seach displays the monthly averages and totals for the selected variable. The results are displayed in a table of months vs years. Column and row totals are included.

The criteria can be either greater than " > " or less than " < " a numeric value and are set by selecting either the Greater or Less Than radio button and entering the number in the following text box. To search for precipitation values greater or less than a trace, enter a T in the text box. Column and row totals are included.

  1. Back to Top
  2. Return to Climate Map

Averages

This search displays a single daily average for the selected variable over the date range selected. In the case of Precipitation, Snowfall, and Degree Days an average for the total period is calculated as well.

  1. Back to Top
  2. Return to Climate Map