All Countries States Cities and Zipcodes in a Application

Question

Is there a way getting all countries, states,cities zipcodes/ in one single database.

I have been looking all over.

I discovered geonames.org, which has I guess all of the content. But there is no way to fetch that data directly.

I am using rails. If there any helpers or Plugins, it'd be great. It would be awesome if there is a complete resource in any parsable format which I can use to get this database in place.

Please recommend if you any thanks

I do have the iso country code list but no States for some countries.

Thanks in advance

Answer 1

Thanks Guys,

I got all the the countries and states of all of them, but no zip codes.

http://27.org/isocountrylist/iso_country_list.sql

This contains all countries, and there iso-3166 codes ( Siberia code needs to be changed from "CS" to "RS")

And here is the FIPS file for countries with states

http://www.maxmind.com/app/fips_include

For zip code validation I am using

http://www.geonames.org webservices

There is a geonames ruby gem as well, which makes it really simple to do zipcode validations

Hope that helps anybody who needs this information, worth keeping it handy for web projects.

Another Link ( thanks @laise ): http://dev.maxmind.com/static/csv/codes/maxmind/region.csv