date:20161107

[mapserver-users] confused on styling polygon

2016-11-07 Thread Ahmet Temiz

Hi,
I think I am confused on styling polygon.
I normally displayed the map without using symbol. When
I used symbol. Nothing is displayed.

here is the relevant code.


  STATUS OFF
  TYPE POLYGON
  OPACITY 80
  CLASS
 STYLE
   SYMBOL "diagonal-auf2"
   COLOR 0 0 252
   SIZE 10
   WIDTH 5
 END
  END

SYMBOL
  NAME "diagonal-auf2"
  TYPE vector
  POINTS
0 0.8
0.2 1
1 0.2
0.8 0
0 0.8
  END
  FILLED TRUE
END

What am I doing wrong?

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

Re: [mapserver-users] [mapserver-dev] MapServer tutorial - symbology

2016-11-07 Thread Lime, Steve D (MNIT)

It's by no means a bad idea - I've thought that a standard set of named colors 
could also make sense (e.g. COLOR RED). At least for symbols they could be 
implemented (I think) as a constant hash where the key is the symbol name and 
the value is a mapfile snippet (e.g. "SYMBOL NAME 'circle' POINTS 1 1 END 
FILLED TRUE END"). When a mapfile is loaded that hash could be used to load 
symbols or I suppose they could be only loaded if referenced.

Might warrant a little RFC.

Steve


From: mapserver-dev [mapserver-dev-boun...@lists.osgeo.org] on behalf of 
Rahkonen Jukka (MML) [jukka.rahko...@maanmittauslaitos.fi]
Sent: Tuesday, October 25, 2016 5:55 AM
To: geograph...@gmail.com; mapserver-...@lists.osgeo.org
Cc: Mapserver-Users (mapserver-users@lists.osgeo.org)
Subject: Re: [mapserver-dev] MapServer tutorial - symbology

Hi,

I think that this kind of discussion belongs to mapserver-users (cc:ed). I hope 
that developers read also the users mailing list, and users may have more to 
say about what they consider hard with styles. Also, Mapserver users learn from 
reading mails like this, and that there are mails on the list at all proves 
that the project is not dead. Developers can discuss on the dev list or in 
GitHub about how to implement the “size by expression” with C++ and so on.

One thing that always feels odd to me is that why we do not have any default 
style for points but we must especially define some symbol in the mapfile. I 
have been thinking that perhaps we could have internal, hard coded symbols at 
least for these 6 which are defined in the SLD standard:

“The WellKnownName element gives the well-known name of the shape of the mark. 
Allowed values include at least “square”, “circle”, “triangle”, “star”, 
“cross”, and “x”, though map servers may draw a different symbol instead if 
they don't have a shape for all of these. The default WellKnownName is 
“square”. Renderings of these marks may be made solid or hollow depending on 
Fill and Stroke elements. These elements are discussed in Subclauses 11.2.2 and 
11.1.3, respectively.”

If user gives no symbol in the mapfile for points it would mean “square”. If 
symbol with the same name than WellKnownName is defined in mapfile or in 
symbolset it would override the standard symbol. If there is a special need for 
non-visible points  we could have one more: SYMBOL “NONE”.

-Jukka Rahkonen-

Lähettäjä: mapserver-dev [mailto:mapserver-dev-boun...@lists.osgeo.org] 
Puolesta Seth G
Lähetetty: 25. lokakuuta 2016 13:20
Vastaanottaja: mapserver-...@lists.osgeo.org
Aihe: [mapserver-dev] MapServer tutorial - symbology


Hi all,

I have updated the second quick start tutorial on SYMBOLS and symbolizing data. 
A draft page is available at: 
https://geographika.github.io/tutorial/quickstart/symbolizing.html

I ran through this with around 6 people, and a few questions came up. If anyone 
can provide details that would be very helpful. Also comments/improvements on 
the tutorials are very welcome.

1. Are there any performance or other benefits of VECTOR symbols over 
IMAGE/SVG? (Although I think SVG is currently not available in ms4w - 
http://www.ms4w.com/trac/ticket/3 ). The manual entering of coordinate details 
seems pretty difficult compared to using/making SVGs.

2. At the top of the http://mapserver.org/mapfile/style.html#style page there 
is the sentence "The final intent is to have named styles (Not yet supported) 
that will be re-usable through the mapfile." I presume this means there was a 
plan to use STYLES similar to a SYMBOLSET? Are there still any plans to do this?

3. I was looking to create circle symbols of different sizes based on an 
attribute, using one of the datasets from Natural Earth. The cities with large 
populations has a smaller "RANK_MAX" - so the size needs to be inverse to an 
attribute. There does not appear to be any easy way to do this without 
modifying the data.  You can set the size using an attribute e.g. "SIZE 
[MYHEIGHT]" but is there a good reason why a MapServer expression couldn't be 
used here? I can add as a feature request to GitHub if it could be a nice 
addition.

A final question - should I post these emails to the dev or users MapServers 
lists?

Regards,

Seth
--
web: http://geographika.co.uk
twitter: @geographika
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] A problem with the Run-time substitution

2016-11-07 Thread Rahkonen Jukka (MML)

Hi,

Your SQL was missing the parenthesis, which I suppose to be mandatory with IN
http://www.1keydata.com/sql/sqlin.html

-Jukka Rahkonen-


-Alkuperäinen viesti-
Lähettäjä: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
Puolesta Burgholzer, Robert (DEQ)
Lähetetty: 7. marraskuuta 2016 16:18
Vastaanottaja: mapserver-users@lists.osgeo.org
Aihe: Re: [mapserver-users] A problem with the Run-time substitution

By includiong the single quotes in the PROCESING directive, doesn't that make 
your input evaluated as a string?  You example suggests that mapserver 
considers single quotes around the input to be bad and rejects it - but by 
putting single quotes in PROCESSING it should avoid that.

What does the expression look like when you tried to syntax I suggested?

-Original Message-
From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On 
Behalf Of Janne Tuovinen
Sent: Monday, November 07, 2016 9:08 AM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] A problem with the Run-time substitution

Thank you, but this doesn't work for me. The problem is that I want to pass a 
string value to my database, but the MapServer doesn't allow that and always 
passes the parameters value as an integer.

-Janne


11/7/2016, 3:33 PM, Burgholzer, Robert (DEQ) wrote:
> I believe that what you want is this:
>
>   PROCESSING "NATIVE_FILTER=param in '%param%' "
>
> I have not used the processing directive, so can not be sure, but the above 
> syntax would work in a QUERY.
>
>
> -Original Message-
> From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
> On Behalf Of Janne Tuovinen
> Sent: Monday, November 07, 2016 7:36 AM
> To: mapserver-users@lists.osgeo.org
> Subject: [mapserver-users] A problem with the Run-time substitution
>
> Hi,
>
> I have a problem when I'm trying to pass a url-parameter to Postgis query's 
> NATIVE_FILTER in my map file.
>
> My layer looks something like this:
>
>   LAYER
>  ...
>   VALIDATION
>   'param' '.+'
>   END
>   ...
>   DATA "shape from table"
>   PROCESSING "NATIVE_FILTER=param in %param%"
>
>END # LAYER
>
> Here is some examples what I get when I try to pass some values: 
>
> ...=1000   = > (param in (1000))
> ...='1000' = > (param in (%param%))
>
> What I like to have is: (param in ('1000'))
>
> Is there a way to this with the MapServer 7.0?
>
> Thank you,
> Janne
>
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] A problem with the Run-time substitution

2016-11-07 Thread Burgholzer, Robert (DEQ)

By includiong the single quotes in the PROCESING directive, doesn't that make 
your input evaluated as a string?  You example suggests that mapserver 
considers single quotes around the input to be bad and rejects it - but by 
putting single quotes in PROCESSING it should avoid that.

What does the expression look like when you tried to syntax I suggested?

-Original Message-
From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On 
Behalf Of Janne Tuovinen
Sent: Monday, November 07, 2016 9:08 AM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] A problem with the Run-time substitution

Thank you, but this doesn't work for me. The problem is that I want to pass a 
string value to my database, but the MapServer doesn't allow that and always 
passes the parameters value as an integer.

-Janne


11/7/2016, 3:33 PM, Burgholzer, Robert (DEQ) wrote:
> I believe that what you want is this:
>
>   PROCESSING "NATIVE_FILTER=param in '%param%' "
>
> I have not used the processing directive, so can not be sure, but the above 
> syntax would work in a QUERY.
>
>
> -Original Message-
> From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
> On Behalf Of Janne Tuovinen
> Sent: Monday, November 07, 2016 7:36 AM
> To: mapserver-users@lists.osgeo.org
> Subject: [mapserver-users] A problem with the Run-time substitution
>
> Hi,
>
> I have a problem when I'm trying to pass a url-parameter to Postgis query's 
> NATIVE_FILTER in my map file.
>
> My layer looks something like this:
>
>   LAYER
>  ...
>   VALIDATION
>   'param' '.+'
>   END
>   ...
>   DATA "shape from table"
>   PROCESSING "NATIVE_FILTER=param in %param%"
>
>END # LAYER
>
> Here is some examples what I get when I try to pass some values: 
>
> ...=1000   = > (param in (1000))
> ...='1000' = > (param in (%param%))
>
> What I like to have is: (param in ('1000'))
>
> Is there a way to this with the MapServer 7.0?
>
> Thank you,
> Janne
>
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] A problem with the Run-time substitution

2016-11-07 Thread Janne Tuovinen

Thank you, but this doesn't work for me. The problem is that I want to
pass a string value to my database, but the MapServer doesn't allow that
and always passes the parameters value as an integer.

-Janne


11/7/2016, 3:33 PM, Burgholzer, Robert (DEQ) wrote:
> I believe that what you want is this:
>
>   PROCESSING "NATIVE_FILTER=param in '%param%' "
>
> I have not used the processing directive, so can not be sure, but the above 
> syntax would work in a QUERY.
>
>
> -Original Message-
> From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On 
> Behalf Of Janne Tuovinen
> Sent: Monday, November 07, 2016 7:36 AM
> To: mapserver-users@lists.osgeo.org
> Subject: [mapserver-users] A problem with the Run-time substitution
>
> Hi,
>
> I have a problem when I'm trying to pass a url-parameter to Postgis query's 
> NATIVE_FILTER in my map file.
>
> My layer looks something like this:
>
>   LAYER
>  ...
>   VALIDATION
>   'param' '.+'
>   END
>   ...
>   DATA "shape from table"
>   PROCESSING "NATIVE_FILTER=param in %param%"
>
>END # LAYER
>
> Here is some examples what I get when I try to pass some values: 
>
> ...=1000   = > (param in (1000))
> ...='1000' = > (param in (%param%))
>
> What I like to have is: (param in ('1000'))
>
> Is there a way to this with the MapServer 7.0?
>
> Thank you,
> Janne
>
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] A problem with the Run-time substitution

2016-11-07 Thread Rahkonen Jukka (MML)

Hi,

It should work like this, if it doesn't then we probably have a bug

PROCESSING "NATIVE_FILTER=ct in ('%param%')"

See also 
http://gis.stackexchange.com/questions/214899/in-operator-in-filter-in-my-mapfile/214921#214921

-Jukka Rahkonen-


Janne Tuovinen wrote:
Re: [mapserver-users] A problem with the Run-time substitution

> Thank you, but this doesn't work for me. The problem is that I want to pass a 
> string value to my database, > but the MapServer doesn't allow that and 
> always passes the parameters value as an integer.

> -Janne


11/7/2016, 3:33 PM, Burgholzer, Robert (DEQ) wrote:
> I believe that what you want is this:
>
>   PROCESSING "NATIVE_FILTER=param in '%param%' "
>
> I have not used the processing directive, so can not be sure, but the above 
> syntax would work in a QUERY.
>
>
> -Original Message-
> From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
> On Behalf Of Janne Tuovinen
> Sent: Monday, November 07, 2016 7:36 AM
> To: mapserver-users@lists.osgeo.org
> Subject: [mapserver-users] A problem with the Run-time substitution
>
> Hi,
>
> I have a problem when I'm trying to pass a url-parameter to Postgis query's 
> NATIVE_FILTER in my map file.
>
> My layer looks something like this:
>
>   LAYER
>  ...
>   VALIDATION
>   'param' '.+'
>   END
>   ...
>   DATA "shape from table"
>   PROCESSING "NATIVE_FILTER=param in %param%"
>
>END # LAYER
>
> Here is some examples what I get when I try to pass some values: 
>
> ...=1000   = > (param in (1000))
> ...='1000' = > (param in (%param%))
>
> What I like to have is: (param in ('1000'))
>
> Is there a way to this with the MapServer 7.0?
>
> Thank you,
> Janne
>
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] arcgis 10.3 enterprise geodatabase

2016-11-07 Thread Fawcett, David (MNIT)

When you create your ‘feature class’ / table in the database using ESRI tools, 
you use the config option PG_GEOMETRY.  This uses PostGIS’s geometry type 
instead of ESRI’s.

With this setup, you can read and edit the data with ESRI products, and you can 
also access the features with straight PostGIS queries.  You can then just 
create a Mapserver layer with connectiontype of POSTGIS and point it at your 
database table.  http://www.mapserver.org/input/vector/postgis.html

From: Oscar ^_^ [mailto:oscar...@gmail.com]
Sent: Friday, November 04, 2016 8:18 AM
To: Fawcett, David (MNIT) 
Cc: Michael Smith ; Lime, Steve D (MNIT) 
; mapserver-users@lists.osgeo.org; Wingfield, Nathaniel 
D 
Subject: RE: [mapserver-users] arcgis 10.3 enterprise geodatabase


How can I Store enterprice data as pg_geometry and manage versión a in 
Mapserver?

El nov 3, 2016 2:10 PM, "Fawcett, David (MNIT)" 
> escribió:
We do the same thing, but on PostGIS with pg_geometry.

From: mapserver-users 
[mailto:mapserver-users-boun...@lists.osgeo.org]
 On Behalf Of Michael Smith
Sent: Thursday, November 03, 2016 3:08 PM
To: Lime, Steve D (MNIT) 
>; Oscar ^_^ 
>; Wingfield, Nathaniel D 
>
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] arcgis 10.3 enterprise geodatabase

The other option, which is what we use, is to store ArcGIS 10.3 enterprise data 
as SDO_GEOMETRY native. We find no performance penalties in ArcGIS and 
performance benefits for non-esri software, such as mapserver.

Mike

--
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

From: mapserver-users 
>
 on behalf of "Lime, Steve D (MNIT)" 
>
Date: Thursday, November 3, 2016 at 4:02 PM
To: Oscar ^_^ >, "Wingfield, 
Nathaniel D" >
Cc: "mapserver-users@lists.osgeo.org" 
>
Subject: Re: [mapserver-users] arcgis 10.3 enterprise geodatabase

If GDAL/OGR can handle the format then you’re in luck. I’d check there first…

From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On 
Behalf Of Oscar ^_^
Sent: Thursday, November 03, 2016 2:51 PM
To: Wingfield, Nathaniel D >
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] arcgis 10.3 enterprise geodatabase

I've got the same requeriment althought i can use 10.1 or 10.2 but i don't know 
how to implement these to Mapserver

Any suggestion o guide ??

2016-11-01 7:39 GMT-06:00 Wingfield, Nathaniel D 
>:
Can MapServer consume spatial data from an ArcGIS 10.3 enterprise geodatabase? 
We are using the default SDE.ST_GEOMETRY type, on Oracle. The MapServer docs 
indicate that any support for ESRI enterprise geodatabases is based on ArcSDE, 
which was abandoned by ESRI at version 10.3, in favor of direct connect 
(https://blogs.esri.com/esri/supportcenter/2015/02/11/where-is-the-install-for-arcsde-10-3/).

We will likely use OpenLayers for a new web-based mapping app, so MapServer 
seems like a natural choice (otherwise we will have to use ArcGIS Server).
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



--
OSCAR
 @
^_^
 Y
___ mapserver-users mailing list 
mapserver-users@lists.osgeo.org 
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] A problem with the Run-time substitution

2016-11-07 Thread Burgholzer, Robert (DEQ)

I believe that what you want is this:

  PROCESSING "NATIVE_FILTER=param in '%param%' "

I have not used the processing directive, so can not be sure, but the above 
syntax would work in a QUERY.


-Original Message-
From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On 
Behalf Of Janne Tuovinen
Sent: Monday, November 07, 2016 7:36 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] A problem with the Run-time substitution

Hi,

I have a problem when I'm trying to pass a url-parameter to Postgis query's 
NATIVE_FILTER in my map file.

My layer looks something like this:

  LAYER
 ...
  VALIDATION
  'param' '.+'
  END
  ...
  DATA "shape from table"
  PROCESSING "NATIVE_FILTER=param in %param%"

   END # LAYER

Here is some examples what I get when I try to pass some values: 

...=1000   = > (param in (1000))
...='1000' = > (param in (%param%))

What I like to have is: (param in ('1000'))

Is there a way to this with the MapServer 7.0?

Thank you,
Janne

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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

2016-11-07 Thread 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=22"

 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 10

  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

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

2016-11-07 Thread 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=22"
> 
>  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 10
>   
>   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
> 


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

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

2016-11-07 Thread 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=22"

 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 10

  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

[mapserver-users] confused on styling polygon

Re: [mapserver-users] [mapserver-dev] MapServer tutorial - symbology

Re: [mapserver-users] A problem with the Run-time substitution

Re: [mapserver-users] A problem with the Run-time substitution

Re: [mapserver-users] A problem with the Run-time substitution

Re: [mapserver-users] A problem with the Run-time substitution

Re: [mapserver-users] arcgis 10.3 enterprise geodatabase

Re: [mapserver-users] A problem with the Run-time substitution

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

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

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

11 matches

Site Navigation

Mail list logo

Footer information