How to show two sets of points from two different fields in QGIS? Planned maintenance...

Is Bran literally the world's memory?

/bin/ls sorts differently than just ls

Why did Bronn offer to be Tyrion Lannister's champion in trial by combat?

Is it OK if I do not take the receipt in Germany?

Suing a Police Officer Instead of the Police Department

Assertions In A Mock Callout Test

Is Vivien of the Wilds + Wilderness Reclamation a competitive combo?

What *exactly* is electrical current, voltage, and resistance?

Sorting the characters in a utf-16 string in java

What kind of equipment or other technology is necessary to photograph sprites (atmospheric phenomenon)

What is the evidence that custom checks in Northern Ireland are going to result in violence?

Why aren't road bike wheels tiny?

Help Recreating a Table

How to break 信じようとしていただけかも知れない into separate parts?

How is an IPA symbol that lacks a name (e.g. ɲ) called?

“Since the train was delayed for more than an hour, passengers were given a full refund.” – Why is there no article before “passengers”?

Im stuck and having trouble with ¬P ∨ Q Prove: P → Q

Why does my GNOME settings mention "Moto C Plus"?

Providing direct feedback to a product salesperson

Does the Pact of the Blade warlock feature allow me to customize the properties of the pact weapon I create?

Why these surprising proportionalities of integrals involving odd zeta values?

What helicopter has the most rotor blades?

Does traveling In The United States require a passport or can I use my green card if not a US citizen?

Trying to enter the Fox's den



How to show two sets of points from two different fields in QGIS?



Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?How to select two points on a map using QGIS?Drawing lines from two points in CSV using QGIS?How to compare two sets of points in QGIS?How to show two layers with different projections in QGISJoining data from two shapefiles in QGISSumming values from different intersecting/overlapping points in QGISQGIS Find distance between specific sets of points between two different point layersHow to display elevation points from point layer as in 3 different group/classes in qgis?QGIS Attribute table - How to merge the values of $area field of several elements by the same attribute (point ID)?Estimate the spatial relationship between two sets of points





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}







0















I made a union of two adjacent shp (points) files with the same theme (Geochemistry) so the resulting attribute table gave duplicated fields, for example: ID, As_ppm, Ag_ppm, Pb_ppm, ... , ID_2, As_ppm_2, Ag_ppm_2, Pb_ppm_2,...
And the elements of the first shp give 'NULL' in the fields of the second shp and vice-versa, As in the screenshot.
enter image description here
So my goal is to show the combined points for a speciffic element, say Arsenic, so I have tried, without success, expressions like As_ppm || As_ppm_2 , As_ppm + As_ppm_2, combine(As_ppm ,As_ppm_2).










share|improve this question































    0















    I made a union of two adjacent shp (points) files with the same theme (Geochemistry) so the resulting attribute table gave duplicated fields, for example: ID, As_ppm, Ag_ppm, Pb_ppm, ... , ID_2, As_ppm_2, Ag_ppm_2, Pb_ppm_2,...
    And the elements of the first shp give 'NULL' in the fields of the second shp and vice-versa, As in the screenshot.
    enter image description here
    So my goal is to show the combined points for a speciffic element, say Arsenic, so I have tried, without success, expressions like As_ppm || As_ppm_2 , As_ppm + As_ppm_2, combine(As_ppm ,As_ppm_2).










    share|improve this question



























      0












      0








      0








      I made a union of two adjacent shp (points) files with the same theme (Geochemistry) so the resulting attribute table gave duplicated fields, for example: ID, As_ppm, Ag_ppm, Pb_ppm, ... , ID_2, As_ppm_2, Ag_ppm_2, Pb_ppm_2,...
      And the elements of the first shp give 'NULL' in the fields of the second shp and vice-versa, As in the screenshot.
      enter image description here
      So my goal is to show the combined points for a speciffic element, say Arsenic, so I have tried, without success, expressions like As_ppm || As_ppm_2 , As_ppm + As_ppm_2, combine(As_ppm ,As_ppm_2).










      share|improve this question
















      I made a union of two adjacent shp (points) files with the same theme (Geochemistry) so the resulting attribute table gave duplicated fields, for example: ID, As_ppm, Ag_ppm, Pb_ppm, ... , ID_2, As_ppm_2, Ag_ppm_2, Pb_ppm_2,...
      And the elements of the first shp give 'NULL' in the fields of the second shp and vice-versa, As in the screenshot.
      enter image description here
      So my goal is to show the combined points for a speciffic element, say Arsenic, so I have tried, without success, expressions like As_ppm || As_ppm_2 , As_ppm + As_ppm_2, combine(As_ppm ,As_ppm_2).







      qgis shapefile point attribute-table map-algebra






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 6 mins ago









      Vince

      14.8k32850




      14.8k32850










      asked 1 hour ago









      cavereapercavereaper

      133




      133






















          1 Answer
          1






          active

          oldest

          votes


















          0














          Union (geoprocessing) feature make a "union" of 2 dataset (C = A united to B).
          Probably you are tring to JOIN two dataset.



          Try this:




          1. Go to JOIN settings: (right click -> properties -> Join)

          2. Add Vector Join of the second layer (click on "+" green-plus icon) and set these parameters:


            • Join Layer: "the second layer to join"

            • Join field: "ID"

            • Join Target: "ID"




          We assume that "ID" is and unambiguous identifier for both the layer's elements.





          share
























            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


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f319551%2fhow-to-show-two-sets-of-points-from-two-different-fields-in-qgis%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









            0














            Union (geoprocessing) feature make a "union" of 2 dataset (C = A united to B).
            Probably you are tring to JOIN two dataset.



            Try this:




            1. Go to JOIN settings: (right click -> properties -> Join)

            2. Add Vector Join of the second layer (click on "+" green-plus icon) and set these parameters:


              • Join Layer: "the second layer to join"

              • Join field: "ID"

              • Join Target: "ID"




            We assume that "ID" is and unambiguous identifier for both the layer's elements.





            share




























              0














              Union (geoprocessing) feature make a "union" of 2 dataset (C = A united to B).
              Probably you are tring to JOIN two dataset.



              Try this:




              1. Go to JOIN settings: (right click -> properties -> Join)

              2. Add Vector Join of the second layer (click on "+" green-plus icon) and set these parameters:


                • Join Layer: "the second layer to join"

                • Join field: "ID"

                • Join Target: "ID"




              We assume that "ID" is and unambiguous identifier for both the layer's elements.





              share


























                0












                0








                0







                Union (geoprocessing) feature make a "union" of 2 dataset (C = A united to B).
                Probably you are tring to JOIN two dataset.



                Try this:




                1. Go to JOIN settings: (right click -> properties -> Join)

                2. Add Vector Join of the second layer (click on "+" green-plus icon) and set these parameters:


                  • Join Layer: "the second layer to join"

                  • Join field: "ID"

                  • Join Target: "ID"




                We assume that "ID" is and unambiguous identifier for both the layer's elements.





                share













                Union (geoprocessing) feature make a "union" of 2 dataset (C = A united to B).
                Probably you are tring to JOIN two dataset.



                Try this:




                1. Go to JOIN settings: (right click -> properties -> Join)

                2. Add Vector Join of the second layer (click on "+" green-plus icon) and set these parameters:


                  • Join Layer: "the second layer to join"

                  • Join field: "ID"

                  • Join Target: "ID"




                We assume that "ID" is and unambiguous identifier for both the layer's elements.






                share











                share


                share










                answered 3 mins ago









                gianfranco di pietrogianfranco di pietro

                134




                134






























                    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.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f319551%2fhow-to-show-two-sets-of-points-from-two-different-fields-in-qgis%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

                    Щит и меч (фильм) Содержание Названия серий | Сюжет |...

                    is 'sed' thread safeWhat should someone know about using Python scripts in the shell?Nexenta bash script uses...

                    Meter-Bus Содержание Параметры шины | Стандартизация |...