[pgrouting-users] Error message- isring() should only be called on a LINE

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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Hi Bob,

The error complains, that "st_isRing(st_linemerge(geom))" should be
called on LINESTRING geometries only.

What is your geometry type of your "geom" column?
Is it MULTILINESTRING?

Best regards,
Daniel

On 06/10/15 06:07, Bistrais, Bob wrote:
> I am trying to build a statewide road network for analysis with
> pgRouting. I ran pgr_createTopology, and it reported OK.
>
> Next I tried to run pgr_analyzeGraph, and got an error.
>
> Here is the command I input:
>
> SELECT
> pgr_analyzeGraph('ng_roads',0.0001,the_geom:='geom',id:='gid',source:=
'sourceroute',target:='targetroute');
>
> And here is the error message:
>
> NOTICE: Analyzing for ring geometries. Please wait...
>
> ERROR: isring() should only be called on a LINE
>
> CONTEXT: SQL statement "SELECT count(*) FROM public.ng_roads
>
> WHERE true AND (true) and st_isRing(st_linemerge(geom))"
>
> PL/pgSQL function pgr_analyzegraph(text,double
> precision,text,text,text,text,text) line 309 at EXECUTE statement
>
> -What should I do about this? Can I still perform pgRouting
> analysis with these roads?
>
> _______________________________________________ Pgrouting-users
> mailing list Pgrouting-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>

- -- Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.info
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQEcBAEBCAAGBQJWEuv4AAoJEHjh5kk/zBG0U1IH/A2TLaBaraKBnQjW6ksynLHl
KI/Z3Ekp16Lb1jz6J8ksjjtrl8wDvTOxhG/YsuJdqpoSYGQd2c5oshpulZw/T+xt
M10fp4q2OQ2yTIIzRrk+B7iUSImfYkQVA5RBMOhI3NFXX2K1Dvoc9r6YJs5/tCxK
1vGDOxF9FMjVhP45GAxnq/tw4LzKQEqeUYVICZBL4k/dSvHDcu+KyerhzCOG2HJV
Lida2wOxAs/T0kJ7J/K+xQdeKu0ZiZLUH6+jIlsb0arYg+UUdkPnI7BfvL+uo9ds
0jheeYdknAVB4rqJrlBypjfuNMBY47Dmfj1DTJyymFduRd4J1gKHKYPiUIO+QBc=
=ih9I
-----END PGP SIGNATURE-----
_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Hi Julien,

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.

J answered such a question on Stackexchange:
http://gis.stackexchange.com/questions/116414/take-from-multilinestring-the-start-end-points/116444#116444

Hope that helps,
Daniel