# FWF — Missing Redlines Report Generated: 2026-05-19T18:07:37.112295Z Source: sprocket_prod.fwf.phase_subs (latest run) + sprocket_fiber.fwf.construction_packages + fwf.source_documents ## CRITICAL — phases with reported construction but ZERO redlines on file ### P01 · Sunrise — Direct Crews - 36,855 of 36,714 ft built (100.4%) · 0 of 21 CPs have a redline - Sections / sites needing redlines: * PHASE 1 - S1 14,046 ft built (100%, complete) → expected redline at P01-CP01-BACKBONE-1 * PHASE 1 - S2 4,491 ft built (100%, complete) → expected redline at P01-CP02-BACKBONE-2 * PHASE 1 - S3 4,739 ft built (100%, complete) → expected redline at P01-CP03-BACKBONE-3 * PHASE 1 - S4 13,108 ft built (97%, in_progress) → expected redline at P01-CP04-BACKBONE-4 * unattributed-r9 471 ft built (0%, not_started) → (could not map: no-match) ### P02 · Jacqueline Construction (Direct) - 54,883 of 59,456 ft built (92.3%) · 0 of 9 CPs have a redline - Sections / sites needing redlines: * FULL ROUTE 54,883 ft built (92%, in_progress) → expected redline at P02-CP01-BACKBONE-1 ### P03 · Sunrise → Customized Tech - 10,654 of 24,938 ft built (42.7%) · 0 of 11 CPs have a redline - Sections / sites needing redlines: * PHASE 3 PERMIT 1 2,688 ft built (49%, in_progress) → expected redline at P03-CP01-BACKBONE-1 * PHASE 3 PERMIT 2 6,566 ft built (33%, in_progress) → expected redline at P03-CP02-BACKBONE-2 * unattributed-r5 1,400 ft built (0%, not_started) → (could not map: no-match) ### P04 · Jacqueline Construction (Direct) - 52,567 of 64,816 ft built (81.1%) · 0 of 21 CPs have a redline - Sections / sites needing redlines: * PH 4 - SEC 1 7,200 ft built (43%, in_progress) → expected redline at P04-CP01-BACKBONE-1 * PH 4 - SEC 2 15,138 ft built (86%, in_progress) → expected redline at P04-CP02-BACKBONE-1 * PH 4 - SEC 3 14,507 ft built (97%, in_progress) → expected redline at P04-CP03-BACKBONE-1 * PH 4 - SEC 4 15,722 ft built (98%, in_progress) → expected redline at P04-CP04-BACKBONE-1 ## PARTIAL — phases with some redlines; specific active CPs still missing them ### P09 · Jacqueline Construction (Direct) - 85,652 of 93,193 ft built (91.9%) · 10 of 12 CPs have a redline - Sub-segments WITH construction but NO redline: * P09-CP03-L1 9,569 ft built (100%) → expected at P09-CP03-L1 - Covered (redline OR as-built on file): * P09-CP01-BACKBONE ✓ 1 as-built(s) at P09-CP01-BACKBONE-1 * P09-CP01-L1 ✓ 1 redline(s) + 2 as-built(s) at P09-CP01-L1 * P09-CP02-BACKBONE ✓ 1 redline(s) + 1 as-built(s) at P09-CP02-BACKBONE-1 * P09-CP02-L1 ✓ 3 as-built(s) at P09-CP02-L1 * P09-CP03-BACKBONE ✓ 1 redline(s) + 1 as-built(s) at P09-CP03-BACKBONE-1 * P09-CP03-L2 ✓ 3 as-built(s) at P09-CP03-L2 * P09-CP04-BACKBONE ✓ 2 redline(s) + 1 as-built(s) at P09-CP04-BACKBONE-1 * P09 - CP04 - L1 ✓ 1 as-built(s) at P09-CP04-L1 * P09-CP04-L2 TRWD ✓ 2 as-built(s) at P09-CP04-L2 ### P10 · TBD - 18,654 of 42,089 ft built (44.3%) · 5 of 7 CPs have a redline - Sub-segments WITH construction but NO redline: * P10-CP02 BACKBONE 3,783 ft built (42%) → expected at P10-CP02-BACKBONE-2 - Covered (redline OR as-built on file): * P10 - CP01 - BACKBONE ✓ 2 as-built(s) at P10-CP01-BACKBONE-1 * P10-CP02-L1 ✓ 2 as-built(s) at P10-CP02-L1 * P10-CP02-L3 ✓ 1 redline(s) + 2 as-built(s) at P10-CP02-L3 ## COVERED — every active sub-segment has a redline - P05 · Sunrise → Elex #1 · 91.4% complete - P06 · Jacqueline Construction (Direct) · 78.2% complete ## Unreadable redlines None — every redline on file extracted cleanly. ## Handholes plotted but NO redline / as-built on file These CPs have handhole positions extracted from engineering plans — meaning construction is feasible or underway — but we have no field documentation of what was actually built. • P01-CP01-L4 P01 CP01 lateral 3 handholes · P01CP01LA04 PD - WEST DIVISION - 1385FT • P01-CP01-L8 P01 CP01 lateral 1 handholes · P01CP01LA08 WATER RIDGLEA TOWER - 220FT • P01-CP04-L1 P01 CP04 lateral 2 handholes · P01CP04LA01 WILL ROGERS MEMORIAL CENTER - 531FT • P01-CP04-L2 P01 CP04 lateral 1 handholes · P01CP04LA02 FIRE STATION #18 - 113FT • P01-CP05-L1 P01 CP05 lateral 1 handholes · P01CP05LA01 PD - 7TH BIKE SF - 429FT) • P02-CP03-L2 P02 CP03 lateral 2 handholes · P02CP03LA02 WATER - WESTLAND TREATMENT - 2245FT • P02-CP03-L3 P02 CP03 lateral 5 handholes · P02CP03LA03 WATER TOWER - 4712FT • P03-CP02-L2 P03 CP02 lateral 1 handholes · P03CP02LA02 PARD - LOG CABIN VILLAGE - 249FT • P04-CP01-L1 P04 CP01 lateral 3 handholes · P04CP01LA01 PD - NPO LANCASTER - 302FT • P04-CP01-L2 P04 CP01 lateral 2 handholes · P04CP01LA02 CODE - HAZEL HARVEY PEACE CENTER FOR N • P04-CP01-L3 P04 CP01 lateral 1 handholes · P04CP01LA03 LIBRARY - SHAMBLEE - 140FT • P04-CP02-L1 P04 CP02 lateral 3 handholes · P04CP02LA01 PARD - SYCAMORE PARK MAINTENANCE CENTE • P04-CP02-L6 P04 CP02 lateral 1 handholes · P04CP02LA06 WATER SYCAMORE PUMP - 527FT • P04-CP03-L1 P04 CP03 lateral 1 handholes · P04CP03LA01 FIRE STATION #14 - 474FT • P04-CP03-L2 P04 CP03 lateral 4 handholes · P04CP03LA02 PD - CRIME LAB AND PROPERTY ROOM FACIL • P05-CP04-BACKBONE-1 P05 CP04 backbone 52 handholes · P05CP04BB01 PERMIT 49 - 14286FT • P05-CP04-L1 P05 CP04 lateral 14 handholes · P05CP04LA01 PARD - TEXAS A&M FOREST SERVICE - 3149 • P06-CP01-L2 P06 CP01 lateral 10 handholes · P06CP01LA02 FIRE STATION #4 - 5189FT • P08-CP02-L6 P08 CP02 lateral 1 handholes · P08CP02LA06 FIRE STATION #26 - 4786FT ## Handholes plotted but NO bore log on file Same as above but specifically for bore logs (directional drilling records). Required for any segment installed via bore. • P01-CP01-L4 P01 CP01 lateral 3 handholes · P01CP01LA04 PD - WEST DIVISION - 1385FT • P01-CP01-L8 P01 CP01 lateral 1 handholes · P01CP01LA08 WATER RIDGLEA TOWER - 220FT • P01-CP04-L1 P01 CP04 lateral 2 handholes · P01CP04LA01 WILL ROGERS MEMORIAL CENTER - 531FT • P01-CP04-L2 P01 CP04 lateral 1 handholes · P01CP04LA02 FIRE STATION #18 - 113FT • P01-CP05-L1 P01 CP05 lateral 1 handholes · P01CP05LA01 PD - 7TH BIKE SF - 429FT) • P02-CP03-L2 P02 CP03 lateral 2 handholes · P02CP03LA02 WATER - WESTLAND TREATMENT - 2245FT • P02-CP03-L3 P02 CP03 lateral 5 handholes · P02CP03LA03 WATER TOWER - 4712FT • P03-CP02-L2 P03 CP02 lateral 1 handholes · P03CP02LA02 PARD - LOG CABIN VILLAGE - 249FT • P04-CP01-L1 P04 CP01 lateral 3 handholes · P04CP01LA01 PD - NPO LANCASTER - 302FT • P04-CP01-L2 P04 CP01 lateral 2 handholes · P04CP01LA02 CODE - HAZEL HARVEY PEACE CENTER FOR N • P04-CP01-L3 P04 CP01 lateral 1 handholes · P04CP01LA03 LIBRARY - SHAMBLEE - 140FT • P04-CP02-L1 P04 CP02 lateral 3 handholes · P04CP02LA01 PARD - SYCAMORE PARK MAINTENANCE CENTE • P04-CP02-L6 P04 CP02 lateral 1 handholes · P04CP02LA06 WATER SYCAMORE PUMP - 527FT • P04-CP03-L1 P04 CP03 lateral 1 handholes · P04CP03LA01 FIRE STATION #14 - 474FT • P04-CP03-L2 P04 CP03 lateral 4 handholes · P04CP03LA02 PD - CRIME LAB AND PROPERTY ROOM FACIL • P05-CP01-BACKBONE-1 P05 CP01 backbone 2 handholes · P05CP01BB01 PERMIT 46 - 11843FT • P05-CP01-L1 P05 CP01 lateral 2 handholes · P05CP01LA01 LIBRARY - MEADOWBROOK - 640FT • P05-CP01-L2 P05 CP01 lateral 11 handholes · P05CP01LA02 FIRE STATION #24 - 5967FT • P05-CP01-L4 P05 CP01 lateral 4 handholes · P05CP01LA04 PARD - HANDLEY MEADOWBROOK CC - 923FT • P05-CP01-L6 P05 CP01 lateral 6 handholes · P05CP01LA06 FIRE STATION #3 - 1969FT • P05-CP02-BACKBONE-1 P05 CP02 backbone 50 handholes · P05CP02BB01 PERMIT 47 - 11554FT • P05-CP02-L1 P05 CP02 lateral 4 handholes · P05CP02LA01 CODE - CHUCK SILCOX ANIMAL CARE AND CO • P05-CP02-L4 P05 CP02 lateral 26 handholes · P05CP02LA04 WATER TOWER - 4806FT • P05-CP02-L5 P05 CP02 lateral 6 handholes · P05CP02LA05 FIRE STATION #22 - 1053FT • P05-CP02-L6 P05 CP02 lateral 2 handholes · P05CP02LA06 LIBRARY - EAST BERRY - 82FT • P05-CP02-L7 P05 CP02 lateral 4 handholes · P05CP02LA07 SE DROPOFF CENTER - 1505FT • P05-CP03-BACKBONE-1 P05 CP03 backbone 24 handholes · P05CP03BB01 PERMIT 48 - 9127FT • P05-CP03-L1 P05 CP03 lateral 56 handholes · P05CP03LA01 PARD - BRADLEY CENTER CC - 4392FT • P05-CP04-BACKBONE-1 P05 CP04 backbone 52 handholes · P05CP04BB01 PERMIT 49 - 14286FT • P05-CP04-L1 P05 CP04 lateral 14 handholes · P05CP04LA01 PARD - TEXAS A&M FOREST SERVICE - 3149 • P06-CP01-L1 P06 CP01 lateral 9 handholes · P06CP01LA01 PARD - WORTH HEIGHTS CC - 2186FT • P06-CP01-L2 P06 CP01 lateral 10 handholes · P06CP01LA02 FIRE STATION #4 - 5189FT • P07-CP01-BACKBONE-1 P07 CP01 backbone 37 handholes · P07CP01BB01 PERMIT 39 - 18731FT • P07-CP01-L1 P07 CP01 lateral 1 handholes · P07CP01LA01 FIRE STATION #29 - 612FT • P07-CP01-L2 P07 CP01 lateral 11 handholes · P07CP01LA02 WATER TANK - 6400FT • P07-CP01-L3 P07 CP01 lateral 1 handholes · P07CP01LA03 PARD - SOUTHWEST CC - 643FT • P07-CP01-L4 P07 CP01 lateral 1 handholes · P07CP01LA04 WATER MCCART PUNK/TANK - 965FT • P07-CP02-BACKBONE-1 P07 CP02 backbone 18 handholes · P07CP02BB01 PERMIT 40 - 9528FT • P07-CP02-L1 P07 CP02 lateral 14 handholes · P07CP02LA01 WATER TOWER - 12621FT • P07-CP02-L2 P07 CP02 lateral 26 handholes · P07CP02LA02 PARD - CHISHOLM TRAIL CC - 7764FT • P07-CP03-BACKBONE-1 P07 CP03 backbone 22 handholes · P07CP03BB01 PERMITS 41 - 11480FT • P07-CP03-L1 P07 CP03 lateral 31 handholes · P07CP03LA01 PARD - PECAN VALLEY GOLF/ PARD - PECAN • P07-CP03-L2 P07 CP03 lateral 22 handholes · P07CP03LA02 FIRE STATION #39 - 7689FT • P08-CP02-L6 P08 CP02 lateral 1 handholes · P08CP02LA06 FIRE STATION #26 - 4786FT • P09-CP01-BACKBONE-1 P09 CP01 backbone 45 handholes · P09CP01BB01 PERMIT 33 - 21165FT • P09-CP01-L1 P09 CP01 lateral 32 handholes · P09CP01LA01 PD - POLICE MOUNTED PATROL - 6611FT • P09-CP02-BACKBONE-1 P09 CP02 backbone 18 handholes · P09CP02BB01 PERMIT 34 - 9486FT • P09-CP02-L1 P09 CP02 lateral 36 handholes · P09CP02LA01 MARSHAL LAKE PATROL - 9936FT • P09-CP03-BACKBONE-1 P09 CP03 backbone 42 handholes · P09CP03BB01 PERMIT 35 - 14973FT • P09-CP03-L2 P09 CP03 lateral 8 handholes · P09CP03LA02 PARD - NATURE CENTER REFUGE - 2585FT • P09-CP04-BACKBONE-1 P09 CP04 backbone 32 handholes · P09CP04BB01 PERMIT 36 - 12905FT • P09-CP04-L2 P09 CP04 lateral 21 handholes · P09CP04LA02 TARRANT REGIONAL WATER DISTRICT (TRWD) • P10-CP02-BACKBONE-1 P10 CP02 backbone 7 handholes · P10CP02BB01 PERMIT 31 - 8479FT • P10-CP02-L3 P10 CP02 lateral 6 handholes · P10CP02LA03 CASA RADAR - 136FT ## Subs that couldn't be auto-mapped to a CP (manual review) - P01 · unattributed-r9 · 471 ft (no-match) - P03 · unattributed-r5 · 1,400 ft (no-match) --- Live: https://sprocket-gis.vercel.app/missing-redlines.html