Alternative to SOUNDEX to get nearby geographical locations.

Question

CASE WHEN SOUNDEX(websiteVisitCity) = SOUNDEX(BilligCity) THEN 1 ELSE 0 END match

I'm trying to isolate travelers from receiving promotion emails from same or nearby cities. to do that I'm using their last visit city location  which is a free form field in website  and provided billing city. This fails in cases like websiteVisitCity = Concord and Billing city = Charlotte,NC. 

is there a way in SQL to identify surrounding geographical locations and ignore them . 

I do not think so but any help is appreciated. 

Thanks,

Vishal. 

 

Answer 1

you need to have table with all places and its geographic locations stored 

Then you can check the logic in T-SQL to identify close proximity places

As an example see

https://docs.microsoft.com/en-us/sql/relational-databases/spatial/query-spatial-data-for-nearest-neighbor?view=sql-server-2017

---

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page