[mapserver-users] some questions regarding getFeatureInfo, SLD, PostGIS

[Julien Cigar]

On 09/21/2012 13:24, Smith, Michael ERDC-RDE-CRREL-NH wrote:
> At the SQL level, you can do some fancy work with CASE and setting some
> default values
>
> The CASE function allows you to set all kind of logical comparisons. You
> can do conditional joins that way, setting the join condition to a non
> matching value when you don't want the join, etc. SQL is more powerful
> than any template language.
>
> Mike

ok I was wrong, you meant JOIN foo ON (CASE ... ) I guess .. ?

>
>
> On 9/21/12 7:07 AM, "Julien Cigar"<jcigar at ulb.ac.be>  wrote:
>
>> On 09/21/2012 12:50, Rahkonen Jukka wrote:
>>> Hi,
>> Hello,
>>
>>> So you have tried to define variables %SEX% and %BOD_ID%, used them
>>> inside your DATA and then fired  WMS GetMaps by
>>> adding&SEX=your_value&BOD_ID=your_id? Does in not work or why it is not
>>> powerful enough?
>> It is not powerful enough because it doesn't allow you to make simple
>> logical tests (if defined/equals/...), the run-time substitution is a
>> simple "replace %FOO%" by the value of FOO= from the query string.
>>
>> It doesn't allow you to do something like: "if FOO is defined or equal
>> to xxx, then add "JOIN foo f ON f.id = bar.foo_id", select additional
>> columns, and add a "WHERE foo.id = ..." at a certain place in the DATA
>> string".
>>
>> I guess mapscript should be used in this case, but it would be really
>> interesting to have this simple template language (or another solution)
>> without having to involve mapscript.
>>
>> Julien
>>
>>> -Jukka Rahkonen-
>>>
>>>
>>> Julien Cigar wrote:
>>>
>>>> Hello,
>>>>
>>>> I'm using Mapserver 6.0.1 with the following PostGIS layer:
>>>> http://pastie.org/private/84042k84vmljbontls5xvq
>>>>
>>>> The user has the possibility to select quite a lot of filters, which
>>>> implies that
>>>> the SQL query should, in theory ,be generated dynamically.
>>>> As this is not possible with Mapserver (run-time substitution with HTTP
>>>> parameters and VALIDATION ... END isn't powerful enough is my case),
>>>> I'm
>>>> dynamically generating an SLD
>>>> (http://pastie.org/private/p66ml3uvqwcnphuuvera) to filter items and it
>>>> works very well.
>>>>
>>>> Some questions:
>>>>
>>>> - Why does Mapserver doesn't have a very lightweight template language
>>>> (or
>>>> something similar) to dynamically build a string following given
>>>> parameters? It
>>>> could be really useful to avoid unnecessary JOIN, etc.
>>>> For example something like:
>>>> http://pastie.org/private/bojm3pi1dwrv18m2tvq (this is just an
>>>> example, but
>>>> the idea is there)
>>>>
>>>> - I noticed in the PostgreSQL logs that sometimes Mapserver adds an
>>>> additional condition to the WHERE clause when SLD is used. For example
>>>> with
>>>> the following<ogc:Filter>   in my SLD:
>>>> #########################################
>>>> <ogc:Filter>
>>>> <ogc:PropertyIsEqualTo>
>>>> <ogc:PropertyName>basis_of_record_id</ogc:PropertyName>
>>>> <ogc:Literal>1</ogc:Literal>
>>>> </ogc:PropertyIsEqualTo>
>>>> </ogc:Filter>
>>>> #########################################
>>>>
>>>> Mapserver adds an additional "and (( ("basis_of_record_id"= 1) ))":
>>>>
>>>> (...) AS q where geom&&   GeomFromText('POLYGON((-3.6860351557368
>>>> -9.81732918571448,-3.6860351557368 9.81732918571447,47.6860351496117
>>>> 9.81732918571447,47.6860351496117 -9.81732918571448,-3.6860351557368
>>>> -9.81732918571448))',4326) and (( ("basis_of_record_id"= 1) ))
>>>>
>>>> which is not bad as less rows have to be post-processed by the SLD
>>>> engine.
>>>>
>>>> However, as soon as I add an additional<ogc:or>   (or<ogc:and>) as:
>>>> #########################################
>>>> <ogc:or>
>>>> <ogc:PropertyIsEqualTo>
>>>> <ogc:PropertyName>basis_of_record_id</ogc:PropertyName>
>>>> <ogc:Literal>1</ogc:Literal>
>>>> </ogc:PropertyIsEqualTo>
>>>> <ogc:PropertyIsEqualTo>
>>>> <ogc:PropertyName>basis_of_record_id</ogc:PropertyName>
>>>> <ogc:Literal>2</ogc:Literal>
>>>> </ogc:PropertyIsEqualTo>
>>>> </ogc:or>
>>>> #########################################
>>>>
>>>> Mapserver doesn't add this additional AND/OR clause (and ((
>>>> ("basis_of_record_id"= 1) OR ("basis_of_record_id" = 2) )) in this
>>>> case).. Why
>>>> ?
>>>>
>>>> - Is it normal that my SLD is totally ignored when I'm using
>>>> REQUEST=GetFeatureInfo? Is the SLD only processed with
>>>> REQUEST=GetMap?
>>>> If this is the case, what's the typical alternative way of doing it?
>>>> Should I go through WFS .. ?
>>>>
>>>> In advance, thank you for your answers :) Julien
>>>>
>>>> --
>>>> No trees were killed in the creation of this message.
>>>> However, many electrons were terribly inconvenienced.
>>> _______________________________________________
>>> mapserver-users mailing list
>>> mapserver-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>
>> -- 
>> No trees were killed in the creation of this message.
>> However, many electrons were terribly inconvenienced.
>>


-- 
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: jcigar.vcf
Type: text/x-vcard
Size: 292 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120921/c7fe2f7e/attachment.vcf>