Where would one search in the FCC database for ATC Xmiter locations?

BinaryMode

Blondie Once Said To Call Her But Never Answerd
Joined
Jul 3, 2023
Messages
1,202
Location
2600 dialtone blvd


Thanks. That's a good chuck of decent Info. I'll create a PHP script to pull out all the FAA data.

That's an interesting website, too.(y)


Well, I initially created this in PHP, but realized many may not want to mess with that. So I had the script converted to HTML, CSS and JavaScript. I also added perks. Like the ability to search withen frequency ranges and if coordinates are provided a small map will render for that data block of information.

To use, double click the HTML file. Then using the browse button chose the included NTIAgovtMasterFile_2021.txt file I had converted to text from the PDF.

Enjoy!


 

ecps92

Member
Joined
Jul 8, 2002
Messages
15,346
Location
Taxachusetts
Well, I initially created this in PHP, but realized many may not want to mess with that. So I had the script converted to HTML, CSS and JavaScript. I also added perks. Like the ability to search withen frequency ranges and if coordinates are provided a small map will render for that data block of information.

To use, double click the HTML file. Then using the browse button chose the included NTIAgovtMasterFile_2021.txt file I had converted to text from the PDF.

Enjoy!


interesting program I like the Map feature
 

BinaryMode

Blondie Once Said To Call Her But Never Answerd
Joined
Jul 3, 2023
Messages
1,202
Location
2600 dialtone blvd
Thanks. What I noticed is that if there are some 1,000 results or more the maps will take a long time to load, and also the results take a while to load. So I'm going to see if I can add code that will show 10 results per page to lessen that load a little. So bear with me here a bit and I should have a new version ready by tonight I hope. One of the disadvantages of a browser based App.

Also note that if you want to search for one frequency like 121.5 just enter in the range box 121.5-121.5. This can also be combined with a search term. For example: you want all results for "fire" relating to a range of frequencies of 118.0-130.0. Keep in mind there will probably be over a 1,000 results. That's why the omission option is there to help better filter things...
 

dlwtrunked

Member
Premium Subscriber
Joined
Dec 19, 2002
Messages
2,551
Okay, version 2 now complete. This version loads 10 results per page and at the bottom you can select each page. This will help with load time and map rendering.



This really should be posted in a thread with a different title to reach the right people.
 

ecps92

Member
Joined
Jul 8, 2002
Messages
15,346
Location
Taxachusetts
How complete is this file ? I just did a quick search of some known Boston, New York and Cleveland Center ARTCC frequencies and none of them seem to be listed ?
Feb 2021 release from a FOIA request
Doesn't imply that it contain all as certain agencies may have frequencies flagged as restricted, there-by not released

ie: There is quite a few of USFS, BLM listed., but none for the White Mountains NF as it is likely they flagged those as also LE (Law Enforcement)
 

AirScan

Member
Premium Subscriber
Joined
Feb 13, 2007
Messages
3,152
Doesn't imply that it contain all as certain agencies may have frequencies flagged as restricted, there-by not released
I'm just talking about standard air traffic control frequencies (re: the OP). These frequencies are not restricted as they appear in other FAA documents. When I have more time I'll take a closer look but from what I've seen so far it seems that "MasterFile" is missing large areas of ARTCC frequency coverage.
 

ecps92

Member
Joined
Jul 8, 2002
Messages
15,346
Location
Taxachusetts
I'm just talking about standard air traffic control frequencies (re: the OP). These frequencies are not restricted as they appear in other FAA documents. When I have more time I'll take a closer look but from what I've seen so far it seems that "MasterFile" is missing large areas of ARTCC frequency coverage.
Since Non of us, true hobbyists, have access (or will admit in public, for obvious reason) to Spectrum XXI, we can only assume that the data record for those not provided contain a FLAG that prohibited them from being released as part of the FOIA request.

I see plenty of VA's but none of my VA Police
I see plenty of USFS Repeaters, but many missing.

Just one of life's mysteries when dealing with the NTIA records.
 

AirScan

Member
Premium Subscriber
Joined
Feb 13, 2007
Messages
3,152
we can only assume that the data record for those not provided contain a FLAG that prohibited them from being released as part of the FOIA request.

After taking a closer look at this NTIA "MasterFile" it seems to only include a very small sampling of the total ARTCC frequencies. I have no idea what the criteria is they used to select the very few they did include, but the missing ones being flagged/prohibited seems unlikely given the large number that are excluded and the fact that all the frequencies can be found in other public FAA documents.
 
Last edited:

ecps92

Member
Joined
Jul 8, 2002
Messages
15,346
Location
Taxachusetts
After taking a closer look at this NTIA "MasterFile" it seems to only include a very small sampling of the total ARTCC frequencies. I have no idea what the criteria is they used to select the very few they did include, but the missing ones being flagged/prohibited seems unlikely given the large number that are excluded and the fact that all the frequencies can be found in other public FAA documents.
Only those on the inside will be able to answer the question, as hobbyists we can only speculate as to "how many licks it takes to get to the center of a tootsie pop"
 

AM909

Radio/computer geek
Premium Subscriber
Joined
Dec 10, 2015
Messages
1,502
Location
SoCal
I remember wondering about the aviation coverage, too. Don't exclude the possibility that they simply made a mistake in the query when producing the file. After all, we've been asked to believe that federal employees are all stupid and lazy. :(
 

alcahuete

Member
Premium Subscriber
Joined
Jul 24, 2015
Messages
2,766
Location
Southern California
The problem is going to NTIA. If you want better information, go directly to the Agencies themselves with the FOIA request.
 

BinaryMode

Blondie Once Said To Call Her But Never Answerd
Joined
Jul 3, 2023
Messages
1,202
Location
2600 dialtone blvd
New version of my web-based App. In this version you can search for items by comma separation. The comma separation in the search box acts as an AND, not an OR. I've also added the ability to search for whole words. Like that state of Colorado, or "CO." Before, if you entered "CO" you'd get results like coordination or whatever. Now with a whole word search for "CO" you may get CO DENVER or CO CRAIG, etc.

 

BinaryMode

Blondie Once Said To Call Her But Never Answerd
Joined
Jul 3, 2023
Messages
1,202
Location
2600 dialtone blvd
HUGE update! Version 4 of my script allows you to pick a location on a map, set a radius in miles to search withen and enter a search term/s or frequency range and the script will output all info. for that map radius providing the coordinates were in the searchable block of text. I've also added a background image just because which is rendered via base64 in the script its self. So no external URL fetches except for OpenStreetMaps (OSM).

 

ecps92

Member
Joined
Jul 8, 2002
Messages
15,346
Location
Taxachusetts
HUGE update! Version 4 of my script allows you to pick a location on a map, set a radius in miles to search withen and enter a search term/s or frequency range and the script will output all info. for that map radius providing the coordinates were in the searchable block of text. I've also added a background image just because which is rendered via base64 in the script its self. So no external URL fetches except for OpenStreetMaps (OSM).

maybe a CLR/Reset feature to reset all inquiry parameters..?
I tried the map search (Nice) , but only could close/launch to remove the Pin - also it required one of the other fields to be filled in vs being Optional...

Also, what (maybe a mouse-over help) is the procedure to determine/search between K#### (kHz) and M#### (mHz) entries ??
 

BinaryMode

Blondie Once Said To Call Her But Never Answerd
Joined
Jul 3, 2023
Messages
1,202
Location
2600 dialtone blvd
maybe a CLR/Reset feature to reset all inquiry parameters..?

Like the search field, frequency range and omissions if used?


I tried the map search (Nice) , but only could close/launch to remove the Pin

You can just select on the map another place. So, say you chose Salt Lake city and now you want Denver. Just pick Denver. No need to close the file and start over. You will also see the coordinates change.

also it required one of the other fields to be filled in vs being Optional...

Yes, that is how I have it coded now, I thought of not doing that.

So if you chose New York city with a radius of 10 miles and enter a frequency range of 117-138 it'll return all results just for that frequency range withen the 10 mile radius of New York city. If I do it where no search parameters are required and you chose New York city then anything and everything will show up for that radius. Which of course may or may not be a good thing. You could of course enter a frequency range of say, 10-3000 and that'll practically do the same thing.

Also, what (maybe a mouse-over help) is the procedure to determine/search between K#### (kHz) and M#### (mHz) entries ??

That was a question I thought of and will have to see about tackling that. So for now, if you instead use a search parameter rather than a frequency search parameter you're more apt to get a kHz range show up in the results then you would via the frequency range parameter.

I'll see if I can't address these minor issues.

By in large, that map search with radius ability is pretty cool. But then again, it comes down to what blocks of text do provide the coordinates. So I'm wanting to create another script for myself to answer the question of A) how many blocks of text there are versus B) how many of those blocks actually contain coordinates? Then I'll know for sure at what percentage the over 20 MB text file actually contains coordinates.

In the absence of coordinates that's where the word search, frequency search and omission ability comes in at. As I wanted this to be as search thorough as possible.

I'm glad you like the map feature. I thought of that a few nights a go while lying in bed thinking of how I could make this script a little better in the searching ability and it hit me like a carbon filament light bulb powered by zero point energy. LOL I should have had that feature from the get-go, really.
 
Last edited:

ecps92

Member
Joined
Jul 8, 2002
Messages
15,346
Location
Taxachusetts
Like the search field, frequency range and omissions if used?




You can just select on the map another place. So, say you chose Salt Lake city and now you want Denver. Just pick Denver. No need to close the file and start over. You will also see the coordinates change.



Yes, that is how I have it coded now, I thought of not doing that.

So if you chose New York city with a radius of 10 miles and enter a frequency range of 117-138 it'll return all results just for that frequency range withen the 10 mile radius of New York city. If I do it where no search parameters are required and you chose New York city then anything and everything will show up for that radius. Which of course may or may not be a good thing. You could of course enter a frequency range of say, 10-3000 and that'll practically do the same thing.



That was a question I thought of and will have to see about tackling that. So for now, if you instead use a search parameter rather than a frequency search parameter you're more apt to get a kHz range show up in the results then you would via the frequency range parameter.

I'll see if I can't address these minor issues.

By in large, that map search with radius ability is pretty cool. But then again, it comes down to what blocks of text do provide the coordinates. So I'm wanting to create another script for myself to answer the question of A) how many blocks of text there are versus B) how many of those blocks actually contain coordinates? Then I'll know for sure at what percentage the over 20 MB text file actually contains coordinates.

In the absence of coordinates that's where the word search, frequency search and omission ability comes in at. As I wanted this to be as search thorough as possible.

I'm glad you like the map feature. I thought of that a few nights a go while lying in bed thinking of how I could make this script a little better in the searching ability and it hit me like a carbon filament light bulb powered by zero point energy. LOL I should have had that feature from the get-go, really.
tried selecting another location and the pin just moved, wanted to CLR it entirely and then do a freq search...(generic vs location)

Thanks for the work
 

dlwtrunked

Member
Premium Subscriber
Joined
Dec 19, 2002
Messages
2,551
After taking a closer look at this NTIA "MasterFile" it seems to only include a very small sampling of the total ARTCC frequencies. I have no idea what the criteria is they used to select the very few they did include, but the missing ones being flagged/prohibited seems unlikely given the large number that are excluded and the fact that all the frequencies can be found in other public FAA documents.
One thing many may not recall (or been around for) is that Reagan (I think it was him) classified the entire NTIA frequency list (their particular list, not others like the FAA). The reason actually given was that if you knew the non-sensitive/classivied frequencies, you could figure out the classified ones like the FBI, CIA, NSA, ATF etc. (Yes, I know we know many of those.) The fact that this file was released goes against that directive and the fact that it is VERY partial and makes it of limited use. My guess is that it was produced from a partial database (the government often does not go through its own complete procedures of allocating frequencies) by some programmer not good at dealing with relational databases (this has been reported as to the cause of the claim that a huge number of dead people are getting SS.) My observation is that more non-sensitive frequencies have been excluded than included making the list of limited value.
 

nd5y

Member
Joined
Dec 19, 2002
Messages
12,050
Location
Wichita Falls, TX
Top