[Gdal-dev] OCI-geometry recognition

[Frank Warmerdam]

Stephan Holl wrote:
> Dear developers,
> 
> I am working with an Oracle db storing geographic data. When copying a
> point-shapefile into Oracle using ogr2ogr everything is fine.
> 
> ogr2ogr -f "OCI" -nlt POINT -nln spearfish_bugsites
> OCI:usr/pwd at oracle bugsites.shp
> 
> Querying the database with ogrinfo gives the following (strange) result
> about the geometry:
> 
> ogrinfo -al -so OCI:usr/pwd at oracle spearfish_bugsites
> INFO: Open of `OCI:usr/pwd at oracle'
> using driver `OCI' successful.
> Layer name: SPEARFISH_BUGSITES
> Geometry: Unknown (any)
>          ^^^^^^^^^^^^^^
...
> Is this an error on my side using ogr2ogr or some Oracle-oddities?
> 
> I found this problematic when I tryed to load a layer directly into
> QGIS, which consequently answers
> UNKNOWN WKBTYPE ENCOUNTERED.
> 
> What can I do?

Stephan,

I am not aware of a dependable way of determining the geometry type of an
oracle geometry column.  So the driver just returns wkbUnknown which means
any geometry type may appear.

This is not uncommon with different kinds of drivers, so if QGIS can't handle
it, I think QGIS should be improved.

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    | President OSGeo, http://osgeo.org