Pages

Thursday, February 3, 2011

Zip codes, postal codes, states, counties, countries of the world!

Surprisingly, it is very hard to find a good download of zip/postal codes, states, countries, etc.  Many places charge for this up to date information.  Where I work, there is often an excel file being emailed around the office with zip codes that were harvested from some other system that we dump into clients' systems.  It's sort of a copy-paste mash of different countries that we've slowly built and it's mostly there.

Well a somewhat unknown site that is available under a creative commons attribute license that is incredibly comprehensive is GeoNames.org.

What I did is go to:

Grab the latest allCountries.zip, import into excel (tab delimited), then throw some filters on there and use it as your master country/zip/state/county/etc list.

The site is a little difficult to navigate and they have many giant data dumps...for example, there are two "allCountries.zip" files I've come across.  One has the good stuff (ISO country, zip, state, county, etc), and the other has stuff that I can't really find a use for (population, elevation, etc).

Hope this saves somebody else a headache when they get a client who does business globally!

5 comments:

  1. Freedom of Information and Access to Information legislation to obtain unpublished datasets from public agencies.
    Email This
    BlogThis!
    Share to Twitter
    Share to Facebook
    Share to Pinterest liteblue.usps.gov login

    ReplyDelete
  2. "At PostalEASE, the phone version of the Liteblue USPS Gov employee portal, employees can begin TSP .gov payments or access Federal Employees Health Benefits. Visit the Liteblue PostalEASE website for more." Postal Ease

    ReplyDelete
  3. The Postal Reorganization Act changed the face of the organization, particularly relating to its labor relations, financials and transportation. liteblue usps No one could put anything inside of those boxes, and American citizens had been conditioned to go check the mail daily to see what was inside.

    ReplyDelete
  4. There are many facts regarding the USPS that lead to the growth of the LiteBlue services to manage it better.

    ReplyDelete
  5. I am very happy to discover your post as it will become on top in my collection of favorite blogs to visit. mosmmo.com

    ReplyDelete