|
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
|
|
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
|
|   |
|
Email Subscription
You are not subscribed to this topic.
Subscribe!
My Subscriptions
Subscriptions Help
Check our help page for help using
Forum, or send questions, comments, or suggestions to the
Forum Manager.
|
|
|