date:20201104

Re: [Geotools-gt2-users] Geotools POC on next Feature2DStyle model

2020-11-04 Thread Ian Turton

For a quick fix you can change that to use perimeter(the_geom)>1000 ) =
true and the existing code should work.

Ian

On Wed, 4 Nov 2020 at 16:16, Erwan Bocher  wrote:

> Hi,
> Le 04/11/2020 à 16:51, Andrea Aime a écrit :
>
> Hi,
> yes that looks promising. I don't see the registration of the function in
> META-INF, but I guess that's handled
> in a different commit
>
> here
> https://github.com/ebocher/geotools/blob/addFunctions/modules/library/main/src/main/resources/META-INF/services/org.opengis.filter.expression.Function#L204
>
> Current and , or operators work with left, right operands. I' m facing
> with a new issue if the user wants to do
>
> (type='parcels' and area(the_geom) >=2 or perimeter(the_geom)>1000 )
> or landuse='grass'
>
> Any idea ?
>
> What about using a list of parameters as input ?
>
> Bests
>
> Erwan
>
>
> Cheers
> Andrea
>
>
> On Wed, Nov 4, 2020 at 4:19 PM Erwan Bocher 
> wrote:
>
>> Hi Andrea,
>>
>> Thanks.
>>
>> Here first implementations :
>> https://github.com/ebocher/geotools/commit/8f5dec5d82967fb91d370bf4408840cbdedf9eca
>>
>> I hope I'm on the right road ;-)
>>
>> Erwan
>> Le 04/11/2020 à 11:49, Andrea Aime a écrit :
>>
>> Hi Erwan,
>> yes, if you want to use expressions, you'll have to replicate every
>> missing bit as a function.
>> As a word of caution, functions are almost always evaluated in memory,
>> unless the particular
>> data store provides direct support for them (the PostGIS datastore has
>> examples for a few string manipulation functions).
>>
>> Cheers
>> Andrea
>>
>> On Wed, Nov 4, 2020 at 10:45 AM Erwan Bocher 
>> wrote:
>>
>>> Hi Jim,
>>>
>>> Logical op works well with Filter but I want to use it to build an
>>> expression.
>>>
>>> @andrea,
>>>
>>> Do we need to add a And function that extends FunctionExpressionImpl ?
>>>
>>> If yes it 'd be the same approach for Or op.
>>>
>>> Best regards
>>>
>>> Erwan
>>>
>>>
>>> Le 02/11/2020 à 19:21, Jim Hughes a écrit :
>>>
>>> Hi Erwan,
>>>
>>> I don't think there's an "and" function.  It can be used between two
>>> conditions[1].
>>>
>>> Cheers,
>>>
>>> Jim
>>>
>>> 1.
>>> https://docs.geoserver.org/stable/en/user/filter/ecql_reference.html#condition
>>> (I end up referring to this page frequently to figure out syntax.)
>>>
>>> 2. I also like this page:
>>> https://docs.geoserver.org/stable/en/user/tutorials/cql/cql_tutorial.html
>>> On 11/2/2020 5:45 AM, Erwan Bocher wrote:
>>>
>>> Based on
>>> https://docs.geotools.org/latest/userguide/library/opengis/filter.html
>>> , I try to use logical op like this
>>>
>>> "if_then_else(and(greaterThan(area(THE_GEOM), 10),equalTo(type, 12)),5, 1)"
>>>
>>> return me
>>>
>>> Exception in thread "main" org.geotools.filter.text.cql2.CQLException: 
>>> Encountered "and" at line 1, column 14.
>>>
>>> Am I doing something wrong?
>>>
>>> Best regards
>>>
>>> Erwan
>>>
>>> Le 02/11/2020 à 10:30, Erwan Bocher a écrit :
>>>
>>>
>>> Le 02/11/2020 à 10:23, Andrea Aime a écrit :
>>>
>>> No, it does not, but you can make it so by modifying FilterToSQL, and
>>> then go around and change
>>> the database filter capabilities (otherwise the filter splitter will
>>> take it out). Well, unless you can ensure
>>> every single database supports CASE WHEN with the same syntax. Which
>>> seems like it may be true
>>> for most, but every time I bet on it, I find a database that does not
>>> follow the SQL standard...):
>>>
>>>
>>> Ok
>>>
>>> I will test this change with the H2GIS-Geotools datastore (
>>> https://github.com/orbisgis/h2gis-geotools) and share my result when it
>>> rocks
>>>
>>> Best regards
>>>
>>>
>>> --
>>> Ingénieur de Recherche CNRS - HDR,
>>> Laboratoire Lab-STICC – UMR 6285
>>> Equipe DECIDE
>>> Institut Universitaire de Technologie de Vannes
>>> 8, Rue Montaigne - BP 561 56017 Vannes Cedex
>>> T: +33 2 97 62 64 92
>>> W: https://cv.archives-ouvertes.fr/erwan-bocher
>>> W: http://www.labsticc.fr
>>>
>>>
>>>
>>> ___
>>> GeoTools-GT2-Users mailing 
>>> listGeoTools-GT2-Users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>>>
>>>
>>>
>>> ___
>>> GeoTools-GT2-Users mailing 
>>> listGeoTools-GT2-Users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>>>
>>> --
>>> Ingénieur de Recherche CNRS - HDR,
>>> Laboratoire Lab-STICC – UMR 6285
>>> Equipe DECIDE
>>> Institut Universitaire de Technologie de Vannes
>>> 8, Rue Montaigne - BP 561 56017 Vannes Cedex
>>> T: +33 2 97 62 64 92
>>> W: https://cv.archives-ouvertes.fr/erwan-bocher
>>> W: http://www.labsticc.fr
>>>
>>> ___
>>> GeoTools-GT2-Users mailing list
>>> GeoTools-GT2-Users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>>>
>>
>>
>> --
>>
>> Regards, Andrea Aime
>>
>> == GeoServer Professional Services from the experts! Visit
>> http://goo.gl/it488V for more information. == Ing.

Re: [Geotools-gt2-users] Geotools POC on next Feature2DStyle model

2020-11-04 Thread Erwan Bocher


Hi,

Le 04/11/2020 à 16:51, Andrea Aime a écrit :

Hi,
yes that looks promising. I don't see the registration of the function 
in META-INF, but I guess that's handled

in a different commit


here 
https://github.com/ebocher/geotools/blob/addFunctions/modules/library/main/src/main/resources/META-INF/services/org.opengis.filter.expression.Function#L204


Current and , or operators work with left, right operands. I' m facing 
with a new issue if the user wants to do


(type='parcels' and area(the_geom) >=2 or perimeter(the_geom)>1000 
)  or landuse='grass'


Any idea ?

What about using a list of parameters as input ?

Bests

Erwan



Cheers
Andrea


On Wed, Nov 4, 2020 at 4:19 PM Erwan Bocher > wrote:


Hi Andrea,

Thanks.

Here first implementations :

https://github.com/ebocher/geotools/commit/8f5dec5d82967fb91d370bf4408840cbdedf9eca

I hope I'm on the right road ;-)

Erwan

Le 04/11/2020 à 11:49, Andrea Aime a écrit :

Hi Erwan,
yes, if you want to use expressions, you'll have to replicate
every missing bit as a function.
As a word of caution, functions are almost always evaluated in
memory, unless the particular
data store provides direct support for them (the PostGIS
datastore has examples for a few string manipulation functions).

Cheers
Andrea

On Wed, Nov 4, 2020 at 10:45 AM Erwan Bocher
mailto:erwan.boc...@univ-ubs.fr>> wrote:

Hi Jim,

Logical op works well with Filter but I want to use it to
build an expression.

@andrea,

Do we need to add a And function that extends
FunctionExpressionImpl ?

If yes it 'd be the same approach for Or op.

Best regards

Erwan


Le 02/11/2020 à 19:21, Jim Hughes a écrit :


Hi Erwan,

I don't think there's an "and" function.  It can be used
between two conditions[1].

Cheers,

Jim

1.

https://docs.geoserver.org/stable/en/user/filter/ecql_reference.html#condition
(I end up referring to this page frequently to figure out
syntax.)

2. I also like this page:

https://docs.geoserver.org/stable/en/user/tutorials/cql/cql_tutorial.html

On 11/2/2020 5:45 AM, Erwan Bocher wrote:


Based on
https://docs.geotools.org/latest/userguide/library/opengis/filter.html
, I try to use logical op like this

"if_then_else(and(greaterThan(area(THE_GEOM),
10),equalTo(type, 12)),5, 1)"

return me

Exception in thread "main" org.geotools.filter.text.cql2.CQLException: 
Encountered "and" at line 1, column 14.

Am I doing something wrong?

Best regards

Erwan
Le 02/11/2020 à 10:30, Erwan Bocher a écrit :


Le 02/11/2020 à 10:23, Andrea Aime a écrit :

No, it does not, but you can make it so by modifying
FilterToSQL, and then go around and change
the database filter capabilities (otherwise the filter
splitter will take it out). Well, unless you can ensure
every single database supports CASE WHEN with the same
syntax. Which seems like it may be true
for most, but every time I bet on it, I find a database
that does not follow the SQL standard...):


Ok

I will test this change with the H2GIS-Geotools datastore
(https://github.com/orbisgis/h2gis-geotools) and share my
result when it rocks

Best regards


-- 
Ingénieur de Recherche CNRS - HDR,

Laboratoire Lab-STICC – UMR 6285
Equipe DECIDE
Institut Universitaire de Technologie de Vannes
8, Rue Montaigne - BP 561 56017 Vannes Cedex
T: +33 2 97 62 64 92
W:https://cv.archives-ouvertes.fr/erwan-bocher
W:http://www.labsticc.fr


___
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net  

https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users



___
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net  

https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users


-- 
Ingénieur de Recherche CNRS - HDR,

Laboratoire Lab-STICC – UMR 6285
Equipe DECIDE
Institut Universitaire de Technologie de Vannes
8, Rue Montaigne - BP 561 56017 Vannes Cedex
T: +33 2 97 62 64 92
W:https://cv.archives-ouvertes.fr/erwan-bocher
W:http://www.labsticc.fr

___
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net

Re: [Geotools-gt2-users] Geotools POC on next Feature2DStyle model

2020-11-04 Thread Andrea Aime

Hi,
yes that looks promising. I don't see the registration of the function in
META-INF, but I guess that's handled
in a different commit

Cheers
Andrea


On Wed, Nov 4, 2020 at 4:19 PM Erwan Bocher 
wrote:

> Hi Andrea,
>
> Thanks.
>
> Here first implementations :
> https://github.com/ebocher/geotools/commit/8f5dec5d82967fb91d370bf4408840cbdedf9eca
>
> I hope I'm on the right road ;-)
>
> Erwan
> Le 04/11/2020 à 11:49, Andrea Aime a écrit :
>
> Hi Erwan,
> yes, if you want to use expressions, you'll have to replicate every
> missing bit as a function.
> As a word of caution, functions are almost always evaluated in memory,
> unless the particular
> data store provides direct support for them (the PostGIS datastore has
> examples for a few string manipulation functions).
>
> Cheers
> Andrea
>
> On Wed, Nov 4, 2020 at 10:45 AM Erwan Bocher 
> wrote:
>
>> Hi Jim,
>>
>> Logical op works well with Filter but I want to use it to build an
>> expression.
>>
>> @andrea,
>>
>> Do we need to add a And function that extends FunctionExpressionImpl ?
>>
>> If yes it 'd be the same approach for Or op.
>>
>> Best regards
>>
>> Erwan
>>
>>
>> Le 02/11/2020 à 19:21, Jim Hughes a écrit :
>>
>> Hi Erwan,
>>
>> I don't think there's an "and" function.  It can be used between two
>> conditions[1].
>>
>> Cheers,
>>
>> Jim
>>
>> 1.
>> https://docs.geoserver.org/stable/en/user/filter/ecql_reference.html#condition
>> (I end up referring to this page frequently to figure out syntax.)
>>
>> 2. I also like this page:
>> https://docs.geoserver.org/stable/en/user/tutorials/cql/cql_tutorial.html
>> On 11/2/2020 5:45 AM, Erwan Bocher wrote:
>>
>> Based on
>> https://docs.geotools.org/latest/userguide/library/opengis/filter.html ,
>> I try to use logical op like this
>>
>> "if_then_else(and(greaterThan(area(THE_GEOM), 10),equalTo(type, 12)),5, 1)"
>>
>> return me
>>
>> Exception in thread "main" org.geotools.filter.text.cql2.CQLException: 
>> Encountered "and" at line 1, column 14.
>>
>> Am I doing something wrong?
>>
>> Best regards
>>
>> Erwan
>>
>> Le 02/11/2020 à 10:30, Erwan Bocher a écrit :
>>
>>
>> Le 02/11/2020 à 10:23, Andrea Aime a écrit :
>>
>> No, it does not, but you can make it so by modifying FilterToSQL, and
>> then go around and change
>> the database filter capabilities (otherwise the filter splitter will take
>> it out). Well, unless you can ensure
>> every single database supports CASE WHEN with the same syntax. Which
>> seems like it may be true
>> for most, but every time I bet on it, I find a database that does not
>> follow the SQL standard...):
>>
>>
>> Ok
>>
>> I will test this change with the H2GIS-Geotools datastore (
>> https://github.com/orbisgis/h2gis-geotools) and share my result when it
>> rocks
>>
>> Best regards
>>
>>
>> --
>> Ingénieur de Recherche CNRS - HDR,
>> Laboratoire Lab-STICC – UMR 6285
>> Equipe DECIDE
>> Institut Universitaire de Technologie de Vannes
>> 8, Rue Montaigne - BP 561 56017 Vannes Cedex
>> T: +33 2 97 62 64 92
>> W: https://cv.archives-ouvertes.fr/erwan-bocher
>> W: http://www.labsticc.fr
>>
>>
>>
>> ___
>> GeoTools-GT2-Users mailing 
>> listGeoTools-GT2-Users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>>
>>
>>
>> ___
>> GeoTools-GT2-Users mailing 
>> listGeoTools-GT2-Users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>>
>> --
>> Ingénieur de Recherche CNRS - HDR,
>> Laboratoire Lab-STICC – UMR 6285
>> Equipe DECIDE
>> Institut Universitaire de Technologie de Vannes
>> 8, Rue Montaigne - BP 561 56017 Vannes Cedex
>> T: +33 2 97 62 64 92
>> W: https://cv.archives-ouvertes.fr/erwan-bocher
>> W: http://www.labsticc.fr
>>
>> ___
>> GeoTools-GT2-Users mailing list
>> GeoTools-GT2-Users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>>
>
>
> --
>
> Regards, Andrea Aime
>
> == GeoServer Professional Services from the experts! Visit
> http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf
> Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa
> (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549
> http://www.geo-solutions.it http://twitter.com/geosolutions_it
> --- *Con riferimento
> alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 -
> Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni
> circostanza inerente alla presente email (il suo contenuto, gli eventuali
> allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i
> destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per
> errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le
> sarei comunque grato se potesse darmene notizia. This email is intended
> only for the person or entity to which

Re: [Geotools-gt2-users] Geotools POC on next Feature2DStyle model

2020-11-04 Thread Erwan Bocher


Hi Andrea,

Thanks.

Here first implementations : 
https://github.com/ebocher/geotools/commit/8f5dec5d82967fb91d370bf4408840cbdedf9eca


I hope I'm on the right road ;-)

Erwan

Le 04/11/2020 à 11:49, Andrea Aime a écrit :

Hi Erwan,
yes, if you want to use expressions, you'll have to replicate every 
missing bit as a function.
As a word of caution, functions are almost always evaluated in memory, 
unless the particular
data store provides direct support for them (the PostGIS datastore has 
examples for a few string manipulation functions).


Cheers
Andrea

On Wed, Nov 4, 2020 at 10:45 AM Erwan Bocher > wrote:


Hi Jim,

Logical op works well with Filter but I want to use it to build an
expression.

@andrea,

Do we need to add a And function that extends FunctionExpressionImpl ?

If yes it 'd be the same approach for Or op.

Best regards

Erwan


Le 02/11/2020 à 19:21, Jim Hughes a écrit :


Hi Erwan,

I don't think there's an "and" function.  It can be used between
two conditions[1].

Cheers,

Jim

1.

https://docs.geoserver.org/stable/en/user/filter/ecql_reference.html#condition
(I end up referring to this page frequently to figure out syntax.)

2. I also like this page:
https://docs.geoserver.org/stable/en/user/tutorials/cql/cql_tutorial.html

On 11/2/2020 5:45 AM, Erwan Bocher wrote:


Based on
https://docs.geotools.org/latest/userguide/library/opengis/filter.html
, I try to use logical op like this

"if_then_else(and(greaterThan(area(THE_GEOM), 10),equalTo(type,
12)),5, 1)"

return me

Exception in thread "main" org.geotools.filter.text.cql2.CQLException: Encountered 
"and" at line 1, column 14.

Am I doing something wrong?

Best regards

Erwan
Le 02/11/2020 à 10:30, Erwan Bocher a écrit :


Le 02/11/2020 à 10:23, Andrea Aime a écrit :

No, it does not, but you can make it so by modifying
FilterToSQL, and then go around and change
the database filter capabilities (otherwise the filter
splitter will take it out). Well, unless you can ensure
every single database supports CASE WHEN with the same syntax.
Which seems like it may be true
for most, but every time I bet on it, I find a database that
does not follow the SQL standard...):


Ok

I will test this change with the H2GIS-Geotools datastore
(https://github.com/orbisgis/h2gis-geotools) and share my
result when it rocks

Best regards


-- 
Ingénieur de Recherche CNRS - HDR,

Laboratoire Lab-STICC – UMR 6285
Equipe DECIDE
Institut Universitaire de Technologie de Vannes
8, Rue Montaigne - BP 561 56017 Vannes Cedex
T: +33 2 97 62 64 92
W:https://cv.archives-ouvertes.fr/erwan-bocher
W:http://www.labsticc.fr


___
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net  

https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users



___
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net  

https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users


-- 
Ingénieur de Recherche CNRS - HDR,

Laboratoire Lab-STICC – UMR 6285
Equipe DECIDE
Institut Universitaire de Technologie de Vannes
8, Rue Montaigne - BP 561 56017 Vannes Cedex
T: +33 2 97 62 64 92
W:https://cv.archives-ouvertes.fr/erwan-bocher
W:http://www.labsticc.fr

___
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net

https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users



--

Regards, Andrea Aime

== GeoServer Professional Services from the experts! Visit 
http://goo.gl/it488V for more information. == Ing. Andrea Aime 
@geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 
55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: 
+39 339 8844549 http://www.geo-solutions.it 
http://twitter.com/geosolutions_it 
--- /Con 
riferimento alla normativa sul trattamento dei dati personali (Reg. UE 
2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si 
precisa che ogni circostanza inerente alla presente email (il suo 
contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è 
riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il 
messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra 
operazione è illecita. Le sarei comunque grato se potesse darmene 
notizia. This email is intended only for the person or entity to which 
it is addressed and may contain information that is privileged,

Re: [Geotools-gt2-users] Geotools POC on next Feature2DStyle model

2020-11-04 Thread Andrea Aime

Hi Erwan,
yes, if you want to use expressions, you'll have to replicate every missing
bit as a function.
As a word of caution, functions are almost always evaluated in memory,
unless the particular
data store provides direct support for them (the PostGIS datastore has
examples for a few string manipulation functions).

Cheers
Andrea

On Wed, Nov 4, 2020 at 10:45 AM Erwan Bocher 
wrote:

> Hi Jim,
>
> Logical op works well with Filter but I want to use it to build an
> expression.
>
> @andrea,
>
> Do we need to add a And function that extends FunctionExpressionImpl ?
>
> If yes it 'd be the same approach for Or op.
>
> Best regards
>
> Erwan
>
>
> Le 02/11/2020 à 19:21, Jim Hughes a écrit :
>
> Hi Erwan,
>
> I don't think there's an "and" function.  It can be used between two
> conditions[1].
>
> Cheers,
>
> Jim
>
> 1.
> https://docs.geoserver.org/stable/en/user/filter/ecql_reference.html#condition
> (I end up referring to this page frequently to figure out syntax.)
>
> 2. I also like this page:
> https://docs.geoserver.org/stable/en/user/tutorials/cql/cql_tutorial.html
> On 11/2/2020 5:45 AM, Erwan Bocher wrote:
>
> Based on
> https://docs.geotools.org/latest/userguide/library/opengis/filter.html ,
> I try to use logical op like this
>
> "if_then_else(and(greaterThan(area(THE_GEOM), 10),equalTo(type, 12)),5, 1)"
>
> return me
>
> Exception in thread "main" org.geotools.filter.text.cql2.CQLException: 
> Encountered "and" at line 1, column 14.
>
> Am I doing something wrong?
>
> Best regards
>
> Erwan
>
> Le 02/11/2020 à 10:30, Erwan Bocher a écrit :
>
>
> Le 02/11/2020 à 10:23, Andrea Aime a écrit :
>
> No, it does not, but you can make it so by modifying FilterToSQL, and then
> go around and change
> the database filter capabilities (otherwise the filter splitter will take
> it out). Well, unless you can ensure
> every single database supports CASE WHEN with the same syntax. Which seems
> like it may be true
> for most, but every time I bet on it, I find a database that does not
> follow the SQL standard...):
>
>
> Ok
>
> I will test this change with the H2GIS-Geotools datastore (
> https://github.com/orbisgis/h2gis-geotools) and share my result when it
> rocks
>
> Best regards
>
>
> --
> Ingénieur de Recherche CNRS - HDR,
> Laboratoire Lab-STICC – UMR 6285
> Equipe DECIDE
> Institut Universitaire de Technologie de Vannes
> 8, Rue Montaigne - BP 561 56017 Vannes Cedex
> T: +33 2 97 62 64 92
> W: https://cv.archives-ouvertes.fr/erwan-bocher
> W: http://www.labsticc.fr
>
>
>
> ___
> GeoTools-GT2-Users mailing 
> listGeoTools-GT2-Users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>
>
>
> ___
> GeoTools-GT2-Users mailing 
> listGeoTools-GT2-Users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>
> --
> Ingénieur de Recherche CNRS - HDR,
> Laboratoire Lab-STICC – UMR 6285
> Equipe DECIDE
> Institut Universitaire de Technologie de Vannes
> 8, Rue Montaigne - BP 561 56017 Vannes Cedex
> T: +33 2 97 62 64 92
> W: https://cv.archives-ouvertes.fr/erwan-bocher
> W: http://www.labsticc.fr
>
> ___
> GeoTools-GT2-Users mailing list
> GeoTools-GT2-Users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>


-- 

Regards, Andrea Aime

== GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf
Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa
(LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549
http://www.geo-solutions.it http://twitter.com/geosolutions_it
--- *Con riferimento
alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 -
Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni
circostanza inerente alla presente email (il suo contenuto, gli eventuali
allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i
destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per
errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le
sarei comunque grato se potesse darmene notizia. This email is intended
only for the person or entity to which it is addressed and may contain
information that is privileged, confidential or otherwise protected from
disclosure. We remind that - as provided by European Regulation 2016/679
“GDPR” - copying, dissemination or use of this e-mail or the information
herein by anyone other than the intended recipient is prohibited. If you
have received this email by mistake, please notify us immediately by
telephone or e-mail.*
___
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

Re: [Geotools-gt2-users] Geotools POC on next Feature2DStyle model

2020-11-04 Thread Erwan Bocher


Hi Jim,

Logical op works well with Filter but I want to use it to build an 
expression.


@andrea,

Do we need to add a And function that extends FunctionExpressionImpl ?

If yes it 'd be the same approach for Or op.

Best regards

Erwan


Le 02/11/2020 à 19:21, Jim Hughes a écrit :


Hi Erwan,

I don't think there's an "and" function.  It can be used between two 
conditions[1].


Cheers,

Jim

1. 
https://docs.geoserver.org/stable/en/user/filter/ecql_reference.html#condition 
(I end up referring to this page frequently to figure out syntax.)


2. I also like this page: 
https://docs.geoserver.org/stable/en/user/tutorials/cql/cql_tutorial.html


On 11/2/2020 5:45 AM, Erwan Bocher wrote:


Based on 
https://docs.geotools.org/latest/userguide/library/opengis/filter.html 
, I try to use logical op like this


"if_then_else(and(greaterThan(area(THE_GEOM), 10),equalTo(type, 
12)),5, 1)"


return me

Exception in thread "main" org.geotools.filter.text.cql2.CQLException: Encountered 
"and" at line 1, column 14.

Am I doing something wrong?

Best regards

Erwan
Le 02/11/2020 à 10:30, Erwan Bocher a écrit :


Le 02/11/2020 à 10:23, Andrea Aime a écrit :
No, it does not, but you can make it so by modifying FilterToSQL, 
and then go around and change
the database filter capabilities (otherwise the filter splitter 
will take it out). Well, unless you can ensure
every single database supports CASE WHEN with the same syntax. 
Which seems like it may be true
for most, but every time I bet on it, I find a database that does 
not follow the SQL standard...):


Ok

I will test this change with the H2GIS-Geotools datastore 
(https://github.com/orbisgis/h2gis-geotools) and share my result 
when it rocks


Best regards



--
Ingénieur de Recherche CNRS - HDR,
Laboratoire Lab-STICC – UMR 6285
Equipe DECIDE
Institut Universitaire de Technologie de Vannes
8, Rue Montaigne - BP 561 56017 Vannes Cedex
T: +33 2 97 62 64 92
W:https://cv.archives-ouvertes.fr/erwan-bocher
W:http://www.labsticc.fr


___
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users



___
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users


--
Ingénieur de Recherche CNRS - HDR,
Laboratoire Lab-STICC – UMR 6285
Equipe DECIDE
Institut Universitaire de Technologie de Vannes
8, Rue Montaigne - BP 561 56017 Vannes Cedex
T: +33 2 97 62 64 92
W: https://cv.archives-ouvertes.fr/erwan-bocher
W: http://www.labsticc.fr

___
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

Re: [Geotools-gt2-users] Geotools POC on next Feature2DStyle model

Re: [Geotools-gt2-users] Geotools POC on next Feature2DStyle model

Re: [Geotools-gt2-users] Geotools POC on next Feature2DStyle model

Re: [Geotools-gt2-users] Geotools POC on next Feature2DStyle model

Re: [Geotools-gt2-users] Geotools POC on next Feature2DStyle model

Re: [Geotools-gt2-users] Geotools POC on next Feature2DStyle model

6 matches

Site Navigation

Mail list logo

Footer information