VHB 2020 Marlborough Streets 2019.xls

XLS spreadsheet 229 KB Posted

Attached to
Town Wide Pavement Assessment Study
Solicitation number
39271
Issued by
Middlesex County, Connecticut

About this file

This is a pavement assessment and treatment analysis spreadsheet for the Town of Marlborough, Connecticut, documenting a comprehensive inventory of 143 road segments requiring condition evaluation and repair recommendations. The assessment evaluates roads based on Pavement Condition Index (PCI) ratings ranging from 0 to 100, identifying distress types including transverse cracking, longitudinal cracking, alligator cracking, potholes, rutting, and raveling. Each road segment is assessed for current condition, recommended treatment, and estimated costs. Treatment recommendations span from "Do Nothing" for roads rated 85-100 PCI to various preservation and rehabilitation options, including crack sealing, surface sealing, overlays, mill and overlay, reclamation, shim and overlay, and full structural replacement. The total mileage evaluated is 62 miles, with recommendations distributed across five primary treatment categories: Do Nothing (14.4 miles), Crack Seal (16.3 miles), Preservation (18.7 miles), Mill & Overlay (8.6 miles), and Reclaim (3.5 miles).

The total estimated cost for all recommended treatments is $5,701,186, with Mill & Overlay projects comprising the largest expense at $3,128,263, followed by Reclaim at $1,347,086 and Preservation at $1,102,567. Unit costs for treatments range from $0.00 for "Do Nothing" recommendations to $30.00 per square yard for Base Rehabilitation. The assessment provides treatment life estimates ranging from one year for isolated patching to 25 years for base rehabilitation, with estimated PCI values after treatment ranging from 95 to 99. Specific roads requiring immediate attention include North Parker Road (PCI 50), Sherwood Lane (PCI 50), Flood Road #3 (PCI 50), and multiple segments rated between 40 and 65 PCI. The spreadsheet includes lookup tables referencing cost data from comparable Connecticut municipalities including Hebron and Norwalk, and notes that some treatment recommendations include alternatives such as cold in-place recycling options or driveway adjustment considerations.

View the file

Other files

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

MarlboroughStreets2019

OBJECTIDROADNAMEBEGINNING_REPAIR 20132019 PCIIsDone_Distresses 2019Repair 2019Comment 2019Length (ft)UniqueIDWidthArea (ft)Area (yds)Treatment Band Based on PCITreatment Band Based On RepairUnit Cost Per SqYdTotal Cost
124ALDEN CIRCLE0.00000000000Crack Seal with Localized repair90YesTransverse and Longitudinal CrackingDo NothingCracks Are Well Sealed9281142825,9822,8870Do Nothing$0.00$0
32AUSTIN DRIVE0.00000000000Base Rehab100YesNoneDo Nothing1,270301519,0502,1170Do Nothing$0.00$0
125BEVERLY LANE0.00000000000Do Nothing85YesTransverse and Longitudinal CrackingCrack Seal687115106,8677630Crack Seal$0.50$382
12BLACKLEDGE ROAD NORTH0.00000000000Do Nothing100YesNoneDo Nothing1,298111823,3692,5970Do Nothing$0.00$0
8BLACKLEDGE ROAD SOUTH0.00000000000Localized Repair80YesTransverse and Alligator CrackingCrack Seal53472010,6801,1870Crack Seal$0.50$593
81BLISH ROAD0.00000000000Crack Seal with Localized repair65YesTransverse and Longitudinal Cracking and Alligator Cracking, DistortionsLevel and OverlayDriveways And Drainage Structures Will Need To Be Adjusted2,104782144,1844,9090Preservation$8.16$40,060
143BROCK CROSSING0.0000000000085Transverse and Longitudinal Cracking Block and Alligator CrackingSurface SealSurface Exhibits Light Alligator Cracking - Surface Seal Now to Avoid Mill & Overlay in 5-10 Years4961314019,8402,2040Preservation$5.00$11,022
75BUCKBOARD LANE0.00000000000Crack Seal with Localized repair70YesTransverse and Longitudinal Cracking Block and Alligator CrackingMill & OverlayConsider Rubber Chip Like Walnut?1,602722032,0403,5600Mill & Overlay$24.17$86,045
67BULL HILL ROAD0.00000000000Base Rehab100YesNoneDo Nothing2,268652045,3525,0390Do Nothing$0.00$0
58CAFFYN DRIVE0.00000000000Do Nothing90YesSurface Wear and Longitudinal CrackingCrack SealCracking Is In The Cul-De-Sac. Surface Wear Caused By Snow Plow Chatter.1,222562328,1063,1230Crack Seal$0.50$1,561
57CARRIAGE LANE0.00000000000Crack Seal with Localized repair65YesAlligator Cracking and DistortionsMill & OverlayConsider Rubber Chip Like Walnut?1,379553041,3704,5970Mill & Overlay$24.17$111,102
51CHAPMAN ROAD0.00000000000Crack Seal with Localized repair85YesTransverse and isolated Alligator Cracking and DistortionsCrack Seal and Patch7,7814924186,74420,7490Preservation$2.50$51,873
90CHENEY ROAD #10.00000000000Crack Seal with Localized repair85YesTransverse and Longitudinal CrackingCrack Seal3,189852476,5308,5030Crack Seal$0.50$4,252
105CHENEY ROAD #20.00000000000Do Nothing90YesLight Transverse and Longitudinal CrackingCrack Seal1,397962534,9153,8790Crack Seal$0.50$1,940
106COOLEY ROAD0.00000000000Base Rehab95YesIsolated Longitudinal CrackingCrack Seal880972219,3602,1510Crack Seal$0.50$1,076
113DEER RUN0.00000000000Crack Seal with Localized repair75YesTransverse and Longitudinal Cracking, light Distortions, Alligator CrackingCrack SealConsider Surface Seal 2 Address Distortions At Transverse Cracks1,9241043057,7206,4130Crack Seal$0.50$3,207
114DENLER DRIVE0.00000000000Do Nothing90YesLight Longitudinal and Alligator CrackingCrack Seal1,9411053058,2176,4690Crack Seal$0.50$3,234
10DICKINSON ROAD0.00000000000Crack Seal with Localized repair95YesTransverse and Longitudinal Cracking and isolated light Alligator CrackingDo NothingCracks Are Well Sealed6,179930185,37020,5970Do Nothing$0.00$0
17EAGLE ROCK TRAIL0.00000000000Do Nothing95YesLight Transverse and Longitudinal CrackingDo NothingChip Seal Surface, Cracks Are Well Sealed1,144162832,0323,5590Do Nothing$0.00$0
18EAST LAKE ROAD0.00000000000Do Nothing100YesNoneDo Nothing34017206,8007560Do Nothing$0.00$0
36EDSTROM ROAD #10.00000000000Crack Seal with Localized repair85YesTransverse and Alligator CrackingCrack SealSome Cracks Are Well Sealed But Additional Alligator Cracking Needs To Be Sealed2,464342254,2026,0220Crack Seal$0.50$3,011
37EDSTROM ROAD #20.00000000000Structural Improvement100YesNoneDo Nothing3,234352580,8478,9830Do Nothing$0.00$0
54EDSTROM ROAD #30.00000000000Crack Seal with Localized repair90YesTransverse and Longitudinal CrackingDo NothingCracks Are Well Sealed2,010522550,2595,5840Do Nothing$0.00$0
63EMILY ROAD0.00000000000Base Rehab85YesLight Distortions Transverse Cracking isolated small PotholesIsolated PatchingPlan To Crack Seal In 2 To 3 Years4,0466128113,28812,5880Preservation$2.00$25,175
64FINLEY HILL ROAD0.00000000000Structural Improvement100YesNoneDo NothingNew Pavement3,830622388,0899,7880Do Nothing$0.00$0
86FLOOD ROAD #10.00000000000Do Nothing60YesTransverse and Longitudinal and Alligator Cracking, some patched PotholesMill & Overlay or OverlaySome Damage To Chip Seal From Snow Plows5,4798222120,53813,3930Mill & Overlay$15.17$203,173
109FLOOD ROAD #30.00000000000Do Nothing50YesLongitudinal and Alligator Cracking some PotholesReclaimCold In-Place Recycling Is A Possible Alternative Treatment6,44710025161,16517,9070Reclaim$24.17$432,817
110FULLER ROAD0.00000000000Do Nothing65YesAlligator Cracking, Transverse and Longitudinal CrackingOverlayFairly Extensive Alligator Cracking Overlay Would Provide Additional Structural Value. Some Driveways May Require Adjustment.1,1021012426,4432,9380Preservation$6.16$18,099
99GARDEN LANE0.00000000000Crack Seal with Localized repair60YesAlligator and Longitudinal CrackingMill & Overlay24693215,1665740Mill & Overlay$24.17$13,874
98GINA LANE0.00000000000Do Nothing95YesLongitudinal and Transverse CrackingCrack SealCracking Is Primarily In Cul-De-Sac1,396922839,0884,3430Crack Seal$0.50$2,172
76GLENWOOD ROAD0.00000000000Do Nothing80YesTransverse and Longitudinal Cracking and Alligator CrackingCrack Seal1,215732327,9403,1040Crack Seal$0.50$1,552
68HALL TRAIL0.00000000000Do Nothing95YesIsolated CrackingDo Nothing739661813,3011,4780Do Nothing$0.00$0
46HEMLOCK DRIVE0.00000000000Crack Seal with Localized repair70YesTransverse and Longitudinal and Alligator CrackingMill & Overlay with some Full Depth Patching2,711442670,4867,8320Mill & Overlay$26.17$204,957
45HERITAGE DRIVE0.00000000000Do Nothing90YesTransverse and Longitudinal CrackingDo NothingChip Seal Surface, Cracks Are Well Sealed2,142432655,6886,1880Do Nothing$0.00$0
28HICKORY ROAD0.00000000000Crack Seal with Localized repair80YesTransverse and Longitudinal Cracking and Alligator Cracking, light DistortionsCrack Seal1,953272446,8725,2080Crack Seal$0.50$2,604
21HIDDEN WOODS DRIVE0.00000000000Do Nothing90YesTransverse and Longitudinal CrackingDo NothingCracks Are Well Sealed1,985202345,6505,0720Do Nothing$0.00$0
121HILLSIDE AVE0.00000000000Do Nothing95YesIsolated CrackingDo Nothing279112195,3055890Do Nothing$0.00$0
1HOCCANUM ROAD0.00000000000Do Nothing90YesTransverse and Longitudinal CrackingDo NothingCracks Are Well Sealed95602523,9002,6560Do Nothing$0.00$0
14HODGE ROAD0.00000000000Crack Seal with Localized repair85YesTransverse and Longitudinal Cracking and Alligator CrackingCrack Seal3,040132060,7936,7550Crack Seal$0.50$3,377
117HOLLY LANE0.00000000000Do Nothing90YesTransverse and Longitudinal Cracking and Block CrackingCrack Seal9441082422,6522,5170Crack Seal$0.50$1,258
83HUNTER RIDGE ROAD0.00000000000Do Nothing95YesLongitudinal and Transverse CrackingDo NothingCracks Are Well Sealed1,327802634,5023,8340Do Nothing$0.00$0
61INDEPENDENCE DRIVE0.00000000000Do Nothing85YesTransverse and Longitudinal CrackingCrack Seal501592814,0281,5590Crack Seal$0.50$779
34ISLEIB ROAD0.00000000000Do Nothing85YesLongitudinal and light Alligator CrackingCrack Seal3,355322377,1638,5740Crack Seal$0.50$4,287
15JAMES LANE0.00000000000Base Rehab100YesNoneDo Nothing1,956142752,8125,8680Do Nothing$0.00$0
107JERRY DANIELS ROAD #10.00000000000Do Nothing95YesTransverse and Longitudinal Cracking and light Alligator CrackingCrack SealCracks Are Well Sealed. Very Isolated Spots Where Additional Sealant Is Recommended.5,4839828153,51717,0570Crack Seal$0.50$8,529
52JERRY DANIELS ROAD #30.00000000000Structural Improvement85YesTransverse and Longitudinal Cracking and Alligator Cracking, Depressions, patched PotholesPatchingCracks Are Well Sealed1,099501617,5791,9530Preservation$2.00$3,906
35JOHNSON ROAD0.00000000000Crack Seal with Localized repair85YesTransverse and Alligator CrackingCrack Seal5,5263323127,09814,1220Crack Seal$0.50$7,061
9JONES HOLLOW ROAD #10.00000000000Do Nothing75YesLight Distortions Transverse and Longitudinal Cracking isolated patchingRoutine MaintenanceChip Seal Surface, Structural Improvement In 5 To 10 Years Recommended4,803821100,86311,2070Preservation$2.50$28,018
108JONES HOLLOW ROAD #20.00000000000Do Nothing75YesLight Distortions Transverse and Longitudinal Cracking isolated patchingRoutine MaintenanceChip Seal Surface. Structural Improvement Recommended In 5 To 10 Years.5,2029924124,84813,8720Preservation$2.50$34,680
77JONES HOLLOW ROAD #30.00000000000Do Nothing80YesNew PavementDo NothingNew Pavement8721272622,6732,5190Do Nothing$0.00$0
141JONES HOLLOW ROAD #30.00000000000Do Nothing80YesLight DistortionsRoutine MaintenanceChip Seal Surface, Section From Town Hall To Cheney Road Is New Pavement.12,8847425322,09835,7890Preservation$2.50$89,472
53KEIRSTEAD CIRCLE0.00000000000Do Nothing95YesIsolated CrackingDo Nothing1,889511834,0113,7790Do Nothing$0.00$0
122KELLOGG ROAD #20.00000000000Do Nothing90YesLight Transverse and Longitudinal CrackingCrack Seal2,9081132058,1596,4620Crack Seal$0.50$3,231
101KIMBERLEY WAY0.00000000000Crack Seal with Localized repair95YesTransverse and Longitudinal Cracking and Alligator CrackingDo NothingCracks Are Well Sealed799952519,9752,2190Do Nothing$0.00$0
78KNEELAND ROAD0.00000000000Crack Seal100YesNoneDo Nothing818752016,3601,8180Do Nothing$0.00$0
47KRISTI LANE0.00000000000Crack Seal with Localized repair95YesLight Transverse and Longitudinal Cracking and Alligator CrackingDo NothingCracks Are Well Sealed1,240452531,0003,4440Do Nothing$0.00$0
29LAFAYETTE ROAD0.00000000000Do Nothing75YesTransverse and Longitudinal Cracking isolated area of Alligator Cracking and DistortionsCrack SealA Short Section On The West End Of This Section (Near Top Of Hill) Needs Structural Improvement868281815,6241,7360Crack Seal$0.50$868
133LAFAYETTE ROAD0.00000000000Base Rehab90YesRaveling, light DistortionsDo Nothing7971212620,7232,3030Do Nothing$0.00$0
3LAKE RIDGE DRIVE #10.00000000000Do Nothing95YesIsolated Transverse and Longitudinal CrackingCrack Seal2,29022148,0975,3440Crack Seal$0.50$2,672
71LAKE ROAD0.00000000000Do Nothing90YesTransverse and Longitudinal CrackingCrack SealCracking Is In The Boat Launch Area919692220,2182,2460Crack Seal$0.50$1,123
48LAUREL LANE0.00000000000Do Nothing90YesTransverse and Longitudinal CrackingDo NothingChip Seal Surface, Cracks Are Well Sealed4,0254628112,69212,5210Do Nothing$0.00$0
24LEWIS ROAD0.00000000000Base Rehab90YesLight Distortions isolated small PotholesPatching2,234232964,7737,1970Preservation$2.00$14,394
4MAYFLOWER ROAD0.00000000000Do Nothing95YesTransverse and Longitudinal CrackingDo NothingCracks Are Well Sealed1,68432847,1505,2390Do Nothing$0.00$0
93MEADOW WAY0.00000000000Crack Seal with Localized repair95YesTransverse and Longitudinal Cracking and Alligator CrackingDo NothingCracks Are Well Sealed772882519,2992,1440Do Nothing$0.00$0
126MILLSTONE DRIVE0.00000000000Crack Seal with Localized repair85YesTransverse CrackingCrack Seal4,16411628116,58312,9540Crack Seal$0.50$6,477
42MONHEGE PATH0.00000000000Crack Seal with Localized repair85YesTransverse and Longitudinal Cracking and light Alligator CrackingCrack Seal1,198402934,7323,8590Crack Seal$0.50$1,930
25MYRNA ROAD0.00000000000Do Nothing65YesAlligator Cracking, Distortions, Transverse and Longitudinal CrackingOverlayOverlay Will Require Some Driveway Adjustments. Very Little Drainage On The Road. Consider Surface Seal With Patching Preparation As An Alternative.1,871242139,2914,3660Preservation$6.16$26,893
118MYSTIC LANE0.00000000000Crack Seal with Localized repair65YesTransverse and Longitudinal Cracking and Alligator CrackingMill & Overlay5771093017,3101,9230Mill & Overlay$24.17$46,487
94NORTH MAIN STREET #10.00000000000Crack Seal with Localized repair90YesIsolated light Transverse and Longitudinal CrackingDo NothingPlan To Crack Seal Again Within 5 Years1,143893135,4333,9370Do Nothing$0.00$0
62NORTH MAIN STREET #20.00000000000Do Nothing85YesLight Transverse and Longitudinal Cracking and Alligator CrackingCrack SealContinue To Maintain By Crack Sealing, Plan To Mill And Overlay In 10 Years8,8226030264,64729,4050Crack Seal$0.50$14,703
127NORTH PARKER ROAD0.00000000000Do Nothing50YesHeavy Distortions, Transverse and Longitudinal CrackingBase RehabilitationPossible Cold In-Place Recycling Candidate3,4931172483,8229,3140Reclaim$30.00$279,408
16OAK DRIVE0.00000000000Do Nothing90YesLight Transverse CrackingCrack Seal1,133153135,1233,9030Crack Seal$0.50$1,951
129OFSHAY ROAD0.00000000000Crack Seal with Localized repair60YesAlligator Cracking Distortions Transverse and Longitudinal CrackingStructural ImprovementReclaim Or Remove And Replace Or Just Maintain With Surface Treatment Are Options286118216,0026670Mill & Overlay$24.17$16,119
85OGDEN LORD ROAD0.00000000000Crack Seal with Localized repair60YesAlligator Cracking some light DistortionOverlaySome Areas May Require Full Depth Patching. Reclaim Is An Alternative Treatment But May Not Be Warranted Due To Limited Traffic9,8368123226,21925,1350Preservation$6.16$154,834
5PAPERMILL ROAD0.00000000000Base Rehab45YesTransverse and Longitudinal Cracking Block and Alligator Cracking, DistortionsShim and Overlay5,48841898,78410,9760Preservation$8.16$89,564
95PARK ROAD0.00000000000Routine Maintenance70YesTransverse and Longitudinal Cracking, Distortions, PotholesOverlayOld Micro Surface Wearing Off In Several Locations, Consider A Surface Treatment With Patching Preparation As An Alternative; Split Segment At Route To Bridge Section To East Is Do Nothing2,723903184,4229,3800Preservation$6.16$57,782
142PARK ROAD1.00000000000Routine Maintenance95YesPatch & OverlayOld Micro Surface Wearing Off In Several Locations, Consider A Surface Treatment With Patching Preparation As An Alternative; Split Segment At Route To Bridge Section To East Is Do Nothing1,7291242339,7604,4180Preservation$8.16$36,049
72PARKER ROAD0.00000000000Do Nothing45YesDistortions and Alligator CrackingLevel and Rubber ChipMultiple Areas Need Drainage Improvement To Keep Water Off Of Road. Conditions Warrant Reclamation However Limited Traffic Suggests Recommended Treatment.3,650701762,0506,8940Preservation$8.16$56,259
43PETTINGILL ROAD0.00000000000Crack Seal with Localized repair80YesTransverse and Longitudinal Cracking, isolated Alligator CrackingCrack Seal1,789411526,8362,9820Crack Seal$0.50$1,491
138PETTINGILL ROAD0.00000000000Crack Seal with Localized repair85YesTransverse and Longitudinal Cracking, isolated Alligator CrackingCrack Seal5391262010,7861,1980Crack Seal$0.50$599
139PETTINGILL ROAD0.00000000000Crack Seal with Localized repair40YesTransverse and Longitudinal Cracking, extensive heavy Alligator CrackingReclaim462125198,7849760Reclaim$24.17$23,590
26PHELPS ROAD0.00000000000Do Nothing85YesTransverse and Longitudinal Cracking and Alligator CrackingCrack Seal2,261252045,2105,0230Crack Seal$0.50$2,512
140PHELPS ROAD0.00000000000Do Nothing60YesTransverse and Longitudinal Cracking and Alligator CrackingPatch & OverlayAlligator Cracking & Distortions468128157,0277810Preservation$8.16$6,372
119PINE GROVE ROAD0.00000000000Do Nothing90YesLongitudinal CrackingCrack Seal8061102520,1452,2380Crack Seal$0.50$1,119
96PLANETA ROAD0.00000000000Crack Seal with Localized repair65YesTransverse and Longitudinal Cracking Block and Alligator CrackingMill & OverlayMilling Recommended To Remove Aged Pavement4911222914,2401,5820Mill & Overlay$24.17$38,242
65POND VIEW0.00000000000Crack Seal with Localized repair95YesTransverse and Longitudinal Cracking and Alligator CrackingDo NothingCracks Are Well Sealed2,128632451,0645,6740Do Nothing$0.00$0
44PORTLAND ROAD0.00000000000Crack Seal with Localized repair70YesTransverse and Longitudinal Cracking and Alligator Cracking, DistortionsLevel and Rubber Chip or OverlayExisting Rubber Chip Wearing Off In Several Locations; Roadside Ditch (Or Other Storm Drainage Facility) Needs To Be Created In Some Locations To Keep Water Off Road5,5994222123,17113,6860Preservation$8.16$111,675
19QUINN ROAD0.00000000000Do Nothing65YesTransverse and Alligator Cracking isolated PotholesOverlaySome Damage To Chip Seal From Snow Plows3,544182070,8807,8760Preservation$6.16$48,513
120RIDGEWOOD DRIVE0.00000000000Do Nothing100YesNoneDo Nothing2,1961113065,8807,3200Do Nothing$0.00$0
88RIVENDELL ROAD0.00000000000Do Nothing70YesExtensive Alligator Cracking, Transverse and Longitudinal Cracking, DistortionsMill & OverlayQuestionable Bass Condition2,112832859,1366,5710Mill & Overlay$24.17$158,813
66RIVERVIEW CIRCLE0.00000000000Base Rehab95YesTransverse and Longitudinal Cracking and Block Cracking in cul-de-sacCrack SealNew Pavement2,067642755,8096,2010Crack Seal$0.50$3,101
38ROBERTS ROAD0.00000000000Crack Seal with Localized repair90YesLight Transverse and Longitudinal CrackingCrack Seal4,9193630147,55516,3950Crack Seal$0.50$8,198
20SANDY LANE0.00000000000Do Nothing90YesLongitudinal CrackingCrack SealCracking Is Primarily In Cul-De-Sac1,012192929,3343,2590Crack Seal$0.50$1,630
111SANER ROAD0.00000000000Crack Seal with Localized repair75YesTransverse and Longitudinal Cracking and Alligator Cracking, isolated PotholesCrack Seal and Patch9,90410224237,69626,4110Preservation$2.50$66,027
89SARAH LANE0.00000000000Crack Seal with Localized repair70YesTransverse and Longitudinal Cracking and isolated Alligator Cracking; DistortionsLevel and OverlayMay Need To Adjust One Driveway35984248,6169570Preservation$8.16$7,812
55SCHOOL DRIVE0.00000000000Do Nothing90YesLongitudinal and light Alligator CrackingCrack Seal1,816532952,6645,8520Crack Seal$0.50$2,926
39SHEPARD DRIVE0.00000000000Do Nothing85YesTransverse and Longitudinal CrackingCrack Seal542373016,2571,8060Crack Seal$0.50$903
11SHERWOOD LANE0.00000000000Base Rehab50YesExtensive Alligator Cracking Distortions, Transverse and Longitudinal CrackingReclaimCross Section Of Road Is Not Bad Remove And Replace Is A Possible Option3,5881028100,46411,1630Reclaim$24.17$269,801
112SOUTH BUCKBOARD LANE0.00000000000Do Nothing95YesTransverse and Longitudinal CrackingDo NothingCracks Are Well Sealed. Chip Seal Surface4,12410327111,34612,3720Do Nothing$0.00$0
79SOUTH MAIN STREET #10.00000000000Crack Seal with Localized repair100YesNoneDo Nothing4,2857625107,12511,9030Do Nothing$0.00$0
56SOUTH MAIN STREET #20.00000000000Do Nothing65YesSurface Wear. Transverse Cracking, Isolated Alligator Cracking, Distortions and PotholesMill & OverlayPossible Alternative Treatment Is Extensive Patching And Surface Seal. Surface Wear Related To Snow Plow Chatter.6,7705426176,02019,5580Mill & Overlay$24.17$472,711
30SOUTH MAIN STREET #30.00000000000Base Rehab70YesTransverse and Longitudinal, light AlligatorMill & OverlayBridge Section6991292618,1622,0180Mill & Overlay$24.17$48,775
130SOUTH MAIN STREET #40.00000000000Crack seal70YesTransverse and Longitudinal, light AlligatorMill & Overlay4021302811,2621,2510Mill & Overlay$24.17$30,245
80SOUTH MAIN STREET #60.00000000000Crack seal65YesTransverse and Longitudinal Cracking and Alligator Cracking, DistortionsMill & Overlay with some Full Depth Patching3,6857729106,86211,8740Mill & Overlay$26.17$310,731
49SOUTH MAIN STREET #70.00000000000Crack seal65YesTransverse and Longitudinal Cracking and Alligator Cracking, DistortionsMill & Overlay with some Full Depth Patching2,860472777,2158,5790Mill & Overlay$26.17$224,524
31SOUTH ROAD #10.00000000000Structural Improvement100YesNoneDo Nothing3,394292688,2449,8050Do Nothing$0.00$0
6SOUTH ROAD #20.00000000000Structural Improvement55YesAlligator Cracking Distortions Longitudinal CrackingReclaimPossible Alternative Treatment Is Overlay. Some Drainage Improvements Needed Regardless Of Treatment.2,85452879,9128,8790Reclaim$24.17$214,608
50SOUTH ROAD #50.00000000000Prep/thin overlay55YesTransverse and Longitudinal Cracking and Alligator Cracking, DistortionsMill & Overlay with some Full Depth PatchingReclaim Could Be A Better Alternative Test Pits Recommended, Some Drainage Improvements Required8,3944825209,85023,3170Mill & Overlay$26.17$610,197
27SOUTH STONY BROOK DRIVE0.00000000000Do Nothing90YesTransverse and Longitudinal Cracking, isolated PotholeCrack Seal and PatchCracks Are Well Sealed. Patch Is Needed In The Cul-De-Sac.4,4842630134,52014,9470Preservation$2.50$37,367
7STAETH ROAD0.00000000000Localized Repair40YesPotholes Distortions Alligator CrackingReclaimWill Need To Coordinate With East Hampton3056237,0157790Reclaim$24.17$18,839
137STAGE HARBOR ROAD0.00000000000Structural Improvement85YesLight Transverse and Longitudinal Cracking and Alligator CrackingCrack Seal2,1861373065,5807,2870Crack Seal$0.50$3,643
97STAGE HARBOR ROAD0.00000000000Structural Improvement90YesLight Transverse and Longitudinal CrackingDo NothingChip Seal Surface3,9219129113,70912,6340Do Nothing$0.00$0
74STANDISH DRIVE0.00000000000Mill & Overlay 1 1/2"90YesLight Transverse and Longitudinal CrackingDo NothingCrack Seal Within 5 Years1,740713052,1945,7990Do Nothing$0.00$0
132STONEY BROOK DRIVE0.00000000000Do Nothing90YesLongitudinal CrackingCrack Seal and PatchArea To Be Patched In Cul-De-Sac2,8141202981,6209,0690Preservation$2.50$22,672
100STURBRIDGE ROAD0.00000000000Crack Seal with Localized repair65YesTransverse and Longitudinal and Alligator Cracking, light DistortionsMill & Overlay1,115942932,3263,5920Mill & Overlay$24.17$86,814
69SURREY LANE0.00000000000Crack Seal with Localized repair65YesExtensive Alligator CrackingMill & OverlayConsider Rubber Chip Like Walnut?443672912,8471,4270Mill & Overlay$24.17$34,501
131THOMASSIAN DRIVE0.00000000000Crack Seal with Localized repair95YesLight Transverse and Longitudinal Cracking and Block CrackingDo NothingCracks Are Well Sealed2,0741192245,6225,0690Do Nothing$0.00$0
22VICTORIA LANE0.00000000000Crack seal85YesTransverse and Longitudinal Cracking and Alligator CrackingCrack SealRoad Has Been Extended Portion Does Not Exhibit The Same Level Of Distress644212818,0362,0040Crack Seal$0.50$1,002
0VICTORIA LANE0.00000000000Added95YesDo NothingNew Section1,0281232323,6402,6270Do Nothing$0.00$0
2VIRGINIA RAIL DRIVE0.00000000000Do Nothing85YesTransverse and Longitudinal Cracking, light DistortionsDo NothingCracks Are Well Sealed3,08112783,1849,2430Do Nothing$0.00$0
91WALKER LANE0.00000000000Crack Seal with Localized repair85YesTransverse and Longitudinal Cracking, light DistortionsCrack Seal905862018,0962,0110Crack Seal$0.50$1,005
70WALNUT DRIVE0.00000000000Prep/thin overlay90YesNoneDo NothingRecent Rubber Chip In Good Shape1,742682950,5185,6130Do Nothing$0.00$0
40WASHINGTON ROAD0.00000000000Do Nothing95YesIsolated CrackingDo Nothing48538209,7001,0780Do Nothing$0.00$0
23WEST ROAD #10.00000000000Crack Seal with Localized repair75YesTransverse and Longitudinal Cracking and Block CrackingCrack SealCrack Seal Recommended Spring Of 20201,022224040,8804,5420Crack Seal$0.50$2,271
115WEST ROAD #20.00000000000Crack Seal with Localized repair90YesTransverse CrackingCrack SealMuch Less Severe Cracking Then Section 12,0731063062,1906,9100Crack Seal$0.50$3,455
92WEST ROAD #30.00000000000Do Nothing80YesTransverse and Longitudinal Cracking, light DistortionsCrack SealOlder Micro Surface? Wearing Off In Several Locations. Crack Seal Now To Preserve But Expect To Need An Additional Treatment (Overlay ?) In Five Years.1,828872851,1845,6870Crack Seal$0.50$2,844
59WEST ROAD #40.00000000000Do Nothing75YesTransverse and Longitudinal Cracking, light Distortions, isolated patchingCrack Seal and PatchRoutine Maintenance Now To Preserve But Expect Another Treatment (Overlay ?) In 5 Years1,685572643,8104,8680Preservation$2.50$12,169
41WEST ROAD #50.00000000000Do Nothing70YesTransverse and Longitudinal Cracking, light Distortions, isolated Alligator CrackingOverlaySimilar To Sections To The South But More Severe Distresses2,807392775,8008,4220Preservation$6.16$51,881
13WEST ROAD #60.00000000000Do Nothing55YesHeavy Distortions, Alligator Cracking, RavelingStructural ImprovementConsider Cold In-Place Recycling. Old Chip Seal Has Worn Off In Many Places.4,7251224113,40012,6000Mill & Overlay$24.17$304,542
116WILHENGER DRIVE0.00000000000Base Rehab45YesExtensive Alligator Cracking and moderate DistortionsReclaim or Mill and Overlay1,3871072940,2234,4690Reclaim$24.17$108,021
60WILLIAMSBURG ROAD1283.00000000000Do Nothing90YesIsolated Transverse CrackingCrack Seal1,702582949,3585,4840Crack Seal$0.50$2,742
33WILLIAMSBURG ROAD2985.00000000000Crack Seal with Localized repair & Chipseal65YesTransverse and Longitudinal Cracking Block and Alligator CrackingMill & OverlayCould Try To Hold Together With Crack Sealing14331608,5809530Mill & Overlay$24.17$23,042
82WILLIAMSBURG ROAD0.00000000000Base Rehab65YesTransverse and Longitudinal Cracking and Alligator CrackingMill & Overlay1,283793038,4904,2770Mill & Overlay$24.17$103,367
Total Miles62Total Cost$5,701,186

&CPavement Segments Listing Marlborough, Connecticut&R&D Page &P of &N

Lookup Tables

ClassTraffic
AR5000
CO2500
RE200
RT1000PCI Drop/Year2.00
PCI
60
72
85
92
100
TreatmentEstimated LifePCI AfterUnit Cost (/sy)Life/Cost RatioSourceTreatment Band
Do Nothing199$0.00- 0HebronDo Nothing
Crack Seal495$0.508.00HebronCrack Seal
Isolated Patching299$2.001.00Same as PatchingPreservation
Patching299$2.001.00From UmassPreservation
Crack Seal and Patch495$2.501.60Crackseal + $2 for PatchPreservation30.33
Routine Maintenance495$2.501.60Same as Crack seal & PatchCrack Seal15.17
Surface Seal899$5.001.60Made it upPreservation
Overlay895$6.161.30HebronPreservation
Level and Overlay899$8.160.98Overlay + $2 for shimPreservation
Level and Rubber Chip899$8.160.98$2 for level, $2.50 for rubber chip (looked up on internet)Preservation
Level and Rubber Chip or Overlay899$8.160.98Same as level & OverlayPreservation
Shim and Overlay899$8.160.98Same as Level & OverlayPreservation
Patch & Overlay1099$8.161.23Overlay + $2 for patchngPreservation
Mill & Overlay or Overlay1599$15.170.99Split the cost between Overlay and Mill & OverlayMill & Overlay
Mill & Overlay1599$24.170.62HebronMill & Overlay
Reclaim2099$24.170.83HebronReclaim
Reclaim or Mill and Overlay2099$24.170.83Same as Mill & Overlay & ReclaimReclaim
Structural Improvement1599$24.170.62Same as Mill & OverlayMill & Overlay
Mill & Overlay with some Full Depth Patching1899$26.170.69Mill & Overlay +$2 for patchingMill & Overlay
Base Rehabilitation2599$30.000.83Used Norwalks costReclaim

Tables & Charts

Sum of Miles
0-400.1
41-452.0
46-502.6
51-553.0
56-603.1
61-655.2
65-704
71-754.8
76-804.0
81-8510.7
86-9010.2
91-958
96-1004.7
Grand Total61.6
Sum of Miles
TreatmentBandBasedOnRepairTotal
Do Nothing14.4
Crack Seal16.3
Preservation18.7
Mill & Overlay8.6
Reclaim3.5
Grand Total61.5
Sum of Total Cost
TreatmentBandBasedOnRepairTotalDollar Backlog
Do Nothing$00$0
Crack Seal$123,270123000$123,270$0
Preservation$1,102,5671103000$1,102,567
Mill & Overlay$3,128,2633128000$3,128,263
Reclaim$1,347,0861347086$1,347,086
Grand Total$5,701,186$5,701,186

Tables & Charts

0-40
41-45
46-50
51-55
56-60
61-65
65-70
71-75
76-80
81-85
86-90
91-95
96-100
Grand Total

Sum of Miles PCI Range Miles 0.1453265211 1.9933708212 2.561968664 3.0251899881 3.0899485441 5.2185585145 3.6011550715 4.8121178959 3.991439676 10.7051110356 10.1724014378 7.5256531822 4.7137800825 61.5560214345

Do Nothing
Crack Seal
Preservation
Mill & Overlay
Reclaim
Grand Total

Sum of Total Cost Total Cost by Treatment Band 123269.536184867 1102567.13176842 3128263.25261712 1347085.93224276 5701185.85281317

Do Nothing
Crack Seal
Preservation
Mill & Overlay
Reclaim
Grand Total

Sum of Miles Total 14.4168358668 16.2990620381 18.6953728385 8.5986782919 3.5105157377 61.520464773

File details come from the government source that posted it. Updated .