03-06-2011 06:31 PM
Anyone familiar with any SLX (or Excel) solutions for finding Contacts within a certain radius? Cost would be helpful too.
Thanks,
Larry Esposito
03-07-2011 05:00 AM - edited 03-07-2011 05:29 AM
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!
04-08-2011 12:40 PM
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