No I am confused. Did you change and test with spatialExtension="pgraster"
instead of "postgis". (After importing with raster2pgsql)
On Thu, Aug 8, 2013 at 5:24 PM, Weiss, Kevin <kweis...@harris.com> wrote:
> Hello Christian,
> Yes, the mapping xml file is copied verbatim from the tutorial. The
> connect and coverage xml files were only modified for our connection info
> and to change the coverage name from "oek" to "satellite" to match my data.
>
> Kevin M. Weiss
>
> Software Engineer
>
> HARRIS IT Services
>
>
>
> 1408 Fort Crook Road South
>
> Bellevue, NE 68005
>
> kweis...@harris.com
>
> ________________________________________
> From: Christian Mueller [christian.muel...@os-solutions.at]
> Sent: Thursday, August 08, 2013 10:19 AM
> To: Weiss, Kevin
> Cc: geoserver-users@lists.sourceforge.net
> Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues
>
> Hi Kevin
>
> Did you change the value of the xml element "spatialExtension" to
> "PGRASTER"
>
>
> On Tue, Aug 6, 2013 at 5:37 PM, Weiss, Kevin <kweis...@harris.com<mailto:
> kweis...@harris.com>> wrote:
> 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:christian.muel...@os-solutions.at<mailto:
> christian.muel...@os-solutions.at>]
> Sent: Tuesday, August 06, 2013 9:04 AM
> To: Weiss, Kevin
> Cc: geoserver-users@lists.sourceforge.net<mailto:
> geoserver-users@lists.sourceforge.net>
> 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 <kweis...@harris.com<mailto:
> kweis...@harris.com>> 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:christian.muel...@os-solutions.at<mailto:
> christian.muel...@os-solutions.at>]
> Sent: Tuesday, August 06, 2013 7:42 AM
>
> To: Weiss, Kevin
> Cc: geoserver-users@lists.sourceforge.net<mailto:
> geoserver-users@lists.sourceforge.net>
> 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 <kweis...@harris.com<mailto:
> kweis...@harris.com>> 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:christian.muel...@os-solutions.at<mailto:
> christian.muel...@os-solutions.at>]
> Sent: Tuesday, August 06, 2013 5:16 AM
> To: Weiss, Kevin
> Cc: geoserver-users@lists.sourceforge.net<mailto:
> geoserver-users@lists.sourceforge.net>
> 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 <kweis...@harris.com<mailto:
> kweis...@harris.com>> 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
> Geoserver-users@lists.sourceforge.net<mailto:
> Geoserver-users@lists.sourceforge.net>
> 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
>
>
>
>
> --
> 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 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
