NTIA Government Master File of Federal Frequency Assignments

AM909

Radio/computer geek
Premium Subscriber
Joined
Dec 10, 2015
Messages
1,412
Location
SoCal
Perhaps this document (chapter 9) on how entries are done might help.
@N1GAW: Can you link to the other chapters of this book? There are references to things station class values in chapter 6 and something else in chapter 8 that would be helpful. Thanks.
 

AM909

Radio/computer geek
Premium Subscriber
Joined
Dec 10, 2015
Messages
1,412
Location
SoCal
Not a CSV/Excel/Google sheet but I ran the PDF through the tool pdftotext starting at Page 5 to extract everything. I made an HTML and a TXT file, both around 50 megs. Should hopefully be easier to search through.

NTIAgovtMasterFile_2021.txt <- Text file
NTIAgovtMasterFile_2021.html<- HTML File

@twosenses: That's really excellent! Searching for a freq is now instant instead of minutes. :)

Do you have any control over how it deals with spaces? The variable number of spaces between fields, that may be in the source document because of their silly use of a proportional font to display what should be columnar data, but without tabs for alignment, is proving to be a challenge to parse. No chance I can muster the will or energy to do it page-by-page as someone else above was doing (perhaps tongue-in-cheek :) ).
 

twosenses

Member
Premium Subscriber
Joined
Aug 1, 2013
Messages
23
Location
Boston Metro Area
@twosenses: That's really excellent! Searching for a freq is now instant instead of minutes. :)

Do you have any control over how it deals with spaces? The variable number of spaces between fields, that may be in the source document because of their silly use of a proportional font to display what should be columnar data, but without tabs for alignment, is proving to be a challenge to parse. No chance I can muster the will or energy to do it page-by-page as someone else above was doing (perhaps tongue-in-cheek :) ).

I'll take a look at the docs for it and see what I can do. I know I can nuke all the original formatting but that may not be super helpful
 

nd5y

Member
Joined
Dec 19, 2002
Messages
11,907
Location
Wichita Falls, TX
If you are a Linux user there is a command line program called pdftk-java that allows you to manipulate PDF documents.
...
I don't know if there is a similar program for Windows.
Now I remember what I used back in my Windows days for PDF editing.
 

es93546

A Member Twice
Premium Subscriber
Joined
Aug 18, 2020
Messages
1,370
Location
Right Side of CA on maps
I have Bob Grove's Federal Freq Assignment book, missing the front cover- it has been used so hard. In the old Police Call books Federal classified freqs were listed as UXX.

I have Grove's book also and the front cover is history, it was not in any condition to save. The book is held together with one of those black clips, the largest I've ever seen. The binding failed long ago. I haven't looked at it much since the narrowband mandate and now especially since the reallocation of the federal VHF High band.

I goofed up and didn't save any of the last editions of the 9 Police Call books published, although I still have a Southern California book on the shelf. I met and spent a couple of days with Gene "Hughes" at his home, while he ran errands and he even arranged a couple of LAPD ride alongs for me. He was a good man and not having one of those books to remember him by hurts a bit.

I've run out of shelf space for all books and that includes the separate 2 shelf bookcase for radio books. Grove's books still contain some useful info, when the frequencies match the reallocation and are not the "split" 12.5 kHz frequencies. The location information might be useful, but with the addition of so many new repeaters it is no longer complete.

I also have the Robert Kelty/James E. Tunnel "Master Frequency File" book that covers a lot of federal information, with NTIA license listings as well, or at least partial license info. The covers are taped on. The binding is just beginning to show signs of failure.

These books might be helpful in looking at these NTIA documents. I'm going to have everything spread out on a table when I look over the document the OP provided here.
 

es93546

A Member Twice
Premium Subscriber
Joined
Aug 18, 2020
Messages
1,370
Location
Right Side of CA on maps
Do you have a copy of the pdf without the duplicated pages?

I'm trying to index all frequencies so we can easily look them up if needed.

Also could be several listed in the file I linked.

This is a great piece of information. The alphabet soup federal agency listings all on one list! I never thought of looking for one so thank you very much.
 

AM909

Radio/computer geek
Premium Subscriber
Joined
Dec 10, 2015
Messages
1,412
Location
SoCal
... I goofed up and didn't save any of the last editions of the 9 Police Call books published, ...
I've seen digital archives of some of those somewhere; maybe archive.org or some Google archive site?
 

es93546

A Member Twice
Premium Subscriber
Joined
Aug 18, 2020
Messages
1,370
Location
Right Side of CA on maps
I've seen digital archives of some of those somewhere; maybe archive.org or some Google archive site?

Thanks, I might do some more searching. I really want a hard copy of one of the editions. It's purely a sentimental thing so a digital copy doesn't fully fit the bill.
 

twosenses

Member
Premium Subscriber
Joined
Aug 1, 2013
Messages
23
Location
Boston Metro Area
@twosenses: That's really excellent! Searching for a freq is now instant instead of minutes. :)

Do you have any control over how it deals with spaces? The variable number of spaces between fields, that may be in the source document because of their silly use of a proportional font to display what should be columnar data, but without tabs for alignment, is proving to be a challenge to parse. No chance I can muster the will or energy to do it page-by-page as someone else above was doing (perhaps tongue-in-cheek :) ).
Not sure if this is helpful but it's the best I can do with pdftotext. This version disregards the original formatting to make it "easier to read" per the documentation. Maybe it'll make it easier to parse with software too.

 

es93546

A Member Twice
Premium Subscriber
Joined
Aug 18, 2020
Messages
1,370
Location
Right Side of CA on maps

ecps92

Member
Joined
Jul 8, 2002
Messages
15,099
Location
Taxachusetts
Sadly the MARS folks listed their info with "too many to list" yet those of us local know some of those sites as Repeaters :(

A couple [two] of CAP Repeaters [148.1500 only] made it thru, like;y someone forgot to check a box

USCG Aux 150.7000 is a nice pool of PL tone's for each site, but much of District 1 is not included
There is a lot of nationwide and regional CAP and MARS HF and VHF frequencies. Maybe all of them.
I haven't found any individual repeaters.
 

AM909

Radio/computer geek
Premium Subscriber
Joined
Dec 10, 2015
Messages
1,412
Location
SoCal
Thanks to those who found this and parsed it into text. :) I've done a little work with regex on it, but nothing I can share yet. I'm afraid parsing it into a more normal set of tables is going to be a fair amount of work to understand all the scenarios presented in the Redbook chapter linked earlier, and how they are reflected in the data, assuming the application preparation rules translate reasonably into the master file format.

The *PRD elements are nice for documenting repeater inputs on high-band where the offsets are not standardized.

I'm surprised/entertained by the level of detail in the SUP field commentary.

There's lots of other interesting things in there, like the SNOTEL system that uses meteor scatter propagation on low-band (40.67/41.61). Anyone heard this?

It's nice to have a reference for the non-FCC callsigns (e.g. NWS 162.45 WWG21).

I wonder why USFS stuff (at least the VHF channels in SoCal) is missing, while other things that are seemingly more sensitive are present.

The lack of precision in the coords (1" ~= 30m) is disappointing, as it could otherwise help identify which buildings are likely federal at large sites (for those of us with a site-mapping fetish :) ).
 

ecps92

Member
Joined
Jul 8, 2002
Messages
15,099
Location
Taxachusetts
Yes, on SnoTel, it is a good set of frequencies to keep in there, for those interested in Low Band Opennings [Skip]

As to the NWS Call Signs, they are also available at the NWS Site

As to mapping, my experience has been they are pretty Dead On when using Google Earth

Thanks to those who found this and parsed it into text. :) I've done a little work with regex on it, but nothing I can share yet. I'm afraid parsing it into a more normal set of tables is going to be a fair amount of work to understand all the scenarios presented in the Redbook chapter linked earlier, and how they are reflected in the data, assuming the application preparation rules translate reasonably into the master file format.

The *PRD elements are nice for documenting repeater inputs on high-band where the offsets are not standardized.

I'm surprised/entertained by the level of detail in the SUP field commentary.

There's lots of other interesting things in there, like the SNOTEL system that uses meteor scatter propagation on low-band (40.67/41.61). Anyone heard this?

It's nice to have a reference for the non-FCC callsigns (e.g. NWS 162.45 WWG21).

I wonder why USFS stuff (at least the VHF channels in SoCal) is missing, while other things that are seemingly more sensitive are present.

The lack of precision in the coords (1" ~= 30m) is disappointing, as it could otherwise help identify which buildings are likely federal at large sites (for those of us with a site-mapping fetish :) ).
 

ArkTex

KA5AAA
Joined
Apr 14, 2021
Messages
334
Location
Little Rock, AR
In the spirit of me having way too much time on my hands, I am now working to make a custom Google map with pins for all listings in the NTIA document.

Why?

Bc I'm a college student with too much free time and too much interest in finding patterns, that's why.
 

rgchristy

Member
Premium Subscriber
Joined
Mar 10, 2005
Messages
767
Location
Delco, PA
You should consider becoming a fire investigator. Finding patterns and solving puzzles are where it's at.

In the spirit of me having way too much time on my hands, I am now working to make a custom Google map with pins for all listings in the NTIA document.

Why?

Bc I'm a college student with too much free time and too much interest in finding patterns, that's why.
 
Top