<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
For performance reason it is advised NOT to store your raster images
inside the database. This discussion gets opened about once every
month. There is no functionality available to read raster images from a
database.<br>
<br>
<br>
<br>
Ryan Ollerenshaw schreef:
<blockquote
cite="mid:20b31d4d0710221237v2738e2ddmadd7aca2c88f5785@mail.gmail.com"
type="cite">
<pre wrap="">How can i use a Postgres database to display raster images with
Mapserver? There are lots of examples on display features this way
and using a gdaltindex to create a shapefile but i cant find any that
talk about using a database to store raster images. Here is what i am
currently trying:
LAYER
NAME "stereo_simp"
TYPE RASTER
PROCESSING "SCALE=AUTO" #rescale 16-bit image to 8-bit
STATUS on
CONNECTION "host=localhost dbname=test user=postgres"
CONNECTIONTYPE POSTGIS
DATA "location FROM stereo"
TILEINDEX "stereo" #the table name
TILEITEM "location" #column that contains the path to the image
END
if i just try and display the image directly it works just fine:
LAYER
NAME "stereo_simp"
TYPE RASTER
PROCESSING "SCALE=AUTO" #rescale 16-bit to 8-bit
STATUS on
DATA "/hiview/products/data/20070929_000600_14euA_171_16_gdal.tif"
END
Thank you for your time,
-Ryan
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<title>3DSite</title>
<meta http-equiv="Content-Type" content="text/html; ">
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
margin-left: 5px;
margin-top: 5px;
margin-right: 5px;
margin-bottom: 5px;
}
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #333333;
}
.style4 {font-size: 9px; }
.style5 {font-size: 9px; color: #CCCCCC; }
-->
</style>
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<br>
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tbody>
<tr>
<td rowspan="3" align="left" height="0" valign="bottom" width="15"><br>
</td>
<td colspan="2" align="left" height="78" valign="top" width="0">
<p class="style4">Milo van der Linden
<br>
<a href="skype:milovanderlinden?add">skype: milovanderlinden</a><br>
<a href="mailto:mlinden@zeelandnet.nl">mlinden@zeelandnet.nl</a><br>
<a href="mailto:milovanderlinden@gmail.com">milovanderlinden@gmail.com</a><br>
<a href="mailto:milo@3dsite.nl">milo@3dsite.nl</a><br>
<a href="http://www.3dsite.nl">http://www.3dsite.nl</a><br>
</p>
</td>
<td rowspan="3" align="left" height="0" valign="top" width="15"> </td>
<td valign="top" width="300">
<p class="style5"><span lang="NL">De informatie in dit bericht
reflecteert mijn persoonlijke mening en niet die van een bedrijf of
instantie. Aan de informatie kunnen geen rechten worden ontleend.
Indien dit bericht onderdeel is van een forum, mailing-list of
community dan gelden automatisch de bij het betreffende medium
behorende voorwaarden.</span>
<span lang="EN">The information in this message reflects my
personal opinion and not that of a company or public body. All rights
reserved.If this message is contained in a mailing-list or community,
the rights on the medium are automatically adapted.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>