New answers tagged spatialite
Here is a step-wise process. Queries were made with Spatialite-gui and visualizations with OpenJUMP. Take some points into table "points" with an attribute "radius". Buffer points by taking the radius from an attribute with SQL CREATE TABLE "buffers" AS SELECT ST_Buffer("geometry", "radius") as geometry FROM points; Union the buffer areas with SQL ...
You could to use Dissolve Tool But, perhaps you could to create a buffer using the parameter: Dissolve result=YES
In SQL, it is an aggregation query. You can do something like: Select st_Union(geom) from your_table group by the_attribute_which_make_each_group
In QGIS you'd use the merge shapefiles function, just be sure to choose the correct couples/triplets/whatever. From the program menu, Vector -> Data management tools -> merge shapefiles
As I've got a similar problem with Geopackage spatial views I thought I'd share what I've seen elsewhere. Some people are reporting that if you select both the ROWID column and geometry column and alias both using " as " in the view SQL, but give them aliases that are exactly the same as the column names, then this fixes the problem in Spatialite. This ...
Try UNION ALL for collecting all the geometries before running ST_COLLECT. SELECT ST_Collect(geometry) FROM (SELECT geometry from tbl1 UNION ALL SELECT geometry from tbl2 UNION ALL SELECT geometry from tbl3 UNION ALL SELECT geometry from tbl4);
A solution was actually buried in this answer, which I could modify for my problem: SELECT MakeLine(p0.geom, p1.geometry) AS link_line FROM "buildings_p0" p0, "roadpoints_p1" p1 WHERE p1.pid = p0.id;
You need to write MakeLine(Collect(p.geometry))
cur.execute(sql) rows = cur.fetchall() for row in rows: print row or for one record: row = cur.fetchone() print row
Top 50 recent answers are included