Hi Paolo,<br>thx for hint.<br><br>I remove the <br>ConnectionType 'ogr'<br><br>and set the NODATA ans SCALE as suggested in the faq:<br><br> NAME "ofc10k_single"<br> STATUS ON<br> EXTENT 1559445 4921905 1566395 4927805<br>
TYPE raster<br> DATA "PG:host='localhost' port='22002' dbname='my_database' user='postgres' password='my_password' schema='my_schema' table='ofc10k_single_2010' mode='2'"<br>
PROCESSING "NODATA=0"<br> PROCESSING "SCALE=AUTO"<br><br>Unfortunately it still don't work correctly.<br>I set debug to max level and see this error report.<br><br>(seem the NODATA=0 was not supported ?)<br>
<br>....<br>[Wed Mar 14 02:18:43 2012].423056 msDrawMap(): rendering using outputformat named png (AGG/PNG).<br>[Wed Mar 14 02:18:43 2012].426271 msDrawMap(): WMS/WFS set-up and query, 0.003s<br>[Wed Mar 14 02:18:43 2012].430485 msDrawMap(): Layer 0 (credits), 0.004s<br>
[Wed Mar 14 02:18:43 2012].586938 msDrawRasterLayerLow(ofc10k_single): entering.<br>[Wed Mar 14 02:20:13 2012].461265 LoadGDALImage(ofc10k_single): NODATA value 0 in GDAL<br>file or PROCESSING directive largely ignored. Not yet fully supported for<br>
unclassified scaled data. The NODATA value is excluded from auto-scaling<br>min/max computation, but will not be transparent.<br>[Wed Mar 14 02:20:13 2012].463071 LoadGDALImage(ofc10k_single): NODATA value 0 in GDAL<br>file or PROCESSING directive largely ignored. Not yet fully supported for<br>
unclassified scaled data. The NODATA value is excluded from auto-scaling<br>min/max computation, but will not be transparent.<br>[Wed Mar 14 02:20:13 2012].464870 LoadGDALImage(ofc10k_single): NODATA value 0 in GDAL<br>file or PROCESSING directive largely ignored. Not yet fully supported for<br>
unclassified scaled data. The NODATA value is excluded from auto-scaling<br>min/max computation, but will not be transparent.<br>[Wed Mar 14 02:20:13 2012].468391 msDrawMap(): Layer 5 (ofc10k_single), 90.038s<br>[Wed Mar 14 02:20:13 2012].469876 msDrawMap(): Drawing Label Cache, 0.001s<br>
[Wed Mar 14 02:20:13 2012].469901 msDrawMap() total time: 90.048s<br>[Wed Mar 14 02:20:13 2012].486769 msSaveImage(stdout) total time: 0.017s<br>[Wed Mar 14 02:20:13 2012].487698 mapserv request processing time (msLoadMap not incl.): 90.066s<br>
[Wed Mar 14 02:20:13 2012].487722 msFreeMap(): freeing map at 0x1438770.<br>[Wed Mar 14 02:19:44 2012].369692 msDrawMap(): rendering using outputformat named png (AGG/PNG).<br>[Wed Mar 14 02:19:44 2012].371084 msDrawMap(): WMS/WFS set-up and query, 0.001s<br>
[Wed Mar 14 02:19:44 2012].373235 msDrawMap(): Layer 0 (credits), 0.002s<br>[Wed Mar 14 02:19:44 2012].376380 msDrawRasterLayerLow(ofc10k_single): entering.<br>[Wed Mar 14 02:21:13 2012].801136 LoadGDALImage(ofc10k_single): NODATA value 0 in GDAL<br>
file or PROCESSING directive largely ignored. Not yet fully supported for<br>unclassified scaled data. The NODATA value is excluded from auto-scaling<br>min/max computation, but will not be transparent.<br>[Wed Mar 14 02:21:13 2012].803247 LoadGDALImage(ofc10k_single): NODATA value 0 in GDAL<br>
file or PROCESSING directive largely ignored. Not yet fully supported for<br>unclassified scaled data. The NODATA value is excluded from auto-scaling<br>min/max computation, but will not be transparent.<br>[Wed Mar 14 02:21:13 2012].804759 LoadGDALImage(ofc10k_single): NODATA value 0 in GDAL<br>
file or PROCESSING directive largely ignored. Not yet fully supported for<br>unclassified scaled data. The NODATA value is excluded from auto-scaling<br>min/max computation, but will not be transparent.<br>[Wed Mar 14 02:21:13 2012].808087 msDrawMap(): Layer 5 (ofc10k_single), 89.435s<br>
[Wed Mar 14 02:21:13 2012].808290 msDrawMap(): Drawing Label Cache, 0.000s<br>[Wed Mar 14 02:21:13 2012].808302 msDrawMap() total time: 89.439s<br>[Wed Mar 14 02:21:13 2012].821898 msSaveImage(stdout) total time: 0.013s<br>
[Wed Mar 14 02:21:13 2012].821997 mapserv request processing time (msLoadMap not incl.): 89.453s<br>[Wed Mar 14 02:21:13 2012].822012 msFreeMap(): freeing map at 0x762770.<br>....<br><br><br><div class="gmail_quote">2012/3/13 Paolo Corti <span dir="ltr"><<a href="mailto:pcorti@gmail.com">pcorti@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On Tue, Mar 13, 2012 at 10:34 PM, Andrea Peri <<a href="mailto:aperi2007@gmail.com">aperi2007@gmail.com</a>> wrote:<br>
> Hi,<br>
> I'm try-ing to access a postgis raster using mapserver trunk,<br>
> but it don't seem work.<br>
><br>
> I don't understand if the problem is on the postgis raster or in the mapfile<br>
> settings.<br>
><br>
> So I like to know if this mapfile setting is ok to call a postgis raster<br>
> I use this mapfile settings:<br>
><br>
> The table ofc10k_single_2010 has only 1 raster loaded with this call:<br>
><br>
> raster2pgsql -s 3003 -l 3 -C -e -Y -I -M 216100_2010.tif -F -f rast -d -t<br>
> 100x100 my_schema.ofc10k_single_2010 > ofc10k_single_2010.sql<br>
><br>
> The gdal available is gdal 1.9.0.<br>
><br>
> The mapfile layer section is this:<br>
><br>
> LAYER<br>
> NAME "ofc10k_single"<br>
> STATUS ON<br>
> EXTENT 1559445 4921905 1566395 4927805<br>
> TYPE raster<br>
> CONNECTIONTYPE ogr<br>
> DATA "PG:host='localhost' port='5432' dbname='my_database'<br>
> user='postgres' password='my_password' schema='my_schema'<br>
> table='ofc10k_single_2010' mode='2'"<br>
> PROCESSING "NODATA=0"<br>
> PROCESSING "SCALE=-100.5,100.5"<br>
> PROCESSING "SCALE_BUCKETS=201"<br>
> # ... other standard raster processing functions here<br>
> PROJECTION<br>
> "init=epsg:3003"<br>
> END<br>
> METADATA<br>
> "wms_title" "OFC 1:10.000 single"<br>
> "wms_srs" "EPSG:3003 EPSG:4326"<br>
> END<br>
> OFFSITE 255 255 255<br>
> OPACITY 100<br>
> END<br>
><br>
> Thx for any hint.<br>
><br>
<br>
</div></div>Hi Andrea<br>
<br>
for sure you have to remove the line with the CONNECTIONTYPE set to<br>
ogr (that is only for vectorial layers [0]).<br>
The rest looks fine to me, but I cannot test it right now.<br>
BTW, have you read this [1] faq?<br>
<br>
ciao<br>
P<br>
<br>
[0] <a href="http://www.mapserver.org/input/vector/ogr.html" target="_blank">http://www.mapserver.org/input/vector/ogr.html</a><br>
[1] <a href="http://www.postgis.org/documentation/manual-svn/RT_FAQ.html#id3059359" target="_blank">http://www.postgis.org/documentation/manual-svn/RT_FAQ.html#id3059359</a><br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
Paolo Corti<br>
Geospatial software developer<br>
web: <a href="http://www.paolocorti.net" target="_blank">http://www.paolocorti.net</a><br>
twitter: @capooti<br>
skype: capooti<br>
</font></span></blockquote></div><br><br clear="all"><br>-- <br>-----------------<br>Andrea Peri<br>. . . . . . . . . <br>qwerty àèìòù<br>-----------------<br><br>