[pdal] Oracle point cloud

[Oscar Martinez Rubi]

Hi Guys,

I am trying to import some points into Oracle with PDAL.

I am getting this error message:

PDAL: GDAL Failure number=1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-06512: at "MDSYS.SDOTNPC", line 321
ORA-06512: at "MDSYS.SDO_PC_PKG", line 573
ORA-06512: at line 3

GDAL: In GDALDestroy - unloading GDAL shared library.

I used the XML below to call PDAL pipeline.

Has someone recently tried this code successfully? (with Oracle 12c)

BTW, in the PDAL docs I saw that also scale and offsets could be specified. Is this really the case or advisable at all? I mean in PostgreSQL the format is defined in the pointcloud_formats but in Oracle I think there is nothing like that. The points are internally stored as Doubles as far as I know and I thought we could not change that (but maybe I am wrong)

Thanks

Regards,

O.

-----------

<?xml version="1.0" encoding="utf-8"?>
<Pipeline version="1.0">
     <Writer type="writers.oci">
         <Option name="debug">
             true
         </Option>
         <Option name="verbose">
             1
         </Option>
         <Option name="connection">
             o20/solution3 at pctest
         </Option>
         <Option name="base_table_name">
             AHN_BASE
         </Option>
         <Option name="block_table_name">
             AHN_BLCK
         </Option>
         <Option name="cloud_column_name">
             PC
         </Option>
         <Option name="is3d">
             false
         </Option>
         <Option name="solid">
             false
         </Option>
         <Option name="overwrite">
             true
         </Option>
         <Option name="srid">
             28992
         </Option>
         <Option name="base_table_aux_columns">
         </Option>
         <Option name="base_table_aux_values">
         </Option>
         <Option name="base_table_boundary_column">
         </Option>
         <Option name="base_table_boundary_wkt">
         </Option>
         <Option name="pre_block_sql">
         </Option>
         <Option name="pre_sql">
         </Option>
         <Option name="post_block_sql">
         </Option>
         <Option name="capacity">
             25000
         </Option>
         <Option name="stream_output_precision">
             8
         </Option>
         <Option name="disable_cloud_trigger">
             true
         </Option>
         <Option name="pack_ignored_fields">
             false
         </Option>
         <Filter type="filters.chipper">
             <Option name="capacity">25000</Option>
             <Reader type="readers.las">
                 <Option name="filename">/pak2/usrdata/ahn2/benchmarks/20M/ahn_minibench.laz</Option>
                 <Option name="spatialreference">EPSG:28992</Option>
             </Reader>
         </Filter>
     </Writer>
</Pipeline>