# RUN REPORT: Big Springs to BBTC, Texas, step 3 engine (local OSM store, RoadAuthority, NLCD pavement, NHD and FRA crossings)

Run 2026-10-03T14:38:40.  Code `engine\` (`run_project.py big-springs`), outputs `_Working\runs\big-springs\`.  Total wall time 43.33 s before the screenshot.

## Rates in use: this project's overrides from the bid workbook

- Overrides file `engine\projects\big-springs\assumptions_overrides.json`, existing file kept (pass --rebuild-overrides to regenerate from the bid).  Source: `BID CALC - HYPERLINK-ROCKPORT - BIG SPRINGS TO BBTC - SOUTH CONNECT ADJUSTMENT - v2026.09.04-FINAL.xlsx`, sheet `CONSTRUCTION BID CALCULATOR`, unit cost block (header row 257), segment 1 (column H: BIG SPRINGS TO to BBTC - NORTH).
- Base rate (bore class 2 dirt) $15.00 per ft (template default $12.00).  Rates the bid left blank fall back to the default multiple times this base: bore class 6: default multiple 3.7500 x $15.00 = $56.25; bore class 7: default multiple 5.0000 x $15.00 = $75.00; bore class 8: default multiple 16.6667 x $15.00 = $250.00; bore class 9: default multiple 37.5000 x $15.00 = $562.50; trench class 6: default multiple 2.0833 x $15.00 = $31.25; trench class 7: default multiple 2.9167 x $15.00 = $43.75; crossing tier1: default multiple 30.0000 x $15.00 = $450.00; crossing tier2: default multiple 14.5833 x $15.00 = $218.75.

| Rate | This project (bid) | Template default |
|:--|--:|--:|
| Bore class 1 | $15.00 | $12.00 |
| Bore class 2 | $15.00 | $12.00 |
| Bore class 3 | $15.00 | $12.00 |
| Bore class 4 | $19.00 | $20.00 |
| Bore class 5 | $25.00 | $30.00 |
| Bore class 6 | $56.25 | $45.00 |
| Bore class 7 | $75.00 | $60.00 |
| Bore class 8 | $250.00 | $200.00 |
| Bore class 9 | $562.50 | $450.00 |
| Trench class 1 | $7.00 | $5.50 |
| Trench class 2 | $7.00 | $5.50 |
| Trench class 3 | $7.00 | $10.00 |
| Trench class 4 | $14.00 | $15.00 |
| Trench class 5 | $14.00 | $20.00 |
| Trench class 6 | $31.25 | $25.00 |
| Trench class 7 | $43.75 | $35.00 |
| Crossing tier1 | $450.00 | $360.00 |
| Crossing tier2 | $218.75 | $175.00 |
| Crossing tier3 | $55.00 | $75.00 |

## A and Z

- Source: `Example - Big Springs\QTS - TEXAS - BIG SPRINGS-BBTC - SOUTH VAULT (CAV 4) - v2026.09.04 - cleaned - v2026.09.14a.kmz`, KMZ line 'Big Springs BBTC - South CAV' (2 lines in the file; selected by longest); A = first vertex of the line as drawn.
- A (lon, lat) = (-102.215782, 31.932867) (A Big Springs end).  Z = (-101.586387, 32.114159) (Z BBTC end).
- Human route length from the KMZ: 290,882 ft = 55.09 mi (56 vertices, geodesic).  Bid footage for this segment: 290,896 ft (`CONSTRUCTION BID CALCULATOR!H94`).
- Snapped to graph nodes 4029054301 (376 ft away) and 225606059 (9894 ft away).

## Corridor graph (local Geofabrik store, no Overpass)

- bbox (left, bottom, right, top) = (-102.42040, 31.75895, -101.38177, 32.28807), pad 12 mi, network drive, source pickle cache of local Geofabrik store (osm_store.py).
- Store read: 40,195 ways from TX in 0.65 s, 10,258 after de-duplication and the drive filter; graph build (chain merge on OSM node ids, split on highway, bridge, toll) 2.28 s: 99,448 segments and 91,184 nodes in the bbox to 17,027 nodes and 25,045 edges; **corridor total 3.05 s** (store timestamps {'TX': '2026-09-20T20:22:06Z'}).
- Routing graph 16,931 nodes, 24,996 edges, 3,889 road miles; bridge edges 254, toll edges 0.

## Incorporated places

- `Places_Incorporated_2025` (EPSG:26914), 4 places in the bbox, read in 0.02 s: Big Spring city, Midland city, Odessa city, Stanton city.
- 19,635 of 24,996 edges (49.0% of corridor footage) are inside a place (midpoint test, 0.61 s).  Top: Midland city 4,741,580 ft, Odessa city 3,943,055 ft, Big Spring city 1,209,176 ft, Stanton city 173,493 ft.

## Soils

- 24,996 edges, 423,279 sample points every 50 ft, one window read of `CONUS_soilbid9_10m.tif` ([6335, 10066], 63.8 MB) in 0.09 s.  Corridor share by class: 1 2.3%, 2 59.5%, 3 2.2%, 4 2.8%, 5 31.2%, 6 0.5%, 7 0.4%, 8 1.1%.

## Pavement (new, Annual NLCD Fractional Impervious Surface 2025)

- `Annual_NLCD_FctImp_2025_CU_C1V2.tif`: 30 m percent impervious, window [2122, 3366] (7.1 MB) read in 0.02 s over the same 423,279 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.06 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 33.6%, suburban 38.0%, urban 27.2%, dense 1.2%; by the raw centerline cell it would have been rural 12.9%, suburban 46.0%, urban 35.8%, dense 5.3%.  Edges whose neighborhood mean is 10 percent or more: 22,689 of 24,996 (centerline cell: 23,828).
- 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 30.8% of corridor footage under `place_pavement_soil`.

## Permitting authority (new, FiberBid RoadAuthority join)

- `RoadAuthority` bbox read: 15,917 HPMS 2024 segments in 4.59 s; classes {'municipal': 6383, 'state_dot': 6198, 'county': 3198, 'unknown': 138}; confidence {'rule_verified': 12581, 'inferred': 3198, 'unknown': 138}.
- Join: nearest segment within 30 m at 25, 50 and 75 percent of each edge; **23,200 of 24,996 edges matched, 91.9% of footage** (7.72 s).  Unmatched footage takes municipal inside a place, else county.
- Corridor footage by permit class: municipal 8,411,217 ft, county 6,883,065 ft, state_dot 3,756,749 ft, interstate 1,481,631 ft.
- Top authorities by footage: Midland city 3,538,711 ft, Odessa city 2,793,347 ft, Midland County 2,361,625 ft, Ector County 879,040 ft, Big Spring city 870,690 ft, Martin County 847,551 ft, Glasscock County 689,392 ft, Howard County 659,584 ft.

## Crossings (new: NHD water, FRA rail, FEMA floodway, USACE navigable)

- NHD (TX): 1,030 water polygons ({'Reservoir': 555, 'LakePond': 475}) and 1,977 flowlines ({'intermittent': 1421, 'artificial path': 520, 'perennial': 18, 'canal/ditch': 18}) in the bbox, read in 0.4 s.
- FRA grade crossings in the bbox: 103 ({'At Grade': 78, 'RR Under': 21, 'RR Over': 4}).  FEMA floodway polygons: 4 of 545 flood zone polygons.  USACE navigable waterway links: 0.
- Detection on all 24,996 edges in 0.22 s: crossings by kind {'dry_bridge': 219, 'water': 35, 'rail': 90}; edges with a crossing 336; edges with only minor (intermittent, ephemeral, canal) flowline hits and no bridge, counted but not tiered: 360; floodway edges 270, navigable edges 0, rail-over-road flags 4.
- 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: {'tier1': 3, 'tier3': 124, 'tier2': 18} by tier, {'water': 35, 'rail': 90, 'dry': 20} by kind.

## GeoTel carrier routes

- 8,780 features in the bbox in 0.06 s.  Named carriers found: ARELION, AT&T, COGENT, FIBERLIGHT, LUMEN, MOX, SEGRA, UNITI, ZAYO; not present: VERIZON, CROWN CASTLE.
- Corridor shared footage (within 250 ft of a named carrier): 6,439,027 ft (31.4%); by carrier AT&T 4,600,180 ft, SEGRA 2,106,884 ft, COGENT 2,079,152 ft, FIBERLIGHT 1,959,287 ft, LUMEN 1,573,391 ft, MOX 1,536,565 ft, ARELION 1,169,201 ft, ZAYO 1,105,326 ft, UNITI 1,034,294 ft.

## Timings (seconds)

| Step | Seconds |
|:--|--:|
| Assumptions build | 1.08 |
| Corridor total (store read plus graph build, or pickle load) | 0.44 |
| Places total | 0.65 |
| Soils total | 0.78 |
| Pavement total | 0.37 |
| Road authority total | 12.37 |
| Crossings total | 1.01 |
| Carriers total | 22.3 |
| Pricing | 0.14 |
| Spread (all solves and bookkeeping) | 1.95 |
| Dijkstra solves only | 1.91 |
| Route diversity | 0.021 |
| Shared segments | 0.16 |
| Comparison (human route) | 1.33 |
| Outputs (KMZ, HTML) | 0.62 |
| Total before the screenshot | 43.33 |

## 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.  43 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 | Overlap vs R01 | tertiary mi | residential mi | secondary mi | motorway mi | trunk mi | primary mi | unclassified mi |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R01 | 52.07 | $2,738,080 | 9.96 | 74.1% | 71,144 | 16,487 | ARELION 36,873; ZAYO 34,346; FIBERLIGHT 32,642; AT&T 24,098; UNITI 21,615; COGENT 20,496; SEGRA 12,212; MOX 7,816; LUMEN 7,766 | $5,500 | 1 (0, 1, 0) | 0 | Tier 3 rail 100 ft UP railroad at County Road 1250 (FRA 796312G) on tertiary $5,500 | $37,334 | 206,825 | 68,114 | 157,498 | 17,721 | 204,853 | 55,351 | 14,735 | 0 | 100.0% | 19.8 | 20.5 | 6.3 | 0.0 | 2.4 | 3.0 | 0.0 |
| R02 | 47.83 | $3,344,352 | 13.24 | 32.9% | 169,345 | 104,383 | AT&T 128,201; ZAYO 116,156; FIBERLIGHT 100,998; COGENT 86,848; ARELION 77,706; UNITI 72,441; LUMEN 49,604; MOX 40,948; SEGRA 26,232 | $27,500 | 5 (0, 5, 0) | 0 | Tier 3 rail 100 ft UP railroad at County Road 1250 (FRA 796312G) on tertiary $5,500 | $59,182 | 130,220 | 122,333 | 159,989 | 51,100 | 109,077 | 136,770 | 6,574 | 133 | 14.2% | 3.4 | 18.6 | 21.0 | 0.0 | 2.3 | 2.6 | 0.0 |
| R03 | 44.11 | $3,923,529 | 16.85 | 29.9% | 163,289 | 59,300 | ZAYO 144,778; AT&T 141,119; COGENT 124,881; LUMEN 41,377; SEGRA 38,291; ARELION 30,182; UNITI 20,446; FIBERLIGHT 20,434; MOX 2,230 | $38,500 | 7 (0, 7, 0) | 0 | Tier 3 rail 100 ft UP railroad at WEST INDUSTRIAL AVENUE (FRA 796325H) on West Industrial Avenue $5,500 | $75,111 | 71,712 | 161,195 | 204,044 | 47,100 | 114,821 | 79,588 | 37,752 | 745 | 27.3% | 17.3 | 14.7 | 0.8 | 0.0 | 4.5 | 6.4 | 0.4 |
| R04 | 53.33 | $3,207,350 | 11.39 | 58.6% | 116,465 | 52,261 | ARELION 68,585; FIBERLIGHT 62,575; ZAYO 49,771; UNITI 38,177; SEGRA 35,520; AT&T 22,688; COGENT 12,187; MOX 540; LUMEN 493 | $11,000 | 1 (0, 1, 0) | 0 | Tier 3 rail 200 ft UP railroad at sh0349 / fm1788 (FRA 796310T) on South FM 1788 $11,000 | $35,974 | 190,885 | 90,704 | 161,270 | 26,084 | 218,148 | 47,196 | 16,245 | 0 | 38.5% | 17.6 | 27.1 | 5.2 | 0.0 | 1.0 | 0.6 | 1.8 |
| R05 | 47.16 | $3,835,924 | 15.41 | 40.0% | 149,473 | 68,871 | AT&T 134,966; COGENT 131,217; ZAYO 71,608; MOX 66,323; LUMEN 64,411; SEGRA 40,702; FIBERLIGHT 32,750; ARELION 27,433; UNITI 20,272 | $5,500 | 1 (0, 1, 0) | 0 | Tier 3 rail 100 ft UP railroad at FM 818 (FRA 796366M) on FM 818 $5,500 | $83,374 | 93,551 | 155,433 | 202,941 | 41,859 | 61,064 | 171,558 | 16,121 | 241 | 8.6% | 21.1 | 5.4 | 8.7 | 0.0 | 2.6 | 9.4 | 0.0 |
| R06 | 51.36 | $3,639,154 | 13.42 | 45.1% | 148,818 | 58,798 | AT&T 109,353; COGENT 83,026; ZAYO 82,033; FIBERLIGHT 66,525; MOX 64,846; LUMEN 62,485; ARELION 48,494; UNITI 46,713; SEGRA 18,881 | $22,000 | 3 (0, 3, 0) | 0 | Tier 3 rail 200 ft UP railroad at FM0829 (FRA 796351X) on FM 829 $11,000 | $172,123 | 143,365 | 127,828 | 189,317 | 64,376 | 139,313 | 76,429 | 24,563 | 30,888 | 25.5% | 6.2 | 20.5 | 13.1 | 5.8 | 2.3 | 2.3 | 1.0 |
| R07 | 49.90 | $3,853,689 | 14.63 | 19.0% | 213,499 | 122,039 | ZAYO 164,141; ARELION 138,593; FIBERLIGHT 128,096; AT&T 120,199; UNITI 103,117; COGENT 60,987; SEGRA 42,918; LUMEN 35,465; MOX 35,210 | $27,500 | 5 (0, 5, 0) | 0 | Tier 3 rail 100 ft UP railroad at South G Street (FRA 796334G) on South G Street $5,500 | $100,677 | 111,723 | 151,742 | 201,542 | 49,324 | 46,631 | 192,136 | 24,378 | 320 | 16.1% | 12.6 | 9.5 | 23.5 | 0.0 | 1.9 | 2.0 | 0.4 |
| R08 | 47.20 | $4,110,088 | 16.49 | 42.1% | 144,227 | 52,757 | AT&T 118,148; ZAYO 103,165; COGENT 98,190; LUMEN 41,377; SEGRA 37,513; ARELION 17,644; FIBERLIGHT 13,463; UNITI 11,851; MOX 2,230 | $22,000 | 4 (0, 4, 0) | 0 | Tier 3 rail 100 ft UP railroad at marie drive (FRA 796342Y) on Marie Drive $5,500 | $105,175 | 78,954 | 170,253 | 215,702 | 70,258 | 107,785 | 74,507 | 66,169 | 745 | 32.2% | 22.0 | 14.2 | 5.4 | 0.0 | 3.9 | 1.2 | 0.5 |
| R09 | 46.31 | $4,227,559 | 17.29 | 34.9% | 159,216 | 81,172 | AT&T 129,493; COGENT 105,544; MOX 76,820; LUMEN 74,535; ZAYO 48,893; SEGRA 38,093; ARELION 25,135; FIBERLIGHT 22,339; UNITI 14,866 | $5,500 | 1 (0, 1, 0) | 0 | Tier 3 rail 100 ft UP railroad at county road 3601 (FRA 796362K) on County Road 3601 $5,500 | $90,630 | 66,921 | 177,619 | 218,134 | 54,540 | 92,252 | 107,593 | 44,696 | 0 | 22.6% | 20.6 | 16.5 | 2.5 | 0.0 | 2.3 | 4.2 | 0.2 |
| R10 | 47.73 | $4,226,344 | 16.77 | 35.5% | 162,494 | 49,637 | AT&T 150,336; COGENT 123,159; MOX 79,776; LUMEN 79,332; ZAYO 75,669; SEGRA 37,201; FIBERLIGHT 24,511; ARELION 21,787; UNITI 14,413 | $44,000 | 8 (0, 8, 0) | 0 | Tier 3 rail 100 ft UP railroad at County Road 1250 (FRA 796312G) on tertiary $5,500 | $284,678 | 78,586 | 173,452 | 206,799 | 48,805 | 36,491 | 131,036 | 30,999 | 53,511 | 6.7% | 20.5 | 7.0 | 7.5 | 10.1 | 1.7 | 1.0 | 0.0 |
| R11 | 51.02 | $4,132,095 | 15.34 | 53.8% | 124,513 | 34,982 | AT&T 107,459; COGENT 93,578; ZAYO 75,232; SEGRA 40,313; LUMEN 33,406; FIBERLIGHT 26,539; ARELION 24,880; MOX 20,802; UNITI 11,038 | $27,500 | 4 (0, 4, 0) | 0 | Tier 3 rail 200 ft UP railroad at FM1208 (FRA 796350R) on FM 1208 $11,000 | $73,935 | 134,791 | 134,592 | 178,364 | 50,037 | 137,156 | 99,759 | 32,467 | 0 | 17.6% | 11.5 | 20.7 | 6.3 | 0.0 | 5.1 | 7.0 | 0.4 |
| R12 | 46.21 | $4,684,198 | 19.20 | 20.8% | 193,282 | 133,548 | AT&T 177,828; COGENT 164,194; ZAYO 143,753; LUMEN 109,877; MOX 109,532; SEGRA 36,172; ARELION 22,002; FIBERLIGHT 16,414; UNITI 11,387 | $16,500 | 3 (0, 3, 0) | 0 | Tier 3 rail 100 ft UP railroad at SOUTH MARIENFIELD STREET (FRA 796335N) on South Marienfeld Street $5,500 | $449,719 | 36,848 | 207,124 | 218,939 | 52,727 | 48,102 | 51,230 | 42,626 | 102,015 | 7.4% | 11.7 | 2.5 | 6.4 | 19.3 | 3.9 | 2.4 | 0.0 |
| R13 | 47.47 | $4,573,774 | 18.25 | 15.9% | 210,933 | 125,555 | AT&T 200,918; COGENT 191,645; MOX 176,737; LUMEN 173,478; ZAYO 96,467; FIBERLIGHT 30,022; ARELION 7,779; SEGRA 7,288; UNITI 5,815 | $87,892 | 7 (0, 6, 1) | 0 | Tier 3 dry 898 ft bridge with no NHD water or FRA rail hit on I 20 $49,392 | $297,514 | 45,668 | 204,998 | 219,897 | 56,271 | 20,599 | 165,467 | 2,586 | 62,015 | 5.5% | 10.0 | 2.1 | 18.9 | 11.7 | 1.4 | 3.3 | 0.0 |
| R14 | 52.09 | $4,763,759 | 17.32 | 41.2% | 161,597 | 65,469 | AT&T 116,159; COGENT 69,691; MOX 65,370; LUMEN 65,172; ZAYO 60,458; FIBERLIGHT 39,097; SEGRA 25,354; ARELION 25,087; UNITI 20,151 | $5,500 | 1 (0, 1, 0) | 0 | Tier 3 rail 100 ft UP railroad at SAINT PETER STREET (FRA 796359C) on South Saint Peter Street $5,500 | $286,535 | 89,420 | 185,637 | 209,080 | 107,237 | 89,667 | 105,221 | 20,402 | 59,767 | 12.1% | 10.3 | 16.8 | 9.5 | 11.3 | 4.1 | 0.2 | 0.0 |
| R15 | 49.23 | $5,129,477 | 19.73 | 23.8% | 197,992 | 114,246 | AT&T 176,322; COGENT 155,116; ZAYO 125,942; MOX 113,996; LUMEN 111,412; SEGRA 37,780; FIBERLIGHT 17,336; ARELION 17,121; UNITI 9,004 | $16,500 | 3 (0, 3, 0) | 0 | Tier 3 rail 100 ft UP railroad at SOUTH MAIN STREET (FRA 796337C) on South Main Street $5,500 | $438,585 | 36,848 | 223,088 | 234,022 | 52,912 | 61,879 | 54,757 | 45,457 | 97,843 | 7.3% | 8.1 | 9.7 | 7.2 | 18.5 | 5.4 | 0.0 | 0.4 |
| R16 | 59.14 | $4,474,618 | 14.33 | 44.8% | 172,310 | 33,789 | AT&T 117,291; FIBERLIGHT 73,517; COGENT 65,551; LUMEN 55,210; SEGRA 50,099; MOX 43,372; ZAYO 29,725; ARELION 24,083; UNITI 18,030 | $27,500 | 4 (0, 4, 0) | 0 | Tier 3 rail 200 ft UP railroad at FM1208 (FRA 796350R) on FM 1208 $11,000 | $95,374 | 136,985 | 175,255 | 220,687 | 67,320 | 109,905 | 179,787 | 21,562 | 986 | 6.1% | 15.8 | 16.7 | 19.6 | 0.0 | 6.7 | 0.3 | 0.0 |
| R17 | 55.56 | $5,520,991 | 18.82 | 31.1% | 201,974 | 76,226 | AT&T 176,489; COGENT 119,528; LUMEN 111,485; MOX 110,989; ZAYO 102,180; FIBERLIGHT 27,722; ARELION 26,599; SEGRA 21,989; UNITI 18,553 | $16,500 | 3 (0, 3, 0) | 0 | Tier 3 rail 100 ft UP railroad at Private (FRA 796363S) on West Interstate 20 $5,500 | $451,859 | 55,877 | 237,456 | 248,679 | 102,430 | 44,610 | 105,863 | 47,073 | 95,787 | 2.7% | 19.2 | 9.2 | 4.7 | 18.1 | 4.2 | 0.1 | 0.0 |
| R18 | 55.25 | $5,682,576 | 19.48 | 30.1% | 203,759 | 137,771 | AT&T 169,136; COGENT 128,342; ZAYO 111,880; LUMEN 109,882; MOX 109,633; ARELION 57,118; FIBERLIGHT 56,259; UNITI 49,281; SEGRA 42,365 | $5,500 | 1 (0, 1, 0) | 0 | Tier 3 rail 100 ft UP railroad at FM 818 (FRA 796366M) on FM 818 $5,500 | $496,072 | 63,763 | 227,947 | 256,297 | 97,432 | 65,317 | 82,312 | 28,607 | 115,472 | 2.8% | 13.3 | 7.2 | 8.2 | 21.9 | 0.7 | 4.0 | 0.0 |
| R19 | 58.93 | $5,388,894 | 17.32 | 51.4% | 151,242 | 32,835 | AT&T 121,349; FIBERLIGHT 75,092; ZAYO 70,346; ARELION 66,191; UNITI 60,299; COGENT 39,791; SEGRA 39,138; LUMEN 28,669; MOX 1,645 | $45,047 | 4 (0, 3, 1) | 0 | Tier 3 dry 519 ft bridge with no NHD water or FRA rail hit on Sergeant Michael Naylor Memorial Highway $28,547 | $234,834 | 111,970 | 199,196 | 232,713 | 99,422 | 133,577 | 98,991 | 36,964 | 41,634 | 14.3% | 12.2 | 26.8 | 8.3 | 7.9 | 1.3 | 2.4 | 0.0 |
| R20 | 59.29 | $5,475,298 | 17.49 | 15.4% | 264,748 | 135,688 | AT&T 216,476; COGENT 211,288; MOX 187,777; LUMEN 186,638; ZAYO 137,901; FIBERLIGHT 53,904; ARELION 50,833; UNITI 40,429; SEGRA 38,704 | $22,000 | 3 (0, 3, 0) | 0 | Tier 3 rail 200 ft UP railroad at Ih0020 (FRA 796349W) on I 20 $11,000 | $534,102 | 74,799 | 238,266 | 264,108 | 35,630 | 68,957 | 106,425 | 8,426 | 129,257 | 2.5% | 12.1 | 9.8 | 8.5 | 24.0 | 2.4 | 2.5 | 0.0 |

Soil footage per kept route (ft):

| Route | Soil 1 | Soil 2 | Soil 3 | Soil 4 | Soil 5 | Flagged ft |
|---|---|---|---|---|---|---|
| R01 | 5,068 | 250,838 | 1,988 | 1,748 | 15,297 | 0 |
| R02 | 499 | 208,251 | 2,979 | 3,395 | 37,429 | 0 |
| R03 | 0 | 169,489 | 50 | 2,133 | 61,235 | 0 |
| R04 | 5,068 | 237,103 | 997 | 2,190 | 36,230 | 0 |
| R05 | 1,147 | 187,200 | 7,539 | 2,628 | 50,471 | 0 |
| R06 | 0 | 231,202 | 1,472 | 3,444 | 35,075 | 0 |
| R07 | 1,147 | 214,263 | 7,044 | 2,341 | 38,670 | 0 |
| R08 | 0 | 183,439 | 832 | 2,133 | 62,802 | 0 |
| R09 | 0 | 174,705 | 588 | 2,048 | 67,200 | 0 |
| R10 | 1,147 | 189,772 | 7,337 | 2,833 | 50,949 | 0 |
| R11 | 0 | 188,451 | 1,546 | 1,747 | 77,638 | 0 |
| R12 | 1,147 | 179,016 | 7,044 | 2,099 | 54,667 | 0 |
| R13 | 1,147 | 180,398 | 9,065 | 2,048 | 58,009 | 0 |
| R14 | 0 | 185,611 | 843 | 1,898 | 86,706 | 0 |
| R15 | 1,147 | 177,139 | 6,993 | 1,985 | 72,673 | 0 |
| R16 | 1,147 | 240,050 | 8,242 | 2,628 | 60,174 | 0 |
| R17 | 1,147 | 198,940 | 7,044 | 2,099 | 84,104 | 0 |
| R18 | 1,147 | 175,029 | 7,044 | 2,099 | 106,391 | 0 |
| R19 | 0 | 193,687 | 1,286 | 1,933 | 114,260 | 0 |
| R20 | 9,436 | 237,980 | 7,432 | 5,575 | 52,642 | 0 |

Every crossing priced at a tier on the cheapest route (R01):

| Tier | Kind | Name | Road | Length ft | Dollars | Forced Tier 1 | Detection |
|:--|:--|:--|:--|--:|--:|:--|:--|
| tier3 | rail | UP railroad at County Road 1250 (FRA 796312G) | tertiary | 100 | $5,500 |  | FRA At Grade: default rail crossing length |

Solve log (every iteration):

| Iter | Solve s | Miles | Dollars | Max overlap vs kept | Result |
|--:|--:|--:|--:|--:|:--|
| 1 | 0.024 | 52.07 | $2,738,080 | 0.0% | kept |
| 2 | 0.12 | 47.83 | $3,344,352 | 14.2% | kept |
| 3 | 0.031 | 47.16 | $3,835,924 | 8.6% | kept |
| 4 | 0.026 | 44.11 | $3,923,529 | 27.3% | kept |
| 5 | 0.023 | 47.47 | $4,573,774 | 14.5% | kept |
| 6 | 0.021 | 46.21 | $4,684,198 | 16.6% | kept |
| 7 | 0.021 | 53.33 | $3,207,350 | 38.5% | kept |
| 8 | 0.101 | 47.73 | $4,226,344 | 35.3% | kept |
| 9 | 0.032 | 74.19 | $4,420,844 | 12.9% | detour cap |
| 10 | 0.026 | 51.36 | $3,639,154 | 34.1% | kept |
| 11 | 0.025 | 59.14 | $4,474,618 | 29.8% | kept |
| 12 | 0.023 | 59.29 | $5,475,298 | 20.0% | kept |
| 13 | 0.023 | 78.37 | $5,291,844 | 6.4% | detour cap |
| 14 | 0.098 | 61.77 | $5,645,032 | 17.0% | detour cap |
| 15 | 0.031 | 52.09 | $4,763,759 | 25.9% | kept |
| 16 | 0.025 | 91.89 | $4,910,068 | 7.4% | detour cap |
| 17 | 0.024 | 73.69 | $4,764,121 | 7.4% | detour cap |
| 18 | 0.024 | 49.9 | $3,853,689 | 29.6% | kept |
| 19 | 0.022 | 67.65 | $4,604,924 | 23.7% | detour cap |
| 20 | 0.144 | 47.2 | $4,110,088 | 51.1% | kept |
| 21 | 0.04 | 87.87 | $5,245,004 | 13.9% | detour cap |
| 22 | 0.031 | 86.32 | $5,589,542 | 6.8% | detour cap |
| 23 | 0.024 | 55.25 | $5,682,576 | 41.8% | kept |
| 24 | 0.026 | 69.44 | $6,720,249 | 22.1% | detour cap |
| 25 | 0.1 | 86.22 | $4,532,118 | 5.7% | detour cap |
| 26 | 0.031 | 66.13 | $6,165,829 | 22.8% | detour cap |
| 27 | 0.03 | 51.02 | $4,132,095 | 33.8% | kept |
| 28 | 0.027 | 71.56 | $5,601,720 | 19.5% | detour cap |
| 29 | 0.024 | 73.44 | $4,623,621 | 17.4% | detour cap |
| 30 | 0.022 | 69.57 | $5,744,465 | 25.7% | detour cap |
| 31 | 0.101 | 81.95 | $4,857,235 | 5.6% | detour cap |
| 32 | 0.028 | 71.78 | $4,958,507 | 24.3% | detour cap |
| 33 | 0.023 | 61.29 | $4,159,700 | 30.5% | detour cap |
| 34 | 0.021 | 90.74 | $5,917,061 | 5.7% | detour cap |
| 35 | 0.022 | 55.56 | $5,520,991 | 39.2% | kept |
| 36 | 0.097 | 71.33 | $6,412,412 | 18.8% | detour cap |
| 37 | 0.044 | 49.23 | $5,129,477 | 33.3% | kept |
| 38 | 0.042 | 86.89 | $5,263,817 | 18.7% | detour cap |
| 39 | 0.043 | 78.89 | $4,612,859 | 6.4% | detour cap |
| 40 | 0.044 | 98.37 | $7,239,618 | 10.1% | detour cap |
| 41 | 0.042 | 58.93 | $5,388,894 | 29.9% | kept |
| 42 | 0.141 | 97.78 | $6,838,743 | 5.5% | detour cap |
| 43 | 0.043 | 46.31 | $4,227,559 | 41.3% | kept |

## Comparison only, never a target: the human route and the bid, like for like

- The KMZ line was sampled every 50 ft (5,818 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 (91.2% matched; the rest priced as unclassified county road).  Crossings on the human route are those of the 100 graph edges it runs along (290,407 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 24,748 ft (Midland city 14,049 ft, Stanton city 10,699 ft); metro footage (pavement 10 percent or more) 71,746 ft; mean neighborhood pavement 8.7 percent (centerline cell 14.5); permit class footage county 216,286 ft, state_dot 44,997 ft, municipal 20,599 ft, interstate 8,999 ft.
- **Tool price of the human route at the bid's own rates: $3,152,491** (10.84 per ft): soil $3,067,696, crossings $11,000 (1 tiered: {'rail': 1}, {'tier3': 1}), permitting adder $73,795; bore 81,245 ft, trench 209,637 ft.  At template defaults (base $12.00): $2,820,520.
- **Bid underground construction lines (footage times unit cost, `CONSTRUCTION BID CALCULATOR` rows under the footage and unit cost headers, segment column H): $5,613,899 for 290,896 ft.**  trench 136,210 ft $1,193,241; bore 87,086 ft $1,372,658; other 67,600 ft $3,048,000.  Lines the tool has no data layer for are repriced at the bid's dirt bore rate for the comparable number: BORE - PIPELINE CROSSINGS 67,000 ft at $45 = $3,015,000 becomes $1,005,000 at $15 (the tool has no pipeline layer).  Comparable: $3,603,899.
- 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 $3,603,899.
- **Ratios: tool over bid comparable 0.875; tool over bid-at-tool-convention 0.875; tool over construction labor K 0.306; tool over bid total P 0.226.**  Within 10 percent of the comparable underground number: no.  Footage: tool bore 81,245 ft (bid bore plus tiered crossings 87,086 ft), tool not-bore 209,637 ft (bid plow plus trench 136,210 ft); tool tiered crossing footage 200 ft $11,000 versus the bid's crossing lines $33,000.
- Bid presentation for this segment (row 9, SEGMENT 1: BIG SPRINGS TO - BBTC - NORTH): LF 290,896, construction labor K $10,300,627, materials O $3,290,012, total P $13,968,804.  Construction labor also holds handholes, splicing, restoration, traffic control and the like, which the tool does not price.
- **Human route diversity: 80.7%**; shared 56,046 ft, near band 17,049 ft, longest continuous shared run 15,549 ft, most carriers on one stretch 4; by carrier AT&T 23,649 ft, ARELION 21,499 ft, ZAYO 19,099 ft, UNITI 16,049 ft, COGENT 15,599 ft, SEGRA 13,349 ft, LUMEN 12,599 ft, MOX 12,549 ft, FIBERLIGHT 6,800 ft.
- Cheapest tool route R01 versus the human route: 52.07 mi versus 55.09 mi (ratio 0.945); $2,738,080 versus $3,152,491 by the same model and rates (ratio 0.869); diversity 74.1% versus 80.7%.

| Soil class | Tool sample of the human line (ft) | Bid calculator soils block (ft) |
|--:|--:|--:|
| 1 | 7,450 | 6,842 |
| 2 | 249,334 | 238,693 |
| 3 | 2,250 | 2,001 |
| 4 | 4,650 | 3,384 |
| 5 | 27,198 | 37,993 |
| 11 | 0 | 1,983 |

Tiered crossings on the human route (from the graph edges it runs along):

| Tier | Kind | Name | Road | Length ft | Dollars | Forced Tier 1 |
|:--|:--|:--|:--|--:|--:|:--|
| tier3 | rail | UP railroad at sh0349 / fm1788 (FRA 796310T) | South FM 1788 | 200 | $11,000 |  |

## 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: 200 ft).

## Files

- `_Working\runs\big-springs\routes.kmz`: one folder per kept route, A, Z, the human route (comparison only), shared segments, and tiered crossing points.
- `_Working\runs\big-springs\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\big-springs\results.json`: every number in this report.  `bid_extract.json`: every bid line read, with cell addresses.  `run.log`: console log.
- `engine\projects\big-springs\project.json` and `assumptions_overrides.json`.

- `_Working\runs\big-springs\explorer-screenshot.png`: screenshot written (438,022 bytes) in 1.0 s; chrome exit 0.
