i want to build an application that needs to go through the database pretty quickly
so i want to convert the osm xml file to a sql server(osm2Pgsql dosent preserve the relation and so isnt very useful to me )
is that possible? are there any other alternatives?
i’ve looked at the links and to my untrained eye it looks like : http://wiki.openstreetmap.org/wiki/Osmosis/PostGIS_Setup
is what i am looking for
am i right? will this import to PostgreSQL preserve all the nod/way/relation data from the OSM file? so that for example i can do routing calculations?
and thanks again
i dont really want to do routing,although i do want to run some kind of algorithm but with far less times it needs to access the DB then i guess a routing algorithm needs to.
so how do those routing algorithms work? for example if they use Planet.osm that’s way to much to keep in main memory isnt it?, and if they want to provide routing services world wide they need the whole file(?)