[OSM-dev] ER Diagram of OSM Database

Philipp Borgers borgers at mi.fu-berlin.de
Mon Dec 12 20:45:26 GMT 2011

On Tue, 2011-12-13 at 00:20 +0530, Parveen Arora wrote:
> Hi All,

Some time ago I used dbvisualizer


to create this "super nice" svg


But the best way to understand "the" database schema is to start using
it. Open up psql or pgadmin and take a close look at the tables and do
some queries. pgadmin is a great tool if you like gui stuff.

> I was searching for ER Diagram of OpenStreetMap's Database to
> understand completely, So I would like to know If there is any
> available or not?
> I found one component diagram
> http://wiki.openstreetmap.org/wiki/Component_overview
> But I want one only of database?
> or Please let me know how to generate it automatically from PostGreSQL Database?
> Thank You.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: This is a digitally signed message part
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20111212/e2ffffe4/attachment.pgp>

More information about the dev mailing list