How do I get Table from Vector layers for use with joinattributestable The Next CEO of Stack...
What does "Its cash flow is deeply negative" mean?
Is there a difference between "Fahrstuhl" and "Aufzug"
What happens if you roll doubles 3 times then land on "Go to jail?"
Make solar eclipses exceedingly rare, but still have new moons
Are there any unintended negative consequences to allowing PCs to gain multiple levels at once in a short milestone-XP game?
Does it take more energy to get to Venus or to Mars?
sp_blitzCache results Memory grants
Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis
Why do professional authors make "consistency" mistakes? And how to avoid them?
If/When UK leaves the EU, can a future goverment conduct a referendum to join the EU?
Is it professional to write unrelated content in an almost-empty email?
What exact does MIB represent in SNMP? How is it different from OID?
Real integral using residue theorem - why doesn't this work?
Can someone help
Is 'diverse range' a pleonastic phrase?
Why do remote companies require working in the US?
What is the result of assigning to std::vector<T>::begin()?
Is it my responsibility to learn a new technology in my own time my employer wants to implement?
How to count occurrences of text in a file?
How to invert MapIndexed on a ragged structure? How to construct a tree from rules?
Why has the US not been more assertive in confronting Russia in recent years?
Should I tutor a student who I know has cheated on their homework?
Can you replace a racial trait cantrip when leveling up?
Would this house-rule that treats advantage as a +1 to the roll instead (and disadvantage as -1) and allows them to stack be balanced?
How do I get Table from Vector layers for use with joinattributestable
The Next CEO of Stack OverflowDetecting Join programmatically using ArcPy?How to get all Vector layers from OpenLayers map?Problems when joining large shapefiles to excel tableTrouble loading non-spatial data via CSV using Python for standalone scriptSaving processing results in a file using QGIS modeler?Unable to only include specific attributes/columns to be joined when joining attribute tables in QGIS with pythonArea of Intersection between two polygon files in QGISWhy does QGIS algorithm 'Join attributes table' change the types of the shapefile attributes?Join from list with duplicates in listPiping output of one processing algorithm as input into another algorithm in QGIS Processing script?
I am attempting to run:
processing.runandload('qgis:joinattributestable', layer1, layer2, 'id', 'id', None)
To join my tables and output to a temporary viewing layer.
layer1 and layer2 are both Spatialite imports. They are vector type objects within QGIS.
joinattributestable specifies the following inputs:
ALGORITHM: Join attributes table
INPUT_LAYER <ParameterVector>
INPUT_LAYER_2 <ParameterTable>
TABLE_FIELD <parameters from INPUT_LAYER>
TABLE_FIELD_2 <parameters from INPUT_LAYER_2>
OUTPUT_LAYER <OutputVector>
How can I get ParameterTable from my Vector object?
pyqgis vector attribute-joins table
edited Aug 25 '17 at 12:18
artwork21
31.1k554120
asked Aug 25 '17 at 11:26
IceDreamerIceDreamer
365
bumped to the homepage by Community♦ 10 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am attempting to run:
processing.runandload('qgis:joinattributestable', layer1, layer2, 'id', 'id', None)
To join my tables and output to a temporary viewing layer.
layer1 and layer2 are both Spatialite imports. They are vector type objects within QGIS.
joinattributestable specifies the following inputs:
ALGORITHM: Join attributes table
INPUT_LAYER <ParameterVector>
INPUT_LAYER_2 <ParameterTable>
TABLE_FIELD <parameters from INPUT_LAYER>
TABLE_FIELD_2 <parameters from INPUT_LAYER_2>
OUTPUT_LAYER <OutputVector>
How can I get ParameterTable from my Vector object?
pyqgis vector attribute-joins table
edited Aug 25 '17 at 12:18
artwork21
31.1k554120
asked Aug 25 '17 at 11:26
IceDreamerIceDreamer
365
bumped to the homepage by Community♦ 10 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am attempting to run:
processing.runandload('qgis:joinattributestable', layer1, layer2, 'id', 'id', None)
To join my tables and output to a temporary viewing layer.
layer1 and layer2 are both Spatialite imports. They are vector type objects within QGIS.
joinattributestable specifies the following inputs:
ALGORITHM: Join attributes table
INPUT_LAYER <ParameterVector>
INPUT_LAYER_2 <ParameterTable>
TABLE_FIELD <parameters from INPUT_LAYER>
TABLE_FIELD_2 <parameters from INPUT_LAYER_2>
OUTPUT_LAYER <OutputVector>
How can I get ParameterTable from my Vector object?
pyqgis vector attribute-joins table
edited Aug 25 '17 at 12:18
artwork21
31.1k554120
asked Aug 25 '17 at 11:26
IceDreamerIceDreamer
365
I am attempting to run:
processing.runandload('qgis:joinattributestable', layer1, layer2, 'id', 'id', None)
To join my tables and output to a temporary viewing layer.
layer1 and layer2 are both Spatialite imports. They are vector type objects within QGIS.
joinattributestable specifies the following inputs:
ALGORITHM: Join attributes table
INPUT_LAYER <ParameterVector>
INPUT_LAYER_2 <ParameterTable>
TABLE_FIELD <parameters from INPUT_LAYER>
TABLE_FIELD_2 <parameters from INPUT_LAYER_2>
OUTPUT_LAYER <OutputVector>
How can I get ParameterTable from my Vector object?
pyqgis vector attribute-joins table
pyqgis vector attribute-joins table
edited Aug 25 '17 at 12:18
artwork21
31.1k554120
asked Aug 25 '17 at 11:26
IceDreamerIceDreamer
365
edited Aug 25 '17 at 12:18
artwork21
31.1k554120
asked Aug 25 '17 at 11:26
IceDreamerIceDreamer
365
edited Aug 25 '17 at 12:18
artwork21
31.1k554120
edited Aug 25 '17 at 12:18
artwork21
31.1k554120
edited Aug 25 '17 at 12:18
artwork21
31.1k554120
31.1k554120
asked Aug 25 '17 at 11:26
IceDreamerIceDreamer
365
asked Aug 25 '17 at 11:26
IceDreamerIceDreamer
365
asked Aug 25 '17 at 11:26
IceDreamerIceDreamer
365
365
bumped to the homepage by Community♦ 10 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 10 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
To convert layer object to table try this:
myCSV = 'C:/Temp/myCSV.csv' # change path or .csv file name if needed
QgsVectorFileWriter.writeAsVectorFormat(layer2, myCSV, "utf-8", None, "CSV")
result = processing.runandload('qgis:joinattributestable', layer1, myCSV, 'id', 'id', None)
memoryLayer = processing.getObject(result['OUTPUT']) # this create the object layer
answered Aug 25 '17 at 12:21
artwork21artwork21
31.1k554120
Perhaps I wasn't clear. I cannot run the algorithm because layer2 as third argument is invalid. It's a vector. Not a table. I need to turn it into a table.
– IceDreamer
Aug 25 '17 at 13:14
Updated my answer
– artwork21
Aug 25 '17 at 16:41
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%2f253297%2fhow-do-i-get-table-from-vector-layers-for-use-with-joinattributestable%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
To convert layer object to table try this:
myCSV = 'C:/Temp/myCSV.csv' # change path or .csv file name if needed
QgsVectorFileWriter.writeAsVectorFormat(layer2, myCSV, "utf-8", None, "CSV")
result = processing.runandload('qgis:joinattributestable', layer1, myCSV, 'id', 'id', None)
memoryLayer = processing.getObject(result['OUTPUT']) # this create the object layer
answered Aug 25 '17 at 12:21
artwork21artwork21
31.1k554120
Perhaps I wasn't clear. I cannot run the algorithm because layer2 as third argument is invalid. It's a vector. Not a table. I need to turn it into a table.
– IceDreamer
Aug 25 '17 at 13:14
Updated my answer
– artwork21
Aug 25 '17 at 16:41
add a comment |
To convert layer object to table try this:
myCSV = 'C:/Temp/myCSV.csv' # change path or .csv file name if needed
QgsVectorFileWriter.writeAsVectorFormat(layer2, myCSV, "utf-8", None, "CSV")
result = processing.runandload('qgis:joinattributestable', layer1, myCSV, 'id', 'id', None)
memoryLayer = processing.getObject(result['OUTPUT']) # this create the object layer
answered Aug 25 '17 at 12:21
artwork21artwork21
31.1k554120
Perhaps I wasn't clear. I cannot run the algorithm because layer2 as third argument is invalid. It's a vector. Not a table. I need to turn it into a table.
– IceDreamer
Aug 25 '17 at 13:14
Updated my answer
– artwork21
Aug 25 '17 at 16:41
add a comment |
To convert layer object to table try this:
myCSV = 'C:/Temp/myCSV.csv' # change path or .csv file name if needed
QgsVectorFileWriter.writeAsVectorFormat(layer2, myCSV, "utf-8", None, "CSV")
result = processing.runandload('qgis:joinattributestable', layer1, myCSV, 'id', 'id', None)
memoryLayer = processing.getObject(result['OUTPUT']) # this create the object layer
answered Aug 25 '17 at 12:21
artwork21artwork21
31.1k554120
To convert layer object to table try this:
myCSV = 'C:/Temp/myCSV.csv' # change path or .csv file name if needed
QgsVectorFileWriter.writeAsVectorFormat(layer2, myCSV, "utf-8", None, "CSV")
result = processing.runandload('qgis:joinattributestable', layer1, myCSV, 'id', 'id', None)
memoryLayer = processing.getObject(result['OUTPUT']) # this create the object layer
answered Aug 25 '17 at 12:21
artwork21artwork21
31.1k554120
edited Aug 25 '17 at 16:40
answered Aug 25 '17 at 12:21
artwork21artwork21
31.1k554120
answered Aug 25 '17 at 12:21
artwork21artwork21
31.1k554120
answered Aug 25 '17 at 12:21
artwork21artwork21
31.1k554120
31.1k554120
Perhaps I wasn't clear. I cannot run the algorithm because layer2 as third argument is invalid. It's a vector. Not a table. I need to turn it into a table.
– IceDreamer
Aug 25 '17 at 13:14
Updated my answer
– artwork21
Aug 25 '17 at 16:41
add a comment |
Perhaps I wasn't clear. I cannot run the algorithm because layer2 as third argument is invalid. It's a vector. Not a table. I need to turn it into a table.
– IceDreamer
Aug 25 '17 at 13:14
Updated my answer
– artwork21
Aug 25 '17 at 16:41
Perhaps I wasn't clear. I cannot run the algorithm because layer2 as third argument is invalid. It's a vector. Not a table. I need to turn it into a table.
– IceDreamer
Aug 25 '17 at 13:14
Perhaps I wasn't clear. I cannot run the algorithm because layer2 as third argument is invalid. It's a vector. Not a table. I need to turn it into a table.
– IceDreamer
Aug 25 '17 at 13:14
Updated my answer
– artwork21
Aug 25 '17 at 16:41
Updated my answer
– artwork21
Aug 25 '17 at 16:41
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%2f253297%2fhow-do-i-get-table-from-vector-layers-for-use-with-joinattributestable%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
