<div class="gmail_quote"><div>Hi, i'm new at this and i'm trying to connect to postgis raster in the mapfile.</div><div>I loaded a tif file into postgis raster database. It created a table with 2 fields.</div><div>
In the mapfile i added the connection like it specifies in the postgis raster FAQ but it doesnt displays a thing:</div><div><br></div><div><span class="Apple-style-span" style="border-collapse: collapse; color: rgb(46, 46, 46); font-family: 'Lucida Grande', Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; "><pre class="programlisting" style="border-right-width: 0px; border-left-width: 0px; border-bottom-width: 2px; border-top-width: 2px; font-family: 'Courier New', Courier, Monaco, monospace; line-height: 16px; border-top-color: rgb(247, 147, 30); border-right-color: rgb(247, 147, 30); border-bottom-color: rgb(247, 147, 30); border-left-color: rgb(247, 147, 30); border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; font-size: 11px; margin-bottom: 10px; margin-top: 10px; overflow-x: auto; overflow-y: auto; padding-top: 10px; padding-right: 10px; padding-bottom: 10px; padding-left: 10px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(248, 248, 249); border-top-left-radius: 2px 2px; border-top-right-radius: 2px 2px; border-bottom-right-radius: 2px 2px; border-bottom-left-radius: 2px 2px; background-position: initial initial; background-repeat: initial initial; ">
LAYER
NAME coolwktraster
TYPE raster
STATUS ON
DATA "PG:host=localhost port=5432 dbname='somedb' user='someuser' password='whatever'
schema='someschema' table='cooltable' mode='2'"
PROCESSING "NODATA=0"
PROCESSING "SCALE=AUTO"
#... other standard raster processing functions here
#... classes are optional but useful for 1 band data
CLASS
NAME "boring"
EXPRESSION ([pixel] < 20)
COLOR 250 250 250
END
CLASS
NAME "mildly interesting"
EXPRESSION ([pixel] > 20 AND [pixel] < 1000)
COLOR 255 0 0
END
CLASS
NAME "very interesting"
EXPRESSION ([pixel] >= 1000)
COLOR 0 255 0
END
END</pre></span></div><div><br></div><div>the mode=2 i deleted it because its for other postgis version, i have postgis 1.5.2.</div><div><br></div><div>Could you help me with this? Could someone connect with success?</div>
<div><br></div><div>Thank you!</div><div><br></div><div>Viriginia</div><div> </div></div>