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 |
|
offspring22
Starting Member
38 Posts |
 Posted - 2010-04-13 : 18:24:36
|
| Does anyone have any experience converting an address to latitude and longitudinal coordinates? I imagine it'll require some sort of 3rd party software or service.... But a point in the right direction would be greatly appreciated! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-14 : 02:52:23
|
| In the UK we use PostCodeAnywhere - online web-service that converts postcode to address, and also has Lat/Long (plus it has a modified Lat/Long that can be used to calculated distance between two points using Pythagoras, rather than having to use the more CPU intensive curvature-of-the-earth algorithms (they may only be able to offer that service / calculation because the UK is not all that big! but based on my experience I would recommend you look into it when choosing a service as it saved a lot of work - and continues to save CPU time! |
 |
|
|
|
|
|
Address to lat/long