<html>
<head>
<title></title>
<meta name="GENERATOR" content="MSHTML 8.00.6001.18852"></meta>
</head>
<body>
<div>Hallo</div>
<div> </div>
<div>I have a quite big dataset (approx 1.2 mill rows) with roads. What I would like to to is merging all linestrings between crossings so I get one linestring between two crossings or between a crossing and the end of the road. Now there can be many small parts cut by a bridge or some border. For quality I also have to check so no linestrings are just passing a crossing too, but that is secondary because I don't think that is a problem with this dataset.</div>
<div> </div>
<div>A while ago I saw a solution on this list which included merging all and dumping, but I think that will be a little heavy in this case.</div>
<div> </div>
<div>I have been struggling some with recursive queries but I haven't found the way.</div>
<div>How to do it?</div>
<div> </div>
<div>Thanks</div>
<div>/Nicklas</div>
</body>
</html>