Hi Stefano
This is the way you have to prepare your image data:
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html
Import your raster data as described here
http://postgis.refractions.net/docs/using_raster.xml.html
GeoServer does not support importing postgis raster data, you have to use
the utility provided by postgis. It is not necessary to create geometry
columns, the postgis raster data type has all capabilities needed.
There is a test which may help you
https://github.com/geotools/geotools/blob/master/modules/plugin/imagemosaic-jdbc/src/test/java/org/geotools/gce/imagemosaic/jdbc/custom/PGRasterOnlineTest.java
Cheers
Christian
On Fri, Jul 25, 2014 at 10:13 AM, Stefano Iacovella <
[email protected]> wrote:
> Hi Christian
>
>
> Please use this tutorial
>>
>> http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html
>>
>
> I tried to follow steps from here:
>
>
> http://docs.geoserver.org/stable/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html
>
> Comparing with the other tutorial I found some major differences:
> 1) importing raster into PostGIS is performed using raster2psql in the
> link you sent, and this will produce a standard PostGIS raster while in the
> tutorial in GeoServer documentation the imagemosaic jdbc jar is used and
> this will create a different type of data. More specifically It seems to me
> that using the jar tiles are loaded in a PostgreSQL bytea field, while
> using raster2psql will create a raster field.
> 2) the suggested template for the mapping xml file is a bit different. It
> seems that collowing code is not needed in the geotools tutorial:
>
> <spatialTable>
> <keyAttributeName name="location" />
> <geomAttributeName name="geom" />
> <tileMaxXAttribute name="maxX"/>
> <tileMaxYAttribute name="maxY"/>
> <tileMinXAttribute name="minX"/>
> <tileMinYAttribute name="minY"/>
> </spatialTable>
>
>
>
>> I have seen that your mapping file has out commented the mix/max
>> attributes. Why ?
>>
> Uh I forgot to remove the comment, I first tried without it but got the
> same error. Then I had a look at the tables and noted the spatial table not
> having the fields and wondering if this may be an issue. I have attached
> the DDL generated by image mosaic jdbc jar
> I also tried to remove the comment in the XML mapping file but I got the
> same error. I have included full geoserver log
>
> Cheers
>
> Stefano
>
>
> ---------------------------------------------------
> 41.95581N 12.52854E
>
>
> http://www.linkedin.com/in/stefanoiacovella
>
> http://twitter.com/#!/Iacovellas
>
--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
