Re: [OSM-dev] ER Diagram of OSM Database
Hello, Am 12.12.2011 um 19:50 schrieb Parveen Arora: or Please let me know how to generate it automatically from PostGreSQL Database? Am 13.12.2011 um 05:20 schrieb Parveen Arora: Yes, I want to have the diagram Yellow:PostGIS, the diagram of database of osm file stored using osm2pgsql. The best online english manual I'm aware of is http://en.flossmanuals.net/openstreetmap/setting-up-your-own-tile-server/ If you understand german (or trust your machine translator), I can also recommend the following 2 part howto: http://wiki.openstreetmap.org/wiki/DE:HowTo_minutely_hstore http://wiki.openstreetmap.org/wiki/DE:HowTo_Mapnik_%26_Tirex Mapnik rendering is based on the Simple Features model, see http://wiki.openstreetmap.org/wiki/The_Future_of_Areas/Simple_Features for more information. Regards, Andi ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] ER Diagram of OSM Database
Hi All, 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. -- Parveen Arora www.parveenarora.in E-Mail: m...@parveenarora.in ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] ER Diagram of OSM Database
Perhaps you an try this tool to extract the schema and display it in an UMLet diagram. http://wiki.hsr.ch/StefanKeller/wiki.cgi?DBSchemaToUML I'm also interested in the result. Yours, Stefan 2011/12/12 Parveen Arora m...@parveenarora.in: Hi All, 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. -- Parveen Arora www.parveenarora.in E-Mail: m...@parveenarora.in ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] ER Diagram of OSM Database
Hi, This might be what you want: http://wiki.openstreetmap.org/wiki/The_Rails_Port/Railroad_diagrams This is handy too: http://wiki.openstreetmap.org/wiki/Rails_port/Database_schema Cheers, Mayeul Le mardi 13 décembre 2011 à 00:20 +0530, Parveen Arora a écrit : Hi All, 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. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] ER Diagram of OSM Database
On 12/12/2011 18:50, Parveen Arora wrote: Hi All, 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? http://git.openstreetmap.org/?p=rails.git;a=tree;f=db/migrate -- Jonathan (Jonobennett) ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] ER Diagram of OSM Database
On Tue, 2011-12-13 at 00:20 +0530, Parveen Arora wrote: Hi All, Some time ago I used dbvisualizer http://www.dbvis.com/ to create this super nice svg https://github.com/osm-spline/xappy.js/blob/master/doc/images/xapi_database_schema.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. signature.asc Description: This is a digitally signed message part ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] ER Diagram of OSM Database
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 We should definitely discuss about using uniform names in future. An overview about the different database schemas is available at http://wiki.openstreetmap.org/wiki/Database_schema#Database_Schemas http://wiki.openstreetmap.org/wiki/List_of_Database_Schemas or Please let me know how to generate it automatically from PostGreSQL Database? Please state which PostgreSQL database you mean. Both databases are hosted on PostgreSQL databases servers. Regards, Andi ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] ER Diagram of OSM Database
On Mon, Dec 12, 2011 at 1:26 PM, Mayeul Kauffmann mayeul.kauffm...@free.fr wrote: Hi, Hi Mayeul, This might be what you want: http://wiki.openstreetmap.org/wiki/The_Rails_Port/Railroad_diagrams This seems to be the database of whole website, But I just particularly wants the diagram of data file stored in database, I want to know how different tags, nodes, relations are being stored in the database, how they are related to each other. Is there any of this kind available? Thank You. -- Parveen Arora www.parveenarora.in E-Mail: m...@parveenarora.in ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] ER Diagram of OSM Database
On Mon, Dec 12, 2011 at 4:14 PM, Andreas Hubel a...@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 www.parveenarora.in E-Mail: m...@parveenarora.in ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] ER Diagram of OSM Database
Well there aren't any database level foreign key constraints in the osm2pgsql schema so database visualization tools won't give you anything useful to look at. Each table is its own island. This schema is denormalized for rendering performance and the import process is lossy. Only objects defined in the style are imported. Everything else is ignored. The wiki page explains things a little although it could use some cleanup by someone who is more familiar with it. Phrases like I noticed these tables being present after an import in slim mode. They seem to be for the first import stage don't exactly inspire confidence... http://wiki.openstreetmap.org/wiki/Osm2pgsql/schema Toby On Mon, Dec 12, 2011 at 10:20 PM, Parveen Arora m...@parveenarora.in wrote: On Mon, Dec 12, 2011 at 4:14 PM, Andreas Hubel a...@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 www.parveenarora.in E-Mail: m...@parveenarora.in ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
