[pgrouting-users] Error message- isring() should only be called on a LINE
Daniel Kastl
daniel at georepublic.de
Sun Nov 29 11:23:31 PST 2015
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
On 30/11/15 03:11, Julien Lacroix wrote:
> 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 >
> 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
> _______________________________________________ > Pgrouting-users mailing list > Pgrouting-users at lists.osgeo.org >
http://lists.osgeo.org/mailman/listinfo/pgrouting-users > > >
_______________________________________________ > Pgrouting-users
mailing list > Pgrouting-users at lists.osgeo.org >
http://lists.osgeo.org/mailman/listinfo/pgrouting-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20151130/b1663a6b/attachment.html>
More information about the Pgrouting-users
mailing list