[Gdal-dev] Re: problem using OCI ovf

[Bart van den Eijnden (OSGIS)]

Okay, found out this only occurs when using SrcSQL, if I use SrcLayer
everything works fine.

So I have solved this problem by creating a database view instead.

<OGRVRTDataSource>
    <OGRVRTLayer name="calamiteitenoud">
        <SrcDataSource>OCI:BVDE/BART@//rws-svl012i.int.storage.nwr.local:1521/TGEOS.rws.nl:VW_CALAMITEITEN_OUD</SrcDataSource>
        <SrcLayer>VW_CALAMITEITEN_OUD</SrcLayer>
        <!--<SrcSQL>SELECT * FROM CALAMITEITEN WHERE ACTUEEL = 0</SrcSQL>-->
        <GeometryType>wkbPoint</GeometryType>
        <LayerSRS>EPSG:28992</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="CALX" y="CALY"/>
    </OGRVRTLayer>
</OGRVRTDataSource>

Best regards,
Bart

> Hi list,
>
> using last week's CVS I am trying to access an ovf point layer in Oracle.
> In Oracle the X and Y columns are of type NUMBER(22,0).
>
> OGR reports all X and Y values as 0 but in the database the correct values
> are present:
>
> CALX     CALY
>  -------  -------
>  33219    669433
>  -452425  913701
>  28883    691114
>  184983   665097
>  66463    776391
>  72244    709904
>  -452425  913701
>  79471    654979
>  73545    515742
>
> Ogrinfo reports:
> CALX: Integer (0.0)
> CALY: Integer (0.0)
>
> And:
>   CALX (Integer) = 0
>   CALY (Integer) = 0
>   ..
>   POINT (0 0 0)
>
> Any ideas what could be going wrong?
>
> The ovf file:
> <OGRVRTDataSource>
>     <OGRVRTLayer name="calamiteitenoud">
>        <SrcDataSource>OCI:BVDE/BART@//xxx:1521/TGEOS.rws.nl:CALAMITEITEN</SrcDataSource>
>         <SrcSQL>SELECT * FROM CALAMITEITEN WHERE ACTUEEL = 0</SrcSQL>
>         <GeometryType>wkbPoint</GeometryType>
>         <LayerSRS>EPSG:28992</LayerSRS>
>         <GeometryField encoding="PointFromColumns" x="CALX" y="CALY"/>
>     </OGRVRTLayer>
> </OGRVRTDataSource>
>
> Thanks in advance.
>
> Best regards,
> Bart
>