Jim Dettman
jimdettman at verizon.net
Wed Sep 5 10:23:04 CDT 2012
Thanks Doug. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Wednesday, September 05, 2012 11:12 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] OT: US Zip codes Jim, It might be worth looking at the Google maps api. I did some experimenting a few years ago and was able to resolve addresses to lat/long and zip. There are some restrictions as I recollect like having a Google account, limited number of queries per day, etc. Depending on your requirements it might work. I would think Google would keep current on zip changes, but that is an assumption. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Wednesday, September 05, 2012 6:34 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] OT: US Zip codes Michael, Thanks for that. Raises a lot of issues moving forward too...many companies base sales tax on zip or zip+4. Zip+4 is a lot more accurate, but it's a royal pain to verify street addresses, especially on web orders, so many (including my client) only base sales tax on zip. The problem with that however is there can be a mis-match between taxing jurisdictions and postal zones. In the past, it wasn't enough to worry about and every state I'm aware of accepted sales tax based on zip. With post offices closing down however, that mis-match will only get larger. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael Mattys Sent: Tuesday, September 04, 2012 11:49 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] OT: US Zip codes Believe it or not, they simply discontinued that Zip Code. It appears that the post office was shut down there so the new identifier is a placename: Cadiz, OH 43907. Michael R Mattys Mattys Consulting, LLC www.mattysconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Tuesday, September 04, 2012 2:04 PM To: AccessD List Subject: [AccessD] OT: US Zip codes All, A while back, a link was posted on the list for a geo database containing all US Zip codes, which was part of a web site. Recently with a client, I had reason to compare this list with one provided by CCH for CA and OH for sales tax purposes. When I compared the two, I found 231 zips that existed in the Geo database that were not in the CCH database. Checking the web, I found a few web sites saying these were valid, but after contacting CCH, they pointed out that they are not according to the US Post Office. One such is: '43989','Short Creek','OH','40.296490','-81.102502',-5,1,'us' We discovered this when my client had a customer place an order using this zip and it didn't calculate sales tax. According to the US Post office and UPS, it's not a valid zip. Yet the city name the customer entered matches the geo database entry and a couple of sites out on the web (i.e. www.uszips.com <http://www.uszips.com/> ) Anyone worked with US zip codes and might have an idea of where the disconnect is or why? I'm left scratching my head between a customer that believes they are using a valid zip and USPS and UPS saying it's not. Jim. -- 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