[OSM-dev] OSM 2 Oracle

[Jukka Rahkonen]

Amir Pourabdollah wrote:

In that case I would install PostgreSQL+PostGIS for initial import and use
ogr2ogr next. You can spend the time you save for thinking about how to
handle the free key-value schema in Oracle. PostgreSQL has the hstore
datatype and Oracle seems to have a NoSQL solution too
http://www.oracle.com/technetwork/database/nosqldb/overview/index.html. I
am pretty sure that ogr2ogr cannot convert PostgreSQL hstore data into
Oracle NoSQL and you should make some other solution but it will be worth
it because free tagging is so natural part of the real user contributed
OSM.

-Jukka Rahkonen-



> Hi,
> Let me add that I don't need incremental updates to be converted. Just the
> current map is wanted.
> Amir.
>
> -----Original Message-----
> From: Sven Geggus [mailto:lists at fuchsschwanzdomain.de]
> Sent: 03 February 2012 13:18
> To: dev at openstreetmap.org
> Subject: Re: [OSM-dev] OSM 2 Oracle
>
> Jukka Rahkonen <jukka.rahkonen at latuviitta.fi> wrote:
>
>> If you select that road I would love to see it able to write into
>> Spatialite as well.
>
> osm2pgsql has not been designed (if designed at all) with various
> backends
> in mind but contains pretty much hardcoded assumptions about the Database
> in
> use. I'm afraid redesigning it in such a way (which would of course be
> nice)
> would grow into a complete rewrite.
>
> The hard thing to do in such a converter are incremental updates and
> multipolygon conversion. IMO the two features keeping the people still
> using
> osm2pgsql after all.
>
> I don't know the achitecture of imposm but maybe this one is designed
> with
> multiple backends in mind.
>
> Regards
>
> Sven
>
> --
> Der "normale Bürger" ist nicht an der TU Dresden und schreibt auch
> nicht mit mutt. (Ulli Kuhnle in de.comp.os.unix.discussion)
>
> /me is giggls at ircnet, http://sven.gegg.us/ on the Web
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>
> This message and any attachment are intended solely for the addressee and
> may contain confidential information. If you have received this message in
> error, please send it back to me, and immediately delete it.   Please do
> not use, copy or disclose the information contained in this message or in
> any attachment.  Any views or opinions expressed by the author of this
> email do not necessarily reflect the views of the University of
> Nottingham.
>
> This message has been checked for viruses but the contents of an
> attachment
> may still contain software viruses which could damage your computer
> system:
> you are advised to perform your own checks. Email communications with the
> University of Nottingham may be monitored as permitted by UK legislation.
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>