<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Julien,<br>
<br>
pgRouting can only handle LINESTRING. If you really have
MULTILINESTRING geometries, how would you define the source and
target node? You would have more than one for source/target but just
one column for each.<br>
<br>
J answered such a question on Stackexchange:<br>
<a class="moz-txt-link-freetext" href="http://gis.stackexchange.com/questions/116414/take-from-multilinestring-the-start-end-points/116444#116444">http://gis.stackexchange.com/questions/116414/take-from-multilinestring-the-start-end-points/116444#116444</a><br>
<br>
Hope that helps,<br>
Daniel<br>
<br>
<br>
On 30/11/15 03:11, Julien Lacroix wrote:<br>
<span style="white-space: pre;">> Hello Daniel,
>
> i've run into the exact same error message today and in fact, my geom column is MULTILINESTRING.
> Did i have to convert my edge geom to LINESTRING for using them proper in pgRouting?
>
> Sincerely,
> Julien
></span><br>
<blockquote type="cite">Hi Bob,<br>
<br>
The error complains, that "st_isRing(st_linemerge(geom))" should
be<br>
called on LINESTRING geometries only.<br>
<br>
What is your geometry type of your "geom" column?<br>
Is it MULTILINESTRING?<br>
<br>
Best regards,<br>
Daniel<br>
<br>
<br>
<br>
On 06/10/15 06:07, Bistrais, Bob wrote:<br>
> I am trying to build a statewide road network for analysis
with<br>
> pgRouting. I ran pgr_createTopology, and it reported OK.<br>
<br>
> Next I tried to run pgr_analyzeGraph, and got an error.<br>
<br>
<br>
<br>
> Here is the command I input:<br>
<br>
> SELECT<br>
>
pgr_analyzeGraph('ng_roads',0.0001,the_geom:='geom',id:='gid',source:=<br>
'sourceroute',target:='targetroute');<br>
<br>
<br>
<br>
<br>
> And here is the error message:<br>
<br>
> NOTICE: Analyzing for ring geometries. Please wait...<br>
<br>
> ERROR: isring() should only be called on a LINE<br>
<br>
> CONTEXT: SQL statement "SELECT count(*) FROM
public.ng_roads<br>
<br>
> WHERE true AND (true) and st_isRing(st_linemerge(geom))"<br>
<br>
> PL/pgSQL function pgr_analyzegraph(text,double<br>
> precision,text,text,text,text,text) line 309 at EXECUTE
statement<br>
<br>
<br>
<br>
> -What should I do about this? Can I still perform pgRouting<br>
> analysis with these roads?<br>
<br>
<br>
<br>
> _______________________________________________
Pgrouting-users<br>
> mailing list <a class="moz-txt-link-abbreviated" href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
> <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br>
<br>
-- Georepublic UG & Georepublic Japan<br>
eMail: <a class="moz-txt-link-abbreviated" href="mailto:daniel.kastl@georepublic.de">daniel.kastl@georepublic.de</a><br>
Web: <a class="moz-txt-link-freetext" href="http://georepublic.info">http://georepublic.info</a><br>
</blockquote>
<span style="white-space: pre;">> _______________________________________________
> Pgrouting-users mailing list
> <a class="moz-txt-link-abbreviated" href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a>
> <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> <a class="moz-txt-link-abbreviated" href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a>
> <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a></span><br>
<br>
<br>
</body>
</html>