On 31/10/14 at 03:12pm, Mateusz Łoskot wrote:
> 2014-10-31 15:08 GMT+01:00 Raffaele Morelli <[email protected]>:
> > 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:
LAYER
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]
END
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?
Regards
--
« Nunc est bibendum, nunc pede libero pulsanda tellus »
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
