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?
dkastl
2
-----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-----