Hi,
Your query may work but because it is returning a point and you have commented
out your symbol it won’t show on the map. There may be some other problem as
well, but you must have SYMBOL because Mapserver does not have any default
style for points (stupid feature in Mapserver for my mind).
-Jukka Rahkonen-
Ahmet Temiz wrote:
[mapserver-users] couldn't adapt this postgis query
>hello
>I couldn't adapt this postgis query to mapserver. Nothing is displayed.
it gives normally output as point data in console and displayed in JUMP.
What am I doing wrong?
NAME 'faultBufferRoad'
TYPE POINT
#DUMP true
TEMPLATE fooOnlyForWMSGetFeatureInfo
EXTENT 2858992.767241 4274930.071479 4987500.356728 5175507.464287
CONNECTIONTYPE POSTGIS
CONNECTION "host=localhost port=5432 dbname=tr3 user=orkun password=222222"
DATA " geom from ( SELECT road.gid as gid , road.tipi as tipi,
ST_Transform(ST_LineInterpolatePoint(road.the_geom::geometry,0.5),3857) as geom
FROM road4analyse_geog as road INNER JOIN fault4analyse_geog AS fault ON
ST_DWithin(road.the_geom, fault.the_geom, 100,false ) AND ( fault.the_geom IS
NOT NULL or road.the_geom IS NOT NULL ) ) as foo using unique gid using
srid=3857 "
PROCESSING "CLOSE_CONNECTION=DEFER"
METADATA
'ows_title' 'faultBufferRoad'
END
STATUS OFF
#TRANSPARENCY ALPHA
OPACITY 90
PROJECTION
"init=epsg:3857"
END
#SYMBOLSCALEDENOM 100000
CLASSITEM 'tipi'
CLASS
NAME "Class1"
STYLE
#SYMBOL "circle"
SIZE 50
COLOR 0 0 200
END
END
END # LAYER
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
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
