Differentiate between line ending within polygon and line passing all the way through polygon - QGIS The 2019 Stack Overflow Developer Survey Results Are InDocumentation “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
Button changing it's text & action. Good or terrible?
How to answer pointed "are you quitting" questioning when I don't want them to suspect
Is this app Icon Browser Safe/Legit?
Are there incongruent pythagorean triangles with the same perimeter and same area?
Statement true because not provable
Why do UK politicians seemingly ignore opinion polls on Brexit?
Apparent duplicates between Haynes service instructions and MOT
What does ひと匙 mean in this manga and has it been used colloquially?
Who coined the term "madman theory"?
What could be the right powersource for 15 seconds lifespan disposable giant chainsaw?
Earliest use of the term "Galois extension"?
Is an up-to-date browser secure on an out-of-date OS?
Does the shape of a die affect the probability of a number being rolled?
Identify This Plant (Flower)
Is flight data recorder erased after every flight?
Resizing object distorts it (Illustrator CC 2018)
I see my dog run
What do hard-Brexiteers want with respect to the Irish border?
Am I thawing this London Broil safely?
Identify boardgame from Big movie
Are children permitted to help build the Beis Hamikdash?
Have you ever entered Singapore using a different passport or name?
Geography at the pixel level
Falsification in Math vs Science
Differentiate between line ending within polygon and line passing all the way through polygon - QGIS
The 2019 Stack Overflow Developer Survey Results Are InDocumentation “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;
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
edited 11 hours ago
Taras
2,2783729
asked 13 hours ago
JClarksonJClarkson
406
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
edited 11 hours ago
Taras
2,2783729
asked 13 hours ago
JClarksonJClarkson
406
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
edited 11 hours ago
Taras
2,2783729
asked 13 hours ago
JClarksonJClarkson
406
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
qgis select-by-location
edited 11 hours ago
Taras
2,2783729
asked 13 hours ago
JClarksonJClarkson
406
edited 11 hours ago
Taras
2,2783729
asked 13 hours ago
JClarksonJClarkson
406
edited 11 hours ago
Taras
2,2783729
edited 11 hours ago
Taras
2,2783729
edited 11 hours ago
Taras
2,2783729
2,2783729
asked 13 hours ago
JClarksonJClarkson
406
asked 13 hours ago
JClarksonJClarkson
406
asked 13 hours ago
JClarksonJClarkson
406
406
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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
answered 13 hours ago
TarasTaras
2,2783729
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
);
);
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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
answered 13 hours ago
TarasTaras
2,2783729
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
answered 13 hours ago
TarasTaras
2,2783729
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
answered 13 hours ago
TarasTaras
2,2783729
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
answered 13 hours ago
TarasTaras
2,2783729
edited 11 hours ago
answered 13 hours ago
TarasTaras
2,2783729
answered 13 hours ago
TarasTaras
2,2783729
answered 13 hours ago
TarasTaras
2,2783729
2,2783729
add a comment |
add a comment |
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.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
