Extract derived data fields from ShapefilesMerging/Dissolving polygons by Common Attribute Field in QGIS?Data...
Is "history" a male-biased word ("his+story")?
Do recommendation systems necessarily use machine learning algorithms?
Single word request: Harming the benefactor
Of what use is Arcane Recovery to an Elf Wizard?
How can I get players to stop ignoring or overlooking the plot hooks I'm giving them?
Does the nature of the Apocalypse in The Umbrella Academy change from the first to the last episode?
How can I ensure my trip to the UK will not have to be cancelled because of Brexit?
Warn me when the equation number is pushed to the next line
What does "the touch of the purple" mean?
Accountant/ lawyer will not return my call
Grey hair or white hair
Why does liquid water form when we exhale on a mirror?
Why does Captain Marvel assume the people on this planet know this?
Does a warlock using the Darkness/Devil's Sight combo still have advantage on ranged attacks against a target outside the Darkness?
Database Backup for data and log files
weren't playing vs didn't play
Should I take out a loan for a friend to invest on my behalf?
Should I tell my boss the work he did was worthless
Does "Until when" sound natural for native speakers?
Intuition behind counterexample of Euler's sum of powers conjecture
Why does the negative sign arise in this thermodynamic relation?
What's the "normal" opposite of flautando?
How do I express some one as a black person?
Do I really need to have a scientific explanation for my premise?
Extract derived data fields from Shapefiles
Merging/Dissolving polygons by Common Attribute Field in QGIS?Data structure for analysis of relationship between rainfall and vegetation indices?Extract X Y data from Mapinfo layer data files?Appended attribute returning “Attribute index 9 out of bounds [0;9]”Editing feature attribute values in joined non-spatial table in QGIS?Two fields have same name in attribute table and not possible to get unique values?How to populate auxiliary fields in QGIS 3?Shapefiles and attributes from ArcGIS Pro missing in ArcMap?How to impose constraints on drop lists of two fields of the same layer?Strange behaviour viewing world map with EPSG:4326
I've uploaded shapefiles with professionally supplied survey data into QGIS and it all plots fine, then when I export the attributes table into Excel I see that the XYZ values are all zeros.
I know they can't be zero as all the data points are plotting on my map. then when I select each point and view attributes table, sure enough, the XYZ fields are zero, however I do see a tab labelled derived, which when selected does show all of the XYZ attributes that I require.
Does anyone know how to extract these derived data fields from shapefiles so I can merge the values with the previously exported attributes Excel file and have all the survey information I need within a single file.
fields-attributes qgis-3 coordinates
edited 1 min ago
nmtoken
7,99642866
asked 50 mins ago
MichaelZMichaelZ
12
New contributor
MichaelZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I've uploaded shapefiles with professionally supplied survey data into QGIS and it all plots fine, then when I export the attributes table into Excel I see that the XYZ values are all zeros.
I know they can't be zero as all the data points are plotting on my map. then when I select each point and view attributes table, sure enough, the XYZ fields are zero, however I do see a tab labelled derived, which when selected does show all of the XYZ attributes that I require.
Does anyone know how to extract these derived data fields from shapefiles so I can merge the values with the previously exported attributes Excel file and have all the survey information I need within a single file.
fields-attributes qgis-3 coordinates
edited 1 min ago
nmtoken
7,99642866
asked 50 mins ago
MichaelZMichaelZ
12
New contributor
MichaelZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
The points are positioned by their geometry not by their fields, you can calculate the X, Y and Z values using the field calculator docs.qgis.org/2.8/en/docs/user_manual/working_with_vector/… (X = $X, Y = $Y and hopefully there's a Z to calculate to $Z but that's not guaranteed, your shapefile could be 2d and not 3d). Be very careful with Excel and DBF files, if you save them it will break the shapefile, best to copy the DBF somewhere else before opening in Excel then it doesn't matter if you accidentally save it.
– Michael Stimson
9 mins ago
Welcome to GIS.se! Could you click 'edit' and give some more information about your data? Where are the XYZ fields coming from, for example? Did you export the layer using the "save vector layer as ..." and select Excel?
– Simbamangu
2 mins ago
add a comment |
I've uploaded shapefiles with professionally supplied survey data into QGIS and it all plots fine, then when I export the attributes table into Excel I see that the XYZ values are all zeros.
I know they can't be zero as all the data points are plotting on my map. then when I select each point and view attributes table, sure enough, the XYZ fields are zero, however I do see a tab labelled derived, which when selected does show all of the XYZ attributes that I require.
Does anyone know how to extract these derived data fields from shapefiles so I can merge the values with the previously exported attributes Excel file and have all the survey information I need within a single file.
fields-attributes qgis-3 coordinates
edited 1 min ago
nmtoken
7,99642866
asked 50 mins ago
MichaelZMichaelZ
12
New contributor
MichaelZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I've uploaded shapefiles with professionally supplied survey data into QGIS and it all plots fine, then when I export the attributes table into Excel I see that the XYZ values are all zeros.
I know they can't be zero as all the data points are plotting on my map. then when I select each point and view attributes table, sure enough, the XYZ fields are zero, however I do see a tab labelled derived, which when selected does show all of the XYZ attributes that I require.
Does anyone know how to extract these derived data fields from shapefiles so I can merge the values with the previously exported attributes Excel file and have all the survey information I need within a single file.
fields-attributes qgis-3 coordinates
fields-attributes qgis-3 coordinates
edited 1 min ago
nmtoken
7,99642866
asked 50 mins ago
MichaelZMichaelZ
12
New contributor
MichaelZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 1 min ago
nmtoken
7,99642866
asked 50 mins ago
MichaelZMichaelZ
12
New contributor
MichaelZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 1 min ago
nmtoken
7,99642866
edited 1 min ago
nmtoken
7,99642866
edited 1 min ago
nmtoken
7,99642866
7,99642866
asked 50 mins ago
MichaelZMichaelZ
12
New contributor
MichaelZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 50 mins ago
MichaelZMichaelZ
12
asked 50 mins ago
MichaelZMichaelZ
12
12
New contributor
MichaelZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
MichaelZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
MichaelZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
The points are positioned by their geometry not by their fields, you can calculate the X, Y and Z values using the field calculator docs.qgis.org/2.8/en/docs/user_manual/working_with_vector/… (X = $X, Y = $Y and hopefully there's a Z to calculate to $Z but that's not guaranteed, your shapefile could be 2d and not 3d). Be very careful with Excel and DBF files, if you save them it will break the shapefile, best to copy the DBF somewhere else before opening in Excel then it doesn't matter if you accidentally save it.
– Michael Stimson
9 mins ago
Welcome to GIS.se! Could you click 'edit' and give some more information about your data? Where are the XYZ fields coming from, for example? Did you export the layer using the "save vector layer as ..." and select Excel?
– Simbamangu
2 mins ago
add a comment |
1
The points are positioned by their geometry not by their fields, you can calculate the X, Y and Z values using the field calculator docs.qgis.org/2.8/en/docs/user_manual/working_with_vector/… (X = $X, Y = $Y and hopefully there's a Z to calculate to $Z but that's not guaranteed, your shapefile could be 2d and not 3d). Be very careful with Excel and DBF files, if you save them it will break the shapefile, best to copy the DBF somewhere else before opening in Excel then it doesn't matter if you accidentally save it.
– Michael Stimson
9 mins ago
Welcome to GIS.se! Could you click 'edit' and give some more information about your data? Where are the XYZ fields coming from, for example? Did you export the layer using the "save vector layer as ..." and select Excel?
– Simbamangu
2 mins ago
1
1
The points are positioned by their geometry not by their fields, you can calculate the X, Y and Z values using the field calculator docs.qgis.org/2.8/en/docs/user_manual/working_with_vector/… (X = $X, Y = $Y and hopefully there's a Z to calculate to $Z but that's not guaranteed, your shapefile could be 2d and not 3d). Be very careful with Excel and DBF files, if you save them it will break the shapefile, best to copy the DBF somewhere else before opening in Excel then it doesn't matter if you accidentally save it.
– Michael Stimson
9 mins ago
The points are positioned by their geometry not by their fields, you can calculate the X, Y and Z values using the field calculator docs.qgis.org/2.8/en/docs/user_manual/working_with_vector/… (X = $X, Y = $Y and hopefully there's a Z to calculate to $Z but that's not guaranteed, your shapefile could be 2d and not 3d). Be very careful with Excel and DBF files, if you save them it will break the shapefile, best to copy the DBF somewhere else before opening in Excel then it doesn't matter if you accidentally save it.
– Michael Stimson
9 mins ago
Welcome to GIS.se! Could you click 'edit' and give some more information about your data? Where are the XYZ fields coming from, for example? Did you export the layer using the "save vector layer as ..." and select Excel?
– Simbamangu
2 mins ago
Welcome to GIS.se! Could you click 'edit' and give some more information about your data? Where are the XYZ fields coming from, for example? Did you export the layer using the "save vector layer as ..." and select Excel?
– Simbamangu
2 mins ago
add a comment |
0
active
oldest
votes
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
});
}
});
MichaelZ is a new contributor. Be nice, and check out our Code of Conduct.
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%2f315164%2fextract-derived-data-fields-from-shapefiles%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
MichaelZ is a new contributor. Be nice, and check out our Code of Conduct.
MichaelZ is a new contributor. Be nice, and check out our Code of Conduct.
MichaelZ is a new contributor. Be nice, and check out our Code of Conduct.
MichaelZ is a new contributor. Be nice, and check out our Code of Conduct.
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%2f315164%2fextract-derived-data-fields-from-shapefiles%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
1
The points are positioned by their geometry not by their fields, you can calculate the X, Y and Z values using the field calculator docs.qgis.org/2.8/en/docs/user_manual/working_with_vector/… (X = $X, Y = $Y and hopefully there's a Z to calculate to $Z but that's not guaranteed, your shapefile could be 2d and not 3d). Be very careful with Excel and DBF files, if you save them it will break the shapefile, best to copy the DBF somewhere else before opening in Excel then it doesn't matter if you accidentally save it.
– Michael Stimson
9 mins ago
Welcome to GIS.se! Could you click 'edit' and give some more information about your data? Where are the XYZ fields coming from, for example? Did you export the layer using the "save vector layer as ..." and select Excel?
– Simbamangu
2 mins ago