[gdal-dev] OGR SQL CAST geometry example

[Daniel Baston]

If a single MULTIPOINT record is OK, then you can do

ogrinfo test.shp -q -dialect SQLITE -sql 'SELECT
ST_DissolvePoints(GEOMETRY) FROM test'

Dan


On Thu, May 30, 2024 at 8:49 PM Dan Jacobson via gdal-dev
<gdal-dev at lists.osgeo.org> wrote:
>
> $ ogrinfo 0.lines.kml -q -dialect SQLITE -sql \
> 'SELECT ST_PointN(GEOMETRY, generate_series(1, ST_NPoints(GEOMETRY))) FROM "0"'
> ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2(....
>   no such function: generate_series
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev