Output from gdalinfo looks good.
I think I will do some debugging tomorrow.
Is it possible that you can you send me your pgraster.sql and your image,
(Only to me, not on the mailing list).
Christian
On Thu, Aug 8, 2013 at 5:54 PM, Weiss, Kevin <kweis...@harris.com> wrote:
> Christian,
> Here is the output from gdalinfo
>
> $>gdalinfo ecnremappedir.png
> Driver: PNG/Portable Network Graphics
> Files: ecnremappedir.png
> ecnremappedir.pgw
> Size is 2880, 2880
> Coordinate System is `'
> Origin = (-128.015625000000000,90.015625000000000)
> Pixel Size = (0.031250000000000,-0.031250000000000)
> Image Structure Metadata:
> INTERLEAVE=PIXEL
> Corner Coordinates:
> Upper Left (-128.0156250, 90.0156250)
> Lower Left (-128.0156250, 0.0156250)
> Upper Right ( -38.0156250, 90.0156250)
> Lower Right ( -38.0156250, 0.0156250)
> Center ( -83.0156250, 45.0156250)
> Band 1 Block=2880x1 Type=Byte, ColorInterp=Red
> Band 2 Block=2880x1 Type=Byte, ColorInterp=Green
> Band 3 Block=2880x1 Type=Byte, ColorInterp=Blue
>
>
> 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:47 AM
> To: Weiss, Kevin
> Cc: geoserver-users@lists.sourceforge.net
> Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues
>
> Hi Kevin
>
> Maybe your image data is not supported by the java image IO library. Can
> you post me the the output of
>
> gdalinfo myimage
>
> Christian
>
>
> On Thu, Aug 8, 2013 at 5:34 PM, Weiss, Kevin <kweis...@harris.com<mailto:
> kweis...@harris.com>> wrote:
> Christian,
> Rather than altering the files I had created while following the first
> tutorial, I started fresh following the tutorial here:
> http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html
>
> The mapping xml file in that tutorial already has the spatialExtension set
> to "pgraster" so I didn't need to modify anything. I merely copied &
> pasted for that file.
>
> Kevin M. Weiss
>
> Software Engineer
>
> HARRIS IT Services
>
>
>
> 1408 Fort Crook Road South
>
> Bellevue, NE 68005
>
> kweis...@harris.com<mailto:kweis...@harris.com>
>
> ________________________________________
> From: Christian Mueller [christian.muel...@os-solutions.at<mailto:
> christian.muel...@os-solutions.at>]
> Sent: Thursday, August 08, 2013 10:29 AM
> To: Weiss, Kevin
> Cc: geoserver-users@lists.sourceforge.net<mailto:
> geoserver-users@lists.sourceforge.net>
> Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues
>
> 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<mailto:
> kweis...@harris.com><mailto:kweis...@harris.com<mailto: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<mailto:kweis...@harris.com><mailto:kweis...@harris.com
> <mailto:kweis...@harris.com>>
>
> ________________________________________
> From: Christian Mueller [christian.muel...@os-solutions.at<mailto:
> christian.muel...@os-solutions.at><mailto:
> christian.muel...@os-solutions.at<mailto:christian.muel...@os-solutions.at
> >>]
> Sent: Thursday, August 08, 2013 10:19 AM
> To: Weiss, Kevin
> Cc: geoserver-users@lists.sourceforge.net<mailto:
> geoserver-users@lists.sourceforge.net><mailto:
> geoserver-users@lists.sourceforge.net<mailto:
> 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><mailto:kweis...@harris.com<mailto:kweis...@harris.com
> >><mailto:kweis...@harris.com<mailto:kweis...@harris.com><mailto:
> 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><mailto:
> christian.muel...@os-solutions.at<mailto:christian.muel...@os-solutions.at
> >><mailto:christian.muel...@os-solutions.at<mailto:
> christian.muel...@os-solutions.at><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><mailto:
> geoserver-users@lists.sourceforge.net<mailto:
> geoserver-users@lists.sourceforge.net>><mailto:
> geoserver-users@lists.sourceforge.net<mailto:
> geoserver-users@lists.sourceforge.net><mailto:
> 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><mailto:kweis...@harris.com<mailto:kweis...@harris.com
> >><mailto:kweis...@harris.com<mailto:kweis...@harris.com><mailto:
> 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><mailto:
> christian.muel...@os-solutions.at<mailto:christian.muel...@os-solutions.at
> >><mailto:christian.muel...@os-solutions.at<mailto:
> christian.muel...@os-solutions.at><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><mailto:
> geoserver-users@lists.sourceforge.net<mailto:
> geoserver-users@lists.sourceforge.net>><mailto:
> geoserver-users@lists.sourceforge.net<mailto:
> geoserver-users@lists.sourceforge.net><mailto:
> 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><http://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><mailto:kweis...@harris.com<mailto:kweis...@harris.com
> >><mailto:kweis...@harris.com<mailto:kweis...@harris.com><mailto:
> 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><mailto:
> christian.muel...@os-solutions.at<mailto:christian.muel...@os-solutions.at
> >><mailto:christian.muel...@os-solutions.at<mailto:
> christian.muel...@os-solutions.at><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><mailto:
> geoserver-users@lists.sourceforge.net<mailto:
> geoserver-users@lists.sourceforge.net>><mailto:
> geoserver-users@lists.sourceforge.net<mailto:
> geoserver-users@lists.sourceforge.net><mailto:
> 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><
> http://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><mailto:kweis...@harris.com<mailto:kweis...@harris.com
> >><mailto:kweis...@harris.com<mailto:kweis...@harris.com><mailto:
> kweis...@harris.com<mailto:kweis...@harris.com>>>> wrote:
> I'm trying to configure an ImageMosaic-JDBC coverage per the instructions (
> http://docs.geoserverorg/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html
> <
> http://docs.geoserverorg/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html
> <
> 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><mailto:
> Geoserver-users@lists.sourceforge.net<mailto:
> Geoserver-users@lists.sourceforge.net>><mailto:
> Geoserver-users@lists.sourceforge.net<mailto:
> Geoserver-users@lists.sourceforge.net><mailto:
> 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
>
>
>
> --
> 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
