Climate division
Last imported 10:05AM UTC on Tuesday, March 26, 2013. See log
Climate divisions defined by NOAA (e.g. VT2).
The National Oceanic and Atmospheric Administration divides each state into between one and ten climate divisions (see this map). Though intended to reflect climatic similarities, they sometimes reflect political and economic considerations as well. We take the 1970-2000 average annual heating and cooling degree days for each climate division from the National Climatic Data Center's U.S. Climate Normals. Annual cooling degree days is the annual sum of each day's average temperature - 65, with negative numbers rounded to zero. Annual heating degree days is the annual sum of 65 - each day's average temperature, with negative numbers rounded to zero.
Citing this data
To cite this data, reference Brighter Planet, "Climate divisions," <http://data.brighterplanet.com/climate_divisions>, retrieved 2013-05-21 16:41:56 UTC.
Download
Total: 359 records.
Random data sample
Sample: 5 records.
| name | heating degree days | heating degree days units | cooling degree days | cooling degree days units | state postal abbreviation |
|---|---|---|---|---|---|
| AK1 | 4493.89 | degrees_celsius | 1.11111 | degrees_celsius | AK |
| AK2 | 5273.89 | degrees_celsius | 5.0 | degrees_celsius | AK |
| AK3 | 5350.0 | degrees_celsius | 0.0 | degrees_celsius | AK |
| AK4 | 7836.11 | degrees_celsius | 0.555556 | degrees_celsius | AK |
| AK5 | 6122.78 | degrees_celsius | 0.0 | degrees_celsius | AK |
Import steps
Click a step for more detail.
-
Import a list of climate divisions and their average heating and cooling degree days
- Fetch data from static.brighterplanet.com.
- Store
- name
- heating_degree_days
- cooling_degree_days
- state_postal_abbreviation
Table structure
CREATE TABLE climate_divisions ( name CHARACTER VARYING(255) NOT NULL PRIMARY KEY, heating_degree_days FLOAT, heating_degree_days_units CHARACTER VARYING(255), cooling_degree_days FLOAT, cooling_degree_days_units CHARACTER VARYING(255), state_postal_abbreviation CHARACTER VARYING(255) );