GitHub - fox-eye/Rails-Seed-All-Countries-and-All-States: A script to generate a seed file from a database of all countries and all of their states or regions for use inside a Rails application.

fox-eye / Rails-Seed-All-Countries-and-All-States Public

Notifications You must be signed in to change notification settings
Fork 13
Star 1

A script to generate a seed file from a database of all countries and all of their states or regions for use inside a Rails application.

1 star 13 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 2 Commits
README		README
admin1CodesASCII.txt		admin1CodesASCII.txt
countryInfo.txt		countryInfo.txt
parse_countries.php		parse_countries.php
state_country_seeds.rb		state_country_seeds.rb

Repository files navigation

To get a new seeds.rb file, just run parse_countries.php.

This will build a seeds file to populate countries and states tables with all countries in the world along with all of their admin 1 regions. These regions correspond to what would be a state within the US. The generated file should be in utf8.

The database model is pretty straightforward:

countries:
	id 
	name
	iso #An ISO abbreviation for the country
states:
	id
	name 
	country_id #the parent country's id, references an entry in countries.
	iso #An ISO abbreviation for the region.

A special thanks to geonames.org for making all of this information available. You can find updated copies of the data files at:

http://download.geonames.org/export/dump/