Issue Running Fixed or Variable Buffer
Opened this issue · 1 comments
The code appears to have an unexpected comma when running the variable or fixed distance buffer on QGIS 3.16.7:
QGIS version: 3.16.7-Hannover
QGIS code revision: 0471743889
Qt version: 5.11.2
GDAL version: 3.1.4
GEOS version: 3.8.1-CAPI-1.13.3
PROJ version: Rel. 6.3.2, May 1st, 2020
Processing algorithm…
Algorithm 'Buffer (variable distance)' starting…
Input parameters:
{ 'DISSFIELD' : 'X', 'DISSOLVEALL' : True, 'DISTANCE' : 'ALT', 'FIELDS' : ['ALT','X','Y'], 'INPUT_LAYER' : 'C:/cov/Block1Coverage.shp', 'OPTIONS' : '', 'SCHEMA' : 'public', 'SINGLE' : False, 'TABLE' : 'buffer' }
GDAL command:
ogr2ogr -f PostgreSQL C:/cov/Block1Coverage.shp C:/cov/Block1Coverage.shp -sql "SELECT (ST_Multi(ST_Union(ST_Buffer(,ALT))))::geometry(MULTIPOLYGON,2100) AS geom FROM Block1Coverage" -nln public.buffer -nlt MULTIPOLYGON -lco FID=gid -lco GEOMETRY_NAME=geom --config PG_USE_COPY YES -overwrite
GDAL command output:
ERROR 1: SQL Expression Parsing Error: syntax error, unexpected ','. Occurred around :
SELECT (ST_Multi(ST_Union(ST_Buffer(,ALT))))::geometry(MULTIPOLYGON,2100) AS
^
Execution completed in 0.13 seconds
Results:
{}
Loading resulting layers
Algorithm 'Buffer (variable distance)' finished
Do you have any advice to fix this? I can share the test files privately if required.
Many thanks,
Ross
the plugin is made to just process PostGIS inputs and return PostGIS outputs.
You can use the standard QGIS buffer tool using SHP as inputs and gave the tool write the output to a PostGIS database. The difference with the plugin is that with the plugin is the server that does the math, while with native QGIS tools is QGIS Desktop that does the math,
GDAL command:
ogr2ogr -f PostgreSQL C:/cov/Block1Coverage.shp C:/cov/Block1Coverage.shp -sql "SELECT (ST_Multi(ST_Union(ST_Buffer(,ALT))))::geometry(MULTIPOLYGON,2100) AS geom FROM Block1Coverage" -nln public.buffer -nlt MULTIPOLYGON -lco FID=gid -lco GEOMETRY_NAME=geom --config PG_USE_COPY YES -overwrite
GDAL command output:
ERROR 1: SQL Expression Parsing Error: syntax error, unexpected ','. Occurred around :SELECT (ST_Multi(ST_Union(ST_Buffer(,ALT))))::geometry(MULTIPOLYGON,2100) AS
^