UC IPM Online UC ANR home page UC IPM home page

UC IPM Home

SKIP navigation

 

How to Manage Pests

California Weather Database: Description

Reports

Reports include the data for the selected station over the requested time period, in the units and format specified. In any format, the output includes:

  • information about the selected station and its variables
  • a "retrieval report" that indicates the number of data values supplied by the selected station and any backup or long-term average stations
  • a description of the file format
  • the data that were retrieved

Formatted report (all stations)

Column headings make this report easy to read, and links to tables of coded values are supplied. A unique feature of this report is that the source of each piece of data is indicated immediately following the data value (in the column headed by a "*"). When a data value is from the selected station, the column is blank; if the value is not supplied by the selected station, a code (1, 2, or A) indicates the source of the value: backup station 1, backup station 2, or the long-term average station.

Comma-delimited data file (for stations other than .P PestCast)

This format uses the quote character ("), recognized by most spreadsheets, to designate information documenting the retrieval results and file format. Otherwise, data for each date are separated by commas, and can be imported into spreadsheet or database software for further processing or analysis.

To save the data page as a file that can be used with a spreadsheet or database program, use your browser's "save as" command (usually on the File menu), specify a descriptive name if you wish, and save the file as text. You can also select all of the data displayed, copy and paste it to a new document in a text editor or word processsor, then save it as text.

UC IPM data file (for stations other than .P PestCast)

This format is identical to the format generated by the (now obsolete) IMPACT program or CALLIPM software. The format is for use specifically with DDU (the Degree-Day Utility), TRAP data management program, or CALEX/Rice or CALEX/Cotton.

To be used directly by these programs, the file can contain no extraneous information. For this reason, a page showing the station information and the "retrieval table" will be shown first, and the "View Data" button will bring up the data page.

To save the data page as a file that can be used with DDU, TRAP, or CALEX, use your browser's "save as" command (usually on the File menu), specify a descriptive name if you wish, and save the file as text. You can also select all of the data displayed, copy and paste it to a new document in a text editor or word processsor, then save it as text.

The resulting file is a text file in the following format.

English units version
DATA FIELD COLUMNS ENGLISH UNITS
Station 1 - 8  
Date 9 - 16 YYYYMMDD
Precipitation Amount 21 - 24 Inches per day
Precipitation Type 25 - 26 Two-letter code
Maximum Air Temperature 27 - 29 Fahrenheit
Minimum Air Temperature 30 - 32 Fahrenheit
Observed Air Temperature 33 - 35 Fahrenheit
Weather Condition 36 - 37 Two-letter code
Wind Direction 38 - 39 N,NE,E,SE,S,SW,W,NW; 0 is "calm"
Wind Speed 40 - 41 Miles per hour
Wet Bulb Temperature 42 - 45 Fahrenheit
Dry Bulb Temperature 46 - 49 Fahrenheit
Maximum Soil Temperature 50 - 52 Fahrenheit
Minimum Soil Temperature 53 - 54 Fahrenheit
Pan Evaporation 55 - 58 Inches per day
Solar Radiation 59 - 61 Langleys per day
Reference Evapotranspiration 63 - 66 Inches per day
Maximum Relative Humidity 68 - 71 Percent
Minimum Relative Humidity 72 - 75 Percent
Metric units version
DATA FIELD COLUMNS METRIC UNITS
Station 1 - 8  
Date 10 - 17 YYYYMMDD
Precipitation Amount 19 - 23 Millimeters per day
Precipitation Type 25 - 26 Two-letter code
Maximum Air Temperature 28 - 32 Celsius
Minimum Air Temperature 34 - 38 Celsius
Observed Air Temperature 40 - 44 Celsius
Weather Condition 46 - 47 Two-letter code
Wind Direction 49 - 50 N,NE,E,SE,S,SW,W,NW; 0 is "calm"
Wind Speed 52 - 53 Meters per second
Wet Bulb Temperature 55 - 59 Celsius
Dry Bulb Temperature 61 - 65 Celsius
Maximum Soil Temperature 67 - 70 Celsius
Minimum Soil Temperature 72 - 75 Celsius
Pan Evaporation 77 - 81 Millimeters per day
Solar Radiation 83 - 85 Watts/m2 per day
Reference Evapotranspiration 87 - 91 Millimeters per day
Maximum Relative Humidity 93 - 96 Percent
Minimum Relative Humidity 98 - 101 Percent

Comma-delimited file (compressed format) for .P PestCast Stations

This format uses the quote character ("), recognized by most spreadsheets, to designate information documenting the retrieval results and file format. Otherwise, data for each date are separated by commas and can be imported into spreadsheet or database software for further processing or analysis. The format is compressed so that every column has data, rather than leaving blank columns for variables not reported.

Comma-delimited file (fixed columns format) for .P PestCast Stations

This format is very similar to the Compressed Format, but the variables are output in a standard position for each request. This may result in a large number of empty columns.

Top of page


Statewide IPM Program, Agriculture and Natural Resources, University of California
All contents copyright 2014 The Regents of the University of California. All rights reserved.

For noncommercial purposes only, any Web site may link directly to this page. FOR ALL OTHER USES or more information, read Legal Notices. Unfortunately, we cannot provide individual solutions to specific pest problems. See our Home page, or in the U.S., contact your local Cooperative Extension office for assistance.

Agriculture and Natural Resources, University of California

Accessibility   /WEATHER/abtwxreports.html revised: July 10, 2014. Contact webmaster.