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

Daniel Kastl daniel at georepublic.de
Mon Oct 5 14:30:32 PDT 2015


-----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 at lists.osgeo.org 
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
> 

- -- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at 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-----


More information about the Pgrouting-users mailing list