Le 30/09/2024 à 21:18, Meyer, Jesse R. (GSFC-618.0)[SCIENCE SYSTEMS AND
APPLICATIONS INC] a écrit :
Thanks Scott and Even,
Maybe it’s an unexpected interaction with Spatialite, but explicitly
providing the geometry column’s name results in bogus outputs. Is the
SQL string wrong somehow?
/f/"select count(ST_Area('{lyr_name + '.' + geom_column_name}'))".
(same outcome if re-arranged as count(…) from lyr_name instead)
ST_Area(some_text) will not work. It expects an identifier (possibly
double quoted if that's needed), not a single-quoted string literal.
--
http://www.spatialys.com
My software is free, but my time generally not.
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev