Hello, this is my first post here.
I hope the title is not to confusing. So let me explain what I am trying to find out.
The Import of osm data with osm2pgsql into a PostgreSQL database works fine.
But is their a way to do it the other way around??? I am looking for something like pgsql2osm.
JRA wrote here
that osm2pgsql looses informations during the conversion to PostgreSQL.
Is there some place, where that is documented? Is there a way to import all Tags?
An other tool to import osm data to PostgreSQL is osmosis. The nice thing about it is that the import works both way (MySQL <-> PostgreSQL) and it seems that no data gets lost (I checked that with the --derive-change option provided by osmosis). osmosis uses a PostgreSQL schema very similar to the schema used by MySQL.
My Question here is, can i use that schema with PostGIS? I searched for more information, but it wasn’t successful.
NOTE: I am NOT trying to compare osmosis with osm2pgsql Â– they are totally different tools!!!
I am looking for a way to import a current osm file to PostgreSQL and use PostGIS features to manipulate some data. And in the end to export them to a osm file. BUT informations during the imports (and possible conversions) must not get lost.
Or does an other tool exist, that does the job?