Link to home
Start Free TrialLog in
Avatar of geoffsweb
geoffsweb

asked on

Google Maps from SQL table

I am using ASP.NET with C#

I am looking to insert a Google Map onto my web site... I'd like the map to plot points on the map that come from a MS SQL table.  The table will have address, city, state, zip, etc.... from what I'm ready, this will need to be converted to lat/long?  Are there any examples out there or articles/blogs that start you from the beginning and walk you through this process from beginning to end? (Plugging to Google Map API + converting to lat/long + dynamically grabbing data)

Thanks!
Avatar of wdosanjos
wdosanjos
Flag of United States of America image

I suggest using the Google Maps JavaScript API.

JavaScript API Main Page
http://code.google.com/apis/maps/documentation/javascript/

JavaScript API Tutorial
http://code.google.com/apis/maps/documentation/javascript/tutorial.html

The process of converting an address to Lat/Lng is called Geocoding, which is supported by the JavaScript API.  More details here:
http://code.google.com/apis/maps/documentation/javascript/services.html#Geocoding

I hope this helps.
Avatar of MaxOvrdrv2
MaxOvrdrv2

and just f.y.i., with the API, you don't need to convert to Lat-Lng manually... the API has a function for it (it's like searching in google map directly), which returns lat-lng coordinates, or a @not found@ error code, for the searched location. However, this comes at a cost... a lot of overhead.

For example, i was loading about 300 points on my map, all from locations. With the function to convert location through API, it might have taken about 30-40 seconds to load the map... but then i created a table a stored all the lat-lng coordinates in there, and loading directly from lat-lng took at most 2 seconds to load all 300.

i've implemented this before, and it's easy to use, but again, at a cost... see every time you call the function to convert, it makes a call to the google servers, and comes back... so... f.y.i.
Avatar of geoffsweb

ASKER

Thanks for the suggestions.  I was hoping to find smoething other than the Google documents.  I prefer reading somebody elses blog/tutorial/article that has simplified the process and gives examples of what to do and what not to do.
ASKER CERTIFIED SOLUTION
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial