[mapserver-users] PostGIS Raster Filters

[Steve Lime]

Can you access/filter the data outside MapServer with only GDAL? Might be
easier to battle one piece of software rather than two.

On Thu, Jun 18, 2020 at 10:09 AM <brett.winklesky at gmail.com> wrote:

> Hello-
>
>
>
> I’m trying to setup a WMS layer that is reading a raster table in
> PostGIS.  I am loading NOAA Global Hydro Estimation data in a single table
> (tiled) and have a field that contains the datetime for the raster.  I
> followed the examples here:
>
>
>
> https://postgis.net/docs/RT_FAQ.html#idm29732
>
>
>
> In my case I would like to use the “where” statement to filter the raster
> tiles, but the ‘where’ statement only seems to work with the ‘rid’ field
> (e.g. rid=123).  Based on the example in the PostGIS docs, it looks like it
> should theoretically work.  I tried the “FILTER” in the map file, but I
> assume that only works with vector data since it did nothing.
>
>
>
> Does anybody know the trick to filter tiled raster data from a PostGIS
> raster table?
>
>
>
> Any help is greatly appreciated!
>
>
>
> Cheers,
>
>
>
> BW
>
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20200618/51d6f046/attachment.htm>