Assign a specific color to vector layer based on RGB codes in attribute table












3















I use QGIS and have a geological map for a large area. I present this after ID codes based on the geology ("Geokartnr" in photo).



I want to use international/nation color codes for each rock type, this way it will be comparable to other peoples work. The international colors is already added to the attribute table as a RGB code ("RGBfargko"). Is there any way I can sort/present the maps by "geokartnr" code and present this by the color codes in the RGB codes in the attribute table? Or do I need to change all colors manually?



Screenshot of the attribute table






qgis attribute-table visualisation vector-layer







share|improve this question









New contributor




Casairo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





















  • Be aware that by using an expression to set the color as stated answer below you wont be able to automatically generate a legend.... (so the problem is you either set the color manually OR create the legend manually....)

    – J.R
    yesterday











  • @J.R Good point, I think its kind of bug, because I suppose that it will generate legend if you use Categorized symbology (with rgb field as category). You can manually change a symbol of every each category, but if the data defined values are set for color, the value is just not taken from the expression. Or I am missing something?

    – Oto Kaláb
    yesterday


















3















I use QGIS and have a geological map for a large area. I present this after ID codes based on the geology ("Geokartnr" in photo).



I want to use international/nation color codes for each rock type, this way it will be comparable to other peoples work. The international colors is already added to the attribute table as a RGB code ("RGBfargko"). Is there any way I can sort/present the maps by "geokartnr" code and present this by the color codes in the RGB codes in the attribute table? Or do I need to change all colors manually?



Screenshot of the attribute table






qgis attribute-table visualisation vector-layer







share|improve this question









New contributor




Casairo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





















  • Be aware that by using an expression to set the color as stated answer below you wont be able to automatically generate a legend.... (so the problem is you either set the color manually OR create the legend manually....)

    – J.R
    yesterday











  • @J.R Good point, I think its kind of bug, because I suppose that it will generate legend if you use Categorized symbology (with rgb field as category). You can manually change a symbol of every each category, but if the data defined values are set for color, the value is just not taken from the expression. Or I am missing something?

    – Oto Kaláb
    yesterday
















3












3








3


1






I use QGIS and have a geological map for a large area. I present this after ID codes based on the geology ("Geokartnr" in photo).



I want to use international/nation color codes for each rock type, this way it will be comparable to other peoples work. The international colors is already added to the attribute table as a RGB code ("RGBfargko"). Is there any way I can sort/present the maps by "geokartnr" code and present this by the color codes in the RGB codes in the attribute table? Or do I need to change all colors manually?



Screenshot of the attribute table






qgis attribute-table visualisation vector-layer







share|improve this question









New contributor




Casairo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












I use QGIS and have a geological map for a large area. I present this after ID codes based on the geology ("Geokartnr" in photo).



I want to use international/nation color codes for each rock type, this way it will be comparable to other peoples work. The international colors is already added to the attribute table as a RGB code ("RGBfargko"). Is there any way I can sort/present the maps by "geokartnr" code and present this by the color codes in the RGB codes in the attribute table? Or do I need to change all colors manually?



Screenshot of the attribute table






qgis attribute-table visualisation vector-layer




qgis attribute-table visualisation vector-layer






share|improve this question









New contributor




Casairo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




Casairo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited yesterday









Ian Turton♦

49.9k547115




49.9k547115






New contributor




Casairo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked yesterday









CasairoCasairo

162




162




New contributor




Casairo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Casairo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Casairo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.













  • Be aware that by using an expression to set the color as stated answer below you wont be able to automatically generate a legend.... (so the problem is you either set the color manually OR create the legend manually....)

    – J.R
    yesterday











  • @J.R Good point, I think its kind of bug, because I suppose that it will generate legend if you use Categorized symbology (with rgb field as category). You can manually change a symbol of every each category, but if the data defined values are set for color, the value is just not taken from the expression. Or I am missing something?

    – Oto Kaláb
    yesterday





















  • Be aware that by using an expression to set the color as stated answer below you wont be able to automatically generate a legend.... (so the problem is you either set the color manually OR create the legend manually....)

    – J.R
    yesterday











  • @J.R Good point, I think its kind of bug, because I suppose that it will generate legend if you use Categorized symbology (with rgb field as category). You can manually change a symbol of every each category, but if the data defined values are set for color, the value is just not taken from the expression. Or I am missing something?

    – Oto Kaláb
    yesterday



















Be aware that by using an expression to set the color as stated answer below you wont be able to automatically generate a legend.... (so the problem is you either set the color manually OR create the legend manually....)

– J.R
yesterday





Be aware that by using an expression to set the color as stated answer below you wont be able to automatically generate a legend.... (so the problem is you either set the color manually OR create the legend manually....)

– J.R
yesterday













@J.R Good point, I think its kind of bug, because I suppose that it will generate legend if you use Categorized symbology (with rgb field as category). You can manually change a symbol of every each category, but if the data defined values are set for color, the value is just not taken from the expression. Or I am missing something?

– Oto Kaláb
yesterday







@J.R Good point, I think its kind of bug, because I suppose that it will generate legend if you use Categorized symbology (with rgb field as category). You can manually change a symbol of every each category, but if the data defined values are set for color, the value is just not taken from the expression. Or I am missing something?

– Oto Kaláb
yesterday












3 Answers
3






active

oldest

votes


















5














In the layer styles panel if you click on simple marker, there is a small box to the right of the fill color combo box - if you click on it you can select edit from the menu and enter the expression editor.



enter image description here
You will need an expression like this, to convert your string's spaces to commas and then into a colour:



color_rgb( replace("rgbfargeko",' ',','))


Then click ok and your colors should show up.






share|improve this answer


























  • You missed a closing bracket ).

    – ahmadhanb
    22 hours ago



















3














AS @J. Monticolo supposed, use Data defined expression in symbology properties.



enter image description here



For expression you can simply use:



replace("rgbfargko",' ',',')


Which takse "rgbfargko" string and replace spaces whit commas for proper color formatting. See:



enter image description here



enter image description here






share|improve this answer































    2














    In the layer properties, in the symbology tab, define the color by an expression (link to the QGIS doc) :



    color_rgb(
    
    array_get(string_to_array("rgbfargko", ' '), 0),
    
    array_get(string_to_array("rgbfargko", ' '), 1),
    
    array_get(string_to_array("rgbfargko", ' '), 2)
    
)


    Explanation of the code :



    1- function string_to_array : transform the field data into an array by splitting at the white space character ;
    2- function array_get : get elements of the array, the first item has an index of 0 ;
    3- function color_rgb : with 3 arguments (R, G, B), this function return a QGIS color.



    EDIT
    The solution of @Ian Turton is more visual and simple !






    share|improve this answer

























      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
      });


      }
      });






      Casairo is a new contributor. Be nice, and check out our Code of Conduct.










      draft saved

      draft discarded


















      StackExchange.ready(
      function () {
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f316218%2fassign-a-specific-color-to-vector-layer-based-on-rgb-codes-in-attribute-table%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









      5














      In the layer styles panel if you click on simple marker, there is a small box to the right of the fill color combo box - if you click on it you can select edit from the menu and enter the expression editor.



      enter image description here
      You will need an expression like this, to convert your string's spaces to commas and then into a colour:



      color_rgb( replace("rgbfargeko",' ',','))


      Then click ok and your colors should show up.






      share|improve this answer


























      • You missed a closing bracket ).

        – ahmadhanb
        22 hours ago
















      5














      In the layer styles panel if you click on simple marker, there is a small box to the right of the fill color combo box - if you click on it you can select edit from the menu and enter the expression editor.



      enter image description here
      You will need an expression like this, to convert your string's spaces to commas and then into a colour:



      color_rgb( replace("rgbfargeko",' ',','))


      Then click ok and your colors should show up.






      share|improve this answer


























      • You missed a closing bracket ).

        – ahmadhanb
        22 hours ago














      5












      5








      5







      In the layer styles panel if you click on simple marker, there is a small box to the right of the fill color combo box - if you click on it you can select edit from the menu and enter the expression editor.



      enter image description here
      You will need an expression like this, to convert your string's spaces to commas and then into a colour:



      color_rgb( replace("rgbfargeko",' ',','))


      Then click ok and your colors should show up.






      share|improve this answer















      In the layer styles panel if you click on simple marker, there is a small box to the right of the fill color combo box - if you click on it you can select edit from the menu and enter the expression editor.



      enter image description here
      You will need an expression like this, to convert your string's spaces to commas and then into a colour:



      color_rgb( replace("rgbfargeko",' ',','))


      Then click ok and your colors should show up.







      share|improve this answer














      share|improve this answer



      share|improve this answer








      edited 15 hours ago

























      answered yesterday









      Ian Turton♦Ian Turton

      49.9k547115




      49.9k547115













      • You missed a closing bracket ).

        – ahmadhanb
        22 hours ago



















      • You missed a closing bracket ).

        – ahmadhanb
        22 hours ago

















      You missed a closing bracket ).

      – ahmadhanb
      22 hours ago





      You missed a closing bracket ).

      – ahmadhanb
      22 hours ago













      3














      AS @J. Monticolo supposed, use Data defined expression in symbology properties.



      enter image description here



      For expression you can simply use:



      replace("rgbfargko",' ',',')


      Which takse "rgbfargko" string and replace spaces whit commas for proper color formatting. See:



      enter image description here



      enter image description here






      share|improve this answer




























        3














        AS @J. Monticolo supposed, use Data defined expression in symbology properties.



        enter image description here



        For expression you can simply use:



        replace("rgbfargko",' ',',')


        Which takse "rgbfargko" string and replace spaces whit commas for proper color formatting. See:



        enter image description here



        enter image description here






        share|improve this answer


























          3












          3








          3







          AS @J. Monticolo supposed, use Data defined expression in symbology properties.



          enter image description here



          For expression you can simply use:



          replace("rgbfargko",' ',',')


          Which takse "rgbfargko" string and replace spaces whit commas for proper color formatting. See:



          enter image description here



          enter image description here






          share|improve this answer













          AS @J. Monticolo supposed, use Data defined expression in symbology properties.



          enter image description here



          For expression you can simply use:



          replace("rgbfargko",' ',',')


          Which takse "rgbfargko" string and replace spaces whit commas for proper color formatting. See:



          enter image description here



          enter image description here







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered yesterday









          Oto KalábOto Kaláb

          4,11231431




          4,11231431























              2














              In the layer properties, in the symbology tab, define the color by an expression (link to the QGIS doc) :



              color_rgb(
              
    array_get(string_to_array("rgbfargko", ' '), 0),
              
    array_get(string_to_array("rgbfargko", ' '), 1),
              
    array_get(string_to_array("rgbfargko", ' '), 2)
              
)


              Explanation of the code :



              1- function string_to_array : transform the field data into an array by splitting at the white space character ;
              2- function array_get : get elements of the array, the first item has an index of 0 ;
              3- function color_rgb : with 3 arguments (R, G, B), this function return a QGIS color.



              EDIT
              The solution of @Ian Turton is more visual and simple !






              share|improve this answer






























                2














                In the layer properties, in the symbology tab, define the color by an expression (link to the QGIS doc) :



                color_rgb(
                
    array_get(string_to_array("rgbfargko", ' '), 0),
                
    array_get(string_to_array("rgbfargko", ' '), 1),
                
    array_get(string_to_array("rgbfargko", ' '), 2)
                
)


                Explanation of the code :



                1- function string_to_array : transform the field data into an array by splitting at the white space character ;
                2- function array_get : get elements of the array, the first item has an index of 0 ;
                3- function color_rgb : with 3 arguments (R, G, B), this function return a QGIS color.



                EDIT
                The solution of @Ian Turton is more visual and simple !






                share|improve this answer




























                  2












                  2








                  2







                  In the layer properties, in the symbology tab, define the color by an expression (link to the QGIS doc) :



                  color_rgb(
                  
    array_get(string_to_array("rgbfargko", ' '), 0),
                  
    array_get(string_to_array("rgbfargko", ' '), 1),
                  
    array_get(string_to_array("rgbfargko", ' '), 2)
                  
)


                  Explanation of the code :



                  1- function string_to_array : transform the field data into an array by splitting at the white space character ;
                  2- function array_get : get elements of the array, the first item has an index of 0 ;
                  3- function color_rgb : with 3 arguments (R, G, B), this function return a QGIS color.



                  EDIT
                  The solution of @Ian Turton is more visual and simple !






                  share|improve this answer















                  In the layer properties, in the symbology tab, define the color by an expression (link to the QGIS doc) :



                  color_rgb(
                  
    array_get(string_to_array("rgbfargko", ' '), 0),
                  
    array_get(string_to_array("rgbfargko", ' '), 1),
                  
    array_get(string_to_array("rgbfargko", ' '), 2)
                  
)


                  Explanation of the code :



                  1- function string_to_array : transform the field data into an array by splitting at the white space character ;
                  2- function array_get : get elements of the array, the first item has an index of 0 ;
                  3- function color_rgb : with 3 arguments (R, G, B), this function return a QGIS color.



                  EDIT
                  The solution of @Ian Turton is more visual and simple !







                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  edited yesterday

























                  answered yesterday









                  J. MonticoloJ. Monticolo

                  1,155217




                  1,155217






















                      Casairo is a new contributor. Be nice, and check out our Code of Conduct.










                      draft saved

                      draft discarded


















                      Casairo is a new contributor. Be nice, and check out our Code of Conduct.













                      Casairo is a new contributor. Be nice, and check out our Code of Conduct.












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




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function () {
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f316218%2fassign-a-specific-color-to-vector-layer-based-on-rgb-codes-in-attribute-table%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

                      數位音樂下載

                      Image
                      數位音樂下載 為非以「實體」方式來販賣音樂的相關產品，而使用數位格式如mp3、AAC等文件格式來進行銷售販賣的一种音乐产业形式。著名的數位音樂下載服務商有iTunes Store、RecoChoku、Google Play音乐和微软Zune等。数字音乐下载在二十一世纪初一度风靡全球， [1] [2] 使得传统唱片产业走向衰落，但其自身也在2010年代流媒体音乐服务如Apple Music、Spotify等的挤压下迅速失去市场份额。 [3] [4] 数字音乐下载有便于携带、传播迅速、制作简单成本低等优点，与流媒体音乐相比也能更好保障音乐人权益； [5] 但它同时很可能带来侵犯版权和滥用的情形， [6] 也给音乐产业带来了诸多不利影响。数字音乐下载为音乐人和乐迷提供了更加便捷直接的交流渠道，也一定程度上推动了网络音乐人的出现和独立音乐的迅速发展。 [7] 目录 1 历史 1.1 技术积淀（1987-2000） 1.2 出现与兴起（2000-2004） 1.3 唱片市场的颠覆者（2004-2007） 1.4 巅峰和衰落（2005-2013） 1.5 摇摇欲坠的现状与不可预知的明天（2014至今） 2 主要文件格式 2.1 PCM编码格式 2.1.1 WAV 2.1.2 APE 2.1.3 FLAC 2.2 苹果推出的无损文件格式 2.2.1 AIFF 2.2.2 ALAC 2.3 有损压缩格式 2.3.1 MP3 2.3.2 AAC 3 主要市场 3.1 iTunes Store 3.2 Google Play音乐商店 3.3 亚马逊音乐商店 3.4 部分其他音乐商店 4 影响与评价 4.1 对音乐产业的影响 4.2 对科技行业的影响 4.3 正面评价 4.4 负面评价 4.4.1 侵权问题 4.4.2 经营模式不明晰 4.4.3 不适应移动时代 4.5 文化现象 5 延伸阅读 6 参考资料 历史 苹果iTunes+iPod的软硬件搭配让数字音...
                      Read more

                      When can things happen in Etherscan, such as the picture below?

                      Image
                      2 I don't know why balance of the address is 0. when can this situation? etherscan balances share | improve this question asked yesterday Ru Hi Ru Hi 11 1 New contributor Ru Hi 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  |  ...
                      Read more

                      格利澤436b

                      Image
                      格利泽436b 太陽系外行星 太陽系外行星列表 艺术家笔下的格利泽436b 母恆星 母恆星 Gliese 436 星座 獅子座 赤經 ( α ) 11 h  42 m  11.0941 s [1] 赤緯 ( δ ) +26° 42′ 23.652″ [1] 距離 33.4 ly (10.2 pc) 光譜類型 M2.5 V [1] 軌道參數 半长轴 ( a ) 0.0291±0.0004 [2] AU 軌道離心率 ( e ) 0.150±0.012 [2] 公轉週期 ( P ) 2.643904±0.000005 [3] d (0.00723849 y) 軌道傾角 ( i ) 85.8 +0.21 −0.25 [3] ° 角距 ( θ ) 2.794 mas 近星點時間 ( T 0 ) 2,451,551.716 ±0.01 JD 半振幅 ( K ) 18.68±0.8 m/s 物理性质 质量 ( m ) 22.2±1.0 [2] M ⊕ 半徑 ( r ) 4.327±0.183 [2] [4] R ⊕ 密度 ( ρ ) 1.51 g cm -3 表面重力 ( g ) 1.18 g 溫度 ( T ) 712±36 [2] K 發現 發現時間 2004 發現者 巴特勒、沃格特、 馬西 et al. 發現方法 徑向速度、凌日法 發現地點 美國加利福尼亞州 發表論文 出版 其他名稱 Ross 905 b, GJ 436 b, [5] LTT 13213 b, GCTP 2704.10 b, LHS 310, AC+27:28217 b, Vyssotsky 616 b, HIP 57087 b, GEN# +9.80120068 b, LP 319-75 b, G 121-7 b, LSPM J1142+2642 b, 1RXS J114211.9+264328 b, ASCC 683818 b, G 147-68 b, UCAC2 41198281 b, BP...
                      Read more