Git Product home page Git Product logo

world.db's Introduction

Willkommen - Benvenuto - ようこそ - Bienvenido - Welcome to world.db

A free open public domain world database & schema for use in any (programming) language (e.g. uses plain text datasets). Example:

### Continents (& Regions)

eu, Europe
sa, South America
na, North America
ca, Central America
ci, Caribbean
af, Africa
me, Middle East        
as, Asia
pa, Pacific          # includes Australia & New Zealand
aq, Antarctica
### Countries

ca, Canada,          CAN, Ottawa,          9 984 670 km²,   34 278 406
mx, México [Mexico], MEX, México D.F.,     1 972 550 km²,  112 322 757
us, United States,   USA, Washington D.C., 9 629 091 km²,  314 167 157
### Tags - Political Organizations

Canada,         un|g8|g20|commonwealth
United States,  un|g8|g20
México,         un|g5|g20
### Tags - Sports Organizations

Canada,         ioc|fifa › concacaf › nafu
United States,  ioc|fifa › concacaf › nafu
México,         ioc|fifa › concacaf › nafu
### Provinces

bc, British Columbia,       Victoria,         922 509 km²

ab, Alberta,                Edmonton,         640 082 km²
mb, Manitoba,               Winnipeg,         552 330 km²
sk, Saskatchewan,           Regina,           588 239 km²

nb, New Brunswick,            Fredericton,     71 377 km²
ns, Nova Scotia,              Halifax,         52 939 km²
pe, Prince Edward Island,     Charlottetown,    5 686 km²
nl, Newfoundland and Labrador,  St. John's,   370 511 km²

on, Ontario,                Toronto,          908 608 km²
qc, Québec,                 Quebec City,    1 356 547 km²

nt, Northwest Territories,  Yellowknife,    1 143 793 km²
yt, Yukon,                  Whitehorse,       474 713 km²
nu, Nunavut,                Iqaluit,        1 877 788 km²
### Tags - Geo Regions

British Columbia,  western_canada

Alberta,           western_canada|prairies
Manitoba,          western_canada|prairies
Saskatchewan,      western_canada|prairies

New Brunswick,        eastern_canada|atlantic_canada|maritimes
Nova Scotia,          eastern_canada|atlantic_canada|maritimes
Prince Edward Island, eastern_canada|atlantic canada|maritimes
Newfoundland and Labrador, eastern_canada|atlantic_canada

Ontario,              eastern_canada|central_canada
Québec,               eastern_canada|central_canada

Northwest Territories,  northern_canada|territories
Yukon,                  northern_canada|territories
Nunavut,                northern_canada|territories
### Tags - (Official) Languages

British Columbia,          en

Alberta,                   en
Manitoba,                  en
Saskatchewan,              en

New Brunswick,             en|fr
Nova Scotia,               en
Prince Edward Island,      en
Newfoundland and Labrador,  en

Ontario,                    en
Québec,                     fr|en

Northwest Territories,      en|fr
Yukon,                      en
Nunavut,                    iu|en|fr
### Cities

Toronto,            ON,   5 583 064
Montréal|Montreal,  QC,   3 824 221
Vancouver,          BC,   2 313 328
Ottawa,             ON,   1 236 324
Calgary,            AB,   1 214 839
Edmonton,           AB,   1 159 869
Québec,             QC,     765 706
Winnipeg,           MB,     730 018
Hamilton,           ON,     721 053
Kitchener,          ON,     477 160
London,             ON,     474 786
...
### Country Codes - Alpha 2, Alpha 3, Numeric

Afghanistan,         AF, AFG, 004
Åland Islands (FI),  AX, ALA, 248
Albania,             AL, ALB, 008
Algeria,             DZ, DZA, 012
American Samoa (US), AS, ASM, 016
Andorra,             AD, AND, 020
Angola,              AO, AGO, 024
...

More world.db Project Site »

Build Your Own world.db Copy

Use the worlddb command line tool to build your own world.db copy from the plain text datasets. More »

License

The world.db schema, scripts, n datasets are dedicated to the public domain. Use it as you please with no restrictions whatsoever.

Questions? Comments?

Send them along to the Open World Database (world.db) and Friends Forum/Mailing List. Thanks!

world.db's People

Contributors

3rn3st0 avatar geraldb avatar pabloveintimilla avatar vessovit avatar williamgueiros avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

world.db's Issues

brazilian citys

hello i am from brazil and i don't have problem to add all states and city from brazil in you database.. now i don't wanted this solution but if you like, i add it for you... do you like this idea?

Why use this versus <other solution>?

The unique points I see to this project are:

  • public domain (geonames is fairly open though)
  • build your own DB easily

Unless I am mistaken, it looks like this should just be a tool to export geonames data into a sqlite db that includes only stuff you need. I think a tool like that would be pretty cool.

Anyway I hope you don't take this the wrong way, I am just looking for the rationale behind starting yet another open countries/cities db?

Looking for opportunity to contribute

Hi, i'm looking for any opportunity to contribute to this project, especially for my country data (Indonesia). Is there anything like contribution guideline?

creating copy fails

Here is the output on Ubuntu 12.04 with Ruby 1.9.3.

$ git clone git://github.com/openmundi/world.db.git
$ worlddb setup --include ./world.db
confdb/1.1.1 on Ruby 1.9.3 (2011-10-30) [x86_64-linux]
tagutils/0.2.2 on Ruby 1.9.3 (2011-10-30) [x86_64-linux]
  [TagDb.has_many_tags] adding taggings n tags has_many assocs to model >WorldDb::Model::Country<
  [TagDb.has_many_tags] adding taggings n tags has_many assocs to model >WorldDb::Model::Region<
  [TagDb.has_many_tags] adding taggings n tags has_many assocs to model >WorldDb::Model::City<
worlddb/2.0.4 on Ruby 1.9.3 (2011-10-30) [x86_64-linux]
logdb 0.6.0 on Ruby 1.9.3 (2011-10-30) [x86_64-linux]
worlddb/2.0.4 on Ruby 1.9.3 (2011-10-30) [x86_64-linux]
worlddb/2.0.4 on Ruby 1.9.3 (2011-10-30) [x86_64-linux]
working directory: /home/pedela/source/worlddb
Connecting to db using settings: 
{:adapter=>"sqlite3", :database=>"./world.db"}
-- create_table(:logs)

*** error: unable to open database file

Then I tried executing worlddb inside the repo directory which succeeded.

$ git clone git://github.com/openmundi/world.db.git
$ cd world.db
$ worlddb setup
WORKS!!!

Countries names are incorrect

Country names are wrong.

Argentinien is not the name of the country, it's the name of the citizens of country Argentina.
Same for Brasilien, Spanien, Italien.

Totally inaccurate, then useless.

Stuck while exceution of setup with world.db

Running sportdb --dbname football.db setup --worldinclude world.db stucks after printing following to the console:

[...]
[Name.parse] adding Name record:
  {:place_id=>730, :place_kind=>"CITY", :name=>"Gujranwala"}
[Name.parse] adding Name record:
  {:place_id=>730, :place_kind=>"CITY", :name=>"Gujranwala"}

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.