Re: [Geotools-gt2-users] Alias on filter function

Erwan Bocher Tue, 22 Dec 2020 08:41:48 -0800

Jody,

I know that but I want to use the SFS function names in ECQL.

If I understand well the way to do that is to extend the currentgeotools function and filter on my side and register them ?


Erwan

Le 22/12/2020 à 08:47, Jody Garnett a écrit :

Erwan:

It depends a bit on each database, you will find that many of themimplement the SFSQL specification.

Here is one for PostGIS:https://github.com/geotools/geotools/blob/master/modules/plugin/jdbc/jdbc-postgis/src/main/java/org/geotools/data/postgis/FilterToSqlHelper.java



--
Jody Garnett

On Mon, 7 Dec 2020 at 07:50, Erwan Bocher <erwan.boc...@univ-ubs.fr<mailto:erwan.boc...@univ-ubs.fr>> wrote:


    Hi,

    I have a first prototype to convert SQL expression to Geotools
    Expression available as a draft here
    https://github.com/orbisgis/orbisgis/pull/1404

    Spatial databases use ST_ prefix to define spatial function. e.g
    st_area, st_centroid

    Geotools expression and filter function doesn't.

    I added a workaround in the sql to expression parser to check when
    the
    sql expression contains a "st_" function and rename it to a geotools
    representation.

    I'd like to known if there is a simple way to aliasing filter
    function
    in geotools and write something like that

    st_area(the_geom) >1000 instead of area(the_geom) >1000

    best regards

    Erwan

--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

--
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] Alias on filter function

Reply via email to