[Geoserver-users] WMS: Filtering rasters in ImageMosaic JDBC store

GeoServer GeoServer User
1

Hi all,

I have a layer based on an Image Mosaic JDBC store on GeoServerV2.7.

Raster (satellite images, GeoTIFF) are dynamically tiled/loaded in PostGIS with raster2pgsql script.

The raster table contains the geometry, as well as the original GeoTIFF file name (in a column “filename”) and an associated date in a column “date” (timestamp).

Each GeoTIFF image is issued every hour from the same geostationary satellite, i.e. all images cover the same area but have different “filename” and “date”.

How can I add a filter in order to get in WMS only the raster matching to a given value of the columns “filename” and/or “date” in the PostGIS db?

· May this be done directly in the SLD associated to the layer?

· May this be done by CQL_FILTER?

· Is it possible to add these columns in the file “mapping.postgis.xml”

Thanks,

Victor

2

Hi Victor

The module does not support filtering at all.

Cheers
Christian

···

On Wed, Feb 18, 2015 at 3:42 PM, victor sinceac <Victor.Sinceac@anonymised.com…> wrote:

Hi all,

I have a layer based on an Image Mosaic JDBC store on GeoServerV2.7.

Raster (satellite images, GeoTIFF) are dynamically tiled/loaded in PostGIS with raster2pgsql script.

The raster table contains the geometry, as well as the original GeoTIFF file name (in a column “filename”) and an associated date in a column “date” (timestamp).

Each GeoTIFF image is issued every hour from the same geostationary satellite, i.e. all images cover the same area but have different “filename” and “date”.

How can I add a filter in order to get in WMS only the raster matching to a given value of the columns “filename” and/or “date” in the PostGIS db?

· May this be done directly in the SLD associated to the layer?

· May this be done by CQL_FILTER?

· Is it possible to add these columns in the file “mapping.postgis.xml”

Thanks,

Victor

Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&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

3

Thanks Christian, so afaik. there remains only one possible solution for my requirements: GeoTIFF files on hard disk store (Image Mosaic / Time Series)… I thought there was a method to serve dynamic images with GeoServer, with all the advantages provided by PostGIS raster format.

Maybe is there some schedule for future filtering in the Image Mosaic JDBC extension?

Victor

From: Christian Mueller [mailto:christian.mueller@…5445…]
Sent: mercredi 18 février 2015 16:18
To: victor sinceac
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] WMS: Filtering rasters in ImageMosaic JDBC store

Hi Victor

The module does not support filtering at all.

Cheers

Christian

On Wed, Feb 18, 2015 at 3:42 PM, victor sinceac <Victor.Sinceac@…5188…> wrote:

Hi all,

I have a layer based on an Image Mosaic JDBC store on GeoServerV2.7. Raster (satellite images, GeoTIFF) are dynamically tiled/loaded in PostGIS with raster2pgsql script. The raster table contains the geometry, as well as the original GeoTIFF file name (in a column “filename”) and an associated date in a column “date” (timestamp). Each GeoTIFF image is issued every hour from the same geostationary satellite, i.e. all images cover the same area but have different “filename” and “date”.

How can I add a filter in order to get in WMS only the raster matching to a given value of the columns “filename” and/or “date” in the PostGIS db?

· May this be done directly in the SLD associated to the layer?

· May this be done by CQL_FILTER?

· Is it possible to add these columns in the file “mapping.postgis.xml”

Thanks, Victor

4

Hi Victor

There are no plans to add filtering to the Image Mosaic JDBC Extension because this needs a full redesign/rewrite of the extension.

Cheers
Christian

···

On Wed, Feb 18, 2015 at 8:45 PM, victor sinceac <Victor.Sinceac@anonymised.com> wrote:

Thanks Christian, so afaik. there remains only one possible solution for my requirements: GeoTIFF files on hard disk store (Image Mosaic / Time Series)… I thought there was a method to serve dynamic images with GeoServer, with all the advantages provided by PostGIS raster format.

Maybe is there some schedule for future filtering in the Image Mosaic JDBC extension?

Victor

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: mercredi 18 février 2015 16:18
To: victor sinceac
Cc: geoserver-users@anonymised.comceforge.net
Subject: Re: [Geoserver-users] WMS: Filtering rasters in ImageMosaic JDBC store

Hi Victor

The module does not support filtering at all.

Cheers

Christian

On Wed, Feb 18, 2015 at 3:42 PM, victor sinceac <Victor.Sinceac@anonymised.com.> wrote:

Hi all,

I have a layer based on an Image Mosaic JDBC store on GeoServerV2.7. Raster (satellite images, GeoTIFF) are dynamically tiled/loaded in PostGIS with raster2pgsql script. The raster table contains the geometry, as well as the original GeoTIFF file name (in a column “filename”) and an associated date in a column “date” (timestamp). Each GeoTIFF image is issued every hour from the same geostationary satellite, i.e. all images cover the same area but have different “filename” and “date”.

How can I add a filter in order to get in WMS only the raster matching to a given value of the columns “filename” and/or “date” in the PostGIS db?

· May this be done directly in the SLD associated to the layer?

· May this be done by CQL_FILTER?

· Is it possible to add these columns in the file “mapping.postgis.xml”

Thanks, Victor

–

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