Dissolve using ogr2ogr gives 'no such function: ST_union'

Question

I am trying to dissolve a shapefile using ogr2ogr but I am getting error no such function: ST_union:

Command:

C:\ms4w>ogr2ogr "C:\output\test-dissolved.sh p" "C:\input\test.shp" -dialect sqlite -sql "SELECT ST_union(geometry) FROM test "

Error:

ERROR 1: In ExecuteSQL(): sqlite3_prepare(SELECT ST_union(geometry) FROM test ): no such function: ST_union

Your GDAL version is is probably compiled without Spatialite. You can test it with ogrinfo -dialect sqlite -sql "select spatialite_version() from test" test.shp. — user30184, Aug 1 '16 at 11:33

Shiko · Accepted Answer · 2016-08-03 16:05:12Z

1

I should use GUnion instead of ST_Union, I tried it and it worked.

below is a list of all spatialite functions where it shows the ST & GEOS functions:
https://www.gaia-gis.it/gaia-sins/spatialite-sql-4.3.0.html

answered Aug 1 '16 at 10:18

Shiko

2,5307 silver badges21 bronze badges

1

2.4 is a very old version with some security issues. I suggest upgrading... – BradHards Aug 1 '16 at 11:27
1

You referred to 2.4 reference link in your answer. Probably just a google hit. gaia-gis.it/gaia-sins/spatialite-sql-4.3.0.html is current as of Aug 2016. – BradHards Aug 1 '16 at 11:30

add a comment |

1 Answer 1