Skip to content
This repository

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

Open World Database & Schema

branch: master

Fetching latest commit…

Octocat-spinner-32-eaf2f5

Cannot retrieve the latest commit at this time

Octocat-spinner-32 db
Octocat-spinner-32 script
Octocat-spinner-32 .gitignore
Octocat-spinner-32 README.md
Octocat-spinner-32 world.db
Octocat-spinner-32 world.sql
README.md

Welcome to world.db

A Free Open World Database & Schema

Usage

Get a copy of the world.db file. That's it.

Demo

Try the world.db Web Admin demo running on Heroku worlddb.herokuapp.com.

Tables, Schema

The world.db includes the following tables:

  • countries
  • regions
  • cities

[add schema pic here]

countries Table

CREATE TABLE "countries" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  "title" varchar(255) NOT NULL,
  "key" varchar(255) NOT NULL,
  "tag" varchar(255) NOT NULL,
  "synonyms" varchar(255),
  "pop" integer,
  "area" integer,
  "created_at" datetime NOT NULL,
  "updated_at" datetime NOT NULL
);

regions Table

CREATE TABLE "regions" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  "title" varchar(255) NOT NULL,
  "key" varchar(255) NOT NULL,
  "synonyms" varchar(255),
  "country_id" integer NOT NULL,
  "pop" integer, "area" integer,
  "created_at" datetime NOT NULL,
  "updated_at" datetime NOT NULL
);

cities Table

CREATE TABLE "cities" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  "title" varchar(255) NOT NULL,
  "key" varchar(255) NOT NULL,
  "synonyms" varchar(255),
  "country_id" integer NOT NULL,
  "region_id" integer,
  "pop" integer,
  "area" integer,
  "capital" boolean DEFAULT 'f' NOT NULL,
  "created_at" datetime NOT NULL,
  "updated_at" datetime NOT NULL
);

Command Line Tool

worlddb - world.db command line tool, version 0.2.0

Usage: worlddb [options]
    -c, --create                     Create DB Schema
        --delete                     Delete all records
        --load                       Use Loader for Builtin World Data
    -i, --include PATH               Data Path (default is .)
    -v, --version                    Show version
        --verbose                    Show debug trace
    -h, --help                       Show this message


Examples:
    worlddb at/cities                      # import austrian regions n cities
    worlddb -c                             # create database schema

Build Your Own world.db Version

Step 1: Create an empty database, that is, world.db. Issue the command:

worlddb --create

Step 2: Add your countries, regions and cities of choice. For example, let's use the Austrian and German cities and regions:

sportdb --include <your_path_to_fixtures> at/cities de/cities

That's it.

Real World Usage

world.db.admin - A free, open source web admin tool for world.db in Ruby on Rails (version 3.2 and up).

sport.db - A free, open sports database & schema.

Sportbook - A free, open source sports betting pool in Ruby on Rails (version 3.2 and up).

Alternatives

worlddb - Open World Database alpha; includes country, region & city names in many languages names and latitude and longitude numbers and country's iso 2-letter code.

License

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

Questions? Comments?

Send them along to the Open Sports Database & Friends Forum/Mailing List. Thanks!

Something went wrong with that request. Please try again.