Trjtdtk

What was Bran's plan to kill the Night King?

What are the differences between credential stuffing and password spraying?

Is there an official reason for not adding a post-credits scene?

Why did Thanos need his ship to help him in the battle scene?

How can stepwise movement be concordant?

Something that can be activated/enabled

Didn't attend field-specific conferences during my PhD; how much of a disadvantage is it?

Should I just decline the job offer?

Upside-Down Pyramid Addition...REVERSED!

Wrong answer from DSolve when solving a differential equation

Longest ringing/resonating object

Can there be a single technologically advanced nation, in a continent full of non-technologically advanced nations?

Is the set of non invertible matrices simply connected? What are their homotopy and homology groups?

Frequency of specific viral sequence in .BAM or .fastq

What does 'made on' mean here?

How can internet speed be 10 times slower without a router than when using a router?

Is there an idiom that support the idea that "inflation is bad"?

Will 700 more planes a day fly because of the Heathrow expansion?

Nominativ or Akkusativ

Emotional immaturity of comic-book version of superhero Shazam

What is a smasher?

I have a unique character that I'm having a problem writing. He's a virus!

Why are UK Bank Holidays on Mondays?

What are the advantages of luxury car brands like Acura/Lexus over their sibling non-luxury brands Honda/Toyota?

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

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.

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

qgis select-by-location

share|improve this question

edited Apr 10 at 10:29

Taras

2,3903730

asked Apr 10 at 8:33

JClarksonJClarkson

648

add a comment | 

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.

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

qgis select-by-location

share|improve this question

edited Apr 10 at 10:29

Taras

2,3903730

asked Apr 10 at 8:33

JClarksonJClarkson

648

add a comment | 

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.

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

qgis select-by-location

share|improve this question

edited Apr 10 at 10:29

Taras

2,3903730

asked Apr 10 at 8:33

JClarksonJClarkson

648

share|improve this question

edited Apr 10 at 10:29

Taras

2,3903730

asked Apr 10 at 8:33

JClarksonJClarkson

648

share|improve this question

edited Apr 10 at 10:29

Taras

2,3903730

asked Apr 10 at 8:33

JClarksonJClarkson

648

edited Apr 10 at 10:29

Taras

2,3903730

edited Apr 10 at 10:29

Taras

2,3903730

asked Apr 10 at 8:33

JClarksonJClarkson

648

asked Apr 10 at 8:33

JClarksonJClarkson

648

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"

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

---

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

edited Apr 10 at 10:52

answered Apr 10 at 9:03

TarasTaras

2,3903730

add a comment | 

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

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

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

Name

Email

Required, but never shown

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"

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

---

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

edited Apr 10 at 10:52

answered Apr 10 at 9:03

TarasTaras

2,3903730

add a comment | 

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"

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

---

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

edited Apr 10 at 10:52

answered Apr 10 at 9:03

TarasTaras

2,3903730

add a comment | 

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"

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

---

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

edited Apr 10 at 10:52

answered Apr 10 at 9:03

TarasTaras

2,3903730

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

share|improve this answer

edited Apr 10 at 10:52

answered Apr 10 at 9:03

TarasTaras

2,3903730

answered Apr 10 at 9:03

TarasTaras

2,3903730

answered Apr 10 at 9:03

TarasTaras

2,3903730