FCC Filing Automation
A Python workflow that rebuilt radio-link relationships and filled missing site data for more than 250 links, in time for a short FCC deadline.
Outcomes
- Local datasets and API queries supplied coordinates, city, county, elevation, and azimuth missing from the source records.
- Radios were tied to their point-to-point and point-to-multipoint links, which the database could not export.
- With limited manual cleanup, the batch was filed before the deadline.
Work started the week of the deadline. Entering each site by hand would not have finished in time, and the source database lacked much of what a batch filing needs. Site names were inconsistent, many records had no coordinates or city, and there was no practical way to export which radios were connected.
Python combined local datasets with API queries. It filled coordinates, city, county, elevation, and azimuth, and associated each radio with its point-to-point or point-to-multipoint link.
The filing team received the link relationships and the missing site data. With limited manual cleanup, the batch was submitted before the deadline.
