May 2022 Update – P35 Boundaries

Improved BRS/EBS P35 Boundaries

BRS and EBS licenses are licensed in a variety of ways (and the upcoming Auction 108 will add another way – counties). One of the way they’re licensed is a Point-Radius method referred to as P35 (point and a 35 mile radius). Licensees define a point, and have the 35 mile radius around that point as their licensed area. However there are lots of cases when those licenses overlap. Which can make it tricky to know which license is the correct one for a given location.

Using a “splitting the football” technique to intersect P35 point/radius license areas, I am better able to determine the county/license relationship. Counties in metropolitan areas will have less noise and more signal (ha ha) as far as which licenses are applicable for that area. In very dense areas, like the picture below, you can see that it becomes less of “splitting the football” and more of just trying to determine the midpoint between all the intersecting points and drawing lines through the midpoints to generate a set of boundaries that are correct.

P35 areas in the northeast USA, along with county boundaries

This was a particularly fun problem to solve. It took a while, as the spatial analysis tools in SQL Server weren’t adequate and I had to spin up a different database to accomplish it.

These improvements will be deployed by the end of May!

More improvements to come soon!

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.