### Author: Abt Associates, Inc.

Date Created:9/26/2008 Date Modified:5/10/2011

Purpose:Contains FCP-generated affected population estimates by state for the analysis in support of Executive Order 12898: Environmental Justice.

File Contents: WorksheetContents

GIS_OutputContains FCP-based affected population estimates by state. The number of affected individuals is determined for each state with in-scope facilities as opposed to each in-scope facility to avoid double counting in those instances when more than 1 in-scopeVariable Naming Convention for Population Counts

Columns with pops are in the from - AA_BB_C_D where: AA=FB for 50 mile facility buffer or RB for 50 mile nearest reach buffer BB =TP for total population and FP for angler population C is the race flag W=White B=Black N=Native Amer A=Asian O=Other D=B for Below 20k income and A for above 20k income Other Vars E2RF1 - key to ERF1.2 field RTPE - type flag from ERF1.2 file Distance = ditance to nearest reach (km)

1 2 3 4 5 6 7 8 FIPSFB_TP_W_BFB_TP_B_BFB_TP_N_BFB_TP_A_BFB_TP_O_BFB_TP_W_AFB_TP_B_A

033,826,537 11,352,318 509,953 1,715,707 3,442,261144,053,51021,029,228 1 1,091,330 606,984 9,527 12,108 19,674 3,425,746 729,620 2 312 3 105 21 12 1,648 35 4 10,220 263 12,266 163 1,049 30,365 398 5 562,931 174,836 25,567 6,507 17,126 1,546,036 195,662 6 2,019,644 510,839 55,716 553,281 951,147 10,400,204 1,222,123 8 464,752 40,965 9,468 18,073 70,722 2,722,719 126,436 9 1,558,324 564,539 25,662 146,471 436,566 8,022,362 1,361,575 10 862,782 441,341 6,432 45,972 84,764 4,655,522 884,605 12 2,662,964 919,123 22,214 60,073 153,73410,153,246 1,589,890 13 817,591 755,203 5,376 21,558 39,384 3,569,557 1,462,041 15 45,580 5,518 2,776 79,489 12,906 259,424 28,973 17 2,381,371 932,576 16,248 90,506 192,94211,562,237 1,709,481 18 2,109,203 788,132 13,657 78,863 173,097 10,310,237 1,554,839 19 642,021 49,867 6,534 9,351 15,247 2,492,460 71,403 20 425,089 93,065 12,994 9,657 18,472 1,889,527 179,727 21 1,733,711 278,826 6,708 16,857 17,817 5,340,996 384,811 22 802,517 763,146 9,445 18,752 19,455 2,527,585 814,111 23 583,307 13,001 3,544 16,065 27,870 2,613,159 38,630 24 787,386 525,299 7,242 56,005 47,814 5,845,220 1,705,056 25 1,420,886 157,642 12,042 69,518 156,971 6,926,041 367,675 26 1,481,949 538,063 15,259 34,820 56,520 7,242,245 1,018,837 27 683,471 57,793 14,271 29,757 20,824 3,733,021 116,627 28 287,733 326,323 2,128 4,744 4,151 962,269 365,346 29 1,010,935 286,131 9,656 19,711 25,675 4,334,342 488,034 30 43,763 380 3,480 341 1,279 128,861 482 31 243,513 24,819 4,860 3,965 9,422 1,055,707 40,358 33 645,058 70,943 4,635 45,873 54,511 3,269,825 171,327 34 3,019,378 1,503,461 39,494 319,283 686,677 15,140,558 3,300,470 35 25,164 273 22,335 267 3,869 87,434 679 36 3,558,423 1,289,421 47,579 307,080 659,33916,152,425 2,739,128 37 1,374,626 780,205 35,274 22,479 63,404 5,470,512 1,353,403 38 48,892 428 3,282 292 794 159,886 880 39 2,767,783 696,098 14,703 47,997 59,46010,662,805 1,097,041 40 576,752 102,306 82,789 16,036 34,214 1,722,232 146,587 41 385,560 19,314 8,096 19,174 34,124 1,854,760 41,6991 2 3 4 5 6 7 8

FIPSFB_TP_W_BFB_TP_B_BFB_TP_N_BFB_TP_A_BFB_TP_O_BFB_TP_W_AFB_TP_B_A

42 3,059,401 812,887 13,175 84,816 125,59212,979,645 1,637,682 44 816,115 101,827 7,835 50,712 80,278 3,809,546 229,096 45 969,638 742,797 23,358 15,999 29,001 3,988,312 1,164,880 46 25,166 82 2,028 88 107 67,080 157 47 1,430,334 410,754 6,063 13,978 23,628 4,221,393 647,986 48 2,634,026 851,136 35,728 104,855 617,05610,497,592 1,568,385 49 195,759 3,703 3,391 7,984 16,090 1,287,098 11,697 50 241,055 15,919 1,436 5,184 26,805 941,449 32,796 51 1,622,142 1,002,455 13,028 72,354 61,332 8,431,231 2,606,105 53 500,468 33,177 13,836 33,909 53,657 2,335,849 88,072 54 1,591,477 156,700 4,688 12,525 10,532 3,950,146 186,825 55 1,295,036 311,358 17,491 66,891 131,752 7,114,195 548,565 56 29,422 338 495 173 974 106,744 5879 10 11 12 13 14 15

FB_TP_N_AFB_TP_A_AFB_TP_O_ARB_FP_W_BRB_FP_B_BRB_FP_N_BRB_FP_A_B

1,173,361 7,544,502 9,283,340 839,821 142,937 11,661 1,419 20,108 36,120 44,726 14,104 4,527 0 0 177 28 45 14,859 249 1,752 45 0 0 0 43,180 16,812 33,002 16,947 5,328 709 0 179,038 2,605,902 3,084,811 7,306 231 987 2 31,312 84,662 227,659 3,963 0 0 312 53,547 644,500 816,247 13,875 122 0 566 15,693 167,089 137,235 4,165 284 33 0 53,067 232,982 420,968 38,534 8,229 0 0 15,678 97,006 129,853 12,457 9,140 0 0 11,607 442,274 51,284 47,335 433,569 712,556 88,517 10,308 0 0 39,926 397,545 644,825 48,177 2,989 0 0 10,679 29,899 45,864 18,876 1,790 0 0 30,671 33,853 51,028 12,493 681 50 406 11,459 53,834 36,614 51,844 5,320 0 0 19,190 47,428 42,170 41,865 25,283 0 0 7,591 66,988 52,219 9,109 1,377 479 0 31,571 381,837 249,172 14,529 2,013 4,147 0 25,351 246,550 255,024 22,220 56 29 574 40,574 163,490 157,378 41,270 10,724 0 0 28,664 115,473 59,919 44,260 7 0 0 4,290 13,379 7,588 5,097 4,766 0 0 22,821 68,042 66,714 18,234 399 0 102 4,480 701 1,516 79 0 0 0 7,610 15,214 30,335 6,433 111 0 2 10,649 152,428 108,934 3,732 28 74 0 89,378 1,338,400 1,390,208 22,837 1,439 186 0 29,393 562 7,589 356 0 208 18 99,050 1,261,711 1,336,157 27,727 1,190 0 0 68,185 104,393 152,748 29,505 6,122 0 0 3,436 875 1,351 461 0 377 0 28,539 151,726 119,194 64,457 12,448 0 0 155,833 38,030 71,305 15,804 3,272 2,611 0 23,441 89,470 103,375 1,107 12 12 09 10 11 12 13 14 15

FB_TP_N_AFB_TP_A_AFB_TP_O_ARB_FP_W_BRB_FP_B_BRB_FP_N_BRB_FP_A_B

31,726 367,494 244,945 54,203 1,430 2,786 0 16,344 165,591 146,617 1,546 0 0 0 45,562 68,855 75,976 25,592 12,297 0 0 2,062 493 379 413 0 7 0 13,254 49,698 62,966 24,579 2,078 0 0 94,300 467,908 1,517,711 63,986 10,488 260 0 10,850 38,648 63,269 4,035 0 0 0 2,435 13,679 27,639 659 0 0 0 45,730 446,387 293,134 16,989 8,481 613 0 38,271 131,468 143,067 5,890 317 393 0 6,286 29,848 14,856 24,882 226 0 0 49,876 337,809 474,906 57,664 9,483 0 0 930 612 3,216 469 0 0 016 17 18 19 20 21

RB_FP_O_BRB_FP_W_ARB_FP_B_ARB_FP_N_ARB_FP_A_ARB_FP_O_A

16,565 7,281,693 282,555 66,771 56,175 97,2600 31 81,893 7,726 1,608 516 7181 2 1 312 3 481 0 104 0 96,015 5,070 1,261 153 1885 2,407 74,531 1,436 1,045 4,217 7,1786 0 64,245 0 0 282 2,8478 530 181,282 4,353 5,424 862 4,0729 0 85,998 1,149 0 88 1,626#N/A 63 254,906 20,167 13,365 2,546 22,99912 907 91,125 24,833 1,992 18 313 15 4,849 860,511 17,233 1,486 7,748 5,37517 2,075 517,222 8,660 605 6,022 2,98818 28 118,000 150 9 275 3,71619 0 69,852 1,410 1,812 850 1,49820 15 259,045 11,244 2,588 5 55321 0 199,874 27,205 3,429 126 3,74022 0 68,857 1,508 161 75 2,11823 0 298,177 16,572 2,913 13,675 1,79824 363 199,205 1,730 10,359 243 2,39925 767 329,977 24,358 0 1,134 2,15426 0 547,456 0 99 213 2227 0 23,709 3,276 1 71 16828 11 112,345 1,157 841 720 92729 0 519 0 4 0 030 0 46,300 140 53 366 1,05431 0 40,968 425 877 3 33333 722 383,532 14,755 611 1,157 9,61834 3 4,113 0 409 1 12635 1,944 465,503 9,900 2,316 2,269 7,73336 1,642 197,742 20,001 5,161 178 3,20937 0 4,479 0 221 0 038 0 576,179 22,955 474 0 3,50639 0 137,434 5,637 3,632 2,230 1,30740 2 12,119 125 203 25 235#N/A16 17 18 19 20 21

RB_FP_O_BRB_FP_W_ARB_FP_B_ARB_FP_N_ARB_FP_A_ARB_FP_O_A

0 631,945 11,928 0 3,438 6,12342 2 15,098 153 905 2 16044 601 168,882 16,103 2,864 632 1,33145 0 2,418 0 8 0 0#N/A 103 116,170 7,688 457 141 9047 0 432,107 5,862 491 4,330 5,80148 0 39,802 0 408 115 813#N/A 0 7,384 82 232 15 6650 168 187,011 20,408 3,751 2,266 22251 403 59,248 935 906 1,924 1,637#N/A 0 101,128 684 133 1 17354 3,292 681,896 19,478 2,095 9,678 3,05655 3 3,213 3 0 8 856