[gdal-dev] GDAL support on OCI

[Chaitanya Jalluri]

Hi Ivan,

Thanks for your reply. Yes, it clarified my query.

Thanks and Regards
Chaitanya Jalluri

On Mon, Mar 7, 2022 at 6:57 PM Ivan Lucena <ivan.lucena at outlook.com> wrote:

> 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/b542ba08/attachment-0001.html>