1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
routing: alphanumeric ids (Dijkstra from-to)
sql_stmt_tests/testdb1.sqlite
SELECT Algorithm, ArcRowid, NodeFrom, NodeTo, Cost FROM alpha_roads_net WHERE NodeTo = 'NODE_30' AND NodeFrom = 'NODE_72';
4 # rows (not including the header row)
5 # columns
Algorithm
ArcRowid
NodeFrom
NodeTo
Cost
Dijkstra
(NULL)
NODE_72
NODE_30
0.001575:6
Dijkstra
72
NODE_72
NODE_73
0.000162:6
Dijkstra
73
NODE_73
NODE_48
0.000810:6
Dijkstra
48
NODE_48
NODE_30
0.000602:6
|
