mutli-line code formating

Source Link

edited Aug 16, 2018 at 12:35

I have two layers. One is MultiLineString and the other is MultiPolygon.

I am trying to erase lines that are on the polygon feature With QGIS difference tool, it worked just fine

This is my code and I do not understand what is wrong with my query. I do not see anything wrong.

select a.objectid, st_difference(a.geom, b.geom) as shape
from line a, mesh b
limit 500

The results return line segments that are also in the mesh.

I have two layers. One is MultiLineString and the other is MultiPolygon.

I am trying to erase lines that are on the polygon feature With QGIS difference tool, it worked just fine

This is my code and I do not understand what is wrong with my query. I do not see anything wrong.

select a.objectid, st_difference(a.geom, b.geom) as shape
from line a, mesh b
limit 500

The results return line segments that are also in the mesh.

I have two layers. One is MultiLineString and the other is MultiPolygon.

I am trying to erase lines that are on the polygon feature With QGIS difference tool, it worked just fine

This is my code and I do not understand what is wrong with my query. I do not see anything wrong.

select a.objectid, st_difference(a.geom, b.geom) as shape
from line a, mesh b
limit 500

The results return line segments that are also in the mesh.

edited title

Link

edited Aug 16, 2018 at 9:54

st_difference (erase overlapped feature) is not working properlyline from polygon

Source Link

asked Aug 16, 2018 at 9:47

st_difference (erase overlapped feature) is not working properly

I have two layers. One is MultiLineString and the other is MultiPolygon.

I am trying to erase lines that are on the polygon feature With QGIS difference tool, it worked just fine

This is my code and I do not understand what is wrong with my query. I do not see anything wrong.

select a.objectid, st_difference(a.geom, b.geom) as shape
from line a, mesh b
limit 500

The results return line segments that are also in the mesh.