Mapping Sites from spreadsheet to Google Maps

[CopperheadCSA]

Not sure if anyone has already discovered this, but I have found a pretty easy way to view System Site locations on Google Maps. The website is www.batchgeo.com. Steps:

1 - Export the site data for the system you want to a .csv
2- Get rid of all the columns except Desc., County Name, Lat, and Lon
3- Copy and Paste all rows in the spreadsheet into the window and press 'Validate and Set Options' You may have to tweak a few things here.
4- Click 'Map Now' and you're done.

Here is the URL for the map I made of the Colorado DTRS system:

https://batchgeo.com/map/b3bb112e8aa9ff0bcaa187214d7ea9e8

 

[jonwienke]

You can do the same thing in ProScan in the Favorites Editor.

 

[troymail]

...except that this is more generic -- and free.

It took me a bit but I pulled in a ULS listing of UHF frequencies for my county and was able to plot the entire set on the map with the tool.

Thanks for the tip!

 

[shajoe44]

Where did you obtain your information from for the frequencies. I was looking at the P25 system info for the South Carolina system and there is no geographical information other than the city of the tower locations obtain when running ProComm or unitrunk programs.

 

[troymail]

I'm guessing Copperhead got it from the "Downloads and Reports" under the system he plotted - I believe it is a Premium Subscriber feature.

But- there are other ways to get the same info...

 

[CopperheadCSA]

Yup, I used the Downloads and Reports function to export the site location data to .csv

 

[Spitfire8520]

The RadioReference Database automatically maps site locations for all trunked radio system. It does both FCC license and database locations. You will find a link for FCC Callsigns and RR Locations (same as the example map) right between the System Frequencies header and before where the sites area actually listed. It has the added benefit of automatically updating whenever the database is modified, like it was for Colorado DTRS this past week.

Google Drive also supports the same operation for mapping out sites, although it does require a Google account. Create a new Google My Maps (found under More), and then import whatever data to be mapped. It is useful for displaying information beyond what the default RadioReference map shows. Here is a map I created a few years back (and updated today) to visualize the RFSS/Zones for Colorado DTRS.

Where did you obtain your information from for the frequencies. I was looking at the P25 system info for the South Carolina system and there is no geographical information other than the city of the tower locations obtain when running ProComm or unitrunk programs.

I'm guessing Copperhead got it from the "Downloads and Reports" under the system he plotted - I believe it is a Premium Subscriber feature.

But- there are other ways to get the same info...

Other Reports are web based and available to all users. Anyone can copy and paste the data found there into a spreadsheet.

 

[CopperheadCSA]

True, but I wasn't able to find a way to see all of the sites together on a map within RadioReference. One great use for this is when travelling you can easily see what sites you need in your scanlists along your route.

 

[troymail]

Where did you obtain your information from for the frequencies. I was looking at the P25 system info for the South Carolina system and there is no geographical information other than the city of the tower locations obtain when running ProComm or unitrunk programs.

Here's a SC map I created without using any Radio Reference data or tools.

https://www.batchgeo.com/map/a747a1d9aa35fdea96f397404e29f241

 

[shajoe44]

Thanks