[pgrouting-users] Pgrouting-users Digest, Vol 85, Issue 1

[Bistrais, Bob]

Yes, it is multilinestring

-----Original Message-----
From: pgrouting-users-bounces at lists.osgeo.org [mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of pgrouting-users-request at lists.osgeo.org
Sent: Tuesday, October 06, 2015 3:00 PM
To: pgrouting-users at lists.osgeo.org
Subject: Pgrouting-users Digest, Vol 85, Issue 1

Send Pgrouting-users mailing list submissions to
	pgrouting-users at lists.osgeo.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.osgeo.org/mailman/listinfo/pgrouting-users
or, via email, send a message with subject or body 'help' to
	pgrouting-users-request at lists.osgeo.org

You can reach the person managing the list at
	pgrouting-users-owner at lists.osgeo.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of Pgrouting-users digest..."


Today's Topics:

   1. Error message- isring() should only be called on	a LINE
      (Bistrais, Bob)
   2. Re: Error message- isring() should only be called on a LINE
      (Daniel Kastl)


----------------------------------------------------------------------

Message: 1
Date: Mon, 5 Oct 2015 21:07:27 +0000
From: "Bistrais, Bob" <Bob.Bistrais at maine.gov>
To: "pgrouting-users at lists.osgeo.org"
	<pgrouting-users at lists.osgeo.org>
Subject: [pgrouting-users] Error message- isring() should only be
	called on	a LINE
Message-ID:
	<D655A37D8BC306438F87579A672E3D107AEF4889 at OIT-TEAQEXMBX01.som.w2k.state.me.us>
	
Content-Type: text/plain; charset="us-ascii"

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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20151005/8419aa95/attachment-0001.html>

------------------------------

Message: 2
Date: Tue, 6 Oct 2015 06:30:32 +0900
From: Daniel Kastl <daniel at georepublic.de>
To: pgrouting-users at lists.osgeo.org
Subject: Re: [pgrouting-users] Error message- isring() should only be
	called on a LINE
Message-ID: <5612EBF8.208 at georepublic.de>
Content-Type: text/plain; charset=windows-1252

-----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-----


------------------------------

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

End of Pgrouting-users Digest, Vol 85, Issue 1
**********************************************