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

[bartvde at xs4all.nl ()]

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/***@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)?

Best regards,
Bart

[Frank Warmerdam]

Post by bartvde at xs4all.nl ()
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.
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,