Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
geocode
Starting Member
2 Posts |
 Posted - 2008-07-09 : 18:42:55
|
| Well, I THOUGHT this would be trivial, but so far I'm not finding the simple answer.......Table in database has address - street1, 2, 3, city, state, zip. Want to get latitude and longitude for the data. I want to do this in a SQL Server procedure - no interface, just read the records in the table, get lat and long, update table....I figure SOMEBODY has to have done this... |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-09 : 22:22:39
|
quote:
Originally posted by geocode
Well, I THOUGHT this would be trivial, but so far I'm not finding the simple answer.......Table in database has address - street1, 2, 3, city, state, zip. Want to get latitude and longitude for the data. I want to do this in a SQL Server procedure - no interface, just read the records in the table, get lat and long, update table....I figure SOMEBODY has to have done this...
What do you mean by this |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-09 : 22:25:45
|
| Try google it, I saw someone did it. |
|
|
|
geocode
Starting Member
2 Posts |
Posted - 2008-07-10 : 00:57:50
|
| Actually I've googled it repeatedly. Apparently, I'm not looking for the right thing 'cause I've found several but they aren't for SQL Server. They're all Javascript or some equivalent. I need to read the address records from a table, get the latitude and longitude of each address record and update the table with the info... This CAN'T be the first time anybody tried to add geocode info to a SQL Server database. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
|
|
|
|
|
Latitude and Longitude in SQL Server