<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="time"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="phone"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="date"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
#yiv1148694614
_filtered #yiv1148694614 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}
_filtered #yiv1148694614 {margin:70.85pt 3.0cm 70.85pt 3.0cm;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p.yiv1148694614msonormal, li.yiv1148694614msonormal, div.yiv1148694614msonormal
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
p.yiv1148694614msonormal1, li.yiv1148694614msonormal1, div.yiv1148694614msonormal1
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
span.yiv1148694614msohyperlink1
{color:blue;
text-decoration:underline;}
span.yiv1148694614msohyperlinkfollowed1
{color:purple;
text-decoration:underline;}
span.yiv1148694614estilocorreo171
{font-family:Arial;
color:windowtext;}
span.EstiloCorreo25
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:905335952;
mso-list-type:hybrid;
mso-list-template-ids:1321485174 201981969 201981977 201981979 201981967 201981977 201981979 201981967 201981977 201981979;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
</head>
<body lang=ES link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>I’ve got some problem
for achieving what you said.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:18.0pt'><font size=2 color=navy
face=Arial><span lang=EN-GB style='font-size:10.0pt;font-family:Arial;
color:navy'>I’ve got a lot of cases where the linestring is intersected
by 2 points. I would need to have 3 linestrings as a result of the split
operation and as far as I can understand St_split only cuts a geometry with another
geometry.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:18.0pt'><font size=2 color=navy
face=Arial><span lang=EN-GB style='font-size:10.0pt;font-family:Arial;
color:navy'>Maybe I could do it in QGIS or another program?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Aitor<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>De:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
pcreso@pcreso.com [mailto:pcreso@pcreso.com] <br>
<b><span style='font-weight:bold'>Enviado el:</span></b> viernes, <st1:date
Year="2013" Day="01" Month="2" ls="trans" w:st="on">01 de febrero de 2013</st1:date>
21:25<br>
<b><span style='font-weight:bold'>Para:</span></b> Aitor Gil Martin<br>
<b><span style='font-weight:bold'>Asunto:</span></b> Re: [postgis-users] Break
polylines by points</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0>
<tr>
<td valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><br>
See the example of splitting a Polyline by a point at:<br>
<a
href="http://postgis.refractions.net/documentation/manual-svn/ST_Split.html">http://postgis.refractions.net/documentation/manual-svn/ST_Split.html</a><br>
<br>
You'll need to decompose the collection (ST_Dump() ) and you can limit the
points/lines being split by use a where clause that restricts the result set
to lines with points that intersect the line.<br>
<br>
Of course, if the point does not lie exactly on the linestring, this will
fail, which in many datasets can be quite likely. You can address this, if it
is an issue, by generating buffers around the points, selecting the
intersection of each linestring with the buffer, then storing the
"adjusted" point (valve) location as the midpoint of the linestring
intersection. <br>
<br>
If you really wanted a geosynchronous point/line dataset, assuming the
valve point locations are more accurate than the lines, you could then find
all those linestring endpoints which are now an adjusted point location,
& update each to the original (rather than adjusted) point location. <br>
<br>
Cheers,<br>
<br>
Brent Wood<br>
<br>
--- On <b><span style='font-weight:bold'>Sat, <st1:date Year="13" Day="2"
Month="2" ls="trans" w:st="on">2/2/13</st1:date>, Aitor Gil Martin <i><span
style='font-style:italic'><agmartin@getxo.net></span></i></span></b>
wrote:<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
From: Aitor Gil Martin <agmartin@getxo.net><br>
Subject: [postgis-users] Break polylines by points<br>
To: postgis-users@lists.osgeo.org<br>
Date: <st1:date Year="2013" Day="2" Month="2" ls="trans" w:st="on">Saturday,
February 2, 2013</st1:date>, <st1:time Minute="49" Hour="3" w:st="on">3:49
AM</st1:time><o:p></o:p></span></font></p>
<div id=yiv1148694614>
<div>
<div>
<p class=yiv1148694614msonormal><font size=2 face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial'>Hi all,</span></font><o:p></o:p></p>
<p class=yiv1148694614msonormal><font size=2 face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial'>I would like to split the
polylines (pipes) with the points (valves). If a point intersects a polyline,
this polyline should be transformed into two polylines. Both tables have 7000
records aprox.</span></font><o:p></o:p></p>
<p class=yiv1148694614msonormal><font size=2 face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial'>Regards, </span></font><o:p></o:p></p>
<p class=yiv1148694614msonormal><b><font size=1 color="#336699" face=Verdana><span
lang=EN-GB style='font-size:9.0pt;font-family:Verdana;color:#336699;
font-weight:bold'> </span></font></b><o:p></o:p></p>
<p class=yiv1148694614msonormal><b><font size=1 color="#336699" face=Verdana><span
style='font-size:9.0pt;font-family:Verdana;color:#336699;font-weight:bold'>Aitor
Gil Martin</span></font></b><o:p></o:p></p>
<p class=yiv1148694614msonormal><b><font size=1 color="#336699" face=Verdana><span
style='font-size:9.0pt;font-family:Verdana;color:#336699;font-weight:bold'>Departamento
Informática</span></font></b><o:p></o:p></p>
<p class=yiv1148694614msonormal><b><font size=1 color="#336699" face=Verdana><span
style='font-size:9.0pt;font-family:Verdana;color:#336699;font-weight:bold'>Getxoko
Udala / Ayto Getxo</span></font></b><o:p></o:p></p>
<p class=yiv1148694614msonormal><font size=1 color="#336699" face=Verdana><span
style='font-size:8.0pt;font-family:Verdana;color:#336699'>Tel: <st1:phone
o:ls="trans" w:st="on">94 466 02 16</st1:phone> Ext.- 3457</span></font><o:p></o:p></p>
<p class=yiv1148694614msonormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><a href="http://www.getxo.net/" target="_blank"
title="http://www.getxo.net/"><font size=1 face=Verdana><span
style='font-size:8.0pt;font-family:Verdana'><span
title="http://www.getxo.net/">www.getxo.net</span></span></font></a><o:p></o:p></span></font></p>
<p class=yiv1148694614msonormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><a href="/mc/compose?to=agmartin@getxo.net"
target="_blank" title="mailto:agmartin@getxo.net"
ymailto="mailto:agmartin@getxo.net"><font size=1 face=Verdana><span
lang=EN-GB style='font-size:8.0pt;font-family:Verdana'><span
title="mailto:agmartin@getxo.net">agmartin</span></span></font></a><a
href="/mc/compose?to=agmartin@getxo.net" target="_blank"
title="mailto:agmartin@getxo.net" ymailto="mailto:agmartin@getxo.net"><font
size=1 face=Verdana><span style='font-size:8.0pt;font-family:Verdana'><span
title="mailto:agmartin@getxo.net">@getxo.net</span></span></font></a><o:p></o:p></span></font></p>
<p class=yiv1148694614msonormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
-----Inline Attachment Follows-----<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>_______________________________________________<br>
postgis-users mailing list<br>
<a href="/mc/compose?to=postgis-users@lists.osgeo.org"
ymailto="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users"
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><o:p></o:p></span></font></p>
</div>
</td>
</tr>
</table>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>