Hi Ian,
Thanks but I'd prefer to parse the right syntax.
@andrea
I sent a PR.
Best regards
Erwan
Le 04/11/2020 à 18:13, Ian Turton a écrit :
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 <erwan.boc...@univ-ubs.fr
<mailto:erwan.boc...@univ-ubs.fr>> 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) >=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
<mailto:GeoTools-GT2-Users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
--
Ian Turton
--
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
