[OSM-dev] ER Diagram of OSM Database

Parveen Arora mail at parveenarora.in
Tue Dec 13 04:20:30 GMT 2011

On Mon, Dec 12, 2011 at 4:14 PM, Andreas Hubel <andi at saerdnaer.de> wrote:
> Hello Parveen,
> Am 12.12.2011 um 19:50 schrieb Parveen Arora:
>> I was searching for ER Diagram of OpenStreetMap's Database to
>> understand completely,
> I think the best way is to understand the different parts step by step and not to try to understand everything at the first time.
>> I found one component diagram
>> http://wiki.openstreetmap.org/wiki/Component_overview
>> But I want one only of database?
> There is not one database. The main services provided by the foundation actually use two different databases, as shown in the component overview you already found.
> Green: PostgreSQL backend
>        aliases: api db, main db, core db
> Yellow: PostGIS
>        aliases: osm2pgsql db, Mapnik db
Yes, I want to have the diagram Yellow:PostGIS, the diagram of
database of osm file stored using osm2pgsql.

> We should definitely discuss about using uniform names in future.
Yes, I realized this lately after posting the email, I will take care
of it from next time.

Thank You.

Parveen Arora
E-Mail: mail at parveenarora.in

More information about the dev mailing list