eHam.net - Amateur Radio (Ham Radio) Community

Call Search
     

New to Ham Radio?
My Profile

Community
Articles
Forums
News
Reviews
Friends Remembered
Speak Out
Strays
Survey Question

Operating
Contesting
DX Cluster Spots
Propagation

Resources
Calendar
Classifieds
Ham Exams
Ham Links
List Archives
News Articles
Product Reviews
QSL Managers

Site Info
eHam Help (FAQ)
Support the site
The eHam Team
Advertising Info
Vision Statement
About eHam.net


QSL Managers
     

Ham Links
     


eHam.net Forum : EmergencyCommunications : Geocoding your ARES/RACES team database Forum Help

1-1 of 1 messages

  Page 1 of 1  


Geocoding your ARES/RACES team database Reply
by K9RFZ on October 27, 2009 Mail this to a friend!
Ever wish you had a simple way to plot your ARES/RACES team addresses as an overlay in Goggle Earth and use the cursor to scroll over the markers and quickly retrieve member info? I ran across a website that makes this easy.

batchgeocode.com

If you already keep a membership list with street addresses in MS Excel, then you're only a few steps away from having that data geocoded (converted to mappable lat/long). The instructions on the batchgeocode webpage lead you through the steps.

I simply open the membership Excel file and do a copy/paste into the open field on the webpage. Press the soft buttons in each step and then output the results to a Google Earth KML file.

When I want a plot, I start Google Earth, use the <FILE> <OPEN> pulldown menu options and load the KML file created by batchgeocode. The team roster is plotted on the Google Earth map and I can see member attributes such as equipment, completed training, license class, etc that were included as separate columns in the Excel spreadsheet. Clicking on a member's marker displays all the attributes.

You could expand this useful tool to other location lists. Consider a map of area fire stations, repeater towers, possible incident staging areas, etc. You can open multiple KML files for display in Google Earth.
You can produce hardcopy maps from Goggle Earth. Give it a try. Both pieces of software are free to use although you might consider a donation to the batchgeocode site if you use it a lot.

Disclaimer: I am not affiliated with batchgeocode or it's owners. I found a neat tool and thought others would find it useful.

Joseph, K9RFZ
 

  Page 1 of 1  

 
Next Topic:   Discussion on FCC Public Notice
Previous Topic:   HT Storage and transport
Email Subscription
You are not subscribed to this topic.

Subscribe!
My Subscriptions
Subscriptions Help


Search EmergencyCommunications:

Check our help page for help using Forum, or send questions, comments, or suggestions to the Forum Manager.