0

I am using SQL Server 2012 and I have a table with addresses and wish to find other addresses within say 500 feet of it. Is there a query I can write to do this task? Do I need to geo code the addresses first?

Thanks

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
SJ Johnson
  • 105
  • 1
  • 8
  • How would you calculate distance without some form of geocoding? – S3S Dec 26 '17 at 01:17
  • do you have the record of addresses that are 50 feet away in your database table?? – Farhad Rakib Dec 26 '17 at 06:11
  • yes, all records are in table. some closer than 500 feet, some farther than 500 feet. – SJ Johnson Dec 26 '17 at 06:55
  • this might help https://stackoverflow.com/questions/13026675/calculating-distance-between-two-points-latitude-longitude https://stackoverflow.com/questions/15628794/radius-search-by-latitude-longitude And yes you will need geo code first – madan Dec 27 '17 at 12:44

0 Answers0