Tutorial

Levee Decision Analysis Model Guide to This Workbook 1. LDAM_Island Inputs This worksheet presents the data inputs for the decision analysis on levee repairs and upgrades when both land and assets are included. The worksheet contains the values we used, drawing on source data presented elsewhere in this workbook. You can change numbers such as property value and probability of failure to see how the overall decisions would change for each island. (Results are presented in the next worksheet - "LDAM_Expected Values"). 4. List of Islands Repaired 2. LDAM_Expected Values This worksheet contains the formulas used to generate the expected present costs for repair and upgrade decisions (using the inputs provided in the "LDAM_Island Inputs" worksheet). The repair/no repair decision is calculated under three upgrade scenarios (no upgrade, PL84-99 upgrades, and PL 84-99 + 1 ft SLR upgrades). The upgrade decision is calculated by selecting the lowest cost scenario, based on present costs. Negative values for present costs indicate that the scenario is profitable. These formulas are locked and cannot be manipulated. An explanation of the formulas can be found in Appendix B. 5. Source Data (SD) Guide 3. LDAM_Repair_Cost_Spread This worksheet compares the difference in cost between a decision to repair and a decision to not repair levees after failure under the "no upgrades" and "PL 84-99 upgrades" scenarios. If the difference between the two decisions is less than $50,000, the island is assigned to the "unsure" category in terms of whether it is cost-effective to invest in repairs. . List of Islands Repaired This worksheet lists the repair decisions generated by our analysis, using land values and land plus other asset values, as presented in Appendix B. IMPORTANT: Because this is NOT a formula-generated list, the results shown here will not change if the user modifies the values in the "LDAM_Island Inputs" worksheet. . Source Data (SD) Guide This worksheet serves as a guide to the remaining sheets of source data, which provide information about how our original inputs were calculated. The numbers and formulas are locked, and cannot be manipulated. Island r 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 Property Value $60,164,424 $38,937,542 $18,904,605 $16,943,203 $56,837,848 $10,780,145 $2,191,687 $38,422,394 $20,147,964 $56,130,613 $144,375,498 $42,595,120 $37,226,096 $48,449,544 $1,860,581 $318,651,235 $100,164,068 $47,005,675 $126,068,759 $24,359,255 $550,468,164 $260,065,034 $27,908,593 $228,549,230 $237,435,567 $79,696,787 $129,308,580 $27,148,842 $289,785,177 $24,610,343 $31,886,961 $141,963,167 $23,516,367 $11,970,466 Bk $3,008,221 $1,946,877 $945,230 $847,160 $2,841,892 $539,007 $109,584 $1,921,120 $1,007,398 $2,806,531 $7,218,775 $2,129,756 $1,861,305 $2,422,477 $93,029 $15,932,562 $5,008,203 $2,350,284 $6,303,438 $1,217,963 $27,523,408 $13,003,252 $1,395,430 $11,427,462 $11,871,778 $3,984,839 $6,465,429 $1,357,442 $14,489,259 $1,230,517 $1,594,348 $7,098,158 $1,175,818 $598,523 PL 84-99 Upgrade Cost $40,091,184 $50,319,696 $29,376,592 $40,009,592 $38,356,920 $16,439,920 $19,625,480 $44,111,760 $34,754,720 $25,312,616 $61,445,720 $24,479,336 $31,945,872 $29,176,952 $7,173,152 $4,610,312 $0 $97,665,624 $36,300,768 $15,354,920 $52,161,592 $23,623,488 $28,085,008 $124,031,544 $91,087,584 $42,181,328 $24,961,944 $20,717,424 $86,607,528 $30,591,792 $43,084,048 $54,435,752 $26,517,456 $36,134,840 Bacon Island Bouldin Island Empire Tract Mandeville Island McDonald Tract Medford Island Quimby Island Rindge Tract Venice Island King Island Terminous Tract Wright-Elmwood Tract Brack Tract Canal Ranch Tract Dead Horse Island Grand Island Ryer Island* Staten Island Tyler Island Coney Island Jones Tract Orwood Tract Palm Tract Roberts Island Union Island Victoria Island Woodward Island Bradford Island Brannan-Andrus Island Holland Tract Jersey Island Sherman Island Twitchell Island Webb Tract * Ryer Island has already been upgraded to PL 84-99 standards Materials Cost to Raise the Levee 1' $7,585,353 $9,520,615 $3,970,089 $7,569,915 $7,257,226 $3,110,474 $3,713,190 $8,346,056 $6,575,680 $4,789,210 $11,625,684 $4,631,552 $6,044,239 $5,520,353 $1,357,178 $15,705,759 $10,715,534 $18,478,581 $13,331,354 $2,905,189 $9,869,104 $4,469,623 $5,313,754 $26,433,775 $17,816,743 $7,980,813 $4,722,862 $3,919,789 $21,472,125 $5,788,044 $8,151,610 $10,299,381 $6,288,610 $6,836,802 PL 84-99 + 1 ft SLR Upgrade Cost $47,676,537 $59,840,311 $33,346,681 $47,579,507 $45,614,146 $19,550,394 $23,338,670 $52,457,816 $41,330,400 $30,101,826 $73,071,404 $29,110,888 $37,990,111 $34,697,305 $8,530,330 $20,316,071 $10,715,534 $116,144,205 $49,632,122 $18,260,109 $62,030,696 $28,093,111 $33,398,762 $150,465,319 $108,904,327 $50,162,141 $29,684,806 $24,637,213 $108,079,653 $36,379,836 $51,235,658 $64,735,133 $32,806,066 $42,971,642 Repair Cost $59,648,813 $42,693,179 $30,528,852 $29,628,438 $49,238,517 $29,956,111 $25,471,488 $34,294,391 $30,294,853 $62,863,739 $91,602,821 $27,610,154 $29,089,290 $36,261,928 $25,330,588 $224,957,140 $57,676,859 $33,147,025 $55,636,559 $46,938,233 $110,767,615 $80,922,337 $32,890,606 $41,504,940 $80,642,709 $65,238,632 $36,907,972 $37,013,466 $170,670,237 $33,729,123 $29,136,997 $52,381,659 $35,294,860 $28,359,022 Cost of No Repair $4,930,479 $213,036,975 $2,580,558 $4,920,445 $4,717,197 $2,021,808 $2,413,574 $5,424,936 $4,274,192 $3,112,987 $76,856,695 $3,010,509 $290,128,755 $100,338,229 $882,166 $632,108,744 $138,815,097 $12,011,078 $8,665,380 $1,888,373 $246,264,918 $2,905,255 $124,503,940 $604,431,954 $11,580,883 $204,987,529 $70,569,861 $2,547,863 $534,606,881 $3,762,228 $5,298,546 $297,394,598 $4,087,597 $4,443,922 Annual Pf 0.06 0.09 0.06 0.07 0.05 0.05 0.07 0.03 0.11 0.02 0.05 0.02 0.05 0.06 0.04 0.07 0.05 0.07 0.09 0.04 0.08 0.04 0.08 0.06 0.04 0.06 0.04 0.09 0.08 0.08 0.10 0.07 0.08 0.10 PL 84 99 PL-84-99 + 1' 2000 2000 Pf Pf 0.06 0.08 0.06 0.06 0.05 0.05 0.06 0.03 0.10 0.02 0.05 0.02 0.05 0.06 0.04 0.07 0.05 0.06 0.08 0.04 0.07 0.04 0.07 0.06 0.04 0.06 0.04 0.08 0.08 0.07 0.09 0.07 0.08 0.09 0.05 0.08 0.05 0.06 0.05 0.04 0.06 0.03 0.09 0.02 0.04 0.02 0.04 0.05 0.03 0.07 0.04 0.06 0.08 0.04 0.07 0.04 0.07 0.05 0.04 0.05 0.04 0.08 0.07 0.07 0.09 0.07 0.07 0.09 Repair Decision with No Upgrades Island Cost of Repair Cost of No Repair Repair? (y/n) Repair Decision with PL 84-99 Upgrades Cost of Repair Bacon Island Bouldin Island Empire Tract Mandeville Island McDonald Tract Medford Island Quimby Island Rindge Tract Venice Island King Island Terminous Tract Wright-Elmwood Tract Brack Tract Canal Ranch Tract Dead Horse Island Grand Island Ryer Island* Staten Island Tyler Island Coney Island Jones Tract Orwood Tract Palm Tract Roberts Island Union Island Victoria Island Woodward Island Bradford Island Brannan-Andrus Island Holland Tract Jersey Island Sherman Island Twitchell Island Webb Tract Total for 34 islands $76,678,539 $84,447,573 $49,834,790 $55,466,818 $46,698,005 $49,844,151 $58,588,941 $19,377,561 $78,266,313 $35,676,424 $52,477,120 -$1,018,725 $24,427,489 $36,037,197 $43,749,388 $254,666,254 $25,206,056 $37,335,930 $44,885,632 $61,936,649 -$195,060,235 -$87,711,541 $60,206,518 -$113,050,731 -$71,464,576 $71,348,827 -$51,496,699 $78,754,865 $186,074,727 $65,235,932 $58,770,507 -$401,202 $70,213,276 $73,454,293 $1,279,456,066 $4,930,479 $213,036,975 $2,580,558 $4,920,445 $4,717,197 $2,021,808 $2,413,574 $5,424,936 $4,274,192 $3,112,987 $76,856,695 $3,010,509 $290,128,755 $100,338,229 $882,166 $632,108,744 $138,815,097 $12,011,078 $8,665,380 $1,888,373 $246,264,918 $2,905,255 $124,503,940 $604,431,954 $11,580,883 $204,987,529 $70,569,861 $2,547,863 $534,606,881 $3,762,228 $5,298,546 $297,394,598 $4,087,597 $4,443,922 $3,629,524,149 no yes no no no no no no no no yes yes yes yes no yes yes no no no yes yes yes yes yes yes yes no yes no no yes no no $111,857,412 $129,571,166 $76,743,814 $93,111,504 $83,034,205 $64,490,958 $76,229,329 $62,779,497 $108,814,011 $59,688,768 $106,096,170 $22,871,761 $53,922,074 $62,181,291 $49,412,377 $264,094,360 $18,937,549 $132,246,963 $76,478,961 $75,403,846 -$156,312,873 -$69,789,340 $84,965,781 $7,900,147 $17,828,227 $109,501,349 -$27,376,199 $96,556,100 $262,128,164 $92,436,639 $98,935,077 $51,774,317 $94,651,904 $106,838,167 $2,498,003,476 * Ryer Island has already been upgraded pair Decision with PL 84-99 Upgrades Cost of No Repair Repair? (y/n) Repair Decision with PL 84-99 + 1 ft SLR Upgrades Cost of Repair Cost of No Repair Repair? (y/n) Expected Present Cost of Upgrad No Upgrade $45,021,663 $263,356,671 $31,957,150 $44,930,037 $43,074,117 $18,461,728 $22,039,054 $49,536,696 $39,028,912 $28,425,603 $138,302,415 $27,489,845 $322,074,627 $129,515,181 $8,055,318 $636,719,056 $138,815,097 $109,676,702 $44,966,148 $17,243,293 $298,426,510 $26,528,743 $152,588,948 $728,463,498 $102,668,467 $247,168,857 $95,531,805 $23,265,287 $621,214,409 $34,354,020 $48,382,594 $351,830,350 $30,605,053 $40,578,762 $4,960,296,613 no yes no no no no no no no no yes yes yes yes no yes yes no no no yes yes yes yes yes yes yes no yes no no yes no no $115,021,684 $134,415,289 $78,493,092 $98,553,003 $88,472,783 $65,987,631 $78,155,937 $70,486,711 $111,603,371 $63,307,735 $110,677,851 $26,973,347 $57,760,154 $64,972,072 $49,410,409 $279,800,120 $24,011,428 $148,246,412 $85,573,619 $76,610,085 -$158,516,575 -$70,450,875 $87,286,364 $31,561,323 $34,029,667 $113,856,237 -$23,410,636 $97,851,319 $274,101,607 $95,172,706 $104,459,157 $60,039,488 $99,069,568 $111,199,099 $2,684,781,180 $52,607,016 $272,877,286 $35,927,239 $52,499,952 $50,331,342 $21,572,202 $25,752,244 $57,882,752 $45,604,592 $33,214,813 $149,928,099 $32,121,396 $328,118,867 $135,035,534 $9,412,496 $652,424,815 $149,530,631 $128,155,283 $58,297,502 $20,148,482 $308,295,614 $30,998,366 $157,902,702 $754,897,272 $120,485,210 $255,149,670 $100,254,667 $27,185,075 $642,686,534 $40,142,064 $56,534,204 $362,129,730 $36,893,663 $47,415,564 $5,252,412,880 no yes no no no no no no no no yes yes yes yes no yes yes no no no yes yes yes yes yes yes yes no yes no no yes no no -$23,110,402 $39,807,517 -$6,674,589 -$3,648,339 -$24,716,518 -$4,099,689 $608,683 -$21,229,625 -$2,660,954 -$38,421,099 -$46,344,475 -$30,758,635 -$6,523,106 -$2,647,208 -$585,984 $13,776,553 -$37,479,006 -$11,118,720 -$35,855,466 -$12,178,715 -$333,351,258 -$181,637,130 $25,920,483 -$165,983,132 -$163,979,064 $2,125,356 -$94,870,100 -$7,264,962 $915,232 -$6,411,050 -$6,077,698 -$59,881,019 -$5,810,089 -$577,768 -$1,250,741,978 pected Present Cost of Upgrade Alternatives PL 84-99 PL 84-99 & 1 ft SLR Upgrade and Repair Decisions (Summary) Upgrade Decision Repair Decision $15,815,519 $84,931,110 $22,317,397 $36,035,040 $12,993,241 $12,134,145 $20,165,451 $22,523,470 $31,729,531 -$13,747,742 $7,274,574 -$6,868,150 $22,971,479 $23,496,886 $6,532,197 $23,204,659 -$43,747,512 $85,666,353 -$1,006,104 $2,832,255 -$294,603,895 -$163,714,929 $50,679,745 -$45,032,254 -$74,686,261 $40,277,878 -$70,749,600 $13,132,559 $76,968,668 $23,726,066 $36,565,939 -$7,705,500 $20,451,561 $35,362,666 $5,926,444 $22,275,371 $89,775,233 $25,916,005 $43,291,940 $19,645,592 $15,048,097 $23,812,709 $30,539,015 $37,948,421 -$9,549,774 $11,856,256 -$2,766,563 $26,809,560 $26,287,667 $7,836,579 $38,910,418 -$38,673,634 $103,300,008 $10,946,869 $5,414,466 -$296,807,597 -$164,376,464 $53,000,328 -$21,371,078 -$58,484,821 $44,632,765 -$66,784,037 $16,748,539 $88,942,111 $29,073,289 $44,295,345 $559,671 $26,499,818 $42,013,100 $226,565,203 No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade No Upgrade no yes no no no no no no no no yes yes yes yes no yes yes no no no yes yes yes yes yes yes yes no yes no no yes no no Repair Decision with No Upgrades Island Cost of Repair Cost of No Repair Spread Confidence in Decision Cost of No Repair Repair Decisio Bacon Island Bouldin Island Empire Tract Mandeville Island McDonald Tract Medford Island Quimby Island Rindge Tract Venice Island King Island Terminous Tract Wright-Elmwood Tract Brack Tract Canal Ranch Tract Dead Horse Island Grand Island Ryer Island Staten Island Tyler Island Coney Island Jones Tract Orwood Tract Palm Tract Roberts Island Union Island Victoria Island Woodward Island Bradford Island Brannan-Andrus Island Holland Tract Jersey Island Sherman Island Twitchell Island Webb Tract $76,678,539 $84,447,573 $49,834,790 $55,466,818 $46,698,005 $49,844,151 $58,588,941 $19,377,561 $78,266,313 $35,676,424 $52,477,120 -$1,018,725 $24,427,489 $36,037,197 $43,749,388 $254,666,254 $25,206,056 $37,335,930 $44,885,632 $61,936,649 -$195,060,235 -$87,711,541 $60,206,518 -$113,050,731 -$71,464,576 $71,348,827 -$51,496,699 $78,754,865 $186,074,727 $65,235,932 $58,770,507 -$401,202 $70,213,276 $73,454,293 $4,930,479 $213,036,975 $2,580,558 $4,920,445 $4,717,197 $2,021,808 $2,413,574 $5,424,936 $4,274,192 $3,112,987 $76,856,695 $3,010,509 $290,128,755 $100,338,229 $882,166 $632,108,744 $138,815,097 $12,011,078 $8,665,380 $1,888,373 $246,264,918 $2,905,255 $124,503,940 $604,431,954 $11,580,883 $204,987,529 $70,569,861 $2,547,863 $534,606,881 $3,762,228 $5,298,546 $297,394,598 $4,087,597 $4,443,922 $71,748,060 $128,589,402 $47,254,232 $50,546,373 $41,980,809 $47,822,343 $56,175,367 $13,952,625 $73,992,121 $32,563,437 $24,379,574 $4,029,234 $265,701,267 $64,301,032 $42,867,222 $377,442,489 $113,609,041 $25,324,852 $36,220,252 $60,048,276 $441,325,153 $90,616,796 $64,297,422 $717,482,685 $83,045,459 $133,638,702 $122,066,560 $76,207,003 $348,532,154 $61,473,703 $53,471,960 $297,795,800 $66,125,680 $69,010,372 unsure unsure unsure unsure unsure unsure unsure unsure unsure unsure $111,857,412 $129,571,166 $76,743,814 $93,111,504 $83,034,205 $64,490,958 $76,229,329 $62,779,497 $108,814,011 $59,688,768 $106,096,170 $22,871,761 $53,922,074 $62,181,291 $49,412,377 $264,094,360 $18,937,549 $132,246,963 $76,478,961 $75,403,846 -$156,312,873 -$69,789,340 $84,965,781 $7,900,147 $17,828,227 $109,501,349 -$27,376,199 $96,556,100 $262,128,164 $92,436,639 $98,935,077 $51,774,317 $94,651,904 $106,838,167 Repair Decision with PL 84-99 Upgrades Cost of No Repair Spread Confidence in Decision $45,021,663 $263,356,671 $31,957,150 $44,930,037 $43,074,117 $18,461,728 $22,039,054 $49,536,696 $39,028,912 $28,425,603 $138,302,415 $27,489,845 $322,074,627 $129,515,181 $8,055,318 $636,719,056 $138,815,097 $109,676,702 $44,966,148 $17,243,293 $298,426,510 $26,528,743 $152,588,948 $728,463,498 $102,668,467 $247,168,857 $95,531,805 $23,265,287 $621,214,409 $34,354,020 $48,382,594 $351,830,350 $30,605,053 $40,578,762 $66,835,749 $133,785,504 $44,786,664 $48,181,467 $39,960,089 $46,029,230 $54,190,276 $13,242,801 $69,785,099 $31,263,165 $32,206,245 $4,618,084 $268,152,554 $67,333,890 $41,357,059 $372,624,695 $119,877,548 $22,570,261 $31,512,812 $58,160,553 $454,739,382 $96,318,083 $67,623,168 $720,563,350 $84,840,241 $137,667,508 $122,908,003 $73,290,814 $359,086,245 $58,082,618 $50,552,483 $300,056,033 $64,046,851 $66,259,405 unsure unsure unsure unsure unsure unsure unsure unsure unsure unsure unsure Islands repaired, land values only Repair Bouldin Island Brack Tract Grand Island Ryer Island Roberts Island Victoria Island Brannan-Andrus Island Sherman Island Do Not Repair Bacon Island Empire Tract Mandeville Island McDonald Tract Medford Island Quimby Island Venice Island King Island Terminous Tract Tyler Island Coney Island Orwood Tract Union Island Bradford Island Holland Tract Jersey Island Twitchell Island Webb Tract Unsure Rindge Tract Wright-Elmwood Tract Canal Ranch Tract Dead Horse Island Staten Island Jones Tract Palm Tract Woodward Island Islands repaired, including land and asset values Repair Bouldin Island Brack Tract Canal Ranch Tract Grand Island Ryer Island Jones Tract Orwood Tract Palm Tract Roberts Island Union Island Victoria Island Woodward Island Brannan-Andrus Island Sherman Island Do Not Repair Bacon Island Mandeville Island Quimby Island Venice Island Coney Island Bradford Island Holland Tract Jersey Island Twitchell Island Webb Tract Unsure Empire Tract McDonald Tract Medford Island Rindge Tract King Island Terminous Tract Wright-Elmwood Tract Dead Horse Island Staten Island Tyler Island Guide to Source Data Worksheets Data Category Worksheet Name Source Land Uses and Values Land and Asset Values Levee Repair Costs and PL 84-99 Upgrade Costs Cost of 1 ft Extra Levee Height for SLR, Assumptions and Values SD_LUE SD_LAV Lund et. al 2007, Appendix D Lund et. al 2007 and DRMS Draft Phase 1 (J.R. Benjamin and Associates, 2007) Communications with Delta levee engineers, and recorded costs for Twitchell, Sherman, and Bouldin SD_RC_PL SD_1FtSLR Communications with Delta levee engineers Road and Rail Lengths Costs of No Repair When Delta Islands Fail Annual Probabilities of Levee Failure SD_RR GIS Tele Atlas' StreetMap Premium Data Road and Rail Lengths (from SD_RR), Communications with Delta engineers DRMS Draft Phase 1 and Draft Phase 2 (J.R. Benjamin and Associates, 2007) SD_NR (1-3) SD_PF Land Usage and Assigned Values (Lund, et. al, 2007, Appendix B, using land use data from Department of Water Resources surveys) Value Table for Different Land Types Land Type Value/acre urban high-value agriculture low-value agriculture native vegetation Land Usage (acres): $50,000 $4,500 $2,250 $1,000 Urban Bacon Island Bethel Tract Bouldin Island Brack Tract Bradford Island Brannan-Andrus Island Canal Ranch Coney Island Deadhorse Island Empire Tract Grand Island Holland Tract Hotchkiss Tract Jersey Island Jones Tract King Island Mandeville Island McDonald Tract Medford Island Orwood Tract Palm Tract Quimby Island Rindge Tract Roberts Island Ryer Island Sherman Island Staten Island Terminous Tract Twitchell Island Tyler Island Pasture Alfalfa Field Crops Sugar Beets 37.8 642.9 7.8 147.0 53.2 744.4 162.5 6.8 0.0 2.7 416.9 17.0 318.3 9.6 128.4 37.6 19.5 60.9 5.0 49.8 5.3 0.0 25.1 1297.2 107.6 115.1 26.8 401.5 27.6 211.0 0.0 88.8 0.0 104.9 582.4 183.2 60.0 0.0 0.0 0.0 56.2 231.1 1594.3 2614.1 0.0 0.0 68.7 454.0 0.0 0.0 148.4 0.0 0.0 136.3 0.0 3429.5 0.0 353.3 503.7 8.9 0.0 0.0 0.0 616.5 0.0 403.1 376.2 504.3 0.0 0.0 1804.3 0.0 0.0 0.0 802.8 0.0 0.0 0.0 0.0 216.8 209.3 0.0 0.0 8304.7 865.7 34.9 0.0 1092.7 0.0 181.4 3147.9 0.0 3519.5 2566.9 41.6 8600.6 1474.6 233.7 0.0 2241.2 7791.2 1528.1 0.0 0.0 4332.9 889.2 2251.6 985.2 621.1 1306.6 1280.0 621.1 4508.7 9359.6 3621.6 3791.0 4565.6 5546.6 1978.4 3682.0 0.0 0.0 0.0 62.0 0.0 0.0 655.6 0.0 0.0 0.0 368.3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 563.6 0.0 0.0 245.9 0.0 230.6 Union Island Venice Island Victoria Island Webb Tract Woodward Island Wright-Elmwood Tract 187.5 7.1 39.4 6.4 4.9 407.4 262.1 0.0 0.0 0.0 0.0 0.0 7658.1 0.0 1038.4 0.0 0.0 0.0 6990.1 2695.9 2832.2 2772.3 1249.1 511.1 1310.5 0.0 0.0 0.0 0.0 214.5 Grain Rice Truck Tomato Orchards Vineyards Native Riparian 851.9 0.0 1831.0 1072.4 0.0 1727.2 506.9 166.7 0.0 666.3 2166.9 1252.8 0.0 0.0 1627.4 719.8 1083.0 1104.8 0.0 0.0 371.9 0.0 321.1 5131.7 3195.4 1575.3 1854.5 2092.0 731.2 1799.5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 13.4 0.0 0.0 0.0 1097.1 0.0 0.0 0.0 0.0 761.2 0.0 0.0 0.0 489.9 206.5 0.0 0.0 0.0 4468.0 1134.7 6.0 2381.5 0.0 632.9 0.0 0.0 1677.7 5623.2 0.0 6.4 554.2 973.9 0.0 861.6 0.0 0.0 0.0 306.1 0.0 0.0 1396.3 0.0 187.5 0.0 955.8 0.0 0.0 0.0 0.0 292.3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 3175.5 2125.6 0.0 1716.8 684.1 0.0 536.1 0.0 0.0 0.0 5.5 0.0 785.9 0.0 0.0 0.0 0.0 2286.0 0.0 0.0 0.0 0.0 4.7 0.0 12.4 0.0 0.0 0.0 0.0 0.0 267.8 462.0 0.0 0.0 0.0 15.0 284.5 0.0 0.0 0.0 878.5 0.0 676.4 1367.3 0.0 0.0 0.0 39.8 0.0 0.0 0.0 0.0 0.0 369.3 8.4 0.0 0.0 0.0 0.0 0.0 1087.4 619.9 2.5 0.0 380.5 0.0 62.3 0.0 51.4 25.1 0.0 109.4 222.4 51.4 0.0 0.0 53.7 41.9 88.6 26.3 19.0 1.2 0.0 204.5 114.4 425.5 0.0 43.5 12.4 0.0 67.2 37.3 219.7 0.0 152.0 61.0 41.9 1795.8 0.0 716.5 1919.2 132.6 656.5 0.0 0.0 0.0 0.0 0.0 0.0 2669.0 6.3 2206.1 0.0 239.8 144.9 2970.3 0.0 0.0 0.0 0.0 390.3 481.8 0.0 0.0 0.0 0.0 0.0 492.0 0.0 0.0 0.0 0.0 0.0 52.6 9.8 0.0 129.7 0.0 8.1 Land value ($) Water Surface Nonirrigated Grain Native Vegetation "Z" & "Blank" Crops Total Acreage High Value Agricutlure Low Value Agriculture Urban 74.5 42.6 101.5 52.1 69.9 285.5 41.0 2.6 14.4 45.3 183.1 67.4 65.1 61.7 231.4 36.4 92.1 180.1 25.8 27.8 31.0 26.3 120.5 385.2 279.0 243.0 191.2 202.1 100.0 160.5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 423.4 2718.1 586.8 550.0 1347.5 1170.5 166.8 62.8 18.7 179.7 670.1 1105.6 1355.0 890.1 753.8 138.9 1206.2 899.7 147.8 126.1 518.5 155.8 234.7 1201.5 262.7 1138.1 373.6 580.1 285.2 1477.5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.0 0.0 5632.6 3543.7 6071.7 6361.9 2204.0 15560.3 6258.6 976.9 220.7 3678.7 16987.1 4290.5 3359.2 3594.6 12345.8 3253.7 5300.9 6201.3 1225.3 2360.0 2607.8 815.6 6887.8 36341.3 12140.5 10555.5 9296.1 12704.8 3702.2 9538.0 1,888,357 32,144,535 390,017 7,348,271 2,657,836 37,218,129 8,123,317 339,917 0 134,860 20,843,875 852,315 15,913,449 482,103 6,418,243 1,879,434 974,257 3,043,427 250,367 2,491,364 262,918 0 1,254,922 64,860,371 5,382,487 5,756,462 1,341,241 20,076,496 1,379,475 10,552,487 8,999,643 199,842 12,038,592 9,951,294 1,404,009 24,556,791 6,915,136 2,035,559 0 6,542,024 27,420,859 6,776,893 3,587,117 5,881,734 15,216,946 3,620,157 7,657,413 5,724,026 1,397,481 3,427,739 4,521,722 1,397,476 10,866,950 52,281,474 18,554,134 19,869,073 14,475,481 20,993,595 7,229,988 13,280,809 4,937,063 0 0 5,355,541 0 10,005,357 12,435,937 0 843,842 2,204,365 15,696,491 0 0 0 20,105,971 6,443,077 1,688,878 10,810,391 0 2,847,852 0 0 7,549,846 45,692,621 14,433,488 39,876 10,219,397 9,173,241 67,641 7,850,069 414.2 181.2 46.4 154.8 51.0 121.4 0.0 0.0 0.0 0.0 0.0 0.0 948.4 381.6 399.7 546.6 206.6 270.2 0.0 0.0 0.0 0.0 0.0 0.0 26232.4 3281.9 7278.8 5529.0 1883.9 2724.4 9,375,290 354,424 1,970,376 322,283 243,001 20,369,439 40,537,336 6,065,748 10,321,042 10,555,929 3,108,969 3,109,863 29,758,970 28,374 9,927,642 0 1,079,054 2,408,579 Native Vegetation Total Value ($) 423,360 16,248,424 2,769,426 35,113,803 611,933 13,040,542 549,990 23,205,096 1,456,997 5,518,842 1,392,900 73,173,177 218,154 27,692,544 62,779 2,438,255 18,740 862,581 233,357 9,114,605 712,010 64,673,235 1,194,135 8,823,343 1,381,337 20,881,903 909,124 7,272,961 755,003 42,496,164 138,945 12,081,613 1,410,656 11,731,203 1,014,005 20,591,848 573,297 2,221,145 126,079 8,893,034 561,953 5,346,593 168,211 1,565,687 234,676 19,906,394 1,268,764 164,103,230 299,959 38,670,068 1,357,755 27,023,167 373,558 26,409,675 732,166 50,975,498 346,263 9,023,367 1,519,394 33,202,759 1,000,972 391,417 399,727 676,254 206,556 278,239 80,672,567 6,839,964 22,618,787 11,554,466 4,637,580 26,166,120 Land and Asset Values Land Value (Lund et al, 2007) Island Name Bacon Island Bouldin Island Empire Tract Mandeville Island McDonald Tract Medford Island Quimby Island Rindge Tract Venice Island King Island Terminous Tract Wright-Elmwood Tract Brack Tract Canal Ranch Tract Dead Horse Island Grand Island Ryer Island Staten Island Tyler Island Coney Island Jones Tract Orwood Tract Palm Tract Roberts Island Union Island Victoria Island Woodward Island Bethel Tract Bradford Island Brannan-Andrus Island Holland Tract Hotchkiss Tract Jersey Island Sherman Island Twitchell Island Webb Tract $16,248,424 $13,040,542 $9,114,605 $11,731,203 $20,591,848 $2,221,145 $1,565,687 $19,906,394 $6,839,964 $12,081,613 $50,975,498 $26,166,120 $23,205,096 $27,692,544 $862,581 $64,673,235 $38,670,068 $26,409,675 $33,202,759 $2,438,255 $42,496,164 $8,893,034 $5,346,593 $164,103,230 $80,672,567 $22,618,787 $4,637,580 $35,113,803 $5,518,842 $73,173,177 $8,823,343 $20,881,903 $7,272,961 $27,023,167 $9,023,367 $11,554,466 Asset Value (J.R. Benjamin & Associates, 2007) $43,916,000 $25,897,000 $9,790,000 $5,212,000 $36,246,000 $8,559,000 $626,000 $18,516,000 $13,308,000 $44,049,000 $93,400,000 $16,429,000 $14,021,000 $20,757,000 $998,000 $253,978,000 $61,494,000 $20,596,000 $92,866,000 $21,921,000 $507,972,000 $251,172,000 $22,562,000 $64,446,000 $156,763,000 $57,078,000 $124,671,000 $254,118,000 $21,630,000 $216,612,000 $15,787,000 $128,181,000 $24,614,000 $114,940,000 $14,493,000 $416,000 Land + Asset Values $60,164,424 $38,937,542 $18,904,605 $16,943,203 $56,837,848 $10,780,145 $2,191,687 $38,422,394 $20,147,964 $56,130,613 $144,375,498 $42,595,120 $37,226,096 $48,449,544 $1,860,581 $318,651,235 $100,164,068 $47,005,675 $126,068,759 $24,359,255 $550,468,164 $260,065,034 $27,908,593 $228,549,230 $237,435,567 $79,696,787 $129,308,580 $289,231,803 $27,148,842 $289,785,177 $24,610,343 $149,062,903 $31,886,961 $141,963,167 $23,516,367 $11,970,466 Levee Repair and PL 84-99 Upgrade Costs Zone Central Central Central Central Central Central Central Central Central Eastern Eastern Eastern Northern Northern Northern Northern Northern Northern Northern Southern Southern Southern Southern Southern Southern Southern Southern Western Western Western Western Western Western Western Western Western Total Island name Bacon Island Bouldin Island Empire Tract Mandeville Island McDonald Tract Medford Island Quimby Island Rindge Tract Venice Island King Island Terminous Tract Wright-Elmwood Tract Brack Tract Canal Ranch Tract Dead Horse Island Grand Island Ryer Island Staten Island Tyler Island Coney Island Jones Tract Orwood Tract Palm Tract Roberts Island Union Island Victoria Island Woodward Island Bethel Tract Bradford Island Brannan-Andrus Island Holland Tract Hotchkiss Tract Jersey Island Sherman Island Twitchell Island Webb Tract Elevation in 2000 (m Levee Length Area Volume msl) (m) (m^2) (m^3) -4.82 23,094 22,820,772 109,996,122 -5.09 28,986 24,600,090 125,266,120 -5.13 16,922 14,894,662 76,338,123 -5.36 23,047 21,470,227 115,071,826 -4.65 22,095 25,115,537 116,769,666 -2.45 9,470 4,960,941 12,136,942 -2.22 11,305 3,304,082 7,345,966 -4.38 25,410 27,903,064 122,340,983 -4.29 20,020 13,288,295 56,957,619 -2.38 14,581 13,172,792 31,320,946 -1.52 35,395 51,439,035 78,315,930 -2.10 14,101 11,035,876 23,190,789 -1.41 18,402 25,784,836 36,480,387 -0.97 16,807 25,341,752 24,540,952 -2.06 4,132 899,779 1,857,233 -0.98 47,817 68,775,422 67,331,139 -1.88 32,624 49,140,461 92,403,722 -3.29 56,259 37,634,620 123,817,898 -2.61 40,588 38,620,444 100,826,393 -0.16 8,845 3,955,484 625,758 -3.26 30,047 49,983,648 163,111,638 -2.52 13,608 9,556,957 24,128,449 -3.08 16,178 10,559,468 32,548,504 -0.73 80,479 147,209,168 107,889,599 -0.27 54,244 106,242,276 28,164,827 -3.16 24,298 29,475,222 93,215,390 -3.27 14,379 7,628,998 24,966,660 -1.99 18,456 14,349,714 28,623,374 -2.24 11,934 8,924,908 19,955,203 -2.81 65,373 63,004,232 176,922,184 -3.73 17,622 17,377,522 64,736,484 -0.94 18,702 13,604,706 12,845,564 -2.34 24,818 14,556,280 34,029,670 -3.73 31,357 42,743,906 159,537,354 -3.17 19,146 14,988,214 47,538,118 -5.15 20,815 22,398,376 115,322,520 931,356 1,056,761,765 2,456,470,053 *Assumes $2.8m/mi for PL 84-99 upgrade Pl-84-99 Upgrade based on Bouldin Island example: 30 yards/ft total fill 5$/yd on-island, $15/yd off island fill source 20%/yd engineering $15/ft riprap **Assumes $25m to repair breach and, scaled to Jones tract failure total of $80M repairs and costs, counting breach, for $.3 PL 84-99 Upgrade* $40,091,184 $50,319,696 $29,376,592 $40,009,592 $38,356,920 $16,439,920 $19,625,480 $44,111,760 $34,754,720 $25,312,616 $61,445,720 $24,479,336 $31,945,872 $29,176,952 $7,173,152 $83,010,312 $56,635,264 $97,665,624 $70,460,768 $15,354,920 $52,161,592 $23,623,488 $28,085,008 $139,711,544 $94,167,584 $42,181,328 $24,961,944 $32,039,616 $20,717,424 $113,487,528 $30,591,792 $32,466,672 $43,084,048 $54,435,752 $33,237,456 $36,134,840 $1,616,834,016 **Single Breach Repair/Damage Costs $62,398,682 $67,590,481 $50,954,962 $64,124,421 $64,701,686 $29,126,560 $27,497,629 $66,595,934 $44,365,590 $35,649,122 $51,627,416 $32,884,868 $37,403,331 $33,343,924 $25,631,459 $47,892,587 $56,417,266 $67,098,085 $59,280,973 $25,212,758 $80,457,957 $33,203,673 $36,066,491 $61,682,464 $34,576,041 $56,693,233 $33,488,664 $34,731,947 $31,784,769 $85,153,542 $47,010,405 $29,367,492 $36,570,088 $79,242,700 $41,162,960 $64,209,657 $1,735,199,818 osts, counting breach, for $.34/m^3 Materials and Cost of 1 ft SLR Assumptions and Formulas: 1. All levees were given an initial height of 25 feet, which is an average value for levee heights in the Delta. Data are currently lacking to calculate the actual heights of levees on individual islands. 2. The amount of fill needed for a cross section of levee with given height was calculated using the following formula: f(x) = h^2 + 21h + 3/4*h^2 + 3/8*h^2 + 10/8*h^2 3. This is a simplified geometric formula obtained by assuming the following: (1) a crown width of 21 feet; (2) a 2:1 slope on the backside (or water side); (3) a 3:1 slope on the land side until an elevation equal to 1/2 the total height of the levee, and from that point on a 10:1 slope to the existing ground (10:1 slope being the slope of the toe berm). 3. The amount of additional fill needed for unit increases in height was calculated by taking the amount of cross-sectional fill needed to build a levee of that height (formula shown above), multiplying by the length of the levee, dividing by 27 to get cubic yards, and finally subtracting the original amount of fill needed to build a levee of height = 25 feet. 4. A one-to-one relationship was assumed in terms of amount of sea level rise in relation to needed levee height. 5. Costs were calculated based upon the following assumptions: (1) one cubic yard of fill = 1.4 cut yards; (2) one cut yard costs a minimum of $5.00 for on-island sourcing, $15 for off-island, yielding an average minimum cost of $10.00 per cut yard (this also assumes that fill is obtained from on-island borrowing approximately 50% of the time); (3) total costs = 10 * amt of cut yrds. 6. Island Value includes land and asset values (see SD_LAV) Values: Island Bacon Island Bouldin Island Empire Tract Mandeville Island McDonald Tract Medford Island Quimby Island Rindge Tract Venice Island King Island Terminous Tract Wright-Elmwood Tract Brack Tract Canal Ranch Tract Dead Horse Island Grand Island Ryer Island Staten Island Tyler Island Coney Island Jones Tract Orwood Tract Palm Tract Roberts Island Union Island Victoria Island Woodward Island Bethel Tract Bradford Island Brannan-Andrus Island Holland Tract Hotchkiss Tract Jersey Island Sherman Island Twitchell Island Webb Tract Materials Cost to Raise the Levee 1' $7,585,353 $9,520,615 $3,970,089 $7,569,915 $7,257,226 $3,110,474 $3,713,190 $8,346,056 $6,575,680 $4,789,210 $11,625,684 $4,631,552 $6,044,239 $5,520,353 $1,357,178 $15,705,759 $10,715,534 $18,478,581 $13,331,354 $2,905,189 $9,869,104 $4,469,623 $5,313,754 $26,433,775 $17,816,743 $7,980,813 $4,722,862 $6,061,976 $3,919,789 $21,472,125 $5,788,044 $6,142,776 $8,151,610 $10,299,381 $6,288,610 $6,836,802 Lengths of Road and Rail on Interior of Delta Islands (Length of road and/or rail on levees not included) Island Name Highway 4 Highway 12 Highway 160 Other Highway Total Highway Bishop Bouldin Brack Brannan-Andrus Byron Canal Ranch Grand Jones Lisbon Netherlands New Hope Ranch Palm Pierson Rio Blanco Roberts Rough and Ready Ryer Sargent Barnhart Sherman Shima Shin Kee Stewart Sutter Terminous Tyler Veale Victoria Walnut Grove Woodward 0.00 0.00 0.00 0.00 4.85 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6.46 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 13.57 4.44 0.00 0.00 0.00 4.60 6.36 5.73 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5.84 0.00 0.00 13.82 0.00 0.00 0.00 0.00 0.00 1.89 0.00 0.00 0.00 0.00 0.00 6.46 0.00 0.00 0.00 1.80 0.00 0.00 0.00 0.00 0.00 0.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2.76 0.00 0.00 1.00 0.00 0.00 0.00 5.06 0.00 2.79 2.00 3.71 0.00 1.54 0.00 0.26 0.00 0.00 0.00 2.00 4.60 6.36 11.57 4.85 0.00 13.82 0.00 0.00 0.00 2.76 0.00 1.89 1.00 6.46 0.00 0.00 5.06 6.46 2.79 2.00 3.71 1.80 1.54 0.00 13.83 4.44 0.00 0.00 Total Rail 0.00 0.00 0.00 0.00 6.31 2.15 0.00 5.33 3.08 7.48 5.08 2.69 0.00 0.00 6.59 7.44 2.93 0.00 0.00 0.00 0.00 3.11 0.00 0.00 7.96 13.43 0.00 1.45 1.50 No Repair Costs 1: Costs of Upgrades to Nearby Islands Cost to Raise Levee 1 Cost to Build up ft Surrounding Islands $7,585,353 $4,930,479 $9,520,615 $6,188,400 $3,970,089 $2,580,558 $7,569,915 $4,920,445 $7,257,226 $4,717,197 $3,110,474 $2,021,808 $3,713,190 $2,413,574 $8,346,056 $5,424,936 $6,575,680 $4,274,192 $4,789,210 $3,112,987 $11,625,684 $7,556,695 $4,631,552 $3,010,509 $6,044,239 $3,928,755 $5,520,353 $3,588,229 $1,357,178 $882,166 $15,705,759 $10,208,744 $10,715,534 $6,965,097 $18,478,581 $12,011,078 $13,331,354 $8,665,380 $2,905,189 $1,888,373 $9,869,104 $6,414,918 $4,469,623 $2,905,255 $5,313,754 $3,453,940 $26,433,775 $17,181,954 $17,816,743 $11,580,883 $7,980,813 $5,187,529 $4,722,862 $3,069,861 $6,061,976 $3,940,284 $3,919,789 $2,547,863 $21,472,125 $13,956,881 $5,788,044 $3,762,228 $6,142,776 $3,992,804 $8,151,610 $5,298,546 $10,299,381 $6,694,598 $6,288,610 $4,087,597 $6,836,802 $4,443,922 Island Bacon Island Bouldin Island Empire Tract Mandeville Island McDonald Tract Medford Island Quimby Island Rindge Tract Venice Island King Island Terminous Tract Wright-Elmwood Tract Brack Tract Canal Ranch Tract Dead Horse Island Grand Island Ryer Island Staten Island Tyler Island Coney Island Jones Tract Orwood Tract Palm Tract Roberts Island Union Island Victoria Island Woodward Island Bethel Tract Bradford Island Brannan-Andrus Island Holland Tract Hotchkiss Tract Jersey Island Sherman Island Twitchell Island Webb Tract Assumptions 1. If an island fails permanently, surro pressure from wind and waves, which 2. The (very) approximate length of le islands should be equal to roughly ha (geometrically). 3. The surrounding levees will need to increased exposure 4. Cost of these upgrades should thus raising the levee of the failed island b "Levee_Rise_Costs1" * 1.3 5. The multiplier of 1.3 accounts for 2 management and 10% state costs. 1. If an island fails permanently, surrounding islands are then exposed to increased pressure from wind and waves, which must be mitigated. 2. The (very) approximate length of levee upgrades needed to these surrounding islands should be equal to roughly half the circumference of the failed island (geometrically). 3. The surrounding levees will need to be raised 1 foot in order to account for this increased exposure 4. Cost of these upgrades should thus be equal to HALF the cost of materials for raising the levee of the failed island by one foot (obtained from spreadsheet titled "Levee_Rise_Costs1" * 1.3 5. The multiplier of 1.3 accounts for 20% cost for engineers and construction management and 10% state costs. No Repair Costs 2: Infrastructure Replacement Costs Miles of Railroad 0 0 0 0 0 0 0 0 0 0 0 0 0 2.15 0 0 2.93 0 0 0 5.33 0 2.69 6.59 0 0 1.5 0 0 0 0 0 0 0 0 0 Miles of Highway 0 4.60 0 0 0 0 0 0 0 0 1.54 0 6.36 0 0 13.82 0 0 0 0 0 0 0 6.46 0 4.44 0 0 0 11.57 0 0 0 6.46 0 0 Total Cost to Replace $0 $206,848,575 $0 $0 $0 $0 $0 $0 $0 $0 $69,300,000 $0 $286,200,000 $96,750,000 $0 $621,900,000 $131,850,000 $0 $0 $0 $239,850,000 $0 $121,050,000 $587,250,000 $0 $199,800,000 $67,500,000 $0 $0 $520,650,000 $0 $0 $0 $290,700,000 $0 $0 Assumptions Island Bacon Island Bouldin Island Empire Tract Mandeville Island McDonald Tract Medford Island Quimby Island Rindge Tract Venice Island King Island Terminous Tract Wright-Elmwood Tract Brack Tract Canal Ranch Tract Dead Horse Island Grand Island Ryer Island Staten Island Tyler Island Coney Island Jones Tract Orwood Tract Palm Tract Roberts Island Union Island Victoria Island Woodward Island Bethel Tract Bradford Island Brannan-Andrus Island Holland Tract Hotchkiss Tract Jersey Island Sherman Island Twitchell Island Webb Tract 1. Cost calculations are based on a simpl obtained from DRMS Preliminary Strateg Armored Infrastructure Corridor Cost Es Associates, 2007), of 45 million dollars p levee. We assumed that these levees w build the roads or highways on top of th 2. These costs are conservative in that th the actual cost of the road or rails thems . Cost calculations are based on a simple, per mile estimated cost btained from DRMS Preliminary Strategies Report Section 12 rmored Infrastructure Corridor Cost Estimates (J.R. Benjamin and ssociates, 2007), of 45 million dollars per mile of seismically resistant vee. We assumed that these levees would have to be put in place to uild the roads or highways on top of them. . These costs are conservative in that they do not take into account he actual cost of the road or rails themselves. No Repair Costs 3: Total Costs of a Flooded Island Total Cost of Not Repairing a Flooded Island $4,930,479 $213,036,975 $2,580,558 $4,920,445 $4,717,197 $2,021,808 $2,413,574 $5,424,936 $4,274,192 $3,112,987 $76,856,695 $3,010,509 $290,128,755 $100,338,229 $882,166 $632,108,744 $138,815,097 $12,011,078 $8,665,380 $1,888,373 $246,264,918 $2,905,255 $124,503,940 $604,431,954 $11,580,883 $204,987,529 $70,569,861 $3,940,284 $2,547,863 $534,606,881 $3,762,228 $3,992,804 $5,298,546 $297,394,598 $4,087,597 $4,443,922 Island Bacon Island Bouldin Island Empire Tract Mandeville Island McDonald Tract Medford Island Quimby Island Rindge Tract Venice Island King Island Terminous Tract Wright-Elmwood Tract Brack Tract Canal Ranch Tract Dead Horse Island Grand Island Ryer Island Staten Island Tyler Island Coney Island Jones Tract Orwood Tract Palm Tract Roberts Island Union Island Victoria Island Woodward Island Bethel Tract Bradford Island Brannan-Andrus Island Holland Tract Hotchkiss Tract Jersey Island Sherman Island Twitchell Island Webb Tract Cost of Road and Cost of Surrounding Rail Upgrades $0 $4,930,479 $206,848,575 $6,188,400 $0 $2,580,558 $0 $4,920,445 $0 $4,717,197 $0 $2,021,808 $0 $2,413,574 $0 $5,424,936 $0 $4,274,192 $0 $3,112,987 $69,300,000 $7,556,695 $0 $3,010,509 $286,200,000 $3,928,755 $96,750,000 $3,588,229 $0 $882,166 $621,900,000 $10,208,744 $131,850,000 $6,965,097 $0 $12,011,078 $0 $8,665,380 $0 $1,888,373 $239,850,000 $6,414,918 $0 $2,905,255 $121,050,000 $3,453,940 $587,250,000 $17,181,954 $0 $11,580,883 $199,800,000 $5,187,529 $67,500,000 $3,069,861 $0 $3,940,284 $0 $2,547,863 $520,650,000 $13,956,881 $0 $3,762,228 $0 $3,992,804 $0 $5,298,546 $290,700,000 $6,694,598 $0 $4,087,597 $0 $4,443,922 Assumptions This cost of no repair is based u 1. An estimated cost of replaci infrastructure (SD_NR2) 2. An estimated cost of strengt islands (SD_NR1) These two factors are assumed to elements. his cost of no repair is based upon: . An estimated cost of replacing lost transportation frastructure (SD_NR2) An estimated cost of strengthening surrounding lands (SD_NR1) hese two factors are assumed to be the most significant cost ements. Annual Probabilities of Levee Failures Island Name* Staten Island Brannan-Andrus Island Bouldin Island Mandeville Island Sherman Island Rindge Tract Bacon Island Webb Tract Tyler Island McDonald Tract Jones Tract Empire Tract Venice Island Victoria Island Holland Tract Ryer Island Twitchell Island Roberts Island Jersey Island Terminous Tract Palm Tract Woodward Island Grand Island Bethel Tract King Island Orwood Tract Wright-Elmwood Tract Bradford Island Brack Tract Quimby Island Medford Island Hotchkiss Tract Canal Ranch Tract Union Island Dead Horse Island Coney Island Average Value Annual Pf 0.07 0.07 0.05 0.05 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.03 0.03 0.03 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.00 0.00 0.03 PL-84-99 2000 Pf 0.06 0.06 0.05 0.04 0.04 0.04 0.04 0.04 0.04 0.03 0.03 0.03 0.03 0.03 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.00 0.00 0.01 0.02 PL 84 99 + 1' 2000 Pf 0.06 0.05 0.04 0.04 0.04 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.00 0.00 0.00 0.01 0.02 DRMS Pf Flood 0.04 0.03 0.06 0.04 0.02 0.01 0.04 0.05 0.04 0.02 0.05 0.04 0.07 0.03 0.05 0.02 0.03 0.03 0.05 0.04 0.05 0.01 0.02 0.04 0.01 0.03 0.01 0.04 0.04 0.04 0.03 0.01 0.04 0.01 0.03 0.02 0.03 DRMS Seismic Pf 0.03 0.05 0.03 0.03 0.05 0.02 0.02 0.05 0.05 0.03 0.03 0.02 0.04 0.03 0.03 0.03 0.05 0.03 0.05 0.01 0.03 0.03 0.05 0.05 0.01 0.01 0.01 0.05 0.01 0.03 0.02 0.03 0.02 0.03 0.01 0.02 0.03 *Island in blue *Island in bold Western island important for water quality at the southern Delta pumps Major roadway, aqueduct, pipeline or railroad infrastructure DRMS PL 84DRMS 84-99 DRMS PL 84- 99 +1' Raise DRMS Flood DRMS Flood Flood + 99 + 1' Raise Flood + + Seismic PL 84-99 Seismic Flood Seismic 0.07 0.04 0.06 0.03 0.06 0.08 0.03 0.08 0.02 0.07 0.09 0.05 0.08 0.05 0.08 0.07 0.04 0.06 0.03 0.06 0.07 0.02 0.07 0.02 0.07 0.03 0.01 0.03 0.01 0.03 0.06 0.04 0.06 0.03 0.05 0.10 0.05 0.09 0.04 0.09 0.09 0.04 0.08 0.03 0.08 0.05 0.02 0.05 0.02 0.05 0.08 0.05 0.07 0.04 0.07 0.06 0.04 0.06 0.03 0.05 0.11 0.06 0.10 0.06 0.09 0.06 0.03 0.06 0.02 0.05 0.08 0.05 0.07 0.04 0.07 0.05 0.02 0.05 0.02 0.05 0.08 0.03 0.08 0.02 0.07 0.06 0.03 0.06 0.02 0.05 0.10 0.05 0.09 0.04 0.09 0.05 0.04 0.05 0.03 0.04 0.08 0.05 0.07 0.04 0.07 0.04 0.01 0.04 0.01 0.04 0.07 0.02 0.07 0.02 0.07 0.09 0.04 0.08 0.03 0.08 0.02 0.01 0.02 0.01 0.02 0.04 0.03 0.04 0.02 0.04 0.02 0.01 0.02 0.01 0.02 0.09 0.04 0.08 0.03 0.08 0.05 0.04 0.05 0.03 0.04 0.07 0.04 0.06 0.03 0.06 0.05 0.03 0.05 0.02 0.04 0.04 0.01 0.04 0.01 0.04 0.06 0.04 0.06 0.03 0.05 0.04 0.01 0.04 0.01 0.04 0.04 0.03 0.04 0.02 0.03 0.04 0.02 0.04 0.02 0.04 0.06 0.03 0.06 0.03 0.06 DRMS Estimates Atlas Tract Bacon Island Bethel Island Bishop Tract Bixler Tract Boggs Tract Bouldin Island Brack Tract Bradford Island Brannan-Andrus Island MERGE Upper Andrus Island Byron Tract Cache Haas Area Canal Ranch Clifton Court Forebay South Coney Island Cosumnes River Area Deadhorse Island Dutch Slough Egbert Tract Little Egbert Tract Ehrheardt Club Elk Grove Empire Tract Fabian Tract Fay Island Glanville Tract Glide District Grand Island Hastings Tract Holland Tract Hotchkiss Tract Jersey Island Kasson District King Island Libby McNeil Tract 1 Liberty Island n Delta pumps . Lisbon District + Glide Little Mandeville Lower Jones Tract MERGE Upper Jones Tract Mandeville Island McCormack Williamson Tract McDonald Tract McMullin Ranch Medford Island Merritt Island Middle Roberts Island MERGE Drexler Tract MERGE Holt Station MERGE Lower Roberts Island MERGE Upper Roberts Island Netherlands New Hope Tract Palm-Orwood Tract Paradise Junction Pescadero Peter's Pocket Pico Naglee Tract Pierson Tract MERGE Randall Island Prospect Island Quimby Island RD 17 (Mossdale) Rindge Tract Rio Blanco Tract River Junction Tract Rough and Ready Island Ryer Island Sacramento Pocket Area Sargent Barnhart Tract East Sherman Island Shima Tract Shin Kee Tract Smith Tract Stark Tract Staten Island Stewart Tract MERGE Mossdale RD 2107 Sutter Island Terminous Tract Tinsley Island Twitchell Island Tyler Island Union Island Veale Tract Venice Island Victoria Island Walnut Grove Walthal Tract MERGE Wetherbee Lake Webb Tract Weber Tract West Sacramento Woodward Island Wright-Elmwood Tract 0.01 0.04 0.04 0.03 0.01 0.02 0.05 0.01 0.01 0.06 0.04 0.04 0.03 0.01 0.03 0.01 0.05 0.05 0.02 0.05 0.04 0.01 0.02 0.05 0.03 0.01 0.03 0.07 0.07 0.02 0.04 0.02 0.03 0.02 0.02 0.01 0.02 0.01 0.01 0.02 0.02 0.02 0.02 0.01 0.02 0.03 0.06 0.01 0.02 0.04 0.05 0.01 0.05 0.01 0.01 0.01 0.01 0.02 0.05 0.04 0.03 0.03 0.05 0.01 0.01 0.01 0.01 0.04 0.03 0.02 Seismic risk (annual frequency of failure) Flood risk (annual frequency of failure) 0.05 0.03 0.04 0.04 0.02 0.02 0.03 0.01 0.03 0.03 0.01 0.03 0.01 0.02 0.02 0.03 0.01 0.05 0.05 0.03 0.03 0.07 0.01 0.01 0.02 0.02 0.03 0.01 0.01 0.03 0.01 0.03 0.01 0.04 0.03 0.01 0.01 0.03 0.01 0.02 0.01 0.02 0.02 0.03 0.02 0.01 0.01 0.04 0.01 0.01 0.03 0.01 0.02 0.01 0.01 0.01 0.03 0.01 0.01 0.05 0.01 0.01 0.01 0.01 0.03 0.01 0.01 0.04 0.04 0.03 0.02 0.01 0.02 0.05 0.04 0.01 0.01 0.07 0.03 0.02 0.01 0.05 0.03 0.01 0.04 0.03 0.01 0.01 0.05 0.01 0.01 0.01 0.01 0.05 0.01 0.02 0.03 0.01