I would like to import OSM data (for a single country only… for now) into a PostGIS database. The data will be used for projections (i.e. displaying maps using Geoserver/WMS and OpenLayers) and also for routing. Now, I have found a variety of tools that will load data into my database osm2pgsql, osm2pgrouting, osmosis, PostGIS2pgsql etc, however, each seems to create a database schema that is relevant for either projection or for routing. Can anyone advise the best method database design + tool to hold data for both… or is it best to have 2 separate schema’s… one for each?
Any help would be really appreciated.