Yep, that is just the only reference we have mapping from SFSQL to geotools functions right now.
And yeah, you should be able to extend not geotools function, but geotools function factory. 1. Make a new FunctionFactory listing the SFSQL function names 2. Make a Function wrapper implementation 3. Use the wrapper to create any SFSQL function name instance requested -- Jody Garnett On Tue, 22 Dec 2020 at 08:42, Erwan Bocher <erwan.boc...@univ-ubs.fr> wrote: > 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 current geotools > 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 them > implement 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> > 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 >> 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 >
_______________________________________________ GeoTools-GT2-Users mailing list GeoTools-GT2-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
