QGIS, Query out some attribute columns temporarilyQgis: Export only some columns of the selected objects to CSVCopying some values from several columns to another column in attribute table?QGIS 2.16.0 - issues with styles and rearranging attribute table columnsRenaming columns in attribute table of joined data - integer dataAttribute Table Print composer columnsColumn names won't update for the attribute table in QGIS using a pythonUnable to only include specific attributes/columns to be joined when joining attribute tables in QGIS with pythonSelect columns to keep from attribute tableQGIS using spatial query in the Layer Attribute EditorAttribute Table Sort Disordered in QGIS?
Set theory with antielements?
Is there a word for returning to unpreparedness?
Will some rockets really collapse under their own weight?
Is Fourier series a sampled version of Fourier transform?
Is this true for all polynomials
Why do we use low resistance cables to minimize power losses?
Why does "auf der Strecke bleiben" mean "to fall by the wayside"?
Knights and Knaves on a (Not So) Deserted Island
What allows us to use imaginary numbers?
Have there ever been other TV shows or Films that told a similiar story to the new 90210 show?
Why do so many people play out of turn on the last lead?
Did Michelle Obama have a staff of 23; and Melania have a staff of 4?
Eric Andre had a dream
How do I pass a "list of lists" as the argument to a function of the form F[x,y]?
Are there any cons in using rounded corners for bar graphs?
How to say "have ideas above his station" in French?
What are these panels underneath the wing root of a A380?
Unconventional examples of mathematical modelling
6502: is BCD *fundamentally* the same performance as non-BCD?
Build a mob of suspiciously happy lenny faces ( ͡° ͜ʖ ͡°)
Can I use my OWN published papers' images in my thesis without Copyright infringment
How can I find an old paper when the usual methods fail?
What if a restaurant suddenly cannot accept credit cards, and the customer has no cash?
Expressing a chain of boolean ORs using ILP
QGIS, Query out some attribute columns temporarily
Qgis: Export only some columns of the selected objects to CSVCopying some values from several columns to another column in attribute table?QGIS 2.16.0 - issues with styles and rearranging attribute table columnsRenaming columns in attribute table of joined data - integer dataAttribute Table Print composer columnsColumn names won't update for the attribute table in QGIS using a pythonUnable to only include specific attributes/columns to be joined when joining attribute tables in QGIS with pythonSelect columns to keep from attribute tableQGIS using spatial query in the Layer Attribute EditorAttribute Table Sort Disordered in QGIS?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I am looking for a work-around to remove some fields (attribute columns) from a layer's table by a query.
For example, there are 10 columns in a table, remove 9 and leave only one (virtually).
Now, if I run 'Join Attribute by Location' tool, I should only get one column attached to the new 'join layer'. This is so that I could get only the desired attribute column in the output 'join layer'.
Once I finish this task, I should be able to display all original columns back as they were in the layer.
I know there is an equivalent in ESRI's ArcGIS, but not sure about QGIS.
qgis attribute-table
edited Aug 5 at 1:17
JGH
15.7k2 gold badges15 silver badges40 bronze badges
asked Aug 4 at 23:35
imranimran
111 bronze badge
add a comment |
I am looking for a work-around to remove some fields (attribute columns) from a layer's table by a query.
For example, there are 10 columns in a table, remove 9 and leave only one (virtually).
Now, if I run 'Join Attribute by Location' tool, I should only get one column attached to the new 'join layer'. This is so that I could get only the desired attribute column in the output 'join layer'.
Once I finish this task, I should be able to display all original columns back as they were in the layer.
I know there is an equivalent in ESRI's ArcGIS, but not sure about QGIS.
qgis attribute-table
edited Aug 5 at 1:17
JGH
15.7k2 gold badges15 silver badges40 bronze badges
asked Aug 4 at 23:35
imranimran
111 bronze badge
Just to be clear: you want to do a spatial join where only 1 of the 10 join table columns is joined? Are you using Arc or QGIS?
– Stu Smith
Aug 5 at 0:39
add a comment |
I am looking for a work-around to remove some fields (attribute columns) from a layer's table by a query.
For example, there are 10 columns in a table, remove 9 and leave only one (virtually).
Now, if I run 'Join Attribute by Location' tool, I should only get one column attached to the new 'join layer'. This is so that I could get only the desired attribute column in the output 'join layer'.
Once I finish this task, I should be able to display all original columns back as they were in the layer.
I know there is an equivalent in ESRI's ArcGIS, but not sure about QGIS.
qgis attribute-table
edited Aug 5 at 1:17
JGH
15.7k2 gold badges15 silver badges40 bronze badges
asked Aug 4 at 23:35
imranimran
111 bronze badge
I am looking for a work-around to remove some fields (attribute columns) from a layer's table by a query.
For example, there are 10 columns in a table, remove 9 and leave only one (virtually).
Now, if I run 'Join Attribute by Location' tool, I should only get one column attached to the new 'join layer'. This is so that I could get only the desired attribute column in the output 'join layer'.
Once I finish this task, I should be able to display all original columns back as they were in the layer.
I know there is an equivalent in ESRI's ArcGIS, but not sure about QGIS.
qgis attribute-table
qgis attribute-table
edited Aug 5 at 1:17
JGH
15.7k2 gold badges15 silver badges40 bronze badges
asked Aug 4 at 23:35
imranimran
111 bronze badge
edited Aug 5 at 1:17
JGH
15.7k2 gold badges15 silver badges40 bronze badges
asked Aug 4 at 23:35
imranimran
111 bronze badge
edited Aug 5 at 1:17
JGH
15.7k2 gold badges15 silver badges40 bronze badges
edited Aug 5 at 1:17
JGH
15.7k2 gold badges15 silver badges40 bronze badges
edited Aug 5 at 1:17
JGH
15.7k2 gold badges15 silver badges40 bronze badges
15.7k2 gold badges15 silver badges40 bronze badges
asked Aug 4 at 23:35
imranimran
111 bronze badge
asked Aug 4 at 23:35
imranimran
111 bronze badge
asked Aug 4 at 23:35
imranimran
111 bronze badge
111 bronze badge
Just to be clear: you want to do a spatial join where only 1 of the 10 join table columns is joined? Are you using Arc or QGIS?
– Stu Smith
Aug 5 at 0:39
add a comment |
Just to be clear: you want to do a spatial join where only 1 of the 10 join table columns is joined? Are you using Arc or QGIS?
– Stu Smith
Aug 5 at 0:39
Just to be clear: you want to do a spatial join where only 1 of the 10 join table columns is joined? Are you using Arc or QGIS?
– Stu Smith
Aug 5 at 0:39
Just to be clear: you want to do a spatial join where only 1 of the 10 join table columns is joined? Are you using Arc or QGIS?
– Stu Smith
Aug 5 at 0:39
add a comment |
2 Answers
2
active
oldest
votes
join attributes by location actually offers exactly this functionality: You can choose which attributes to join (leaving the field blank joins all columns)
answered Aug 5 at 6:34
ErikErik
4,2536 silver badges22 bronze badges
2
In the English version, this option is called "Fields to add."
– csk
Aug 5 at 15:55
add a comment |
You can create a virtual layer with the desired column(s). The layer just points to the original layer, so it can be dismissed when you are done with it.
go to the menu Layer > Add Layer > Add/Edit Virtual Layer... and enter the query
SELECT myfield, geometry
FROM myLayer
edited Aug 5 at 6:54
Taras
3,4893 gold badges9 silver badges33 bronze badges
answered Aug 5 at 1:16
JGHJGH
15.7k2 gold badges15 silver badges40 bronze badges
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
);
);
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f331011%2fqgis-query-out-some-attribute-columns-temporarily%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
join attributes by location actually offers exactly this functionality: You can choose which attributes to join (leaving the field blank joins all columns)
answered Aug 5 at 6:34
ErikErik
4,2536 silver badges22 bronze badges
2
In the English version, this option is called "Fields to add."
– csk
Aug 5 at 15:55
add a comment |
join attributes by location actually offers exactly this functionality: You can choose which attributes to join (leaving the field blank joins all columns)
answered Aug 5 at 6:34
ErikErik
4,2536 silver badges22 bronze badges
2
In the English version, this option is called "Fields to add."
– csk
Aug 5 at 15:55
add a comment |
join attributes by location actually offers exactly this functionality: You can choose which attributes to join (leaving the field blank joins all columns)
answered Aug 5 at 6:34
ErikErik
4,2536 silver badges22 bronze badges
join attributes by location actually offers exactly this functionality: You can choose which attributes to join (leaving the field blank joins all columns)
answered Aug 5 at 6:34
ErikErik
4,2536 silver badges22 bronze badges
edited Aug 5 at 12:37
answered Aug 5 at 6:34
ErikErik
4,2536 silver badges22 bronze badges
answered Aug 5 at 6:34
ErikErik
4,2536 silver badges22 bronze badges
answered Aug 5 at 6:34
ErikErik
4,2536 silver badges22 bronze badges
4,2536 silver badges22 bronze badges
2
In the English version, this option is called "Fields to add."
– csk
Aug 5 at 15:55
add a comment |
2
In the English version, this option is called "Fields to add."
– csk
Aug 5 at 15:55
2
2
In the English version, this option is called "Fields to add."
– csk
Aug 5 at 15:55
In the English version, this option is called "Fields to add."
– csk
Aug 5 at 15:55
add a comment |
You can create a virtual layer with the desired column(s). The layer just points to the original layer, so it can be dismissed when you are done with it.
go to the menu Layer > Add Layer > Add/Edit Virtual Layer... and enter the query
SELECT myfield, geometry
FROM myLayer
edited Aug 5 at 6:54
Taras
3,4893 gold badges9 silver badges33 bronze badges
answered Aug 5 at 1:16
JGHJGH
15.7k2 gold badges15 silver badges40 bronze badges
add a comment |
You can create a virtual layer with the desired column(s). The layer just points to the original layer, so it can be dismissed when you are done with it.
go to the menu Layer > Add Layer > Add/Edit Virtual Layer... and enter the query
SELECT myfield, geometry
FROM myLayer
edited Aug 5 at 6:54
Taras
3,4893 gold badges9 silver badges33 bronze badges
answered Aug 5 at 1:16
JGHJGH
15.7k2 gold badges15 silver badges40 bronze badges
add a comment |
You can create a virtual layer with the desired column(s). The layer just points to the original layer, so it can be dismissed when you are done with it.
go to the menu Layer > Add Layer > Add/Edit Virtual Layer... and enter the query
SELECT myfield, geometry
FROM myLayer
edited Aug 5 at 6:54
Taras
3,4893 gold badges9 silver badges33 bronze badges
answered Aug 5 at 1:16
JGHJGH
15.7k2 gold badges15 silver badges40 bronze badges
You can create a virtual layer with the desired column(s). The layer just points to the original layer, so it can be dismissed when you are done with it.
go to the menu Layer > Add Layer > Add/Edit Virtual Layer... and enter the query
SELECT myfield, geometry
FROM myLayer
edited Aug 5 at 6:54
Taras
3,4893 gold badges9 silver badges33 bronze badges
answered Aug 5 at 1:16
JGHJGH
15.7k2 gold badges15 silver badges40 bronze badges
edited Aug 5 at 6:54
Taras
3,4893 gold badges9 silver badges33 bronze badges
edited Aug 5 at 6:54
Taras
3,4893 gold badges9 silver badges33 bronze badges
edited Aug 5 at 6:54
Taras
3,4893 gold badges9 silver badges33 bronze badges
3,4893 gold badges9 silver badges33 bronze badges
answered Aug 5 at 1:16
JGHJGH
15.7k2 gold badges15 silver badges40 bronze badges
answered Aug 5 at 1:16
JGHJGH
15.7k2 gold badges15 silver badges40 bronze badges
answered Aug 5 at 1:16
JGHJGH
15.7k2 gold badges15 silver badges40 bronze badges
15.7k2 gold badges15 silver badges40 bronze badges
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f331011%2fqgis-query-out-some-attribute-columns-temporarily%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Just to be clear: you want to do a spatial join where only 1 of the 10 join table columns is joined? Are you using Arc or QGIS?
– Stu Smith
Aug 5 at 0:39