[pgrouting-users] TRSP error - Invalid result geometry node_id:-1 edge_id:0

Tue Aug 18 08:18:59 PDT 2015

Hi Ko

Yes, it is a Windows 2008 R2 64bit server I am running on (production).

"PostgreSQL 9.2.13, compiled by Visual C++ build 1600, 64-bit"
"2.0.0";"pgrouting-2.0.0";"0";"f26831f";"master";"1.53.0"
"POSTGIS="2.1.7 r13414" GEOS="3.4.2-CAPI-1.8.2 r3924" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24" LIBXML="2.7.8" LIBJSON="UNKNOWN" TOPOLOGY RASTER"

On my Windows 7 32bit PC I can confirm that pgr_trsp works with both vertices and edges and both with and without turn restrictions on my network.  My PC has:

"PostgreSQL 9.3.9, compiled by Visual C++ build 1600, 32-bit"
"2.1.0";"pgrouting-2.1.0-alpha1";"81";"5fa89b2";"develop_2_1_0";"1.58.0"
"POSTGIS="2.1.9dev r13903" GEOS="3.5.0dev-CAPI-1.9.0 r4069" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24 GDAL_DATA not found" LIBXML="2.7.8" LIBJSON="UNKNOWN" (core procs from "2.1.8 r13780" need upgrade) TOPOLOGY (topology procs f (...)"

I am using the same network in both production and test databases (built from Ordnance Survey's ITN dataset) although they are different architectures.

Thanks for the help

Ross

-----Original Message-----
From: pgrouting-users-bounces at lists.osgeo.org [mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of Ko Nagase
Sent: 18 August 2015 14:20
To: pgRouting users mailing list
Subject: Re: [pgrouting-users] TRSP error - Invalid result geometry node_id:-1 edge_id:0

Hi Ross,

Are you using pgRouting on Windows environment ?
If so, the error is same as the following Github issue #336.
https://github.com/pgRouting/pgrouting/issues/336

I think that it is fixed temporary on pgRouting >= 2.1.0 beta binary already.

Regards,

Ko

2015-08-18 21:53 GMT+09:00 McDonaldR <McDonaldR at angus.gov.uk>:
> Hello list
>
>
>
> I am getting an error using the pgr_trsp function with vertices.
>
>
>
> [Invalid result geometry node_id:-1 edge_id:0] using the pgRouting
> Layer plugin in QGIS
>
>
>
> The query is:
>
>
>
> SELECT *
>
> FROM pgr_trsp('SELECT gid as id, source::integer, target::integer,
> cost_len::float AS cost
>
> FROM itn_network',
>
>  30,
>
> 60,
>
>  false,
>
>  false
>
> );
>
>
>
> Result
>
> 0;-1;0;0 using PgAdmin
>
>
>
> If I use the function with edges then it works as expected
>
>
>
> SELECT *
>
> FROM pgr_trsp('SELECT gid as id, source::integer, target::integer,
> cost_len::float AS cost
>
> FROM itn_network',
>
>  2958, 0.5,
>
> 1194, 0.5,
>
>  false,
>
>  false
>
> );
>
>
>
> Result
>
> 0;-1;2958;302.909919799321
>
> 1;21;12;3289.06571781744
>
> 2;22;2534;0
>
> 3;1841;1484;0
>
> 4;1063;669;657.261388446325
>
> 5;1062;671;306.606908032689
>
> 6;1064;2381;0
>
> 7;428;241;0
>
> 8;427;69391;0
>
> 9;1504;1104;0
>
> 10;1069;675;0
>
> 11;1066;672;0
>
> 12;430;242;0
>
> 13;429;1763;0
>
> 14;506;290;814.718952140309
>
> 15;507;1157;206.661904345321
>
> 16;505;69401;394.173213311315
>
> 17;2093;69400;1152.8033703581
>
> 18;24;1156;0
>
> 19;1109;712;911.407628015424
>
> 20;1110;69367;82.6836380428031
>
> 21;2275;2954;55.7924940561552
>
> 22;2818;69406;10.2909471381108
>
> 23;2262;2171;93.7878062207647
>
> 24;1548;1148;0
>
> 25;1547;1543;0
>
> 26;1901;2178;0
>
> 27;1546;2172;0
>
> 28;1897;1540;0
>
> 29;1542;1968;22.2622766251952
>
> 30;495;284;0
>
> 31;494;2612;0
>
> 32;499;286;0
>
> 33;498;69364;0
>
> 34;1557;1155;0
>
> 35;1556;1154;0
>
> 36;1555;2603;0
>
> 37;146;79;0
>
> 38;145;1981;35.7573399535413
>
> 39;148;80;0
>
> 40;147;2994;0
>
> 41;2842;2996;0
>
> 42;26;14;0
>
> 43;25;1170;0
>
> 44;1572;2993;0
>
> 45;1133;736;0
>
> 46;1132;737;0
>
> 47;1134;1173;0
>
> 48;1136;739;0
>
> 49;150;82;1139.31607861894
>
> 50;151;1175;267.426016400421
>
> 51;1197;794;0
>
> 52;604;349;0
>
> 53;603;2077;0
>
> 54;1941;1589;0
>
> 55;1604;1206;0
>
> 56;1196;793;0
>
> 57;1195;1207;0
>
> 58;1189;788;491.087128220612
>
> 59;1190;789;300.17025240827
>
> 60;1191;1586;122.598743787454
>
> 61;167;1840;0
>
> 62;171;92;0
>
> 63;170;1579;0
>
> 64;1593;1199;0
>
> 65;1592;68167;0
>
> 66;1183;1828;0
>
> 67;1933;1578;0
>
> 68;1932;1985;0
>
> 69;1595;1200;0
>
> 70;1594;1984;26.9342460479565
>
> 71;1931;1577;67.4166151627323
>
> 72;1181;782;312.414537400116
>
> 73;1179;781;0
>
> 74;1180;68143;0
>
> 75;591;341;0
>
> 76;590;772;0
>
> 77;1167;68151;0
>
> 78;1170;773;0
>
> 79;1169;774;0
>
> 80;1171;1194;0
>
>
>
> Any suggestions on how to debug this?  Using the same two vertices
> with the Djikstra functions works fine.
>
>
>
> I am running it on Postgresql 9.2.13 64bit with PostGIS 2.1.7 and
> pgRouting
> 2.0.0
>
>
>
> "POSTGIS="2.1.7 r13414" GEOS="3.4.2-CAPI-1.8.2 r3924" PROJ="Rel.
> 4.8.0, 6 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24" LIBXML="2.7.8"
> LIBJSON="UNKNOWN" TOPOLOGY RASTER"
>
>
>
> "2.0.0";"pgrouting-2.0.0";"0";"f26831f";"master";"1.53.0"
>
>
>
> Thanks
>
>
>
> Ross
>
>
>
>
>
>
>
> Ross McDonald | GIS Data Coordinator | Resources Department, IT
> Division | Angus Council, Angus House, Orchardbank Business Park,
> Forfar, DD8 1AT
>
> T: 01307 476419 | F: 01307 476401 | E: mcdonaldr at angus.gov.uk
>
>
>
>
>
>
>
> This message is strictly confidential. If you have received this in
> error, please inform the sender and remove it from your system. If
> received in error you may not copy, print, forward or use it or any
> attachment in any way. This message is not capable of creating a legal
> contract or a binding representation and does not represent the views
> of Angus Council. Emails may be monitored for security and network
> management reasons. Messages containing inappropriate content may be
> intercepted. Angus Council does not accept any liability for any harm
> that may be caused to the recipient system or data on it by this message or any attachment.
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users

--
Ko Nagase (長瀬　興)
Georepublic Japan
mail: nagase at georepublic.co.jp
web: http://georepublic.co.jp
_______________________________________________
Pgrouting-users mailing list
Pgrouting-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment.