Hi Bruce, first the bad news As you stated in your last mail, this is your special use case. Since geotools is an OS library, I cannot create solutions which work for special use cases. The code I produce has to work for any kind of map, and you know my arguments why this not the case in your special setup.
The good news The access to the database is done via an interface called iJDBCAccesa. This interface has 4 or 5 Methods. An implementation of this interface fetches the image data from db and builds georeferenced BufferedImages for further processing. I think Baskar can do an implementation for your needs very quickly. I will give you the possibility to plug in your implementation. There is an Element in the XML configuration which determines the spatial extension. <spatialExtension name="georaster"/> I can offer you the possibility to specify your implementation class here. <spatialExtension name="com.corelogic.MyJDBCAccess"/> Thats it. I think this is more work for me concerning documentation,backport,and so on as for Baskar. Deal ? Quoting "Thelen, Bruce" <[email protected]>: > Christian, > > Whereas it is possible to have multiple rows in a table where each > row represents a different map, what we really need is to be able to > mosaic more than one map together in this use case. > > Bruce E. Thelen > [email protected] > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] > Sent: Wednesday, May 05, 2010 10:43 AM > To: Thelen, Bruce > Cc: Baskar, Dhanapal; [email protected] > Subject: RE: [Geotools-devel] Proposed Mosaicing GeoRaster Module > > Bruce,Baskar, and Steve, many questions, I will try to give good answers :-) > > It is not true that the table has only one row. Each row is a map. If > your enterprise has 20 different maps, you have 20 records in this > table. You can assign a different raster data table for each of this > 20 rows. Oracle will create 20 different raster data tables (RDT) > holding the tiles for one map. You can look at these RDTs, you will > have tons of rows in it. > > I believe, these RDTs are exactly what you want to create yourself. > You can specify a lot of storage parameters for these RDTs like > tablespace, blocksize of one tile,... > > About the 95 % no data value. Specify a "compression= ..." storage parameter. > "compression=DEFLATE" is a simple gzip for example. > > Do you use pyramids ?. If you use your own tile table and generate > pyramids for each tile, you will have a good chance to see the borders > of the tiles on your map, looking like a chess board :-) > I have this experience since I developed the gdal_retily.py utility. > Building a pyramid for one tile means also to load all 8 neighbors, > moasic the image, and crop the original rectangle. If you use your own > tile table, it is likely to loose the oracle pyramid feature. > > For Oracle 10.2, I have not seen a possibilty to import an already > tiled image into a georaster object. > Is this right ? This means you have to use gdal_merge.py > > For Oracle 11.x, I have seen SDO_GEOR.updateRaster at > http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28398/geor_ref.htm#CACHBIAE > > updateRaster gives you the possibility to update a part of the raster > object and the pyramids are rebuild automatically. Here you can avoid > gdal_merge.py. To be fair, I have not used it until know, > but this could be a chance. > > so far, so good, hope that helped a little bit > > > *************************** > This message may contain confidential or proprietary information > intended only > for the use of the addressee(s) named above or may contain > information that is > legally privileged. If you are not the intended addressee, or the person > responsible for delivering it to the intended addressee, you are hereby > notified that reading, disseminating, distributing or copying this message is > strictly prohibited. If you have received this message by mistake, please > immediately notify us by replying to the message and delete the original > message and any copies immediately thereafter. > > Thank you. > **************************** > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ _______________________________________________ Geotools-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
