Vjylku

Renting a 2CV in France

Disk space full during insert, what happens?

What is the meaning of "usr"?

How can I prevent an oracle who can see into the past from knowing everything that has happened?

Does throwing a Bead of Force require a roll to hit accurately?

Third wheel character

How can I handle players killing my NPC outside of combat?

Is having explosions as a go-to solution considered bad table manners?

Is the UK legally prevented from having another referendum on Brexit?

Is it possible to narrate a novel in a faux-historical style without alienating the reader?

Coworker asking me to not bring cakes due to self control issue. What should I do?

Neglect higher order derivatives in expression

Can you help me solve this algebra problem?

How do I narratively explain how in-game circumstances do not mechanically allow a PC to instantly kill an NPC?

Coworker is trying to get me to sign his petition to run for office. How to decline politely?

How do I add a strong "onion flavor" to the biryani (in restaurant style)?

Why can't i set the 'prototype' of a function created using 'bind'?

How can I give a Ranger advantage on a check due to Favored Enemy without spoiling the story for the player?

Unable to repartition non-mounted SD card

Can you prevent a man in the middle from reading the message?

Isn't a semicolon (';') needed after a function declaration in C++?

Is the tritone (A4 / d5) still banned in Roman Catholic music?

How do I avoid the "chosen hero" feeling?

Sets that are both Sum-free and Product-free

Select all columns except geometry using virutal layers

SQL Geometry Query similar to Select by CentroidHow to perform SQL query using .STContains in MS SQL Serverogr2ogr export to KML from SQLite, when using SELECT for fields Linestrings are lostCombined Hstore key/value and spatial query too slow to handle bigger OSM extractsST_Union returning Null with Spatialite, even after ST_MakeValiddissolving polygon records that only fall completely in another polygon from the same tableFind missing polygons from two layers with select by location toolMore efficient approach for processing large polygon datasetPostGIS Union of two polygons layersSelect layer by attribute - SQL command pending on two columns

0

Is it possible to select all columns except geometry using virutal layers in QGIS?

For example I have this (simplified) query:

Select *, st_union(geometry) From mypolygons

It does not work. It only throws back the first polygon. But using the (simplified) query as follows does union all polygons as intended:

Select id, name, st_union(geometry) From mypolygons

Now the issue is, that if I have a polygon with a lot of columns I need them to type in all manually. Is there a way to avoid this?

qgis sql virtual-layer

share

asked 1 min ago

MrXsquaredMrXsquared

1,5801416

add a comment | 

0

Is it possible to select all columns except geometry using virutal layers in QGIS?

For example I have this (simplified) query:

Select *, st_union(geometry) From mypolygons

It does not work. It only throws back the first polygon. But using the (simplified) query as follows does union all polygons as intended:

Select id, name, st_union(geometry) From mypolygons

Now the issue is, that if I have a polygon with a lot of columns I need them to type in all manually. Is there a way to avoid this?

qgis sql virtual-layer

share

asked 1 min ago

MrXsquaredMrXsquared

1,5801416

add a comment | 

Is it possible to select all columns except geometry using virutal layers in QGIS?

For example I have this (simplified) query:

Select *, st_union(geometry) From mypolygons

It does not work. It only throws back the first polygon. But using the (simplified) query as follows does union all polygons as intended:

Select id, name, st_union(geometry) From mypolygons

Now the issue is, that if I have a polygon with a lot of columns I need them to type in all manually. Is there a way to avoid this?

qgis sql virtual-layer

share

asked 1 min ago

MrXsquaredMrXsquared

1,5801416

Select *, st_union(geometry) From mypolygons

Select id, name, st_union(geometry) From mypolygons

share

asked 1 min ago

MrXsquaredMrXsquared

1,5801416

share

asked 1 min ago

MrXsquaredMrXsquared

1,5801416

asked 1 min ago

MrXsquaredMrXsquared

1,5801416

asked 1 min ago

MrXsquaredMrXsquared

1,5801416