DTRS Site Sorting Help

[eyes00only]

Most members may know this but I accidently did it today and it's great.
While looking at the sites in the DTRS Database I clicked the County Header and it sorted them alphabetically.

 

[ScannerSK]

Good tip, thank you!

 

[poltergeisty]

When I'm looking in there I just hit control + F to find the talk group or what ever.

 

[milcom_chaser]

Just tried it. Soooo helpful. Thank you!

 

[N0GTG]

That CTRL-F (find) is very handy if you're looking at any web page for a certain word or phrase. You don't have to visually search through a bunch of other data to see if what you want is on the page, and where it is.

I am also looking for a way to see what control channels are duplicated at multiple sites in Colorado's DTRS. I am working on a Favorites List of all the sites and TG's on DTRS. For instance, 853.2375 is duplicated on the Arapahoe Admin, Deer Trail, Calhan, and Lamar sites. If those were programmed as separate sites, the scanner could show the incorrect site, since the CC's are 'shared'. It would also have to scan the same CC freq 4 times on each pass. I would like to create a single site with those 4 names as the title, and the appropriate primary and alternate CC's. Any ideas on how to sort the sites other than 'brute force' analyzing the database line by line?

 

[poltergeisty]

I am also looking for a way to see what control channels are duplicated at multiple sites in Colorado's DTRS.

This has been a major, major PITA. I tried doing this with Notepad ++ and Ultraedit and and got it to all sort in lines, but I ended up using an online tool to remove the duplicate lines as Notepad ++ wouldn't work right for some reason. Even looking at an example at Stackexchange and using the consecutive duplicate line remover. So here's the file with duplicate frequencies removed. Now you said just control channels. That I have no idea how to do with Notepad ++ and Ultraedit. I suppose one could craft a regular expression based on a number with the appended c and go from there. Keep in mind it also removed duplicate words. I noticed at the end of the file were 700 MHz frequencies under (Air) something or other.

You can grab the data in the database by holding the control key and highlighting what cells you want.

 

[N0GTG]

Thanks for the help. I'll see if I can craft something with your information. I was thinking there might be some way to accomplish this by loading the data in CSV format into Excel, but I don't know enough about Excel to figure out how to do it.

 

[poltergeisty]

but I don't know enough about Excel to figure out how to do it.

Me either. Though, I use LibreOffice.

 

[n0doz]

Thanks for the help. I'll see if I can craft something with your information. I was thinking there might be some way to accomplish this by loading the data in CSV format into Excel, but I don't know enough about Excel to figure out how to do it.

Hi Curt, easier than it sounds:

1. Open a new Excel document and navigate to the Data tab.
2. Click “From Text”.
3. Navigate to the CSV file you wish to open and click “Import”.
4. From the newly-opened window, choose “Delimited”. Then click “Next”.
5. Check the box next to the type of delimiter – in most cases this is either a semicolon or a comma. ...
6. Click “Finish”.

 

[N0GTG]

Hi Jerry, good to hear from you! Thanks for the help.

I know how to get the CSV file into Excel, but it's the manipulation I don't know how to do: selecting the primary and alternate control channels, and then sorting that data so that sites with identical control channels are grouped together. I suspect that Excel can do it, but I'm not sure how.

I hope you're enjoying your move to Phx. I went through there briefly several years ago, and was amazed at the amount of traffic on their Fire Dispatch channel. I monitored some of the law enforcement traffic too, especially the helo traffic.