<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Selecting the start and endpoint in a fully-noded linear dataset has
always worked for me to get the junctions. Why does it not give you
the desired result? What's happening?<br>
<br>
-- Kevin<br>
<br>
On 12/16/2010 1:52 AM, Thomas Kouk wrote:
<blockquote cite="mid:63773.22698.qm@web27808.mail.ukl.yahoo.com"
type="cite">
<style type="text/css"><!-- DIV {margin:0px;} --></style>
<div style="font-family: arial,helvetica,sans-serif; font-size:
12pt;">
<div>Hi all,</div>
<div>I am newbie in postgis. I have a linear dataset (road
network) and I want to select the junctions (in order to count
them and maybe isolate them in a seperate point table).
ST_StartPoint and ST_EndPoint do not give me the desired
result, no matter how I combine them. Is there another way or
a function that I could use?</div>
<div>Alternatively I could create a loop in php to examine each
feature and to find for each end-point if there is other
feature in zero distance... however I think that this would be
a really painfull and long lasting procedure, especially in
case of dense data. There should be a simpler way...</div>
<div>Thanks,</div>
<div>Thomas</div>
</div>
<br>
</blockquote>
</body>
</html>