[gdal-dev] GDAL support on OCI

[Ivan Lucena]

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-bounces at lists.osgeo.org> on behalf of Chaitanya Jalluri <chaitanyajalluri at gmail.com>
Sent: Monday, March 7, 2022 7:42 AM
To: gdal-dev at lists.osgeo.org <gdal-dev at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20220307/e2983ccd/attachment.html>