Re: Shipping application help

Scott:

We use the Zip Code/Area Code/Time Zone database from KJL Software (www.kjlsoftware.com). It contains:

Zip Code
City
State
USPS Status Code
Area Code(s)
Time Zone
Latitude
Longitude

for the rougly 52000 valid US zip codes.

It's a monthly subscription service. They also have some DLLs for accessing the USPS web site for zip and zip+4 data.

HTH J
sjblanky_at_yahoo.com (Scott Blankenship) 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...
Received on Wed Jan 08 2003 - 22:15:01 CET