GitHub - basicxman/CountriesAndSubdivisions: List of countries and their subdivisions in SQL format (with Ruby code to generate).

basicxman / CountriesAndSubdivisions Public

Notifications You must be signed in to change notification settings
Fork 0
Star 4

List of countries and their subdivisions in SQL format (with Ruby code to generate).

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 12 Commits
README		README
cdh_download_08_24_2010.txt		cdh_download_08_24_2010.txt
generator.rb		generator.rb
output.sql		output.sql

Repository files navigation

Takes a semicolon delimited list from http://www.commondatahub.com/live/geography/state_province_region/iso_3166_2_state_codes
and generates an SQL table which contains a comma separated list of subdivisions
within a country.

Selected Columns from CommonDataHub:
~Country Name
~ISO 3166-2 Subvision/State Name

To run,
./generator.rb file_to_process.txt
or
ruby generator.rb file_to_process.txt