[jsheusi]

Hi All,

Is there a database anywhere that would take an address in a SQL query and return the latitude and longitude for it? I am working on an application where someone would submit an address by a web page, then a backend server would look up the L&L for it.

Thanks

Jim

[modi123_1]

Well MSSQL2008 has a new geospatial data type..
http://www.microsoft...atial-data.aspx

... but that's only for storage. What it sounds like is you want to have the user input an address.. then you program jumps out to the maps.google api to get the spatial info, and then save that?

[jsheusi]

Yes, Modi123_1, Thanks. But I spent an hour plowing through the GoogleMaps stuff and I can only find Javascript stuff for sending and address and getting back a whole web page. I just want the two fields to come back, and I would rather not post a web page; I just want to send a query eg. querying a remote MySQL query over port 3306.

Isn't that possible?

Thanks again,

Jim

modi123_1, on 23 December 2010 - 09:14 AM, said:

Well MSSQL2008 has a new geospatial data type..
http://www.microsoft...atial-data.aspx

... but that's only for storage. What it sounds like is you want to have the user input an address.. then you program jumps out to the maps.google api to get the spatial info, and then save that?

[modi123_1]

Have you even looked at the GeoCoding from google? Give it an address and it gives you an xml of the lat and longitude!

http://code.google.c...tion/geocoding/


Say with .NET you can ping that api with address and snag the part of the geocoding one wants pretty quickly. What are you writing this in?

As far as your thought of going to a database - ah.. no, not that I know of. Everyone should have an API to go through...


Here's a quick run through of how to use the google api.
http://webhole.net/2...-and-longitude/

[jsheusi]

Thanks again, Modi,

I ended up parsing the JSON response and got what I needed.

Thanks again,

modi123_1, on 23 December 2010 - 11:34 AM, said:

Have you even looked at the GeoCoding from google? Give it an address and it gives you an xml of the lat and longitude!

http://code.google.c...tion/geocoding/


Say with .NET you can ping that api with address and snag the part of the geocoding one wants pretty quickly. What are you writing this in?

As far as your thought of going to a database - ah.. no, not that I know of. Everyone should have an API to go through...


Here's a quick run through of how to use the google api.
http://webhole.net/2...-and-longitude/