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
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to