Speed under deadline · Where the practice started
317 packages, 60 days, three days to build the pipeline.
A national wireless carrier issued a relocation portfolio and gave 60 days to return feasibility and permitting recommendations across it. Assembling that by hand was not achievable in the time available.
The carrier’s site list was synthesised with spatial data: coordinates, ground elevation, and urban or rural classification driving how large each search area needed to be. Python generated a review radius per candidate on that logic, half a mile urban and one mile rural, and a macro-enabled Word template produced the folder structure and a pre-populated feasibility analysis for every site.
Each generated document arrived already carrying its site number and name, state and jurisdiction, coordinates, ground elevation, existing tower height and structure type, carrier centerline and height above ground, and review radius, plus structured sections for search-area feasibility, permitting paths split between raw land and colocation, feasibility maps, and the relevant zoning ordinance excerpts.
317 feasibility packages across 316 sites, delivered on schedule. The pipeline was built in three days by an operator with no prior programming experience, and the analyses were divided across the three people working the programme.
The analysis used four attributes. Coordinates, structure height, city, state. That was what the spatial logic required and it is all the pipeline ever touched, decided before the code was written rather than reviewed afterwards.
| Date | Artifact | What it establishes |
|---|---|---|
| Oct 7, 2024 | Executed scope of work | Engagement scoped |
| Oct 22, 2024 | Carrier site list received | Source of truth established |
| Oct 22, 2024 | KML containing 315 review-radius polygons | Python radius generation working |
| Oct 23, 2024 | Folder-generation macro | Directory structure automated |
| Oct 24, 2024 | KML containing 315 site placemarks | Candidates plotted |
| Oct 25, 2024 | Production macro-enabled template | Pipeline complete |
Stated as an estimate: the labor hours this removed run to several hundred. That figure is a considered estimate, not a measurement, and it is not presented as one. The delivery counts are exact: 317 packages, 316 sites, a 60-day window, a three-day build.
Mapped to the method
- Source of truth. The carrier’s own site list, treated as authoritative rather than re-keyed.
- Structured operating data. Every candidate as a geospatial point with a market-classified review radius.
- Workflows and controls. Radius generation and document assembly automated, with one template governing every output.
- Tested and handed off. 317 packages delivered against a fixed deadline.