Linie rozgraniczające nieprzebiegające po granicach działek

notCoveringLines.sql

SELECT row_number() OVER () rn, *
	FROM (
		SELECT (ST_Dump(ST_Difference(ST_Snap(luse, lparcels, tolerance), lparcels))).*
		FROM (
			SELECT
				ST_Union(DISTINCT land_use_only.geom) AS luse,
				ST_Union(DISTINCT land_parcels_only.geom) AS lparcels,
				1e-5 AS tolerance
			FROM (
				SELECT 
					ST_Boundary(geom) AS geom FROM tereny
				EXCEPT
				SELECT ST_Boundary(geom) AS geom FROM "EGiB".gesdzi_2180
			) land_use_only,
			(
				SELECT ST_Boundary(geom) AS geom FROM "EGiB".gesdzi_2180
				EXCEPT
				SELECT ST_Boundary(geom) AS geom FROM tereny
			) land_parcels_only
		) distinct_lines
	) new_lines