Differentiate between line ending within polygon and line passing all the way through polygon - QGIS Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Documentation “Join Attributes by Location” QGIS 2.18Create polygon layer from polyline layerSort polygons from north to south in QGIS using 'graphical modeler'?The select-by-location tool of ArcMap won't work properly!Using QGIS to find and calculate parts of polylines within polygon?What is the most efficient way to do a spatial join of all raster points within a polygon layer area?Calculating shortest distance between points within polygon using QGIS?How to delete from mutipolygons all but the biggest polygon in QGISHow to only select lines (geometry features) going through a polygon?Sorting by row already pre-selected polygons by location by line?Prevent user from creating self intersected polygons

Is it ethical to give a final exam after the professor has quit before teaching the remaining chapters of the course?

How to answer "Have you ever been terminated?"

2001: A Space Odyssey's use of the song "Daisy Bell" (Bicycle Built for Two); life imitates art or vice-versa?

Is there a holomorphic function on open unit disc with this property?

Is safe to use va_start macro with this as parameter?

Do square wave exist?

How to find 'n' nodes where all distances between them are greater than 'k'?

How to show element name in portuguese using elements package?

Is the Standard Deduction better than Itemized when both are the same amount?

How to react to hostile behavior from a senior developer?

How do I find out the mythology and history of my Fortress?

How come Sam didn't become Lord of Horn Hill?

What do you call the main part of a joke?

Why wasn't DOSKEY integrated with COMMAND.COM?

Why are both D and D# fitting into my E minor key?

また usage in a dictionary

Circuit to "zoom in" on mV fluctuations of a DC signal?

Do I really need recursive chmod to restrict access to a folder?

What causes the direction of lightning flashes?

Denied boarding although I have proper visa and documentation. To whom should I make a complaint?

Can an alien society believe that their star system is the universe?

Impact on credit score of opening and closing accounts

What are the out-of-universe reasons for the references to Toby Maguire-era Spider-Man in ITSV

Withdrew £2800, but only £2000 shows as withdrawn on online banking; what are my obligations?



Differentiate between line ending within polygon and line passing all the way through polygon - QGIS



Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?Documentation “Join Attributes by Location” QGIS 2.18Create polygon layer from polyline layerSort polygons from north to south in QGIS using 'graphical modeler'?The select-by-location tool of ArcMap won't work properly!Using QGIS to find and calculate parts of polylines within polygon?What is the most efficient way to do a spatial join of all raster points within a polygon layer area?Calculating shortest distance between points within polygon using QGIS?How to delete from mutipolygons all but the biggest polygon in QGISHow to only select lines (geometry features) going through a polygon?Sorting by row already pre-selected polygons by location by line?Prevent user from creating self intersected polygons



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








3















I have a line file and a polygon file in QGIS.



Primarily I am looking for any polygon that has a line intersecting it - easy, sorted.



From these intersects, I then want to pull out just the polygons that have a line going all the way through them and ignore those where the line ends within the polygon. See the below diagram for an explanation: I only want polygons 2 and 3.



Example



Does that make sense? I haven't managed to find any predefined tools thus far.










share|improve this question






























    3















    I have a line file and a polygon file in QGIS.



    Primarily I am looking for any polygon that has a line intersecting it - easy, sorted.



    From these intersects, I then want to pull out just the polygons that have a line going all the way through them and ignore those where the line ends within the polygon. See the below diagram for an explanation: I only want polygons 2 and 3.



    Example



    Does that make sense? I haven't managed to find any predefined tools thus far.










    share|improve this question


























      3












      3








      3








      I have a line file and a polygon file in QGIS.



      Primarily I am looking for any polygon that has a line intersecting it - easy, sorted.



      From these intersects, I then want to pull out just the polygons that have a line going all the way through them and ignore those where the line ends within the polygon. See the below diagram for an explanation: I only want polygons 2 and 3.



      Example



      Does that make sense? I haven't managed to find any predefined tools thus far.










      share|improve this question
















      I have a line file and a polygon file in QGIS.



      Primarily I am looking for any polygon that has a line intersecting it - easy, sorted.



      From these intersects, I then want to pull out just the polygons that have a line going all the way through them and ignore those where the line ends within the polygon. See the below diagram for an explanation: I only want polygons 2 and 3.



      Example



      Does that make sense? I haven't managed to find any predefined tools thus far.







      qgis select-by-location






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Apr 10 at 10:29









      Taras

      2,3703730




      2,3703730










      asked Apr 10 at 8:33









      JClarksonJClarkson

      426




      426




















          1 Answer
          1






          active

          oldest

          votes


















          5















          Tested on QGIS 2.18




          I can suggest using a "Virtual Layer" through Layer > Add Layer > Add/Edit Virtual Layer...



          Let's assume we have two layers, namely "lines_test" and "polygons"



          Input



          With using this query you may achieve the result you are looking for.



          SELECT *
          FROM polygons
          WHERE polygons.id NOT IN (
          SELECT polygons.id
          FROM polygons, lines_test
          WHERE ST_Within(ST_StartPoint(lines_test.geometry), polygons.geometry) OR ST_Within(ST_EndPoint(lines_test.geometry), polygons.geometry)
          )


          Output




          References:



          • PostGIS – Opposite of ST_Within


          • Chapter 8. PostGIS Reference | 8.5. Geometry Accessors


          • Documentation “Join Attributes by Location” QGIS 2.18






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



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318335%2fdifferentiate-between-line-ending-within-polygon-and-line-passing-all-the-way-th%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









            5















            Tested on QGIS 2.18




            I can suggest using a "Virtual Layer" through Layer > Add Layer > Add/Edit Virtual Layer...



            Let's assume we have two layers, namely "lines_test" and "polygons"



            Input



            With using this query you may achieve the result you are looking for.



            SELECT *
            FROM polygons
            WHERE polygons.id NOT IN (
            SELECT polygons.id
            FROM polygons, lines_test
            WHERE ST_Within(ST_StartPoint(lines_test.geometry), polygons.geometry) OR ST_Within(ST_EndPoint(lines_test.geometry), polygons.geometry)
            )


            Output




            References:



            • PostGIS – Opposite of ST_Within


            • Chapter 8. PostGIS Reference | 8.5. Geometry Accessors


            • Documentation “Join Attributes by Location” QGIS 2.18






            share|improve this answer





























              5















              Tested on QGIS 2.18




              I can suggest using a "Virtual Layer" through Layer > Add Layer > Add/Edit Virtual Layer...



              Let's assume we have two layers, namely "lines_test" and "polygons"



              Input



              With using this query you may achieve the result you are looking for.



              SELECT *
              FROM polygons
              WHERE polygons.id NOT IN (
              SELECT polygons.id
              FROM polygons, lines_test
              WHERE ST_Within(ST_StartPoint(lines_test.geometry), polygons.geometry) OR ST_Within(ST_EndPoint(lines_test.geometry), polygons.geometry)
              )


              Output




              References:



              • PostGIS – Opposite of ST_Within


              • Chapter 8. PostGIS Reference | 8.5. Geometry Accessors


              • Documentation “Join Attributes by Location” QGIS 2.18






              share|improve this answer



























                5












                5








                5








                Tested on QGIS 2.18




                I can suggest using a "Virtual Layer" through Layer > Add Layer > Add/Edit Virtual Layer...



                Let's assume we have two layers, namely "lines_test" and "polygons"



                Input



                With using this query you may achieve the result you are looking for.



                SELECT *
                FROM polygons
                WHERE polygons.id NOT IN (
                SELECT polygons.id
                FROM polygons, lines_test
                WHERE ST_Within(ST_StartPoint(lines_test.geometry), polygons.geometry) OR ST_Within(ST_EndPoint(lines_test.geometry), polygons.geometry)
                )


                Output




                References:



                • PostGIS – Opposite of ST_Within


                • Chapter 8. PostGIS Reference | 8.5. Geometry Accessors


                • Documentation “Join Attributes by Location” QGIS 2.18






                share|improve this answer
















                Tested on QGIS 2.18




                I can suggest using a "Virtual Layer" through Layer > Add Layer > Add/Edit Virtual Layer...



                Let's assume we have two layers, namely "lines_test" and "polygons"



                Input



                With using this query you may achieve the result you are looking for.



                SELECT *
                FROM polygons
                WHERE polygons.id NOT IN (
                SELECT polygons.id
                FROM polygons, lines_test
                WHERE ST_Within(ST_StartPoint(lines_test.geometry), polygons.geometry) OR ST_Within(ST_EndPoint(lines_test.geometry), polygons.geometry)
                )


                Output




                References:



                • PostGIS – Opposite of ST_Within


                • Chapter 8. PostGIS Reference | 8.5. Geometry Accessors


                • Documentation “Join Attributes by Location” QGIS 2.18







                share|improve this answer














                share|improve this answer



                share|improve this answer








                edited Apr 10 at 10:52

























                answered Apr 10 at 9:03









                TarasTaras

                2,3703730




                2,3703730



























                    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%2f318335%2fdifferentiate-between-line-ending-within-polygon-and-line-passing-all-the-way-th%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

                    រឿង រ៉ូមេអូ និង ហ្ស៊ុយលីយេ សង្ខេបរឿង តួអង្គ បញ្ជីណែនាំ

                    Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given

                    Romeo and Juliet ContentsCharactersSynopsisSourcesDate and textThemes and motifsCriticism and interpretationLegacyScene by sceneSee alsoNotes and referencesSourcesExternal linksNavigation menu"Consumer Price Index (estimate) 1800–"10.2307/28710160037-3222287101610.1093/res/II.5.31910.2307/45967845967810.2307/2869925286992510.1525/jams.1982.35.3.03a00050"Dada Masilo: South African dancer who breaks the rules"10.1093/res/os-XV.57.1610.2307/28680942868094"Sweet Sorrow: Mann-Korman's Romeo and Juliet Closes Sept. 5 at MN's Ordway"the original10.2307/45957745957710.1017/CCOL0521570476.009"Ram Leela box office collections hit massive Rs 100 crore, pulverises prediction"Archived"Broadway Revival of Romeo and Juliet, Starring Orlando Bloom and Condola Rashad, Will Close Dec. 8"Archived10.1075/jhp.7.1.04hon"Wherefore art thou, Romeo? To make us laugh at Navy Pier"the original10.1093/gmo/9781561592630.article.O006772"Ram-leela Review Roundup: Critics Hail Film as Best Adaptation of Romeo and Juliet"Archived10.2307/31946310047-77293194631"Romeo and Juliet get Twitter treatment""Juliet's Nurse by Lois Leveen""Romeo and Juliet: Orlando Bloom's Broadway Debut Released in Theaters for Valentine's Day"Archived"Romeo and Juliet Has No Balcony"10.1093/gmo/9781561592630.article.O00778110.2307/2867423286742310.1076/enst.82.2.115.959510.1080/00138380601042675"A plague o' both your houses: error in GCSE exam paper forces apology""Juliet of the Five O'Clock Shadow, and Other Wonders"10.2307/33912430027-4321339124310.2307/28487440038-7134284874410.2307/29123140149-661129123144728341M"Weekender Guide: Shakespeare on The Drive""balcony"UK public library membership"romeo"UK public library membership10.1017/CCOL9780521844291"Post-Zionist Critique on Israel and the Palestinians Part III: Popular Culture"10.2307/25379071533-86140377-919X2537907"Capulets and Montagues: UK exam board admit mixing names up in Romeo and Juliet paper"Istoria Novellamente Ritrovata di Due Nobili Amanti2027/mdp.390150822329610820-750X"GCSE exam error: Board accidentally rewrites Shakespeare"10.2307/29176390149-66112917639"Exam board apologises after error in English GCSE paper which confused characters in Shakespeare's Romeo and Juliet""From Mariotto and Ganozza to Romeo and Guilietta: Metamorphoses of a Renaissance Tale"10.2307/37323537323510.2307/2867455286745510.2307/28678912867891"10 Questions for Taylor Swift"10.2307/28680922868092"Haymarket Theatre""The Zeffirelli Way: Revealing Talk by Florentine Director""Michael Smuin: 1938-2007 / Prolific dance director had showy career"The Life and Art of Edwin BoothRomeo and JulietRomeo and JulietRomeo and JulietRomeo and JulietEasy Read Romeo and JulietRomeo and Julieteeecb12003684p(data)4099369-3n8211610759dbe00d-a9e2-41a3-b2c1-977dd692899302814385X313670221313670221