[AccessD] Determine Mileage Between 2 Zip Codes

Scott

...not quite, 5 digit zips are assigned to the main post offices within a
zip ...mileage is calculated between the po's, not the area boundaries
...but its still full of errors when you are concerned about actual mileage
rather than proximate ...in the only app I use zip/mileage calculations in,
a difference of a few miles isn't a concern whereas it would appear to be in
Chris's application ...except that his contract allows for exactly that type
of error by specifying the use of zip codes ...moving up to the next step
...routing software door to door mileage calculations is tremendously more
costly and is actually subject to more variables since the opening of a new
road could easily change the mileage calculations considerably ...take your
pick of poison ...in Chris's case, I'd stick with zips.

William Hindman
"War is an ugly thing but not the ugliest of things; the decayed and
degraded state of moral and patriotic feelings which thinks that nothing is
worth war is much worse. A man who has nothing for which he is willing to
fight, nothing which is more important than his own personal safety, is a
miserable creature and has no chance of being free unless made and kept so
by the exertions of better men than himself."  John Stuart Mill

----- Original Message -----
From: "Marcus, Scott (GEAE, RHI Consulting)" <scott.marcus at ae.ge.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, April 09, 2003 1:34 PM
Subject: RE: [AccessD] Determine Mileage Between 2 Zip Codes


> So 2 zip codes next to each other are zero miles appart but could total
more
> than 7 miles. Even worse, 3 zipcodes could touch each other and each be
zero
> miles appart. I think address is gonna be the only way.
>
> Scott
>
> -----Original Message-----
> From: Chris Mackin [mailto:chris at denverdb.com]
> Sent: Wednesday, April 09, 2003 1:29 PM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Determine Mileage Between 2 Zip Codes
>
>
> Scott,
>
> In DC there are no zip codes that are very large so using it as an
> approximation is an acceptable method and was specified by the contract, I
> just need to know if there's an automated way to do it.  If I can get
access
> to a system that uses the full address then that would be even better, but
> it doesn't need to be that percise.
>
> Chris Mackin
> www.denverdb.com
> Denver Database Consulting, LLC
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Marcus, Scott
> (GEAE, RHI Consulting)
> Sent: Wednesday, April 09, 2003 11:18 AM
> To: 'accessd at databaseadvisors.com'
> Subject: RE: [AccessD] Determine Mileage Between 2 Zip Codes
>
>
> Chris,
>
> Where I live, a zipcode can cover more than a 7 mile radius. I live in the
> Greater Cincinnati area. By no means would you call where I live sparse in
> population. How would you determine the difference between a zip code any
> way?
> It would have to be by address. Maybe you could automate "MapQuest" to get
> the
> distance between the office and client.
>
> Scott
>
> -----Original Message-----
> From: Chris Mackin [mailto:chris at denverdb.com]
> Sent: Wednesday, April 09, 2003 1:05 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Determine Mileage Between 2 Zip Codes
>
>
> Does anyone know of any code or software that I can use to try and get
> mileage between 2 zip codes?  The situation is this, in an insurance
> database there is a contractual obligation for my client to report on the
> number of members of the plan who live within 7 miles of one of the
> providers of the plan.  There are about 250 providers in the Washington DC
> area and approximately 15,000 members so the more automation I can get in
> this the better.
>
> Thanks,
> Chris Mackin
> www.denverdb.com
> Denver Database Consulting, LLC
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com