Blog posts tagged with 'zip code database'

RSS
What are CBSA Codes?- Tuesday, May 21, 2013

CBSA Codes were introduced in June 2003 by the Executive Branch of the United States under the Office of Management and Budget as a way to determine which areas in the USA had a high-degree of "cohesiveness" or interaction with each other. For example, all the cities and towns around Chicago, IL interact primarily with Chicago - knowing this information helps companies better identify their customers as well as divide sales territories.

For larger metro areas, this database also includes the Metropolitan Division (if any) in which the ZIP code lies.  Not all ZIP Codes have a CBSA code assigned to them such as rural and "middle of nowhere" ZIP Codes.

CBSAs and Metropolitan Divisions are five-digit numeric codes assigned to the 960 metropolitan, micropolitan, and division statistical areas defined by the Office of Management and Budget (OMB), a part of the administrative branch of the Federal Government.

USA - CBSA Database. The database includes ZIP Code, County FIPS, CSA Code, CSA Name, CBSA Code, CBSA Name, CBSA Type, Div Code, Div Name. The ZIP Code list is available in the following formats: Microsoft Excel 97 (or later), Microsoft Access 97 & 2000 (or later), comma-separated values, fixed-width format, and tab-delimited format. All formats are included with your purchase, and they can be imported into most databases and spreadsheets.

Comments (0)
Voted #1 for the 11th year in a Row- Tuesday, March 26, 2013

Recently, zipcodedownload was rated the #1 provider for zip code data for the 11th year in a row.  We are proud of our ranking and take great pride in providing our thousands of customers with the best and most accurate zip code database anywhere.  

When we launched 11 years ago we were the first company to provide an accurate, up to date downloadable zip code database.  We expanded our product line over the years to include Canadian postal codes and Mexican zip code databases. 

Most recently, we launched the first zip code web service to the public, making it easy for customers to plug into up to data zip code data.  Thousands have taken advantage of this new service to automate their web sites, software and apps.  

As we look forward to the next ten years, we plan to keep your trust and continue to be the #1 provider of zip code data online.  Thank you for your trust!

Comments (0)
Three and Four Digit ZIP Codes Appearing in Database- Friday, May 18, 2012
Three and Four Digit ZIP Codes

Many customers wonder why their data is including three and four digit ZIP codes. Of course, the United States Postal Service does not manufacture cities with only three and four digit ZIP codes. Most customers experience these because they are opening the data up with a program, such as Microsoft Excel, which has a default setting to eliminate zeros preceding a number. For instance, Holtsville, New York has a ZIP code of 00501. Excel will take that file, remove the zeros preceding the “5” and give you “501.”

Remedies

There are three main ways to remedy this issue:
  1. Instead of downloading the .CSV version of the file from ZipCodeDownload.com, download the “Excel (97 or later)” version. This has been preformatted to accept leading zeros.
  2. If you download the .CSV file, format the column by selecting the column and right clicking it selecting Format Cells> Number> Special> “Zip Code.”
  3. Follow the same steps in way number two but instead do …> Number> Custom> and under Type enter “00000”.

Either of these three ways are acceptable, however, we strongly recommend that you download the file type specific to the program that you will use.
Comments (0)
Will the USPS Go Out of Business?- Tuesday, March 20, 2012

Fortunately for all of us, the USPS will not be going out of business any time soon. If you are unfamiliar with what the USPS is, it is a separate agency of the U.S. government. Since 1971, the USPS has been funded directly from postage. Before then, taxes helped subsidize the costs. Now, the USPS is expected to compete with private companies such as the UPS and FedEx. Therefore, Congress doesn't provide for any of USPS' operating expenses. As of late however, the USPS has found themselves struggling financially.


Many worry that the USPS will go out of business, however, many changes are being made to the operations of the United States Post office to help mitigate some of their slowly declining losses. These changes include cutting many local post offices, processing centers from around 500 to about 200, and possibly removing Saturday's mail service.


One of the main responsibilities of the USPS is to maintain a steady and current database of ZIP codes. This database is updated monthly and receives its inputs from local post offices on boundary changes, ZIP code additions, and ZIP code subtractions. This database is not only used by the USPS by is also used by every other mailing service in the United States. These services include the Federal Express, United Parcel Service, and DHL.


This information allows us to realize the true importance of the USPS and their contribution to the United States. We can be confident that the USPS will continue to provide ZIP code databases.

Comments (0)
‘Mr Zip’ and the Zip Code Database- Tuesday, March 6, 2012

Drowning in mail and looking for a solution, over seventy years ago the USPS discovered and implemented a system to improve tracking. They started demanding a two-digit number between city and state on the address line of letters and parcels, which was a short-term fix; but the quantity of mail continued expanding. Five-digit codes were introduced within twenty years and made mandatory four years later: the first three digits send each piece of mail to a central sorting facility, where it is sorted according to the last two digits and sent to the appropriate post office for delivery.

As with many big initiatives, there was still the challenge of educating the public and helping them adopt the practice of adding numbers to the end of an address. Introduce Mr. Zip, accompanied by Ethel Merman performing ‘Zip-a-dee-doo-dah’ and bringing a friendly message to one and all. This little cartoon figure was so effective that now 95% of all addresses include the zip code, an amazing statistic. It goes to show you the impression of a marketing campaign in such a basic format for everyone to comprehend and enjoy.

Now, picture yourself trying to manage an ever-growing amount of mail and routing it correctly to millions of frequently-changing addresses every day. The challenge shifted to accuracy of address data, giving way to new solutions to be introduced. The first zip code directories were local, pencil-and-paper, affairs, ineffective, but the best thing available.

That quickly changed with the availability and power of computers, until today there are huge amounts of data accumulated in zip code databases nationally, internationally, for city and state levels and as part of every business or corporation. We can’t communicate without the location information they contain.

The national online zip code database constantly adds, updates, and verifies zip information for every person or business at every location in the country. Canada has a comparable setup; other countries have varying coverage. International corporations have them. To name just a sample, many businesses, hospitals, and educational institutes develop and use zip code directories.

There is a wide scope of capabilities that online databases provide in the zip code world. By accessing information from around the country from so many different sources, changes are quickly synched up and missing information or new addresses are added with ease. This first-time correct delivery gets mail to the right place more quickly and saves millions of dollars every year in the process.

There are zip code maps of all sorts, zip code ‘finder’ software, zip code directories, and online zip code search engines. We’ve come a long way from the Pony Express rider riding hard to deliver his cargo!