[OSM-dev] OSM 2 Oracle

[Greg Troxel]

Amir Pourabdollah <Amir.Pourabdollah at nottingham.ac.uk> writes:

> I need help in converting OSM data into Oracle Spatial (direct, no stop-overs!)
> As far as I found so far, the
> ogr2ogr<http://www.gdal.org/ogr2ogr.html> converts to Postgres but
> does not have Oracle output format. Can this be used or adopted for
> Oracle? Any experience?
> Also FME and GoLoader seems to do the conversion straight into Oracle,
> but I have not tried. Any idea?
> Again, this Java tool also exists:
> http://www.ciss.de/openstreetmap-oracle-konverter.html has anybody
> tried this?
> Any idea will be a great help.

(It isn't surprising that there would be far worse support for
proprietary databases, as few people are in a position to use them.)

I would guess that the interfaces to Oracle Spatial are not so different
From the postgis interfaces, and that you would be able to extend the
various tools that load into postgis (in support of mapnik rendering)
without extreme effort.

  http://imposm.org/docs/imposm/latest/

  http://wiki.openstreetmap.org/wiki/Osmosis


Are you trying to store the entire dataset in the schema used by the
rails port, or the schema used by mapnik, or a reduced set for your
analysis, or ?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 194 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20120203/6e662b00/attachment-0001.pgp>