asked
get the address from the latitude and longitude in sql server 2008 r2?
Hi to all, i have the table which holds latitude and longitude, based on that i have to get the address in sql server 2008 r2 itself, is it possible? Please give the solution to get the proper address from latitude and longitude Thanks in advance.
If you mean the street address, you're going to need a dataset that contains the street addresses and some means of mapping that to the lat/long For example, in the UK the Ordnance Survey publishes a data set that maps postcodes to the British National Grid system that can be converted to lat/long and then mapped to a set of street addresses, but there is no intrinsic functionality in SQL Server for that
15 People are following this question.
