Vjylku

80-bit collision resistence because of 80-bit x87 registers?

Can you wish for more wishes from an Efreeti bound to service via an Efreeti Bottle?

Was the Soviet N1 really capable of sending 9.6 GB/s of telemetry?

Taking an academic pseudonym?

Ramanujan's radical and how we define an infinite nested radical

Can "ee" appear in Latin?

Why is Shelob considered evil?

What is the difference between crontab -e and nano /etc/crontab?

Is it common to refer to someone as "Prof. Dr. [LastName]"?

Aligning Systems of Equations

What is formjacking?

Almost normal subgroups: Is there any notion which is weaker than normal subgroup?

How many copper coins fit inside a cubic foot?

Why would you use 2 alternate layout buttons instead of 1, when only one can be selected at once

How can I create unencrypted addresses?

SFDX CLI - Locked with an active writer?

Which was the first story to feature space elevators?

Arizona laws regarding ownership of ground glassware for chemistry usage

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

Why don't reads from /dev/zero count as I/O?

Are there any spells or magic items that allow for making of ‘logic gates or wires’?

What if you do not believe in the project benefits?

How can changes in personality/values of a person who turned into a vampire be explained?

Can a planet be tidally unlocked?

Adding field in vector layer from attribute table in QGIS?

Joining non-spatial CSV file to spatial data (shapefile) using QGIS?Primary key field hidden on attribute table added to QGISQGIS crashes when adding vector layer from mysql or testing connection to mysqlQGIS 1.8 Vector layer from ODBC connectionAttribute table not updating after QGIS field calculator used?How to avoid field duplication when joining two vector layers?Adding value in raster file from attribute table in QGIS?Adding date field to attribute table using QGIS processing modeler?Making QGIS attribute table field automatic?Using field calculator for attribute table data in QGISAutomatically Generate Attribute Table in Qgis

1

I have an Attribute Table named 'data.shp' and a Vector Layer 'pop.shp'.

The 'data.shp' has the following fields "ID", "value1", "value2"

The 'pop.shp' has the "ID" field (same with the 'data.shp')

I want to update 'pop.shp' and add the fields "value1", "value2" from 'data.shp' where "ID" (from 'data.shp') is equal to "ID" (from 'pop.shp').

How could I do that in QGIS?

qgis sql attribute-joins

share|improve this question

edited 1 hour ago

Kazuhito

15.8k41782

asked 2 hours ago

NatNat

375

• 
  
  
  

  
  3
  

  
  
  
  
  
  

  
  
  Have you checked this tutorial Performing Table Joins? Start from Step #12, inclusive.
  
  – Taras
  2 hours ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Possible duplicate of Joining non-spatial CSV file to spatial data (shapefile) using QGIS?, mainly Nathan W's answer.
  
  – Taras
  2 hours ago
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Taras it seems sql tag was removed. That tag is essential to distinguish Nat's question from the linked one. Thanks!
  
  – Kazuhito
  2 hours ago
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Kazuhito, shall I place it back? However, I did not find out anything related to sql in the gist of the question itself, is not it? Can you clarify this for me, please?
  
  – Taras
  2 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Kazuhito I'm not sure the sql tag is that relevant even to the linked questions. The joins can be done without it.
  
  – Gabriel C.
  2 hours ago
  

  
  
  
  

 | 
show 5 more comments

1

I have an Attribute Table named 'data.shp' and a Vector Layer 'pop.shp'.

The 'data.shp' has the following fields "ID", "value1", "value2"

The 'pop.shp' has the "ID" field (same with the 'data.shp')

I want to update 'pop.shp' and add the fields "value1", "value2" from 'data.shp' where "ID" (from 'data.shp') is equal to "ID" (from 'pop.shp').

How could I do that in QGIS?

qgis sql attribute-joins

share|improve this question

edited 1 hour ago

Kazuhito

15.8k41782

asked 2 hours ago

NatNat

375

• 
  
  
  

  
  3
  

  
  
  
  
  
  

  
  
  Have you checked this tutorial Performing Table Joins? Start from Step #12, inclusive.
  
  – Taras
  2 hours ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Possible duplicate of Joining non-spatial CSV file to spatial data (shapefile) using QGIS?, mainly Nathan W's answer.
  
  – Taras
  2 hours ago
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Taras it seems sql tag was removed. That tag is essential to distinguish Nat's question from the linked one. Thanks!
  
  – Kazuhito
  2 hours ago
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Kazuhito, shall I place it back? However, I did not find out anything related to sql in the gist of the question itself, is not it? Can you clarify this for me, please?
  
  – Taras
  2 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Kazuhito I'm not sure the sql tag is that relevant even to the linked questions. The joins can be done without it.
  
  – Gabriel C.
  2 hours ago
  

  
  
  
  

 | 
show 5 more comments

I have an Attribute Table named 'data.shp' and a Vector Layer 'pop.shp'.

The 'data.shp' has the following fields "ID", "value1", "value2"

The 'pop.shp' has the "ID" field (same with the 'data.shp')

I want to update 'pop.shp' and add the fields "value1", "value2" from 'data.shp' where "ID" (from 'data.shp') is equal to "ID" (from 'pop.shp').

How could I do that in QGIS?

qgis sql attribute-joins

share|improve this question

edited 1 hour ago

Kazuhito

15.8k41782

asked 2 hours ago

NatNat

375

share|improve this question

edited 1 hour ago

Kazuhito

15.8k41782

asked 2 hours ago

NatNat

375

share|improve this question

edited 1 hour ago

Kazuhito

15.8k41782

asked 2 hours ago

NatNat

375

edited 1 hour ago

Kazuhito

15.8k41782

edited 1 hour ago

Kazuhito

15.8k41782

asked 2 hours ago

NatNat

375

asked 2 hours ago

NatNat

375

2 Answers
2

active

oldest

votes

1

You can perform it with a Virtual Layer from Layer > Add Layer > Add/Edit Virtual Layer

SELECT pop.*, data.value1, data.value2

FROM pop

LEFT JOIN data

ON pop.id = data.id

References:

• SQL Joins


• SQL LEFT JOIN Keyword

share|improve this answer

answered 1 hour ago

TarasTaras

2,0802624

add a comment | 

1

QGIS has built-in table join capabilities. If you want to add fields from a table (data.shp) into another layer (pop.shp), then go this way:

• Right click on pop.shp -> Properties -> Joins -> "+"


• Choose relevant layer and key field for the join


• Check which fields you want to add


• Click OK

The attribute table from your pop.shp layer should now include the data you need. To make this permanent, save the layer as a new file.

share|improve this answer

edited 43 mins ago

Gabriel C.

1,277320

answered 2 hours ago

ChristopheChristophe

864315

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%2f313065%2fadding-field-in-vector-layer-from-attribute-table-in-qgis%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

1

You can perform it with a Virtual Layer from Layer > Add Layer > Add/Edit Virtual Layer

SELECT pop.*, data.value1, data.value2

FROM pop

LEFT JOIN data

ON pop.id = data.id

References:

• SQL Joins


• SQL LEFT JOIN Keyword

share|improve this answer

answered 1 hour ago

TarasTaras

2,0802624

add a comment | 

1

You can perform it with a Virtual Layer from Layer > Add Layer > Add/Edit Virtual Layer

SELECT pop.*, data.value1, data.value2

FROM pop

LEFT JOIN data

ON pop.id = data.id

References:

• SQL Joins


• SQL LEFT JOIN Keyword

share|improve this answer

answered 1 hour ago

TarasTaras

2,0802624

add a comment | 

You can perform it with a Virtual Layer from Layer > Add Layer > Add/Edit Virtual Layer

SELECT pop.*, data.value1, data.value2

FROM pop

LEFT JOIN data

ON pop.id = data.id

References:

• SQL Joins


• SQL LEFT JOIN Keyword

share|improve this answer

answered 1 hour ago

TarasTaras

2,0802624

SELECT pop.*, data.value1, data.value2

FROM pop

LEFT JOIN data

ON pop.id = data.id

share|improve this answer

answered 1 hour ago

TarasTaras

2,0802624

answered 1 hour ago

TarasTaras

2,0802624

answered 1 hour ago

TarasTaras

2,0802624

1

QGIS has built-in table join capabilities. If you want to add fields from a table (data.shp) into another layer (pop.shp), then go this way:

• Right click on pop.shp -> Properties -> Joins -> "+"


• Choose relevant layer and key field for the join


• Check which fields you want to add


• Click OK

The attribute table from your pop.shp layer should now include the data you need. To make this permanent, save the layer as a new file.

share|improve this answer

edited 43 mins ago

Gabriel C.

1,277320

answered 2 hours ago

ChristopheChristophe

864315

add a comment | 

1

QGIS has built-in table join capabilities. If you want to add fields from a table (data.shp) into another layer (pop.shp), then go this way:

• Right click on pop.shp -> Properties -> Joins -> "+"


• Choose relevant layer and key field for the join


• Check which fields you want to add


• Click OK

The attribute table from your pop.shp layer should now include the data you need. To make this permanent, save the layer as a new file.

share|improve this answer

edited 43 mins ago

Gabriel C.

1,277320

answered 2 hours ago

ChristopheChristophe

864315

add a comment | 

QGIS has built-in table join capabilities. If you want to add fields from a table (data.shp) into another layer (pop.shp), then go this way:

• Right click on pop.shp -> Properties -> Joins -> "+"


• Choose relevant layer and key field for the join


• Check which fields you want to add


• Click OK

The attribute table from your pop.shp layer should now include the data you need. To make this permanent, save the layer as a new file.

share|improve this answer

edited 43 mins ago

Gabriel C.

1,277320

answered 2 hours ago

ChristopheChristophe

864315

share|improve this answer

edited 43 mins ago

Gabriel C.

1,277320

answered 2 hours ago

ChristopheChristophe

864315

edited 43 mins ago

Gabriel C.

1,277320

edited 43 mins ago

Gabriel C.

1,277320

answered 2 hours ago

ChristopheChristophe

864315

answered 2 hours ago

ChristopheChristophe

864315