Ygthkb

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

Is the percentage symbol a constant?

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

Is it possible to have the same planeswalker from different editions in a Commander deck?

How many diagrams is too much in a research article?

Can you help me solve this algebra problem?

How unreachable are Jupiter's moons from Mars with the technology developed for going to Mars?

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

Boss asked me to sign a resignation paper without a date on it along with my new contract

Buying a "Used" Router

Including proofs of known theorems in master's thesis

Is there any way to play D&D without a DM?

In the Lost in Space intro why was Dr. Smith actor listed as a special guest star?

Disk space full during insert, what happens?

Minimum Viable Product for RTS game?

Why is Shelob considered evil?

Can I benefit from a feat effect whilst polymorphed?

How to write Muḥammad ibn Mūsā al-Khwārizmī?

How bad is a Computer Science course that doesn't teach Design Patterns?

What if I miss a connection and don't have money to book next flight?

Color of alien seas

Finding the index of a specific element in a list

In a post apocalypse world, with no power and few survivors, would Satnav still work?

Are all power cords made equal?

Select all columns except geometry using virtual layers

How to select a number of rows based on current sort orderSQL Geometry Query similar to Select by Centroidogr2ogr export to KML from SQLite, when using SELECT for fields Linestrings are lostDynamic Linear Referencing of events in QGIS from Excel or CSV using virtual layerIs it possible to create a virtual layer based upon virtual (geometry) fields of another layer ?How to iterate nearest polygons until threshold is reached?QGIS: alternative to add/edit virtual layer. With python?Mangled table names and choice of geometry when there are multiple geometry columnsHow to label only one feature in QGIS without editing layers when several have the same valueSelect layer by attribute - SQL command pending on two columns

2

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

For example I have this (simplified) query:

Select *, st_buffer(geometry, 100) From mypolygons

It does not work. It does not buffer at all. But using the (simplified) query as follows does buffer all polygons as intended:

Select id, name, st_buffer(geometry, 100) From mypolygons

Now the issue is, that if I have polygons 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|improve this question

edited 1 hour ago

JGH

12.6k21137

asked 1 hour ago

MrXsquaredMrXsquared

1,5921416

add a comment | 

2

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

For example I have this (simplified) query:

Select *, st_buffer(geometry, 100) From mypolygons

It does not work. It does not buffer at all. But using the (simplified) query as follows does buffer all polygons as intended:

Select id, name, st_buffer(geometry, 100) From mypolygons

Now the issue is, that if I have polygons 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|improve this question

edited 1 hour ago

JGH

12.6k21137

asked 1 hour ago

MrXsquaredMrXsquared

1,5921416

add a comment | 

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

For example I have this (simplified) query:

Select *, st_buffer(geometry, 100) From mypolygons

It does not work. It does not buffer at all. But using the (simplified) query as follows does buffer all polygons as intended:

Select id, name, st_buffer(geometry, 100) From mypolygons

Now the issue is, that if I have polygons 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|improve this question

edited 1 hour ago

JGH

12.6k21137

asked 1 hour ago

MrXsquaredMrXsquared

1,5921416

Select *, st_buffer(geometry, 100) From mypolygons

Select id, name, st_buffer(geometry, 100) From mypolygons

share|improve this question

edited 1 hour ago

JGH

12.6k21137

asked 1 hour ago

MrXsquaredMrXsquared

1,5921416

share|improve this question

edited 1 hour ago

JGH

12.6k21137

asked 1 hour ago

MrXsquaredMrXsquared

1,5921416

edited 1 hour ago

JGH

12.6k21137

edited 1 hour ago

JGH

12.6k21137

asked 1 hour ago

MrXsquaredMrXsquared

1,5921416

asked 1 hour ago

MrXsquaredMrXsquared

1,5921416

1 Answer
1

active

oldest

votes

3

It does work as intended, and it is only a display issue.

To make is work, just give a name to the buffered geometry and specify this name as being the spatial column.

Otherwise, the virtual layer has two geometry columns, the original geometry and the new st_buffer(geometry) and the 1st one is picked-up for display.

Select *, st_buffer(geometry, 100) as geo2 From mypolygons

share|improve this answer

answered 1 hour ago

JGHJGH

12.6k21137

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f313331%2fselect-all-columns-except-geometry-using-virtual-layers%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

3

It does work as intended, and it is only a display issue.

To make is work, just give a name to the buffered geometry and specify this name as being the spatial column.

Otherwise, the virtual layer has two geometry columns, the original geometry and the new st_buffer(geometry) and the 1st one is picked-up for display.

Select *, st_buffer(geometry, 100) as geo2 From mypolygons

share|improve this answer

answered 1 hour ago

JGHJGH

12.6k21137

add a comment | 

3

It does work as intended, and it is only a display issue.

To make is work, just give a name to the buffered geometry and specify this name as being the spatial column.

Otherwise, the virtual layer has two geometry columns, the original geometry and the new st_buffer(geometry) and the 1st one is picked-up for display.

Select *, st_buffer(geometry, 100) as geo2 From mypolygons

share|improve this answer

answered 1 hour ago

JGHJGH

12.6k21137

add a comment | 

It does work as intended, and it is only a display issue.

To make is work, just give a name to the buffered geometry and specify this name as being the spatial column.

Otherwise, the virtual layer has two geometry columns, the original geometry and the new st_buffer(geometry) and the 1st one is picked-up for display.

Select *, st_buffer(geometry, 100) as geo2 From mypolygons

share|improve this answer

answered 1 hour ago

JGHJGH

12.6k21137

Select *, st_buffer(geometry, 100) as geo2 From mypolygons

share|improve this answer

answered 1 hour ago

JGHJGH

12.6k21137

answered 1 hour ago

JGHJGH

12.6k21137

answered 1 hour ago

JGHJGH

12.6k21137