Plotting 500 US cities to a map
Posted
by
sqlman
on Stack Overflow
See other posts from Stack Overflow
or by sqlman
Published on 2011-11-18T04:00:20Z
Indexed on
2012/11/30
11:05 UTC
Read the original article
Hit count: 230
I have 500 US cities in a MySQL table. I have the city name, state, longitude and latitude. I want to visually see these cities plotted on a map of the US.
How can I do this? Are they any free tools available? Google Maps or Google Earth maybe?
Obviously, it would take forever to plot each city individually. So I need a quick way of doing it, either through a program or by exporting the table as a spreadsheet and uploading it into some kind of generator that will do the plotting for me.
Please let me know your ideas. Thanks.
© Stack Overflow or respective owner