You are not logged in.

#1 2008-03-07 09:47:06

Lorius
Member
Registered: 2008-02-29
Posts: 4

In what Database do relations belong

Hello

Im new to OSM and I am programming a java SaxParser for entering nodes, ways etc from a osm file in a database.
I found the Database structures on the OSM Wiki http://wiki.openstreetmap.org/index.php/Database_schema but I dont understand in which database the Relations are stored (nodes, ways, segments have their own databases but relations and members dont).
Can someone tell me where do I find the osm database structure for Relations and Members Information to store in?

thnx
Lor

Offline

#2 2008-03-07 10:14:03

Lambertus
Administrator
From: Apeldoorn (NL)
Registered: 2007-03-17
Posts: 3,269
Website

Re: In what Database do relations belong

I don't know what you're planning to do with that database, but maybe you're solution is already created by means of Osmosis. Osmosis can populate a MySQL or PostgreSQL database using it's own database scheme. It can apply planet change files and much more.


Mapping tools: Garmin GPSmap 60CSx, Giant Terrago 2002

Offline

#3 2008-03-07 10:31:34

Lorius
Member
Registered: 2008-02-29
Posts: 4

Re: In what Database do relations belong

Lambertus wrote:

I don't know what you're planning to do with that database, but maybe you're solution is already created by means of Osmosis. Osmosis can populate a MySQL or PostgreSQL database using it's own database scheme. It can apply planet change files and much more.

Yes I know but Im trying to do it myself.

Offline

#4 2008-03-07 11:22:58

Lorius
Member
Registered: 2008-02-29
Posts: 4

Re: In what Database do relations belong

I just found this on the Wiki page

The file is XML formatted and follows an XML Schema (though this is out-of-date)

Can you please tell me where I can find the newest XML Schemas or the newest Database structures because this Structures here http://wiki.openstreetmap.org/index.php/Database_schema are from September 17, 2007?

thnx

Last edited by Lorius (2008-03-07 11:23:28)

Offline

#5 2008-03-07 13:03:41

the_winch
Member
Registered: 2008-02-24
Posts: 21

Re: In what Database do relations belong

The current XML schema is documented here
http://wiki.openstreetmap.org/index.php … ersion_0.5

The api server software itself will always have the most upto date information on the database schema it is using.
http://wiki.openstreetmap.org/index.php/The_Rails_Port

Your database schema should be influenced by what you want to do with the data. If you don't want to do the same things the api server does its schema may not be appropriate for your application.

Offline

Board footer

Powered by FluxBB