[postgis-users] View PostGIS raster in mapserver

[Pierre Racine]

Hemin,

On  a side line, can I ask you why you want to rasterize geometries with PostGIS or shp2img and then view them with MapServer when MapServer is already a rasterizer of geometries itself? It's like you will be rasterizing two times. Any specific application needs hard to see from here?

Thanks,

Pierre

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Hemin Tofiq
> Sent: Tuesday, March 20, 2012 6:57 PM
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] View PostGIS raster in mapserver
> 
> Dear Salvatore,
> 
> Thank you for your support.
> 
> I have now added the system variables and the path values from "setenv.bat", I
> can actually create a png using this command:
> 
> C:\spatialsuite\app\ms4w\tools\mapserv\shp2img -m
> C:\spatialsuite\app\ms4w\apps\mapserv-demo/itasca.map -o
> C:\spatialsuite\temp\shp2img2.png -l kommune_r
> 
> But mapserver creates still an empty png (I am using the same "itasca.map"
> used by shp2img).
> 
> Here is a part of the log file (showing the success of rendering of
> kommune_v(vector) and error when trying to render kommune_r(raster) from
> the same database)
> 
> [Tue Mar 20 23:50:09 2012] [error] [client 127.0.0.1] CGI Request 1 on process
> 1372\r [Tue Mar 20 23:50:09 2012] [error] [client 127.0.0.1] msDrawMap():
> rendering using outputformat named png (AGG/PNG).\r [Tue Mar 20 23:50:09
> 2012] [error] [client 127.0.0.1] msDrawMap(): WMS/WFS set-up and query,
> 0.000s\r [Tue Mar 20 23:50:09 2012] [error] [client 127.0.0.1] msDrawMap():
> Layer 0 (kommune_v), 0.104s\r [Tue Mar 20 23:50:09 2012] [error] [client
> 127.0.0.1] msDrawMap(): Layer 3 (ctybdpy2), 0.000s\r [Tue Mar 20 23:50:09
> 2012] [error] [client 127.0.0.1] msDrawMap(): Drawing Label Cache, 0.000s\r
> [Tue Mar 20 23:50:09 2012] [error] [client 127.0.0.1] msDrawMap() total
> time: 0.105s\r
> [Tue Mar 20 23:50:09 2012] [error] [client 127.0.0.1]
> msSaveImage(C:/spatialsuite/app/ms4w/tmp/ms_tmp/ITASCA13322838091372.
> png)
> total time: 0.122s\r
> [Tue Mar 20 23:50:09 2012] [error] [client 127.0.0.1]
> msSaveImage(C:/spatialsuite/app/ms4w/tmp/ms_tmp/ITASCAleg133228380913
> 72.png)
> total time: 0.004s\r
> [Tue Mar 20 23:50:09 2012] [error] [client 127.0.0.1]
> msSaveImage(C:/spatialsuite/app/ms4w/tmp/ms_tmp/ITASCAsb133228380913
> 72.png)
> total time: 0.003s\r
> [Tue Mar 20 23:50:09 2012] [error] [client 127.0.0.1]
> msSaveImage(C:/spatialsuite/app/ms4w/tmp/ms_tmp/ITASCAref133228380913
> 72.png)
> total time: 0.009s\r
> [Tue Mar 20 23:50:09 2012] [error] [client 127.0.0.1] mapserv request
> processing time (loadmap not incl.): 0.248s\r [Tue Mar 20 23:50:09 2012] [error]
> [client 127.0.0.1] msFreeMap(): freeing map at 02B31FD8.\r [Tue Mar 20
> 23:50:16 2012] [error] [client 127.0.0.1] CGI Request 1 on process 3080\r [Tue
> Mar 20 23:50:16 2012] [error] [client 127.0.0.1] msDrawMap(): rendering using
> outputformat named png (AGG/PNG).\r [Tue Mar 20 23:50:16 2012] [error]
> [client 127.0.0.1] msDrawMap(): WMS/WFS set-up and query, 0.000s\r [Tue Mar
> 20 23:50:16 2012] [error] [client 127.0.0.1]
> msDrawRasterLayerLow(kommune_r): entering.\r [Tue Mar 20 23:50:16 2012]
> [error] [client 127.0.0.1] Corrupt, empty or missing file 'PG:host=localhost
> port=5432 dbname='hto' user='hto'
> password='hto' \r
> [Tue Mar 20 23:50:16 2012] [error] [client 127.0.0.1] \t\tschema='raster'
> table='kommune_r' mode='2'' for layer 'kommune_r' ... ignoring this missing
> data.  Error checking geometry type existence. Is PostGIS correctly
> installed?: no connection to the server\r [Tue Mar 20 23:50:16 2012] [error]
> [client 127.0.0.1] \r [Tue Mar 20 23:50:16 2012] [error] [client 127.0.0.1]
> msDrawMap(): Layer 1 (kommune_r), 0.002s\r [Tue Mar 20 23:50:16 2012]
> [error] [client 127.0.0.1] msDrawMap(): Layer 3 (ctybdpy2), 0.001s\r [Tue Mar
> 20 23:50:16 2012] [error] [client 127.0.0.1] msDrawMap(): Drawing Label Cache,
> 0.000s\r [Tue Mar 20 23:50:16 2012] [error] [client 127.0.0.1] msDrawMap()
> total
> time: 0.003s\r
> [Tue Mar 20 23:50:16 2012] [error] [client 127.0.0.1]
> msSaveImage(C:/spatialsuite/app/ms4w/tmp/ms_tmp/ITASCA13322838163080.
> png)
> total time: 0.073s\r
> [Tue Mar 20 23:50:16 2012] [error] [client 127.0.0.1]
> msSaveImage(C:/spatialsuite/app/ms4w/tmp/ms_tmp/ITASCAleg133228381630
> 80.png)
> total time: 0.004s\r
> [Tue Mar 20 23:50:16 2012] [error] [client 127.0.0.1]
> msSaveImage(C:/spatialsuite/app/ms4w/tmp/ms_tmp/ITASCAsb133228381630
> 80.png)
> total time: 0.020s\r
> [Tue Mar 20 23:50:16 2012] [error] [client 127.0.0.1]
> msSaveImage(C:/spatialsuite/app/ms4w/tmp/ms_tmp/ITASCAref133228381630
> 80.png)
> total time: 0.006s\r
> [Tue Mar 20 23:50:16 2012] [error] [client 127.0.0.1] mapserv request
> processing time (loadmap not incl.): 0.113s\r [Tue Mar 20 23:50:16 2012] [error]
> [client 127.0.0.1] msFreeMap(): freeing map at 02A81FD8.\r
> 
> 
> It is probably the DATA item
> 
> Layer definition (as defined here
> http://www.postgis.org/documentation/manual-svn/RT_FAQ.html#id2822614):
> 
>   LAYER
> 	NAME kommune_r
> 	TYPE raster
> 	STATUS ON
> 	DATA "PG:host=localhost port=5432 dbname='hto' user='hto'
> password='hto'
> 		schema='raster' table='kommune_r' mode='2'"
> 	PROCESSING "NODATA=0"
> 	PROCESSING "SCALE=AUTO"
> 	  PROCESSING "RESAMPLE=NEAREST"
> 	CLASS
> 		NAME "kommune_r"
> 		COLOR 250 250 250
> 	END
> 
> END
> 
> 
> 
> Regards,
> Hemin
> 
> --
> View this message in context: http://postgis.17.n6.nabble.com/View-PostGIS-
> raster-in-mapserver-tp4627669p4638697.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users