Skip to main content
Geographic Information Systems

Return to Question

edited tags
Link
geozelot
geozelot
  • 30.9k
  • 4
  • 34
  • 57
Became Hot Network Question
Structured, Title adjusted
Source Link
Taras ♦
Taras ♦
  • 33.9k
  • 4
  • 73
  • 148

How to spatial join 2 Spatial joining two line layers in postgres/postgis and checkchecking intersection in PostgreSQL/PostGIS

I have two line layers in PostgreSQL/PostGIS.i I want to the select data which are not intersecting. when iWhen I am writingwriting this query it is taking a lot of time.how i 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  

SELECT Geometry into Qlayer5
FROM qlayer4, egmap_20170316_tmc_polyline
WHERE st_intersects(qlayer59.Geometry,egmap_20170316_tmc_polyline.geom) = false

and iI 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 

SELECT Geometry INTO Qlayer5
FROM qlayer4
RIGHT JOIN egmap_20170316_tmc_polyline ON
st_intersects(qlayer59.Geometry,egmap_20170316_tmc_polyline.geom) = false

How to spatial join 2 line layers in postgres/postgis and check intersection

I have two line layers .i want to select data which are not intersecting. when i am writing this query it is taking a lot time.how i can make it faster and see 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

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

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
Source Link
poonam patel
poonam patel
  • 113
  • 1
  • 8

How to spatial join 2 line layers in postgres/postgis and check intersection

I have two line layers .i want to select data which are not intersecting. when i am writing this query it is taking a lot time.how i can make it faster and see 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