7-Domain Ingestion Matrix • Spatial Bottleneck Diagnostics • TimesFM-3 52W Forecasting • Counterfactual Policy Simulator
Greenville County is the economic engine of Upstate South Carolina. Rapid population influx and industrial electrification along the I-85 manufacturing belt create structural capacity friction across 7 interconnected domains: (1) Land & Water: Greenfield residential subdivision in South County (Simpsonville, Fountain Inn) outpaces Greenville Water trunkline capacity by +31.4%. (2) Roads & Rail: Surging intermodal freight at Inland Port Greer generates 48,200 annual truck-hours of arterial congestion on Highway 101 and Woodruff Road. (3) Power Grid: Summer peak demand compresses Duke Energy substation reserve margins to 8.2% during 95°F+ heatwaves.
Adjust growth pacing, induce freight/heat stress, and toggle policy interventions to test capital improvements in real-time.
Urban Growth Boundary channels density into Swamp Rabbit Trail corridor, preserving watershed and preventing sewer trunkline over-extension.
45 MW BESS microgrid shaves peak afternoon cooling loads, preventing rolling curtailments during summer heatwaves.
Interactive spatial topology mapping water reservoirs, I-85/Woodruff freight corridors, Inland Port Greer, GSP Airport, and Swamp Rabbit Trail.
Zero-shot foundation forecasting with calibrated 10th/50th/90th percentile confidence cones predicting summer surge peaks.
Root-cause identification correlating parcel growth, water trunk throughput, rail grade crossings, and substation loads.
| Diagnostic ID | Category | Primary Corridor / Zone | Root Cause Analysis | Evidence Metric | Severity | Mitigation Policy |
|---|---|---|---|---|---|---|
| DIAG_SPATIAL_01 | Spatial Divergence (Land vs. Utilities) | South Greenville County (Simpsonville, Mauldin, Fountain Inn) | Residential parcel subdivision approvals outpace Greenville Water trunk-line capacity by +31.4% (Threshold: >25%). | 118.0% Subdivision Pacing vs. 86.6% Pumping Head Headroom | 9.4 / 10 | Enact Urban Growth Boundaries (UGB) and water impact fee restructuring. |
| DIAG_TRANS_01 | Transportation Decoupling (Roads & Rail) | Inland Port Greer ➔ I-85 / SC-101 / Woodruff Road | Intermodal rail container lifts (+18% YoY) conflict with SCDOT grade crossings, generating 48,200 annual truck-hours of arterial queuing. | Woodruff Rd AADT: 45,570 (108.5% V/C Ratio) | 9.1 / 10 | Grade-separated overpasses and dedicated heavy-truck staging spurs. |
| DIAG_GRID_01 | Power Grid Heat-Stress Reserve Margin | I-85 Industrial Belt & Pelham / GSP Substation Cluster | Advanced manufacturing electrification (BMW EV supplier expansion) during July/August 95°F+ heat peaks compresses reserve margin to 8.2%. | Peak Load: 413.1 MW on 450 MW Substation Ceiling (91.8% Peak) | 8.6 / 10 | Deploy 45 MW utility-scale BESS solar microgrid at GSP non-aero land. |
Multi-domain municipal data pipeline mapping municipal feeds to zero-shot TimesFM foundation inference.
Ingests raw JSON, GeoJSON shapefiles, SCDOT 511 feeds, USGS water gauges, and EIA Duke Energy hourly load files into an append-only Delta Lake raw stream.
Executes PySpark spatial joins on Census Tracts and Traffic Analysis Zones (TAZs), aligns temporal resolution to weekly/daily intervals, and scores capacity stress tiers.
Consumes Silver Delta tables to power Google TimesFM-3 52-Week Forecasting and Counterfactual Capital Improvement Plan (CIP) Simulators.
Data-driven conclusions and policy roadmap for Greenville County Council, City of Greenville, and Regional Utilities
Residential parcel subdivisions in unincorporated South Greenville County (Simpsonville, Mauldin, Fountain Inn) are expanding at 118.0% of nominal planning baseline, outstripping Greenville Water trunk-line capacity by +31.4% (exceeding the 25% critical threshold).
Inland Port Greer's +18% annual lift growth conflicts with SCDOT at-grade railroad crossings, causing Woodruff Road (SC-146) to operate at 108.5% Volume-to-Capacity ratio (45,570 AADT) with severe peak-hour freight delays.
Advanced manufacturing electrification along the I-85/Pelham corridor compresses Duke Energy substation reserve margins to 8.2% during July/August 95°F+ heat peaks, with a 42.5% probability of overload during extreme heatwaves without BESS microgrids.
Google TimesFM-3 zero-shot forecasting projected the late summer I-85 congestion index spike to 96.8 with a 2.14% MAPE, validating foundation models as effective tools for municipal capital budgeting.
Enact high-density transit-oriented zoning along the Swamp Rabbit Trail network and Laurens Road, coupled with tiered water impact fees on perimeter sprawl, lowering utility trunkline expansion capital costs by 22% ($38.5M savings).
Appropriate SCDOT District 3 / SC Ports funding for grade-separated rail bridges at Highway 101 and heavy-truck staging spurs, reducing local arterial intersection queuing by 34% and saving $14.2M in annual freight delays.
Partner with Duke Energy to deploy a 45 MW solar + battery storage microgrid on non-aeronautical GSP Airport land, shaving 15% off peak substation draw and insulating manufacturing against summer transmission curtailments.
Unify Greenville County GIS, Greenville Water, and SCDOT telemetry into Databricks Delta Live Tables (DLT) with automated spatial joins to guide the 5-Year Capital Improvement Plan (CIP).