Polygons not containing other polygons

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
1
down vote

favorite












I have two large polygon data-sets, one highlights the building footprints and one indicating parcel outlines. I want to find all parcels without a building on them. Essentially all parcel A's which do not contain a parcel B. Is the Spatial query, select by location the best way to do this? The files are very large and often crash.










share|improve this question









New contributor




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



















  • Welcome to GIS SE. If you have not done so, please take the tour to learn about our focused Q&A format. Please edit your question to detail what you have tried, and if you are seeing crashes, please include any crash messages.
    – Andy
    3 hours ago














up vote
1
down vote

favorite












I have two large polygon data-sets, one highlights the building footprints and one indicating parcel outlines. I want to find all parcels without a building on them. Essentially all parcel A's which do not contain a parcel B. Is the Spatial query, select by location the best way to do this? The files are very large and often crash.










share|improve this question









New contributor




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



















  • Welcome to GIS SE. If you have not done so, please take the tour to learn about our focused Q&A format. Please edit your question to detail what you have tried, and if you are seeing crashes, please include any crash messages.
    – Andy
    3 hours ago












up vote
1
down vote

favorite









up vote
1
down vote

favorite











I have two large polygon data-sets, one highlights the building footprints and one indicating parcel outlines. I want to find all parcels without a building on them. Essentially all parcel A's which do not contain a parcel B. Is the Spatial query, select by location the best way to do this? The files are very large and often crash.










share|improve this question









New contributor




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











I have two large polygon data-sets, one highlights the building footprints and one indicating parcel outlines. I want to find all parcels without a building on them. Essentially all parcel A's which do not contain a parcel B. Is the Spatial query, select by location the best way to do this? The files are very large and often crash.







qgis select-by-location






share|improve this question









New contributor




ADN FRS 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




ADN FRS 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 2 hours ago









Kadir

3,92011226




3,92011226






New contributor




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









asked 3 hours ago









ADN FRS

61




61




New contributor




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





New contributor





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






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











  • Welcome to GIS SE. If you have not done so, please take the tour to learn about our focused Q&A format. Please edit your question to detail what you have tried, and if you are seeing crashes, please include any crash messages.
    – Andy
    3 hours ago
















  • Welcome to GIS SE. If you have not done so, please take the tour to learn about our focused Q&A format. Please edit your question to detail what you have tried, and if you are seeing crashes, please include any crash messages.
    – Andy
    3 hours ago















Welcome to GIS SE. If you have not done so, please take the tour to learn about our focused Q&A format. Please edit your question to detail what you have tried, and if you are seeing crashes, please include any crash messages.
– Andy
3 hours ago




Welcome to GIS SE. If you have not done so, please take the tour to learn about our focused Q&A format. Please edit your question to detail what you have tried, and if you are seeing crashes, please include any crash messages.
– Andy
3 hours ago










2 Answers
2






active

oldest

votes

















up vote
2
down vote













Yes, Select by location is the right tool. (In this example I used Extract by location but they are essentially the same).



To reduce QGIS' burden, we can:



  1. Process data without showing the layers on the map canvas

  2. Perform only one task at one time.

For example:



(1) Consider we want to extract Parcel 103 (no buildings).



enter image description here



(2) Restart QGIS (or just remove all layers) to empty the map area.



(3) Activate Extract by location (under Processing Toolbox | Vector selection tools).



enter image description here



  1. Click on the ... button and select parcel data.

  2. Click on the ... button and select buildings data.

  3. Select disjoint for the Geometric predicate.

  4. Run the too..

(4) We will get new Extracted layer.



enter image description here



I echo ThingumaBob that you may as well consider changing data provider.






share|improve this answer




















  • +1 - I usually use any form of SQL over built in tools and finding non-intersections is a bit of a pain (e.g. using plain ST_Disjoint on two tables results in a cross product etc.); if QGIS handles that elegantly, better use this than my suggestion.
    – ThingumaBob
    16 mins ago

















up vote
1
down vote













I think you could



  • select all features of your polygon layer


  • run an intersection filter via Select by location on selected features


  • choose Removing from current selection


Main point:



If those files (shapefiles?) are large enough to crash QGIS, consider moving to GeoPackage, or PostGIS even.






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',
    convertImagesToLinks: false,
    noModals: false,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );






    ADN FRS 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%2f298744%2fpolygons-not-containing-other-polygons%23new-answer', 'question_page');

    );

    Post as a guest






























    2 Answers
    2






    active

    oldest

    votes








    2 Answers
    2






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    2
    down vote













    Yes, Select by location is the right tool. (In this example I used Extract by location but they are essentially the same).



    To reduce QGIS' burden, we can:



    1. Process data without showing the layers on the map canvas

    2. Perform only one task at one time.

    For example:



    (1) Consider we want to extract Parcel 103 (no buildings).



    enter image description here



    (2) Restart QGIS (or just remove all layers) to empty the map area.



    (3) Activate Extract by location (under Processing Toolbox | Vector selection tools).



    enter image description here



    1. Click on the ... button and select parcel data.

    2. Click on the ... button and select buildings data.

    3. Select disjoint for the Geometric predicate.

    4. Run the too..

    (4) We will get new Extracted layer.



    enter image description here



    I echo ThingumaBob that you may as well consider changing data provider.






    share|improve this answer




















    • +1 - I usually use any form of SQL over built in tools and finding non-intersections is a bit of a pain (e.g. using plain ST_Disjoint on two tables results in a cross product etc.); if QGIS handles that elegantly, better use this than my suggestion.
      – ThingumaBob
      16 mins ago














    up vote
    2
    down vote













    Yes, Select by location is the right tool. (In this example I used Extract by location but they are essentially the same).



    To reduce QGIS' burden, we can:



    1. Process data without showing the layers on the map canvas

    2. Perform only one task at one time.

    For example:



    (1) Consider we want to extract Parcel 103 (no buildings).



    enter image description here



    (2) Restart QGIS (or just remove all layers) to empty the map area.



    (3) Activate Extract by location (under Processing Toolbox | Vector selection tools).



    enter image description here



    1. Click on the ... button and select parcel data.

    2. Click on the ... button and select buildings data.

    3. Select disjoint for the Geometric predicate.

    4. Run the too..

    (4) We will get new Extracted layer.



    enter image description here



    I echo ThingumaBob that you may as well consider changing data provider.






    share|improve this answer




















    • +1 - I usually use any form of SQL over built in tools and finding non-intersections is a bit of a pain (e.g. using plain ST_Disjoint on two tables results in a cross product etc.); if QGIS handles that elegantly, better use this than my suggestion.
      – ThingumaBob
      16 mins ago












    up vote
    2
    down vote










    up vote
    2
    down vote









    Yes, Select by location is the right tool. (In this example I used Extract by location but they are essentially the same).



    To reduce QGIS' burden, we can:



    1. Process data without showing the layers on the map canvas

    2. Perform only one task at one time.

    For example:



    (1) Consider we want to extract Parcel 103 (no buildings).



    enter image description here



    (2) Restart QGIS (or just remove all layers) to empty the map area.



    (3) Activate Extract by location (under Processing Toolbox | Vector selection tools).



    enter image description here



    1. Click on the ... button and select parcel data.

    2. Click on the ... button and select buildings data.

    3. Select disjoint for the Geometric predicate.

    4. Run the too..

    (4) We will get new Extracted layer.



    enter image description here



    I echo ThingumaBob that you may as well consider changing data provider.






    share|improve this answer












    Yes, Select by location is the right tool. (In this example I used Extract by location but they are essentially the same).



    To reduce QGIS' burden, we can:



    1. Process data without showing the layers on the map canvas

    2. Perform only one task at one time.

    For example:



    (1) Consider we want to extract Parcel 103 (no buildings).



    enter image description here



    (2) Restart QGIS (or just remove all layers) to empty the map area.



    (3) Activate Extract by location (under Processing Toolbox | Vector selection tools).



    enter image description here



    1. Click on the ... button and select parcel data.

    2. Click on the ... button and select buildings data.

    3. Select disjoint for the Geometric predicate.

    4. Run the too..

    (4) We will get new Extracted layer.



    enter image description here



    I echo ThingumaBob that you may as well consider changing data provider.







    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered 2 hours ago









    Kazuhito

    12.7k31472




    12.7k31472











    • +1 - I usually use any form of SQL over built in tools and finding non-intersections is a bit of a pain (e.g. using plain ST_Disjoint on two tables results in a cross product etc.); if QGIS handles that elegantly, better use this than my suggestion.
      – ThingumaBob
      16 mins ago
















    • +1 - I usually use any form of SQL over built in tools and finding non-intersections is a bit of a pain (e.g. using plain ST_Disjoint on two tables results in a cross product etc.); if QGIS handles that elegantly, better use this than my suggestion.
      – ThingumaBob
      16 mins ago















    +1 - I usually use any form of SQL over built in tools and finding non-intersections is a bit of a pain (e.g. using plain ST_Disjoint on two tables results in a cross product etc.); if QGIS handles that elegantly, better use this than my suggestion.
    – ThingumaBob
    16 mins ago




    +1 - I usually use any form of SQL over built in tools and finding non-intersections is a bit of a pain (e.g. using plain ST_Disjoint on two tables results in a cross product etc.); if QGIS handles that elegantly, better use this than my suggestion.
    – ThingumaBob
    16 mins ago












    up vote
    1
    down vote













    I think you could



    • select all features of your polygon layer


    • run an intersection filter via Select by location on selected features


    • choose Removing from current selection


    Main point:



    If those files (shapefiles?) are large enough to crash QGIS, consider moving to GeoPackage, or PostGIS even.






    share|improve this answer


























      up vote
      1
      down vote













      I think you could



      • select all features of your polygon layer


      • run an intersection filter via Select by location on selected features


      • choose Removing from current selection


      Main point:



      If those files (shapefiles?) are large enough to crash QGIS, consider moving to GeoPackage, or PostGIS even.






      share|improve this answer
























        up vote
        1
        down vote










        up vote
        1
        down vote









        I think you could



        • select all features of your polygon layer


        • run an intersection filter via Select by location on selected features


        • choose Removing from current selection


        Main point:



        If those files (shapefiles?) are large enough to crash QGIS, consider moving to GeoPackage, or PostGIS even.






        share|improve this answer














        I think you could



        • select all features of your polygon layer


        • run an intersection filter via Select by location on selected features


        • choose Removing from current selection


        Main point:



        If those files (shapefiles?) are large enough to crash QGIS, consider moving to GeoPackage, or PostGIS even.







        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited 1 hour ago

























        answered 3 hours ago









        ThingumaBob

        4,5181222




        4,5181222




















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









             

            draft saved


            draft discarded


















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












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











            ADN FRS 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%2f298744%2fpolygons-not-containing-other-polygons%23new-answer', 'question_page');

            );

            Post as a guest













































































            Comments

            Popular posts from this blog

            What does second last employer means? [closed]

            Installing NextGIS Connect into QGIS 3?

            One-line joke