Hi Christian, Thanks for your mail.
Yes you are right about the mosaic on the fly. With respect to pyramid building, this is actually completed in Oracle on a tile by tile basis. The plugin will find the max pyramid level of the coverage on initialization, and based on the spatial resolution, will select the relevant pyramid level. It is funny you mentioned about extending the abstract JDBCCustom class, I started this work on Friday and am now complete. Still waiting for developer access to codeHause to write a wiki page on this, and then hopefully carry on the next steps to releasing this as an unsupported plugin (or community module). I think it is a good idea to use the current test case as much as possible -this is where I am going to struggle creating Junit tests - so any help, guidance and advice would be welcome. Many Thanks, Steve -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: 30 January 2011 14:08 To: Steve Way Cc: geotools-devel ([email protected]); [email protected] Subject: Re: [Geotools-devel] Proposed Oracle Georaster Mosaic Module Hi, I can remember working with Baskar. I hope your extension is a subclass of the JDBCAccessCustom base class, otherwise we would have an additional architecture (We have already two, one based on files maintained by Simone, the second based on jdbc, maintained by me). The current Oracle Georaster plugin is an implementation of http://docs.codehaus.org/display/GEOTDOC/Customized+JDBC+Access+for+images If I got it right, you calculate the mosaic on the fly, what about pyramid building ?. About the test case. There is already an OracleGeoraster test, I think it would be a good idea to use this test as a template. If I am right, you only have to modify the import of the images. Anyway, your approach is very interesting for me because I intend to add postgis wkt raster which has a database layout similar to yours. And last not least, do you plan to extend the import utility. The current Oracle Georaster implementation can use the original Oracle tools for import, postgis wkt raster has its own tool and for the rest I wrote the import utility based on the output of gdal_retile. Cheers Christian Quoting Steve Way <[email protected]>: > Hi Jody, > > Last year I extended Christian's imagemosaic-jdbc module to support > Oracle Georaster. This however, was quite a dirty implementations > and had a dependency on about 11 external Oracle java libraries > (which, is not workable in the opensource world!). > > The imagemosiac-jdbc module was then officially extended by the > community, however, it is limited to only working with the Oracle > Georaster format if a mosaic has been created in the DB. > > What I have created in collaboration with another developer (Baskar > Dhanapal), and would like to release to the community, is a plugin, > which is dependant only on one external Oracle Library (the Oracle > JDBC Driver ojdbc14.jar), and works with the most common GeoRaster > data model, where there are many raster tiles for a given dataset > and does not rely on the DBA to create a mosaic within Oracle. An > example of this would be the Ordnance Survey 1:10,000 scale raster > products, where there are 10,585 tiles. To create a mosaic for this > is timely, high maintenance (as mosaic would need to be re-created > even if a few tiles were updated) and costly in storage. The > proposed module would mosaic on the fly, and take out those issues > mentioned above. > > I hope yourself and the community see the benefit to having this > module, and accept this as a formal request to submit. We will > definitely be using this in the WMS service we provide to Ordnance > Survey(GB) in the current Geoserver upgrade to 2.1.0 for INSPIRE > compliance in the coming months. > > Kind Regards, > > Steve Way > > > > > > > > > ________________________________ > DISCLAIMER: > > This email may contain confidential information and is intended only > for the use of the specific individual(s) to which it is addressed. > If you are not the intended recipient of this email, you are hereby > notified that any unauthorized use, dissemination or copying of > this email or the information contained in it or attached to it is > strictly prohibited. If you received this message in error, please > immediately notify the sender at Infotech or > [email protected] and delete the original message. > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d _______________________________________________ Geotools-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
