Virtual Spatial Data through OCI

[Bart van den Eijnden]

Hi list,

probably a question for Frank.

I am trying to use an Oracle X Y column table through virtual spatial data. I compiled GDAL against the Oracle client. I can access it through ODBC without any problems.

When doing an ogrinfo on the ovf file I created, I get:

D:\ms4w\apps\stragisweb\htdocs\sites\westland\data>ogrinfo adr4all.ovf
ERROR 4: Update access not supported for VRT datasources.
ERROR 1: Failed to find layer 'ADR5_ADRESCYCLUS' on datasource 'OCI:CAB/CAB at 10.1
5.7.7:1521/ONTW'.
FAILURE:
Unable to open datasource `adr4all.ovf' with the following drivers.
  -> ESRI Shapefile
  -> UK .NTF
  -> SDTS
  -> TIGER
  -> S57
  -> MapInfo File
  -> DGN
  -> VRT
  -> AVCBin
  -> REC
  -> Memory
  -> CSV
  -> GML
  -> ODBC
  -> OCI

My ovf file looks like:

<OGRVRTDataSource>
    <OGRVRTLayer name="adr4all">
        <SrcDataSource>OCI:CAB/CAB at 10.15.7.7:1521/ONTW</SrcDataSource> 
 	<SrcLayer>ADR5_ADRESCYCLUS</SrcLayer> 
	<GeometryType>wkbPoint</GeometryType> 
        <LayerSRS>epsg:28992</LayerSRS>
	<GeometryField encoding="PointFromColumns" x="X_KOORD" y="Y_KOORD"/> 
    </OGRVRTLayer>
</OGRVRTDataSource>

When I do a direct ogrinfo sql select command it works fine:

D:\ms4w\apps\stragisweb\htdocs\sites\westland\data>ogrinfo -ro OCI:CAB/CAB at 10.15
..7.7:1521/ONTW -sql "SELECT * FROM ADR5_ADRESCYCLUS WHERE ADRESNR=41812"
INFO: Open of `OCI:CAB/CAB at 10.15.7.7:1521/ONTW'
using driver `OCI' successful.

Layer name: SELECT * FROM ADR5_ADRESCYCLUS WHERE ADRESNR=41812
Geometry: Unknown (any)
Feature Count: 1
Layer SRS WKT:
(unknown)
ADRESNR: Integer (10.0)
VOLGNR: Integer (3.0)
LANDKODE: String (4.0)
GEMEENTEKODE: String (4.0)
WOONPLKODE: String (4.0)
WOONPL_BOCO: String (24.0)
WOONPL_BOCO_U: String (24.0)
WOONPL_BOCO_D: String (30.0)
STRAATKODE: String (5.0)
STRAAT: String (40.0)
STRAAT_U: String (40.0)
STRAAT_D: String (50.0)
AAND: String (2.0)
HUISNR: Integer (5.0)
HUISLT: String (1.0)
TOEV: String (4.0)
POSTK_A: String (2.0)
POSTK_N: Integer (4.0)
WIJKKODE: String (3.0)
BUURTKODE: String (6.0)
SRT_ADRESKODE: String (3.0)
STATUSKODE: String (3.0)
X_KOORD: Real (9.3)
Y_KOORD: Real (9.3)
Z_KOORD: Real (9.3)
LOKATIE: String (40.0)
LOKATIE_D: String (50.0)
VRIJ_VELD1: String (10.0)
VRIJ_VELD2: String (10.0)
OGRFeature(SELECT * FROM ADR5_ADRESCYCLUS WHERE ADRESNR=41812):0
  ADRESNR (Integer) = 41812
  VOLGNR (Integer) = 1
  LANDKODE (String) = 6030
  GEMEENTEKODE (String) = 1783
  WOONPLKODE (String) = 10
  WOONPL_BOCO (String) = De Lier
  WOONPL_BOCO_U (String) = DE LIER
  WOONPL_BOCO_D (String) = De Lier
  STRAATKODE (String) = 13040
  STRAAT (String) = Witte de Withstraat
  STRAAT_U (String) = WITTE DE WITHSTRAAT
  STRAAT_D (String) = Witte de Withstraat
  AAND (String) = (null)
  HUISNR (Integer) = 15
  HUISLT (String) =
  TOEV (String) =
  POSTK_A (String) = GE
  POSTK_N (Integer) = 2678
  WIJKKODE (String) = (null)
  BUURTKODE (String) = (null)
  SRT_ADRESKODE (String) = (null)
  STATUSKODE (String) = (null)
  X_KOORD (Real) = 77334.060
  Y_KOORD (Real) = 443550.020
  Z_KOORD (Real) = (null)
  LOKATIE (String) = (null)
  LOKATIE_D (String) = (null)
  VRIJ_VELD1 (String) = N
  VRIJ_VELD2 (String) = 5,27163

I am confused. Any ideas?

Best regards,
Bart

Bart van den Eijnden
Syncera IT Solutions
Postbus 270
2600 AG  DELFT

tel.nr.: 015-7512436
email: BEN at Syncera-ITSolutions.nl