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
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.
I just found this on the Wiki page
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
The current XML schema is documented here
http://wiki.openstreetmap.org/index.php/OSM_Protocol_Version_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.