Database

From OpenCITT

OpenCITT uses several Postgres Databases as data backend to serve different tasks.

List of databases in use

Contents 1 opencitt 2 osm 3 gis 4 pgrouting

opencitt

- used to store general settings, tables are created/managed by opencitt itself

osm

- currently stores map data for rendering, tables are created/managed by opencitt, map import via gui possible
- some shortcomings concerning stability and standards
- to be replaced with gis/pgrouting, see below

---

Future databases for routing-capable navi module

gis

- stores map data for rendering map tiles as postgis db
- data import done by osm2pgsql
- rendering done by mapnik

pgrouting

- stores road network topology for routing
- data import done by osm2pgrouting
- routing done by pgrouting