Interesting question Chaitanya,

But the answer is probably no.

The VSI drivers mentioned on that page are supposed to access assets, buckets 
and file system on popular cloud services.

There is no Oracle Cloud Infrastructure (OCI) driver for that purpose, but you 
might be able to access spatial data types SDO_GEOMETRY and SDO_GEORASTER 
tables/columns on a server running on the cloud, just like if it were running 
in any machine. No?

The GDAL/OGR driver OCI, developed many decades ago, was named OCI in reference 
to the Oracle C SDK. It can access "vector" data in SDO_GEOMETRY type.

https://gdal.org/drivers/vector/oci.html#vector-oci

The GDAL georaster driver is a raster driver that supports SDO_GEORASTER type.

https://gdal.org/drivers/raster/georaster.html

Inside the georaster driver code there is a VSI/OCI driver that can read images 
in BLOB data type on the database.

https://github.com/OSGeo/gdal/blob/master/frmts/georaster/cpl_vsil_ocilob.cpp

That driver is rarely exposed for the public and there is documentation. It is 
used by the georaster driver to read JPEG200 compression. But it can be used to 
store Geotiffs or any other raster file format into an BLOB.

With those GDAL driver and with the data stored in oracle databases, you can 
have rendering on the fly in QGIS, ArcMap, etc.

But if you have other geospatial types inside an oracle schema, like 
ST_GEOMETRY, TERRALIB or SDE_GEOMETRY for example, those are not supported by 
GDAL.

Again, if all you want is to access files on OCI storage and rendering on the 
fly,  that wasn't developed yet. You might find command line tools that you can 
pipe the data into GDAL based application, but not rendering on the fly. I 
think.

I hope it helps to clarify,

Ivan

________________________________
From: gdal-dev <gdal-dev-boun...@lists.osgeo.org> on behalf of Chaitanya 
Jalluri <chaitanyajall...@gmail.com>
Sent: Monday, March 7, 2022 7:42 AM
To: gdal-dev@lists.osgeo.org <gdal-dev@lists.osgeo.org>
Subject: [gdal-dev] GDAL support on OCI

Hi,

Does gdal support the accessing and rendering data on the fly (i.e virtual file 
systems ) from the Oracle cloud storage?? I couldn't see any support of this in 
the documentation https://gdal.org/user/virtual_file_systems.html .  Can you 
please help with it?

Thanks and regards
Chaitanya Jalluri
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to