• Effective immediately we will be deleting, without notice, any negative threads or posts that deal with the use of encryption and streaming of scanner audio.

    We've noticed a huge increase in rants and negative posts that revolve around agencies going to encryption due to the broadcasting of scanner audio on the internet. It's now worn out and continues to be the same recycled rants. These rants hijack the threads and derail the conversation. They no longer have a place anywhere on this forum other than in the designated threads in the Rants forum in the Tavern.

    If you violate these guidelines your post will be deleted without notice and an infraction will be issued. We are not against discussion of this issue. You just need to do it in the right place. For example:
    https://forums.radioreference.com/rants/224104-official-thread-live-audio-feeds-scanners-wait-encryption.html

FCC Database Questions

Status
Not open for further replies.

N9JIG

Sheriff
Moderator
Joined
Dec 14, 2001
Messages
3,915
Location
Far NW Valley
#1
I am looking for a fairly simple way to find transmit locations by frequency in the FCC database.

When I search by frequency the main FCC database page only has location information for the licensee and, while for Public Safety this is not too bad it is a pain for other searches, especially railroads.

As an example, let's say I want to search 160.740 in Utah. While I might get results from local shortlines I am unlikely to get results from any of the large Class Ones since all those licenses come back to Texas or Nebraska.

In addition, does anyone still sell a data dump of the entire FCC database like the old Percon CD's of years past? I used to import that file into FileMaker Pro and create my own front ends that allowed me to do my own searches and edits. The County searches were extremely useful! (AFAIK there is no way to search by transmitter location county in the FCC DB)
 

natedawg1604

Member
Premium Subscriber
Joined
Jun 29, 2013
Messages
1,950
Location
Denver-Metro
#3
Hopefully Shawn's link provides a solution. You certainly can download raw ULS data files for FREE. And if you build your own local copy of ULS, you can certainly construct your own custom queries. I've done it myself, and I was able to generate all kinds of cool query parameters not available in the ULS Web API.

However, it's a bit of a project, and I'd be shocked if you could do it with Filemaker or Access. The FCC raw datafiles are a HUGE complex cluster&**(, and you basically *have* to use a real database program like MySQL, Postgres etc, if you want to utilize the raw data files. I'm guessing Filemaker and/or Access wouldn't allow you to import all those giant data files, to say nothing of the complex joins & queries that would have to be run afterwords.
 
Last edited:

DaveNF2G

Member
Premium Subscriber
Joined
Jan 23, 2001
Messages
9,180
Location
Rensselaer, NY
#5
You can search by transmitter county if you use the Geosearch option. It allows you to select multiple counties at a time if you need to.
 
Status
Not open for further replies.
Top