<div dir="ltr"><font face="arial, helvetica, sans-serif">Are they all multilinestrings ?</font><div><font face="arial, helvetica, sans-serif"><br></font></div><div><font face="arial, helvetica, sans-serif">What gives :</font></div>
<div><font face="arial, helvetica, sans-serif">select distinct geometryType(geom) from <span style="color:rgb(31,73,125);font-size:15px">l4_3</span> </font></div><div><br></div><div><font face="arial, helvetica, sans-serif">If it is only Linestrings, then you can update your table:</font></div>
<div><font face="arial, helvetica, sans-serif">update <span style="color:rgb(31,73,125);font-size:15px">l4_3 set geom = st_geometryN(geom);</span></font></div><div><span style="color:rgb(31,73,125);font-size:15px"><font face="arial, helvetica, sans-serif"><br>
</font></span></div><div><span style="color:rgb(31,73,125);font-size:15px"><font face="arial, helvetica, sans-serif">(If you have constraint on the geoemtry's type, you should use an "alter table..." construct to change the geometry type)</font></span></div>
<div><span style="color:rgb(31,73,125);font-size:15px"><font face="arial, helvetica, sans-serif"><br></font></span></div><div><font face="arial, helvetica, sans-serif">Nicolas</font></div><div class="gmail_extra"><font face="arial, helvetica, sans-serif"><br>
<br></font><div class="gmail_quote"><font face="arial, helvetica, sans-serif">On 16 May 2013 14:03, Hugues François <span dir="ltr"><<a href="mailto:hugues.francois@irstea.fr" target="_blank">hugues.francois@irstea.fr</a>></span> wrote:<br>
</font><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><font face="arial, helvetica, sans-serif"><u></u>
</font><div lang="EN-US" link="blue" vlink="purple">
<div dir="ltr" align="left"><span><font color="#0000ff" face="arial, helvetica, sans-serif">Hello,</font></span></div>
<div dir="ltr" align="left"><font face="arial, helvetica, sans-serif"><span><font color="#0000ff"></font></span> </font></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="arial, helvetica, sans-serif">You may try to work with a dump of your multi into single
(st_dump(geom)).geom</font></span></div>
<div dir="ltr" align="left"><font face="arial, helvetica, sans-serif"><span><font color="#0000ff"></font></span> </font></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="arial, helvetica, sans-serif">Hugues.</font></span></div>
<div><font face="arial, helvetica, sans-serif"> </font></div>
<div align="left"><font face="arial, helvetica, sans-serif"> </font></div><font face="arial, helvetica, sans-serif"><br>
</font><div dir="ltr" lang="fr" align="left">
<hr>
<font face="arial, helvetica, sans-serif"><font><div class="im"><b>From:</b> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Jonatan
Malaver<br></div><b>Sent:</b> Thursday, May 16, 2013 2:01 PM<div><div class="h5"><br><b>To:</b> PostGIS
Users Discussion<br><b>Subject:</b> Re: [postgis-users] flow
analysis<br></div></div></font><br></font></div><div><div class="h5">
<div></div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">OK,
so after some research I found out that ST_StartPoint() returns NULL for
multilinestring. Anyone know a work around?<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></span></p>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">Thanks,<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">Jonatan<u></u><u></u></font></span></p></div>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></span></p>
<div>
<div style="BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#e1e1e1 1pt solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt">
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><b><span style="font-size:11pt">From:</span></b><span style="font-size:11pt">
<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Jonatan
Malaver<br><b>Sent:</b> Thursday, May 16, 2013 7:46 AM<br><b>To:</b> PostGIS
Users Discussion<br><b>Subject:</b> Re: [postgis-users] flow
analysis<u></u><u></u></span></font></p></div></div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">Here’s
my query<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">WITH
RECURSIVE flow(gid, geom) AS (<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">
SELECT gid, geom FROM l4_3 WHERE gid = 212<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">
UNION ALL<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">
SELECT n.gid, n.geom<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">
FROM l4_3 n, flow f<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">
WHERE
ST_DWithin(ST_EndPoint(f.geom),ST_StartPoint(n.geom),0.01)<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">
)<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">SELECT
gid, ST_AsText(geom)<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">FROM
flow;<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">Here’s
the result<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">212;"MULTILINESTRING((589700.21
2926252.04,589698.873744219 2926256.62316697))"<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">l4_3
is a multilinestring of and electrical circuit. I would like to see what’s
downstream the grid from a transformer, fuse, or upstream from a house
meter.<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">Thanks,<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif">Jonatan
<u></u><u></u></font></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></span></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><b><span style="font-size:11pt">From:</span></b><span style="font-size:11pt"> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">mailto:postgis-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Nicolas Ribot<br><b>Sent:</b> Wednesday, May 15, 2013 12:55
PM<br><b>To:</b> PostGIS Users Discussion<br><b>Subject:</b> Re: [postgis-users]
flow analysis<u></u><u></u></span></font></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></p>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif">Hello,<u></u><u></u></font></p>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></p></div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif">This precise example, no, but the "WITH RECURSIVE" construct
yes.<u></u><u></u></font></p></div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></p></div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif">Could you post your query and the data model
?<u></u><u></u></font></p></div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></p></div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif">Nicolas<u></u><u></u></font></p></div></div>
<div>
<p style="MARGIN-BOTTOM:12pt" class="MsoNormal"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></p>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif">On 15 May 2013 17:56, Jonatan Malaver <<a href="mailto:jon.malaver@shrewsburyma.gov" target="_blank">jon.malaver@shrewsburyma.gov</a>> wrote:<u></u><u></u></font></p>
<blockquote style="BORDER-BOTTOM:medium none;BORDER-LEFT:#cccccc 1pt solid;PADDING-BOTTOM:0in;MARGIN:5pt 0in 5pt 4.8pt;PADDING-LEFT:6pt;PADDING-RIGHT:0in;BORDER-TOP:medium none;BORDER-RIGHT:medium none;PADDING-TOP:0in">
<div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><span style="color:rgb(31,73,125);font-size:11pt">Hello
again, </span><u></u><u></u></font></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><span style="color:rgb(31,73,125);font-size:11pt">I
tried the example, but it only returns the same line. Has anyone tried that
example?</span><u></u><u></u></font></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><span style="color:rgb(31,73,125);font-size:11pt"> </span><u></u><u></u></font></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><span style="color:rgb(31,73,125);font-size:11pt">Thanks,</span><u></u><u></u></font></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><span style="color:rgb(31,73,125);font-size:11pt"> </span><u></u><u></u></font></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><span style="color:rgb(31,73,125);font-size:11pt">Jonatan
</span><u></u><u></u></font></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><span style="color:rgb(31,73,125);font-size:11pt"> </span><u></u><u></u></font></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><b><span style="font-size:11pt">From:</span></b><span style="font-size:11pt"> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of
</b>Nicolas Ribot<br><b>Sent:</b> Tuesday, May 14, 2013 1:02 PM<br><b>To:</b>
PostGIS Users Discussion</span><u></u><u></u></font></p>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><br><b>Subject:</b> Re: [postgis-users] flow
analysis<u></u><u></u></font></p></div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"> <u></u><u></u></font></p>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif">Hi,<u></u><u></u></font></p>
<div>
<div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"> <u></u><u></u></font></p></div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif">The WITH RECURSIVE construct allows to walk a
graph:<u></u><u></u></font></p></div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"> <u></u><u></u></font></p></div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif">This link may help:<u></u><u></u></font></p></div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><a href="http://blog.cleverelephant.ca/2010/07/network-walking-in-postgis.html" target="_blank">http://blog.cleverelephant.ca/2010/07/network-walking-in-postgis.html</a><u></u><u></u></font></p>
</div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"> <u></u><u></u></font></p></div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif">Nicolas<u></u><u></u></font></p></div></div></div></div>
<div>
<div>
<div>
<p style="MARGIN-BOTTOM:12pt" class="MsoNormal"><font face="arial, helvetica, sans-serif"> <u></u><u></u></font></p>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif">On 14 May 2013 18:40, Jonatan Malaver <<a href="mailto:jon.malaver@shrewsburyma.gov" target="_blank">jon.malaver@shrewsburyma.gov</a>> wrote:<u></u><u></u></font></p>
<blockquote style="BORDER-BOTTOM:medium none;BORDER-LEFT:#cccccc 1pt solid;PADDING-BOTTOM:0in;MARGIN:5pt 0in 5pt 4.8pt;PADDING-LEFT:6pt;PADDING-RIGHT:0in;BORDER-TOP:medium none;BORDER-RIGHT:medium none;PADDING-TOP:0in">
<div>
<div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif">Hello, is it possible to do any flow analysis? For example,
query postgis for what down flow a certain point?<u></u><u></u></font></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"> <u></u><u></u></font></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif">Thanks,<u></u><u></u></font></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><span style="COLOR:#888888"> </span><u></u><u></u></font></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><span style="COLOR:#888888">Jonatan
Malaver</span><u></u><u></u></font></p>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><span style="COLOR:#888888"> </span><u></u><u></u></font></p></div></div>
<p style="MARGIN-BOTTOM:12pt" class="MsoNormal"><font face="arial, helvetica, sans-serif"><br>_______________________________________________<br>postgis-users
mailing list<br><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">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><u></u><u></u></font></p>
</blockquote></div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"> <u></u><u></u></font></p></div></div></div></div></div>
<p style="MARGIN-BOTTOM:12pt" class="MsoNormal"><font face="arial, helvetica, sans-serif"><br>_______________________________________________<br>postgis-users
mailing list<br><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">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><u></u><u></u></font></p>
</blockquote></div>
<p class="MsoNormal"><font face="arial, helvetica, sans-serif"><u></u> <u></u></font></p></div></div></div></div></div>
<font face="arial, helvetica, sans-serif"><br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="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><br>
<br></font></blockquote></div><br></div></div>