Want Help Organizing Zip Code Information

[RockHillWill]

I am interested in being able to determine some information that will result in being able to take one zip code (A National Meet for instance) and review the zip codes shown on the registration forms to determine the distance a determined percentage of the attendees were willing to travel.

When I was in stock car racing and seeking sponsorship, NASCAR had some demographics that shown for a particular event 80% of the attendees travel from within a 250 mile radius. I want to be able to determine this information for some of the past national and regional events in an effort to determine the distance at which certain events in a specified time frame might be liable to detract from each other.

I would think this is not a difficult piece of information to determine, but I do not have the skills nor the hardware at this time to achieve this. Can anyone suggest to me a piece of affordable software that I might acquire or guide me in same manner to some one that might be of assistance?

Thanks in advance for any offer of assistance.

[whirnot]

http://www.melissadata.com/lookups/z...634&zip2=97707

[whirnot]

The above, and most calculators I found are the distance as the crow flies, not driving distsnce, but you could probably come up with an average adder that would be close. I would add 20%

[Marco Tahtaras]

Originally Posted by whirnot

The above, and most calculators I found are the distance as the crow flies, not driving distsnce, but you could probably come up with an average adder that would be close. I would add 20%

Yep, the example on their page shows 888.4 mile while mapping the same shows 1,180 or 1,254 depending on route. The difference is substantial!

[pat59]

Not for nothing, but if ya add 20% to every calculation don't they all come out in the same order anyway?
-Pat

[Bob Johnson]

Sponsored Links (Register now to hide all advertisements)

Will,

I just wrote a Linux shell script that will do what you want to do. It takes the list of Zip codes and looks up the driving distances on Google. It then makes a list of distances from every zip code. If you send me a list of zip codes I can send you back a list of distance. If you happen to have a computer running the Linux operating system I can send you the code.

Bob

[CarlG]

Anchorage to Seattle -- by air = 1,488 miles
To drive it = 2,546

(I've done both!)

[Gary WA]

Originally Posted by CarlG

Anchorage to Seattle -- by air = 1,488 miles
To drive it = 2,546

(I've done both!)

Carl you know Jim Fredenhagen. Nice fellow. He flew us from anchor. to Larsen Bay in Sept. Go up there fishing every year at Kodiak Lodge.Didn't mean to steal the thread!!! Just a ???

[CarlG]

Originally Posted by Gary WA

Carl you know Jim Fredenhagen. Nice fellow. He flew us from anchor. to Larsen Bay in Sept. Go up there fishing every year at Kodiak Lodge.

Jim is practically my neighbor, and my chief mentor! He occasionally gets to work on Lilly (his '29 Tudor) when he's not working on Boyd's, Larry's, Rich's, Bob's, Lee's, (add about 10 more names) or my vehicle. Great guy!

[Gary WA]

Originally Posted by CarlG

Jim is practically my neighbor, and my chief mentor! He occasionally gets to work on Lilly (his '29 Tudor) when he's not working on Boyd's, Larry's, Rich's, Bob's, Lee's, (add about 10 more names) or my vehicle. Great guy!

Thanks. Tell him Hello. Have "A" Great Holiday.

[spdway1]

Originally Posted by CarlG

Anchorage to Seattle -- by air = 1,488 miles
To drive it = 2,546

(I've done both!)

In a Model A?

[CarlG]

Originally Posted by spdway1

In a Model A?

Air = Boeing 737
Ground = 1979 Honda Acord

[spdway1]

Originally Posted by CarlG

Air = Boeing 737
Ground = 1979 Honda Acord

AHH, ok!

[RockHillWill]

Thank you guys, I have been getting some GREAT help!