[AccessD] Determine Mileage Between 2 Zip Codes

Marcus, Scott (GEAE, RHI Consulting) scott.marcus at ae.ge.com
Wed Apr 9 12:34:44 CDT 2003


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


More information about the AccessD mailing list