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 >
_______________________________________________ GeoTools-GT2-Users mailing list GeoTools-GT2-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
