[OSM-dev] OSM 2 Oracle

[Amir Pourabdollah]

For this particular purpose, I don't want to build any mapping service on top of the Oracle database. This database will be used to do validation analysis and quality measures, using a tool that works with Oracle data only. The required set is a reduced one. The minimum set may include id, name, type and geometery and some node tags for each layer.
Amir.
________________________________________
From: Greg Troxel [gdt at ir.bbn.com]
Sent: 03 February 2012 15:37
To: Amir Pourabdollah
Cc: dev at openstreetmap.org; Jeremy Morley; Tracey Mooney
Subject: Re: [OSM-dev] OSM 2 Oracle

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 ?
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.