<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Interesting question Chaitanya,<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
But the answer is probably no.</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
The VSI drivers mentioned on that page are supposed to access assets, buckets and file system on popular cloud services.</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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?<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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.<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<a href="https://gdal.org/drivers/vector/oci.html#vector-oci" id="LPNoLPOWALinkPreview">https://gdal.org/drivers/vector/oci.html#vector-oci</a><br>
</div>
<div class="_Entity _EType_OWALinkPreview _EId_OWALinkPreview _EReadonly_1"></div>
<br>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
The GDAL georaster driver is a raster driver that supports SDO_GEORASTER type. <br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<a href="https://gdal.org/drivers/raster/georaster.html" id="LPNoLPOWALinkPreview_1">https://gdal.org/drivers/raster/georaster.html</a><br>
</div>
<div class="_Entity _EType_OWALinkPreview _EId_OWALinkPreview_1 _EReadonly_1"></div>
<br>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Inside the georaster driver code there is a VSI/OCI driver that can read images in BLOB data type on the database.
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<a href="https://github.com/OSGeo/gdal/blob/master/frmts/georaster/cpl_vsil_ocilob.cpp" id="LPlnk469090">https://github.com/OSGeo/gdal/blob/master/frmts/georaster/cpl_vsil_ocilob.cpp</a></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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.</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
With those GDAL driver and with the data stored in oracle databases, you can have rendering on the fly in QGIS, ArcMap, etc.</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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.</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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.<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I hope it helps to clarify,</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Ivan<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> gdal-dev <gdal-dev-bounces@lists.osgeo.org> on behalf of Chaitanya Jalluri <chaitanyajalluri@gmail.com><br>
<b>Sent:</b> Monday, March 7, 2022 7:42 AM<br>
<b>To:</b> gdal-dev@lists.osgeo.org <gdal-dev@lists.osgeo.org><br>
<b>Subject:</b> [gdal-dev] GDAL support on OCI</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div id="x_gmail-:2bm" class="x_gmail-Ar x_gmail-Au x_gmail-Ao">
<div id="x_gmail-:2bi" class="x_gmail-Am x_gmail-Al x_editable x_gmail-LW-avf x_gmail-tS-tW x_gmail-tS-tY" aria-label="Message Body" role="textbox" tabindex="1" style="direction:ltr; min-height:376px">
Hi,
<div><br>
</div>
<div>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 <a href="https://gdal.org/user/virtual_file_systems.html" target="_blank">https://gdal.org/user/virtual_file_systems.html</a> .
Can you please help with it?</div>
<div><br>
</div>
<div>Thanks and regards<br>
Chaitanya Jalluri</div>
</div>
</div>
</div>
</div>
</body>
</html>