[postgis-users] [OT] multiple rasters in same table?

Raffaele Morelli raffaele.morelli at gmail.com
Wed Nov 5 01:03:25 PST 2014

On 31/10/14 at 03:12pm, Mateusz Łoskot wrote:
> 2014-10-31 15:08 GMT+01:00 Raffaele Morelli <raffaele.morelli at gmail.com>:
> > Is there any chance to load multiple rasters in the same table?
> >
> > Raffaele
> Yes.
> Similarly to vector, a raster layer in PostGIS is made of a pair:
> table and column, not just a table.

Yes, I finally loaded a bunch of GTiff without applying raster constraints
because they have different extents.

Now I am stucked in defining a working mapserver LAYER, ie how to query the
table according to 'filename' column (added OT in the subject because should be a mapserver related question I guess)

Given that layer definition:

        NAME "dtm20"
        DATA "PG:host=localhost dbname='xxx' user='xxxx' password='xxx' schema='dtms' table='dtm' where='filename=dtm1.tif' mode='2'"
        TYPE         RASTER

        [snip METADATA etc etc]

Then shp2img gives an error, no matter how I use quotes in where condition:

msDrawRasterLayerLow(): Unable to access file. Corrupt, empty or missing file 'PG:host='localhost' port='5432' dbname='xxx' user='xxx' password='xxx' schema='dtms' table='dtm' where='filename=dtm1.tif' mode='2'' for layer 'dtm20'. Error browsing database for PostGIS Raster properties <br>

Without where condition I obtain an image with all GTiff which is not what I want...

Where I am doint wrong?

« Nunc est bibendum, nunc pede libero pulsanda tellus »

More information about the postgis-users mailing list