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