Re: [udig-dev] Oracle GeoRaster support

[Ivan Lucena <lucena_ivan@xxxxxxxxxxx>]

Hi there,

A little bit of good news.

I managed to make uDig to display direct from GeoRaster objects on a Oracle database.

Following Jody and Frank's suggestions I added code to org.locationtech.catalog.oracle to list and instantiate raster GeoSources that resolves to AbstractGridCoverage2DReader from ImageMosaicJDBCReader.

If I understand it correctly, the ImageMosaic-JDBC is an optional extension to GeoTools and the JDBCAcessOracleGeoRaster class is a custom plugin to that package, and that is what is doing the trick.

What is award about that solution is that in order to instantiate that reader I needed to create a configuration file and pass it as source.

            URL source = configFile.toURI().toURL();
            ImageMosaicJDBCFormatFactory formatFactory = new ImageMosaicJDBCFormatFactory();
            ImageMosaicJDBCFormat format = formatFactory.createFormat();
            reader = format.getReader(source);

Suggestions are welcome.

Thanks a lot,

Ivan

---

From: lucena_ivan@xxxxxxxxxxx
To: ivan.lucena@xxxxxxxxxx
Subject: FW: [udig-dev] Oracle GeoRaster support
Date: Sat, 22 Feb 2014 11:04:57 -0500

---

Date: Fri, 17 Jan 2014 09:36:37 +0100
Subject: Re: [udig-dev] Oracle GeoRaster support
From: fgdrf@xxxxxxxxxxxxxxxxxxxxx
To: lucena_ivan@xxxxxxxxxxx
CC: udig-dev@xxxxxxxxxxxxxxxx

IMHO its required to add gt-imagemosaic-jdbc lib to pom-libs in udig libs bundle (where all the other gt-jars are bundled together). Having this in the manifest file should export the packages from this lib.

Jody : what would be the next step, a new catalog plugin/extent the catalog.oracle bundle or an other imageio-ext extension? Not sure about later option..

I guess I would prefer to implement additional wizards and handlings in catalog.oracle plugin since it seems to be natural because of oracle specific code for handing rasters and jdbc-driver handing. 

Having this in mind it could be an other option to extend catalog.postgis in the same way.

Andrea: have you ever worked with imagemosaic via jdbc?

-- 

Frank

2014/1/16 Ivan Lucena <lucena_ivan@xxxxxxxxxxx>

Frank,

So what you mean is that there is alternative available.

So what would be the node for a future development? What component we would need to extend or what kind of plugins to develop.

Regards,

Ivan

---

Date: Thu, 16 Jan 2014 20:28:10 +0100
Subject: Re: [udig-dev] Oracle GeoRaster support
From: fgdrf@xxxxxxxxxxxxxxxxxxxxx
To: udig-dev@xxxxxxxxxxxxxxxx
CC: lucena_ivan@xxxxxxxxxxx

Ivan, welcome at uDig Developer land :)

My read of the current setup is that gt-imagemosaic is used to access file based mosaic stores whereas an other geotools module provides readers (and writers) to access tiled images from a jdbc database. Please have a look at Geotools Image Mosaicing Pyramidal JDBC Plugin. The module name in geotools github repository is imagemosaic-jdbc and since it is a plugin its build in a CI-maner at a Jenkins instance at boundlessgeo : http://ares.boundlessgeo.com/jenkins/job/geotools-10.x

However, note that we currently integrated 9.0-M0 release of geotools! The osgeo maven repository contains the module : http://download.osgeo.org/webdav/geotools/org/geotools/gt-imagemosaic-jdbc/9.0-M0/

A good point to start is the geotools documentation : http://docs.geotools.org/latest/userguide/library/coverage/jdbc/customized.html

HTH

Frank

2014/1/16 Ivan Lucena <lucena_ivan@xxxxxxxxxxx>

I would like to correct myself. The ImageIO-EXT path is not necessary since the Image Mosaic JDBC plugin for GeoTools cam handle Oracle GeoRaster and I can see that the file "gt-imagemosaic-9.0-M0.jar" is part of the nDig installation:
 
C:\Program Files (x86)\uDig\1.4.0\udig\plugins\net.refractions.udig.libs_1.4.0.201303261513\lib
C:\Program Files (x86)\uDig\2.0.0.Alpha1-v20131119\udig\plugins\org.locationtech.udig.libs_2.0.0.Alpha1-v20131119\lib
 
Is there an example or documentation on how to use the GeoTool's "Image Mosaic JDBC" plugin with nDig?
 
Thanks.
 

---

From: lucena_ivan@xxxxxxxxxxx
To: udig-dev@xxxxxxxxxxxxxxxx
Date: Thu, 16 Jan 2014 10:45:31 -0500
Subject: [udig-dev] Oracle GeoRaster support

Hi there,
 
I am trying to get uDig to display raster images direct from Oracle Spatial GeoRaster.
 
I am new to uDig but I understand that the support for that is not developed yet, so what I am trying to do is to make GeoTools/Imageio-EXT/GDAL to access an GDAL VRT file that points to a GeoRaster object in the database.
 
That is how I started with QGIS, 4 years ago, I droped a GDAL plugin (gdal_GEOR.{so,dll}) into a QGIS installation (or a folder pointed by GDAL_DRIVER_PATH) and I create the VRT file with gdal_translate. After that select "Add Raster Layer" and selected the VRT file as if it was a regular raster file. That worked pretty well on QGIS and works the same way in several other application that uses GDAL.
 
But the little I undestand is that for ImageIO-EXT to access a specific GDAL driver, it need a specific Java wrapper. So when I tried to do the same that I did on QGIS, add the plugin, create the VRT file, add the VRT file as a layer, that did not worked at all in uDIG.
 
That is one think that I would need help with. I need to know if what I am saying here about GeoTools/ImageIO-EXT/GDAL concerning Oracle Spatial GeoRaster is correct or if I am just confuded. But if I am right, Is there a solution available and where can I find it? GeoServer seems to have sorted out but I not sure how, yet.
 
But once I got this think sorted out, I would like to do the same I did for QGIS and write a UI for uDIG where users can select exactly what image they want from the database. It's not as simple as selecting a Geometry table, for the user point of view, you can have more than one sdo_georaster column in a table and each row stores a completly independent image.
 
Any suggestions would be very appreciated.
 
Best regards,
 
Ivan
 

_______________________________________________ udig-dev mailing list udig-dev@xxxxxxxxxxxxxxxx https://locationtech.org/mailman/listinfo/udig-dev

_______________________________________________
udig-dev mailing list
udig-dev@xxxxxxxxxxxxxxxx
https://locationtech.org/mailman/listinfo/udig-dev