Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Elite Contributor
Posts: 153
Registered: ‎02-27-2010

Finding Contacts within a certain radius

Anyone familiar with any SLX (or Excel) solutions for finding Contacts within a certain radius? Cost would be helpful too.

 

Thanks,

Larry Esposito

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Finding Contacts within a certain radius

[ Edited ]

You need to expand the address record and add latitude/longitude - the rest is straight forward computer science/basic math (trig).

 

Here are come sites that have some free code:

  http://www.zip-codes.com/zip-code-radius-app.asp

  http://forums.aspfree.com/code-bank-54/distance-calculation-for-asp-vbscript-398426.html

  http://www.zipcodeworld.com/samples/distance.vb.html

 

Take a look hare as well:

  http://www.movable-type.co.uk/scripts/latlong.html

 

NOTE: BE careful because some of these approaches can lead to error in short distances - The "circle" approach can be off up to 3%.

 

We recommend http://www.zip-codes.com to our clients. The standard version will supply you with all the raw data you need. AT $399/year.. not to shabby!

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Tuned Listener
Posts: 14
Registered: ‎05-28-2009

Re: Finding Contacts within a certain radius

Larry - we already developed such a solution.  We call it "Proximity Search" and we have versions for both SLX Windows and Web 7.5. 

 

Send me an email if you want more information and pricing.

 

Thx...Doug

 

 

Doug Gangi
VP Professional Services
Strategic Sales Systems
dgangi@sssworld.com