Opening pointcloud/fixtures/test.las to fetch header
Setting output base table to: lidar_base_pc
Setting output block table to: lidar_block
Setting output point cloud column to: pc
Setting output base-table-boundary-wkt to: pointcloud/fixtures/test.las.wkt
Inserting boundary into column: coverage_geometry
Setting header blob column to: header
Setting base-table-aux-columns to: system_identifier,file_signature,generating_software,min_x,min_y,min_z,version_major,global_encoding,file_creation_date,num_points_by_return,z_offset,max_z,max_x,max_y,x_scale_factor,z_scale_factor,original_file_size_bytes,pt_data_record_length,guid_data,file_source_id,path,version_minor,product_id,num_variable_length_records,pt_data_format_id,y_scale_factor,y_offset,x_offset,date_loaded,number_of_point_records
Setting base-table-aux-values to: 'MODIFICATION','LASF','TerraScan','289814.15','4320978.61','170.58','1','0',to_date('19000101','YYYYMMDD'),'10-0-0-0-0-0-0-0','-0.0','170.76','289818.5','4320980.59','0.01','0.01','1039','28','00000000-0000-0000-0000-000000000000','0','pointcloud/fixtures/test.las','2','1','3','1','0.01','-0.0','-0.0',to_date('20110330','YYYYMMDD'),'10'
Setting block capacity to: 5000
Setting precision to: 8
Setting output Oracle SRID to: 4326
Setting output post-sql to: begin execute immediate 'alter procedure build_max_density compile'; build_max_density; end;
Setting offsets to: 0 0 0
Setting scales to: 1e-07 1e-07 0.0001
Setting input SRS to 'EPSG:32617+4326'
Setting output SRS to EPSG:4326+4326
GDAL Debug: OGRCT: Source: +proj=utm +zone=17 +ellps=WGS84 +datum=WGS84 +units=m +no_defs
GDAL Debug: OGRCT: Target: +proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs
GDAL Debug: OGRCT: Source: +proj=utm +zone=17 +ellps=WGS84 +datum=WGS84 +units=m +no_defs
GDAL Debug: OGRCT: Target: +proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs
Connecting with username: test_lidar password: Im_a_lumberjack instance: 10.211.55.13/dev.localdomain
Base table name lidar_base_pc cloud column: pc block table: lidar_block
Oracle connection succeded
GDAL Debug: PL/SQL:
select table_name from user_tables where table_name like upper('%%lidar_block%%')

GDAL Debug: PL/SQL:
CREATE TABLE lidar_block AS SELECT * FROM MDSYS.SDO_PC_BLK_TABLE

Chipping data for loading into Oracle with 5000 block capacity
GDAL Debug: PL/SQL:
SELECT COORD_REF_SYS_KIND from MDSYS.SDO_COORD_REF_SYSTEM WHERE SRID = :1

GDAL Debug: PL/SQL:
declare
  pc_id NUMBER := :1;
  pc sdo_pc;
begin
  -- Initialize the Point Cloud object.
  pc := sdo_pc_pkg.init(
          'LIDAR_BASE_PC', -- Table that has the SDO_POINT_CLOUD column defined
          'PC',   -- Column name of the SDO_POINT_CLOUD object
          'LIDAR_BLOCK', -- Table to store blocks of the point cloud
           'blk_capacity=5000', -- max # of points per block
           mdsys.sdo_geometry(2003, 4326, null,
              mdsys.sdo_elem_info_array(1,1003,3),
              mdsys.sdo_ordinate_array(
-83.4276,39.0126,-83.4275,39.0126)),  -- Extent
     0.5, -- Tolerance for point cloud
           5, -- Total number of dimensions
           null);
  :1 := pc.pc_id;
  -- Insert the Point Cloud object  into the "base" table.
  insert into LIDAR_BASE_PC ( ID, PC,SYSTEM_IDENTIFIER,FILE_SIGNATURE,GENERATING_SOFTWARE,MIN_X,MIN_Y,MIN_Z,VERSION_MAJOR,GLOBAL_ENCODING,FILE_CREATION_DATE,NUM_POINTS_BY_RETURN,Z_OFFSET,MAX_Z,MAX_X,MAX_Y,X_SCALE_FACTOR,Z_SCALE_FACTOR,ORIGINAL_FILE_SIZE_BYTES,PT_DATA_RECORD_LENGTH,GUID_DATA,FILE_SOURCE_ID,PATH,VERSION_MINOR,PRODUCT_ID,NUM_VARIABLE_LENGTH_RECORDS,PT_DATA_FORMAT_ID,Y_SCALE_FACTOR,Y_OFFSET,X_OFFSET,DATE_LOADED,NUMBER_OF_POINT_RECORDS,HEADER,COVERAGE_GEOMETRY) values ( pc.pc_id, pc,'MODIFICATION','LASF','TerraScan','289814.15','4320978.61','170.58','1','0',to_date('19000101','YYYYMMDD'),'10-0-0-0-0-0-0-0','-0.0','170.76','289818.5','4320980.59','0.01','0.01','1039','28','00000000-0000-0000-0000-000000000000','0','pointcloud/fixtures/test.las','2','1','3','1','0.01','-0.0','-0.0',to_date('20110330','YYYYMMDD'),'10', :2, SDO_GEOMETRY(:3, :4));
  end;