APPENDIX 7-B. WEATHER STATION DATA MAPPING TO RECS 

HOUSEHOLDS 

TABLE OF CONTENTS

7-B.1 INTRODUCTION ................................................................................................. 7-B-1

7-B.2 MAPPING METHODOLOGY ............................................................................. 7-B-1

7-B.3 MAPPING RESULTS ........................................................................................... 7-B-2

7-B.4 REFERENCES ...................................................................................................... 7-B-6

LIST OF TABLES

Table 7-B.3.1 Weather Station Data ........................................................................... 7-B-2

7-B-i
APPENDIX 7-B. MAPPING OF WEATHER STATION DATA TO RECS 

HOUSEHOLDS

7-B.1 INTRODUCTION

Energy Information Administration’s (EIA) 2009 Residential Energy Consumption 

Survey (RECS 2009)1 provide data on annual heating and cooling degree-days but not on other 

weather parameters needed for the analysis such as average monthly outdoor absolute humidity

(AH), monthly heating degree days (HDD) and cooling degree days (CDD), and average outdoor 

temperature. 

7-B.2 MAPPING METHODOLOGY

To derive the additional weather data that is needed for the analysis (e.g., AH), for each 

building in the sample, DOE developed an approach to assign a physical location to each RECS 

household. a The methodology consists of the following steps:

1. DOE assembled monthly weather data from 151 weather stations from the National 

Oceanic and Atmospheric Administration (NOAA)’s National Climatic Data Center 

(NCDC) that provide the heating and cooling degree-days at base temperature 65o

F for 

year 2009 (for the RECS sample).

3 The 2009 heating and cooling degree days match the 

period used to determine the degree-days in RECS 2009.

2. RECS reports both annual HDD and CDD to base temperature 65oF for each building 

record. DOE assigned each building to one of the 151 weather stations by calculating 

which weather station (within the appropriate region) was the closest using the root mean 

square distance of the RECS annual degree days to the weather station annual degree 

days. The following equation calculates the root mean square distance in degree days 

between the U.S. weather data and the RECS/CBECS data:

" Distance" = ( HDD − HDD ) + (CDD − CDD ) 2 1

2

2 1

2

Where:

HDD1 = heating degree days from U.S. weather data,

HDD2 = heating degree days from RECS data,

CDD1 = cooling degree days from U.S. weather data, and

CDD2 = cooling degree days from RECS data.

a For confidentiality, heating and cooling degree day values were altered slightly by EIA to mask the exact 

geographic location of the housing unit.

7-B-1

 
7-B.3 MAPPING RESULTS

Table 7-C.3.1 shows the imputation results for all RECS locations. Note that some U.S. 

weather station data match with several of the RECS weather data. The number of RECS 

buildings that were matched to the specified weather station is indicated in the column “Count”. 

Table 7-C.3.1 shows the data matches (151 weather stations) including the outdoor AH for the 

weather stations.

Table 7-B.3.1 Weather Station Data

WBAN State City HDD CDD Vapor Density DOEID

03013 CO LAMAR 5374 1003 0.0060160842 1

03031 TX ODESSA 2355 2478 0.0076450452 4

03102 CA ONTARIO 1315 1952 0.0080335282 10

03104 CA PALM SPRINGS 1067 3943 0.0066554348 1

03178 CA SAN DIEGO 1530 826 0.0093166774 1

03849 KY LONDON 4287 1039 0.0093844476 8

03856 AL HUNTSVILLE 2971 1847 0.0106559281 4

03882 FL PANAMA CITY 1235 2952 0.0143677968 4

03894 TN CLARKSVILLE 3927 1293 0.0100264573 10

03904 TX COLLEGE STATION 1475 3421 0.0119196775 1

03919 KS SALINA 5080 1307 0.008216447 1

03928 KS WICHITA 4521 1495 0.0087987799 6

03947 MO KANSAS CITY 5007 1083 0.0088161017 41

03953 AR JONESBORO 3521 1684 0.010599441 4

03963 MO JEFFERSON CITY 4507 1158 0.0089089311 6

04726 PA JOHNSTOWN 6676 263 0.0069141535 2

04781 NY ISLIP 5277 657 0.007716758 46

04841 WI SHEBOYGAN 7720 258 0.0067380115 21

04845 WI KENOSHA 7149 345 0.0070480555 21

04849 OH LORAIN/ELYRIA 5667 733 0.0075507607 8

04852 OH NEW PHILADELPHIA 5649 605 0.0075274837 3

04858 OH NEWARK 5862 518 0.0080336913 20

12815 FL ORLANDO 590 3599 0.0144723192 4

12838 FL MELBOURNE 548 3590 0.0154710453 4

12839 FL MIAMI 109 4905 0.0168885045 4

12842 FL TAMPA 488 3866 0.0152015791 4

12843 FL VERO BEACH 489 3547 0.0159311502 4

12844 FL WEST PALM BEACH 239 4234 0.0155691407 4

12849 FL FORT LAUDERDALE 120 4726 0.0165875652 4

12873 FL ST PETERSBURG/ CLEARWATER 444 3963 0.0153142247 4

12947 TX COTULLA 1089 4060 0.0122759646 1

12960 TX HOUSTON 1255 3419 0.0138533393 5

13722 NC RALEIGH/DURHAM 3126 1876 0.0099136985 4

13729 WV ELKINS 5508 420 0.007951544 50

13733 VA LYNCHBURG 4394 1025 0.0088138222 29

13739 PA PHILADELPHIA 4498 1211 0.0085328605 5

13740 VA RICHMOND 3742 1570 0.0094171582 14

13748 NC WILMINGTON 2439 2053 0.0118205767 1

7-B-2
WBAN State City HDD CDD Vapor Density DOEID

13833 MS HATTIESBURG 1878 2617 0.0126452945 3

13837 GA AUGUSTA 2082 2444 0.0105780255 2

13841 OH WILMINGTON 5373 702 0.008214416 8

13874 GA ATLANTA 2803 1849 0.0107638781 6

13876 AL BIRMINGHAM 2612 1950 0.0110090341 2

13877 TN BRISTOL/JHNSN CTY/KNGSPRT 4244 941 0.0091840512 2

13881 NC CHARLOTTE 3325 1623 0.0099698823 13

13882 TN CHATTANOOGA 3141 1822 0.0103702599 2

13891 TN KNOXVILLE 3593 1401 0.0099456766 3

13894 AL MOBILE 1608 2680 0.0130542794 2

13897 TN NASHVILLE 3589 1553 0.0098770797 3

13963 AR LITTLE ROCK 2939 1940 0.011046741 1

13978 MS GREENWOOD 2464 2237 0.0117848858 1

13987 MO JOPLIN 4258 1349 0.0091626993 18

13989 KS EMPORIA 4939 1130 0.0084067492 14

13993 MO ST JOSEPH 5583 971 0.0081289433 29

13995 MO SPRINGFIELD 4570 1110 0.0089819159 15

14605 ME AUGUSTA 7465 275 0.0065529735 31

14710 NH MANCHESTER 6366 553 0.0068233628 17

14732 NY NEW YORK 4566 1049 0.0077815891 35

14735 NY ALBANY 6506 450 0.0070472883 14

14736 PA ALTOONA 6095 390 0.0073154231 8

14745 NH CONCORD 7350 329 0.0067044268 12

14758 CT NEW HAVEN 5339 706 0.0081707387 4

14764 ME PORTLAND 7023 304 0.0070281667 27

14765 RI PROVIDENCE 5610 591 0.0075202781 14

14768 NY ROCHESTER 6689 325 0.0071111021 69

14770 PA SELINSGROVE 5524 715 0.0077313171 4

14771 NY SYRACUSE 6516 428 0.0069783428 13

14778 PA WILLIAMSPORT 5584 659 0.0074689608 1

14794 RI WESTERLY 5721 464 0.0083001294 3

14815 MI BATTLE CREEK 6420 514 0.0072130328 19

14820 OH CLEVELAND 5742 681 0.0076627958 21

14821 OH COLUMBUS 5207 873 0.0077971836 9

14827 IN FORT WAYNE 5939 616 0.00788948 15

14850 MI TRAVERSE CITY 7517 247 0.0064113439 19

14853 MI DETROIT 6659 449 0.0071093382 19

14914 ND FARGO 9240 361 0.005866579 9

14916 ND GRAND FORKS 9736 268 0.0059222236 19

14919 ND JAMESTOWN 9644 258 0.0058707582 12

14920 WI LA CROSSE 7210 520 0.0069321426 21

14921 WI LONE ROCK 7130 378 0.0070061569 21

14925 MN ROCHESTER 7658 319 0.0066144531 38

14939 NE LINCOLN 6105 896 0.007342676 14

14950 IA OTTUMWA 6277 573 0.0079394164 11

14991 WI EAU CLAIRE 8026 329 0.0063139509 21

22010 TX DEL RIO 1265 3806 0.0105411543 1

23042 TX LUBBOCK 3151 1968 0.0071494326 1

7-B-3
WBAN State City HDD CDD Vapor Density DOEID

23065 KS GOODLAND 5983 728 0.0063323031 1

23090 NM FARMINGTON 5225 1003 0.0041742386 1

23129 CA LONG BEACH 1125 1208 0.0098345389 4

23157 CA BISHOP 4063 1140 0.0036467675 2

23174 CA LOS ANGELES 1275 551 0.0096459357 2

23185 NV RENO 4942 1069 0.0040345727 1

23213 CA SANTA ROSA 3135 350 0.0081665898 2

23230 CA OAKLAND 2827 174 0.0085942545 2

23232 CA SACRAMENTO 2531 1344 0.0081042454 1

23234 CA SAN FRANCISCO 2584 214 0.0087316501 3

24012 ND DICKINSON 9526 183 0.0055502263 6

24023 NE NORTH PLATTE 6872 534 0.0066847 1

24033 MT BILLINGS 6695 623 0.0047439218 1

24090 SD RAPID CITY 7752 354 0.0054756864 34

24130 OR BAKER CITY 7660 192 0.0051141527 1

24143 MT GREAT FALLS 7940 288 0.0043370561 1

24153 MT MISSOULA 7492 353 0.0048594245 1

24216 CA RED BLUFF 2518 2096 0.0070521959 2

24221 OR EUGENE 5046 330 0.0076039356 1

24225 OR MEDFORD 4456 1024 0.0064759087 1

24229 OR PORTLAND 4282 628 0.0074672022 1

24232 OR SALEM 4701 454 0.0073914877 1

24234 WA SEATTLE 4706 374 0.0074312216 6

53120 CA RAMONA 2304 980 0.0076951935 1

53866 IN SHELBYVILLE 5427 732 0.0083896808 7

53867 SC COLUMBIA 2391 2329 0.0110377232 1

53872 NC MONROE 3197 1720 0.0101469551 4

53903 TX HUNTSVILLE 1637 3151 0.0125537826 8

53909 TX FORT WORTH 2220 2704 0.0106132655 3

54737 PA LANCASTER 5366 764 0.0081751608 24

54740 VT SPRINGFIELD 7388 298 0.0065290992 1

54743 NJ CALDWELL 5368 761 0.0076220114 17

54756 MA ORANGE 7079 377 0.0068937208 43

54769 MA PLYMOUTH 6050 453 0.0079864434 43

54777 MA TAUNTON 6099 468 0.0076840108 43

54781 VT BENNINGTON 7145 244 0.0068121386 9

54782 PA POTTSTOWN 4980 844 0.0082301142 19

54788 CT MERIDEN 5924 548 0.0077707976 23

93084 AZ SAFFORD 1968 2942 0.004977519 1

93134 CA LOS ANGELES 844 1371 0.0093026134 4

93193 CA FRESNO 2274 2383 0.0074362585 2

93778 PA YORK 5485 707 0.008171033 7

93780 NJ MOUNT HOLLY 4881 859 0.0085453221 17

93801 GA ROME 3155 1695 0.0107720384 26

93805 FL TALLAHASSEE 1564 2808 0.0132476954 4

93814 KY COVINGTON 4884 881 0.0086178081 3

93817 IN EVANSVILLE 4363 1281 0.0092907246 2

93821 KY LOUISVILLE 4132 1324 0.009041761 5

7-B-4
WBAN State City HDD CDD Vapor Density DOEID

93990 KS HILL CITY 5569 1047 0.0074465493 3

93992 AR EL DORADO 2620 2112 0.011859783 1

94014 ND WILLISTON 9630 296 0.0053011177 14

94040 NE MC COOK 5994 852 0.0070509402 2

94227 WA SHELTON 5714 176 0.0072152937 2

94240 WA QUILLAYUTE 5885 42 0.0074349835 2

94741 NJ TETERBORO 4884 944 0.0077413683 17

94822 IL ROCKFORD 6656 433 0.0072514877 50

94823 PA PITTSBURGH 5627 631 0.0073981585 6

94847 MI DETROIT 6062 597 0.0072827025 19

94943 SD CHAMBERLAIN 7314 556 0.00654522 26

94950 SD MITCHELL 7295 576 0.0069465882 23

94963 MN MINNEAPOLIS 7592 544 0.0062048826 24

94971 IA ESTHERVILLE 7931 362 0.0066166922 6

94982 IA DAVENPORT 6533 542 0.0075225903 4

94988 IA MARSHALLTOWN 7105 442 0.0073512376 14

94993 SD SISSETON 8780 321 0.0062633651 5

7-B-5
7-B.4 REFERENCES

1. U.S. Department of Energy: Energy Information Administration, Residential Energy 

Consumption Survey: 2009 RECS Survey Data, 2013. (Last accessed March, 2013.) 

<http://www.eia.gov/consumption/residential/data/2009/>

2. U.S. Department of Energy: Energy Information Administration, Commercial Buildings 

Energy Consumption Survey, 2003. (Last accessed September, 2013.) 

<http://www.eia.doe.gov/emeu/cbecs/>

3. National Oceanic And Atmospheric Administration, Degree Days Archives, 1997-

Present.

<ftp://ftp.cpc.ncep.noaa.gov/htdocs/products/analysis_monitoring/cdus/degree_days/archi

ves/>

4. American Society for Heating Refrigeration and Air-Conditioning Engineers (ASHRAE), 

ASHRAE Handbook: Fundamentals. 1993.

7-B-6