Hello All!
I am using Google Maps to plot points based on addresses I receive
from users, those addresses are submitted into my Microsoft SQL
database.
My questions are when would I want to convert those addresses into Geo
Code and how to do that? These are my thoughts on how to, sorted in
best to worst -
1. Have those addresses verified against geocode before they are
submitted into my database and then if they have errors with the
address notify the user before they get submitted. I would also want
to insert the Geo Code also. I think I can verify the address through
the following code here <http://code.google.com/apis/maps/
documentation/services.html> although I don't know how to implement
that code into my "submit.aspx" page.
2. When the address is submitted have a seperate verification on the
address to let the user know the address cannot be converted into a
map point. After the addresses are input into my database have google
map access the address from my database, convert it to geocode, then
plot the points on the map.
3. Don't verify Address. After the addresses are input into my
database have google map access the address from my database, convert
it to geocode, then plot the points on the map.
Obviously I want to use #1. Any help will be great of you!
|
