Re: Shipping application help

Don't know the answer to your question, but look up info on zip+4. It is supposed to get you within like half a block of the person. Maybe the post office has (usps.gov) this info. I know they used to sell the zip code info with city and state. Perhaps they sell the zip+4 and it includes more information.
Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Scott Blankenship" <sjblanky_at_yahoo.com> wrote in message
news:63206a4f.0301080605.59186f3c_at_posting.google.com...


> We have 80 warehouses across the country. What we'd like to implement

> is a shipping routine that will determine the warehouse that will

> generate the cheapest shipping cost to our customers.

>

> I've thought of snagging a table of zipcodes and their

> latitude/longitude, and generating a distance measurement for that, to

> see which is closest. That's pretty easy to do. Then someone suggested

> that if a customer is on a "shipping zone" border, we might prefer to

> ship from a further warehouse in the same shipping zone rather than a

> closer warehouse that crosses shipping zones.

>

> Do any of you implement this kind of thing? Where do you get your data

> to populate in oracle for zipcodes and coordinates? Do any of you

> implement the zone concept? Do the major shipping companies use the

> same zones?

>

> If anyone can give me some guidance, I'd appreciate it...