[Gdal-dev] ogr2ogr and Oracle: 3D instead of 2D

[Frank Warmerdam]

bartvde at xs4all.nl wrote:
> Hi list,
> 
> we are trying to use ogr2ogr to import a MapInfo datasource into Oracle
> Spatial. The MapInfo datasource is in the RD system (EPSG:28992) and is a
> 2D datasource. We are getting all data in Oracle in 3D instead of in 2D,
> without requesting it specifically.
> 
> We are trying:
> 
> ogr2ogr -f OCI OCI:usr/pass at mydb e:\Projecten\EduGis\ApeldoornProef -lco
> OVERWRITE=YES -s_srs EPSG:28992 -nlt POLYGON apeldoorn_vlak
> 
> Anybody have an idea why we get 3D (3003 instead of 2003)?

Bart,

The Oracle driver in OGR defaults to creating tables with a dimension of 3.
Use the "-lco DIM=2" command arg to force to 2D.

This is described in the layer creation options section of the Oracle Spatial
driver page at:

   http://www.remotesensing.org/gdal/ogr/drv_oci.html

Best regards,

-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent