# RUN REPORT: Rockport, Indiana to Louisville, step 3 engine (local OSM store, RoadAuthority, NLCD pavement, NHD and FRA crossings)

Run 2026-10-03T14:41:41.  Code `engine\` (`run_project.py rockport-louisville`), outputs `_Working\runs\rockport-louisville\`.  Total wall time 137.02 s before the screenshot.

## Rates in use: this project's overrides from the bid workbook

- Overrides file `engine\projects\rockport-louisville\assumptions_overrides.json`, existing file kept (pass --rebuild-overrides to regenerate from the bid).  Source: `BID CALC - HYPERLINK-ROCKPORT - QTS - ROCKPORT INDIANA - v2026.09.17.Final.xlsx`, sheet `CONSTRUCTION LABOR BID`, unit cost block (header row 257), segment 3 (column J: ROCKPORT, IN to LOUISVILLE).
- Base rate (bore class 2 dirt) $12.00 per ft (template default $12.00).  Rates the bid left blank fall back to the default multiple times this base: none.

| Rate | This project (bid) | Template default |
|:--|--:|--:|
| Bore class 1 | $12.00 | $12.00 |
| Bore class 2 | $12.00 | $12.00 |
| Bore class 3 | $12.00 | $12.00 |
| Bore class 4 | $16.00 | $20.00 |
| Bore class 5 | $25.00 | $30.00 |
| Bore class 6 | $35.00 | $45.00 |
| Bore class 7 | $45.00 | $60.00 |
| Bore class 8 | $100.00 | $200.00 |
| Bore class 9 | $175.00 | $450.00 |
| Trench class 1 | $5.00 | $5.50 |
| Trench class 2 | $5.00 | $5.50 |
| Trench class 3 | $6.00 | $10.00 |
| Trench class 4 | $10.00 | $15.00 |
| Trench class 5 | $12.00 | $20.00 |
| Trench class 6 | $16.00 | $25.00 |
| Trench class 7 | $22.00 | $35.00 |
| Crossing tier1 | $360.00 | $360.00 |
| Crossing tier2 | $150.00 | $175.00 |
| Crossing tier3 | $75.00 | $75.00 |

## A and Z

- Source: `Example - Rockport IN\QTS_Rockport Indiana.kmz`, KMZ line 'Rockport to Louisville_Flex' (3 lines in the file; selected by name); A = last vertex of the line as drawn.
- A (lon, lat) = (-86.991996, 37.944773) (A Rockport IN).  Z = (-85.732979, 38.242618) (Z Louisville).
- Human route length from the KMZ: 487,368 ft = 92.30 mi (1481 vertices, geodesic).  Bid footage for this segment: 492,635 ft (`CONSTRUCTION LABOR BID!J94`).
- Snapped to graph nodes 181714331 (379 ft away) and 164942420 (235 ft away).

## Corridor graph (local Geofabrik store, no Overpass)

- bbox (left, bottom, right, top) = (-87.21243, 37.77086, -85.51255, 38.41653), pad 12 mi, network drive, source pickle cache of local Geofabrik store (osm_store.py).
- Store read: 148,050 ways from IN, KY in 11.4 s, 49,281 after de-duplication and the drive filter; graph build (chain merge on OSM node ids, split on highway, bridge, toll) 16.49 s: 639,650 segments and 620,950 nodes in the bbox to 65,316 nodes and 81,842 edges; **corridor total 28.72 s** (store timestamps {'IN': '2026-09-20T20:22:06Z', 'KY': '2026-09-20T20:22:06Z'}).
- Routing graph 64,704 nodes, 81,388 edges, 13,201 road miles; bridge edges 1602, toll edges 113.

## Incorporated places

- `Places_Incorporated_2025` (EPSG:26914), 157 places in the bbox, read in 0.03 s: Alfordsville town, Alton town, Anchorage city, Audubon Park city, Bancroft city, Barbourmeade city, Bardstown city, Beechwood Village city, Bellemeade city, Bellewood city, Birdseye town, Blue Ridge Manor city, Boonville city, Borden town, Brandenburg city, Briarwood city, Broeck Pointe city, Brownsboro Farm city, Brownsboro Village city, Cambridge city, Cannelton city, Charlestown city, Chrisney town, Clarksville town, Cloverport city, Coldstream city, Corydon town, Crandall town, Creekside city, Crestwood city, Crossgate city, Dale town, Douglass Hills city, Druid Hills city, Ekron city, Elizabeth town, Elizabethtown city, English town, Ferdinand town, Fincastle city, Forest Hills city, Fox Chase city, French Lick town, Gentryville town, Georgetown town, Glenview Hills city, Glenview Manor city, Glenview city, Goose Creek city, Goshen city, Grandview town, Graymoor-Devondale city, Green Spring city, Greenville town, Hardinsburg city, Hawesville city, Hebron Estates city, Heritage Creek city, Hickory Hill city, Hills and Dales city, Hillview city, Holland town, Hollow Creek city, Hollyvilla city, Houston Acres city, Hunters Hollow city, Huntingburg city, Hurstbourne Acres city, Hurstbourne city, Indian Hills city, Irvington city, Jasper city, Jeffersontown city, Jeffersonville city, Kingsley city, La Grange city, Laconia town, Lanesville town, Langdon Place city, Leavenworth town, Lebanon Junction city, Lewisport city, Lincolnshire city, Louisville city, Louisville/Jefferson County metro government (balance), Lyndon city, Lynnview city, Manor Creek city, Marengo town, Maryhill Estates city, Mauckport town, Meadow Vale city, Meadowbrook Farm city, Meadowview Estates city, Middletown city, Milltown town, Mockingbird Valley city, Moorland city, Mount Washington city, Muldraugh city, Murray Hill city, New Albany city, New Amsterdam town, New Haven city, New Middletown town, Norbourne Estates city, Northfield city, Norwood city, Old Brownsboro Place city, Orchard Grass Hills city, Owensboro city, Palmyra town, Parkway Village city, Pewee Valley city, Pioneer Village city, Plantation city, Poplar Hills city, Prospect city, Radcliff city, Richland town, Richlawn city, River Bluff city, Riverwood city, Rockport city, Rolling Fields city, Rolling Hills city, Santa Claus town, Sellersburg town, Seneca Gardens city, Shepherdsville city, Shively city, South Park View city, Spring Mill city, Spring Valley city, St. Matthews city, St. Regis Park city, Strathmoor Manor city, Strathmoor Village city, Sycamore city, Tell City city, Ten Broeck city, Tennyson town, Thornhill city, Troy town, Utica town, Vine Grove city, Watterson Park city, Wellington city, West Buechel city, West Point city, Westwood city, Wildwood city, Windy Hills city, Winslow town, Woodland Hills city, Woodlawn Park city, Worthington Hills city.
- 57,643 of 81,388 edges (42.2% of corridor footage) are inside a place (midpoint test, 2.58 s).  Top: Louisville/Jefferson County metro government (balance) 9,212,064 ft, Louisville city 5,622,315 ft, Jeffersonville city 1,747,686 ft, New Albany city 1,075,826 ft, Jeffersontown city 814,960 ft, Clarksville town 724,483 ft.

## Soils

- 81,388 edges, 1,434,476 sample points every 50 ft, one window read of `CONUS_soilbid9_10m.tif` ([8674, 15362], 133.2 MB) in 0.19 s.  Corridor share by class: 1 1.7%, 2 27.7%, 3 11.2%, 4 1.1%, 5 23.6%, 6 5.3%, 7 9.2%, 8 0.7%, 11 0.6%, 12 18.8%.

## Pavement (new, Annual NLCD Fractional Impervious Surface 2025)

- `Annual_NLCD_FctImp_2025_CU_C1V2.tif`: 30 m percent impervious, window [2902, 5131] (14.9 MB) read in 0.03 s over the same 1,434,476 sample points; 0 nodata samples treated as 0 percent.
- The percent used is the mean of a 11 by 11 cell box (150 m each side of the sample, 0.1 s), not the cell under the road: the road's own cell reads 10 to 40 percent on any paved highway.  Corridor footage by bin, neighborhood: rural 50.5%, suburban 30.8%, urban 15.9%, dense 2.8%; by the raw centerline cell it would have been rural 21.6%, suburban 45.6%, urban 26.0%, dense 6.8%.  Edges whose neighborhood mean is 10 percent or more: 64,089 of 81,388 (centerline cell: 74,654).
- Used twice: the metro multiplier per edge is the footage-weighted mix of bin multipliers (rural 1.0, suburban 1.05, urban 1.2, dense 1.5, placeholders until step 4), and the not-bore rule now requires the edge mean under 10 percent.  Trench allowed on 48.0% of corridor footage under `place_pavement_soil`.

## Permitting authority (new, FiberBid RoadAuthority join)

- `RoadAuthority` bbox read: 82,855 HPMS 2024 segments in 10.76 s; classes {'state_dot': 43083, 'municipal': 20812, 'county': 12072, 'private': 4598, 'federal_agency': 1256, 'unknown': 794, 'other_public': 240}; confidence {'rule_verified': 75967, 'inferred': 6094, 'unknown': 794}.
- Join: nearest segment within 30 m at 25, 50 and 75 percent of each edge; **76,558 of 81,388 edges matched, 93.8% of footage** (6.53 s).  Unmatched footage takes municipal inside a place, else county.
- Corridor footage by permit class: county 31,504,794 ft, municipal 21,841,001 ft, state_dot 10,980,112 ft, interstate 3,369,271 ft, federal_or_tribal 1,905,218 ft, toll 102,171 ft.
- Top authorities by footage: Louisville/Jefferson County metro government (balance) 4,765,834 ft, Harrison County 4,467,048 ft, Louisville city 4,084,546 ft, Spencer County 3,569,341 ft, VINCENNES 2,999,280 ft, Private owner / HOA 2,652,374 ft, Perry County 2,485,436 ft, Crawford County 2,352,048 ft.

## Crossings (new: NHD water, FRA rail, FEMA floodway, USACE navigable)

- NHD (IN, KY): 1,498 water polygons ({'LakePond': 935, 'Reservoir': 519, 'StreamRiver': 41, 'CanalDitch': 3}) and 128,629 flowlines ({'intermittent': 60320, 'artificial path': 35077, 'perennial': 21459, 'canal/ditch': 11771, 'ephemeral': 2}) in the bbox, read in 11.46 s.
- FRA grade crossings in the bbox: 1380 ({'At Grade': 1161, 'RR Over': 123, 'RR Under': 96}).  FEMA floodway polygons: 293 of 35,860 flood zone polygons.  USACE navigable waterway links: 10 (OHIO RIVER 9, GREEN RIVER 1).
- Detection on all 81,388 edges in 74.49 s: crossings by kind {'rail': 788, 'water': 2157, 'dry_bridge': 798}; edges with a crossing 3,639; edges with only minor (intermittent, ephemeral, canal) flowline hits and no bridge, counted but not tiered: 5,970; floodway edges 1611, navigable edges 13, rail-over-road flags 90.
- Rules (assumptions `crossings`): polygon water on the edge: length = intersection ft (a bridge edge uses at least its own length); else a bridge edge over any flowline: length = bridge edge length; else a perennial flowline with no bridge: no_bridge_perennial_ft; minor (intermittent, ephemeral, canal) flowlines with no bridge are counted and flagged, not tiered, unless tier_minor_without_bridge is true.  Rail: At Grade: rail crossing of at_grade_ft on the nearest edge within join_max_m; RR Under (road bridge over rail): rail crossing of rr_under_ft (the bore under the tracks and the embankment, not the whole bridge; a 776 ft overpass at FM 1788 near Midland priced as Tier 2 rail before this, 2026-09-21); RR Over (rail bridge over the road): flag only.  Forced Tier 1: a water crossing within navigable_within_m of the USACE navigable waterway network is Tier 1 at any length (the Corps Section 10 rule). A water crossing on an edge inside a FEMA floodway polygon is Tier 1 when it is a real crossing of the floodway stream: polygon water or a bridge, at least floodway_min_ft long. A culvert-class default crossing of a side creek inside a wide floodway keeps its own tier (Ohio River bottoms finding, 2026-09-21).
- Priced at a tier across the whole graph: {'tier3': 2940, 'tier2': 53, 'tier1': 27} by tier, {'rail': 788, 'water': 2157, 'dry': 75} by kind.

## GeoTel carrier routes

- 40,386 features in the bbox in 0.26 s.  Named carriers found: ARELION, AT&T, COGENT, CROWN CASTLE, LUMEN, MOX, SEGRA, UNITI, VERIZON, ZAYO; not present: FIBERLIGHT.
- Corridor shared footage (within 250 ft of a named carrier): 13,658,732 ft (19.6%); by carrier AT&T 7,291,509 ft, UNITI 5,541,752 ft, LUMEN 2,889,693 ft, ZAYO 2,650,891 ft, MOX 855,722 ft, VERIZON 684,386 ft, COGENT 331,295 ft, ARELION 252,077 ft, SEGRA 142,210 ft, CROWN CASTLE 56,962 ft.

## Timings (seconds)

| Step | Seconds |
|:--|--:|
| Assumptions build | 1.04 |
| Corridor total (store read plus graph build, or pickle load) | 1.48 |
| Places total | 2.65 |
| Soils total | 1.91 |
| Pavement total | 0.76 |
| Road authority total | 17.58 |
| Crossings total | 88.81 |
| Carriers total | 16.96 |
| Pricing | 0.66 |
| Spread (all solves and bookkeeping) | 2.7 |
| Dijkstra solves only | 2.651 |
| Route diversity | 0.036 |
| Shared segments | 0.22 |
| Comparison (human route) | 0.74 |
| Outputs (KMZ, HTML) | 1.16 |
| Total before the screenshot | 137.02 |

## Kept routes

Spread settings: penalty 1.3, overlap max 0.7, detour cap 1.35 times the shortest kept, max 20 routes, max 60 iterations.  20 solves, 20 kept, 0 pruned by the final cap.  R01 is the cheapest kept route.  Dollars are at this project's rates.

| Route | Miles | Dollars | $/ft | Diversity % | Shared ft | Longest shared run ft | Carriers (ft within 250 ft) | Crossing $ | Tiered crossings (water, rail, dry) | Tier 1 | Worst crossing | Permit $ | Trench ft | Bore ft | Metro ft | Inside place ft | county ft | state_dot ft | municipal ft | interstate ft | toll ft | federal_or_tribal ft | Overlap vs R01 | residential mi | secondary mi | motorway mi | unclassified mi | primary mi | tertiary mi | trunk mi |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R01 | 95.68 | $7,533,928 | 14.91 | 91.2% | 44,423 | 14,589 | AT&T 34,229; UNITI 21,886; ZAYO 10,128; LUMEN 7,721; CROWN CASTLE 1,925; VERIZON 1,692; ARELION 489; COGENT 489; MOX 484 | $1,771,649 | 20 (17, 3, 0) | 1 | Tier 1 water 4,323 ft Ohio River; StreamRiver on Sherman Minton Bridge $1,556,315 (forced Tier 1: USACE navigable waterway) | $254,291 | 375,693 | 129,486 | 226,252 | 52,864 | 255,424 | 173,266 | 12,932 | 42,820 | 0 | 20,737 | 100.0% | 21.6 | 21.5 | 8.1 | 25.8 | 18.1 | 0.6 | 0.0 |
| R02 | 92.97 | $8,221,909 | 16.75 | 87.8% | 59,807 | 21,173 | AT&T 38,669; ZAYO 29,816; UNITI 22,113; LUMEN 8,310; MOX 6,679; VERIZON 5,577; ARELION 704; COGENT 556 | $1,387,168 | 24 (20, 2, 2) | 1 | Tier 1 water 2,643 ft Ohio River; StreamRiver on Abraham Lincoln Bridge $951,651 (forced Tier 1: USACE navigable waterway) | $820,293 | 192,651 | 298,238 | 328,902 | 59,093 | 172,074 | 33,178 | 26,164 | 243,438 | 5,582 | 10,453 | 0.1% | 17.2 | 6.3 | 47.1 | 12.2 | 7.9 | 2.3 | 0.0 |
| R03 | 91.33 | $8,963,129 | 18.59 | 89.3% | 51,417 | 26,587 | UNITI 36,690; AT&T 33,890; LUMEN 5,340; ZAYO 2,589; VERIZON 1,908; CROWN CASTLE 978; MOX 516; ARELION 489; COGENT 489 | $1,945,034 | 26 (23, 3, 0) | 1 | Tier 1 water 4,449 ft Ohio River; StreamRiver on Sherman Minton Bridge $1,601,543 (forced Tier 1: USACE navigable waterway) | $742,751 | 209,755 | 272,486 | 322,442 | 54,786 | 152,665 | 65,414 | 33,028 | 222,602 | 0 | 8,532 | 2.2% | 21.4 | 18.2 | 42.1 | 5.5 | 1.3 | 2.9 | 0.0 |
| R04 | 100.63 | $8,361,577 | 15.74 | 81.0% | 100,729 | 23,964 | LUMEN 48,870; VERIZON 47,300; UNITI 39,645; AT&T 29,048; ZAYO 28,071; MOX 4,294; COGENT 541; ARELION 536 | $1,773,803 | 42 (37, 2, 3) | 1 | Tier 1 water 3,158 ft Ohio River; StreamRiver on John F. Kennedy Memorial Bridge $1,136,957 (forced Tier 1: USACE navigable waterway) | $271,468 | 411,690 | 119,641 | 157,870 | 90,148 | 221,556 | 210,200 | 47,698 | 6,110 | 6,565 | 39,202 | 8.2% | 47.0 | 30.0 | 2.3 | 0.0 | 13.4 | 7.9 | 0.0 |
| R05 | 95.91 | $9,312,088 | 18.39 | 78.0% | 111,497 | 53,298 | UNITI 73,650; ZAYO 37,033; AT&T 22,937; LUMEN 6,744; CROWN CASTLE 1,474; VERIZON 1,465; MOX 665; COGENT 575; ARELION 479 | $1,994,256 | 24 (22, 2, 0) | 1 | Tier 1 water 4,449 ft Ohio River; StreamRiver on Sherman Minton Bridge $1,601,543 (forced Tier 1: USACE navigable waterway) | $853,175 | 155,574 | 350,813 | 373,661 | 77,230 | 92,865 | 129,619 | 17,818 | 266,084 | 0 | 0 | 6.1% | 19.2 | 10.2 | 50.4 | 0.5 | 14.4 | 0.9 | 0.3 |
| R06 | 105.99 | $8,461,563 | 15.12 | 72.4% | 154,677 | 30,801 | AT&T 95,569; ZAYO 63,194; UNITI 34,019; LUMEN 19,518; VERIZON 10,412; MOX 4,532; COGENT 1,748; ARELION 731 | $1,420,235 | 42 (37, 3, 2) | 1 | Tier 1 water 2,643 ft Ohio River; StreamRiver on Abraham Lincoln Bridge $951,651 (forced Tier 1: USACE navigable waterway) | $208,386 | 445,513 | 114,101 | 199,857 | 80,663 | 346,065 | 122,963 | 54,726 | 4,598 | 9,776 | 21,486 | 0.1% | 45.2 | 17.4 | 2.7 | 22.4 | 9.4 | 4.4 | 4.4 |
| R07 | 102.36 | $8,836,690 | 16.35 | 85.0% | 81,159 | 19,226 | ZAYO 62,634; UNITI 39,700; AT&T 17,687; LUMEN 9,060; VERIZON 2,331; CROWN CASTLE 1,342; MOX 596; ARELION 526; COGENT 526 | $1,796,419 | 35 (32, 3, 0) | 1 | Tier 1 water 4,313 ft Ohio River; StreamRiver on motorway $1,552,658 (forced Tier 1: USACE navigable waterway) | $223,766 | 437,134 | 103,346 | 178,638 | 58,901 | 349,111 | 111,716 | 23,192 | 43,388 | 0 | 13,071 | 0.3% | 55.1 | 16.7 | 8.1 | 13.4 | 5.1 | 4.0 | 0.0 |
| R08 | 103.65 | $8,804,762 | 16.09 | 83.6% | 89,598 | 24,386 | UNITI 55,241; ZAYO 43,863; AT&T 41,051; LUMEN 6,364; VERIZON 3,408; CROWN CASTLE 994; MOX 679; COGENT 537; ARELION 489 | $1,861,722 | 29 (26, 3, 0) | 1 | Tier 1 water 4,323 ft Ohio River; StreamRiver on Sherman Minton Bridge $1,556,315 (forced Tier 1: USACE navigable waterway) | $405,736 | 363,707 | 183,558 | 239,199 | 49,748 | 333,725 | 61,260 | 33,088 | 119,193 | 0 | 0 | 12.0% | 45.7 | 12.5 | 22.6 | 12.8 | 2.3 | 7.7 | 0.0 |
| R09 | 104.82 | $9,027,882 | 16.31 | 87.1% | 71,213 | 15,044 | UNITI 43,283; ZAYO 42,084; AT&T 28,631; LUMEN 10,510; VERIZON 1,505; CROWN CASTLE 1,440; MOX 643; COGENT 575; ARELION 479 | $1,997,602 | 26 (19, 6, 1) | 1 | Tier 1 water 4,323 ft Ohio River; StreamRiver on Sherman Minton Bridge $1,556,315 (forced Tier 1: USACE navigable waterway) | $335,248 | 409,312 | 144,157 | 266,978 | 69,119 | 268,990 | 171,225 | 26,610 | 48,505 | 0 | 38,139 | 36.2% | 29.3 | 20.3 | 9.1 | 20.3 | 21.0 | 4.9 | 0.0 |
| R10 | 108.50 | $8,805,271 | 15.37 | 71.1% | 165,753 | 83,210 | AT&T 103,065; LUMEN 100,510; UNITI 56,378; VERIZON 4,328; ZAYO 3,695; CROWN CASTLE 2,014; COGENT 1,294; ARELION 1,197; MOX 536 | $1,557,666 | 36 (26, 9, 1) | 1 | Tier 1 water 2,728 ft Ohio River; StreamRiver; artificial path on Lincoln Trail Bridge $981,954 (forced Tier 1: USACE navigable waterway) | $167,008 | 351,725 | 221,131 | 329,774 | 177,492 | 69,654 | 476,456 | 26,746 | 0 | 0 | 0 | 8.4% | 15.0 | 44.9 | 0.0 | 0.0 | 17.7 | 9.5 | 21.3 |
| R11 | 106.46 | $9,024,899 | 16.06 | 87.1% | 72,689 | 17,518 | AT&T 45,502; UNITI 26,613; ZAYO 21,921; LUMEN 15,579; VERIZON 10,092; CROWN CASTLE 1,604; COGENT 585; ARELION 539; MOX 530 | $1,897,281 | 38 (36, 2, 0) | 1 | Tier 1 water 4,449 ft Ohio River; StreamRiver on Sherman Minton Bridge $1,601,543 (forced Tier 1: USACE navigable waterway) | $239,749 | 466,945 | 95,165 | 152,408 | 55,021 | 395,325 | 73,964 | 29,003 | 34,970 | 0 | 28,850 | 0.3% | 51.9 | 15.1 | 6.6 | 25.5 | 1.2 | 5.4 | 0.7 |
| R12 | 103.34 | $9,398,943 | 17.23 | 83.2% | 91,727 | 37,449 | UNITI 58,938; AT&T 54,596; ZAYO 32,269; LUMEN 21,412; VERIZON 18,658; MOX 585; ARELION 536; COGENT 500 | $2,282,944 | 43 (31, 11, 1) | 1 | Tier 1 water 4,897 ft Ohio River; StreamRiver on Clark Memorial Bridge $1,762,917 (forced Tier 1: USACE navigable waterway) | $319,489 | 368,299 | 177,319 | 245,128 | 75,896 | 333,988 | 76,372 | 51,998 | 71,348 | 0 | 11,912 | 11.3% | 41.4 | 16.9 | 13.5 | 18.4 | 7.2 | 5.9 | 0.0 |
| R13 | 108.14 | $9,681,365 | 16.96 | 86.1% | 79,502 | 18,135 | AT&T 49,282; UNITI 43,882; ZAYO 43,259; LUMEN 18,574; VERIZON 15,233; MOX 535; ARELION 514; COGENT 500 | $2,230,865 | 28 (25, 1, 2) | 1 | Tier 1 water 4,897 ft Ohio River; StreamRiver on Clark Memorial Bridge $1,762,917 (forced Tier 1: USACE navigable waterway) | $329,616 | 430,729 | 140,270 | 172,353 | 83,394 | 346,522 | 76,744 | 65,050 | 28,279 | 0 | 54,404 | 0.3% | 62.4 | 11.3 | 5.3 | 6.8 | 7.0 | 15.3 | 0.0 |
| R14 | 108.95 | $9,623,015 | 16.73 | 63.2% | 211,860 | 40,621 | ZAYO 161,908; UNITI 106,683; AT&T 59,377; LUMEN 6,756; MOX 5,825; VERIZON 3,435; COGENT 1,231; ARELION 734 | $1,553,515 | 38 (32, 2, 4) | 1 | Tier 1 water 3,158 ft Ohio River; StreamRiver on John F. Kennedy Memorial Bridge $1,136,957 (forced Tier 1: USACE navigable waterway) | $156,147 | 439,036 | 136,234 | 241,508 | 92,611 | 342,082 | 178,846 | 37,407 | 4,920 | 12,015 | 0 | 0.5% | 51.4 | 11.3 | 3.2 | 11.1 | 21.5 | 3.4 | 7.2 |
| R15 | 113.95 | $9,270,496 | 15.41 | 82.0% | 108,243 | 43,100 | LUMEN 53,764; VERIZON 49,637; AT&T 28,043; SEGRA 26,861; UNITI 11,025; ZAYO 4,322; CROWN CASTLE 1,922; MOX 528; ARELION 491; COGENT 491 | $1,901,551 | 31 (29, 2, 0) | 1 | Tier 1 water 4,313 ft Ohio River; StreamRiver on motorway $1,552,658 (forced Tier 1: USACE navigable waterway) | $304,193 | 497,340 | 104,316 | 137,131 | 84,043 | 351,372 | 126,996 | 49,415 | 16,796 | 0 | 57,078 | 1.2% | 57.2 | 18.6 | 3.2 | 8.2 | 8.3 | 18.4 | 0.0 |
| R16 | 114.53 | $9,795,856 | 16.20 | 71.0% | 175,071 | 106,400 | ZAYO 127,566; UNITI 61,454; AT&T 24,132; MOX 5,064; LUMEN 2,811; VERIZON 1,648; ARELION 696; COGENT 627 | $1,368,027 | 36 (24, 9, 3) | 1 | Tier 1 water 2,643 ft Ohio River; StreamRiver on Abraham Lincoln Bridge $951,651 (forced Tier 1: USACE navigable waterway) | $299,679 | 436,502 | 168,201 | 253,106 | 92,552 | 396,149 | 71,475 | 68,765 | 60,707 | 7,606 | 0 | 0.0% | 56.1 | 9.0 | 12.8 | 21.5 | 8.2 | 6.9 | 0.0 |
| R17 | 113.01 | $9,952,433 | 16.68 | 59.7% | 240,674 | 87,606 | LUMEN 160,813; AT&T 156,426; UNITI 149,330; VERIZON 4,705; ARELION 1,179; COGENT 1,179; MOX 534; ZAYO 338 | $2,434,835 | 44 (32, 10, 2) | 1 | Tier 1 water 4,593 ft Ohio River; StreamRiver on William H. Natcher Bridge $1,653,641 (forced Tier 1: USACE navigable waterway) | $221,942 | 367,059 | 229,610 | 310,017 | 154,993 | 139,727 | 407,666 | 22,947 | 0 | 0 | 26,330 | 0.0% | 23.5 | 13.0 | 0.0 | 8.5 | 8.1 | 24.6 | 35.2 |
| R18 | 117.05 | $10,368,402 | 16.78 | 65.4% | 214,128 | 25,100 | AT&T 149,582; UNITI 71,140; LUMEN 66,049; VERIZON 18,538; ZAYO 11,950; ARELION 538; MOX 493; COGENT 489 | $2,513,245 | 45 (32, 12, 1) | 1 | Tier 1 water 4,588 ft Ohio River; StreamRiver on William H. Natcher Bridge $1,651,511 (forced Tier 1: USACE navigable waterway) | $129,361 | 411,117 | 206,888 | 255,867 | 147,115 | 259,467 | 322,577 | 35,854 | 106 | 0 | 0 | 0.0% | 36.9 | 23.4 | 0.0 | 10.0 | 4.5 | 23.4 | 18.9 |
| R19 | 123.29 | $10,380,153 | 15.95 | 76.0% | 156,217 | 53,974 | AT&T 122,095; UNITI 101,007; LUMEN 66,305; MOX 1,074; COGENT 600; ARELION 556; VERIZON 494; ZAYO 338 | $2,317,515 | 31 (26, 4, 1) | 1 | Tier 1 water 4,593 ft Ohio River; StreamRiver on William H. Natcher Bridge $1,653,641 (forced Tier 1: USACE navigable waterway) | $417,312 | 467,698 | 183,290 | 287,589 | 106,407 | 79,658 | 450,645 | 38,065 | 0 | 0 | 82,620 | 0.0% | 15.1 | 38.4 | 0.0 | 0.7 | 4.8 | 40.9 | 23.4 |
| R20 | 118.27 | $10,844,770 | 17.37 | 62.5% | 234,040 | 39,662 | ZAYO 162,497; UNITI 122,447; AT&T 73,475; LUMEN 4,625; MOX 4,294; VERIZON 1,191; ARELION 704; COGENT 541 | $1,634,221 | 55 (35, 17, 3) | 1 | Tier 1 water 3,158 ft Ohio River; StreamRiver on John F. Kennedy Memorial Bridge $1,136,957 (forced Tier 1: USACE navigable waterway) | $200,380 | 465,534 | 158,927 | 260,598 | 88,649 | 384,755 | 156,417 | 51,047 | 11,881 | 7,190 | 13,171 | 0.1% | 61.1 | 11.2 | 3.6 | 11.2 | 19.3 | 7.0 | 4.9 |

Soil footage per kept route (ft):

| Route | Soil 1 | Soil 2 | Soil 3 | Soil 4 | Soil 5 | Soil 6 | Soil 7 | Soil 10 | Soil 11 | Soil 12 | Flagged ft |
|---|---|---|---|---|---|---|---|---|---|---|---|
| R01 | 114,262 | 122,137 | 42,116 | 16,237 | 101,742 | 25,667 | 44,984 | 1,884 | 248 | 35,903 | 35,086 |
| R02 | 203,738 | 93,195 | 39,343 | 4,491 | 66,155 | 23,964 | 15,397 | 2,569 | 9,735 | 32,301 | 40,317 |
| R03 | 156,650 | 102,396 | 31,514 | 8,081 | 64,858 | 54,321 | 22,319 | 2,032 | 250 | 39,820 | 38,828 |
| R04 | 3,769 | 155,934 | 52,036 | 25,967 | 114,250 | 51,961 | 63,566 | 2,894 | 8,443 | 52,510 | 58,535 |
| R05 | 235,225 | 82,255 | 17,938 | 744 | 66,666 | 4,539 | 29,250 | 1,988 | 250 | 67,533 | 66,465 |
| R06 | 26,753 | 107,370 | 68,474 | 17,925 | 138,416 | 38,837 | 79,901 | 2,371 | 11,492 | 68,073 | 77,346 |
| R07 | 34,839 | 154,225 | 46,997 | 8,023 | 107,621 | 56,618 | 92,754 | 2,135 | 198 | 37,069 | 36,244 |
| R08 | 108,872 | 113,461 | 59,283 | 4,237 | 116,037 | 39,255 | 49,977 | 1,883 | 248 | 54,011 | 53,095 |
| R09 | 111,255 | 128,062 | 31,057 | 12,289 | 125,177 | 42,689 | 64,084 | 1,974 | 248 | 36,633 | 35,692 |
| R10 | 5,838 | 195,699 | 93,911 | 1,545 | 114,392 | 14,613 | 54,928 | 2,587 | 0 | 89,342 | 88,876 |
| R11 | 26,458 | 144,252 | 52,258 | 27,707 | 124,965 | 75,123 | 75,340 | 2,050 | 250 | 33,708 | 32,890 |
| R12 | 59,461 | 90,147 | 59,715 | 8,774 | 140,547 | 53,938 | 49,216 | 3,486 | 6,291 | 74,043 | 76,986 |
| R13 | 29,126 | 107,464 | 65,448 | 27,884 | 132,388 | 46,429 | 76,284 | 3,932 | 12,338 | 69,705 | 78,298 |
| R14 | 3,224 | 133,751 | 57,191 | 5,632 | 126,745 | 66,282 | 101,934 | 2,388 | 15,154 | 62,969 | 76,035 |
| R15 | 8,015 | 178,852 | 66,322 | 16,174 | 159,182 | 49,552 | 71,485 | 2,406 | 2,618 | 47,050 | 48,393 |
| R16 | 47,779 | 103,118 | 71,970 | 20,419 | 165,701 | 41,342 | 87,804 | 2,451 | 8,923 | 55,196 | 62,542 |
| R17 | 300 | 213,424 | 86,531 | 1,891 | 127,933 | 192 | 72,933 | 3,234 | 0 | 90,231 | 89,905 |
| R18 | 3,700 | 210,568 | 92,031 | 2,939 | 175,066 | 5,528 | 69,964 | 3,261 | 0 | 54,948 | 54,153 |
| R19 | 300 | 241,434 | 123,290 | 977 | 135,655 | 5,637 | 84,451 | 3,664 | 0 | 55,580 | 55,305 |
| R20 | 9,870 | 128,119 | 53,646 | 3,118 | 205,522 | 60,012 | 104,670 | 2,445 | 9,804 | 47,254 | 55,165 |

Every crossing priced at a tier on the cheapest route (R01):

| Tier | Kind | Name | Road | Length ft | Dollars | Forced Tier 1 | Detection |
|:--|:--|:--|:--|--:|--:|:--|:--|
| tier1 | water | Ohio River; StreamRiver | Sherman Minton Bridge | 4,323 | $1,556,315 | USACE navigable waterway | NHD polygon intersection (bridge length used, longer) |
| tier3 | water | Anderson River; StreamRiver | State Road 66 | 374 | $28,076 |  | NHD polygon intersection (bridge length used, longer) |
| tier3 | water | Little Blue River; StreamRiver | East Camp Jerry Road | 282 | $21,159 |  | NHD polygon intersection (bridge length used, longer) |
| tier3 | water | Indian Creek; StreamRiver | SR 335 | 268 | $20,096 |  | NHD polygon intersection (bridge length used, longer) |
| tier3 | water | Crooked Creek; StreamRiver | SR 66 | 233 | $17,491 |  | NHD polygon intersection (bridge length used, longer) |
| tier3 | water | Little Sandy Creek | SR 66 | 213 | $15,964 |  | bridge edge over an NHD flowline |
| tier3 | rail | NS railroad at I-64 (FRA 724957T) | Sherman Minton Bridge | 200 | $15,000 |  | FRA RR Under: road bridge over the railroad, bore under the tracks and embankment at rr_under_ft |
| tier3 | water | Blue River; StreamRiver | East Rothrocks Mill Road | 196 | $14,722 |  | NHD polygon intersection |
| tier3 | water | Sandy Creek | SR 66 | 166 | $12,436 |  | bridge edge over an NHD flowline |
| tier3 | water | Stinking Fork; StreamRiver | SR 66 | 112 | $8,416 |  | NHD polygon intersection |
| tier3 | water | perennial | SR 66 | 100 | $7,500 |  | perennial flowline, no bridge: culvert-class default length |
| tier3 | water | perennial | SR 66 | 100 | $7,500 |  | perennial flowline, no bridge: culvert-class default length |
| tier3 | rail | HOS railroad at SR 66/FRANKIN ST (FRA 735801A) | State Road 66 | 100 | $7,500 |  | FRA At Grade: default rail crossing length |
| tier3 | water | Jubin Creek | Branchville Road | 100 | $7,500 |  | perennial flowline, no bridge: culvert-class default length |
| tier3 | water | Ewing Creek | Oriole Road | 100 | $7,500 |  | perennial flowline, no bridge: culvert-class default length |
| tier3 | water | perennial | East Camp Jerry Road | 100 | $7,500 |  | perennial flowline, no bridge: culvert-class default length |
| tier3 | rail | LNAL railroad at SKY AIRE DR (FRA 851844K) | Sky Aire Road Northeast | 100 | $7,500 |  | FRA At Grade: default rail crossing length |
| tier3 | water | Oil Creek | Branchville Road | 56 | $4,166 |  | bridge edge over an NHD flowline |
| tier3 | water | South Fork Beargrass Creek; StreamRiver | East Broadway | 47 | $3,488 |  | NHD polygon intersection |
| tier3 | water | StreamRiver | East Broadway | 24 | $1,821 |  | NHD polygon intersection |

Solve log (every iteration):

| Iter | Solve s | Miles | Dollars | Max overlap vs kept | Result |
|--:|--:|--:|--:|--:|:--|
| 1 | 0.299 | 95.68 | $7,533,928 | 0.0% | kept |
| 2 | 0.061 | 92.97 | $8,221,909 | 0.1% | kept |
| 3 | 0.061 | 91.33 | $8,963,129 | 2.2% | kept |
| 4 | 0.068 | 100.63 | $8,361,577 | 8.2% | kept |
| 5 | 0.074 | 102.36 | $8,836,690 | 6.2% | kept |
| 6 | 0.105 | 105.99 | $8,461,563 | 9.3% | kept |
| 7 | 0.334 | 108.5 | $8,805,271 | 8.4% | kept |
| 8 | 0.084 | 103.65 | $8,804,762 | 14.1% | kept |
| 9 | 0.09 | 95.91 | $9,312,088 | 18.7% | kept |
| 10 | 0.093 | 113.01 | $9,952,433 | 11.3% | kept |
| 11 | 0.077 | 108.95 | $9,623,015 | 10.0% | kept |
| 12 | 0.314 | 103.34 | $9,398,943 | 21.3% | kept |
| 13 | 0.116 | 113.95 | $9,270,496 | 18.1% | kept |
| 14 | 0.095 | 114.53 | $9,795,856 | 7.4% | kept |
| 15 | 0.094 | 117.05 | $10,368,402 | 15.5% | kept |
| 16 | 0.083 | 104.82 | $9,027,882 | 36.2% | kept |
| 17 | 0.326 | 118.27 | $10,844,770 | 8.1% | kept |
| 18 | 0.104 | 108.14 | $9,681,365 | 21.6% | kept |
| 19 | 0.099 | 123.29 | $10,380,153 | 20.2% | kept |
| 20 | 0.074 | 106.46 | $9,024,899 | 38.5% | kept |

## Comparison only, never a target: the human route and the bid, like for like

- The KMZ line was sampled every 50 ft (9,748 samples) for soils, places, pavement and the nearest HPMS segment; each sample took the OSM class and toll flag of the nearest corridor-graph sample point within 30 m (99.5% matched; the rest priced as unclassified county road).  Crossings on the human route are those of the 235 graph edges it runs along (491,303 ft of edges; an edge counts when at least 2 samples and 30 percent of its own sample count land on it).
- Inside-place footage 80,245 ft (New Albany city 20,649 ft, Louisville city 16,099 ft, Clarksville town 14,799 ft, Tell City city 9,699 ft, Troy town 6,300 ft, Grandview town 4,600 ft); metro footage (pavement 10 percent or more) 280,631 ft; mean neighborhood pavement 16.9 percent (centerline cell 40.5); permit class footage state_dot 207,186 ft, interstate 192,587 ft, municipal 45,197 ft, county 21,849 ft, federal_or_tribal 20,449 ft, toll 100 ft.
- **Tool price of the human route at the bid's own rates: $9,275,379** (19.03 per ft): soil $6,280,770, crossings $2,252,218 (23 tiered: {'water': 19, 'dry': 1, 'rail': 3}, {'tier1': 1, 'tier2': 2, 'tier3': 20}), permitting adder $742,391; bore 319,379 ft, trench 167,989 ft.  At template defaults (base $12.00): $10,170,909.
- **Bid underground construction lines (footage times unit cost, `CONSTRUCTION LABOR BID` rows under the footage and unit cost headers, segment column J): $5,952,068 for 492,635 ft.**  trench 336,370 ft $2,538,495; bore 150,766 ft $2,060,572; crossing 5,500 ft $1,353,000.
- Plow convention: the tool prices every not-bore foot at the trench rate (Jeff, 2026-09-21).  The bid's plow lines repriced at this project's trench rates add $0, so the bid's own footage at the tool's convention is $5,952,068.
- **Ratios: tool over bid comparable 1.558; tool over bid-at-tool-convention 1.558; tool over construction labor K 0.768; tool over bid total P 0.417.**  Within 10 percent of the comparable underground number: no.  Footage: tool bore 319,379 ft (bid bore plus tiered crossings 156,266 ft), tool not-bore 167,989 ft (bid plow plus trench 336,370 ft); tool tiered crossing footage 10,284 ft $2,252,218 versus the bid's crossing lines $1,353,000.
- Bid presentation for this segment (row 11, SEGMENT 3: ROCKPORT, IN - LOUISVILLE): LF 492,635, construction labor K $12,069,558, materials O $8,774,502, total P $22,234,485.  Construction labor also holds handholes, splicing, restoration, traffic control and the like, which the tool does not price.
- **Human route diversity: 87.7%**; shared 59,946 ft, near band 36,048 ft, longest continuous shared run 18,499 ft, most carriers on one stretch 6; by carrier AT&T 44,047 ft, ZAYO 25,348 ft, UNITI 25,198 ft, LUMEN 21,449 ft, VERIZON 15,549 ft, COGENT 1,000 ft, ARELION 750 ft, MOX 700 ft.
- Cheapest tool route R01 versus the human route: 95.68 mi versus 92.30 mi (ratio 1.037); $7,533,928 versus $9,275,379 by the same model and rates (ratio 0.812); diversity 91.2% versus 87.7%.

| Soil class | Tool sample of the human line (ft) | Bid calculator soils block (ft) |
|--:|--:|--:|
| 1 | 250,033 | 1,052 |
| 2 | 87,044 | 319,936 |
| 3 | 18,649 | 22,915 |
| 4 | 2,750 | 3,636 |
| 5 | 23,698 | 23,007 |
| 6 | 25,548 | 22,319 |
| 7 | 27,348 | 30,038 |
| 8 | 0 | 455 |
| 10 | 3,750 | 16,209 |
| 11 | 16,499 | 15,042 |
| 12 | 32,048 | 38,026 |

Tiered crossings on the human route (from the graph edges it runs along):

| Tier | Kind | Name | Road | Length ft | Dollars | Forced Tier 1 |
|:--|:--|:--|:--|--:|--:|:--|
| tier1 | water | Ohio River; StreamRiver | Clark Memorial Bridge | 4,897 | $1,762,917 | USACE navigable waterway |
| tier2 | water | Silver Creek; StreamRiver | Brown's Station Way | 597 | $89,506 |  |
| tier2 | water | Blue River; StreamRiver | I 64 | 540 | $80,982 |  |
| tier3 | dry | bridge with no NHD water or FRA rail hit | Clark Memorial Bridge | 973 | $72,960 |  |
| tier3 | water | Little Blue River; StreamRiver | I 64 | 459 | $34,427 |  |
| tier3 | water | Indian Creek; StreamRiver | I 64 | 436 | $32,686 |  |
| tier3 | water | Anderson River; StreamRiver | State Road 66 | 374 | $28,076 |  |
| tier3 | water | Crooked Creek; StreamRiver | SR 66 | 233 | $17,491 |  |
| tier3 | water | Brush Heap Creek | I 64 | 215 | $16,158 |  |
| tier3 | water | Little Sandy Creek | SR 66 | 213 | $15,964 |  |
| tier3 | water | Sandy Creek | SR 66 | 166 | $12,436 |  |
| tier3 | water | Turkey Fork | I 64 | 126 | $9,426 |  |
| tier3 | water | perennial | SR 66 | 100 | $7,500 |  |
| tier3 | water | perennial | SR 66 | 100 | $7,500 |  |
| tier3 | rail | HOS railroad at SR 66/FRANKIN ST (FRA 735801A) | State Road 66 | 100 | $7,500 |  |
| tier3 | water | Windy Creek | State Road 66 | 100 | $7,500 |  |
| tier3 | rail | HOS railroad at State Highway 66 (FRA 916468P) | State Road 66 | 100 | $7,500 |  |
| tier3 | water | Windy Creek | Payne Street | 100 | $7,500 |  |
| tier3 | water | Little Windy Creek | Payne Street | 100 | $7,500 |  |
| tier3 | water | Stinking Fork | SR 62 | 100 | $7,500 |  |
| tier3 | rail | CSX railroad at ALLEY (FRA 352438L) | East 15th Street | 100 | $7,500 |  |
| tier3 | water | Fall Run | Pearl Street | 95 | $7,139 |  |
| tier3 | water | South Fork Beargrass Creek; StreamRiver | Baxter Avenue | 61 | $4,551 |  |

## Still placeholder (all marked in assumptions_defaults.json)

- Metro multipliers (1.0, 1.15, 1.4, 2.0 by pavement bin) and permitting adders (county 0, state DOT 0.05, municipal 0.15, interstate 0.5, toll 0.75, federal or tribal 0.5, in multiples of dirt bore per foot) are Claude's placeholders until step 4 calibration.  The data behind them is now real.
- Crossing default lengths (perennial flowline with no bridge 100 ft, FRA at-grade rail 100 ft) and the rule that minor flowlines without a bridge are not tiered are Claude's interim choices; the tier rates and the calculator's three tiers are Jeff's.
- Soil classes 10, 11, 12 are priced as class 3 and their footage is reported as flagged.  Plow rows are unused; not-bore uses the trench multiples.
- Pipeline crossings (Big Springs priced 67,000 ft of them) have no data layer in the tool.

## What failed or was not checked

- Nothing failed in the run that produced this report (the report is written only after every step returned).
- Not checked: GeoTel positional accuracy; OSM bridge edges spanning the whole physical bridge; whether every FRA crossing sits within 30 m of its OSM road.
- The inside-place test uses the edge midpoint; the RoadAuthority join votes over three points per edge; the human line is tested per sample.
- The human route's crossings are taken from the graph edges it runs along, so a crossing on an edge the snap did not claim is missed, and its crossing footage is also priced once more as soil footage (small: 10,284 ft).

## Files

- `_Working\runs\rockport-louisville\routes.kmz`: one folder per kept route, A, Z, the human route (comparison only), shared segments, and tiered crossing points.
- `_Working\runs\rockport-louisville\explorer.html`: Leaflet map (routes, human route, shared segments, crossings), scatter, sortable table with permit and crossing columns, assumptions panel.  Needs internet for tiles and Leaflet.
- `_Working\runs\rockport-louisville\results.json`: every number in this report.  `bid_extract.json`: every bid line read, with cell addresses.  `run.log`: console log.
- `engine\projects\rockport-louisville\project.json` and `assumptions_overrides.json`.

- `_Working\runs\rockport-louisville\explorer-screenshot.png`: screenshot written (880,479 bytes) in 1.1 s; chrome exit 0.
