Hi Jakub First, please stay on the mailing list, otherwise
1) you will have no chance to get input from others 2) Normally, developers do not answer to individual mails I am not sure that I am understanding your problem. The image mosaic jdbc plugin can use postgis raster columns directly, no need for an additional blob column. http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html I assume the problem is that that this fact is not mentioned in the geoserver user guide. The only problem may be that the module uses st_aspng and will use st_astiff in next versions. If you have problems here, I can prepare a special jar file for you. (Need to know your geoserver version). Christian Zitat von Jakub Hettler <[email protected]>: > No no, I found the solution Christian, I only wanted to know what kind of > function I can use for creating of BLOB column with raster data for image > mosaic jdbc plugin with GeoServer. Because if I have rast column in table > and I need to make BLOB (bytea in Postgre) I need to use functions as > ST_AsPNG, ST_AsTIFF,etc. > > And I couldnt find any information what kind of formats can I use with > image mosaic jdbc, but I think I found the answer on your page > > "Data (Blob) : The image data (Encoded in a format readable by JAI, e. g. > png,jpeg,...)" > > http://docs.codehaus.org/display/GEOTDOC/Image+Mosaicing+Pyramidal+JDBC+Plugin > > Because I tried to publish QuickBird data with 4 bands in TIFF, but it is > impossible, cause of 8 BUI and 16 BUI :) Then I found the way of using > ST_AsTIFF instead ST_AsPNG, but I get only black rectangle, I think it is > because there some no data values or something like this or I have to make > histogram stretch in the conversion between postgis raster native and BLOB, > because if I open the same raster in native PostGIS format, I get also > black rectangle and I need to use histogram stretch to get original picture. > > Do you have some tips? :) > > Thanks > > Jakub > > 2012/8/27 <[email protected]> > >> Not sure about your problem, perhaps it is related to >> >> http://jira.codehaus.org/**browse/GEOT-4225<http://jira.codehaus.org/browse/GEOT-4225> >> >> Christian >> >> Zitat von Jakub Hettler <[email protected]>: >> >> >> Hi all, >>> I have a question. I created a structure in PostGIS that support GeoServer >>> and image mosaic JDBC plugin. >>> >>> It is almost same as with the original tool to import image-mosaic tiles >>> as >>> is >>> http://docs.geoserver.org/**stable/en/user/tutorials/** >>> imagemosaic-jdbc/imagemosaic-**jdbc_tutorial.html<http://docs.geoserver.org/stable/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html> >>> . >>> But I use to import rasters raster2pgsql and than from rast column I >>> create >>> the polygon and bytea for Image mosaic JDBC plugin (the structure what >>> original import tool create). >>> >>> But the question is. Now I have for example rast created from png, ok than >>> I use ST_asGDALRaster(rast, png) on this column and I have bytea code for >>> bytea column. But if I try to make it as JPEG for >>> example ST_asGDALRaster(rast, JPEG) I get anything in my map window. Image >>> mosaic JDBC plugin consumes only PNG? >>> >>> Thanks >>> >>> Regards >>> >>> Jakub >>> >>> >> >> >> ------------------------------**------------------------------**---- >> This message was sent using IMP, the Internet Messaging Program. >> >> >> > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ GeoTools-GT2-Users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
