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/m² 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

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.

Acknowledgements Staff-only pages Subscribe (RSS) Contact UC IPM

Agriculture and Natural Resources, University of California

Accessibility /WEATHER/abtwxreports.html?srcPage=WEATHER%2Fabtwxreports.html revised: June 21, 2016. Contact webmaster.