[mapserver-users] Re: Raster Data from PostGIS

[Fawcett, David (MPCA)]

Florencia, 

Since you are using this strategy for vector layers, I think that it could work for rasters.  

You would use gdaltindex or something else to create a polygon data set that represented the 'footprints' of your raster files.  http://mapserver.org/optimization/tileindex.html  One of the attribute columns in a tile index is the path to the location of each individual raster file.  The raster files are stored in the file system, not in the database.  The database just stores the paths to the images.

I don't know if you can create a tileindex directly in PostGIS, but you could import the output shapefile.  I am guessing that you would then create a related table in PostGIS that stored records containing the allowed tileid and username combinations.  

For the tileindex, you would use pretty much the same query that you use for your vector layers.

David.

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of florencia.bujan
Sent: Monday, November 29, 2010 10:39 AM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] Re: Raster Data from PostGIS


David,

Exactly. I done this with a dynamic parameter, like this:

DATA "the_geom from (SELECT l.* from lotes l, campos c WHERE c.id=l.idcampo
AND l.idcampo=%param%) as lotes using unique gid using SRID=-1"

but I want to do that with raster layer. Perhaps another solution is in the
passage of parameters.

Thanks!

Florencia from Uruguay


-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Raster-Data-from-PostGIS-tp5784362p5785003.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users