[Geoserver-users] publish postgis table which has a raster

Hi Vineendra,

you will have to use a Image Mosaic JDBC store:

http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html

Best Regards

----------------------------------------------------------------------

Message: 1
Date: Tue, 3 Sep 2013 04:43:44 -0700 (PDT)
From: Vineendra <vineendra.sriramoju@anonymised.com>
Subject: [Geoserver-users] publish postgis table which has a raster
  image using rest API services
To: geoserver-users@lists.sourceforge.net
Message-ID: <1378208624143-5075792.post@anonymised.com>
Content-Type: text/plain; charset=us-ascii

I am storing a thumbnail of an image which represent a large image in the
postgresql database. The size of the image is 1 to 2MB. Now i want to display the image in the database on the map in order to
represent the large image. I want to do this using geoserver REST API
services.

Previously i have published the postgis table which has vector data. How to
do it with raster data in table

Hi Frederik,

Thanks for the reply.

I have followed the tutorial to add a postgis raster to geoserver(which was suggested by you), but i am getting an error.

“Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I have followed the tutorial as it is. Every thing went well. But at the end, when i try to use the Image Mosaic JDBC store

Am attaching the screen shot of that error and geoserver log. Please do check them.

Screenshot from 2013-09-04 19:03:03.png

geoserver.log (503 KB)

···

On Tue, Sep 3, 2013 at 7:09 PM, Frederik Haefker <fhaefker@anonymised.com> wrote:

Hi Vineendra,

you will have to use a Image Mosaic JDBC store:

http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html

Best Regards


Message: 1
Date: Tue, 3 Sep 2013 04:43:44 -0700 (PDT)
From: Vineendra <vineendra.sriramoju@amigooptima.in>
Subject: [Geoserver-users] publish postgis table which has a raster
image using rest API services
To: geoserver-users@anonymised.comsourceforge.net
Message-ID: <1378208624143-5075792.post@n6.nabble.com>
Content-Type: text/plain; charset=us-ascii

I am storing a thumbnail of an image which represent a large image in the
postgresql database. The size of the image is 1 to 2MB. Now i want to display the image in the database on the map in order to
represent the large image. I want to do this using geoserver REST API
services.

Previously i have published the postgis table which has vector data. How to
do it with raster data in table

I had a quick look at the log file.

The problem is that the java image library cannot decode the image data fetched from postgis raster.

Can you send the output of

gdalinfo myimage

Perhaps your image format is not supported.

Cheers
Christian

···

On Thu, Sep 5, 2013 at 7:45 AM, Vineendra Sriramoju <vineendra.sriramoju@anonymised.com> wrote:

---------- Forwarded message ----------
From: Vineendra Sriramoju <vineendra.sriramoju@anonymised.com790…>
Date: Wed, Sep 4, 2013 at 7:13 PM
Subject: Re: publish postgis table which has a raster
To: Frederik Haefker <fhaefker@anonymised.com>

Hi Frederik,

Thanks for the reply.

I have followed the tutorial to add a postgis raster to geoserver(which was suggested by you), but i am getting an error.

“Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I have followed the tutorial as it is. Every thing went well. But at the end, when i try to use the Image Mosaic JDBC store

Am attaching the screen shot of that error and geoserver log. Please do check them.


Learn the latest–Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk


Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Tue, Sep 3, 2013 at 7:09 PM, Frederik Haefker <fhaefker@anonymised.com> wrote:

Hi Vineendra,

you will have to use a Image Mosaic JDBC store:

http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html

Best Regards


Message: 1
Date: Tue, 3 Sep 2013 04:43:44 -0700 (PDT)
From: Vineendra <vineendra.sriramoju@amigooptima.in>
Subject: [Geoserver-users] publish postgis table which has a raster
image using rest API services
To: geoserver-users@anonymised.comsourceforge.net
Message-ID: <1378208624143-5075792.post@n6.nabble.com>
Content-Type: text/plain; charset=us-ascii

I am storing a thumbnail of an image which represent a large image in the
postgresql database. The size of the image is 1 to 2MB. Now i want to display the image in the database on the map in order to
represent the large image. I want to do this using geoserver REST API
services.

Previously i have published the postgis table which has vector data. How to
do it with raster data in table

Hi Christian,

This is the gdalinfo of the image

Driver: GTiff/GeoTIFF
Files: test.tif
test.tfw
Size is 750, 750
Coordinate System is:
GEOGCS[“WGS 84”,
DATUM[“WGS_1984”,
SPHEROID[“WGS 84”,6378137,298.257223563,
AUTHORITY[“EPSG”,“7030”]],
AUTHORITY[“EPSG”,“6326”]],
PRIMEM[“Greenwich”,0],
UNIT[“degree”,0.0174532925199433],
AUTHORITY[“EPSG”,“4326”]]
Origin = (79.999583817610983,25.000417126729928)
Pixel Size = (0.006666666666667,-0.006666666666667)
Metadata:
AREA_OR_POINT=Area
Image Structure Metadata:
INTERLEAVE=BAND
Corner Coordinates:
Upper Left ( 79.9995838, 25.0004171) ( 79d59’58.50"E, 25d 0’ 1.50"N)
Lower Left ( 79.9995838, 20.0004171) ( 79d59’58.50"E, 20d 0’ 1.50"N)
Upper Right ( 84.9995838, 25.0004171) ( 84d59’58.50"E, 25d 0’ 1.50"N)
Lower Right ( 84.9995838, 20.0004171) ( 84d59’58.50"E, 20d 0’ 1.50"N)
Center ( 82.4995838, 22.5004171) ( 82d29’58.50"E, 22d30’ 1.50"N)
Band 1 Block=750x5 Type=Int16, ColorInterp=Gray

···

On Thu, Sep 5, 2013 at 7:14 PM, Christian Mueller <christian.mueller@anonymised.com> wrote:

I had a quick look at the log file.

The problem is that the java image library cannot decode the image data fetched from postgis raster.

Can you send the output of

gdalinfo myimage

Perhaps your image format is not supported.

Cheers
Christian

On Thu, Sep 5, 2013 at 7:45 AM, Vineendra Sriramoju <vineendra.sriramoju@anonymised.com90…> wrote:

---------- Forwarded message ----------
From: Vineendra Sriramoju <vineendra.sriramoju@anonymised.com>
Date: Wed, Sep 4, 2013 at 7:13 PM
Subject: Re: publish postgis table which has a raster
To: Frederik Haefker <fhaefker@anonymised.com>

Hi Frederik,

Thanks for the reply.

I have followed the tutorial to add a postgis raster to geoserver(which was suggested by you), but i am getting an error.

“Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I have followed the tutorial as it is. Every thing went well. But at the end, when i try to use the Image Mosaic JDBC store

Am attaching the screen shot of that error and geoserver log. Please do check them.


Learn the latest–Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk


Geoserver-users mailing list
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

On Tue, Sep 3, 2013 at 7:09 PM, Frederik Haefker <fhaefker@anonymised.com> wrote:

Hi Vineendra,

you will have to use a Image Mosaic JDBC store:

http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html

Best Regards


Message: 1
Date: Tue, 3 Sep 2013 04:43:44 -0700 (PDT)
From: Vineendra <vineendra.sriramoju@amigooptima.in>
Subject: [Geoserver-users] publish postgis table which has a raster
image using rest API services
To: geoserver-users@anonymised.comsourceforge.net
Message-ID: <1378208624143-5075792.post@n6.nabble.com>
Content-Type: text/plain; charset=us-ascii

I am storing a thumbnail of an image which represent a large image in the
postgresql database. The size of the image is 1 to 2MB. Now i want to display the image in the database on the map in order to
represent the large image. I want to do this using geoserver REST API
services.

Previously i have published the postgis table which has vector data. How to
do it with raster data in table

Do you have the possibility to write a tiny java program reading the image from the file system and writing it back for testing.

If not, can you send me a small sample image extracted with the gdal utilities. I can make the test.

Christian

···

On Thu, Sep 5, 2013 at 4:55 PM, Vineendra Sriramoju <vineendra.sriramoju@anonymised.com…5790…> wrote:

Hi Christian,

This is the gdalinfo of the image

Driver: GTiff/GeoTIFF
Files: test.tif
test.tfw
Size is 750, 750
Coordinate System is:
GEOGCS[“WGS 84”,
DATUM[“WGS_1984”,
SPHEROID[“WGS 84”,6378137,298.257223563,
AUTHORITY[“EPSG”,“7030”]],
AUTHORITY[“EPSG”,“6326”]],
PRIMEM[“Greenwich”,0],
UNIT[“degree”,0.0174532925199433],
AUTHORITY[“EPSG”,“4326”]]
Origin = (79.999583817610983,25.000417126729928)
Pixel Size = (0.006666666666667,-0.006666666666667)
Metadata:
AREA_OR_POINT=Area
Image Structure Metadata:
INTERLEAVE=BAND
Corner Coordinates:
Upper Left ( 79.9995838, 25.0004171) ( 79d59’58.50"E, 25d 0’ 1.50"N)
Lower Left ( 79.9995838, 20.0004171) ( 79d59’58.50"E, 20d 0’ 1.50"N)
Upper Right ( 84.9995838, 25.0004171) ( 84d59’58.50"E, 25d 0’ 1.50"N)
Lower Right ( 84.9995838, 20.0004171) ( 84d59’58.50"E, 20d 0’ 1.50"N)
Center ( 82.4995838, 22.5004171) ( 82d29’58.50"E, 22d30’ 1.50"N)
Band 1 Block=750x5 Type=Int16, ColorInterp=Gray

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Thu, Sep 5, 2013 at 7:14 PM, Christian Mueller <christian.mueller@anonymised.com> wrote:

I had a quick look at the log file.

The problem is that the java image library cannot decode the image data fetched from postgis raster.

Can you send the output of

gdalinfo myimage

Perhaps your image format is not supported.

Cheers
Christian

On Thu, Sep 5, 2013 at 7:45 AM, Vineendra Sriramoju <vineendra.sriramoju@anonymised.com> wrote:

---------- Forwarded message ----------
From: Vineendra Sriramoju <vineendra.sriramoju@anonymised.com>
Date: Wed, Sep 4, 2013 at 7:13 PM
Subject: Re: publish postgis table which has a raster
To: Frederik Haefker <fhaefker@anonymised.com>

Hi Frederik,

Thanks for the reply.

I have followed the tutorial to add a postgis raster to geoserver(which was suggested by you), but i am getting an error.

“Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I have followed the tutorial as it is. Every thing went well. But at the end, when i try to use the Image Mosaic JDBC store

Am attaching the screen shot of that error and geoserver log. Please do check them.


Learn the latest–Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk


Geoserver-users mailing list
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

On Tue, Sep 3, 2013 at 7:09 PM, Frederik Haefker <fhaefker@anonymised.com> wrote:

Hi Vineendra,

you will have to use a Image Mosaic JDBC store:

http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html

Best Regards


Message: 1
Date: Tue, 3 Sep 2013 04:43:44 -0700 (PDT)
From: Vineendra <vineendra.sriramoju@amigooptima.in>
Subject: [Geoserver-users] publish postgis table which has a raster
image using rest API services
To: geoserver-users@anonymised.comsourceforge.net
Message-ID: <1378208624143-5075792.post@n6.nabble.com>
Content-Type: text/plain; charset=us-ascii

I am storing a thumbnail of an image which represent a large image in the
postgresql database. The size of the image is 1 to 2MB. Now i want to display the image in the database on the map in order to
represent the large image. I want to do this using geoserver REST API
services.

Previously i have published the postgis table which has vector data. How to
do it with raster data in table

On Thu, Sep 5, 2013 at 8:38 PM, Christian Mueller <
christian.mueller@anonymised.com> wrote:

Do you have the possibility to write a tiny java program reading the image
from the file system and writing it back for testing.

If not, can you send me a small sample image extracted with the gdal
utilities. I can make the test.

Christian

On Thu, Sep 5, 2013 at 4:55 PM, Vineendra Sriramoju <
vineendra.sriramoju@anonymised.com> wrote:

Hi Christian,

This is the gdalinfo of the image

Driver: GTiff/GeoTIFF
Files: test.tif
       test.tfw
Size is 750, 750
Coordinate System is:
GEOGCS["WGS 84",
    DATUM["WGS_1984",
        SPHEROID["WGS 84",6378137,298.257223563,
            AUTHORITY["EPSG","7030"]],
        AUTHORITY["EPSG","6326"]],
    PRIMEM["Greenwich",0],
    UNIT["degree",0.0174532925199433],
    AUTHORITY["EPSG","4326"]]
Origin = (79.999583817610983,25.000417126729928)
Pixel Size = (0.006666666666667,-0.006666666666667)
Metadata:
  AREA_OR_POINT=Area
Image Structure Metadata:
  INTERLEAVE=BAND
Corner Coordinates:
Upper Left ( 79.9995838, 25.0004171) ( 79d59'58.50"E, 25d 0' 1.50"N)
Lower Left ( 79.9995838, 20.0004171) ( 79d59'58.50"E, 20d 0' 1.50"N)
Upper Right ( 84.9995838, 25.0004171) ( 84d59'58.50"E, 25d 0' 1.50"N)
Lower Right ( 84.9995838, 20.0004171) ( 84d59'58.50"E, 20d 0' 1.50"N)
Center ( 82.4995838, 22.5004171) ( 82d29'58.50"E, 22d30' 1.50"N)
Band 1 Block=750x5 Type=Int16, ColorInterp=Gray

On Thu, Sep 5, 2013 at 7:14 PM, Christian Mueller <
christian.mueller@anonymised.com> wrote:

I had a quick look at the log file.

The problem is that the java image library cannot decode the image data
fetched from postgis raster.

Can you send the output of

gdalinfo myimage

Perhaps your image format is not supported.

Cheers
Christian

On Thu, Sep 5, 2013 at 7:45 AM, Vineendra Sriramoju <
vineendra.sriramoju@anonymised.com> wrote:

---------- Forwarded message ----------
From: Vineendra Sriramoju <vineendra.sriramoju@anonymised.com>
Date: Wed, Sep 4, 2013 at 7:13 PM
Subject: Re: publish postgis table which has a raster
To: Frederik Haefker <fhaefker@anonymised.com>

Hi Frederik,

Thanks for the reply.

I have followed the tutorial to add a postgis raster to geoserver(which
was suggested by you), but i am getting an error.

"Could not list layers for this store, an error occurred retrieving
them: Argument "value" should not be null."

I have followed the tutorial as it is. Every thing went well. But at
the end, when i try to use the Image Mosaic JDBC store

Am attaching the screen shot of that error and geoserver log. Please do
check them.

On Tue, Sep 3, 2013 at 7:09 PM, Frederik Haefker <fhaefker@anonymised.com>wrote:

Hi Vineendra,

you will have to use a Image Mosaic JDBC store:

http://docs.geoserver.org/**stable/en/user/data/raster/**
postgisraster.html<http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html&gt;

Best Regards

------------------------------**------------------------------**

----------

Message: 1
Date: Tue, 3 Sep 2013 04:43:44 -0700 (PDT)
From: Vineendra <vineendra.sriramoju@**amigooptima.in<vineendra.sriramoju@anonymised.com>
>
Subject: [Geoserver-users] publish postgis table which has a raster
        image using rest API services
To: geoserver-users@anonymised.com**sourceforge.net<geoserver-users@lists.sourceforge.net>
Message-ID: <1378208624143-5075792.post@**n6.nabble.com<1378208624143-5075792.post@anonymised.com>
>
Content-Type: text/plain; charset=us-ascii

I am storing a thumbnail of an image which represent a large image in
the
postgresql database. The size of the image is 1 to 2MB. Now i want to
display the image in the database on the map in order to
represent the large image. I want to do this using geoserver REST API
services.

Previously i have published the postgis table which has vector data.
How to
do it with raster data in table

------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft
technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!

http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
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

image.zip (659 KB)

Hi Vineendra

Found the reason, look at http://jira.codehaus.org/browse/GEOT-4561

The problem is fixed on geotools 10.x series and will be available in geotools version 10.0 (geoserver version 2.4.0).

I will send you a jar file in a private mail for testing.

Cheers
Christian

···

On Fri, Sep 6, 2013 at 8:19 AM, Vineendra Sriramoju <vineendra.sriramoju@anonymised.com> wrote:

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Thu, Sep 5, 2013 at 8:38 PM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Do you have the possibility to write a tiny java program reading the image from the file system and writing it back for testing.

If not, can you send me a small sample image extracted with the gdal utilities. I can make the test.

Christian

On Thu, Sep 5, 2013 at 4:55 PM, Vineendra Sriramoju <vineendra.sriramoju@anonymised.com> wrote:

Hi Christian,

This is the gdalinfo of the image

Driver: GTiff/GeoTIFF
Files: test.tif
test.tfw
Size is 750, 750
Coordinate System is:
GEOGCS[“WGS 84”,
DATUM[“WGS_1984”,
SPHEROID[“WGS 84”,6378137,298.257223563,
AUTHORITY[“EPSG”,“7030”]],
AUTHORITY[“EPSG”,“6326”]],
PRIMEM[“Greenwich”,0],
UNIT[“degree”,0.0174532925199433],
AUTHORITY[“EPSG”,“4326”]]
Origin = (79.999583817610983,25.000417126729928)
Pixel Size = (0.006666666666667,-0.006666666666667)
Metadata:
AREA_OR_POINT=Area
Image Structure Metadata:
INTERLEAVE=BAND
Corner Coordinates:
Upper Left ( 79.9995838, 25.0004171) ( 79d59’58.50"E, 25d 0’ 1.50"N)
Lower Left ( 79.9995838, 20.0004171) ( 79d59’58.50"E, 20d 0’ 1.50"N)
Upper Right ( 84.9995838, 25.0004171) ( 84d59’58.50"E, 25d 0’ 1.50"N)
Lower Right ( 84.9995838, 20.0004171) ( 84d59’58.50"E, 20d 0’ 1.50"N)
Center ( 82.4995838, 22.5004171) ( 82d29’58.50"E, 22d30’ 1.50"N)
Band 1 Block=750x5 Type=Int16, ColorInterp=Gray

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Thu, Sep 5, 2013 at 7:14 PM, Christian Mueller <christian.mueller@anonymised.com45…> wrote:

I had a quick look at the log file.

The problem is that the java image library cannot decode the image data fetched from postgis raster.

Can you send the output of

gdalinfo myimage

Perhaps your image format is not supported.

Cheers
Christian

On Thu, Sep 5, 2013 at 7:45 AM, Vineendra Sriramoju <vineendra.sriramoju@anonymised.com> wrote:

---------- Forwarded message ----------
From: Vineendra Sriramoju <vineendra.sriramoju@anonymised.com>
Date: Wed, Sep 4, 2013 at 7:13 PM
Subject: Re: publish postgis table which has a raster
To: Frederik Haefker <fhaefker@anonymised.com>

Hi Frederik,

Thanks for the reply.

I have followed the tutorial to add a postgis raster to geoserver(which was suggested by you), but i am getting an error.

“Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I have followed the tutorial as it is. Every thing went well. But at the end, when i try to use the Image Mosaic JDBC store

Am attaching the screen shot of that error and geoserver log. Please do check them.


Learn the latest–Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk


Geoserver-users mailing list
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

On Tue, Sep 3, 2013 at 7:09 PM, Frederik Haefker <fhaefker@anonymised.com> wrote:

Hi Vineendra,

you will have to use a Image Mosaic JDBC store:

http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html

Best Regards


Message: 1
Date: Tue, 3 Sep 2013 04:43:44 -0700 (PDT)
From: Vineendra <vineendra.sriramoju@amigooptima.in>
Subject: [Geoserver-users] publish postgis table which has a raster
image using rest API services
To: geoserver-users@anonymised.comsourceforge.net
Message-ID: <1378208624143-5075792.post@n6.nabble.com>
Content-Type: text/plain; charset=us-ascii

I am storing a thumbnail of an image which represent a large image in the
postgresql database. The size of the image is 1 to 2MB. Now i want to display the image in the database on the map in order to
represent the large image. I want to do this using geoserver REST API
services.

Previously i have published the postgis table which has vector data. How to
do it with raster data in table