Data Gurus... Anyone know how to put street address data in walk sequence order? - WickedFire - Affiliate Marketing Forum

NMC777 · 01-30-2011, 05:28 PM

I have a database of about 17,000 business addresses all located in 13 cities in Excel.

I am trying to find a way to group these addresses in walk sequence (in proximity to each other) to the extent possible.

If you can do this for me right away, please let me know what I can give you in return for doing it.

Thanks!

Chris

pstation · 01-30-2011, 06:17 PM

Are you trying to basically solve the Traveling salesman problem with your list of address? (Travelling salesman problem - Wikipedia, the free encyclopedia)

brentdev · 01-30-2011, 06:27 PM

put em through a bulk reverse geolocator so u can have the lat/long... add that entire set to a google maps. click the get destination.. click on your closest one... then all the ones around it... etc.... export the rss and it'll be a georss with all 17000

NMC777 · 02-06-2011, 12:19 PM

Thanks, Brent... sent PM

NMC777 · 02-06-2011, 12:20 PM

Still have not found the answer to this. I'm happy to pay a reasonable fee to anyone who can help. Thanks.

01-30-2011, 05:28 PM	#1 (permalink)
NMC777 Member Join Date: May 2010 Location: Redlands, California Posts: 88 iTrader: 4 / 100%	Data Gurus... Anyone know how to put street address data in walk sequence order? I have a database of about 17,000 business addresses all located in 13 cities in Excel. I am trying to find a way to group these addresses in walk sequence (in proximity to each other) to the extent possible. If you can do this for me right away, please let me know what I can give you in return for doing it. Thanks! Chris Share Share this post on Digg Del.icio.us Technorati Twitter

01-30-2011, 06:17 PM	#2 (permalink)
pstation Senior Member Join Date: Jul 2007 Location: Chicago Posts: 159 iTrader: 9 / 100%	Are you trying to basically solve the Traveling salesman problem with your list of address? (Travelling salesman problem - Wikipedia, the free encyclopedia) Share Share this post on Digg Del.icio.us Technorati Twitter

01-30-2011, 06:27 PM	#3 (permalink)
brentdev shamwow aficionado Join Date: Nov 2008 Posts: 469 iTrader: 14 / 100%	put em through a bulk reverse geolocator so u can have the lat/long... add that entire set to a google maps. click the get destination.. click on your closest one... then all the ones around it... etc.... export the rss and it'll be a georss with all 17000 Share Share this post on Digg Del.icio.us Technorati Twitter __________________ QuietAffiliate.com

02-06-2011, 12:19 PM	#4 (permalink)
NMC777 Member Join Date: May 2010 Location: Redlands, California Posts: 88 iTrader: 4 / 100%	Thanks, Brent... sent PM Share Share this post on Digg Del.icio.us Technorati Twitter

02-06-2011, 12:20 PM	#5 (permalink)
NMC777 Member Join Date: May 2010 Location: Redlands, California Posts: 88 iTrader: 4 / 100%	Still have not found the answer to this. I'm happy to pay a reasonable fee to anyone who can help. Thanks. Share Share this post on Digg Del.icio.us Technorati Twitter

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PR5+ Profiles LinkWheel - Amazing Results - Reviews Available	bbleo	Links & SEO	2077	10-18-2011 06:14 PM
Google Weighs Using Data for Profit	Barefootsies	Shooting The Shit	0	08-11-2010 12:56 PM
Obama's Connecticut Social Security number	Unarmed Gunman	Shooting The Shit	60	06-26-2010 12:22 AM
AT&T phases out unlimited data plans	chipmunk	Shooting The Shit	23	06-03-2010 11:10 AM