Christian,
I have followed the PostGIS raster tutorial and seemed to have ended up in the
same situation as before. When I try to add the ImageMosaic-JDBC store I
receive the dreaded "Could not list layers for this store, an error occurred
retrieving them: Argument "value" should not be null." error.
Here are the steps I took.
I loaded the raster into the DB:
raster2pgsql -I -C -s 4326 satellite.png public.satellite > pgraster.sql
psql -U xxxx -d xxxx -h xxxx -f pgraster.sql
Then I created the mosaic table using the sql in the tutorial and added a row
for my previously loaded raster:
insert into mosaic (name, tiletable) values ('satellite', 'satellite');
Then I created the mapping, connect and coverage xml files as described in the
tutorial only modifying the DB connection info and the coverageName value in
the coverage xml file to match the value in the mosaic table.
One thing I've noticed is that despite my coverageName specifying 'satellite'
all lower case, I get an error stating "No level available for Satellite" in
the GeoServer logs. When I update the name in the mosaic table to 'Satellite'
then I get a NullPointerException in ImageMosaicJDBCReader line 164. I'm not
sure why it would auto-capitalize my coverage name as all the references I've
made are lower case.
Kevin M. Weiss
From: Christian Mueller [mailto:[email protected]]
Sent: Tuesday, August 06, 2013 9:04 AM
To: Weiss, Kevin
Cc: [email protected]
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues
The imagemosiac-jdbc is NOT an extension of the ImageMosaic plugin and lacks
temporal support.
The tutorial link in your previous mail is a good starting point.
Cheers
Christian
On Tue, Aug 6, 2013 at 3:38 PM, Weiss, Kevin
<[email protected]<mailto:[email protected]>> wrote:
Hello Christian,
Yes, I was hoping to use the "time" parameter in WMS. I had prototyped an
example using the time & elevation tutorial (link below) a while back and just
assumed that the ImageMosaic-JDBC was an extension of the ImageMosaic plugin
and would support time-series as well.
http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html#tutorial-imagemosaic-timeseries
Is this the best tutorial for configuring GeoServer with PostGIS Raster? Even
if it doesn't support the time parameter, I'd at least like to get a prototype
running.
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html
Thanks,
Kevin M. Weiss
From: Christian Mueller
[mailto:[email protected]<mailto:[email protected]>]
Sent: Tuesday, August 06, 2013 7:42 AM
To: Weiss, Kevin
Cc:
[email protected]<mailto:[email protected]>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues
Hi Kevin
I would use PostGis raster columns.
Using pastebin.com<http://pastebin.com> for stack traces is ok, will have a
look at it later.
About temporal queries. Do you want to use the "time" parameter in WMS requests
? I never used it and the imagemosiac-JDBC module has no temporal support !!!
Cheers
Christian
On Tue, Aug 6, 2013 at 1:44 PM, Weiss, Kevin
<[email protected]<mailto:[email protected]>> wrote:
Hello Christian,
For the purpose of the exercise I was using the Blobs for image data storage.
With regards to my end goal, I'm not sold on one approach over the other. I'm
just looking to prototype a solution that allows me to programmatically store
spatial imagery in the database from a java application and have it available
for display via GeoServer while allowing temporal queries. Along the lines of
looping weather radar imagery.
Any help you could provide in either direction would be great.
Is there a preferred location for providing stack traces and such? I didn't
want to attach the files and spam the whole mailing list.
Thanks,
Kevin M. Weiss
From: Christian Mueller
[mailto:[email protected]<mailto:[email protected]>]
Sent: Tuesday, August 06, 2013 5:16 AM
To: Weiss, Kevin
Cc:
[email protected]<mailto:[email protected]>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues
Hi Kevin
A question, do you want to use PostGis Raster columns as described here
http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html<http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html>
or do you want to use Blobs for your image data.
At the moment, I have no access to pastebin.com<http://pastebin.com> due to
firewall rules of my customer.
Cheers
Christian
On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin
<[email protected]<mailto:[email protected]>> wrote:
I'm trying to configure an ImageMosaic-JDBC coverage per the instructions
(http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html<http://docs.geoserver.org/2.30/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html>)
and keep getting the following error "Could not list layers for this store, an
error occurred retrieving them: Argument "value" should not be null."
I've searched through the mailing list and have seen similar threads, but can't
find a solution to the problem. If anyone can help me out I'd appreciate it.
I'll attach pastebin links for the typically requested files.
The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added.
Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.
As a side note, my end goal is to construct a Raster Catalog containing
temporal imagery which can be retrieved and looped via GeoServer with the
rasters being persisted in postgres/postgis. If anyone has accomplished
something similar and is willing to give me some help or tips I would greatly
appreciate it.
Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX
osm.postgis.xml
http://pastebin.com/x0KaJB0n
mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK
connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS
Thanks,
Kevin M. Weiss
------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
