Home

Awesome

world-json

topojson files for countries and states/provinces

Getting the files

Download the files as a release

Translating

You'll need postgres to import all of the translations (it's a big file)

allCountries.txt

CREATE TABLE geoname (geonameid INTEGER, name VARCHAR(200), asciiname VARCHAR(200), alternatenames varchar(10000), latitude varchar(100), longitude varchar(100), class varchar(10), code varchar(10), cc char(2), cc2 varchar(100), admin1 varchar(100), admin2 varchar(100), admin3 varchar(100), admin4 varchar(100), population varchar(100), elevation varchar(100000), dem varchar(10000), tz varchar(100), updated_at varchar(100));

CREATE UNIQUE INDEX geoname_idx ON geoname (geonameid);

COPY geoname FROM 'allCountries.txt';