Chris Mackin
chris at denverdb.com
Wed Apr 9 14:30:46 CDT 2003
Just wanted to say thanks to all who responded, your input is appreciated. Chris Mackin Denver Database Consulting, LLC www.denverdb.com -----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 12:10 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Determine Mileage Between 2 Zip Codes William, Thanks for the explanation. I think this site could get you a pretty accurate distance... http://www.melissadata.com/AddressObject/addressobject.htm Scott -----Original Message----- From: William Hindman [mailto:wdhindman at bellsouth.net] Sent: Wednesday, April 09, 2003 1:52 PM To: accessd at databaseadvisors.com Subject: Re: [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 _______________________________________________ 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