The OCI reader is used to read data from Oracle point cloud databases.
{
"pipeline":[
{
"type":"readers.oci",
"query":"SELECT \r\n l.\"OBJ_ID\", l.\"BLK_ID\", l.\"BLK_EXTENT\", \r\n l.\"BLK_DOMAIN\", l.\"PCBLK_MIN_RES\", \r\n l.\"PCBLK_MAX_RES\", l.\"NUM_POINTS\",\r\n l.\"NUM_UNSORTED_POINTS\", l.\"PT_SORT_DIM\", \r\n l.\"POINTS\", b.cloud\r\n FROM AUTZEN_BLOCKS l, AUTZEN_CLOUD b\r\n WHERE l.obj_id = b.id and l.obj_id in (1,2)\r\n ORDER BY l.obj_id",
"connection":"grid/grid@localhost/orcl",
"populate_pointsourceid":"true"
},
{
"type":"writers.las",
"filename":"outputfile.las"
}
]
}