<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.9600.19597"></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#000080 size=2
face=Arial>So far the cl<SPAN
class=503170117-31032020>o</SPAN>sest <SPAN class=503170117-31032020>option
</SPAN>I found to<SPAN class=503170117-31032020>wards
generating </SPAN>geometries in order to cut the unwanted roads <SPAN
class=503170117-31032020>( </SPAN>before merging to the land
use it shares the longest bound<SPAN
class=503170117-31032020>a</SPAN>ry with) is using the function . That will generate li<SPAN
class=503170117-31032020>n</SPAN>es (see <SPAN
class=503170117-31032020>dotted red line in </SPAN>graph 4 </FONT><A
href="https://github.com/karstenv/postgis_processing/blob/master/parcel_layer4.png"><FONT
size=2
face=Arial>https://github.com/karstenv/postgis_processing/blob/master/parcel_layer4.png</FONT></A><SPAN
class=503170117-31032020></SPAN><FONT color=#000080 size=2
face=Arial> </FONT><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=503170117-31032020>)<BR><BR></SPAN><SPAN class=503170117-31032020>I used
this simple query to get this above example in
QGIS:</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=503170117-31032020></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=503170117-31032020>SELECT id, ST_StraightSkeleton(geom), attr1 FROM
parcels;</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT
size=2></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=503170117-31032020>Going forward </SPAN><SPAN
class=503170117-31032020>I could create workflow similar
to</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=503170117-31032020>limit the query to only the respective roads, generate
the skeleton lines, convert the roads to lines then generate a polygon geometry
of the skeleton lines and roads lines, replace the former roads polygon
geometries in the land use layer with the new polygon (skeleton-roads) geometry
before merging parcels by land use type.</SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN style="FONT-SIZE: 11pt; FONT-FAMILY: 'Verdana','sans-serif'"><SPAN
class=706372501-31032020></SPAN><FONT face=Arial><FONT color=#000080><FONT
size=2><SPAN
class=503170117-31032020> </SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 11pt; FONT-FAMILY: 'Verdana','sans-serif'"><FONT
face=Arial><FONT color=#000080><FONT size=2>Karsten</FONT></FONT></FONT>
</SPAN></DIV></BODY></HTML>