OpenStreetMap: sqlite database

Schema

CREATE TABLE nod (
          id             integer primary key,
          lat            real not null,
          lon            real not null
        );

CREATE TABLE nod_way (
          way_id         integer not null,
          nod_id         integer not null,
          order_         integer not null
        );

CREATE TABLE nod_rel (
          nod_id         integer not null,
          rel_of         integer null,
          rol            text
        );

CREATE TABLE way_rel (
          way_id         integer not null,
          rel_of         integer null,
          rol            text
        );

CREATE TABLE rel_rel (
          rel_id         integer not null,
          rel_of         integer null,
          rol            text
        );

CREATE TABLE tag(
          nod_id         integer null,
          way_id         integer null,
          rel_id         integer null,
          key            text not null,
          val            text not null
        );

CREATE INDEX nod_way_ix_way_id on nod_way (way_id);
CREATE INDEX tag_ix_val        on tag     (     val);
CREATE INDEX tag_ix_key_val    on tag     (key, val);
CREATE INDEX tag_ix_nod_id     on tag     (nod_id);
CREATE INDEX tag_ix_way_id     on tag     (way_id);
CREATE INDEX tag_ix_rel_id     on tag     (rel_id);

See also