[mapserver-users] couldn't adapt this postgis query

[Rahkonen Jukka (MML)]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20161107/40787ba2/attachment.htm>