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

[Jörg Thomsen (WhereGroup)]

Hello,

how do you call the the layer?

in most cases this is a problem caused by the extend. Please check
whether it's correct or remove it temporarily, so ms will process it itself.

Another problem might be the 'status off' item.

Regard, Jörg


Am 07.11.2016 um 09:00 schrieb Ahmet Temiz:
> 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 


Viele Grüße,
Jörg Thomsen

-- 

********************************************
Where2B Konferenz 2016
15. Dezember 2016 in Bonn
www.where2b-conference.com
********************************************

-------------------------------
Jörg Thomsen
WhereGroup GmbH & Co. KG
Gillweg 3
14193 Berlin
Germany

Fon: +49 (0)30 / 5130 278 74
Fax: +49 (0)30 / 89 09 53 11

joerg.thomsen at wheregroup.com
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-------------------------------
Folgen Sie der WhereGroup auf twitter: http://twitter.com/WhereGroup_com