couldn't adapt this postgis query

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

couldn't adapt this postgis query

orkun
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: 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
> [hidden email]
> 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

[hidden email]
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
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: couldn't adapt this postgis query

jratike80
In reply to this post by orkun

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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users