Hi, For sure GDAL/OGR supports Oracle http://gdal.org/ogr/drv_oci.html For new GDAL versions you will need to install the Oracle plugin separately. It seems that it is not properly documented in the OCI driver page. If you use Windows you can download GDAL 1.9.0 and Oracle plugin installers from http://www.gisinternals.com/sdk/
Once you begin, why not to develop a general OSM driver for GDAL as possible? It could do about the same as osm2pgsql but instead of a named target it would convert from osm into ogr simple features. After that ogr2ogr coud do the rest to any format it supports. Data models do not suit but we are doing the same with osm2pgsql and Mapnik rendering all the time. It may still be worth considering to use osm2pgsql first and convert then with ogr2ogr from PostGIS into Oracle. Then you would have all the tools ready. Or then you could tweak osm2pgsql so that it could write directly into Oracle in addition to PostgreSQL. That is probably not very simple. If you select that road I would love to see it able to write into Spatialite as well. -Jukka Rahkonen- Amir Pourabdollah wrote: > Hi group, > Greetings from a new comer to this list. For your information, we have started developing OSM-GB<http://www.osmgb.org.uk/> project. > > 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. > Thanks, > Amir. > > 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 > [email protected] > http://lists.openstreetmap.org/listinfo/dev > _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
