Re: Web service call to determine distance between 2 zip codes

[x y <xy6581@xxxxxxxxx>]

I think there are commercial databases with ZIP-to-ZIP mileages.  But
distances between ZIP codes can be accomplished by getting a ZIP and/or
city database with latitude and longitude and then computing miles from
lat/lon.  I have a routine with a bit of spherical geometry that computes
"great circle" miles from those coordinates and it's very fast.  With a
large sample size, the GC distances and the Google-ized "road mile"
distances will end up being very close (but Google does screw up every now
and then).

An issue with road miles from Google, Trimble, Rand-McNally and others is
this: the actual (what the driver drove) routings may vary depending upon
traffic, highway availability, tolls, speed limits, and the nature of the
shipment(s) (stop-offs, etc.).  Because of the gazillions of from-to
combinations, a database solution may not be good if you're looking at
1,000,000 shipments because each route has to be computed, usually with a
fair amount of database IO.  The tradeoff is more accurate miles and a
performance impact or less accurate miles and very little performance
impact.  And vendors change their routing algorithms, thereby causing
calculated miles to change spontaneously.


On Fri, Dec 2, 2022 at 5:12 AM Alan Shore via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> Hi everyone
> We are on V7r3
> I have been given a task to extract data concerning packages that have
> shipped
> Part of that data is to determine the distance between the origin zip code
> and the destination zip code
> Does anyone have code (and is willing to share it) for a web service call
> to obtain this information?
> As always - all answers gratefully accepted
>
> Alan Shore
> Solutions Architect
> IT Supply Chain Execution
>
> [cid:image001.png@01D90625.BD2AB6B0]
>
> 60 Orville Drive
> Bohemia, NY 11716
> Phone [O] : (631) 200-5019
> Phone [C] : (631) 880-8640
> E-mail : ASHORE@xxxxxxxxxxxxxxxxxxxx
>
> 'If you're going through hell, keep going.'
> Winston Churchill
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com