Exhibit_C_Town_of_Port_Royal.xlsx
XLSX spreadsheet 32 KB Posted
- Attached to
- Pavement Evaluation & Maintenance Plan
- Solicitation number
- RFQ 040825
- Issued by
- Beaufort County, South Carolina
About this file
This document is an Excel spreadsheet (Exhibit C) detailing road condition and pavement assessment for the Town of Port Royal in Beaufort County, South Carolina. The spreadsheet provides a comprehensive inventory of 49,099 linear feet (approximately 9.30 miles) of roadways, systematically categorizing each street section by length, pavement condition index (PCI), and detailed cost estimates for potential maintenance interventions. The roads are evaluated using a standard PCI rating scale ranging from 100 (Good) to 10 (Failed), with prioritization recommendations segmented into categories like "Priority Attention," "1-3 Years," "3-5 Years," and "Beyond 10 Years."
The document includes granular cost projections for road maintenance, with estimated expenses for 2-inch and 3-inch overlay treatments, patching, and total rehabilitation costs. The total cumulative estimated costs for road maintenance across all surveyed sections approximate $1,222,236, with individual street rehabilitation costs ranging from $15,883 to $486,938. Streets are prioritized based on their PCI, with the lowest-rated roads like 13th Madrid to Paris (PCI of 33) and Pickney Boulevard (PCI of 36) receiving immediate attention, while roads with PCI of 100 (indicating recently resurfaced surfaces) are categorized as needing maintenance beyond 10 years. The analysis provides a strategic framework for systematic road infrastructure maintenance and investment for the Town of Port Royal.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Pavement_Evaluation_&_Maintenance_Plan_(Addendum_#1_Revision).pdf | ||
| THHI_Roads_2024.pdf | ||
| Beaufort_County_Roads.xls | XLS spreadsheet | |
| City_of_BFt_Road_List.pdf | ||
| Town_of_Bluffton_Roads.xls | XLS spreadsheet |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Report Table
| Street Name | Section | Length (ft) | Pavement Condition Index (PCI) | Street Name | Length (ft) | Pavement Condition Index (PCI) | ||||||
| 7th | Paris | to | London | 561 | 82 | 18th | 506 | 72 | ||||
| 8th | Paris | to | London | 564 | 57 | Old Fort Rd | 626 | 67 | ||||
| 9th | Madrid | to | Paris | 468 | 91 | Old Shell Ct | 476 | 81 | ||||
| Paris | to | London | 540 | 100 | Tamara Ln | 568 | 65 | |||||
| 10th | Madrid | to | Paris | 542 | 89 | Laurel St | 544 | 82 | ||||
| Paris | to | London | 533 | 53 | Ritter Cir | 1,417 | 52 | |||||
| London | to | DE (E) | 240 | 53 | Berkley Cir | 665 | 71 | |||||
| 11th | DE (W) | to | Madrid | 469 | 76 | Edinburgh Ave | 1,496 | 62 | ||||
| Madrid | to | Paris | 540 | 50 | Columbia Ave | 1,913 | 64 | |||||
| Paris | to | London | 526 | 100 | Madrid Ave | 2,669 | 57 | |||||
| London | to | Richmond | 545 | 100 | London Ave | 2,381 | 52 | |||||
| 12th | Columbia | to | Madrid | 550 | 63 | Richmond Ave | 3,368 | 95 | ||||
| Madrid | to | Paris | 523 | 61 | West Paris Ave | 1,640 | 55 | |||||
| Paris | to | London | 524 | 38 | Pickney Blvd | 775 | 36 | |||||
| London | to | Richmond | 562 | 35 | Stuart Towne Ln | 917 | 88 | |||||
| 13th | DE (W) | to | Columbia | 325 | 63 | Old Shell Road | 4,760 | 55 | ||||
| Columbia | to | Madrid | 552 | 39 | Sands Beach Rd | 1,758 | 100 | |||||
| Madrid | to | Paris | 527 | 33 | Paris Avenue | 4,212 | 57 | |||||
| Richmond | to | DE (E) | 370 | 100 | ||||||||
| 14th | Columbia | to | Madrid | 550 | 68 | |||||||
| Madrid | to | Paris | 520 | 54 | ||||||||
| Paris | to | London | 515 | 62 | ||||||||
| London | to | Richmond | 555 | 52 | ||||||||
| Richmond | to | Old Shell | 380 | 50 | ||||||||
| 15th | Edinburgh | to | Columbia | 555 | 80 | |||||||
| Columbia | to | Madrid | 556 | 79 | Standard PCI Rating Scale | Prioritization | ||||||
| Madrid | to | Paris | 528 | 81 | ||||||||
| Paris | to | London | 525 | 67 | 100 | Good | 100 | Beyond 10 Years | ||||
| London | to | Richmond | 541 | 100 | 86 | |||||||
| 16th | Edinburgh | to | Columbia | 550 | 75 | 85 | Satisfactory | 85 | 5-10 years | |||
| Columbia | to | Madrid | 550 | 68 | 71 | |||||||
| Madrid | to | Paris | 514 | 63 | 70 | Fair | 70 | 3-5 years | ||||
| Paris | to | London | 542 | 60 | 56 | |||||||
| London | to | Richmond | 558 | 100 | 55 | Poor | 55 | 1-3 years | ||||
| Richmond | to | Old Shell | 938 | 44 | 41 | |||||||
| Old Shell | to | DE (E) | 736 | 100 | 40 | Very Poor | 40 | Priority Attention | ||||
| 17th | DE (W) | to | Richmond | 233 | 81 | 26 | ||||||
| Richmond | to | DE (E) | 465 | 78 | 25 | Serious | 25 | |||||
| *DE - Dead End, (E) or (W) - East or West | 11 | |||||||||||
| *PCI's of 100 indicate recenlty resurfaced roads and were not surveyed | 10 | Failed | 10 | |||||||||
| 0 | 0 |
Report Table (2) Town of Port Royal Roadways - Sorted Pavement Condition
| Street Name | Section | Length (ft) | Pavement Condition Index (PCI) | |||||
| 13th | Madrid | to | Paris | 527 | 33 | |||
| 12th | London | to | Richmond | 562 | 35 | |||
| 12th | Paris | to | London | 524 | 38 | |||
| 12th | Paris | to | London | 524 | 38 | |||
| 13th | Columbia | to | Madrid | 552 | 39 | |||
| 16th | Richmond | to | Old Shell | 938 | 44 | |||
| 11th | Madrid | to | Paris | 540 | 50 | |||
| 14th | Richmond | to | Old Shell | 380 | 50 | |||
| 14th | London | to | Richmond | 555 | 52 | |||
| Ritter Cir | 1,417 | 52 | ||||||
| London Ave | 2,381 | 52 | ||||||
| 10th | Paris | to | London | 533 | 53 | |||
| 10th | London | to | DE (E) | 240 | 53 | |||
| 14th | Madrid | to | Paris | 520 | 54 | |||
| West Paris Ave | 1,640 | 55 | ||||||
| Old Shell Road | 4,760 | 55 | ||||||
| 8th | Paris | to | London | 564 | 57 | |||
| Madrid Ave | 2,669 | 57 | ||||||
| Paris Avenue | 4,212 | 57 | ||||||
| 16th | Paris | to | London | 542 | 60 | |||
| 12th | Madrid | to | Paris | 523 | 61 | |||
| 14th | Paris | to | London | 515 | 62 | |||
| Edinburgh Ave | 1,496 | 62 | ||||||
| 12th | Columbia | to | Madrid | 550 | 63 | |||
| 13th | DE (W) | to | Columbia | 325 | 63 | |||
| 16th | Madrid | to | Paris | 514 | 63 | Standard PCI Rating Scale | ||
| Columbia Ave | 800 | 64 | ||||||
| Tamara Ln | 568 | 65 | 100 | 100 | Good | |||
| 15th | Paris | to | London | 525 | 67 | 86 | ||
| Old Fort Rd | 626 | 67 | 85 | 85 | Satisfactory | |||
| 14th | Columbia | to | Madrid | 550 | 68 | 71 | ||
| 16th | Columbia | to | Madrid | 550 | 68 | 70 | 70 | Fair |
| Berkley Cir | 665 | 71 | 56 | |||||
| 18th | 506 | 72 | 55 | 55 | Poor | |||
| 16th | Edinburgh | to | Columbia | 550 | 75 | 41 | ||
| 11th | DE (W) | to | Madrid | 469 | 76 | 40 | 40 | Very Poor |
| 17th | Richmond | to | DE (E) | 465 | 78 | 26 | ||
| 15th | Columbia | to | Madrid | 556 | 79 | 25 | 25 | Serious |
| 15th | Edinburgh | to | Columbia | 555 | 80 | 11 | ||
| 15th | Madrid | to | Paris | 528 | 81 | 10 | 10 | Failed |
| 17th | DE (W) | to | Richmond | 233 | 81 | 0 | 0 | |
| Old Shell Ct | 476 | 81 | ||||||
| 7th | Paris | to | London | 561 | 82 | |||
| Laurel St | 544 | 82 | ||||||
| Stuart Towne Ln | 917 | 88 | ||||||
| 10th | Madrid | to | Paris | 542 | 89 | |||
| 9th | Madrid | to | Paris | 468 | 91 | |||
| Richmond Ave | 3,368 | 95 | ||||||
| 9th | Paris | to | London | 540 | 100 | |||
| 11th | Paris | to | London | 526 | 100 | |||
| 11th | London | to | Richmond | 545 | 100 | |||
| 13th | Richmond | to | DE (E) | 370 | 100 | |||
| 15th | London | to | Richmond | 541 | 100 | |||
| 16th | London | to | Richmond | 558 | 100 | |||
| 16th | Old Shell | to | DE (E) | 736 | 100 | |||
| Sands Beach Rd | 1,758 | 100 | ||||||
| 49099 | ||||||||
| 9.30 | Miles |
Exhibit C
EXHIBIT C
Town of Port Royal Roads
Road Length (ft) Termini Termini
| Old Shell Road | 4,760 | Ribaut | 14th |
| Tamara Ln | 568 | 16th | End |
| Old Fort Rd | 626 | Old Shell | End |
| Berkley Cir | 665 | Ribaut | Ribaut |
| Old Shell Ct | 476 | Old Shell Rd | End |
| Laurel St | 544 | Columbia | Madrid |
| Stuart Towne Ln | 917 | Pinckney Blvd | End |
8,556 LF
1.62 Miles
Report Table (3)
| Street Name | Section | Length (ft) | Pavement Condition Index (PCI) | Area (square yards) | Area (square yards) | Mill Cost | 2" Overlay | 3" Overlay | Patching | Total Cost | Cumulative Estimates | |||||
| 13th | Madrid | to | Paris | 527 | 33 | 1171 | 1327 | $ 3,716 | $ 5,212 | $ 12,708 | $ 11,280 | $ 34,562 | ||||
| 12th | London | to | Richmond | 562 | 35 | 1249 | 1405 | $ 3,934 | $ 5,851 | $ 12,981 | $ 11,942 | $ 36,443 | Priority | |||
| Pickney Blvd | 775 | 36 | 2067 | 2223 | $ 6,223 | $ 9,522 | $ 20,164 | $ 18,893 | $ 57,542 | Attention | ||||||
| 12th | Paris | to | London | 524 | 38 | 1164 | 1320 | $ 3,697 | $ 5,971 | $ 11,535 | $ 11,224 | $ 34,049 | ||||
| 13th | Columbia | to | Madrid | 552 | 39 | 1227 | 1383 | $ 3,871 | $ 6,417 | $ 11,847 | $ 11,753 | $ 35,582 | $ 198,179 | |||
| 16th | Richmond | to | Old Shell | 938 | 44 | 2084 | 2240 | $ 6,273 | $ 11,731 | $ 17,314 | $ 19,044 | $ 57,080 | ||||
| 11th | Madrid | to | Paris | 540 | 50 | 1200 | 1356 | $ 3,797 | $ 8,068 | $ 9,112 | $ 11,526 | $ 34,128 | ||||
| 14th | Richmond | to | Old Shell | 380 | 50 | 844 | 1000 | $ 2,801 | $ 5,953 | $ 6,723 | $ 8,504 | $ 25,180 | ||||
| 14th | London | to | Richmond | 555 | 52 | 1233 | 1389 | $ 3,890 | $ 8,597 | $ 8,870 | $ 11,809 | $ 34,824 | ||||
| Ritter Cir | 1,417 | 52 | 3149 | 3305 | $ 9,254 | $ 20,451 | $ 21,098 | $ 28,092 | $ 82,839 | |||||||
| London Ave | 2,381 | 52 | 5291 | 5447 | $ 15,252 | $ 33,707 | $ 34,774 | $ 46,300 | $ 136,535 | |||||||
| 10th | Paris | to | London | 533 | 53 | 1184 | 1340 | $ 3,753 | $ 8,454 | $ 8,332 | $ 11,394 | $ 33,530 | ||||
| 10th | London | to | DE (E) | 240 | 53 | 533 | 689 | $ 1,930 | $ 4,348 | $ 4,285 | $ 5,859 | $ 17,243 | ||||
| 14th | Madrid | to | Paris | 520 | 54 | 1156 | 1312 | $ 3,672 | $ 8,428 | $ 7,932 | $ 11,148 | $ 32,740 | 1-3 Years | |||
| West Paris Ave | 1,640 | 55 | 4373 | 4529 | $ 12,682 | $ 29,644 | $ 26,632 | $ 38,499 | $ 112,831 | |||||||
| Old Shell Road | 4,760 | 55 | 12693 | 12849 | $ 35,978 | $ 84,099 | $ 75,554 | $ 109,219 | $ 320,093 | $ 887,024 | ||||||
| 8th | Paris | to | London | 564 | 57 | 1253 | 1409 | $ 3,946 | $ 9,560 | $ 7,813 | $ 11,979 | $ 34,963 | ||||
| Madrid Ave | 2,669 | 57 | 5931 | 6087 | $ 17,044 | $ 41,289 | $ 33,747 | $ 51,740 | $ 151,011 | |||||||
| Paris Avenue | 4,212 | 57 | 19472 | 19628 | $ 54,958 | $ 133,137 | $ 108,818 | $ 166,838 | $ 486,938 | |||||||
| 16th | Paris | to | London | 542 | 60 | 1204 | 1360 | $ 3,809 | $ 9,714 | $ 6,857 | $ 11,564 | $ 33,540 | ||||
| 12th | Madrid | to | Paris | 523 | 61 | 1162 | 1318 | $ 3,691 | $ 9,569 | $ 6,422 | $ 11,205 | $ 32,432 | ||||
| 14th | Paris | to | London | 515 | 62 | 1144 | 1300 | $ 3,641 | $ 9,595 | $ 6,117 | $ 11,054 | $ 31,927 | ||||
| Edinburgh Ave | 1,496 | 62 | 3324 | 3480 | $ 9,745 | $ 25,679 | $ 16,372 | $ 29,584 | $ 85,449 | |||||||
| 12th | Columbia | to | Madrid | 550 | 63 | 1222 | 1378 | $ 3,859 | $ 10,333 | $ 6,252 | $ 11,715 | $ 33,766 | ||||
| 13th | DE (W) | to | Columbia | 325 | 63 | 722 | 878 | $ 2,459 | $ 6,584 | $ 3,984 | $ 7,465 | $ 21,516 | ||||
| 16th | Madrid | to | Paris | 514 | 63 | 1142 | 1298 | $ 3,635 | $ 9,733 | $ 5,889 | $ 11,035 | $ 31,806 | Standard PCI Rating Scale | |||
| Columbia Ave | 1,913 | 64 | 4251 | 4407 | $ 12,340 | $ 33,565 | $ 19,250 | $ 37,460 | $ 107,746 | |||||||
| Tamara Ln | 568 | 65 | 1262 | 1418 | $ 3,971 | $ 10,970 | $ 5,957 | $ 12,055 | $ 34,600 | 100 | 100 | Good | ||||
| 15th | Paris | to | London | 525 | 67 | 1167 | 1323 | $ 3,703 | $ 10,546 | $ 5,111 | $ 11,243 | $ 32,133 | 86 | |||
| Old Fort Rd | 626 | 67 | 1391 | 1547 | $ 4,332 | $ 12,335 | $ 5,978 | $ 13,150 | $ 37,585 | 3-5 Years | 85 | 85 | Satisfactory | |||
| 14th | Columbia | to | Madrid | 550 | 68 | 1222 | 1378 | $ 3,859 | $ 11,153 | $ 5,094 | $ 11,715 | $ 33,411 | 71 | |||
| 16th | Columbia | to | Madrid | 550 | 68 | 1222 | 1378 | $ 3,859 | $ 11,153 | $ 5,094 | $ 11,715 | $ 33,411 | $ 1,222,236 | 70 | 70 | Fair |
| Berkley Cir | 665 | 71 | 1478 | 1634 | $ 4,575 | $ 13,804 | $ 5,215 | $ 13,887 | $ 39,355 | 56 | ||||||
| 18th | 506 | 72 | 1124 | 1280 | $ 3,585 | $ 10,971 | $ 3,872 | $ 10,884 | $ 30,778 | 55 | 55 | Poor | ||||
| 16th | Edinburgh | to | Columbia | 550 | 75 | 1222 | 1378 | $ 3,859 | $ 12,301 | $ 3,473 | $ 11,715 | $ 32,915 | 41 | |||
| 11th | DE (W) | to | Madrid | 469 | 76 | 1042 | 1198 | $ 3,355 | $ 10,837 | $ 2,818 | $ 10,185 | $ 28,555 | 40 | 40 | Very Poor | |
| 17th | Richmond | to | DE (E) | 465 | 78 | 1033 | 1189 | $ 3,330 | $ 11,039 | $ 2,398 | $ 10,109 | $ 28,220 | 26 | |||
| 15th | Columbia | to | Madrid | 556 | 79 | 1236 | 1392 | $ 3,896 | $ 13,082 | $ 2,572 | $ 11,828 | $ 32,947 | 25 | 25 | Serious | |
| 15th | Edinburgh | to | Columbia | 555 | 80 | 1233 | 1389 | $ 3,890 | $ 13,226 | $ 2,334 | $ 11,809 | $ 32,823 | 11 | |||
| 15th | Madrid | to | Paris | 528 | 81 | 1173 | 1329 | $ 3,722 | $ 12,813 | $ 2,010 | $ 11,299 | $ 31,337 | 10 | 10 | Failed | |
| 17th | DE (W) | to | Richmond | 233 | 81 | 518 | 674 | $ 1,887 | $ 6,495 | $ 1,019 | $ 5,727 | $ 15,883 | 0 | 0 | ||
| Old Shell Ct | 476 | 81 | 1058 | 1214 | $ 3,399 | $ 11,700 | $ 1,835 | $ 10,317 | $ 28,613 | 5-10 Years | ||||||
| 7th | Paris | to | London | 561 | 82 | 1247 | 1403 | $ 3,927 | $ 13,687 | $ 1,885 | $ 11,923 | $ 32,994 | ||||
| Laurel St | 544 | 82 | 1209 | 1365 | $ 3,822 | $ 13,319 | $ 1,834 | $ 11,602 | $ 32,105 | $ 366,524 | ||||||
| Stuart Towne Ln | 917 | 88 | 2038 | 2194 | $ 6,143 | $ 26,106 | $ - 0 | $ - 0 | $ 33,861 | |||||||
| 10th | Madrid | to | Paris | 542 | 89 | 1204 | 1360 | $ 3,809 | $ 16,189 | $ - 0 | $ - 0 | $ 20,998 | ||||
| 9th | Madrid | to | Paris | 468 | 91 | 1040 | 1196 | $ 3,349 | $ 14,232 | $ - 0 | $ - 0 | $ 18,460 | ||||
| Richmond Ave | 3,368 | 95 | 8233 | 8389 | $ 23,489 | $ 99,828 | $ - 0 | $ - 0 | $ 129,483 | |||||||
| 9th | Paris | to | London | 540 | 100 | 1200 | 1356 | $ 3,797 | $ 16,136 | $ - 0 | $ - 0 | $ 20,930 | ||||
| 11th | Paris | to | London | 526 | 100 | 1169 | 1325 | $ 3,710 | $ 15,766 | $ - 0 | $ - 0 | $ 20,450 | ||||
| 11th | London | to | Richmond | 545 | 100 | 1211 | 1367 | $ 3,828 | $ 16,269 | $ - 0 | $ - 0 | $ 21,101 | ||||
| 13th | Richmond | to | DE (E) | 370 | 100 | 822 | 978 | $ 2,739 | $ 11,641 | $ - 0 | $ - 0 | $ 15,099 | ||||
| 15th | London | to | Richmond | 541 | 100 | 1202 | 1358 | $ 3,803 | $ 16,163 | $ - 0 | $ - 0 | $ 20,964 | Beyond | |||
| 16th | London | to | Richmond | 558 | 100 | 1240 | 1396 | $ 3,909 | $ 16,612 | $ - 0 | $ - 0 | $ 21,547 | 10 Years | |||
| 16th | Old Shell | to | DE (E) | 736 | 100 | 1636 | 1792 | $ 5,016 | $ 21,320 | $ - 0 | $ - 0 | $ 27,653 | ||||
| Sands Beach Rd | 1,758 | 100 | 4688 | 4844 | $ 13,563 | $ 57,644 | $ - 0 | $ - 0 | $ 74,767 | $ 425,313 | ||||||
| *Paris Avenue area estimate includes street parking surfaces | ||||||||||||||||
| *Areas include intersection estimates | ||||||||||||||||
| *Estimated 10% Surface Patching and 5% Misc. |
File details come from the government source that posted it. Updated .