Finding Contacts within a certain radius

[LEsposito]

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

Thanks,

Larry Esposito

[RJLedger]

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!

[dgangi]

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