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: 226

Filed under:

google-maps

|

maps

|

google-maps-markers

|

google-earth

|

yahoo-maps

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

Related posts about google-maps

DirectionsDistance in google maps API v3

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, I'm trying to work out how to use this to get the distance from the successful directions: http://code.google.com/apis/maps/documentation/v3/reference.html#DirectionsDistance This is the code I have so far: var googleMaps = { // HTML Nodes fromInput: google_maps_from, toInput: google_maps_to… >>> More
Why does Internet Explorer break "pegman" display in Google Maps API v3?

as seen on Stack Overflow - Search for 'Stack Overflow'
On my site here, the SteetView control, aka "Pegman", works great under Firefox. Under IE (7 in this case, but tested on 8 as well - same result) it breaks the display of the pegman control. Here's my map code: var directionsDisplay; var directionsService = new google.maps.DirectionsService(); var… >>> More
How can I put multiple markers on Google maps with Javascript API v3?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'd like to know how to put multiple markers for Google Maps using Javascript API v3. I tried the solution posted here: http://stackoverflow.com/questions/1621991/multiple-markers-in-googe-maps-api-v3-that-link-to-different-pages-when-clicked but it does not work for me for some reason. var… >>> More
Multiple markers in Googe Maps API v3 that link to different pages when clicked

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a map with multiple markers, which I populate via an array. Each marker is clickable and should take the user to a different url per marker. The problem is that all the markers, while displaying the correct title, all use the url of the last entry in the array. Here is my code: var myOptions… >>> More
Problem to display 3D google map.

as seen on Stack Overflow - Search for 'Stack Overflow'
hello friends, I have implemented one Flex application in which I want to display 3D google map.In which I am getting the error the NUll object reference during map display. Here is my code:- import com.google.maps.controls.MapTypeControl; import adobe.utils.XMLUI; import mx.rpc… >>> More

Related posts about maps

Easily use google maps, openstreet maps etc offline.

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I did it and i am going to explain step by step. The explanatination may appear long but its simple if you follow. Note: All the softwares i have used are the latest and i have packaged them and provided them in the link below. I use Nokia N96 1) RootSign smartComGPS and install it on your phone(i… >>> More
add shapes to bing maps from locations stored in a database (bing maps ajax control)

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to use the Bing Maps Ajax Control to plot pins of locations stored in a database to the bing map on a web page. All the locations are geocoded and the lat longs stored in the database. I am using ASP.NET (C#), but can't figure out or find any tutorials on how to go about doing this. All… >>> More
JSF and usage of gdata maps or js maps api

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am building jsf component for map servers and I was wondering if it is possible to use gdata maps api to update or retrieve new map which isn' t user map or i have to create Javascript binding for JSF. Regards Jan >>> More
Why does Internet Explorer break "pegman" display in Google Maps API v3?

as seen on Stack Overflow - Search for 'Stack Overflow'
On my site here, the SteetView control, aka "Pegman", works great under Firefox. Under IE (7 in this case, but tested on 8 as well - same result) it breaks the display of the pegman control. Here's my map code: var directionsDisplay; var directionsService = new google.maps.DirectionsService(); var… >>> More
Alternative to google map api, so that I can use it on a HTTPS/SSL encrypted website.

as seen on Stack Overflow - Search for 'Stack Overflow'
I did find a solution for this on Google map api page, and I made the following changes as mentioned in it. 1.Use Google Maps API for Flash version 1.9a or later. 2.Add the following to your Flash application before the map is instantiated: Security.allowInsecureDomain("maps.googleapis.com"); Ref:http://code… >>> More