Re: [Geoserver-users] "Image Mosaic JDBC" plugin is not available for GeoServer V2.22

On Wed, Apr 5, 2023 at 5:20 PM Amirhossein Nikfal wrote: > So what are we supposed to do for adding a Postgis raster data store? > According to docs, "Image Mosaic JDBC" plugin was necessary for such a > task. > Read and apply this guide: https://github.com/geoserver/geoserver/wiki/Successfully-

Re: [Geoserver-users] "Image Mosaic JDBC" plugin is not available for GeoServer V2.22

support the module with time or cash. That's the way open source works I'm afraid Ian On Wed, 5 Apr 2023 at 16:19, Amirhossein Nikfal wrote: > So what are we supposed to do for adding a Postgis raster data store? > According to docs, "Image Mosaic JDBC" plugin was necessary for such a > task. >

Re: [Geoserver-users] "Image Mosaic JDBC" plugin is not available for GeoServer V2.22

So what are we supposed to do for adding a Postgis raster data store? According to docs, "Image Mosaic JDBC" plugin was necessary for such a task. On Wed, Apr 5, 2023 at 5:13 PM Ian Turton wrote: > quoting from another thread: > the imagemosaic-jdbc plugin has been removed from the GeoServer sou

Re: [Geoserver-users] "Image Mosaic JDBC" plugin is not available for GeoServer V2.22

quoting from another thread: the imagemosaic-jdbc plugin has been removed from the GeoServer source code, after years without a dedicated maintainer. See the full answer on a similar thread. https://sourceforge.net/p/geoserver/mailman/geoserver-users/thread/61ddb27d-9187-bde0-34ae-48700befa703%40m

[Geoserver-users] "Image Mosaic JDBC" plugin is not available for GeoServer V2.22

Dear fellows, Following https://docs.geoserver.org/2.19.x/en/user/community/imagemosaic-jdbc/index.html : The "Image Mosaic JDBC" plugin for Geoserver version 2.22 is not available. In fact it is not available for versions 2.20 and higher. Best, Amir Nikfal ___

Re: [Geoserver-users] Image Mosaic JDBC

Hi David, quoting from another thread: *the imagemosaic-jdbc plugin has been removed from the GeoServer source code,after years without a dedicated maintainer.* See the full answer on a similar thread. https://sourceforge.net/p/geoserver/mailman/geoserver-users/thread/61ddb27d-9187-bde0-34ae-4870

[Geoserver-users] Image Mosaic JDBC

Hello, Sorry for this simple question. I was updating my Geoserver to version 2.20.3 and I seem to have some difficulty finding and downloading the image mosaic JDBC.zip (Jar). Has it been renamed Image Pyramid ( http://geoserver.org/release/stable/) ___

[Geoserver-users] Image mosaic JDBC module about to get demoted: anyone interested in stepping up?

Hi, the image mosaic JDBC module, used to access rasters stored in relational databases,has not seen any sort of maintenance for years. It's starting to pick up issues, but we have noone to fix them, or even to look at pull requests for those that are interested in a "touch and go" contribution. Te

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

yet another patch (detects single band 32 bit rasters and executes slightly different code, otherwise using original code) 32bit_raster-patch3.patch -- View this message in context: http://osgeo-org.1560.x6.nabble.

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Attaching a slighly better patch (ArrayOutOfBoundsException in fixed on zoom out) 32bit_raster-patch2.patch nroberts wrote > Hi Cristian, > > the patch for the hack is attached. > 32bit_raster.patch >

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Hi Cristian, the patch for the hack is attached. 32bit_raster.patch I did update my test raster to explicitely set noDataValue. This patch only works for 32bit Integer rasters at the moment. Also, there are some problem

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Can you send a diff file of your hack. Christian On Tue, Nov 5, 2013 at 8:28 AM, nroberts wrote: > Hi Christian, > > In terms of rescaling, the following seems to work at least for 32 bit > integer rasters: > > > Now my problem is with startImage - it is created with underlying values of > '0',

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Hi Christian, In terms of rescaling, the following seems to work at least for 32 bit integer rasters: Now my problem is with startImage - it is created with underlying values of '0', so when I pan or zoom out in Layer Preview, I get a black border around my image (please see screenshots below)

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

both 32 bit integer and float don't work for me. 32 bit integer produces solid black image due to alll values being turned into '0' and 32 bit float throws ArrayOutOfBounds exception when attempting to rescaleImage. cheers Nataliya Christian Mueller-3 wrote > Yep, the rescale op is the problem.

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Yep, the rescale op is the problem. Do you have a 32 bit float or integer raster. As far as I can remember, integer rasters should work fine, float is causing the problem. I also tried some different implemenations for the rescale operation, but none was working for float values. Cheers Christia

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Hi Christian, thank you for the suggestion! I have upgraded to 10.1 and the situation is a bit better, but I am still having a problem with my 32bit raster, albeit a slightly different one - all I can see now is a solid black image filling an entire image area in the Layer Preview. It looks to m

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Some weeks ago, I did some major changes. Please switch to the lastest version or check out trunk from github. Christian On Thu, Oct 31, 2013 at 12:45 PM, Andrea Aime wrote: > On Thu, Oct 31, 2013 at 12:34 PM, nroberts > wrote: > >> Hi Christian, >> >> I am using 9.5. >> >> I checked trunk svn

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

On Thu, Oct 31, 2013 at 12:34 PM, nroberts wrote: > Hi Christian, > > I am using 9.5. > > I checked trunk svn a few weeks back (assuming this is a correct location > for it: > > http://svn.osgeo.org/geotools/trunk/modules/plugin/imagemosaic-jdbc/src/main/java/org/geotools/gce/imagemosaic/jdbc > )

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Hi Christian, I am using 9.5. I checked trunk svn a few weeks back (assuming this is a correct location for it: http://svn.osgeo.org/geotools/trunk/modules/plugin/imagemosaic-jdbc/src/main/java/org/geotools/gce/imagemosaic/jdbc) and didn't spot any changes in the code in comparison to my my 9.5 v

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Hi Nataliya Which geotools version do you use. Are you working on trunk ? On Thu, Oct 31, 2013 at 8:02 AM, nroberts wrote: > Hi Mike and Christian, > > I am having the same problem with 32bit rasters as Mike experienced. I did > attempt to fix it by using a different BufferedImage constructor

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Hi Mike and Christian, I am having the same problem with 32bit rasters as Mike experienced. I did attempt to fix it by using a different BufferedImage constructor as Christian suggested, which allowed me to get past the imageComposerThread.getStartImage() issue, however, now rescaleImage is produc

Re: [Geoserver-users] Image Mosaic JDBC - not working

Hi Frederik During the last weekend I fixed a problem https://jira.codehaus.org/browse/GEOT-4561 Maybe this will fix your issue too. You can test with a nightly build or I can send you a jar file. Christian On Wed, Sep 4, 2013 at 11:41 AM, Christian Mueller < christian.muel...@os-solutions.at

Re: [Geoserver-users] Image Mosaic JDBC - not working

Hmmm, No idea how create an account, I did this a long time ago. Can you open a new thread on the user list asking how to get a JIRA account. I can remember some people having the same problem but I forgot the solution. On Wed, Sep 4, 2013 at 10:59 AM, Frederik Haefker wrote: > Thanks a lot for

Re: [Geoserver-users] Image Mosaic JDBC - not working

Thanks a lot for your effort and help!!! Do you have any idea why I can't create an account at http://jira.codehaus.org/browse/GEOS/ To create a new issue? It is recommended in the error message of geoserver: "Here's an error report you can include in a JIRA bug report about this issue:" Best

Re: [Geoserver-users] Image Mosaic JDBC - not working

About the geoserver error No chance without a debug session, I cannot see anything from the log files. Have a look at the supported formats http://www.oracle.com/technetwork/java/iio-141084.html On Wed, Sep 4, 2013 at 10:05 AM, Frederik Haefker wrote: > Good Morning, > > I just tried follow

Re: [Geoserver-users] Image Mosaic JDBC - not working

Good Morning, I just tried following idea: first I converted the geotiff to png > gdal_translate -co WORLDFILE=YES -of png 1.tif 2.png Then I followed the instruction of the tutorial. I didn't get the error message when I published the layer. The layer can be loaded to the main map and uses the

Re: [Geoserver-users] Image Mosaic JDBC - not working

Hi Frederik This is strange. In the file geoserver_aftererror.log I see 2013-09-03 13:35:57,116 INFO [org.geotools.gce.imagemosaic.jdbc] - Using 8 CPU(s) 2013-09-03 13:35:57,129 INFO [org.geotools.gce.imagemosaic.jdbc] - Getting 1 Tiles needs 13 millisecs 2013-09-03 13:35:57,134 INFO [org.geotool

Re: [Geoserver-users] Image Mosaic JDBC - not working

Hi Christian, I have full control of the geoserver (sudo etc.). So I think I can start a debug session. Sadly I don't know what to do :) (sorry) In my last message I sent you a file called error-log.txt which included a copy of the full error message. Maybe we can find a hint there? I can se

Re: [Geoserver-users] Image Mosaic JDBC - not working

Hi Christan, thanks again for the help. Sadly I don't understand what you mean by writing a simple test program. Regarding the geoserver status page JAI is working fine: Native JAI true Native JAI ImageIO true I will send you the log-files and screenshots separately. Gdalinfo do

Re: [Geoserver-users] Image Mosaic JDBC - not working

Hi erveryone, the Image Mosaic JDBC works fine and I could publish a png as shown in the tutorial: http://docs.geoserver.org/stable/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html However, when I try to publish my own geotiff I get an error message: "Oops, something went wrong

Re: [Geoserver-users] Image Mosaic JDBC - not working

Hi Christian, I did as you told me, but no new log files was created. For all 5 logging profiles I used following settings: Settings that apply to the entire server. Verbose Messages Verbose Exception Reporting Enable Global Service For restart I used: user@domain$ sudo service tomcat7 restart *

Re: [Geoserver-users] Image Mosaic JDBC - not working

Hi Frederik Please stay on the mailing list for discussions. Go to Global Settings and switch the log level to VERBOSE_LOGGING. Stop GeoServer and remove the log file from the file system. Start geoserver, and zip the new logfile. Repeat the same procedure with GEOTOOLS_DEVELOPER_LOGGING and GEO

Re: [Geoserver-users] Image Mosaic JDBC - not working

Hi Christian, thanks for the help. However, its not the solution. Actually you are right and I used sudo cp. But tomcat works quite fine with it (for example the proxy plugin was installed correctly). Just to make sure I changed the user-rights (sudo chmod -R ugo+rwx /var/lib/tomcat7/webapps/g

Re: [Geoserver-users] Image Mosaic JDBC - not working

Hi Frederik I did a quick test on the master branch and anything works fine. Did you check the file permissions of /var/lib/tomcat7/ webapps/geoserver/WEB-INF/lib/imagemosaich-jdbc-.jar Maybe you copied the jar file using the "root" user and tomact is using the "tomcat" user. In this case, tom

Re: [Geoserver-users] Image Mosaic JDBC - not working

Hello, I am sorry to send the request again. However, it is my first time writing to this user-list and I am really lost! In the geoserver web application (localhost:8080/geoserver) there is no possibility to add an Image Mosaic JDBC as a store. However, the .jar-file is at the right place an

[Geoserver-users] Image Mosaic JDBC - not working

Hello, we are using "Geoserver 2.4 RC1" with "tomcat7" on "Ubuntu 12.04". Everything is working fine with the exclusion of the "Image Mosaic JDBC"-plugin. The .jar-file is at the right place: user@station:/var/lib/tomcat7/webapps/geoserver/WEB-INF/lib$ ls -l total 55928 -rw-r--r-- 1 tomcat7 t

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Hi Christian, I concur, I was looking at that same bit of code as the likely culprit. I can also verify from some of my test code that my image is likely being read in through ImageDecodedThread.readImage2 When I read in my image using similar code, it's type is indeed BufferedImage.TYPE_CUSTOM

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Hi Mike I think I found the problem. It is in ImageComposerThread.getStartImage The unlucky code sequence is if (imageType == BufferedImage.TYPE_CUSTOM) imageType = ImageMosaicJDBCReader.DEFAULT_IMAGE_TYPE; I think your image type is custom and the default type is RGB wit 3 bands using bytes

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Hi Christian, I was curious what that would reveal too, so I tried that yesterday afternoon. I put together a small java jdbc program to run select st_astiff(rast) from test from my postgis database and dumped the result to a file. I then gdalinfo my original file (prior to the postgis load)

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Hi Mike Do you have the possibility to store the output of select st_astiff(rast) from test into a file. (I assume you have to code a little bit). On success, you could examine this file (test.tif) with gdalinfo. Cheers 2013/6/10 mrollans > Hi Christian, > > Thanks for the suggestion. I

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Hi Christian, Thanks for the suggestion. I attempted what you said, but learned that st_numbands expects a raster type not a bytea type as returned by st_astiff. Running select st_numbands(st_astiff(rast)) from test in pgadmin returns ERROR: function st_numbands(bytea) does not exist LINE 1:

Re: [Geoserver-users] Image Mosaic JDBC single band raster losing data values

Hi Mike The plugin uses "as_tiff" when fetching raster data. If you do some test queries, include st_astiff. Example: select st_numbands(st_astiff(rast)) from test instead of select st_numbands(rast) from test Christian 2013/6/6 mrollans > I'm trying to serve a single band raster from pos

[Geoserver-users] Image Mosaic JDBC single band raster losing data values

I'm trying to serve a single band raster from postgis though GeoServer using the Image Mosaic JDBC plugin. In short I'm seeing an issue such that the values in my single band are truncated to byte values between 0 and 255. Additionally, what was a single band raster appears as 3 band when viewed

Re: [Geoserver-users] image mosaic jdbc using Float 32 for pixel value

Hi Markus Zitat von Markus Innerebner : > Hi Christian, > >>> >>> I checked out code from github and moved to the correct branch. >>> >>> Until now I always tested everything together with geoserver, which makes >>> everything in debug mode much more heavy. So in future I want >>> instead to u

Re: [Geoserver-users] image mosaic jdbc using Float 32 for pixel value

Hi Christian, >> >> I checked out code from github and moved to the correct branch. >> >> Until now I always tested everything together with geoserver, which makes >> everything in debug mode much more heavy. So in future I want instead to use >> only geotools for testing. > > This is a good id

Re: [Geoserver-users] image mosaic jdbc using Float 32 for pixel value

Hi Markus Zitat von markusin : > Hi Christian, sorry for not answering you via mailing list. > > I checked out code from github and moved to the correct branch. > > Until now I always tested everything together with geoserver, which makes > everything in debug mode much more heavy. So in future I

Re: [Geoserver-users] image mosaic jdbc using Float 32 for pixel value

Hi Christian, sorry for not answering you via mailing list. I checked out code from github and moved to the correct branch. Until now I always tested everything together with geoserver, which makes everything in debug mode much more heavy. So in future I want instead to use only geotools for test

Re: [Geoserver-users] image mosaic jdbc using Float 32 for pixel value

Hi Markus, answers inside Zitat von markusin : > Hi Christian, > > do you mean many tests, or only tests related to this new functionality? There is only one test class with some tests and the "st_astiff" call is not the problem. > > When installing postgis 2.0 did you run the legacy.sql scri

Re: [Geoserver-users] image mosaic jdbc using Float 32 for pixel value

Hi Christian, do you mean many tests, or only tests related to this new functionality? When installing postgis 2.0 did you run the legacy.sql script? Maybe it will make sense that I create a develop environment that includes geoserver as well geotools. Or check out the version you are working for

Re: [Geoserver-users] image mosaic jdbc using Float 32 for pixel value

Hi Markus I tried to get the module working with postgis 2.0. Unfortunately the tests are completely broken. The syntax changed and a needed select statement gives me "Unknown WKB type 48" Do you work with postgis 2.0 or the former postgis raster component ?. The module was written for a

Re: [Geoserver-users] image mosaic jdbc using Float 32 for pixel value

The ticket in Jira is open, can you provide me a modified jar file after fixing the bug? many thanks Markus -- View this message in context: http://osgeo-org.1560.n6.nabble.com/image-mosaic-jdbc-using-Float-32-for-pixel-value-tp4993699p4994459.html Sent from the GeoServer - User mailing list

Re: [Geoserver-users] image mosaic jdbc using Float 32 for pixel value

Hi Christian thanks for your prompt answer. I will open an issue on jira. cheers Markus -- View this message in context: http://osgeo-org.1560.n6.nabble.com/image-mosaic-jdbc-using-Float-32-for-pixel-value-tp4993699p4994432.html Sent from the GeoServer - User mailing list archive at Nabble.

Re: [Geoserver-users] image mosaic jdbc using Float 32 for pixel value

It would not be a problem to use st_astiff instead of st_aspng but I have to test first. Can you open a JIRA issue ? The patch would go into geotools 8.x meaning that you have to use the upcoming geoserver 2.2.0. If it is urgent, it is possible to prepare an individual jar file after you o

Re: [Geoserver-users] image mosaic jdbc using Float 32 for pixel value

After debugging I found out, that the postgis function st_asPNG is causing that error. Why do you call here calling st_asTIFF(rast) works fine Thanks -- View this message in context: http://osgeo-org.1560.n6.nabble.com/image-mosaic-jdbc-using-Float-32-for-pixel-value-tp4993699p4994403.ht

[Geoserver-users] image mosaic jdbc using Float 32 for pixel value

Hello, I am using the image mosaic jdbc extension in Geoserver 2.1.4 to query data stored in a postgres 2.0 raster db. I imported the files as following using gdal_translate and raster2pg utility: The files is an ascii file where gdalinfo shows the following output: Then I translate the file i

[Geoserver-users] Image Mosaic JDBC & Gaps

Dear Geoserver Users I am getting same error (Image Gabs) in my application . Currently i am using Geoserver 2.1.0 version and image mosaic jdbc -- My data s taking from oracle database . Please provide any advice to me . - T.Manikandan GIS R&D -- View this message in context: http: