[mapserver-users] to construct postgis raster in map file

[Ahmet Temiz]

With mapserver map file and postgis,
I need to construct st_slope postgis raster and then display it with
mapserver dynamically

that is to say how can I operate following postgis expression in mapserver
map file?

WITH r AS ( -- union of filtered tiles SELECT
206
ST_Transform(ST_Union(srtm.rast), 3310) AS rast FROM srtm
JOIN sfpoly sf
stom extent
SELECT ST_AsRaster(ST_Transform(sf.geom, 3310), r.rast) AS
rast FROM sfpoly sf
CROSS JOIN r
)SELECT ST_Clip(ST_Slope(r.rast, 1, cx.rast), S
T_Transform(sf.geom, 3310)) AS rast FROM r
CROSS JOIN cx
CROSS JOIN sfpoly sf;

regards


-- 
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu


________________________

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20150512/8e60ba3f/attachment.htm>