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) >=20000 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 <erwan.boc...@univ-ubs.fr
<mailto:erwan.boc...@univ-ubs.fr>> 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
<erwan.boc...@univ-ubs.fr <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
<mailto: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
<mailto: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
<mailto: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./
--
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
--
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./
--
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
