<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt">Florencia,<br><br>As far as I know, Mapserver only works with vectorial data on PostGIS. So having a kind of BLOB (bytea)<br>column doesn't work.<br><br>I guess you will have to had those TIF files as a file to be able to load it using a RASTER layer.<br><br>Cheers from México<br><br><div style="font-weight: bold; color: rgb(0, 96, 191);">IC Carlos Ruiz</div><br style="font-weight: bold; color: rgb(0, 96, 191);"><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><b><span style="font-weight: bold;">From:</span></b> florencia.bujan <florita026@gmail.com><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;"><font face="Tahoma" size="2"><b><span style="font-weight: bold;">To:</span></b> mapserver-users@lists.osgeo.org<br><b><span style="font-weight:
bold;">Sent:</span></b> Mon, November 29, 2010 7:46:56 AM<br><b><span style="font-weight: bold;">Subject:</span></b> [mapserver-users] Raster Data from PostGIS<br></font><br>
<br>Hi,<br><br>I have my data rasters (tif files) into my PostGIS database such as file. <br>Any file into database is in "bytea" format.<br>I want to show this raster layer from PostGIS with mapserver. My "Raster<br>Table" structure and my .map code are:<br><br>TABLE rasters (<br> id serial NOT NULL,<br> nombre character varying(100),<br> archivo_bytea bytea,<br> mime character varying(100),<br> size double precision<br>)<br><br>LAYER<br> NAME 'Raster'<br> TYPE RASTER<br> CONNECTIONTYPE postgis<br> CONNECTION "user=postgres password=... dbname=... host=..."<br> DATA "bytea FROM rasters"<br> STATUS OFF<br> OFFSITE 0 0 0<br> TRANSPARENCY 100<br>END<br><br>Thanks a
lot.<br>Regards.<br>Florencia<br>-- <br><span>View this message in context: <a target="_blank" href="http://osgeo-org.1803224.n2.nabble.com/Raster-Data-from-PostGIS-tp5784362p5784362.html">http://osgeo-org.1803224.n2.nabble.com/Raster-Data-from-PostGIS-tp5784362p5784362.html</a></span><br>Sent from the Mapserver - User mailing list archive at <a target="_blank" href="http://Nabble.com">Nabble.com</a>.<br>_______________________________________________<br>mapserver-users mailing list<br><a ymailto="mailto:mapserver-users@lists.osgeo.org" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br><span><a target="_blank" href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></span><br></div></div>
</div><br>
</body></html>