[Geoserver-users] ImageMosaicJDBC How to create tables which not store raster-format but only the absolute paths to image files inclusive the geometry column

GeoServer GeoServer User
1

Hi all,

following steps i had done:

  1. gdal_retile for image pyramids of my GeoTIFF

  2. gdaltindex for shape file of bounding box of each pyramid step inclusive the absolute path on file system

  3. Create Table for mosaic-table and fill information of my geotiff:

CREATE TABLE mosaic_geom

(

name character varying(254) NOT NULL,

spatialtable character varying(254) NOT NULL,

minx double precision,

miny double precision,

maxx double precision,

maxy double precision,

resx double precision,

resy double precision,

CONSTRAINT rmosaic_geom_pkey PRIMARY KEY (name, spatialtable)

)

“dop2014rgb_5000_path”;“dop2014rgb_5000_path_1”;;;;;;

“dop2014rgb_5000_path”;“dop2014rgb_5000_path_2”;;;;;;

“dop2014rgb_5000_path”;“dop2014rgb_5000_path_3”;;;;;;

“dop2014rgb_5000_path”;“dop2014rgb_5000_path_4”;;;;;;

“dop2014rgb_5000_path”;“dop2014rgb_5000_path_5”;;;;;;

“dop2014rgb_5000_path”;“dop2014rgb_5000_path_6”;;;;;;

“dop2014rgb_5000_path”;“dop2014rgb_5000_path_7”;;;;;;

“dop2014rgb_5000_path”;“dop2014rgb_5000_path_8”;;;;;;

“dop2014rgb_5000_path”;“dop2014rgb_5000_path_0”;;;;;;

  1. Create Tables for each pyramid step und insert to shape file and absolute path:

For example:

CREATE TABLE dop2014rgb_5000_path_0

(

location character(64) NOT NULL,

geom geometry(MultiPolygon,25833)

)

"D:\Datenimport\DOP2014RGB5000\0\dop20c_33298_5610_01_37.tif ";“0106000020E9640000010000000103000000010000000500000000000000C06214410000000070935541000000006072144100000000709355410000000060721441000000007692554100000000C0621441000000007692554100000000C06214410000000070935541”

"D:\Datenimport\DOP2014RGB5000\0\dop20c_33298_5610_01_38.tif ";“0106000020E964000001000000010300000001000000050000000000000060721441000000007093554100000000008214410000000070935541000000000082144100000000769255410000000060721441000000007692554100000000607214410000000070935541”

  1. Create XML-Files for ImageMosaicJDBC-Plugin in GeoServer:

dop2014rgb_5000_path.postgis.xml

<?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE ImageMosaicJDBCConfig [ ]>

&mapping;

&connect;

mapping_path.postgis.xml

Now comes a error when I add a data store using this xml-files:

2015-04-30 12:46:52,415 ERROR [imagemosaic.jdbc] - No level available for dop2014rgb_5000_path

2015-04-30 12:46:52,415 ERROR [imagemosaic.jdbc] - No level available for dop2014rgb_5000_path

2015-04-30 12:46:52,415 WARN [imagemosaic.jdbc] - java.io.IOException: No level available for dop2014rgb_5000_path

java.io.IOException: java.io.IOException: No level available for dop2014rgb_5000_path

at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCReader.(ImageMosaicJDBCReader.java:163)

at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat.getReader(ImageMosaicJDBCFormat.java:226)

at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat.getReader(ImageMosaicJDBCFormat.java:68)

at org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1436)

…

What is the mistake?

Greets,

André Mende