Changing field types so graduated symbols are available











up vote
3
down vote

favorite












I can't seem to make graduated symbols work. When I try to click on my column it doesn't show any options.
I think these is due to those columns being formatted as text and not number. Any ideas how can i work this out?



enter image description here



enter image description here






qgis symbology fields-attributes







share|improve this question
























  • Welcome to GIS SE! As a new user, please be sure to take the tour to learn about this site's focused Q&A format.
    – Andy
    Dec 3 at 13:50















up vote
3
down vote

favorite












I can't seem to make graduated symbols work. When I try to click on my column it doesn't show any options.
I think these is due to those columns being formatted as text and not number. Any ideas how can i work this out?



enter image description here



enter image description here






qgis symbology fields-attributes







share|improve this question
























  • Welcome to GIS SE! As a new user, please be sure to take the tour to learn about this site's focused Q&A format.
    – Andy
    Dec 3 at 13:50













up vote
3
down vote

favorite









up vote
3
down vote

favorite











I can't seem to make graduated symbols work. When I try to click on my column it doesn't show any options.
I think these is due to those columns being formatted as text and not number. Any ideas how can i work this out?



enter image description here



enter image description here






qgis symbology fields-attributes







share|improve this question















I can't seem to make graduated symbols work. When I try to click on my column it doesn't show any options.
I think these is due to those columns being formatted as text and not number. Any ideas how can i work this out?



enter image description here



enter image description here






qgis symbology fields-attributes




qgis symbology fields-attributes






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Dec 3 at 14:25









Gabriel C.

80518




80518










asked Dec 3 at 13:37









Martin Lemma

161




161












  • Welcome to GIS SE! As a new user, please be sure to take the tour to learn about this site's focused Q&A format.
    – Andy
    Dec 3 at 13:50


















  • Welcome to GIS SE! As a new user, please be sure to take the tour to learn about this site's focused Q&A format.
    – Andy
    Dec 3 at 13:50
















Welcome to GIS SE! As a new user, please be sure to take the tour to learn about this site's focused Q&A format.
– Andy
Dec 3 at 13:50




Welcome to GIS SE! As a new user, please be sure to take the tour to learn about this site's focused Q&A format.
– Andy
Dec 3 at 13:50










3 Answers
3






active

oldest

votes

















up vote
3
down vote













Use the field calculator to create a new integer/real column with the following code



to_int/real(dens_bru)



Then graduated symbols should be available.






share|improve this answer

















  • 1




    +1 but I would use 2 lines for the code snippet to show more clearly that those are options and not a mathematical operation ;)
    – LaughU
    Dec 3 at 13:50


















up vote
3
down vote













You can use the Refactor fields tool to restructure your table. It will create a new layer so you can try it without fear of corrupting your existing data.



enter image description here






share|improve this answer





















  • Thanks! I have tried this option before. However, when I try to save the temporary refactored file layer somehow it creates a file with all string type layers. Which is the correct format to save it? Also, fields with data with decimals (eg. "5,54") are transformed into "0".
    – Martin Lemma
    Dec 3 at 15:20












  • Verify that your decimal separator is correctly set, i.e. "." versus ",". That's one main reason why a decimal field would be imported as a string field or its values mangled.
    – Gabriel C.
    Dec 3 at 15:45


















up vote
3
down vote













Instead of selecting the column to be used for graduating, click the Expression button beside it. In there, you can transform your field from text to integer using to_int("FieldName")



In comparisons to the other answers, this one doesn't require a new layer nor to add a new column.



enter image description here






share|improve this answer























  • That's a good idea although if the column contains numeric data, why not change it to the correct type? It might solve other issues in the future.
    – Gabriel C.
    Dec 3 at 14:14






  • 1




    @GabrielC. Fixing the data is the way to go if there is no other system/user depending on the current setting and the data is never refreshed from an external source.
    – JGH
    Dec 3 at 14:19










  • That's sensible. +1.
    – Gabriel C.
    Dec 3 at 14:21











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',
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


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f304730%2fchanging-field-types-so-graduated-symbols-are-available%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























3 Answers
3






active

oldest

votes








3 Answers
3






active

oldest

votes









active

oldest

votes






active

oldest

votes








up vote
3
down vote













Use the field calculator to create a new integer/real column with the following code



to_int/real(dens_bru)



Then graduated symbols should be available.






share|improve this answer

















  • 1




    +1 but I would use 2 lines for the code snippet to show more clearly that those are options and not a mathematical operation ;)
    – LaughU
    Dec 3 at 13:50















up vote
3
down vote













Use the field calculator to create a new integer/real column with the following code



to_int/real(dens_bru)



Then graduated symbols should be available.






share|improve this answer

















  • 1




    +1 but I would use 2 lines for the code snippet to show more clearly that those are options and not a mathematical operation ;)
    – LaughU
    Dec 3 at 13:50













up vote
3
down vote










up vote
3
down vote









Use the field calculator to create a new integer/real column with the following code



to_int/real(dens_bru)



Then graduated symbols should be available.






share|improve this answer












Use the field calculator to create a new integer/real column with the following code



to_int/real(dens_bru)



Then graduated symbols should be available.







share|improve this answer












share|improve this answer



share|improve this answer










answered Dec 3 at 13:46









Erik

2,777118




2,777118








  • 1




    +1 but I would use 2 lines for the code snippet to show more clearly that those are options and not a mathematical operation ;)
    – LaughU
    Dec 3 at 13:50














  • 1




    +1 but I would use 2 lines for the code snippet to show more clearly that those are options and not a mathematical operation ;)
    – LaughU
    Dec 3 at 13:50








1




1




+1 but I would use 2 lines for the code snippet to show more clearly that those are options and not a mathematical operation ;)
– LaughU
Dec 3 at 13:50




+1 but I would use 2 lines for the code snippet to show more clearly that those are options and not a mathematical operation ;)
– LaughU
Dec 3 at 13:50












up vote
3
down vote













You can use the Refactor fields tool to restructure your table. It will create a new layer so you can try it without fear of corrupting your existing data.



enter image description here






share|improve this answer





















  • Thanks! I have tried this option before. However, when I try to save the temporary refactored file layer somehow it creates a file with all string type layers. Which is the correct format to save it? Also, fields with data with decimals (eg. "5,54") are transformed into "0".
    – Martin Lemma
    Dec 3 at 15:20












  • Verify that your decimal separator is correctly set, i.e. "." versus ",". That's one main reason why a decimal field would be imported as a string field or its values mangled.
    – Gabriel C.
    Dec 3 at 15:45















up vote
3
down vote













You can use the Refactor fields tool to restructure your table. It will create a new layer so you can try it without fear of corrupting your existing data.



enter image description here






share|improve this answer





















  • Thanks! I have tried this option before. However, when I try to save the temporary refactored file layer somehow it creates a file with all string type layers. Which is the correct format to save it? Also, fields with data with decimals (eg. "5,54") are transformed into "0".
    – Martin Lemma
    Dec 3 at 15:20












  • Verify that your decimal separator is correctly set, i.e. "." versus ",". That's one main reason why a decimal field would be imported as a string field or its values mangled.
    – Gabriel C.
    Dec 3 at 15:45













up vote
3
down vote










up vote
3
down vote









You can use the Refactor fields tool to restructure your table. It will create a new layer so you can try it without fear of corrupting your existing data.



enter image description here






share|improve this answer












You can use the Refactor fields tool to restructure your table. It will create a new layer so you can try it without fear of corrupting your existing data.



enter image description here







share|improve this answer












share|improve this answer



share|improve this answer










answered Dec 3 at 13:47









Gabriel C.

80518




80518












  • Thanks! I have tried this option before. However, when I try to save the temporary refactored file layer somehow it creates a file with all string type layers. Which is the correct format to save it? Also, fields with data with decimals (eg. "5,54") are transformed into "0".
    – Martin Lemma
    Dec 3 at 15:20












  • Verify that your decimal separator is correctly set, i.e. "." versus ",". That's one main reason why a decimal field would be imported as a string field or its values mangled.
    – Gabriel C.
    Dec 3 at 15:45


















  • Thanks! I have tried this option before. However, when I try to save the temporary refactored file layer somehow it creates a file with all string type layers. Which is the correct format to save it? Also, fields with data with decimals (eg. "5,54") are transformed into "0".
    – Martin Lemma
    Dec 3 at 15:20












  • Verify that your decimal separator is correctly set, i.e. "." versus ",". That's one main reason why a decimal field would be imported as a string field or its values mangled.
    – Gabriel C.
    Dec 3 at 15:45
















Thanks! I have tried this option before. However, when I try to save the temporary refactored file layer somehow it creates a file with all string type layers. Which is the correct format to save it? Also, fields with data with decimals (eg. "5,54") are transformed into "0".
– Martin Lemma
Dec 3 at 15:20






Thanks! I have tried this option before. However, when I try to save the temporary refactored file layer somehow it creates a file with all string type layers. Which is the correct format to save it? Also, fields with data with decimals (eg. "5,54") are transformed into "0".
– Martin Lemma
Dec 3 at 15:20














Verify that your decimal separator is correctly set, i.e. "." versus ",". That's one main reason why a decimal field would be imported as a string field or its values mangled.
– Gabriel C.
Dec 3 at 15:45




Verify that your decimal separator is correctly set, i.e. "." versus ",". That's one main reason why a decimal field would be imported as a string field or its values mangled.
– Gabriel C.
Dec 3 at 15:45










up vote
3
down vote













Instead of selecting the column to be used for graduating, click the Expression button beside it. In there, you can transform your field from text to integer using to_int("FieldName")



In comparisons to the other answers, this one doesn't require a new layer nor to add a new column.



enter image description here






share|improve this answer























  • That's a good idea although if the column contains numeric data, why not change it to the correct type? It might solve other issues in the future.
    – Gabriel C.
    Dec 3 at 14:14






  • 1




    @GabrielC. Fixing the data is the way to go if there is no other system/user depending on the current setting and the data is never refreshed from an external source.
    – JGH
    Dec 3 at 14:19










  • That's sensible. +1.
    – Gabriel C.
    Dec 3 at 14:21















up vote
3
down vote













Instead of selecting the column to be used for graduating, click the Expression button beside it. In there, you can transform your field from text to integer using to_int("FieldName")



In comparisons to the other answers, this one doesn't require a new layer nor to add a new column.



enter image description here






share|improve this answer























  • That's a good idea although if the column contains numeric data, why not change it to the correct type? It might solve other issues in the future.
    – Gabriel C.
    Dec 3 at 14:14






  • 1




    @GabrielC. Fixing the data is the way to go if there is no other system/user depending on the current setting and the data is never refreshed from an external source.
    – JGH
    Dec 3 at 14:19










  • That's sensible. +1.
    – Gabriel C.
    Dec 3 at 14:21













up vote
3
down vote










up vote
3
down vote









Instead of selecting the column to be used for graduating, click the Expression button beside it. In there, you can transform your field from text to integer using to_int("FieldName")



In comparisons to the other answers, this one doesn't require a new layer nor to add a new column.



enter image description here






share|improve this answer














Instead of selecting the column to be used for graduating, click the Expression button beside it. In there, you can transform your field from text to integer using to_int("FieldName")



In comparisons to the other answers, this one doesn't require a new layer nor to add a new column.



enter image description here







share|improve this answer














share|improve this answer



share|improve this answer








edited Dec 3 at 14:27

























answered Dec 3 at 14:01









JGH

11.6k21134




11.6k21134












  • That's a good idea although if the column contains numeric data, why not change it to the correct type? It might solve other issues in the future.
    – Gabriel C.
    Dec 3 at 14:14






  • 1




    @GabrielC. Fixing the data is the way to go if there is no other system/user depending on the current setting and the data is never refreshed from an external source.
    – JGH
    Dec 3 at 14:19










  • That's sensible. +1.
    – Gabriel C.
    Dec 3 at 14:21


















  • That's a good idea although if the column contains numeric data, why not change it to the correct type? It might solve other issues in the future.
    – Gabriel C.
    Dec 3 at 14:14






  • 1




    @GabrielC. Fixing the data is the way to go if there is no other system/user depending on the current setting and the data is never refreshed from an external source.
    – JGH
    Dec 3 at 14:19










  • That's sensible. +1.
    – Gabriel C.
    Dec 3 at 14:21
















That's a good idea although if the column contains numeric data, why not change it to the correct type? It might solve other issues in the future.
– Gabriel C.
Dec 3 at 14:14




That's a good idea although if the column contains numeric data, why not change it to the correct type? It might solve other issues in the future.
– Gabriel C.
Dec 3 at 14:14




1




1




@GabrielC. Fixing the data is the way to go if there is no other system/user depending on the current setting and the data is never refreshed from an external source.
– JGH
Dec 3 at 14:19




@GabrielC. Fixing the data is the way to go if there is no other system/user depending on the current setting and the data is never refreshed from an external source.
– JGH
Dec 3 at 14:19












That's sensible. +1.
– Gabriel C.
Dec 3 at 14:21




That's sensible. +1.
– Gabriel C.
Dec 3 at 14:21


















draft saved

draft discarded




















































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.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • 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.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f304730%2fchanging-field-types-so-graduated-symbols-are-available%23new-answer', 'question_page');
}
);

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







-

Popular posts from this blog

Probability when a professor distributes a quiz and homework assignment to a class of n students.

Image
0 0 $begingroup$ Need help with this problem. Suppose our lazy professor collects a quiz and a homework assignment from a class of n students one day, then distributes both the quizzes and the homework assignments back to the class in a random fashion for grading. Each student receives one quiz and one homework assignment to grade. (a) What is the probability that every student receives someone else's quiz to grade, and someone else's homework to grade? (b) What is the probability that no student receives both their own quiz and their own homework assignment to grade? In this case, some students may receive their own quiz, and others may receive their own homework assignment. (c) Compute the limiting probability as n approaches infinity in each case. ...
Read more

Aardman Animations

Image
Aardman Animations, Ltd. Aardman Animations Tipo privada Atividade Animação em stop-motion , Animação em CGI Fundação 1972 Fundador(es) Peter Lord David Sproxton Sede Bristol, Inglaterra  Reino Unido Proprietário(s) Dreamworks Pessoas-chave Peter Lord David Sproxton Nick Park Divisões Aardman Features Aardman Digital Aardman Commercials Aardman Broadcast Aardman International Aardman Rights Aardman Effects Aardman 3-D Systems Aardman Nathan Love AardBoiled Website oficial aardman.com ...
Read more

Are they similar matrix

Image
0 $begingroup$ Do $begin{bmatrix} 0&i&0\0&0&1\0&0&0 end{bmatrix} $ and $begin{bmatrix} 0&0&0\-i&0&0\0&1&0 end{bmatrix} $ are similar.Is this True/false Clearly both are nilpotent and one is conjucate transpose of other but how to know if they are similar.i'm stuck. Please help me linear-algebra vector-spaces eigenvalues-eigenvectors generalizedeigenvector share | cite | improve this question edited Dec 10 '18 at 6:38 Vasanth Kris asked Dec 10 '18 at 6:19 ...
Read more