Part 2—Calculate Summer Air Temperature Averages 1980-1999
In any step, click the Show me link to reveal extra information. If you prefer a printout of the full set of instructions for this part, choose Print from the File menu.
Step 1 - Add Data to ArcMap
- Open ArcGIS ArcCatalog and browse to the "NCAR Climate Change" folder created in Part 1. The following shapefiles should be present in the folder.
- Begin by renaming each of the shapefiles by removing the "-180.0_180.0_-90.0_90.0" from each file name.
- Open ArcMap and add the three 1980-1999 20th Century Experiment shapefiles to the Layer list.
The following three files should now be in the Layer list. -
Right-click on one of the layers in the Table of Contents and select Open Attribute Table. Examine the attribute table. As downloaded from the portal, the table of attributes associated with each shapefile represents air temperature for each month (e.g., August) over the 20 year time frame.
Step 2 - Calculate Summer Averages for 1980-1999
The steps in the next two parts are used to analyze and compare the 20th Century Experiment ensemble averages for the northern hemisphere summer months (June-July-August) to the projected A2 Scenario ensemble averages for the same months. Any model run and/or set of years available from the NCAR GIS Climate Change Portal can be similarly analyzed.
The first step is to combine the months that were downloaded as separate files into one file in order to calculate a June, July, and August average for each of the 20 years. This is done separately for each model run. For example, from the 6 separate shapefiles, you will derive the June, July, August (JJA) average for each year and for each model.
First, (in Part 2, Step 2) for the 20th Century Experiment Model Run 1980 - 1999
The first step is to combine the months that were downloaded as separate files into one file in order to calculate a June, July, and August average for each of the 20 years. This is done separately for each model run. For example, from the 6 separate shapefiles, you will derive the June, July, August (JJA) average for each year and for each model.
First, (in Part 2, Step 2) for the 20th Century Experiment Model Run 1980 - 1999
- 1980 JJA average
- 1981 JJA average
- 1982 JJA average ...
- 1999 JJA average
- 2021 JJA average
- 2022 JJA average
- 2023 JJA average ...
- 2040 JJA average
- Return to ArcCatalog to make a copy of tas_June_1980_1999_20th_Century_Experiment. Rename the copy "tas_JJA_1980-1999_20th_Century_Experiment". You will use this file for your averages.
- Drag tas_JJA_1980-1999_20th_Century_Experiment file from ArcCatalog to the top of the ArcMap Layer list, above the three monthly layers.
- Join each of the July (07) and August (08) attribute tables to the tas_JJA_1980-1999_20th_Century_Experiment attribute table using the FID field.
- Open and examine the tas_JJA_1980-1999_20th_Century_Experiment attribute table. Verify that the joins were successful. You should now have temperature data for all three months for the years 1980-1999.
- Add new fields to this table to accommodate the calculation of the yearly JJA weighted averages for 1980-1999. Name the new fields JJA1980avg, JJA1981avg, JJA1982avg...JJA1999avg for a total of 20 new fields.
- Calculate JJA weighted average for each year using the Field Calculator in the attribute table
- Repeat for each of the 20 fields JJA1981avg-JJA1999avg
Weighted Average: From this step, for each unique cell from the CCSM model output, a JJA weighted average for each year is calculated for each model run. The weighted average is simply considering the unequal number of days within each calendar month, and weighting appropriately by multiplying each monthly average by the number of days within each month and dividing by the total. From this, for each unique cell from the CCSM model output, a JJA weighted average for each year is calculated for each model run. For example, the equation below demonstrates the calculation for the 1980 JJA average:number of days.
To prevent syntax errors copy and paste the following equation into the Field Calculator.
((30 *[tas_JJA_1980_1999_20th_Century_Experiment.198006]) + (31 *[tas_July_1980_1999_20th_Century_Experiment.198007]) + (31 *[tas_August_1980_1999_20th_Century_Experiment.198008]))/92
If you had difficulty completing the steps listed above, download this completed file and place it in your NCAR Climate Change Folder.
Calculated Summer Averages for 1980-1999
tas_JJA_1980_1999_20th_Century_Experiment_completed (Zip Archive 8.1MB Jan10 09)
Calculated Summer Averages for 1980-1999
tas_JJA_1980_1999_20th_Century_Experiment_completed (Zip Archive 8.1MB Jan10 09)
Step 3 - Calculate 20-year Average for 1980-1999
- Add a new field to the attribute table to accommodate the 20-year JJA Average. Name this field JJA_20_avg.
- Calculate 20-year mean using the Field Calculator in the Attribute table.
To prevent syntax errors copy and paste the following equation into the field calculator.
([tas_JJA_1980_1999_20th_Century_Experiment.JJA1980avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1981avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1982avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1983avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1984avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1985avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1986avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1987avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1988avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1989avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1990avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1991avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1992avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1993avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1994avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1995avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1996avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1997avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1998avg] + [tas_JJA_1980_1999_20th_Century_Experiment.JJA1999avg])/20