Appendix A1- Oakland TSC update Only Routine Patrols.xlsx

XLSX spreadsheet 17 KB Posted

Attached to
Routine and Emergency Carcass Removal
Solicitation number
RFP-591-200000001710-3
Issued by
Berrien County, Michigan

About this file

This file is an Excel spreadsheet (Appendix A1) detailing routine and as-needed patrol routes for the Oakland Transportation Service Center (TSC). The document outlines 31 specific road segments across Oakland County, Michigan, including interstate highways (I-96, I-696, I-75, I-275), US highways (US-24), and state routes (M-59, M-1, M-15, among others). The spreadsheet categorizes each route by name, geographic limits, mainline divided and undivided mileage, and whether the route requires routine or as-needed patrol coverage. The total system encompasses 148.58 miles of divided highway (one direction), 298.15 miles of divided highway (both directions), and 36.98 miles of undivided highway.

The document specifies that 303.871 miles are designated for routine patrol coverage, while approximately 46.63 miles are designated for as-needed patrol coverage. The routes are clearly defined with specific direction requirements, with some segments requiring patrol coverage in both directions while others require only single-direction coverage. Notable segments include major corridors such as I-96/M-5 from the West County Line to 8 Mile Road (38.50 miles both directions) and I-75 from M-15 to the North County Line (29.14 miles both directions).

View the file

Other files

File Type Posted
Appendix A3 - Macomb TSC Only Routine Patrol.xlsx XLSX spreadsheet
Schedule_A Oakland and Macomb 5 20 20.docx DOCX document
Appendix A2 - Oakland TSC Only (non routine patrol).xlsx XLSX spreadsheet
Macomb LSS Update.docx DOCX document
proposal-instructions-confidential-treatment-vendor-questions-worksheet6867 Dates 4 16.docx DOCX document
ATTACHMENT A - ARCGIS.pdf PDF
standard_contract_terms.docx DOCX document
LSS Metro - Oakland TSC 5 20 20.docx DOCX document
Region Map_Prosperity Regions.pdf PDF

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

Sheet1

OAKLAND TSC REQUIRED ROUTES

APPENDIX A1

Route NameLimitsMainline Divided (One Direction Miles)Mainline Divided (Both Directions Miles)Mainline Undivided (One Direction Miles)Routine Patrol (Yes/No)Routine Patrol (Miles)As-Neededl Patrol (Yes/No)As-Needed Patrol (Miles)Patrol In One/Both Direction(s)
I-96/M-5West County Line to 8 Mile Rd19.2538.500.00Yes38.50No0.00Both Directions
US-24 (Telegraph Rd)Square Lake Rd to 8 Mile Rd11.3322.660.00Yes22.66No0.00Both Directions
M-59Tipsico Lake Rd to Telegraph Rd7.3414.6811.00Yes18.34No0.00One Direction
M-59Telegraph Rd to E. Wide Track (Pontiac Loop)0.000.002.13No0.00Yes2.13One Direction
Auburn RdAdams Rd to Rochester Rd0.000.004.02No0.00Yes4.02One Direction
M-59E. Wide Track (Pontiac Loop) to Dequindre Rd10.2920.580.00Yes20.58No0.00Both Directions
M-1Square Lake Rd to Big Beaver Rd3.667.310.00Yes3.66No0.00One Direction
M-1Big Beaver Rd to 8 Mile Rd9.3618.710.00No0.00Yes9.36One Direction
US-24 (Telegraph Rd)Square Lake Rd to US-24 (Dixie Hwy)3.787.563.50Yes7.28No0.00One Direction
US-24 (Dixie Hwy)Telegraph Rd (US-24) to M-15 (Ortonville Rd)0.000.006.22Yes6.22No0.00One Direction
US-24 (Dixie Hwy)M-15 (Ortonville Road) to I-750.000.002.48Yes2.48No0.00One Direction
M-15County Line Rd to I-750.000.009.78Yes9.78No0.00One Direction
M-15Dixie Hwy (US-24) to I-750.000.001.80No0.00Yes1.80One Direction
M-108 Mile Rd to US-24 (Telegraph Rd)5.3210.640.00Yes10.64No0.00Both Directions
M-10US-24 (Telegraph Rd) to Orchard Lake Rd4.699.380.00Yes4.69No0.00One Direction
Perry StWide Track (Pontiac Loop) to M-24 (Lapeer Rd)0.000.003.54No0.00Yes3.54One Direction
I-696Mixing Bowl (I-696, I-96, I-275) to US-24 (Telegraph Rd)8.5917.180.00Yes17.18No0.00Both Directions
I-696US-24 (Telegraph Rd) to I-759.4018.800.00Yes18.80No0.00Both Directions
I-696I-75 to Dequindre Rd1.603.200.00No0.00Yes5.69Both Directions
Square Lake RdM-1 (Woodward Rd) to I-752.154.300.00Yes4.30No0.00Both Directions
M-24Perry St to W Davison Lake Rd11.7923.584.00Yes15.79No0.00One Direction
Lapeer Rd ConnectorM-24 (Lapeer Rd) - I-750.501.000.00Yes1.00No0.00Both Directions
M-150M-59 to Auburn Rd0.000.000.70No0.00Yes0.70One Direction
M-150M-59 to Tienken Rd0.000.004.11No0.00Yes4.11One Direction
M-1Wide Track (Pontiac Loop) to US-24 (Telegraph Rd)2.174.340.00No0.00Yes2.17One Direction
M-398 Mile Rd to Northwester Hwy (M-10)1.272.540.00No0.00Yes2.81Both Directions
I-75M-59 to M-15 (Ortonville Rd)13.4126.820.00Yes26.82No0.00Both Directions
I-75M-15 (Ortonville Rd) to North County Line (Genessee)14.5729.140.00Yes29.14No0.00Both Directions
I-7514 Mile Rd to M-5912.6125.220.00Yes25.22No0.00Both Directions
I-275/I-968 Mile Rd to I-6964.108.200.00Yes8.20No0.00Both Directions
M-5Mixing Bowl (I-696, I-96, I-275) to Pontiac Trail6.3012.600.00Yes12.60No0.00Both Directions
BL75/BR24/M59Pontiac Loop0.000.002.34No0.00Yes2.34One Direction
Cass AveCesar E Chavez to Woodward Loop0.000.001.18No0.00Yes1.18One Direction
Cesar E Chavez Ave(US-24) Telegraph Rd to Woodward Loop0.260.522.13No0.00Yes2.39One Direction
Grand River AveI-275 to M-50.390.793.99No0.00Yes4.39One Direction
Totals148.58298.1536.98303.871

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