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:

Worksheet Contents

GIS_Output Contains 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-scope 
Variable 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

FIPS FB_TP_W_B FB_TP_B_B FB_TP_N_B FB_TP_A_B FB_TP_O_B FB_TP_W_A FB_TP_B_A

0 33,826,537 11,352,318 509,953 1,715,707 3,442,261 144,053,510 21,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,734 10,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,942 11,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,339 16,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,460 10,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,699
1 2 3 4 5 6 7 8

FIPS FB_TP_W_B FB_TP_B_B FB_TP_N_B FB_TP_A_B FB_TP_O_B FB_TP_W_A FB_TP_B_A

42 3,059,401 812,887 13,175 84,816 125,592 12,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,056 10,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 587
9 10 11 12 13 14 15

FB_TP_N_A FB_TP_A_A FB_TP_O_A RB_FP_W_B RB_FP_B_B RB_FP_N_B RB_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 0
9 10 11 12 13 14 15

FB_TP_N_A FB_TP_A_A FB_TP_O_A RB_FP_W_B RB_FP_B_B RB_FP_N_B RB_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 0
16 17 18 19 20 21

RB_FP_O_B RB_FP_W_A RB_FP_B_A RB_FP_N_A RB_FP_A_A RB_FP_O_A

16,565 7,281,693 282,555 66,771 56,175 97,260 0

31 81,893 7,726 1,608 516 718 1

2

1 312 3 481 0 10 4

0 96,015 5,070 1,261 153 188 5

2,407 74,531 1,436 1,045 4,217 7,178 6

0 64,245 0 0 282 2,847 8

530 181,282 4,353 5,424 862 4,072 9

0 85,998 1,149 0 88 1,626 #N/A

63 254,906 20,167 13,365 2,546 22,999 12

907 91,125 24,833 1,992 18 3 13

15

4,849 860,511 17,233 1,486 7,748 5,375 17

2,075 517,222 8,660 605 6,022 2,988 18

28 118,000 150 9 275 3,716 19

0 69,852 1,410 1,812 850 1,498 20

15 259,045 11,244 2,588 5 553 21

0 199,874 27,205 3,429 126 3,740 22

0 68,857 1,508 161 75 2,118 23

0 298,177 16,572 2,913 13,675 1,798 24

363 199,205 1,730 10,359 243 2,399 25

767 329,977 24,358 0 1,134 2,154 26

0 547,456 0 99 213 22 27

0 23,709 3,276 1 71 168 28

11 112,345 1,157 841 720 927 29

0 519 0 4 0 0 30

0 46,300 140 53 366 1,054 31

0 40,968 425 877 3 333 33

722 383,532 14,755 611 1,157 9,618 34

3 4,113 0 409 1 126 35

1,944 465,503 9,900 2,316 2,269 7,733 36

1,642 197,742 20,001 5,161 178 3,209 37

0 4,479 0 221 0 0 38

0 576,179 22,955 474 0 3,506 39

0 137,434 5,637 3,632 2,230 1,307 40

2 12,119 125 203 25 235 #N/A
16 17 18 19 20 21

RB_FP_O_B RB_FP_W_A RB_FP_B_A RB_FP_N_A RB_FP_A_A RB_FP_O_A

0 631,945 11,928 0 3,438 6,123 42

2 15,098 153 905 2 160 44

601 168,882 16,103 2,864 632 1,331 45

0 2,418 0 8 0 0 #N/A

103 116,170 7,688 457 141 90 47

0 432,107 5,862 491 4,330 5,801 48

0 39,802 0 408 115 813 #N/A

0 7,384 82 232 15 66 50

168 187,011 20,408 3,751 2,266 222 51

403 59,248 935 906 1,924 1,637 #N/A

0 101,128 684 133 1 173 54

3,292 681,896 19,478 2,095 9,678 3,056 55

3 3,213 3 0 8 8 56