Vjylku

Can I throw a longsword at someone?

Is above average number of years spent on PhD considered a red flag in future academia or industry positions?

Why use gamma over alpha radiation?

How to set letter above or below the symbol?

How does modal jazz use chord progressions?

Was credit for the black hole image misattributed?

What do I do if technical issues prevent me from filing my return on time?

What did Darwin mean by 'squib' here?

Need a suitable toxic chemical for a murder plot in my novel

Fishing simulator

Can a zero nonce be safely used with AES-GCM if the key is random and never used again?

Stopping real property loss from eroding embankment

What was the last x86 CPU that did not have the x87 floating-point unit built in?

How many things? AとBがふたつ

How do I keep my slimes from escaping their pens?

What is the order of Mitzvot in Rambam's Sefer Hamitzvot?

Why is "Captain Marvel" translated as male in Portugal?

What items from the Roman-age tech-level could be used to deter all creatures from entering a small area?

Can I add database to AWS RDS MySQL without creating new instance?

Replacing HDD with SSD; what about non-APFS/APFS?

What's the point in a preamp?

What do you call the holes in a flute?

Single author papers against my advisor's will?

Why does tar appear to skip file contents when output file is /dev/null?

Spatial joining two line layers and checking intersection in PostgreSQL/PostGIS

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

1

I have two line layers in PostgreSQL/PostGIS. I want to the select data which are not intersecting. When I am writing this query it is taking a lot of time. How can I make it faster and see the result?

SELECT Geometry into Qlayer5

FROM qlayer4, egmap_20170316_tmc_polyline

WHERE st_intersects(qlayer59.Geometry,egmap_20170316_tmc_polyline.geom) = false  

and I have also tried using right join but none of them giving output.

SELECT Geometry INTO Qlayer5

FROM qlayer4

RIGHT JOIN egmap_20170316_tmc_polyline ON

st_intersects(qlayer59.Geometry,egmap_20170316_tmc_polyline.geom) = false 

postgis intersection st-intersects

share|improve this question

edited 4 mins ago

Taras

2,3003729

asked 1 hour ago

poonam patelpoonam patel

212

add a comment | 

1

I have two line layers in PostgreSQL/PostGIS. I want to the select data which are not intersecting. When I am writing this query it is taking a lot of time. How can I make it faster and see the result?

SELECT Geometry into Qlayer5

FROM qlayer4, egmap_20170316_tmc_polyline

WHERE st_intersects(qlayer59.Geometry,egmap_20170316_tmc_polyline.geom) = false  

and I have also tried using right join but none of them giving output.

SELECT Geometry INTO Qlayer5

FROM qlayer4

RIGHT JOIN egmap_20170316_tmc_polyline ON

st_intersects(qlayer59.Geometry,egmap_20170316_tmc_polyline.geom) = false 

postgis intersection st-intersects

share|improve this question

edited 4 mins ago

Taras

2,3003729

asked 1 hour ago

poonam patelpoonam patel

212

add a comment | 

I have two line layers in PostgreSQL/PostGIS. I want to the select data which are not intersecting. When I am writing this query it is taking a lot of time. How can I make it faster and see the result?

SELECT Geometry into Qlayer5

FROM qlayer4, egmap_20170316_tmc_polyline

WHERE st_intersects(qlayer59.Geometry,egmap_20170316_tmc_polyline.geom) = false  

and I have also tried using right join but none of them giving output.

SELECT Geometry INTO Qlayer5

FROM qlayer4

RIGHT JOIN egmap_20170316_tmc_polyline ON

st_intersects(qlayer59.Geometry,egmap_20170316_tmc_polyline.geom) = false 

postgis intersection st-intersects

share|improve this question

edited 4 mins ago

Taras

2,3003729

asked 1 hour ago

poonam patelpoonam patel

212

SELECT Geometry into Qlayer5

FROM qlayer4, egmap_20170316_tmc_polyline

WHERE st_intersects(qlayer59.Geometry,egmap_20170316_tmc_polyline.geom) = false  

SELECT Geometry INTO Qlayer5

FROM qlayer4

RIGHT JOIN egmap_20170316_tmc_polyline ON

st_intersects(qlayer59.Geometry,egmap_20170316_tmc_polyline.geom) = false 

share|improve this question

edited 4 mins ago

Taras

2,3003729

asked 1 hour ago

poonam patelpoonam patel

212

share|improve this question

edited 4 mins ago

Taras

2,3003729

asked 1 hour ago

poonam patelpoonam patel

212

edited 4 mins ago

Taras

2,3003729

edited 4 mins ago

Taras

2,3003729

asked 1 hour ago

poonam patelpoonam patel

212

asked 1 hour ago

poonam patelpoonam patel

212

1 Answer
1

active

oldest

votes

0

Try this first for seeing the result of your query:

SELECT a.Geometry

FROM qlayer4 AS a,

egmap_20170316_tmc_polyline AS b  

WHERE

st_intersects(a.Geometry, b.geom) = false;

If it returns the expected result, insert the "INTO Qlayer5" statement.

share|improve this answer

answered 15 mins ago

blabbathblabbath

728318

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%2f318777%2fspatial-joining-two-line-layers-and-checking-intersection-in-postgresql-postgis%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

Try this first for seeing the result of your query:

SELECT a.Geometry

FROM qlayer4 AS a,

egmap_20170316_tmc_polyline AS b  

WHERE

st_intersects(a.Geometry, b.geom) = false;

If it returns the expected result, insert the "INTO Qlayer5" statement.

share|improve this answer

answered 15 mins ago

blabbathblabbath

728318

add a comment | 

0

Try this first for seeing the result of your query:

SELECT a.Geometry

FROM qlayer4 AS a,

egmap_20170316_tmc_polyline AS b  

WHERE

st_intersects(a.Geometry, b.geom) = false;

If it returns the expected result, insert the "INTO Qlayer5" statement.

share|improve this answer

answered 15 mins ago

blabbathblabbath

728318

add a comment | 

Try this first for seeing the result of your query:

SELECT a.Geometry

FROM qlayer4 AS a,

egmap_20170316_tmc_polyline AS b  

WHERE

st_intersects(a.Geometry, b.geom) = false;

If it returns the expected result, insert the "INTO Qlayer5" statement.

share|improve this answer

answered 15 mins ago

blabbathblabbath

728318

SELECT a.Geometry

FROM qlayer4 AS a,

egmap_20170316_tmc_polyline AS b  

WHERE

st_intersects(a.Geometry, b.geom) = false;

share|improve this answer

answered 15 mins ago

blabbathblabbath

728318

answered 15 mins ago

blabbathblabbath

728318

answered 15 mins ago

blabbathblabbath

728318