# Knapsacks and Networks in SQL

I opened a GitHub account, Brendan’s GitHub Page last year and have added a number of projects since then, in PL/SQL and other 3GL languages. Partly in response to a request for the code for one of my blog articles on an interesting SQL problem, I decided recently to create a new repo for the SQL behind a group of articles on solving difficult combinatorial optimisation problems via ‘advanced’ SQL techniques such as recursive subquery factoring and model clause, sql_demos – Brendan’s repo for interesting SQL. It includes installation scripts with object creation and data setup, and scripts to run the SQL on the included datasets. The idea is that anyone with the pre-requisites should be able to reproduce my results within a few minutes of downloading the repo.

[Left image from Knapsack problem; right image copied from Chapter 11 Dynamic Programming]

In this article I embed each of the earlier articles relevant to the GitHub repo with a brief preamble.

The first two articles are from January 2013 and use recursive subquery factoring to find exact solutions for the single and multiple knapsack problem, and also include PL/SQL solutions for comparison. They avoid the ‘brute force’ approach by truncating search paths as soon as limit constraints are exceeded. The cumulative paths are stored in string variables passed through the iterations (which would not be possible with the older Connect By hierarchical syntax).

In these articles I illustrate the nature of the problems using Visio diagrams, and include dimensional performance benchmarking results, using a technique that I presented on at last year’s Ireland OUG conference: Dimensional Performance Benchmarking of SQL – IOUG Presentation. I also illustrate the queries using my own method for diagramming SQL queries.

A Simple SQL Solution for the Knapsack Problem (SKP-1), January 2013

An SQL Solution for the Multiple Knapsack Problem (SKP-m), January 2013

The next article uses Model clause to find a more general solution to a problem posed on AskTom, as a ‘bin fitting’ problem. I also solved the problem by other methods including recursive subquery factoring. I illustrate the problem itself, as well as the Model iteration scheme using Visio diagrams, and again include dimensional performance benchmarking. The results show how quadratic performance variation can be turned into much faster linear variation by means of a temporary table in this kind of problem.

This article arose from a question on OTN, and concerns a type of knapsack or bin-fitting problem that is quite tricky to solve in SQL, where the items fall into categories on which there are separate constraints. I introduced a new idea here, to filter out unpromising paths within recursive subquery factoring by means of analytic functions, in order to allow the technique to be used to generate solutions for larger problems without guaranteed optimality, but in shorter time. Two realistic datasets were used, one from the original poster, and another I got from a scraping website.

This article is on a classic ‘hard’ optimisation problem, and uses recursive subquery factoring with the same filtering technique as the previous article, and shows that it’s possible to solve a problem involving 312 American cities quite quickly in pure SQL using the approximation technique. It also uses a simple made-up example dataset to illustrate its working.

SQL for the Travelling Salesman Problem, July 2013

The following two articles concern finding shortest paths between given nodes in a network, and arose from a question on OTN. The first one again uses recursive subquery factoring with a filtering mechanism to exclude paths as early as possible, in a similar way to the approximative solutios methods in the earlier articles. In this case, however, reasoning about the nature of the problem shows that we are not in fact sacrificing optimality. The article has quite a lot of explanatory material on how the SQL works, and uses small dataset examples.

The second article considers how to improve performance further by obtaining a preliminary approximate solution that can be used as a bounding mechanism in a second step to find the exact solutions. This article uses two realistic networks as examples, including one having 428,156 links.

SQL for Shortest Path Problems, April 2015

In the article above I cited results from a general network analysis package I had developed that obtains all the distinct connected subnetworks with their structures in an efficient manner using PL/SQL recursion. It is worth noting that for that kind of problem recursive SQL alone is very inefficient, and I wrote the following article to try to explain why that is so, and why the Connect By syntax is generally much worse than recursive subquery factoring.

Recursive SQL for Network Analysis, and Duality, September 2015

The PL/SQL package mentioned, which I think implements a ‘named’ algorithm although I didn’t know that when I wrote it (I don’t recall the name right now, sorry š ), is available on GitHub: Brendan’s network structural analysis Oracle package, with article:

# SQL for Shortest Path Problems 2: A Branch and Bound Approach

I wrote an article a couple of weeks ago, SQL for Shortest Path Problems, in which analytic functions are used to truncate sub-optimal routes in SQL recursions for shortest paths through networks. The problem was posed by an OTN poster, How to use Recursive Subquery Factoring (RSF) to Implement Dijkstraās shortest path algorithm?, who referenced a very simple test network, and included his own SQL to solve it, which turned out to be quite similar to my own effort. The solutions are guaranteed to be optimal if the algorithm terminates normally, which it does on the small test network, and will on any network unless resources such as memory or time are exhausted owing to problem size.

In that article I referenced two earlier articles that I had written (in June/July 2013) that used analytic functions for other combinatorial problems. The usage in those cases was similar syntactically, but pruned out routes that looked inferior to others at a given iteration, so that the final solutions were not guaranteed to be optimal. The motivation was to to be able to use the SQL for exact solutions on smaller problems and for good, maybe sub-optimal, solutions for problems too large to solve exactly.

I wondered how the SQL in the last article would perform on larger networks, and whether further tuning methods could be found, perhaps based on some form of search truncation, as in the earlier articles. The resulting solution methods can be considered as branch and bound algorithms in SQL.

Update, 19 November 2017: I have now put the code and the dataset installation onto GitHub: Brendan’s repo for interesting SQL

Test Problems

I took two test problems from this site: Stanford Large Network Dataset Collection.

The larger second data set has 428,156 arcs.

Both data sets are of the non-physical type, where there are no differential costs associated with links, and the problem therefore reduces to determining the minimum number of links between a node and other reachable nodes. These non-physical networks tend to be heavily looped, owing to the essentially zero cost of adding a new link. For that reason, I change my problem definition in this article to that of finding a single best path to each reachable node, rather than all, which reduces the solution set size considerably.

It is well known that in non-physical networks, such as social media networks like Linked-In and Facebook, the minimum paths between members tends to remain relatively small as the network size goes up. This will influence the type of algorithm that will be more efficient.

Approximation Methods: Simple truncation

The most obvious approximative approach would be to simple truncate the search after a certain depth (or level). This actually works quite well and gives good results for highly looped networks, where the minimum paths tend to be much shorter than the number of nodes. However there is no guarantee of optimality, and it will be less effective for less looped networks with longer minimum paths.

SQL for SP_RSFONE (simple truncation)

```WITH paths (node, path, lev, rn) AS (
SELECT a.dst, To_Char(a.dst), 1, 1
FROM arcs_v a
WHERE a.src = &SRC
UNION ALL
SELECT  a.dst,
p.path || ',' || a.dst,
p.lev + 1,
Row_Number () OVER (PARTITION BY a.dst ORDER BY a.dst)
FROM paths p
JOIN arcs_v a
ON a.src = p.node
WHERE p.rn = 1
AND p.lev < &LEVMAX
)  SEARCH DEPTH FIRST BY node SET line_no
CYCLE node SET lp TO '*' DEFAULT ' '
SELECT Substr (LPad ('.', 1 + 2 * (Max (lev) KEEP (DENSE_RANK FIRST ORDER BY lev) - 1), '.') || node, 2) node,
Max (lev) KEEP (DENSE_RANK FIRST ORDER BY lev) lev,
Max (Max (lev) KEEP (DENSE_RANK FIRST ORDER BY lev)) OVER () maxlev,
Max (lev) intnod,
Max (Max (lev)) OVER () intmax,
Max (path) KEEP (DENSE_RANK FIRST ORDER BY lev) path,
Max (lp) KEEP (DENSE_RANK FIRST ORDER BY lev) lp
FROM paths
GROUP BY node
ORDER BY Max (line_no) KEEP (DENSE_RANK FIRST ORDER BY lev)
```

Notes on SQL for SP_RSFONE (simple truncation)

• Row_Number gives a single row with value 1 per partitioning node, so that we retain only one row per node for the previous iteration
• The global pruning can be done without an additional subquery by grouping with KEEP, since we only want one optimal row per node
• Note that in the double Max to get maxlev, the inner one is the grouping Max, while the outer is an analytic Max over the whole (grouped) result set
• intnod obtains the maximum intermdiate value of lev for a given node
• intmax obtains the maximum intermdiate value of lev over all nodes

Approximation Methods: Preliminary approximate subquery
A less obvious approach is based on the fact that during the recursion our path pruning can only take into account information available to the current iteration: Other than loops, we can prune out only paths to a given node that are longer than another at the same level. But what if we ran an approximate search in advance, in a prior subquery? Then we could outer-join the subquery by node and prune out any paths for which the subquery has found a better cost. This would potentially reduce the total searching without sacrificing guranteed optimality.

SQL for SP_RSFTWO (preliminary approximate subquery)

```WITH paths_0 (node, path, lev, rn) AS (
SELECT a.dst, To_Char(a.dst), 1, 1
FROM arcs_v a
WHERE a.src = &SRC
UNION ALL
SELECT a.dst,
p.path || ',' || a.dst,
p.lev + 1,
Row_Number () OVER (PARTITION BY a.dst ORDER BY a.dst)
FROM paths_0 p
JOIN arcs_v a
ON a.src = p.node
WHERE p.rn = 1
AND p.lev < &LEVMAX
) CYCLE node SET lp TO '*' DEFAULT ' '
, approx_best_paths AS (
SELECT node,
Max (lev) KEEP (DENSE_RANK FIRST ORDER BY lev) lev
FROM paths_0
GROUP BY node
), paths (node, path, lev, rn) AS (
SELECT a.dst, To_Char(a.dst), 1, 1
FROM arcs_v a
WHERE a.src = &SRC
UNION ALL
SELECT a.dst,
p.path || ',' || a.dst,
p.lev + 1,
Row_Number () OVER (PARTITION BY a.dst ORDER BY a.dst)
FROM paths p
JOIN arcs_v a
ON a.src = p.node
LEFT JOIN approx_best_paths b
ON b.node = a.dst
WHERE p.rn = 1
AND p.lev < Nvl (b.lev, 1000000)
)  SEARCH DEPTH FIRST BY node SET line_no CYCLE node SET lp TO '*' DEFAULT ' '
SELECT Substr (LPad ('.', 1 + 2 * (Max (lev) KEEP (DENSE_RANK FIRST ORDER BY lev) - 1), '.') || node, 2) node,
Max (lev) KEEP (DENSE_RANK FIRST ORDER BY lev) lev,
Max (Max (lev) KEEP (DENSE_RANK FIRST ORDER BY lev)) OVER () maxlev,
Max (lev) intnod,
Max (Max (lev)) OVER () intmax,
Max (path) KEEP (DENSE_RANK FIRST ORDER BY lev) path,
Max (lp) KEEP (DENSE_RANK FIRST ORDER BY lev) lp
FROM paths
GROUP BY node
ORDER BY Max (line_no) KEEP (DENSE_RANK FIRST ORDER BY lev)
```

Notes on SQL for SP_RSFTWO (preliminary approximate subquery)

• This query has two recursive subquery factors
• path_0 truncates after an input level is reached
• approx_best_paths gets the global best paths found from the approximate recursion
• paths now has an outer join to path_0 that is used to prune paths that are inferior to any path to the same node found in the prior subquery
• the approximate recursion may not reach all reachable nodes, but the outer join ensures this does not cut off any such nodes incorrectly

Approximation Methods: Preliminary approximate subquery to GTT
We will see later that the second approach works quite well, but that the CBO does not process the preliminary query very efficiently. For this reason writing the query result instead to a temporary table may be more efficient overall. The table can be indexed, and dynamic sampling allows the CBO to estimate the cardinalities more accurately.

SQL for SP_GTTRSF_I and SP_GTTRSF_Q (preliminary approximate query to GTT)

```PROMPT SP_GTTRSF_I
INSERT INTO approx_min_levs
WITH paths_0 (node, path, lev, rn) /* SP_GTTRSF_I */ AS (
SELECT a.dst, To_Char(a.dst), 1, 1
FROM arcs_v a
WHERE a.src = &SRC
UNION ALL
SELECT  a.dst,
p.path || ',' || a.dst,
p.lev + 1,
Row_Number () OVER (PARTITION BY a.dst ORDER BY a.dst)
FROM paths_0 p
JOIN arcs_v a
ON a.src = p.node
WHERE p.rn = 1
AND p.lev < &LEVMAX
) CYCLE node SET lp TO '*' DEFAULT ' '
SELECT node,
Max (lev) KEEP (DENSE_RANK FIRST ORDER BY lev) lev
FROM paths_0
GROUP BY node
/
PROMPT SP_GTTRSF_Q
WITH paths (node, path, lev, rn) AS (
SELECT a.dst, To_Char(a.dst), 1, 1
FROM arcs_v a
WHERE a.src = &SRC
UNION ALL
SELECT a.dst,
p.path || ',' || a.dst,
p.lev + 1,
Row_Number () OVER (PARTITION BY a.dst ORDER BY a.dst)
FROM paths p
JOIN arcs_v a
ON a.src = p.node
LEFT JOIN approx_min_levs b
ON b.node = a.dst
WHERE p.rn = 1
AND p.lev < Nvl (b.lev, 1000000)
)  SEARCH DEPTH FIRST BY node SET line_no CYCLE node SET lp TO '*' DEFAULT ' '
SELECT Substr (LPad ('.', 1 + 2 * (Max (lev) KEEP (DENSE_RANK FIRST ORDER BY lev) - 1), '.') || node, 2) node,
Max (lev) KEEP (DENSE_RANK FIRST ORDER BY lev) lev,
Max (Max (lev) KEEP (DENSE_RANK FIRST ORDER BY lev)) OVER () maxlev,
Max (lev) intnod,
Max (Max (lev)) OVER () intmax,
Max (path) KEEP (DENSE_RANK FIRST ORDER BY lev) path,
Max (lp) KEEP (DENSE_RANK FIRST ORDER BY lev) lp
FROM paths
GROUP BY node
ORDER BY Max (line_no) KEEP (DENSE_RANK FIRST ORDER BY lev)
```

Notes on SQL for preliminary approximate subquery to GTT

• the SQL above consists of an insert of the approximate subquery into a temporary table, followed by the exact recursive query now referencing the table rather than a subquery factor

Results: Collaboration network of Arxiv General Relativity category
Collaboration network of Arxiv General Relativity category

Arxiv GR-QC (General Relativity and Quantum Cosmology) collaboration network is from the e-print arXiv and covers scientific collaborations between authors papers submitted to General Relativity and Quantum Cosmology category. If an author i co-authored a paper with author j, the graph contains a undirected edge from i to j. If the paper is co-authored by k authors this generates a completely connected (sub)graph on k nodes.

The data set comes with the reverse arcs already present, making a total of 28,980.

I took the first node in the first line in the data set file as the initial root node, 3466, and tested the three methods above for values of LEVMAX of 5, 10, 15, 20, 25 and 30. The complete results, including execution plans are in the attached file.

The exact solution has 4,158 nodes reached from the source node 3466, with a maximum level of 11. The listing below gives the output from SP_GTTRSF_Q for LEVMAX=5.

```NODE                            LEV  MAXLEV  INTNOD  INTMAX PATH                                                                             LP
------------------------------ ---- ------- ------- ------- -------------------------------------------------------------------------------- --
937                               1      11       1      45 937
5233                              1      11       1      45 5233
8579                              1      11       1      45 8579
..4135                            2      11       2      45 937,4135
....1860                          3      11       3      45 8579,4135,1860
....16498                         3      11       3      45 8579,4135,16498
......19442                       4      11       4      45 8579,4135,16498,19442
..........9890                    6      11       6      45 8579,4135,16498,19442,6264,9890
......22826                       4      11       4      45 8579,4135,16498,22826
..........12260                   6      11       8      45 8579,4135,16498,22826,6804,12260
..........25491                   6      11       8      45 8579,4135,16498,22826,6804,25491
..........25844                   6      11       6      45 8579,4135,16498,22826,6804,25844
..............8037                8      11       9      45 8579,4135,16498,22826,13520,122,4825,8037
..............14621               8      11      11      45 8579,4135,16498,22826,13520,122,4825,14621
..............19608               8      11      10      45 8579,4135,16498,22826,13520,122,4825,19608
..............4836                8      11       9      45 8579,4135,16498,22826,13520,122,9593,4836
............4641                  7      11       9      45 8579,4135,16498,22826,13520,22224,4641
............17937                 7      11       9      45 8579,4135,16498,22826,13520,22224,17937
............21660                 7      11       7      45 8579,4135,16498,22826,13520,22224,21660
............22088                 7      11       7      45 8579,4135,16498,22826,13520,22224,22088
..........22224                   6      11       9      45 8579,4135,16498,22826,13520,22224
........17599                     5      11       5      45 8579,4135,16498,22826,17599
..16258                           2      11       2      45 8579,16258
....1356                          3      11       3      45 8579,16258,1356
....1727                          3      11       3      45 8579,16258,1727
......4241                        4      11       4      45 8579,16258,1727,4241
........5227                      5      11       5      45 8579,16258,1727,4241,5227
........7015                      5      11       5      45 8579,16258,1727,4241,7015
........10476                     5      11       5      45 8579,16258,1727,4241,10476
..............7854                8      11      10      45 8579,16258,1727,4241,10476,4875,11844,7854
............11844                 7      11      10      45 8579,16258,1727,4241,10476,4875,11844
.
. extracted
.
..23429                           2      11       2      45 17038,23429
....4781                          3      11       3      45 17038,23429,4781
....19697                         3      11       3      45 17038,23429,19697
......5519                        4      11       4      45 17038,23429,19697,5519
........26167                     5      11       5      45 17038,23429,19697,5519,26167
......17818                       4      11       4      45 17038,23429,19697,17818
......20260                       4      11       4      45 17038,23429,19697,20260
......23809                       4      11       4      45 17038,23429,19697,23809
........23219                     5      11       5      45 17038,23429,19697,5519,23219
..24578                           2      11       2      45 17038,24578
....18297                         3      11       3      45 17038,24578,18297
......5402                        4      11       4      45 17038,24578,18297,5402
......15947                       4      11       4      45 17038,24578,18297,15947
18720                             1      11       1      45 18720
19607                             1      11       1      45 19607
..3466                            2      11       2      45 937,3466

4158 rows selected.

Elapsed: 00:00:09.78
```

The embedded Excel file below summarises the results with relevant statistics from the query runs and the execution plans.

Results summary - SP_RSFONE (simple truncation)

• SP_RSFONE ran in from 3 seconds to 60 seconds, and returned the exact solution from LEVMAX = 15 on
• It continued iterating up to the maximum level of LEVMAX in each case, although all optimal path lengths are found by level 11

Results summary - SP_RSFTWO (preliminary approximate subquery)
This is the execution plan for LEVMAX=5

```-----------------------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                          | Name            | Starts | E-Rows | A-Rows |   A-Time   | Buffers |  OMem |  1Mem | Used-Mem |
-----------------------------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                                   |                 |      1 |        |   4158 |00:00:27.47 |    2716K|       |       |          |
|   1 |  WINDOW SORT                                       |                 |      1 |     39 |   4158 |00:00:27.47 |    2716K|   372K|   372K|  330K (0)|
|   2 |   SORT GROUP BY                                    |                 |      1 |     39 |   4158 |00:00:27.45 |    2716K|    19M|  6662K|   17M (0)|
|   3 |    VIEW                                            |                 |      1 |     39 |  87755 |00:00:27.27 |    2716K|       |       |          |
|   4 |     UNION ALL (RECURSIVE WITH) DEPTH FIRST         |                 |      1 |        |  87755 |00:00:27.17 |    2716K|    16M|  1524K|   14M (0)|
|*  5 |      INDEX RANGE SCAN                              | ARCS_CA_GRQC_PK |      1 |      6 |      8 |00:00:00.01 |       2 |       |       |          |
|   6 |      WINDOW SORT                                   |                 |     45 |     33 |  87747 |00:00:21.78 |    1664K|   832K|   511K|  739K (0)|
|*  7 |       FILTER                                       |                 |     45 |        |  87747 |00:00:21.27 |    1664K|       |       |          |
|*  8 |        HASH JOIN RIGHT OUTER                       |                 |     45 |     33 |    110K|00:00:21.38 |    1664K|  1817K|  1817K| 1565K (0)|
|   9 |         VIEW                                       |                 |     45 |     39 |    114K|00:00:21.02 |    1655K|       |       |          |
|  10 |          SORT GROUP BY                             |                 |     45 |     39 |    114K|00:00:20.96 |    1655K|   337K|   337K|  299K (0)|
|  11 |           VIEW                                     |                 |     45 |     39 |    689K|00:00:20.23 |    1655K|       |       |          |
|  12 |            UNION ALL (RECURSIVE WITH) BREADTH FIRST|                 |     45 |        |    689K|00:00:19.32 |    1655K|   903K|   523K|  802K (0)|
|* 13 |             INDEX RANGE SCAN                       | ARCS_CA_GRQC_PK |     45 |      6 |    360 |00:00:00.01 |      50 |       |       |          |
|  14 |             WINDOW SORT                            |                 |    225 |     33 |    688K|00:00:04.00 |   44865 |  1116K|   557K|  991K (0)|
|  15 |              NESTED LOOPS                          |                 |    225 |     33 |    688K|00:00:01.27 |   44865 |       |       |          |
|  16 |               RECURSIVE WITH PUMP                  |                 |    225 |        |  67635 |00:00:00.27 |       0 |       |       |          |
|* 17 |               INDEX RANGE SCAN                     | ARCS_CA_GRQC_PK |  67635 |      6 |    688K|00:00:00.57 |   44865 |       |       |          |
|  18 |         NESTED LOOPS                               |                 |     45 |     33 |    110K|00:00:00.21 |    8594 |       |       |          |
|  19 |          RECURSIVE WITH PUMP                       |                 |     45 |        |  10787 |00:00:00.03 |       0 |       |       |          |
|* 20 |          INDEX RANGE SCAN                          | ARCS_CA_GRQC_PK |  10787 |      6 |    110K|00:00:00.11 |    8594 |       |       |          |
-----------------------------------------------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

5 - access("SRC"=3466)
7 - filter("P"."LEV"<NVL("B"."LEV",1000000))
8 - access("B"."NODE"="DST")
13 - access("SRC"=3466)
17 - access("SRC"="P"."NODE")
20 - access("SRC"="P"."NODE")

```
• SP_RSFTWO ran in from 27 seconds to 552 seconds, and returned the exact solution in all cases
• From the intmax value (Excel file) we can see that only in the case of LEVMAX=5 did the second recursion iterate beyond the optimum level of 11 (in fact to a level of 45). This would be due the preliminary approximate subquery allowing it to discard sub-optimal paths in the second recursion
• The execution plan above shows that Oracle CBO has chosen not to materialize the first recursive subquery, and essentially reruns it at each of the 45 outer iterations
• A better approach for the CBO to have taken would appear to be to form a hash table in memory (where possible) of the first subquery, and run each iteration of the outer recursion outer-joining to that unchanging hash table; or alternatively, to materialize it and outer-join in any other way deemed appropriate
• I tried hinting the subquery to get CBO to materialise or avoid the repetition of the first subquery, but without success, and so decided using a temproray table to materialise it myself would be a good idea

Results summary - SP_GTTRSF_I and SP_GTTRSF_Q (preliminary approximate query to GTT)

• SP_GTTRSF_I and SP_GTTRSF_Q ran in from 5 seconds to 54 seconds combined
• LEVMAX=10 gave slight the better result here: Evidently, the extra work in the insert compared with LEVMAX=5 was over-compensated by the benefit of a better approximate solution
• Once LEVMAX is sufficiently large to give a good approximate solution it is most efficient not to increase it further
• This method is almost as efficient as simply truncating at a given level, but guarantees optimality

Network analysis

I have my own network analysis program, implemented as a PL/SQL pipelined function. I thought this might be useful to help validate the results. The function returns all distinct subnetworks and is called three times to give different levels of detail. It runs against a view links_v that must be created for the data source containing the network links. Here is the output:

```links_v based on net_CA_GrQc

View dropped.

View created.

COUNT(*)
----------
14484

Network detail

---------- ------- ------- ------ ---------- ----------
1000         13422    4158      0   1000     ROOT
1 > 1149     770
2 > 12016    4681
3 < 1000*    778
3 > 18271    7628
4 < 13702    3675
.
. Extracted
.
11 < 5400     14039
8 < 5241     5959
7 > 18145    8551
8 > 21799    13889
9 < 11557*   8553
6 > 18271*   14193
6 > 19978    14194
7 < 13702*   3676
7 < 18271*   3671
4 < 18152    12071
2 > 16234    4682
3 > 18373    4686
4 < 1149*    4684
4 > 19871    4687
5 > 25526    5590
6 < 18373*   4688
2 > 17251    4683
2 > 20557    4685
2 > 4189     4679
3 > 5829     13222
1 > 20667    785
10002            1       2      0   10002    ROOT
1 < 7468     8487
10056           11       6      0   10056    ROOT
1 < 2754     13119
2 > 5511     13116
3 > 10056*   13122
3 > 7265     13120
4 > 10056*   13115
4 < 2754*    13117
4 > 7479     13114
5 > 10056*   12036
5 > 13390    12037
5 < 2754*    13118
5 < 5511*    13121
1010             1       2      0   1010     ROOT
1 > 2749     13221
10115            2       3      0   10115    ROOT
1 > 10134    50
1 > 23916    51
1013             2       3      0   1013     ROOT
1 > 19011    9224
2 < 2123     12933
10133            1       2      0   10133    ROOT
1 > 18218    6369
10148            1       2      0   10148    ROOT
1 > 10847    7955
10154            5       4      0   10154    ROOT
1 > 16830    13630
2 < 11410    14133
3 < 9224     12381
4 > 10154*   12380
4 > 16830*   12382
10163           24       8      0   10163    ROOT
1 > 12551    7434
2 < 1281     7440
3 > 10163*   7439
3 > 18621    7441
4 < 10163*   7435
4 < 12551*   5987
4 < 17588    5984
5 < 12551*   5986
5 > 24207    5985
6 < 10163*   7436
6 < 12551*   5988
6 < 1281*    7442
6 < 18621*   5982
6 > 25287    5981
7 < 10163*   7437
7 < 12551*   5989
7 < 1281*    7443
7 < 18621*   5983
7 < 3653     7448
8 > 10163*   7444
8 > 12551*   7445
8 < 1281*    7438
8 > 18621*   7446
8 > 24207*   7447
10178            3       3      0   10178    ROOT
1 > 24133    10756
2 < 3744     14126
3 > 10178*   14125
10180            3       3      0   10180    ROOT
1 > 17587    13060
2 < 2334     13059
3 > 10180*   13058
10252            3       3      0   10252    ROOT
1 > 16820    6964
2 < 9630     6963
3 > 10252*   6962
10317            2       3      0   10317    ROOT
1 > 11816    4265
1 < 2259     4264
10338           14       7      0   10338    ROOT
1 > 12458    5220
2 > 12460    8958
3 < 10338*   5221
3 > 16651    13302
4 < 10338*   5223
4 < 12458*   8959
4 > 19378    13976
5 < 10338*   5224
5 < 12458*   8960
5 < 12460*   13303
5 < 7523     12926
6 > 10338*   12924
6 > 12458*   12925
1 > 14844    5222
10341            6       4      0   10341    ROOT
1 < 1292     10693
2 > 14840    10694
3 < 10341*   10695
3 < 6648     10697
4 > 10341*   10696
4 < 1292*    10692
10355            5       6      0   10355    ROOT
1 < 2054     3240
2 > 13741    3241
2 < 1552     13484
2 > 8719     3238
2 > 9760     3239
10356            1       2      0   10356    ROOT
1 > 19062    7274
10382            1       2      0   10382    ROOT
1 > 25482    12047
10407            1       2      0   10407    ROOT
1 < 6701     13278
10432            2       3      0   10432    ROOT
1 > 16891    7463
1 < 5774     13628
10433            1       2      0   10433    ROOT
1 < 2593     5143
1050             1       2      0   1050     ROOT
1 > 17120    4284
1051             3       3      0   1051     ROOT
1 > 25664    13897
2 < 4245     13898
3 < 1051*    13896
10513            2       3      0   10513    ROOT
1 > 25059    9437
1 > 25595    9438
10517            1       2      0   10517    ROOT
1 < 5119     9154
10522            1       2      0   10522    ROOT
1 > 10561    11775
10559            1       2      0   10559    ROOT
1 > 18245    8169
10564            6       5      0   10564    ROOT
1 > 15187    6266
2 < 8970     9824
3 > 10564*   9823
1 < 2984     6265
2 > 8731     6264
3 > 10564*   6294
10602            1       2      0   10602    ROOT
1 > 20805    13140
10637            4       4      0   10637    ROOT
1 > 21340    4094
2 < 8428     4093
3 > 10637*   4091
3 > 18603    4092
10638            1       2      0   10638    ROOT
1 < 8717     12974
10672            6       4      0   10672    ROOT
1 > 12512    11111
2 < 4630     11110
3 > 10672*   11109
3 > 9921     11108
4 > 10672*   13681
4 > 12512*   13682
10676            1       2      0   10676    ROOT
1 > 24961    1798
10677           29      14      0   10677    ROOT
1 > 17015    9130
2 > 20560    7465
3 < 309      7253
4 > 10677*   7250
4 > 17015*   7251
4 > 17453    7252
5 < 11030    10700
6 > 23946    10701
7 < 17453*   4282
7 > 25611    10703
8 < 11030*   10702
8 < 17453*   4283
8 < 6012     8987
9 > 11030*   8984
9 > 17453*   8985
9 > 23946*   8986
9 > 9591     8983
10 > 10677*   4275
10 > 11030*   4276
10 > 13704    4277
10 > 17015*   4278
10 > 17453*   4279
10 < 2136     4273
11 > 17453*   4274
10 < 2186     14089
10 > 23946*   4280
10 > 25611*   4281
10 < 309*     7249
2 > 21314    7466
10679            4       4      0   10679    ROOT
1 < 115      9941
2 > 5268     9940
3 > 10679*   9939
1 < 8671     9015
10682            4       4      0   10682    ROOT
1 < 2506     6022
2 > 9962     6021
3 > 10682*   5990
3 > 22428    5991
10792           11       7      0   10792    ROOT
1 > 15695    9866
2 > 20379    9647
2 > 21309    9648
3 < 20422    9661
4 < 2222     9642
5 > 10792*   9640
5 > 15695*   9641
5 > 21309*   9643
5 < 2215     9644
6 > 15695*   9645
6 > 21309*   9646
10818            3       3      0   10818    ROOT
1 > 11016    11965
2 > 25596    11967
3 < 10818*   11966
10872            3       3      0   10872    ROOT
1 > 24250    6959
2 < 2666     6961
3 > 10872*   6960
10884           10       7      0   10884    ROOT
1 > 16353    12670
2 < 4958     12669
3 > 10884*   12668
3 > 9606     12667
4 > 10884*   9663
4 > 12122    9664
5 < 5973     13438
6 > 9606*    13437
4 > 16353*   9665
4 < 2247     9662
10897            1       2      0   10897    ROOT
1 < 5548     7565
10904            7       7      0   10904    ROOT
1 > 12707    9216
2 < 5156     4083
3 > 10904*   4082
3 > 14282    4084
4 < 11035    4183
3 > 17933    4085
3 > 7483     4081
10906            5       6      0   10906    ROOT
1 < 1289     10560
2 > 1560     10558
2 > 4365     10559
1 < 8530     5023
2 > 21144    5024
1092             2       3      0   1092     ROOT
1 > 23226    5795
1 > 3196     5794
10936            3       4      0   10936    ROOT
1 > 19509    10723
1 > 19510    10724
1 > 23687    10725
11009           12       8      0   11009    ROOT
1 > 20157    7971
2 > 23471    7975
3 < 11009*   7974
1 > 21344    7972
2 < 11721    9753
3 > 12151    9751
4 > 15221    9756
5 < 11721*   9752
5 > 21344*   9754
4 > 21344*   9757
2 > 22990    9755
3 < 11009*   7973
11028            6       4      0   11028    ROOT
1 > 21171    9834
2 > 22730    9836
3 < 11028*   9835
3 < 5211     9833
4 > 11028*   9831
4 > 21171*   9832
11054            3       3      0   11054    ROOT
1 < 8395     14002
2 > 8725     14001
3 > 11054*   14003
1107             1       2      0   1107     ROOT
1 > 6973     6133
11120            3       4      0   11120    ROOT
1 > 16340    13294
1 > 17851    13295
1 > 20233    13296
11196            3       4      0   11196    ROOT
1 < 13       9182
2 > 19170    9183
2 > 7596     9181
11197            3       3      0   11197    ROOT
1 < 844      6408
2 > 890      6407
3 > 11197*   6409
11215            1       2      0   11215    ROOT
1 > 23156    13072
11216            2       3      0   11216    ROOT
1 > 19598    5564
2 < 13815    5565
11279            5       5      0   11279    ROOT
1 > 17750    5108
2 > 22976    5109
2 > 25609    5110
2 < 9832     6048
3 > 11279*   6047
11280            1       2      0   11280    ROOT
1 < 831      11119
11285            3       3      0   11285    ROOT
1 > 12193    7864
2 < 9618     7863
3 > 11285*   7862
11411            1       2      0   11411    ROOT
1 > 24242    13714
11418            5       5      0   11418    ROOT
1 < 161      5233
2 > 19583    5234
3 < 97       12273
4 > 161*     12272
2 > 3105     5232
11427            4       4      0   11427    ROOT
1 > 20414    6376
2 < 14170    7561
3 < 7632     6737
4 > 20414*   6738
11459            1       2      0   11459    ROOT
1 < 6706     4089
11462            1       2      0   11462    ROOT
1 > 17141    5708
11465            3       3      0   11465    ROOT
1 > 11577    12723
2 < 3239     5601
3 > 11465*   5600
11467            1       2      0   11467    ROOT
1 > 19575    13141
11539            7       5      0   11539    ROOT
1 > 15227    13103
2 > 16655    9932
3 < 11539*   13104
3 < 782      9931
4 > 11539*   9929
4 > 15227*   9930
2 > 18151    9933
1154             6       5      0   1154     ROOT
1 > 12017    4312
2 > 12930    4314
3 < 1154*    4313
3 > 17591    4315
4 < 8704     7088
5 > 12930*   7087
11561            6       6      0   11561    ROOT
1 < 9579     11992
2 > 16932    11993
3 > 19451    11991
4 < 9579*    11994
2 > 22381    11995
2 < 6534     12067
11566            3       3      0   11566    ROOT
1 > 11808    3143
2 > 18560    3145
3 < 11566*   3144
11579            1       2      0   11579    ROOT
1 > 15073    12917
11593           10      10      0   11593    ROOT
1 > 18415    9430
2 < 16818    8830
2 > 23648    3437
2 < 4633     3436
2 < 7194     886
3 > 15322    885
3 > 20960    887
4 < 6355     883
5 > 7194*    882
3 > 7542     884
11616           12       9      0   11616    ROOT
1 > 14149    5047
2 > 14662    5042
3 < 11616*   5048
2 > 16648    5043
2 > 19560    5044
3 > 23530    9159
4 < 14149*   5046
4 < 3750     11990
5 > 14149*   11988
5 > 19560*   11989
2 > 22199    5045
2 < 8147     13240
11622            5       5      0   11622    ROOT
1 < 3852     12250
2 > 7877     12249
3 > 11622*   6262
3 < 1378     6261
3 > 15422    6263
11623            1       2      0   11623    ROOT
1 > 23621    9950
11641            1       2      0   11641    ROOT
1 > 24462    11178
11642            1       2      0   11642    ROOT
1 > 25230    13233
11662           10       5      0   11662    ROOT
1 > 14094    9983
2 > 19014    9985
3 < 11662*   9984
3 < 5960     9979
4 > 11662*   9977
4 > 14094*   9978
4 > 8705     9976
5 > 11662*   9980
5 > 14094*   9981
5 > 19014*   9982
11718            1       2      0   11718    ROOT
1 > 20766    14024
11823           19       9      0   11823    ROOT
1 > 13628    13948
2 > 15246    13945
3 > 20332    13377
4 < 13628*   13946
4 < 6350     9193
5 > 11823*   9189
5 > 13628*   9190
5 > 15246*   9191
5 > 16014    9192
5 > 23710    9194
6 < 11823*   13949
6 < 13628*   13947
6 < 8372     13944
7 > 11823*   13940
7 > 13628*   13941
7 > 15246*   13942
7 > 20332*   13943
7 < 6350*    9188
5 < 4495     9195
11828            1       2      0   11828    ROOT
1 < 7807     7330
11842            5       5      0   11842    ROOT
1 < 1656     5766
2 > 21531    5767
3 < 5828     5768
4 < 1656*    5765
2 > 4040     5764
1187             1       2      0   1187     ROOT
1 > 6290     9841
11879            7       6      0   11879    ROOT
1 > 26092    11947
2 < 21187    10770
3 < 4051     7891
4 > 21313    7892
5 < 21310    13661
5 > 26092*   7894
4 > 26092*   7893
11893            3       3      0   11893    ROOT
1 > 25667    13467
2 < 8891     13036
3 > 11893*   13035
11911            1       2      0   11911    ROOT
1 < 9039     12102
1194             1       2      0   1194     ROOT
1 > 21858    1756
11965            3       4      0   11965    ROOT
1 < 1556     6619
2 > 14096    6620
2 > 23154    6621
11969            3       3      0   11969    ROOT
1 > 18996    10664
2 < 1967     10666
3 > 11969*   10665
11971            1       2      0   11971    ROOT
1 > 25211    11733
11991            1       2      0   11991    ROOT
1 < 3186     12664
12034           15       6      0   12034    ROOT
1 > 17935    14102
2 < 2116     14098
3 > 12034*   14097
3 > 9189     14094
4 > 12034*   14092
4 > 17935*   14093
4 > 9765     14090
5 > 12034*   14100
5 > 17935*   14101
5 < 2116*    14095
5 > 9774     14099
6 > 12034*   14103
6 > 17935*   14104
6 < 2116*    14096
6 < 9189*    14091
12041            1       2      0   12041    ROOT
1 > 14384    8493
12042           20      12      0   12042    ROOT
1 < 5738     3826
2 > 17252    3827
3 > 18142    12724
4 < 5738*    3828
4 < 6538     10717
5 > 16040    10715
5 > 17252*   10716
5 < 5478     13900
6 > 5738*    13899
6 > 8349     13901
7 < 1549     9651
8 > 22766    9652
9 > 23168    9655
10 < 1549*    9653
10 < 8349*    9650
9 < 8349*    9649
8 > 24732    9654
7 < 5738*    3825
7 < 6538*    10714
5 < 5738*    3824
12046            7       8      0   12046    ROOT
1 > 25957    7833
2 < 17724    4986
3 > 25958    4987
2 < 19126    9486
3 < 14135    13923
2 < 8263     3572
3 > 17882    3571
12050            1       2      0   12050    ROOT
1 < 5364     13463
12113            4       4      0   12113    ROOT
1 > 16886    12069
2 < 142      12755
3 > 18626    12756
4 < 16886*   12070
12161            1       2      0   12161    ROOT
1 > 19162    4316
12192            3       3      0   12192    ROOT
1 < 5839     9611
2 > 7026     9610
3 > 12192*   9612
12213           21       7      0   12213    ROOT
1 > 13558    13457
2 > 21710    12987
3 < 12213*   13458
3 > 22318    13461
4 < 12213*   13459
4 < 13558*   12988
4 > 24888    13456
5 < 12213*   13460
5 < 13558*   12989
5 < 21710*   13462
5 < 8669     12995
6 > 12213*   12991
6 > 13558*   12992
6 > 21710*   12993
6 > 22318*   12994
6 > 9038     12990

---------- ------- ------- ------ ---------- ----------
12213           21       7      7 > 12213*   13451
7 > 13558*   13452
7 > 21710*   13453
7 > 22318*   13454
7 > 24888*   13455
12248            1       2      0   12248    ROOT
1 < 98       14149
12252            2       3      0   12252    ROOT
1 > 22404    10336
2 < 9026     13358
12256            2       3      0   12256    ROOT
1 > 17237    6040
1 < 5081     6039
12290            2       3      0   12290    ROOT
1 > 17307    8012
1 > 20031    8013
12307            3       3      0   12307    ROOT
1 > 14175    12694
2 > 22980    12693
3 < 12307*   12695
12320            3       3      0   12320    ROOT
1 > 12321    6226
2 > 19222    6228
3 < 12320*   6227
12338            3       3      0   12338    ROOT
1 > 15800    13147
2 < 1878     13146
3 > 12338*   13145
12387            7       6      0   12387    ROOT
1 > 19520    7612
2 > 23084    7614
3 < 12387*   7613
3 < 19931    14057
3 > 23553    7616
3 > 23554    7617
4 < 19520*   7615
12414           13       8      0   12414    ROOT
1 > 14431    5783
2 > 24439    14022
3 < 12414*   5785
3 < 18562    5786
4 < 12414*   5784
4 < 3102     5781
5 > 12414*   5780
5 > 24439*   5782
3 < 20537    13299
4 > 20543    13298
5 > 21339    10744
6 > 24439*   10746
5 > 24439*   10745
12473            1       2      0   12473    ROOT
1 < 9831     13760
12504            1       2      0   12504    ROOT
1 < 9053     9044
12554            1       2      0   12554    ROOT
1 < 7636     11747
12616            3       3      0   12616    ROOT
1 > 16266    4164
2 < 4485     4166
3 > 12616*   4165
12617            2       3      0   12617    ROOT
1 > 17388    7631
2 < 6037     8024
12676            2       3      0   12676    ROOT
1 > 14302    9722
2 < 5432     13653
12689            6       4      0   12689    ROOT
1 > 17560    4479
2 > 21697    4477
3 < 12689*   4480
3 > 25116    4476
4 < 12689*   4481
4 < 17560*   4478
12703            2       3      0   12703    ROOT
1 < 1669     4747
1 < 5260     6438
12704            2       3      0   12704    ROOT
1 < 7861     7495
2 < 2355     7496
12751            1       2      0   12751    ROOT
1 < 6307     11094
12798            2       3      0   12798    ROOT
1 > 19507    6123
2 < 3199     7089
12801            4       4      0   12801    ROOT
1 > 15641    13864
2 > 19548    9870
3 < 12801*   13865
2 < 5466     9871
12863            1       2      0   12863    ROOT
1 > 18390    11997
12940            2       3      0   12940    ROOT
1 < 787      9633
2 > 20883    9634
13012            3       3      0   13012    ROOT
1 < 1983     12737
2 > 20943    12738
3 < 13012*   12739
13022            1       2      0   13022    ROOT
1 < 8077     8653
13031            4       4      0   13031    ROOT
1 > 13334    12391
2 < 8738     12997
3 > 13031*   12996
1 > 13620    12392
13167            3       3      0   13167    ROOT
1 > 15485    13919
2 < 800      7678
3 > 13167*   7677
13202            3       4      0   13202    ROOT
1 > 16703    8062
2 > 22253    3823
3 < 4128     5098
13325           14       8      0   13325    ROOT
1 > 14502    9507
2 > 15899    9510
3 < 13325*   9508
2 > 20926    9511
3 < 13325*   9509
3 < 6735     9505
4 > 13325*   9503
4 > 14502*   9504
4 > 23167    9506
5 < 3388     13311
6 > 3818     13309
7 > 23167*   9127
7 > 6735*    9126
6 > 6735*    13310
13357            4       4      0   13357    ROOT
1 > 25115    9305
2 < 8739     9304
3 > 13357*   9303
1 > 25852    9306
13413            1       2      0   13413    ROOT
1 < 9211     13312
13415            3       3      0   13415    ROOT
1 > 15386    12935
2 < 7585     12980
3 > 13415*   12979
1344             1       2      0   1344     ROOT
1 > 18126    10351
1346             1       2      0   1346     ROOT
1 > 6448     4271
13485            2       3      0   13485    ROOT
1 > 21530    5692
2 < 5059     1701
13486            3       3      0   13486    ROOT
1 > 18688    11102
2 < 4259     11104
3 > 13486*   11103
13621            1       2      0   13621    ROOT
1 > 25388    560
13675            1       2      0   13675    ROOT
1 < 4186     4163
13677            3       3      0   13677    ROOT
1 > 18288    9861
2 > 23206    9863
3 < 13677*   9862
13717            1       2      0   13717    ROOT
1 < 8558     12265
1376             1       2      0   1376     ROOT
1 > 4267     10556
13802            6       4      0   13802    ROOT
1 > 16823    14183
2 > 19553    13907
3 < 13802*   14184
3 < 5571     14182
4 > 13802*   14180
4 > 16823*   14181
1383            11       6      0   1383     ROOT
1 > 3377     13218
2 < 1660     11777
3 > 23068    11778
4 > 25631    11781
5 < 1660*    11779
5 > 25678    11776
6 < 1660*    11780
6 < 23068*   11782
6 < 3377*    11785
5 < 3377*    11784
4 < 3377*    11783
13932            4       4      0   13932    ROOT
1 < 6075     1618
2 > 14499    1619
3 > 20345    1621
4 < 6075*    1620
14               1       2      0   14       ROOT
1 > 14171    13498
14130            1       2      0   14130    ROOT
1 < 3599     9719
14131            1       2      0   14131    ROOT
1 < 372      12066
14132            1       2      0   14132    ROOT
1 > 15154    11120
14159            4       4      0   14159    ROOT
1 > 24852    6980
2 < 5144     10685
3 > 14159*   10684
2 < 8869     8832
14182            1       2      0   14182    ROOT
1 > 17537    12666
14338            1       2      0   14338    ROOT
1 > 22729    11180
14339            2       3      0   14339    ROOT
1 > 18608    13026
2 > 22816    13025
14353            6       5      0   14353    ROOT
1 > 14886    4074
2 < 2043     9914
3 > 6315     9913
4 > 14886*   5819
2 < 2455     4073
3 > 14353*   4072
14358            1       2      0   14358    ROOT
1 < 5697     12262
14543            4       4      0   14543    ROOT
1 > 21221    7497
2 > 25130    7499
3 < 14543*   7498
3 < 7958     6801
14560            3       3      0   14560    ROOT
1 > 24251    3804
2 < 2656     3803
3 > 14560*   3802
14763            1       2      0   14763    ROOT
1 < 4432     14004
14770            9       7      0   14770    ROOT
1 > 21713    11906
2 > 25470    12922
3 < 14770*   11908
1 > 23461    11907
2 < 3297     11746
3 > 17936    11745
3 > 5667     11744
4 > 14770*   9772
4 > 23461*   9773
14771            1       2      0   14771    ROOT
1 > 24127    4463
14842            2       3      0   14842    ROOT
1 > 24575    9988
2 < 8255     13350
14845            3       3      0   14845    ROOT
1 > 19521    13500
2 < 5232     13502
3 > 14845*   13501
14868            3       3      0   14868    ROOT
1 > 16226    9830
2 < 2201     9829
3 > 14868*   9828
14894            2       3      0   14894    ROOT
1 < 1670     9778
1 > 22927    9777
1490             1       2      0   1490     ROOT
1 > 20813    3849
14990            1       2      0   14990    ROOT
1 > 25975    13930
15181            1       2      0   15181    ROOT
1 < 2331     8932
15182           10       5      0   15182    ROOT
1 > 16728    12023
2 > 22319    12026
3 < 15182*   12024
3 > 23424    12028
4 < 15182*   12025
4 < 16728*   12027
4 < 8153     12022
5 > 15182*   12019
5 > 16728*   12020
5 > 22319*   12021
15188            1       2      0   15188    ROOT
1 < 6354     5992
15208            1       2      0   15208    ROOT
1 > 23759    9082
15218            1       2      0   15218    ROOT
1 > 17585    8869
15248            5       5      0   15248    ROOT
1 > 17595    13446
2 > 19018    8520
3 < 17076    4176
2 < 8443     13445
3 > 15248*   13444
15249            1       2      0   15249    ROOT
1 > 15624    3148
15259            2       3      0   15259    ROOT
1 > 25136    13139
2 < 22000    10613
15358            3       3      0   15358    ROOT
1 > 18036    12671
2 > 18338    12673
3 < 15358*   12672
15374            1       2      0   15374    ROOT
1 > 15553    14037
15387            1       2      0   15387    ROOT
1 > 15388    4994
15396            7       5      0   15396    ROOT
1 > 18238    11870
2 > 26180    11865
3 < 15396*   11871
3 < 4777     11869
4 > 15396*   11866
4 > 18238*   11867
4 > 19064    11868
15401            1       2      0   15401    ROOT
1 < 4196     13893
15415            3       4      0   15415    ROOT
1 > 24640    2865
2 < 24152    5206
2 < 4685     11740
15423            1       2      0   15423    ROOT
1 > 18144    9875
1551             2       3      0   1551     ROOT
1 > 8058     9269
2 < 2328     13800
15572            1       2      0   15572    ROOT
1 < 7356     7467
15583            4       4      0   15583    ROOT
1 > 17785    12058
2 > 18628    10047
2 > 24272    10048
3 < 15583*   12059
15609            1       2      0   15609    ROOT
1 > 21809    8705
15642            3       3      0   15642    ROOT
1 > 16783    14117
2 > 17563    10323
3 < 15642*   14118
15668            6       4      0   15668    ROOT
1 > 17293    10740
2 > 25614    10738
3 < 15668*   10741
3 > 26006    10743
4 < 15668*   10742
4 < 17293*   10739
15681            2       3      0   15681    ROOT
1 > 20793    8829
1 < 7482     8828
15688            1       2      0   15688    ROOT
1 > 22692    9551
15706            2       3      0   15706    ROOT
1 > 20776    6419
1 < 374      12104
15712            1       2      0   15712    ROOT
1 > 19596    10679
15824            1       2      0   15824    ROOT
1 > 22283    4049
15847            3       3      0   15847    ROOT
1 < 348      10620
2 > 5660     10619
3 > 15847*   10621
1589             1       2      0   1589     ROOT
1 > 7603     9073
15962            1       2      0   15962    ROOT
1 > 25447    13908
16015            1       2      0   16015    ROOT
1 > 22938    13260
16109            9       6      0   16109    ROOT
1 > 21808    6661
2 < 2784     6660
3 > 16109*   6659
3 > 5425     6658
4 > 16109*   2533
4 > 16224    2534
5 > 24161    2537
6 < 5425*    2536
4 > 21808*   2535
16124            3       3      0   16124    ROOT
1 > 20807    8756
2 > 24334    8758
3 < 16124*   8757
16129            3       3      0   16129    ROOT
1 < 2298     12973
2 < 74       12971
3 > 16129*   12972
1621             3       3      0   1621     ROOT
1 > 6576     11063
2 > 7109     11062
3 < 1621*    11064
16281            1       2      0   16281    ROOT
1 > 24728    4740
16312            1       2      0   16312    ROOT
1 > 16314    12399
16338            1       2      0   16338    ROOT
1 > 21390    9527
16358            3       3      0   16358    ROOT
1 < 822      11830
2 > 9518     11829
3 > 16358*   11831
16470            1       2      0   16470    ROOT
1 > 17822    1078
16484            1       2      0   16484    ROOT
1 < 8302     290
16523            2       3      0   16523    ROOT
1 < 4110     9867
2 > 17696    9868
16609            2       3      0   16609    ROOT
1 < 6170     12054
2 > 8881     12053
16620            8       6      0   16620    ROOT
1 < 1908     8034
2 > 16621    8035
3 < 2611     6945
4 > 16620*   6944
4 < 1908*    8033
4 < 376      6942
5 > 16620*   6943
2 > 17173    8036
16622            1       2      0   16622    ROOT
1 > 18454    12390
16643            1       2      0   16643    ROOT
1 > 20035    12052
16802            3       3      0   16802    ROOT
1 > 23757    9016
2 < 830      9018
3 > 16802*   9017
16892            3       3      0   16892    ROOT
1 > 19572    13495
2 < 3062     8588
3 > 16892*   8587
16922            1       2      0   16922    ROOT
1 > 20925    12923
1695             1       2      0   1695     ROOT
1 > 19380    7838
16957            2       3      0   16957    ROOT
1 < 3362     9779
2 < 3347     9780
16971            3       3      0   16971    ROOT
1 > 20170    13022
2 < 5228     13024
3 > 16971*   13023
17178            8       7      0   17178    ROOT
1 > 21024    9774
2 < 19712    8585
2 > 23215    8586
3 < 17178*   9775
2 < 8071     12245
1 < 2329     13300
2 > 24846    13301
3 < 17178*   9776
17179            3       3      0   17179    ROOT
1 > 24816    5256
2 < 9871     5255
3 > 17179*   5254
17276            3       3      0   17276    ROOT
1 > 18383    4020
2 < 9994     4019
3 > 17276*   4018
17280            7       5      0   17280    ROOT
1 > 19956    7470
2 < 2785     13505
3 > 17280*   13504
3 > 3682     13503
4 > 17280*   13506
4 > 19956*   13507
1 > 24597    7471
17291            3       3      0   17291    ROOT
1 < 4017     4627
2 > 7888     4626
3 > 17291*   4628
17346            3       3      0   17346    ROOT
1 > 20319    9991
2 < 9149     9916
3 > 17346*   9915
17461            3       3      0   17461    ROOT
1 < 188      7261
2 > 22920    7262
3 < 17461*   8965
17468            3       3      0   17468    ROOT
1 < 3200     9325
2 > 4264     9324
3 > 17468*   9326
17470            1       2      0   17470    ROOT
1 > 19221    12233
17471            1       2      0   17471    ROOT
1 < 3989     10774
17503            1       2      0   17503    ROOT
1 < 3748     13137
17690            1       2      0   17690    ROOT
1 < 5814     5763
17782           10       5      0   17782    ROOT
1 > 18231    10034
2 < 1989     10031
3 > 17782*   10030
3 > 4106     10028
4 > 17782*   13352
4 > 18231*   13353
4 > 7515     13351
5 > 17782*   10032
5 > 18231*   10033
5 < 1989*    10029
17865            3       4      0   17865    ROOT
1 > 24159    9131
2 < 4276     10554
2 < 717      9713
17951            1       2      0   17951    ROOT
1 < 833      8539
1798             3       3      0   1798     ROOT
1 > 4828     11136
2 > 5404     11138
3 < 1798*    11137
17992            1       2      0   17992    ROOT
1 < 4181     14179
18003            2       3      0   18003    ROOT
1 < 5545     8014
1 < 6709     3077
18034           18       8      0   18034    ROOT
1 < 1981     9113
2 > 19879    9114
3 < 18034*   9120
3 < 5468     9119
4 > 18034*   9118
4 < 1981*    9109
4 > 5668     9116
5 > 18034*   11977
5 < 1981*    9110
5 > 19879*   11978
5 > 8187     11976
6 > 18034*   9514
6 < 1981*    9112
6 > 19879*   9515
6 < 5468*    9117
2 > 25444    9115
3 < 6908     11813
4 < 1981*    9111
18098            1       2      0   18098    ROOT
1 < 3100     7819
18156            1       2      0   18156    ROOT
1 < 5387     12715
18171            2       3      0   18171    ROOT
1 < 5413     1730
1 < 85       7675
18183            1       2      0   18183    ROOT
1 < 4278     11748
18194            1       2      0   18194    ROOT
1 > 21949    12248
1821             3       3      0   1821     ROOT
1 < 187      6296
2 > 21386    6297
3 < 1821*    6298
18279            3       3      0   18279    ROOT
1 < 6389     8481
2 > 6914     8480
3 > 18279*   8482
1836             1       2      0   1836     ROOT
1 > 8400     12006
18388            1       2      0   18388    ROOT
1 > 20654    13869
18417            1       2      0   18417    ROOT
1 > 19892    13920
18544            3       3      0   18544    ROOT
1 > 21596    10321
2 < 2332     10320
3 > 18544*   10319
18581            1       2      0   18581    ROOT
1 < 2938     9797
18596            3       3      0   18596    ROOT
1 > 23771    12385
2 < 4144     12384
3 > 18596*   12383
18669            4       4      0   18669    ROOT
1 > 19866    10338
2 > 25545    10340
3 < 18669*   10339
3 < 8538     12898
18721            1       2      0   18721    ROOT
1 < 3067     6377
18895            1       2      0   18895    ROOT
1 < 7957     8872
18908            1       2      0   18908    ROOT
1 > 25531    13413
18970           10       5      0   18970    ROOT
1 < 2409     9807
2 > 3522     9804
3 > 18970*   9810
3 > 4286     9808
4 > 18970*   11115
4 < 2409*    9805
4 > 4288     11114
5 > 18970*   11116
5 < 2409*    9806
5 < 3522*    9809
18984            1       2      0   18984    ROOT
1 < 2476     6293
19015           10       5      0   19015    ROOT
1 > 19444    6633
2 > 25139    6635
3 < 19015*   6634
3 < 5212     6629
4 > 19015*   6627
4 > 19444*   6628
4 > 6628     6626
5 > 19015*   6630
5 > 19444*   6631
5 > 25139*   6632
19052            1       2      0   19052    ROOT
1 < 7713     289
19061            1       2      0   19061    ROOT
1 < 9094     1873
19145            1       2      0   19145    ROOT
1 > 23760    12719
1916             3       3      0   1916     ROOT
1 > 20953    6416
2 > 24463    6418
3 < 1916*    6417
19252            1       2      0   19252    ROOT
1 < 3195     6456
19257            3       3      0   19257    ROOT
1 > 22961    9462
2 < 7477     9461
3 > 19257*   9460
19314           15       6      0   19314    ROOT
1 > 19880    13363
2 > 25496    13371
3 < 19314*   13364
3 > 25543    13360
4 < 19314*   13365
4 < 19880*   13372
4 > 26019    13368
5 < 19314*   13366
5 < 19880*   13373
5 < 25496*   13361
5 > 26048    13370
6 < 19314*   13367
6 < 19880*   13374
6 < 25496*   13362
6 < 25543*   13369
194              1       2      0   194      ROOT
1 > 8628     7522
19466            3       3      0   19466    ROOT
1 > 24128    13695
2 < 7543     13697
3 > 19466*   13696
19473            1       2      0   19473    ROOT
1 > 23812    13340
19502            3       3      0   19502    ROOT
1 > 23970    13101
2 < 7718     13100
3 > 19502*   13099
19554            3       3      0   19554    ROOT
1 > 24878    7606
2 < 6159     7605
3 > 19554*   7604
1969             3       3      0   1969     ROOT
1 > 24141    13017
2 < 8472     13018
3 < 1969*    13016
1976             1       2      0   1976     ROOT
1 > 23672    14065
19906            1       2      0   19906    ROOT
1 > 26102    9469
19911            1       2      0   19911    ROOT
1 > 25487    7946
19932           12       7      0   19932    ROOT
1 > 19936    3994
2 < 2118     4090
2 > 25864    3996
3 < 19932*   3995
3 < 4199     3990
4 > 19932*   3988
4 > 19936*   3989
4 > 6443     3987
5 > 19932*   3991
5 > 19936*   3992
5 > 25864*   3993
2 > 26132    3997
19941            1       2      0   19941    ROOT
1 < 6079     9479
2004             1       2      0   2004     ROOT
1 > 21191    900
20084            1       2      0   20084    ROOT
1 > 22311    11060
20150            3       3      0   20150    ROOT
1 > 22312    9946
2 > 25226    9948
3 < 20150*   9947
20216            3       3      0   20216    ROOT
1 < 2223     12050
2 > 4266     12049
3 > 20216*   12051
20309            3       3      0   20309    ROOT
1 < 7267     13033
2 > 7280     13032
3 > 20309*   13031
20320            1       2      0   20320    ROOT
1 < 4643     13929
20333            1       2      0   20333    ROOT
1 < 4262     13275
20433            3       3      0   20433    ROOT
1 < 5446     11939
2 > 5632     11938
3 > 20433*   11940
20707            1       2      0   20707    ROOT
1 > 24820    13375
20803            2       3      0   20803    ROOT
1 > 25231    9268
1 < 6356     12964
20914            3       3      0   20914    ROOT
1 < 6008     6038
2 > 9959     6037
3 > 20914*   6036
21018            1       2      0   21018    ROOT
1 < 5479     8725
21028            1       2      0   21028    ROOT
1 < 8146     7558
2117             1       2      0   2117     ROOT
1 > 6300     8692
2119             1       2      0   2119     ROOT
1 > 7637     2066
2120             1       2      0   2120     ROOT
1 > 8157     288
21206            2       3      0   21206    ROOT
1 > 23175    1940
2 > 25662    1837
21288            3       4      0   21288    ROOT
1 < 8557     6253
2 > 26191    6254
2 < 8308     6255
21303            1       2      0   21303    ROOT
1 < 734      12168
21515            4       4      0   21515    ROOT
1 > 21523    9322
2 < 7916     8070
3 > 21515*   8069
3 < 28       8068
21579            1       2      0   21579    ROOT
1 < 373      8982
21593            1       2      0   21593    ROOT
1 > 22325    9803
21623            1       2      0   21623    ROOT
1 > 22605    12034
21684            6       5      0   21684    ROOT
1 > 22719    9328
2 < 21821    5235
2 > 22720    5236
3 < 21684*   9329
2 > 24169    5237
3 < 21684*   9330
22021            1       2      0   22021    ROOT
1 < 8811     10312
22110            1       2      0   22110    ROOT
1 < 5231     11035
22378            1       2      0   22378    ROOT
1 < 2762     4741
22435            1       2      0   22435    ROOT
1 < 5406     13288
2248             1       2      0   2248     ROOT
1 > 8409     12903
22827            3       3      0   22827    ROOT
1 < 5256     13257
2 > 5257     13256
3 > 22827*   13258
22891            1       2      0   22891    ROOT
1 < 25       8058
2304             6       4      0   2304     ROOT
1 < 360      11887
2 > 7602     11888
3 < 2304*    11890
3 > 8307     11892
4 < 2304*    11891
4 < 360*     11889
23094            1       2      0   23094    ROOT
1 < 2561     13015
2339             1       2      0   2339     ROOT
1 > 24594    3965
23416            1       2      0   23416    ROOT
1 < 3074     7925
23465            1       2      0   23465    ROOT
1 < 598      4505
23480            1       2      0   23480    ROOT
1 > 23652    5173
23772            1       2      0   23772    ROOT
1 < 735      12948
23776            1       2      0   23776    ROOT
1 < 8708     460
23811            3       3      0   23811    ROOT
1 < 4038     13143
2 > 7058     13142
3 > 23811*   13144
23856            2       3      0   23856    ROOT
1 > 24451    5693
2 < 4252     1759
23881            1       2      0   23881    ROOT
1 < 5577     7611
24202            1       2      0   24202    ROOT
1 < 2624     7464
24214            1       2      0   24214    ROOT
1 < 4116     13349
24464            1       2      0   24464    ROOT
1 < 8336     9272
24504            1       2      0   24504    ROOT
1 < 8054     12033
24733            1       2      0   24733    ROOT
1 < 6776     13049
24957            3       3      0   24957    ROOT
1 < 4019     6240
2 > 5626     6239
3 > 24957*   6241
25062            1       2      0   25062    ROOT
1 < 8735     12072
25095            1       2      0   25095    ROOT
1 < 9130     13214
254              1       2      0   254      ROOT
1 > 7572     9945
25492            9       6      0   25492    ROOT
1 > 25511    13407
2 < 8512     13406
3 > 25492*   13405
3 > 9715     13404
4 > 25492*   11133
4 > 25511*   11134
4 < 4034     11130
5 > 9717     11131
6 < 9715*    11132
25510            1       2      0   25510    ROOT
1 < 3279     9327
2557             1       2      0   2557     ROOT
1 > 4272     9656
25676            3       3      0   25676    ROOT
1 < 350      3528
2 > 951      3527
3 > 25676*   3529
2569             1       2      0   2569     ROOT
1 > 5546     1820
25853            1       2      0   25853    ROOT
1 < 8404     8057
26022            3       3      0   26022    ROOT
1 < 4021     8577
2 > 4826     8576
3 > 26022*   8575
294              1       2      0   294      ROOT
1 > 8626     4086
2981             1       2      0   2981     ROOT
1 > 4427     9683
3206             2       3      0   3206     ROOT
1 > 6535     7976
1 > 6579     7977
3844             1       2      0   3844     ROOT
1 < 82       9542
410              1       2      0   410      ROOT
1 > 4366     13307
4254             1       2      0   4254     ROOT
1 > 9337     2681
4954             1       2      0   4954     ROOT
1 > 4955     9567
5083             3       3      0   5083     ROOT
1 > 5084     3494
2 > 8711     3496
3 < 5083*    3495
5137             1       2      0   5137     ROOT
1 > 6884     9209
5261             1       2      0   5261     ROOT
1 > 6282     13379
5409             1       2      0   5409     ROOT
1 > 8623     9568
5486             1       2      0   5486     ROOT
1 > 8366     13376
5490             1       2      0   5490     ROOT
1 > 8474     14046
5492             1       2      0   5492     ROOT
1 > 5853     13722
6072             1       2      0   6072     ROOT
1 > 8887     914
6161             1       2      0   6161     ROOT
1 > 7055     8578
6229             2       3      0   6229     ROOT
1 > 6423     7947
1 > 7647     7948
6446             1       2      0   6446     ROOT
1 > 8036     9161
6669             1       2      0   6669     ROOT
1 > 9865     9691
6744             1       2      0   6744     ROOT
1 > 9595     4285
7534             1       2      0   7534     ROOT
1 > 7536     10346
7588             1       2      0   7588     ROOT
1 > 7590     9718
8534             1       2      0   8534     ROOT
1 > 8676     12343
8615             1       2      0   8615     ROOT
1 < 925      3541

14838 rows selected.

Elapsed: 00:00:10.56
Network summary 1 - by network

Network     #Links  #Nodes    Max Lev
---------- ------- ------- ----------
21593            2       2          1
21623            2       2          1
22021            2       2          1
22110            2       2          1
22378            2       2          1
22435            2       2          1
2248             2       2          1
22891            2       2          1
23094            2       2          1
2339             2       2          1
23416            2       2          1
23465            2       2          1
23480            2       2          1
23772            2       2          1
23776            2       2          1
23881            2       2          1
24202            2       2          1
24214            2       2          1
24464            2       2          1
24504            2       2          1
24733            2       2          1
25062            2       2          1
25095            2       2          1
254              2       2          1
25510            2       2          1
2557             2       2          1
2569             2       2          1
25853            2       2          1
294              2       2          1
2981             2       2          1
3844             2       2          1
410              2       2          1
4254             2       2          1
4954             2       2          1
5137             2       2          1
5261             2       2          1
5409             2       2          1
5486             2       2          1
5490             2       2          1
5492             2       2          1
6072             2       2          1
6161             2       2          1
6446             2       2          1
6669             2       2          1
6744             2       2          1
7534             2       2          1
7588             2       2          1
8534             2       2          1
8615             2       2          1
15208            2       2          1
15218            2       2          1
15249            2       2          1
15374            2       2          1
15387            2       2          1
15401            2       2          1
15423            2       2          1
15572            2       2          1
15609            2       2          1
15688            2       2          1
15712            2       2          1
15824            2       2          1
1589             2       2          1
15962            2       2          1
16015            2       2          1
16281            2       2          1
16312            2       2          1
16338            2       2          1
16470            2       2          1
16484            2       2          1
16622            2       2          1
16643            2       2          1
16922            2       2          1
1695             2       2          1
17470            2       2          1
17471            2       2          1
17503            2       2          1
17690            2       2          1
17951            2       2          1
17992            2       2          1
18098            2       2          1
18156            2       2          1
18183            2       2          1
18194            2       2          1
1836             2       2          1
18388            2       2          1
18417            2       2          1
18581            2       2          1
18721            2       2          1
18895            2       2          1
18908            2       2          1
18984            2       2          1
19052            2       2          1
19061            2       2          1
19145            2       2          1
19252            2       2          1
194              2       2          1
19473            2       2          1
1976             2       2          1
19906            2       2          1
19911            2       2          1
19941            2       2          1
2004             2       2          1
20084            2       2          1
20320            2       2          1
20333            2       2          1
20707            2       2          1
21018            2       2          1
21028            2       2          1
2117             2       2          1
2119             2       2          1
2120             2       2          1
21303            2       2          1
21579            2       2          1
10002            2       2          1
1010             2       2          1
10133            2       2          1
10148            2       2          1
10356            2       2          1
10382            2       2          1
10407            2       2          1
10433            2       2          1
1050             2       2          1
10517            2       2          1
10522            2       2          1
10559            2       2          1
10602            2       2          1
10638            2       2          1
10676            2       2          1
10897            2       2          1
1107             2       2          1
11215            2       2          1
11280            2       2          1
11411            2       2          1
11459            2       2          1
11462            2       2          1
11467            2       2          1
11579            2       2          1
11623            2       2          1
11641            2       2          1
11642            2       2          1
11718            2       2          1
11828            2       2          1
1187             2       2          1
11911            2       2          1
1194             2       2          1
11971            2       2          1
11991            2       2          1
12041            2       2          1
12050            2       2          1
12161            2       2          1
12248            2       2          1
12473            2       2          1
12504            2       2          1
12554            2       2          1
12751            2       2          1
12863            2       2          1
13022            2       2          1
13413            2       2          1
1344             2       2          1
1346             2       2          1
13621            2       2          1
13675            2       2          1
13717            2       2          1
1376             2       2          1
14               2       2          1
14130            2       2          1
14131            2       2          1
14132            2       2          1
14182            2       2          1
14338            2       2          1
14358            2       2          1
14763            2       2          1
14771            2       2          1
1490             2       2          1
14990            2       2          1
15181            2       2          1
15188            2       2          1
10115            3       3          1
1013             3       3          2
10317            3       3          1
10432            3       3          1
10513            3       3          1
1092             3       3          1
11216            3       3          2
12252            3       3          2
12256            3       3          1
12290            3       3          1
12617            3       3          2
12676            3       3          2
12703            3       3          1
12704            3       3          2
12798            3       3          2
12940            3       3          2
13485            3       3          2
14339            3       3          2
14842            3       3          2
14894            3       3          1
15259            3       3          2
1551             3       3          2
15681            3       3          1
15706            3       3          1
16523            3       3          2
16609            3       3          2
16957            3       3          2
18003            3       3          1
18171            3       3          1
20803            3       3          1
21206            3       3          2
23856            3       3          2
3206             3       3          1
6229             3       3          1
10178            4       3          3
10180            4       3          3
10252            4       3          3
1051             4       3          3
10818            4       3          3
10872            4       3          3
10936            4       4          1
11054            4       3          3
11120            4       4          1
11196            4       4          2
11197            4       3          3
11285            4       3          3
11465            4       3          3
11566            4       3          3
11893            4       3          3
11965            4       4          2
11969            4       3          3
12192            4       3          3
12307            4       3          3
12320            4       3          3
12338            4       3          3
12616            4       3          3
13012            4       3          3
13167            4       3          3
13202            4       4          3
13415            4       3          3
13486            4       3          3
13677            4       3          3
14560            4       3          3
14845            4       3          3
14868            4       3          3
15358            4       3          3
15415            4       4          2
15642            4       3          3
15847            4       3          3
16124            4       3          3
16129            4       3          3
1621             4       3          3
16358            4       3          3
16802            4       3          3
16892            4       3          3
16971            4       3          3
17179            4       3          3
17276            4       3          3
17291            4       3          3
17346            4       3          3
17461            4       3          3
17468            4       3          3
17865            4       4          2
1798             4       3          3
1821             4       3          3
18279            4       3          3
18544            4       3          3
18596            4       3          3
1916             4       3          3
19257            4       3          3
19466            4       3          3
19502            4       3          3
19554            4       3          3
1969             4       3          3
20150            4       3          3
20216            4       3          3
20309            4       3          3
20433            4       3          3
20914            4       3          3
21288            4       4          2
22827            4       3          3
23811            4       3          3
24957            4       3          3
25676            4       3          3
26022            4       3          3
5083             4       3          3
13031            5       4          3
12801            5       4          3
18669            5       4          3
14543            5       4          3
11427            5       4          4
10682            5       4          3
10679            5       4          3
15583            5       4          3
10637            5       4          3
21515            5       4          3
13357            5       4          3
12113            5       4          4
13932            5       4          4
14159            5       4          3
10154            6       4          4
11842            6       5          4
10906            6       6          2
15248            6       5          3
10355            6       6          2
11418            6       5          4
11279            6       5          3
11622            6       5          3
12689            7       4          4
11561            7       6          4
1154             7       5          5
11028            7       4          4
10672            7       4          4
10564            7       5          3
10341            7       4          4
2304             7       4          4
21684            7       5          3
15668            7       4          4
14353            7       5          4
13802            7       4          4
15396            8       5          4
11539            8       5          4
12046            8       8          3
10904            8       7          4
11879            8       6          5
12387            8       6          4
17280            8       5          4
17178            9       7          3
16620            9       6          5
16109           10       6          6
14770           10       7          4
25492           10       6          6
10884           11       7          6
11593           11      10          5
11662           11       5          5
15182           11       5          5
17782           11       5          5
18970           11       5          5
19015           11       5          5
1383            12       6          6
10792           12       7          6
10056           12       6          5
19932           13       7          5
11616           13       9          5
11009           13       8          5
12414           14       8          6
13325           15       8          7
10338           15       7          6
19314           16       6          6
12034           16       6          6
18034           19       8          6
11823           20       9          7
12042           21      12         10
12213           22       7          7
10163           25       8          8
10677           30      14         11
1000         13423    4158       1146

354 rows selected.

Elapsed: 00:00:01.75
Network summary 2 - grouped by numbers of nodes

#Nodes #Networks
------- ---------
2       177
3        98
4        30
5        17
6        12
7         8
8         6
9         2
10         1
12         1
14         1
4158         1

12 rows selected.

Elapsed: 00:00:01.44
```

The results show that the data set contains 354 connected networks, with one much larger than the rest, having 4158 nodes. This (more or less) matches with the results we got from source 3466. Actually, we should get one fewer record back than the number of nodes in the network, but as in the earlier article the SQL returns the source node in one record - we can easily fix this, but it's not worthwhile my redoing all the results, so I leave it as is.

As another check, we can run against the second largest network, using 10677 as the source, which should give 14 records. Here is the result for SP_GTTRSF_Q, LEVMAX=10.

```NODE                            LEV  MAXLEV  INTNOD  INTMAX PATH
------------------------------ ---- ------- ------- ------- --------------------------------------------------------------------------------
309                               1       2       1       2 309
9591                              1       2       1       2 9591
..2136                            2       2       2       2 9591,2136
..2186                            2       2       2       2 9591,2186
..6012                            2       2       2       2 9591,6012
..11030                           2       2       2       2 9591,11030
..13704                           2       2       2       2 9591,13704
..17453                           2       2       2       2 9591,17453
..23946                           2       2       2       2 9591,23946
..25611                           2       2       2       2 9591,25611
17015                             1       2       1       2 17015
..10677                           2       2       2       2 9591,10677
..20560                           2       2       2       2 309,20560
..21314                           2       2       2       2 17015,21314

14 rows selected.
```

This is consistent with the network output with source node appearing once. The network output (usually I indent the records by level, but the level is very high in some networks here) is:

```Network     #Links  #Nodes    Lev Node       Link
---------- ------- ------- ------ ---------- ----------
10677           29      14      0   10677    ROOT
1 > 17015    9130
2 > 20560    7465
3 < 309      7253
4 > 10677*   7250
4 > 17015*   7251
4 > 17453    7252
5 < 11030    10700
6 > 23946    10701
7 < 17453*   4282
7 > 25611    10703
8 < 11030*   10702
8 < 17453*   4283
8 < 6012     8987
9 > 11030*   8984
9 > 17453*   8985
9 > 23946*   8986
9 > 9591     8983
10 > 10677*   4275
10 > 11030*   4276
10 > 13704    4277
10 > 17015*   4278
10 > 17453*   4279
10 < 2136     4273
11 > 17453*   4274
10 < 2186     14089
10 > 23946*   4280
10 > 25611*   4281
10 < 309*     7249
2 > 21314    7466
```

Results: Friendship network of Brightkite users

Friendship network of Brightkite users

Brightkite was once a location-based social networking service provider where users shared their locations by checking-in. The friendship network was collected using their public API, and consists of 58,228 nodes and 214,078 edges. The network is originally directed but we have constructed a network with undirected edges when there is a friendship in both ways.

The data set comes with the reverse arcs already present, making a total of 428,156 arcs.

I took the first node in the first line in the data set file as the initial root node, 0, and tested only the method SP_GTTRSF_I/Q for values of LEVMAX of 5, 10. The complete results, including execution plans are in the attached file.

The exact solution has 56,739 nodes reached from the source node 0, with a maximum level of 10. The output is a bit large to embed, so attaching it in file, but here are the last few lines of the exact solution:

```122                               1      10       1      13 122
..0                               2      10       2      13 99,0
..6534                            2      10       2      13 122,6534
....15726                         3      10       3      13 40,647,15726
......42871                       4      10       4      13 69,4994,12608,42871
......45149                       4      10       4      13 40,2886,15714,45149
......45850                       4      10       4      13 122,6534,15726,45850
......45851                       4      10       4      13 40,2886,22440,45851
......45852                       4      10       4      13 122,6534,15726,45852
......45853                       4      10       4      13 40,2886,26635,45853
......45854                       4      10       4      13 36,2625,15736,45854
......45855                       4      10       4      13 122,6534,15726,45855
......45856                       4      10       4      13 122,6534,15726,45856
....15744                         3      10       3      13 40,647,15744
....34944                         3      10       3      13 122,6534,34944
....34945                         3      10       3      13 122,6534,34945
....34946                         3      10       3      13 122,6534,34946

56739 rows selected.

Elapsed: 00:01:32.49
```

In summary, as shown in the embedded Excel file, the exact solution is found in a total of 105 seconds and 344 seconds (based on Xplan timings) for LEVMAX=5 and 10 respectively.

I ran my network analysis program on this network too, and here is the final grouped results, showing consistency with the largest connected network of 56,739 nodes.

```Network summary 2 - grouped by numbers of nodes

#Nodes #Networks
------- ---------
2       362
3       103
4        40
5        21
6         9
7         3
8         2
9         1
10         2
11         2
49         1
56739         1

12 rows selected.

Elapsed: 00:00:24.17
```

We can do a further test by using a source from a smaller network. 51944 is a root of the network of size 49 nodes (as the full output shows). Here is the result of sourcing from that, again consistent witht he network analysis program that uses a completely diffferent algorithm:

```NODE                            LEV  MAXLEV  INTNOD  INTMAX PATH
------------------------------ ---- ------- ------- ------- --------------------------------------------------------------------------------
57077                             1       7       1       9 57077
..51944                           2       7       2       9 57077,51944
..57969                           2       7       2       9 57077,57969
....58151                         3       7       3       9 57077,57969,58151
......58195                       4       7       4       9 57077,57969,58151,58195
........58218                     5       7       5       9 57077,57969,58151,58195,58218
......58196                       4       7       4       9 57077,57969,58151,58196
......58197                       4       7       4       9 57077,57969,58151,58197
......58198                       4       7       4       9 57077,57969,58151,58198
......58199                       4       7       4       9 57077,57969,58151,58199
......58201                       4       7       4       9 57077,57969,58151,58201
......58202                       4       7       4       9 57077,57969,58151,58202
......58203                       4       7       4       9 57077,57969,58151,58203
....58152                         3       7       3       9 57077,57969,58152
......58205                       4       7       4       9 57077,57969,58152,58205
........58219                     5       7       5       9 57077,57969,58152,58205,58219
..........58224                   6       7       6       9 57077,57969,58152,58205,58219,58224
........58220                     5       7       5       9 57077,57969,58152,58205,58220
..........58226                   6       7       8       9 57077,57969,58152,58205,58220,58226
............58227                 7       7       8       9 57077,57969,58152,58205,58220,58225,58227
..........58225                   6       7       9       9 57077,57969,58152,58205,58220,58225
........58221                     5       7       5       9 57077,57969,58152,58205,58221
......58207                       4       7       4       9 57077,57969,58152,58207
....58153                         3       7       3       9 57077,57969,58153
....58154                         3       7       3       9 57077,57969,58154
......58208                       4       7       4       9 57077,57969,58154,58208
......58209                       4       7       4       9 57077,57969,58154,58209
....58156                         3       7       3       9 57077,57969,58156
....58159                         3       7       3       9 57077,57969,58159
......58200                       4       7       4       9 57077,57969,58159,58200
....58160                         3       7       3       9 57077,57969,58160
......58210                       4       7       4       9 57077,57969,58160,58210
........58222                     5       7       5       9 57077,57969,58160,58210,58222
......58211                       4       7       4       9 57077,57969,58160,58211
......58212                       4       7       4       9 57077,57969,58160,58212
........58223                     5       7       5       9 57077,57969,58160,58212,58223
....58161                         3       7       3       9 57077,57969,58161
......58204                       4       7       4       9 57077,57969,58161,58204
......58206                       4       7       4       9 57077,57969,58161,58206
..57970                           2       7       2       9 57077,57970
....58155                         3       7       3       9 57077,57970,58155
....58157                         3       7       3       9 57077,57970,58157
....58158                         3       7       3       9 57077,57970,58158
..57971                           2       7       2       9 57077,57971
..57972                           2       7       2       9 57077,57972
....58162                         3       7       3       9 57077,57972,58162
..57973                           2       7       2       9 57077,57973
..57974                           2       7       2       9 57077,57974
....58163                         3       7       3       9 57077,57974,58163

49 rows selected.

Elapsed: 00:00:00.21
```

[4 May 2015 - I will add attachments in the next few days after tidying up, including the network analysis package]
[11 May 2015: I added PL/SQL Pipelined Function for Network Analysis]

# SQL for the Travelling Salesman Problem

‘The travelling salesman problem (TSP) or travelling salesperson problem asks the following question: Given a list of cities and the distances between each pair of cities, what is the shortest possible route that visits each city exactly once and returns to the origin city? It is an NP-hard problem in combinatorial optimization, important in operations research and theoretical computer science.’Travelling salesman problem.

[‘or travelling salesperson problem’ – :)]

I posted a couple of articles recently on approximate solution methods for ‘hard’ combinatorial problems using SQL, SQL for the Balanced Number Partitioning Problem and SQL for the Fantasy Football Knapsack Problem, and I wondered whether similar techniques could be applied to TSP. This article provides my answer.

Updated, 20 February 2016: Added attachment with the input data files, DDL and raw results at the end.

Update, 12 November 2017: I have added all the scripts necessary to run the SQL against the two example datasets to my GitHub repo: Brendan’s repo for interesting SQL. I also add a link to a recent useful primer on TSP: The Trials And Tribulations Of The Traveling Salesman.

Test Problems

I used two test problems, the first being a simple constructed example of five towns arranged in an M-shape. The second is a more realistic problem based on 312 towns in USA and Canada, the data for which I found on a university web site.

Test Problem 1: Emland

The first problem is small enough to verify the solutions manually.

The Short Route

The Long Route

Test Problem 2: USCA312

I got the second problem here, City Distance Datasets, described thus:
‘USCA312 describes 312 cities in the US and Canada. Distances between the city are computed from latitude and longitude, not from road mileage’

I took the distances based on the x-y values given, using the simple Euclidean distance formula. I am aware that this will not give accurate distances, but it seemed the simplest approach as the provided distances were in a format not so easy to load into a database, and I am interested only in the technical aspects.

SQL Solution with Recursive Subquery Factoring

SQL

```WITH count_towns AS (
SELECT Count(*) n_towns FROM towns
), dist_from_root AS (/* XTSP  */
SELECT a, b, dst, Row_Number () OVER (ORDER BY :SIGN * dst) rnk_by_dst, Count(DISTINCT a) OVER () + 1 n_towns
FROM distances
WHERE b > a
),  rsf (root, root_leg, path_rnk, nxt_id, lev, tot_price, path, n_towns) AS (
SELECT a, a || ' -> ' || b, 0, d.b, 2, d.dst,
CAST ('|' || LPad (d.a, 3, '0') || '|' || LPad (d.b, 3, '0') AS VARCHAR2(4000)) path,
d.n_towns
FROM dist_from_root d
WHERE d.rnk_by_dst <= :KEEP_NUM_ROOT
UNION ALL
SELECT r.root,
r.root_leg,
Row_Number() OVER (PARTITION BY r.root_leg ORDER BY :SIGN * (r.tot_price + d.dst)),
d.b,
r.lev + 1,
r.tot_price + d.dst,
r.path || '|' || LPad (d.b, 3, '0'),
r.n_towns
FROM rsf r
JOIN distances d
ON d.a = r.nxt_id
AND r.path NOT LIKE '%' || '|' || LPad (d.b, 3, '0') || '%'
WHERE r.path_rnk <= :KEEP_NUM
), circuits AS (
SELECT r.root_leg,
Row_Number() OVER (PARTITION BY r.root_leg ORDER BY :SIGN * (r.tot_price + d.dst)) path_rnk,
r.tot_price + d.dst tot_price,
r.path || '|' || LPad (d.b, 3, '0') path
FROM rsf r
JOIN distances d
ON d.a = r.nxt_id
AND d.b = r.root
WHERE r.lev = r.n_towns
AND r.path_rnk <= :KEEP_NUM
), top_n_paths AS (
SELECT root_leg,
tot_price,
path,
path_rnk,
town_index
FROM circuits
CROSS JOIN (SELECT LEVEL town_index FROM count_towns c CONNECT BY LEVEL <= c.n_towns + 1)
WHERE path_rnk <= :KEEP_NUM
), top_n_sets AS (
SELECT root_leg,
tot_price,
path,
path_rnk,
town_index,
To_Number (Substr (path, (town_index - 1) * 4 + 2, 3)) town_id,
Lag (To_Number (Substr (path, (town_index - 1) * 4 + 2, 3))) OVER (PARTITION BY root_leg, path_rnk ORDER BY town_index) town_id_prior
FROM top_n_paths
)
SELECT /*+ GATHER_PLAN_STATISTICS */
top.root_leg,
top.path_rnk,
Round (top.tot_price, 2) tot_dist,
top.town_id,
twn.name,
Round (dst.dst, 2) leg_dist,
Round (Sum (dst.dst) OVER (PARTITION BY root_leg, path_rnk ORDER BY town_index), 2) cum_dist
FROM top_n_sets top
JOIN towns twn
ON twn.id = top.town_id
LEFT JOIN distances dst
ON dst.a = top.town_id_prior
AND dst.b = top.town_id
ORDER BY top.root_leg, top.path_rnk, top.town_index
```

How It Works

Bind Variables
==============
SIGN – 1 means minimise distance; -1, maximise it
KEEP_NUM_ROOT – number of best anchor records (root legs) to retain (throughout)
KEEP_NUM – number of best records from previous iteration to retain, partitioning by root leg

The solution approach is based on the idea I had in my last article whereby recursive subquery factoring is at the heart of the method, and analytic row numbering is used to reduce searching to manageable proportions at each iteration. The bind variables control the level of searching desired.

• count_towns subquery – simply counts the total number of towns
• dist_from_root subquery – gets the distance between each pair of towns, without duplication, and ranks the pairs by distance
• rsf subquery, anchor branch – selects the KEEP_NUM_ROOT best legs as roots for the recursion
• rsf subquery, recursive branch – joins up to KEEP_NUM best records from last iteration all possible town via distances table, using pattern matching to exclude towns already visited
• The recursive branch stores the towns visited in a delimited string
• Analytic funtion Row_Number is used to rank the recursive branch result set at each iteration, partitioning by root leg for use in the next iteration
• circuits subquery – completes the circuit by joining the root leg via the distances table, doing the same constraint by rank and analytic ranking as the recursive branch
• top_n_paths subquery – uses a standard row generator subquery to generate indexed rows for the number of towns in the final path (my where clause looks redundant as I write)
• top_n_sets subquery – extracts the town id from the path using the index derived in the previous subquery, and gets the previous town id using analytic Lag
• Main query – joins towns table to get the town name and distances table for leg distances

Results

Test Problem 1: Emland

I used keep values of 5 and 5 and solved the shortest routes problem in 0.14 seconds, and the longest in 0.16 seconds.

```Shortest Routes
===============
ROOT_LEG       PATH_RNK   TOT_DIST    TOWN_ID NAME                             LEG_DIST   CUM_DIST
------------ ---------- ---------- ---------- ------------------------------ ---------- ----------
1 -> 2                1      10.94          1 Left Floor
2 Left Peak                            2.24       2.24
4 Right Peak                              2       4.24
5 Right Floor                          2.24       6.47
3 Midfield                             2.24       8.71
1 Left Floor                           2.24      10.94
2       11.3          1 Left Floor
2 Left Peak                            2.24       2.24
3 Midfield                             1.41       3.65
4 Right Peak                           1.41       5.06
5 Right Floor                          2.24        7.3
1 Left Floor                              4       11.3
3      11.73          1 Left Floor
2 Left Peak                            2.24       2.24
5 Right Floor                          3.61       5.84
4 Right Peak                           2.24       8.08
3 Midfield                             1.41       9.49
1 Left Floor                           2.24      11.73
4      11.73          1 Left Floor
2 Left Peak                            2.24       2.24
3 Midfield                             1.41       3.65
5 Right Floor                          2.24       5.89
4 Right Peak                           2.24       8.12
1 Left Floor                           3.61      11.73
5      11.89          1 Left Floor
2 Left Peak                            2.24       2.24
4 Right Peak                              2       4.24
3 Midfield                             1.41       5.65
5 Right Floor                          2.24       7.89
1 Left Floor                              4      11.89
2 -> 3                1       11.3          2 Left Peak
3 Midfield                             1.41       1.41
4 Right Peak                           1.41       2.83
5 Right Floor                          2.24       5.06
1 Left Floor                              4       9.06
2 Left Peak                            2.24       11.3
2      11.73          2 Left Peak
3 Midfield                             1.41       1.41
5 Right Floor                          2.24       3.65
4 Right Peak                           2.24       5.89
1 Left Floor                           3.61       9.49
2 Left Peak                            2.24      11.73
3       13.1          2 Left Peak
3 Midfield                             1.41       1.41
1 Left Floor                           2.24       3.65
4 Right Peak                           3.61       7.26
5 Right Floor                          2.24       9.49
2 Left Peak                            3.61       13.1
4      13.26          2 Left Peak
3 Midfield                             1.41       1.41
5 Right Floor                          2.24       3.65
1 Left Floor                              4       7.65
4 Right Peak                           3.61      11.26
2 Left Peak                               2      13.26
5      14.04          2 Left Peak
3 Midfield                             1.41       1.41
4 Right Peak                           1.41       2.83
1 Left Floor                           3.61       6.43
5 Right Floor                             4      10.43
2 Left Peak                            3.61      14.04
2 -> 4                1      10.94          2 Left Peak
4 Right Peak                              2          2
5 Right Floor                          2.24       4.24
3 Midfield                             2.24       6.47
1 Left Floor                           2.24       8.71
2 Left Peak                            2.24      10.94
2      11.89          2 Left Peak
4 Right Peak                              2          2
3 Midfield                             1.41       3.41
5 Right Floor                          2.24       5.65
1 Left Floor                              4       9.65
2 Left Peak                            2.24      11.89
3      11.89          2 Left Peak
4 Right Peak                              2          2
5 Right Floor                          2.24       4.24
1 Left Floor                              4       8.24
3 Midfield                             2.24      10.47
2 Left Peak                            1.41      11.89
4      13.26          2 Left Peak
4 Right Peak                              2          2
3 Midfield                             1.41       3.41
1 Left Floor                           2.24       5.65
5 Right Floor                             4       9.65
2 Left Peak                            3.61      13.26
5      13.68          2 Left Peak
4 Right Peak                              2          2
1 Left Floor                           3.61       5.61
3 Midfield                             2.24       7.84
5 Right Floor                          2.24      10.08
2 Left Peak                            3.61      13.68
3 -> 4                1       11.3          3 Midfield
4 Right Peak                           1.41       1.41
5 Right Floor                          2.24       3.65
1 Left Floor                              4       7.65
2 Left Peak                            2.24       9.89
3 Midfield                             1.41       11.3
2      11.73          3 Midfield
4 Right Peak                           1.41       1.41
5 Right Floor                          2.24       3.65
2 Left Peak                            3.61       7.26
1 Left Floor                           2.24       9.49
3 Midfield                             2.24      11.73
3      11.89          3 Midfield
4 Right Peak                           1.41       1.41
2 Left Peak                               2       3.41
1 Left Floor                           2.24       5.65
5 Right Floor                             4       9.65
3 Midfield                             2.24      11.89
4       13.1          3 Midfield
4 Right Peak                           1.41       1.41
1 Left Floor                           3.61       5.02
2 Left Peak                            2.24       7.26
5 Right Floor                          3.61      10.86
3 Midfield                             2.24       13.1
5      13.26          3 Midfield
4 Right Peak                           1.41       1.41
2 Left Peak                               2       3.41
5 Right Floor                          3.61       7.02
1 Left Floor                              4      11.02
3 Midfield                             2.24      13.26
3 -> 5                1      10.94          3 Midfield
5 Right Floor                          2.24       2.24
4 Right Peak                           2.24       4.47
2 Left Peak                               2       6.47
1 Left Floor                           2.24       8.71
3 Midfield                             2.24      10.94
2      11.73          3 Midfield
5 Right Floor                          2.24       2.24
4 Right Peak                           2.24       4.47
1 Left Floor                           3.61       8.08
2 Left Peak                            2.24      10.31
3 Midfield                             1.41      11.73
3      11.89          3 Midfield
5 Right Floor                          2.24       2.24
1 Left Floor                              4       6.24
2 Left Peak                            2.24       8.47
4 Right Peak                              2      10.47
3 Midfield                             1.41      11.89
4       13.1          3 Midfield
5 Right Floor                          2.24       2.24
2 Left Peak                            3.61       5.84
1 Left Floor                           2.24       8.08
4 Right Peak                           3.61      11.68
3 Midfield                             1.41       13.1
5      13.68          3 Midfield
5 Right Floor                          2.24       2.24
2 Left Peak                            3.61       5.84
4 Right Peak                              2       7.84
1 Left Floor                           3.61      11.45
3 Midfield                             2.24      13.68

150 rows selected.

Elapsed: 00:00:00.14
```
```Longest Routes
==============
ROOT_LEG       PATH_RNK   TOT_DIST    TOWN_ID NAME                             LEG_DIST   CUM_DIST
------------ ---------- ---------- ---------- ------------------------------ ---------- ----------
1 -> 2                1       13.1          1 Left Floor
2 Left Peak                            2.24       2.24
5 Right Floor                          3.61       5.84
3 Midfield                             2.24       8.08
4 Right Peak                           1.41       9.49
1 Left Floor                           3.61       13.1
2      11.89          1 Left Floor
2 Left Peak                            2.24       2.24
4 Right Peak                              2       4.24
3 Midfield                             1.41       5.65
5 Right Floor                          2.24       7.89
1 Left Floor                              4      11.89
3      11.73          1 Left Floor
2 Left Peak                            2.24       2.24
5 Right Floor                          3.61       5.84
4 Right Peak                           2.24       8.08
3 Midfield                             1.41       9.49
1 Left Floor                           2.24      11.73
4      11.73          1 Left Floor
2 Left Peak                            2.24       2.24
3 Midfield                             1.41       3.65
5 Right Floor                          2.24       5.89
4 Right Peak                           2.24       8.12
1 Left Floor                           3.61      11.73
5      10.94          1 Left Floor
2 Left Peak                            2.24       2.24
4 Right Peak                              2       4.24
5 Right Floor                          2.24       6.47
3 Midfield                             2.24       8.71
1 Left Floor                           2.24      10.94
1 -> 4                1      13.68          1 Left Floor
4 Right Peak                           3.61       3.61
2 Left Peak                               2       5.61
5 Right Floor                          3.61       9.21
3 Midfield                             2.24      11.45
1 Left Floor                           2.24      13.68
2      13.26          1 Left Floor
4 Right Peak                           3.61       3.61
2 Left Peak                               2       5.61
3 Midfield                             1.41       7.02
5 Right Floor                          2.24       9.26
1 Left Floor                              4      13.26
3       13.1          1 Left Floor
4 Right Peak                           3.61       3.61
5 Right Floor                          2.24       5.84
2 Left Peak                            3.61       9.45
3 Midfield                             1.41      10.86
1 Left Floor                           2.24       13.1
4       13.1          1 Left Floor
4 Right Peak                           3.61       3.61
3 Midfield                             1.41       5.02
5 Right Floor                          2.24       7.26
2 Left Peak                            3.61      10.86
1 Left Floor                           2.24       13.1
5      11.73          1 Left Floor
4 Right Peak                           3.61       3.61
5 Right Floor                          2.24       5.84
3 Midfield                             2.24       8.08
2 Left Peak                            1.41       9.49
1 Left Floor                           2.24      11.73
1 -> 5                1      14.04          1 Left Floor
5 Right Floor                             4          4
2 Left Peak                            3.61       7.61
3 Midfield                             1.41       9.02
4 Right Peak                           1.41      10.43
1 Left Floor                           3.61      14.04
2      13.26          1 Left Floor
5 Right Floor                             4          4
2 Left Peak                            3.61       7.61
4 Right Peak                              2       9.61
3 Midfield                             1.41      11.02
1 Left Floor                           2.24      13.26
3      13.26          1 Left Floor
5 Right Floor                             4          4
3 Midfield                             2.24       6.24
2 Left Peak                            1.41       7.65
4 Right Peak                              2       9.65
1 Left Floor                           3.61      13.26
4      11.89          1 Left Floor
5 Right Floor                             4          4
4 Right Peak                           2.24       6.24
2 Left Peak                               2       8.24
3 Midfield                             1.41       9.65
1 Left Floor                           2.24      11.89
5      11.89          1 Left Floor
5 Right Floor                             4          4
3 Midfield                             2.24       6.24
4 Right Peak                           1.41       7.65
2 Left Peak                               2       9.65
1 Left Floor                           2.24      11.89
2 -> 5                1      14.04          2 Left Peak
5 Right Floor                          3.61       3.61
1 Left Floor                              4       7.61
4 Right Peak                           3.61      11.21
3 Midfield                             1.41      12.63
2 Left Peak                            1.41      14.04
2      13.68          2 Left Peak
5 Right Floor                          3.61       3.61
3 Midfield                             2.24       5.84
1 Left Floor                           2.24       8.08
4 Right Peak                           3.61      11.68
2 Left Peak                               2      13.68
3      13.26          2 Left Peak
5 Right Floor                          3.61       3.61
1 Left Floor                              4       7.61
3 Midfield                             2.24       9.84
4 Right Peak                           1.41      11.26
2 Left Peak                               2      13.26
4       13.1          2 Left Peak
5 Right Floor                          3.61       3.61
4 Right Peak                           2.24       5.84
1 Left Floor                           3.61       9.45
3 Midfield                             2.24      11.68
2 Left Peak                            1.41       13.1
5      11.73          2 Left Peak
5 Right Floor                          3.61       3.61
4 Right Peak                           2.24       5.84
3 Midfield                             1.41       7.26
1 Left Floor                           2.24       9.49
2 Left Peak                            2.24      11.73
3 -> 5                1      13.68          3 Midfield
5 Right Floor                          2.24       2.24
2 Left Peak                            3.61       5.84
4 Right Peak                              2       7.84
1 Left Floor                           3.61      11.45
3 Midfield                             2.24      13.68
2      13.26          3 Midfield
5 Right Floor                          2.24       2.24
1 Left Floor                              4       6.24
4 Right Peak                           3.61       9.84
2 Left Peak                               2      11.84
3 Midfield                             1.41      13.26
3       13.1          3 Midfield
5 Right Floor                          2.24       2.24
2 Left Peak                            3.61       5.84
1 Left Floor                           2.24       8.08
4 Right Peak                           3.61      11.68
3 Midfield                             1.41       13.1
4      11.89          3 Midfield
5 Right Floor                          2.24       2.24
1 Left Floor                              4       6.24
2 Left Peak                            2.24       8.47
4 Right Peak                              2      10.47
3 Midfield                             1.41      11.89
5      11.73          3 Midfield
5 Right Floor                          2.24       2.24
4 Right Peak                           2.24       4.47
1 Left Floor                           3.61       8.08
2 Left Peak                            2.24      10.31
3 Midfield                             1.41      11.73

150 rows selected.

Elapsed: 00:00:00.16
```

Summary of Results
Here we list the best solutions found for each root leg. * denotes optimum.

```Shortest Routes
===============
ROOT_LEG       PATH_RNK   TOT_DIST
------------ ---------- ----------
1 -> 2                1      10.94*
2 -> 3                1       11.3
2 -> 4                1      10.94*
3 -> 4                1       11.3
3 -> 5                1      10.94*

Longest Routes
==============
ROOT_LEG       PATH_RNK   TOT_DIST
------------ ---------- ----------
1 -> 2                1       13.1
1 -> 4                1      13.68
1 -> 5                1      14.04*
2 -> 5                1      14.04*
3 -> 5                1      13.68
```

Test Problem 2: USCA312

I used keep values of 2 and 2 and solved the problems in around 85 seconds.

```Shortest Routes
===============
ROOT_LEG       PATH_RNK   TOT_DIST    TOWN_ID NAME                             LEG_DIST   CUM_DIST
------------ ---------- ---------- ---------- ------------------------------ ---------- ----------
184 -> 208            1   55744.86        184 Norfolk, VA
208 Portsmouth, VA                       1.19       1.19
294 Washington, DC                     151.18     152.37
18 Baltimore, MD                       40.06     192.43
141 Lancaster, PA                       55.83     248.26
129 Johnstown, PA                       16.64      264.9
217 Reading, PA                          27.2      292.1
302 Wilmington, DE                      48.48     340.58
198 Philadelphia, PA                    30.05     370.63
283 Trenton, NJ                         34.35     404.99
83 Elizabeth, NJ                       48.02     453.01
177 Newark, NJ                           5.61     458.62
128 Jersey City, NJ                      6.57     465.19
181 New York, NY                         5.04     470.23
194 Paterson, NJ                        18.08     488.32
299 White Plains, NY                    29.39     517.71
266 Stamford, CT                        15.36     533.07
39 Bridgeport, CT                      24.55     557.61
179 New Haven, CT                       21.46     579.08
163 Meriden, CT                         17.96     597.04
178 New Britain,CT                       8.71     605.75
117 Hartford, CT                         9.62     615.37
263 Springfield, MA                     24.25     639.62
202 Pittsfield, MA                      51.31     690.93
285 Troy, NY                            36.34     727.27
3 Albany, NY                           6.88     734.16
251 Schenectady, NY                     16.88     751.04
289 Utica, NY                           91.52     842.56
272 Syracuse, NY                        63.31     905.86
29 Binghamtom, NY                      67.49     973.35
301 Wilkes-Barre, PA                    58.97    1032.33
6 Allentown, PA                       51.68       1084
116 Harrisburg, PA                      99.07    1183.07
13 Atlantic City, NJ                  181.31    1364.38
50 Central Islip, NY                  129.74    1494.12
210 Providence, RI                     142.75    1636.87
91 Fall River, MA                      19.72    1656.59
40 Brockton, MA                        28.03    1684.61
34 Boston, MA                          19.21    1703.83
46 Cambridge, MA                        3.36    1707.19
155 Lowell, MA                          23.03    1730.22
145 Lawrence, MA                        11.73    1741.95
159 Manchester, NH                      28.36     1770.3
67 Concord, NH                         15.76    1786.06
307 Worcester, MA                       67.84     1853.9
38 Brattleboro, VT                     66.17    1920.07
171 Montpelier, VT                      97.37    2017.43
43 Burlington, VT                      46.45    2063.89
172 Montreal, QC                        97.19    2161.08
284 Trois-Rivieres, QC                  98.03     2259.1
254 Sherbrooke, QC                      93.08    2352.18
205 Portland, ME                       157.79    2509.97
207 Portsmouth, NH                      53.74    2563.71
15 Augusta, ME                        109.27    2672.99
19 Bangor, ME                          77.07    2750.06
98 Fredericton, NB                    171.89    2921.95
229 Saint John, NB                      58.53    2980.48
169 Moncton, NB                         99.94    3080.42
113 Halifax, NS                        117.55    3197.97
55 Charlottetown, PE                  100.98    3298.95
271 Syndey, NS                         212.55     3511.5
230 Saint John's, NF                   514.07    4025.57
213 Quebec City, QC                   1290.47    5316.03
191 Ottawa, ON                         400.01    5716.04
137 Kingston, ON                        85.39    5801.42
24 Belleville, ON                      49.28    5850.71
197 Peterborough, ON                    72.87    5923.57
282 Toronto, ON                         82.62    6006.19
42 Burlington, ONT                     33.92    6040.11
115 Hamilton, ON                        19.51    6059.62
37 Brantford, ON                       28.55    6088.16
111 Guelph, ON                           29.4    6117.56
138 Kitchener, ON                       10.29    6127.86
152 London, ON                          67.63    6195.49
86 Erie, PA                            97.44    6292.93
310 Youngstown, OH                      81.12    6374.05
267 Steubenville, OH                    50.45     6424.5
297 Wheeling, WV                        21.97    6446.47
201 Pittsburgh, PA                      56.46    6502.93
47 Canton, OH                          98.69    6601.61
2 Akron, OH                            21.8    6623.41
61 Cleveland, OH                       31.35    6654.76
304 Windsor, ON                        102.38    6757.14
76 Detroit, MI                          7.21    6764.35
9 Ann Arbor, MI                       47.21    6811.56
125 Jackson, MI                         46.67    6858.23
142 Lansing, MI                         35.28    6893.51
21 Battle Creek, MI                    51.65    6945.16
132 Kalamazoo, MI                       28.23    6973.39
259 South Bend, IN                      62.16    7035.55
104 Gary, IN                            76.01    7111.56
58 Chicago, IL                         27.47    7139.03
135 Kenosha, WI                         52.13    7191.16
214 Racine, WI                          10.12    7201.28
165 Milwaukee, WI                       23.24    7224.52
224 Rockford, IL                        97.71    7322.22
158 Madison, WI                         59.34    7381.56
78 Dubuque, IA                         95.84     7477.4
49 Cedar Rapids, IA                    75.74    7553.14
124 Iowa City, IA                       25.25    7578.39
295 Waterloo, IA                        80.35    7658.74
222 Rochester, MN                         106    7764.75
233 Saint Paul, MN                      76.94    7841.69
166 Minneapolis, MN                     12.03    7853.72
228 Saint Cloud, MN                     73.94    7927.66
79 Duluth, MN                         165.27    8092.93
270 Superior, WI                         4.32    8097.25
81 Eau Claire, WI                     138.42    8235.67
108 Green Bay, WI                      241.21    8476.87
253 Sheboygan, WI                       57.13       8534
106 Grand Rapids, MI                   151.51     8685.5
226 Saginaw, MI                        122.77    8808.27
22 Bay City, MI                        12.83     8821.1
94 Flint, MI                           42.55    8863.65
280 Toledo, OH                          93.64    8957.28
149 Lima, OH                            74.14    9031.42
265 Springfield, OH                     60.13    9091.56
71 Dayton, OH                          28.81    9120.37
114 Hamilton, OH                        35.63       9156
60 Cincinnati, OH                      17.93    9173.93
147 Lexington, KY                       81.08    9255.01
154 Louisville, KY                      90.44    9345.45
35 Bowling Green, KY                    99.3    9444.76
175 Nashville, TN                       61.65     9506.4
122 Huntsville, AL                     100.13    9606.53
100 Gadsden, AL                         63.64    9670.18
30 Birmingham, AL                       64.7    9734.88
170 Montgomery, AL                      86.96    9821.85
65 Columbus, GA                         90.9    9912.75
12 Atlanta, GA                         98.17   10010.92
157 Macon, GA                           81.64   10092.56
14 Augusta, GA                        122.52   10215.08
110 Greenville, SC                      99.77   10314.85
260 Spartanburg, NC                     32.62   10347.46
54 Charlotte, NC                       77.64   10425.11
306 Winston-Salem, NC                   73.13   10498.24
109 Greensboro, NC                       31.3   10529.54
215 Raleigh, NC                         82.35   10611.89
80 Durham, NC                          23.61    10635.5
221 Roanoke, VA                        113.91   10749.41
53 Charleston, WV                     138.61   10888.02
11 Ashland, KY                         70.03   10958.04
312 Zanesville, OH                     109.84   11067.89
66 Columbus, OH                        68.11   11135.99
174 Muncie, IN                         165.75   11301.74
123 Indianapolis, IN                    60.87   11362.61
276 Terre Haute, IN                     89.24   11451.85
288 Urbana, IL                           70.6   11522.45
51 Champaign, IL                        2.52   11524.98
73 Decatur, IL                         52.73   11577.71
32 Bloomington, IL                     44.57   11622.28
196 Peoria, IL                           43.6   11665.88
262 Springfield, IL                     61.75   11727.63
232 Saint Louis, MO                     89.73   11817.36
63 Columbia, MO                       149.28   11966.64
264 Springfield, MO                    137.23   12103.88
130 Joplin, MO                          84.44   12188.32
287 Tulsa, OK                          120.76   12309.07
188 Oklahoma City, OK                  115.46   12424.54
85 Enid, OK                            68.83   12493.37
300 Wichita, KS                         97.07   12590.44
236 Salina, KS                          81.55   12671.99
281 Topeka, KS                         134.35   12806.34
133 Kansas City, KS                     72.73   12879.07
134 Kansas City, MO                      3.52    12882.6
231 Saint Joseph, MO                    49.79   12932.39
150 Lincoln, NE                        144.56   13076.95
189 Omaha, NE                           59.52   13136.47
257 Sioux City, IA                      91.54   13228.01
258 Sioux Falls, SD                     75.45   13303.46
92 Fargo, ND                          229.97   13533.43
305 Winnipeg, MB                       211.94   13745.38
36 Brandon, MB                        187.08   13932.46
167 Minot, ND                          148.55      14081
31 Bismarck, ND                       104.59   14185.59
200 Pierre, SD                         171.22   14356.81
216 Rapid City, SD                     199.98   14556.79
57 Cheyenne, WY                       230.96   14787.75
74 Denver, CO                          97.46   14885.21
62 Colorado Springs, CO                63.56   14948.77
212 Pueblo, CO                          42.63    14991.4
246 Santa Fe, NM                       199.75   15191.16
4 Albuquerque, NM                     64.52   15255.68
102 Gallup, NM                         147.72    15403.4
93 Flagstaff, AZ                      202.26   15605.66
199 Phoenix, AZ                        124.38   15730.04
286 Tucson, AZ                         116.06    15846.1
311 Yuma, AZ                           257.86   16103.95
240 San Diego, CA                      175.01   16278.97
239 San Bernardino, CA                  96.69   16375.66
193 Pasadena, CA                        59.12   16434.78
153 Los Angeles, CA                      9.51   16444.29
244 Santa Barbara, CA                  103.68   16547.97
17 Bakersfield, CA                     80.84   16628.81
99 Fresno, CA                         108.31   16737.12
242 San Jose, CA                       152.25   16889.37
245 Santa Cruz, CA                      26.93    16916.3
186 Oakland, CA                         59.72   16976.02
241 San Francisco, CA                   10.47   16986.49
26 Berkeley, CA                        12.14   16998.63
268 Stockton, CA                        68.11   17066.74
225 Sacramento, CA                      45.35   17112.09
48 Carson City, NV                    125.92      17238
219 Reno, NV                            25.48   17263.49
88 Eureka, CA                         313.15   17576.64
87 Eugene, OR                         236.57    17813.2
235 Salem, OR                           61.63   17874.84
206 Portland, OR                        47.17   17922.01
273 Tacoma, WA                         120.57   18042.58
252 Seattle, WA                         25.62    18068.2
25 Bellingham, WA                      80.42   18148.62
290 Vancouver, BC                       56.66   18205.28
291 Victoria, BC                        41.45   18246.73
308 Yakima, WA                         246.37    18493.1
293 Walla Walla, WA                    153.98   18647.07
261 Spokane, WA                        127.07   18774.15
33 Boise, ID                          291.99   19066.14
203 Pocatello, ID                      264.67   19330.81
187 Ogden, UT                          118.47   19449.28
237 Salt Lake City, UT                  32.44   19481.72
211 Provo, UT                           39.79   19521.51
105 Grand Junction, CO                 229.45   19750.96
255 Sheridan, WY                       411.17   20162.14
27 Billings, MT                       126.61   20288.75
107 Great Falls, MT                    226.94   20515.69
118 Helena, MT                           80.7   20596.39
44 Butte, MT                           53.31    20649.7
146 Lethbridge, AB                     251.24   20900.94
45 Calgary, AB                        132.75   21033.69
82 Edmonton, AB                       173.35   21207.04
161 Medicine Hat, AB                   312.59   21519.63
248 Saskatoon, SK                      315.13   21834.76
173 Moose Jaw, SK                      149.68   21984.44
218 Regina, SK                          62.04   22046.48
77 Dodge City, KS                     933.12    22979.6
7 Amarillo, TX                       215.16   23194.75
156 Lubbock, TX                        113.61   23308.37
1 Abilene, TX                        166.25   23474.62
97 Ft Worth, TX                       167.57   23642.19
69 Dallas, TX                          36.19   23678.39
292 Waco, TX                            88.57   23766.96
16 Austin, TX                          97.72   23864.68
238 San Antonio, TX                     77.99   23942.67
143 Laredo, TX                         149.89   24092.56
68 Corpus Christi, TX                 147.28   24239.84
121 Houston, TX                        195.26    24435.1
103 Galveston, TX                       50.45   24485.55
204 Port Arthur, TX                     72.86   24558.41
23 Beaumont, TX                        17.62   24576.03
256 Shreveport, LA                     170.28   24746.32
160 Marshall, TX                        42.67   24788.99
277 Texarkana, TX                       64.71    24853.7
95 Ft Smith, AR                       137.64   24991.34
151 Little Rock, AR                    152.27   25143.61
162 Memphis, TN                         157.3   25300.91
192 Paducah, KY                        166.97   25467.88
89 Evansville, IN                      94.86   25562.74
140 Lafayette, IN                      175.16    25737.9
96 Ft Wayne, IN                       130.36   25868.26
139 Knoxville, TN                      366.84    26235.1
10 Asheville, NC                       97.65   26332.75
64 Columbia, SC                       152.46   26485.21
52 Charleston, SC                      113.9   26599.11
250 Savannah, GA                         93.9   26693.01
127 Jacksonville, FL                   126.96   26819.97
101 Gainesville, FL                     65.95   26885.92
72 Daytona Beach, FL                   94.98    26980.9
190 Orlando, FL                         52.58   27033.48
275 Tampa, FL                           85.01   27118.49
234 Saint Petersburg, FL                19.54   27138.03
247 Sarasota, FL                        31.73   27169.75
296 West Palm Beach, FL                176.46   27346.21
164 Miami, FL                           65.75   27411.96
136 Key West, FL                       138.36   27550.32
274 Tallahassee, FL                    441.61   27991.93
195 Pensacola, FL                      202.87    28194.8
168 Mobile, AL                          60.12   28254.92
28 Biloxi, MS                          61.74   28316.66
112 Gulfport, MS                        14.47   28331.13
180 New Orleans, LA                     73.62   28404.74
20 Baton Rouge, LA                     82.09   28486.83
176 Natchez, MS                         78.58   28565.41
126 Jackson, MS                         98.43   28663.84
56 Chattanooga, TN                    386.64   29050.48
303 Wilmington, NC                     512.01   29562.49
220 Richmond, VA                       232.37   29794.87
41 Buffalo, NY                        381.27   30176.14
182 Niagara Falls, ON                   20.54   30196.68
227 Saint Catherines, ON                 8.92   30205.61
223 Rochester, NY                      107.53   30313.14
185 North Bay, ON                      260.14   30573.28
269 Sudbury, ON                            93   30666.28
279 Timmins, ON                        140.17   30806.45
249 Sault Ste Marie, ON                260.02   31066.47
278 Thunder Bay, ON                    357.29   31423.76
75 Des Moines, IA                     553.68   31977.44
84 El Paso, TX                       1119.89   33097.34
144 Las Vegas, NV                      671.08   33768.41
209 Prince Rupert, BC                 1638.53   35406.94
131 Juneau, AK                         390.43   35797.37
298 Whitehorse, YK                     172.32   35969.69
70 Dawson, YT                         362.92   36332.61
90 Fairbanks, AK                         596   36928.62
8 Anchorage, AK                      292.11   37220.72
183 Nome, AK                          1095.15   38315.87
148 Lihue, HI                          2967.4   41283.27
120 Honolulu, HI                        114.5   41397.77
119 Hilo, HI                              176   41573.77
309 Yellowknife, NT                   4111.93    45685.7
59 Churchill, MB                     1431.71   47117.42
5 Alert, NT                         2742.38    49859.8
243 San Juan, PR                      4433.43   54293.23
184 Norfolk, VA                       1451.64   55744.86
2   55746.24        184 Norfolk, VA
208 Portsmouth, VA                       1.19       1.19
294 Washington, DC                     151.18     152.37
18 Baltimore, MD                       40.06     192.43
141 Lancaster, PA                       55.83     248.26
129 Johnstown, PA                       16.64      264.9
217 Reading, PA                          27.2      292.1
302 Wilmington, DE                      48.48     340.58
198 Philadelphia, PA                    30.05     370.63
283 Trenton, NJ                         34.35     404.99
83 Elizabeth, NJ                       48.02     453.01
177 Newark, NJ                           5.61     458.62
128 Jersey City, NJ                      6.57     465.19
181 New York, NY                         5.04     470.23
194 Paterson, NJ                        18.08     488.32
299 White Plains, NY                    29.39     517.71
266 Stamford, CT                        15.36     533.07
39 Bridgeport, CT                      24.55     557.61
179 New Haven, CT                       21.46     579.08
163 Meriden, CT                         17.96     597.04
178 New Britain,CT                       8.71     605.75
117 Hartford, CT                         9.62     615.37
263 Springfield, MA                     24.25     639.62
202 Pittsfield, MA                      51.31     690.93
285 Troy, NY                            36.34     727.27
3 Albany, NY                           6.88     734.16
251 Schenectady, NY                     16.88     751.04
289 Utica, NY                           91.52     842.56
272 Syracuse, NY                        63.31     905.86
29 Binghamtom, NY                      67.49     973.35
301 Wilkes-Barre, PA                    58.97    1032.33
6 Allentown, PA                       51.68       1084
116 Harrisburg, PA                      99.07    1183.07
13 Atlantic City, NJ                  181.31    1364.38
50 Central Islip, NY                  129.74    1494.12
210 Providence, RI                     142.75    1636.87
91 Fall River, MA                      19.72    1656.59
40 Brockton, MA                        28.03    1684.61
34 Boston, MA                          19.21    1703.83
46 Cambridge, MA                        3.36    1707.19
155 Lowell, MA                          23.03    1730.22
145 Lawrence, MA                        11.73    1741.95
159 Manchester, NH                      28.36     1770.3
67 Concord, NH                         15.76    1786.06
307 Worcester, MA                       67.84     1853.9
38 Brattleboro, VT                     66.17    1920.07
171 Montpelier, VT                      97.37    2017.43
43 Burlington, VT                      46.45    2063.89
172 Montreal, QC                        97.19    2161.08
284 Trois-Rivieres, QC                  98.03     2259.1
254 Sherbrooke, QC                      93.08    2352.18
205 Portland, ME                       157.79    2509.97
207 Portsmouth, NH                      53.74    2563.71
15 Augusta, ME                        109.27    2672.99
19 Bangor, ME                          77.07    2750.06
98 Fredericton, NB                    171.89    2921.95
229 Saint John, NB                      58.53    2980.48
169 Moncton, NB                         99.94    3080.42
113 Halifax, NS                        117.55    3197.97
55 Charlottetown, PE                  100.98    3298.95
271 Syndey, NS                         212.55     3511.5
230 Saint John's, NF                   514.07    4025.57
213 Quebec City, QC                   1290.47    5316.03
191 Ottawa, ON                         400.01    5716.04
137 Kingston, ON                        85.39    5801.42
24 Belleville, ON                      49.28    5850.71
197 Peterborough, ON                    72.87    5923.57
282 Toronto, ON                         82.62    6006.19
42 Burlington, ONT                     33.92    6040.11
115 Hamilton, ON                        19.51    6059.62
37 Brantford, ON                       28.55    6088.16
111 Guelph, ON                           29.4    6117.56
138 Kitchener, ON                       10.29    6127.86
152 London, ON                          67.63    6195.49
86 Erie, PA                            97.44    6292.93
310 Youngstown, OH                      81.12    6374.05
267 Steubenville, OH                    50.45     6424.5
297 Wheeling, WV                        21.97    6446.47
201 Pittsburgh, PA                      56.46    6502.93
47 Canton, OH                          98.69    6601.61
2 Akron, OH                            21.8    6623.41
61 Cleveland, OH                       31.35    6654.76
304 Windsor, ON                        102.38    6757.14
76 Detroit, MI                          7.21    6764.35
9 Ann Arbor, MI                       47.21    6811.56
125 Jackson, MI                         46.67    6858.23
142 Lansing, MI                         35.28    6893.51
21 Battle Creek, MI                    51.65    6945.16
132 Kalamazoo, MI                       28.23    6973.39
259 South Bend, IN                      62.16    7035.55
104 Gary, IN                            76.01    7111.56
58 Chicago, IL                         27.47    7139.03
135 Kenosha, WI                         52.13    7191.16
214 Racine, WI                          10.12    7201.28
165 Milwaukee, WI                       23.24    7224.52
224 Rockford, IL                        97.71    7322.22
158 Madison, WI                         59.34    7381.56
78 Dubuque, IA                         95.84     7477.4
49 Cedar Rapids, IA                    75.74    7553.14
124 Iowa City, IA                       25.25    7578.39
295 Waterloo, IA                        80.35    7658.74
222 Rochester, MN                         106    7764.75
233 Saint Paul, MN                      76.94    7841.69
166 Minneapolis, MN                     12.03    7853.72
228 Saint Cloud, MN                     73.94    7927.66
79 Duluth, MN                         165.27    8092.93
270 Superior, WI                         4.32    8097.25
81 Eau Claire, WI                     138.42    8235.67
108 Green Bay, WI                      241.21    8476.87
253 Sheboygan, WI                       57.13       8534
106 Grand Rapids, MI                   151.51     8685.5
226 Saginaw, MI                        122.77    8808.27
22 Bay City, MI                        12.83     8821.1
94 Flint, MI                           42.55    8863.65
280 Toledo, OH                          93.64    8957.28
149 Lima, OH                            74.14    9031.42
265 Springfield, OH                     60.13    9091.56
71 Dayton, OH                          28.81    9120.37
114 Hamilton, OH                        35.63       9156
60 Cincinnati, OH                      17.93    9173.93
147 Lexington, KY                       81.08    9255.01
154 Louisville, KY                      90.44    9345.45
35 Bowling Green, KY                    99.3    9444.76
175 Nashville, TN                       61.65     9506.4
122 Huntsville, AL                     100.13    9606.53
100 Gadsden, AL                         63.64    9670.18
30 Birmingham, AL                       64.7    9734.88
170 Montgomery, AL                      86.96    9821.85
65 Columbus, GA                         90.9    9912.75
12 Atlanta, GA                         98.17   10010.92
157 Macon, GA                           81.64   10092.56
14 Augusta, GA                        122.52   10215.08
110 Greenville, SC                      99.77   10314.85
260 Spartanburg, NC                     32.62   10347.46
54 Charlotte, NC                       77.64   10425.11
306 Winston-Salem, NC                   73.13   10498.24
109 Greensboro, NC                       31.3   10529.54
215 Raleigh, NC                         82.35   10611.89
80 Durham, NC                          23.61    10635.5
221 Roanoke, VA                        113.91   10749.41
53 Charleston, WV                     138.61   10888.02
11 Ashland, KY                         70.03   10958.04
312 Zanesville, OH                     109.84   11067.89
66 Columbus, OH                        68.11   11135.99
174 Muncie, IN                         165.75   11301.74
123 Indianapolis, IN                    60.87   11362.61
276 Terre Haute, IN                     89.24   11451.85
288 Urbana, IL                           70.6   11522.45
51 Champaign, IL                        2.52   11524.98
73 Decatur, IL                         52.73   11577.71
32 Bloomington, IL                     44.57   11622.28
196 Peoria, IL                           43.6   11665.88
262 Springfield, IL                     61.75   11727.63
232 Saint Louis, MO                     89.73   11817.36
63 Columbia, MO                       149.28   11966.64
264 Springfield, MO                    137.23   12103.88
130 Joplin, MO                          84.44   12188.32
287 Tulsa, OK                          120.76   12309.07
188 Oklahoma City, OK                  115.46   12424.54
85 Enid, OK                            68.83   12493.37
300 Wichita, KS                         97.07   12590.44
236 Salina, KS                          81.55   12671.99
281 Topeka, KS                         134.35   12806.34
133 Kansas City, KS                     72.73   12879.07
134 Kansas City, MO                      3.52    12882.6
231 Saint Joseph, MO                    49.79   12932.39
150 Lincoln, NE                        144.56   13076.95
189 Omaha, NE                           59.52   13136.47
257 Sioux City, IA                      91.54   13228.01
258 Sioux Falls, SD                     75.45   13303.46
92 Fargo, ND                          229.97   13533.43
305 Winnipeg, MB                       211.94   13745.38
36 Brandon, MB                        187.08   13932.46
167 Minot, ND                          148.55      14081
31 Bismarck, ND                       104.59   14185.59
200 Pierre, SD                         171.22   14356.81
216 Rapid City, SD                     199.98   14556.79
57 Cheyenne, WY                       230.96   14787.75
74 Denver, CO                          97.46   14885.21
62 Colorado Springs, CO                63.56   14948.77
212 Pueblo, CO                          42.63    14991.4
246 Santa Fe, NM                       199.75   15191.16
4 Albuquerque, NM                     64.52   15255.68
102 Gallup, NM                         147.72    15403.4
93 Flagstaff, AZ                      202.26   15605.66
199 Phoenix, AZ                        124.38   15730.04
286 Tucson, AZ                         116.06    15846.1
311 Yuma, AZ                           257.86   16103.95
240 San Diego, CA                      175.01   16278.97
239 San Bernardino, CA                  96.69   16375.66
193 Pasadena, CA                        59.12   16434.78
153 Los Angeles, CA                      9.51   16444.29
244 Santa Barbara, CA                  103.68   16547.97
17 Bakersfield, CA                     80.84   16628.81
99 Fresno, CA                         108.31   16737.12
242 San Jose, CA                       152.25   16889.37
245 Santa Cruz, CA                      26.93    16916.3
186 Oakland, CA                         59.72   16976.02
241 San Francisco, CA                   10.47   16986.49
26 Berkeley, CA                        12.14   16998.63
268 Stockton, CA                        68.11   17066.74
225 Sacramento, CA                      45.35   17112.09
48 Carson City, NV                    125.92      17238
219 Reno, NV                            25.48   17263.49
88 Eureka, CA                         313.15   17576.64
87 Eugene, OR                         236.57    17813.2
235 Salem, OR                           61.63   17874.84
206 Portland, OR                        47.17   17922.01
273 Tacoma, WA                         120.57   18042.58
252 Seattle, WA                         25.62    18068.2
25 Bellingham, WA                      80.42   18148.62
290 Vancouver, BC                       56.66   18205.28
291 Victoria, BC                        41.45   18246.73
308 Yakima, WA                         246.37    18493.1
293 Walla Walla, WA                    153.98   18647.07
261 Spokane, WA                        127.07   18774.15
33 Boise, ID                          291.99   19066.14
203 Pocatello, ID                      264.67   19330.81
187 Ogden, UT                          118.47   19449.28
237 Salt Lake City, UT                  32.44   19481.72
211 Provo, UT                           39.79   19521.51
105 Grand Junction, CO                 229.45   19750.96
255 Sheridan, WY                       411.17   20162.14
27 Billings, MT                       126.61   20288.75
107 Great Falls, MT                    226.94   20515.69
118 Helena, MT                           80.7   20596.39
44 Butte, MT                           53.31    20649.7
146 Lethbridge, AB                     251.24   20900.94
45 Calgary, AB                        132.75   21033.69
82 Edmonton, AB                       173.35   21207.04
161 Medicine Hat, AB                   312.59   21519.63
248 Saskatoon, SK                      315.13   21834.76
173 Moose Jaw, SK                      149.68   21984.44
218 Regina, SK                          62.04   22046.48
77 Dodge City, KS                     933.12    22979.6
7 Amarillo, TX                       215.16   23194.75
156 Lubbock, TX                        113.61   23308.37
1 Abilene, TX                        166.25   23474.62
97 Ft Worth, TX                       167.57   23642.19
69 Dallas, TX                          36.19   23678.39
292 Waco, TX                            88.57   23766.96
16 Austin, TX                          97.72   23864.68
238 San Antonio, TX                     77.99   23942.67
143 Laredo, TX                         149.89   24092.56
68 Corpus Christi, TX                 147.28   24239.84
121 Houston, TX                        195.26    24435.1
103 Galveston, TX                       50.45   24485.55
204 Port Arthur, TX                     72.86   24558.41
23 Beaumont, TX                        17.62   24576.03
160 Marshall, TX                       170.89   24746.92
256 Shreveport, LA                      42.67   24789.59
277 Texarkana, TX                       65.49   24855.08
95 Ft Smith, AR                       137.64   24992.72
151 Little Rock, AR                    152.27      25145
162 Memphis, TN                         157.3   25302.29
192 Paducah, KY                        166.97   25469.26
89 Evansville, IN                      94.86   25564.12
140 Lafayette, IN                      175.16   25739.28
96 Ft Wayne, IN                       130.36   25869.64
139 Knoxville, TN                      366.84   26236.49
10 Asheville, NC                       97.65   26334.13
64 Columbia, SC                       152.46    26486.6
52 Charleston, SC                      113.9   26600.49
250 Savannah, GA                         93.9   26694.39
127 Jacksonville, FL                   126.96   26821.35
101 Gainesville, FL                     65.95    26887.3
72 Daytona Beach, FL                   94.98   26982.28
190 Orlando, FL                         52.58   27034.86
275 Tampa, FL                           85.01   27119.87
234 Saint Petersburg, FL                19.54   27139.41
247 Sarasota, FL                        31.73   27171.14
296 West Palm Beach, FL                176.46    27347.6
164 Miami, FL                           65.75   27413.34
136 Key West, FL                       138.36    27551.7
274 Tallahassee, FL                    441.61   27993.31
195 Pensacola, FL                      202.87   28196.18
168 Mobile, AL                          60.12    28256.3
28 Biloxi, MS                          61.74   28318.04
112 Gulfport, MS                        14.47   28332.51
180 New Orleans, LA                     73.62   28406.13
20 Baton Rouge, LA                     82.09   28488.22
176 Natchez, MS                         78.58    28566.8
126 Jackson, MS                         98.43   28665.22
56 Chattanooga, TN                    386.64   29051.86
303 Wilmington, NC                     512.01   29563.88
220 Richmond, VA                       232.37   29796.25
41 Buffalo, NY                        381.27   30177.52
182 Niagara Falls, ON                   20.54   30198.06
227 Saint Catherines, ON                 8.92   30206.99
223 Rochester, NY                      107.53   30314.52
185 North Bay, ON                      260.14   30574.66
269 Sudbury, ON                            93   30667.66
279 Timmins, ON                        140.17   30807.83
249 Sault Ste Marie, ON                260.02   31067.85
278 Thunder Bay, ON                    357.29   31425.14
75 Des Moines, IA                     553.68   31978.82
84 El Paso, TX                       1119.89   33098.72
144 Las Vegas, NV                      671.08    33769.8
209 Prince Rupert, BC                 1638.53   35408.32
131 Juneau, AK                         390.43   35798.75
298 Whitehorse, YK                     172.32   35971.07
70 Dawson, YT                         362.92   36333.99
90 Fairbanks, AK                         596      36930
8 Anchorage, AK                      292.11    37222.1
183 Nome, AK                          1095.15   38317.26
148 Lihue, HI                          2967.4   41284.65
120 Honolulu, HI                        114.5   41399.15
119 Hilo, HI                              176   41575.15
309 Yellowknife, NT                   4111.93   45687.09
59 Churchill, MB                     1431.71    47118.8
5 Alert, NT                         2742.38   49861.18
243 San Juan, PR                      4433.43   54294.61
184 Norfolk, VA                       1451.64   55746.24
51 -> 288             1   56794.75         51 Champaign, IL
288 Urbana, IL                           2.52       2.52
73 Decatur, IL                         54.92      57.45
262 Springfield, IL                     47.66     105.11
196 Peoria, IL                          61.75     166.86
32 Bloomington, IL                      43.6     210.46
224 Rockford, IL                       123.66     334.12
135 Kenosha, WI                         90.57     424.69
165 Milwaukee, WI                       31.93     456.62
214 Racine, WI                          23.24     479.86
58 Chicago, IL                         61.23     541.09
104 Gary, IN                            27.47     568.56
259 South Bend, IN                      76.01     644.57
132 Kalamazoo, MI                       62.16     706.73
21 Battle Creek, MI                    28.23     734.96
142 Lansing, MI                         51.65     786.61
125 Jackson, MI                         35.28     821.89
9 Ann Arbor, MI                       46.67     868.56
280 Toledo, OH                          43.57     912.13
76 Detroit, MI                         58.03     970.16
304 Windsor, ON                          7.21     977.37
94 Flint, MI                           71.67    1049.04
226 Saginaw, MI                          33.5    1082.54
22 Bay City, MI                        12.83    1095.36
106 Grand Rapids, MI                   130.44     1225.8
96 Ft Wayne, IN                          132     1357.8
174 Muncie, IN                          67.15    1424.95
123 Indianapolis, IN                    60.87    1485.83
140 Lafayette, IN                       66.81    1552.63
276 Terre Haute, IN                     75.45    1628.09
89 Evansville, IN                     103.56    1731.64
192 Paducah, KY                         94.86    1826.51
175 Nashville, TN                      140.56    1967.07
35 Bowling Green, KY                   61.65    2028.71
154 Louisville, KY                       99.3    2128.02
147 Lexington, KY                       90.44    2218.46
60 Cincinnati, OH                      81.08    2299.54
114 Hamilton, OH                        17.93    2317.47
71 Dayton, OH                          35.63     2353.1
265 Springfield, OH                     28.81    2381.91
66 Columbus, OH                        56.03    2437.94
312 Zanesville, OH                      68.11    2506.04
47 Canton, OH                          73.78    2579.83
2 Akron, OH                            21.8    2601.63
61 Cleveland, OH                       31.35    2632.98
310 Youngstown, OH                      77.36    2710.33
267 Steubenville, OH                    50.45    2760.79
297 Wheeling, WV                        21.97    2782.75
201 Pittsburgh, PA                      56.46    2839.21
86 Erie, PA                           116.83    2956.05
37 Brantford, ON                       71.49    3027.54
138 Kitchener, ON                       22.82    3050.35
111 Guelph, ON                          10.29    3060.65
42 Burlington, ONT                     29.68    3090.32
115 Hamilton, ON                        19.51    3109.83
227 Saint Catherines, ON                52.51    3162.34
41 Buffalo, NY                         29.25    3191.58
182 Niagara Falls, ON                   20.54    3212.12
282 Toronto, ON                         42.01    3254.13
197 Peterborough, ON                    82.62    3336.75
24 Belleville, ON                      72.87    3409.61
137 Kingston, ON                        49.28     3458.9
191 Ottawa, ON                          85.39    3544.28
172 Montreal, QC                       146.68    3690.97
43 Burlington, VT                      97.19    3788.16
171 Montpelier, VT                      46.45    3834.61
38 Brattleboro, VT                     97.37    3931.97
263 Springfield, MA                     51.84    3983.81
117 Hartford, CT                        24.25    4008.06
178 New Britain,CT                       9.62    4017.69
163 Meriden, CT                          8.71     4026.4
179 New Haven, CT                       17.96    4044.36
39 Bridgeport, CT                      21.46    4065.82
266 Stamford, CT                        24.55    4090.37
299 White Plains, NY                    15.36    4105.73
181 New York, NY                        27.75    4133.48
128 Jersey City, NJ                      5.04    4138.52
177 Newark, NJ                           6.57    4145.09
83 Elizabeth, NJ                        5.61     4150.7
194 Paterson, NJ                        17.67    4168.37
283 Trenton, NJ                          62.4    4230.77
198 Philadelphia, PA                    34.35    4265.12
302 Wilmington, DE                      30.05    4295.18
217 Reading, PA                         48.48    4343.66
129 Johnstown, PA                        27.2    4370.86
141 Lancaster, PA                       16.64     4387.5
116 Harrisburg, PA                      43.19    4430.69
18 Baltimore, MD                        70.5    4501.18
294 Washington, DC                      40.06    4541.24
220 Richmond, VA                        97.21    4638.45
208 Portsmouth, VA                      94.39    4732.84
184 Norfolk, VA                          1.19    4734.03
215 Raleigh, NC                        178.76    4912.79
80 Durham, NC                          23.61    4936.41
109 Greensboro, NC                      61.97    4998.37
306 Winston-Salem, NC                    31.3    5029.67
54 Charlotte, NC                       73.13     5102.8
260 Spartanburg, NC                     77.64    5180.45
110 Greenville, SC                      32.62    5213.06
10 Asheville, NC                       52.87    5265.93
139 Knoxville, TN                       97.65    5363.58
56 Chattanooga, TN                    114.91    5478.49
100 Gadsden, AL                         86.02    5564.51
122 Huntsville, AL                      63.64    5628.15
30 Birmingham, AL                      84.91    5713.06
170 Montgomery, AL                      86.96    5800.02
65 Columbus, GA                         90.9    5890.93
157 Macon, GA                           97.26    5988.18
12 Atlanta, GA                         81.64    6069.82
14 Augusta, GA                        167.83    6237.65
64 Columbia, SC                        74.55    6312.21
52 Charleston, SC                      113.9     6426.1
250 Savannah, GA                         93.9       6520
127 Jacksonville, FL                   126.96    6646.96
101 Gainesville, FL                     65.95    6712.91
72 Daytona Beach, FL                   94.98    6807.89
190 Orlando, FL                         52.58    6860.48
275 Tampa, FL                           85.01    6945.48
234 Saint Petersburg, FL                19.54    6965.02
247 Sarasota, FL                        31.73    6996.75
296 West Palm Beach, FL                176.46    7173.21
164 Miami, FL                           65.75    7238.96
136 Key West, FL                       138.36    7377.32
274 Tallahassee, FL                    441.61    7818.92
195 Pensacola, FL                      202.87     8021.8
168 Mobile, AL                          60.12    8081.91
28 Biloxi, MS                          61.74    8143.65
112 Gulfport, MS                        14.47    8158.12
180 New Orleans, LA                     73.62    8231.74
20 Baton Rouge, LA                     82.09    8313.83
176 Natchez, MS                         78.58    8392.41
126 Jackson, MS                         98.43    8490.84
162 Memphis, TN                         197.2    8688.04
151 Little Rock, AR                     157.3    8845.33
277 Texarkana, TX                      151.96    8997.29
160 Marshall, TX                        64.71       9062
256 Shreveport, LA                      42.67    9104.67
23 Beaumont, TX                       170.28    9274.96
204 Port Arthur, TX                     17.62    9292.58
103 Galveston, TX                       72.86    9365.44
121 Houston, TX                         50.45    9415.89
16 Austin, TX                         168.07    9583.96
238 San Antonio, TX                     77.99    9661.95
68 Corpus Christi, TX                 135.39    9797.35
143 Laredo, TX                         147.28    9944.63
292 Waco, TX                            323.5   10268.13
97 Ft Worth, TX                        82.15   10350.28
69 Dallas, TX                          36.19   10386.47
188 Oklahoma City, OK                  191.95   10578.42
85 Enid, OK                            68.83   10647.25
300 Wichita, KS                         97.07   10744.32
236 Salina, KS                          81.55   10825.87
281 Topeka, KS                         134.35   10960.22
133 Kansas City, KS                     72.73   11032.95
134 Kansas City, MO                      3.52   11036.48
231 Saint Joseph, MO                    49.79   11086.27
189 Omaha, NE                          127.61   11213.88
150 Lincoln, NE                         59.52    11273.4
257 Sioux City, IA                     118.91    11392.3
258 Sioux Falls, SD                     75.45   11467.76
228 Saint Cloud, MN                    223.72   11691.48
166 Minneapolis, MN                     73.94   11765.42
233 Saint Paul, MN                      12.03   11777.45
222 Rochester, MN                       76.94   11854.39
81 Eau Claire, WI                       86.5   11940.89
270 Superior, WI                       138.42    12079.3
79 Duluth, MN                           4.32   12083.63
278 Thunder Bay, ON                    221.38   12305.01
108 Green Bay, WI                      281.05   12586.06
253 Sheboygan, WI                       57.13   12643.19
158 Madison, WI                         125.6   12768.78
78 Dubuque, IA                         95.84   12864.62
49 Cedar Rapids, IA                    75.74   12940.36
124 Iowa City, IA                       25.25   12965.61
295 Waterloo, IA                        80.35   13045.96
75 Des Moines, IA                     107.02   13152.99
63 Columbia, MO                       203.13   13356.12
264 Springfield, MO                    137.23   13493.35
130 Joplin, MO                          84.44   13577.79
95 Ft Smith, AR                       117.62    13695.4
287 Tulsa, OK                          122.27   13817.67
77 Dodge City, KS                     299.19   14116.86
7 Amarillo, TX                       215.16   14332.02
156 Lubbock, TX                        113.61   14445.63
1 Abilene, TX                        166.25   14611.88
84 El Paso, TX                        469.27   15081.15
4 Albuquerque, NM                    230.08   15311.23
246 Santa Fe, NM                        64.52   15375.75
102 Gallup, NM                         194.11   15569.86
93 Flagstaff, AZ                      202.26   15772.12
199 Phoenix, AZ                        124.38    15896.5
286 Tucson, AZ                         116.06   16012.56
311 Yuma, AZ                           257.86   16270.41
240 San Diego, CA                      175.01   16445.43
239 San Bernardino, CA                  96.69   16542.12
193 Pasadena, CA                        59.12   16601.24
153 Los Angeles, CA                      9.51   16610.75
244 Santa Barbara, CA                  103.68   16714.43
17 Bakersfield, CA                     80.84   16795.27
99 Fresno, CA                         108.31   16903.58
268 Stockton, CA                       134.15   17037.73
225 Sacramento, CA                      45.35   17083.08
26 Berkeley, CA                         72.8   17155.88
186 Oakland, CA                          4.65   17160.53
241 San Francisco, CA                   10.47      17171
242 San Jose, CA                        47.11   17218.11
245 Santa Cruz, CA                      26.93   17245.03
48 Carson City, NV                    217.59   17462.63
219 Reno, NV                            25.48   17488.11
88 Eureka, CA                         313.15   17801.26
87 Eugene, OR                         236.57   18037.82
235 Salem, OR                           61.63   18099.46
206 Portland, OR                        47.17   18146.63
273 Tacoma, WA                         120.57    18267.2
252 Seattle, WA                         25.62   18292.82
25 Bellingham, WA                      80.42   18373.24
290 Vancouver, BC                       56.66    18429.9
291 Victoria, BC                        41.45   18471.35
308 Yakima, WA                         246.37   18717.72
293 Walla Walla, WA                    153.98    18871.7
261 Spokane, WA                        127.07   18998.77
33 Boise, ID                          291.99   19290.76
203 Pocatello, ID                      264.67   19555.43
187 Ogden, UT                          118.47    19673.9
237 Salt Lake City, UT                  32.44   19706.34
211 Provo, UT                           39.79   19746.13
105 Grand Junction, CO                 229.45   19975.58
74 Denver, CO                         250.76   20226.34
62 Colorado Springs, CO                63.56    20289.9
212 Pueblo, CO                          42.63   20332.53
57 Cheyenne, WY                       199.91   20532.45
216 Rapid City, SD                     230.96    20763.4
200 Pierre, SD                         199.98   20963.38
31 Bismarck, ND                       171.22    21134.6
167 Minot, ND                          104.59   21239.19
36 Brandon, MB                        148.55   21387.74
305 Winnipeg, MB                       187.08   21574.82
92 Fargo, ND                          211.94   21786.76
218 Regina, SK                         597.09   22383.85
173 Moose Jaw, SK                       62.04   22445.89
248 Saskatoon, SK                      149.68   22595.57
161 Medicine Hat, AB                   315.13    22910.7
146 Lethbridge, AB                     146.13   23056.82
45 Calgary, AB                        132.75   23189.57
82 Edmonton, AB                       173.35   23362.92
107 Great Falls, MT                    446.74   23809.67
118 Helena, MT                           80.7   23890.36
44 Butte, MT                           53.31   23943.68
27 Billings, MT                       279.14   24222.81
255 Sheridan, WY                       126.61   24349.42
144 Las Vegas, NV                      821.24   25170.67
209 Prince Rupert, BC                 1638.53   26809.19
131 Juneau, AK                         390.43   27199.62
298 Whitehorse, YK                     172.32   27371.94
70 Dawson, YT                         362.92   27734.86
90 Fairbanks, AK                         596   28330.87
8 Anchorage, AK                      292.11   28622.97
183 Nome, AK                          1095.15   29718.13
148 Lihue, HI                          2967.4   32685.52
120 Honolulu, HI                        114.5   32800.02
119 Hilo, HI                              176   32976.02
309 Yellowknife, NT                   4111.93   37087.96
59 Churchill, MB                     1431.71   38519.67
249 Sault Ste Marie, ON               1073.27   39592.94
269 Sudbury, ON                        256.57   39849.51
185 North Bay, ON                          93   39942.51
279 Timmins, ON                        198.01   40140.52
152 London, ON                         387.85   40528.37
223 Rochester, NY                       249.8   40778.17
272 Syracuse, NY                       101.71   40879.88
289 Utica, NY                           63.31   40943.18
29 Binghamtom, NY                      83.89   41027.07
301 Wilkes-Barre, PA                    58.97   41086.05
6 Allentown, PA                       51.68   41137.72
13 Atlantic City, NJ                  113.26   41250.99
50 Central Islip, NY                  129.74   41380.73
202 Pittsfield, MA                      114.7   41495.43
285 Troy, NY                            36.34   41531.77
3 Albany, NY                           6.88   41538.65
251 Schenectady, NY                     16.88   41555.54
307 Worcester, MA                      152.51   41708.04
210 Providence, RI                      40.53   41748.58
91 Fall River, MA                      19.72   41768.29
40 Brockton, MA                        28.03   41796.32
34 Boston, MA                          19.21   41815.53
46 Cambridge, MA                        3.36    41818.9
155 Lowell, MA                          23.03   41841.93
145 Lawrence, MA                        11.73   41853.65
159 Manchester, NH                      28.36   41882.01
67 Concord, NH                         15.76   41897.76
207 Portsmouth, NH                      54.37   41952.14
205 Portland, ME                        53.74   42005.88
15 Augusta, ME                         55.61   42061.49
19 Bangor, ME                          77.07   42138.56
98 Fredericton, NB                    171.89   42310.45
229 Saint John, NB                      58.53   42368.98
169 Moncton, NB                         99.94   42468.93
55 Charlottetown, PE                  108.58    42577.5
113 Halifax, NS                        100.98   42678.49
271 Syndey, NS                         254.97   42933.46
230 Saint John's, NF                   514.07   43447.53
213 Quebec City, QC                   1290.47   44737.99
284 Trois-Rivieres, QC                 190.67   44928.66
254 Sherbrooke, QC                      93.08   45021.74
221 Roanoke, VA                        802.17   45823.91
53 Charleston, WV                     138.61   45962.52
11 Ashland, KY                         70.03   46032.55
149 Lima, OH                           186.42   46218.96
232 Saint Louis, MO                    445.62   46664.59
303 Wilmington, NC                     899.59   47564.17
243 San Juan, PR                      1361.81   48925.99
5 Alert, NT                         4433.43   53359.42
51 Champaign, IL                     3435.34   56794.75
2   56794.89         51 Champaign, IL
288 Urbana, IL                           2.52       2.52
73 Decatur, IL                         54.92      57.45
262 Springfield, IL                     47.66     105.11
196 Peoria, IL                          61.75     166.86
32 Bloomington, IL                      43.6     210.46
224 Rockford, IL                       123.66     334.12
135 Kenosha, WI                         90.57     424.69
165 Milwaukee, WI                       31.93     456.62
214 Racine, WI                          23.24     479.86
58 Chicago, IL                         61.23     541.09
104 Gary, IN                            27.47     568.56
259 South Bend, IN                      76.01     644.57
132 Kalamazoo, MI                       62.16     706.73
21 Battle Creek, MI                    28.23     734.96
142 Lansing, MI                         51.65     786.61
125 Jackson, MI                         35.28     821.89
9 Ann Arbor, MI                       46.67     868.56
280 Toledo, OH                          43.57     912.13
76 Detroit, MI                         58.03     970.16
304 Windsor, ON                          7.21     977.37
94 Flint, MI                           71.67    1049.04
226 Saginaw, MI                          33.5    1082.54
22 Bay City, MI                        12.83    1095.36
106 Grand Rapids, MI                   130.44     1225.8
96 Ft Wayne, IN                          132     1357.8
174 Muncie, IN                          67.15    1424.95
123 Indianapolis, IN                    60.87    1485.83
140 Lafayette, IN                       66.81    1552.63
276 Terre Haute, IN                     75.45    1628.09
89 Evansville, IN                     103.56    1731.64
192 Paducah, KY                         94.86    1826.51
175 Nashville, TN                      140.56    1967.07
35 Bowling Green, KY                   61.65    2028.71
154 Louisville, KY                       99.3    2128.02
147 Lexington, KY                       90.44    2218.46
60 Cincinnati, OH                      81.08    2299.54
114 Hamilton, OH                        17.93    2317.47
71 Dayton, OH                          35.63     2353.1
265 Springfield, OH                     28.81    2381.91
66 Columbus, OH                        56.03    2437.94
312 Zanesville, OH                      68.11    2506.04
47 Canton, OH                          73.78    2579.83
2 Akron, OH                            21.8    2601.63
61 Cleveland, OH                       31.35    2632.98
310 Youngstown, OH                      77.36    2710.33
267 Steubenville, OH                    50.45    2760.79
297 Wheeling, WV                        21.97    2782.75
201 Pittsburgh, PA                      56.46    2839.21
86 Erie, PA                           116.83    2956.05
37 Brantford, ON                       71.49    3027.54
138 Kitchener, ON                       22.82    3050.35
111 Guelph, ON                          10.29    3060.65
42 Burlington, ONT                     29.68    3090.32
115 Hamilton, ON                        19.51    3109.83
227 Saint Catherines, ON                52.51    3162.34
182 Niagara Falls, ON                    8.92    3171.26
41 Buffalo, NY                         20.54     3191.8
282 Toronto, ON                         62.46    3254.26
197 Peterborough, ON                    82.62    3336.88
24 Belleville, ON                      72.87    3409.75
137 Kingston, ON                        49.28    3459.03
191 Ottawa, ON                          85.39    3544.41
172 Montreal, QC                       146.68     3691.1
43 Burlington, VT                      97.19    3788.29
171 Montpelier, VT                      46.45    3834.74
38 Brattleboro, VT                     97.37    3932.11
263 Springfield, MA                     51.84    3983.94
117 Hartford, CT                        24.25     4008.2
178 New Britain,CT                       9.62    4017.82
163 Meriden, CT                          8.71    4026.53
179 New Haven, CT                       17.96    4044.49
39 Bridgeport, CT                      21.46    4065.95
266 Stamford, CT                        24.55     4090.5
299 White Plains, NY                    15.36    4105.86
181 New York, NY                        27.75    4133.61
128 Jersey City, NJ                      5.04    4138.65
177 Newark, NJ                           6.57    4145.22
83 Elizabeth, NJ                        5.61    4150.84
194 Paterson, NJ                        17.67     4168.5
283 Trenton, NJ                          62.4     4230.9
198 Philadelphia, PA                    34.35    4265.26
302 Wilmington, DE                      30.05    4295.31
217 Reading, PA                         48.48    4343.79
129 Johnstown, PA                        27.2    4370.99
141 Lancaster, PA                       16.64    4387.63
116 Harrisburg, PA                      43.19    4430.82
18 Baltimore, MD                        70.5    4501.31
294 Washington, DC                      40.06    4541.38
220 Richmond, VA                        97.21    4638.58
208 Portsmouth, VA                      94.39    4732.97
184 Norfolk, VA                          1.19    4734.16
215 Raleigh, NC                        178.76    4912.92
80 Durham, NC                          23.61    4936.54
109 Greensboro, NC                      61.97    4998.51
306 Winston-Salem, NC                    31.3     5029.8
54 Charlotte, NC                       73.13    5102.94
260 Spartanburg, NC                     77.64    5180.58
110 Greenville, SC                      32.62    5213.19
10 Asheville, NC                       52.87    5266.06
139 Knoxville, TN                       97.65    5363.71
56 Chattanooga, TN                    114.91    5478.63
100 Gadsden, AL                         86.02    5564.64
122 Huntsville, AL                      63.64    5628.29
30 Birmingham, AL                      84.91    5713.19
170 Montgomery, AL                      86.96    5800.16
65 Columbus, GA                         90.9    5891.06
157 Macon, GA                           97.26    5988.32
12 Atlanta, GA                         81.64    6069.95
14 Augusta, GA                        167.83    6237.79
64 Columbia, SC                        74.55    6312.34
52 Charleston, SC                      113.9    6426.24
250 Savannah, GA                         93.9    6520.14
127 Jacksonville, FL                   126.96    6647.09
101 Gainesville, FL                     65.95    6713.05
72 Daytona Beach, FL                   94.98    6808.02
190 Orlando, FL                         52.58    6860.61
275 Tampa, FL                           85.01    6945.62
234 Saint Petersburg, FL                19.54    6965.15
247 Sarasota, FL                        31.73    6996.88
296 West Palm Beach, FL                176.46    7173.34
164 Miami, FL                           65.75    7239.09
136 Key West, FL                       138.36    7377.45
274 Tallahassee, FL                    441.61    7819.06
195 Pensacola, FL                      202.87    8021.93
168 Mobile, AL                          60.12    8082.04
28 Biloxi, MS                          61.74    8143.79
112 Gulfport, MS                        14.47    8158.25
180 New Orleans, LA                     73.62    8231.87
20 Baton Rouge, LA                     82.09    8313.96
176 Natchez, MS                         78.58    8392.54
126 Jackson, MS                         98.43    8490.97
162 Memphis, TN                         197.2    8688.17
151 Little Rock, AR                     157.3    8845.47
277 Texarkana, TX                      151.96    8997.42
160 Marshall, TX                        64.71    9062.13
256 Shreveport, LA                      42.67    9104.81
23 Beaumont, TX                       170.28    9275.09
204 Port Arthur, TX                     17.62    9292.71
103 Galveston, TX                       72.86    9365.57
121 Houston, TX                         50.45    9416.02
16 Austin, TX                         168.07     9584.1
238 San Antonio, TX                     77.99    9662.09
68 Corpus Christi, TX                 135.39    9797.48
143 Laredo, TX                         147.28    9944.76
292 Waco, TX                            323.5   10268.26
97 Ft Worth, TX                        82.15   10350.41
69 Dallas, TX                          36.19    10386.6
188 Oklahoma City, OK                  191.95   10578.55
85 Enid, OK                            68.83   10647.38
300 Wichita, KS                         97.07   10744.46
236 Salina, KS                          81.55      10826
281 Topeka, KS                         134.35   10960.35
133 Kansas City, KS                     72.73   11033.09
134 Kansas City, MO                      3.52   11036.61
231 Saint Joseph, MO                    49.79    11086.4
189 Omaha, NE                          127.61   11214.01
150 Lincoln, NE                         59.52   11273.53
257 Sioux City, IA                     118.91   11392.44
258 Sioux Falls, SD                     75.45   11467.89
228 Saint Cloud, MN                    223.72   11691.61
166 Minneapolis, MN                     73.94   11765.55
233 Saint Paul, MN                      12.03   11777.58
222 Rochester, MN                       76.94   11854.52
81 Eau Claire, WI                       86.5   11941.02
270 Superior, WI                       138.42   12079.44
79 Duluth, MN                           4.32   12083.76
278 Thunder Bay, ON                    221.38   12305.14
108 Green Bay, WI                      281.05   12586.19
253 Sheboygan, WI                       57.13   12643.32
158 Madison, WI                         125.6   12768.91
78 Dubuque, IA                         95.84   12864.75
49 Cedar Rapids, IA                    75.74    12940.5
124 Iowa City, IA                       25.25   12965.74
295 Waterloo, IA                        80.35    13046.1
75 Des Moines, IA                     107.02   13153.12
63 Columbia, MO                       203.13   13356.25
264 Springfield, MO                    137.23   13493.48
130 Joplin, MO                          84.44   13577.92
95 Ft Smith, AR                       117.62   13695.54
287 Tulsa, OK                          122.27    13817.8
77 Dodge City, KS                     299.19      14117
7 Amarillo, TX                       215.16   14332.15
156 Lubbock, TX                        113.61   14445.76
1 Abilene, TX                        166.25   14612.02
84 El Paso, TX                        469.27   15081.29
4 Albuquerque, NM                    230.08   15311.37
246 Santa Fe, NM                        64.52   15375.88
102 Gallup, NM                         194.11   15569.99
93 Flagstaff, AZ                      202.26   15772.25
199 Phoenix, AZ                        124.38   15896.63
286 Tucson, AZ                         116.06   16012.69
311 Yuma, AZ                           257.86   16270.55
240 San Diego, CA                      175.01   16445.56
239 San Bernardino, CA                  96.69   16542.25
193 Pasadena, CA                        59.12   16601.38
153 Los Angeles, CA                      9.51   16610.89
244 Santa Barbara, CA                  103.68   16714.56
17 Bakersfield, CA                     80.84   16795.41
99 Fresno, CA                         108.31   16903.71
268 Stockton, CA                       134.15   17037.87
225 Sacramento, CA                      45.35   17083.21
26 Berkeley, CA                         72.8   17156.01
186 Oakland, CA                          4.65   17160.66
241 San Francisco, CA                   10.47   17171.13
242 San Jose, CA                        47.11   17218.24
245 Santa Cruz, CA                      26.93   17245.17
48 Carson City, NV                    217.59   17462.76
219 Reno, NV                            25.48   17488.24
88 Eureka, CA                         313.15   17801.39
87 Eugene, OR                         236.57   18037.96
235 Salem, OR                           61.63   18099.59
206 Portland, OR                        47.17   18146.76
273 Tacoma, WA                         120.57   18267.33
252 Seattle, WA                         25.62   18292.95
25 Bellingham, WA                      80.42   18373.37
290 Vancouver, BC                       56.66   18430.03
291 Victoria, BC                        41.45   18471.48
308 Yakima, WA                         246.37   18717.85
293 Walla Walla, WA                    153.98   18871.83
261 Spokane, WA                        127.07    18998.9
33 Boise, ID                          291.99    19290.9
203 Pocatello, ID                      264.67   19555.56
187 Ogden, UT                          118.47   19674.03
237 Salt Lake City, UT                  32.44   19706.47
211 Provo, UT                           39.79   19746.26
105 Grand Junction, CO                 229.45   19975.72
74 Denver, CO                         250.76   20226.47
62 Colorado Springs, CO                63.56   20290.03
212 Pueblo, CO                          42.63   20332.67
57 Cheyenne, WY                       199.91   20532.58
216 Rapid City, SD                     230.96   20763.54
200 Pierre, SD                         199.98   20963.52
31 Bismarck, ND                       171.22   21134.74
167 Minot, ND                          104.59   21239.32
36 Brandon, MB                        148.55   21387.87
305 Winnipeg, MB                       187.08   21574.95
92 Fargo, ND                          211.94   21786.89
218 Regina, SK                         597.09   22383.98
173 Moose Jaw, SK                       62.04   22446.03
248 Saskatoon, SK                      149.68    22595.7
161 Medicine Hat, AB                   315.13   22910.83
146 Lethbridge, AB                     146.13   23056.96
45 Calgary, AB                        132.75    23189.7
82 Edmonton, AB                       173.35   23363.06
107 Great Falls, MT                    446.74    23809.8
118 Helena, MT                           80.7    23890.5
44 Butte, MT                           53.31   23943.81
27 Billings, MT                       279.14   24222.95
255 Sheridan, WY                       126.61   24349.56
144 Las Vegas, NV                      821.24    25170.8
209 Prince Rupert, BC                 1638.53   26809.33
131 Juneau, AK                         390.43   27199.75
298 Whitehorse, YK                     172.32   27372.07
70 Dawson, YT                         362.92      27735
90 Fairbanks, AK                         596      28331
8 Anchorage, AK                      292.11   28623.11
183 Nome, AK                          1095.15   29718.26
148 Lihue, HI                          2967.4   32685.65
120 Honolulu, HI                        114.5   32800.16
119 Hilo, HI                              176   32976.16
309 Yellowknife, NT                   4111.93   37088.09
59 Churchill, MB                     1431.71    38519.8
249 Sault Ste Marie, ON               1073.27   39593.07
269 Sudbury, ON                        256.57   39849.65
185 North Bay, ON                          93   39942.65
279 Timmins, ON                        198.01   40140.66
152 London, ON                         387.85   40528.51
223 Rochester, NY                       249.8    40778.3
272 Syracuse, NY                       101.71   40880.01
289 Utica, NY                           63.31   40943.32
29 Binghamtom, NY                      83.89   41027.21
301 Wilkes-Barre, PA                    58.97   41086.18
6 Allentown, PA                       51.68   41137.86
13 Atlantic City, NJ                  113.26   41251.12
50 Central Islip, NY                  129.74   41380.86
202 Pittsfield, MA                      114.7   41495.56
285 Troy, NY                            36.34    41531.9
3 Albany, NY                           6.88   41538.78
251 Schenectady, NY                     16.88   41555.67
307 Worcester, MA                      152.51   41708.18
210 Providence, RI                      40.53   41748.71
91 Fall River, MA                      19.72   41768.43
40 Brockton, MA                        28.03   41796.45
34 Boston, MA                          19.21   41815.67
46 Cambridge, MA                        3.36   41819.03
155 Lowell, MA                          23.03   41842.06
145 Lawrence, MA                        11.73   41853.79
159 Manchester, NH                      28.36   41882.14
67 Concord, NH                         15.76    41897.9
207 Portsmouth, NH                      54.37   41952.27
205 Portland, ME                        53.74   42006.01
15 Augusta, ME                         55.61   42061.62
19 Bangor, ME                          77.07    42138.7
98 Fredericton, NB                    171.89   42310.58
229 Saint John, NB                      58.53   42369.11
169 Moncton, NB                         99.94   42469.06
55 Charlottetown, PE                  108.58   42577.64
113 Halifax, NS                        100.98   42678.62
271 Syndey, NS                         254.97   42933.59
230 Saint John's, NF                   514.07   43447.66
213 Quebec City, QC                   1290.47   44738.13
284 Trois-Rivieres, QC                 190.67    44928.8
254 Sherbrooke, QC                      93.08   45021.87
221 Roanoke, VA                        802.17   45824.05
53 Charleston, WV                     138.61   45962.65
11 Ashland, KY                         70.03   46032.68
149 Lima, OH                           186.42    46219.1
232 Saint Louis, MO                    445.62   46664.72
303 Wilmington, NC                     899.59   47564.31
243 San Juan, PR                      1361.81   48926.12
5 Alert, NT                         4433.43   53359.55
51 Champaign, IL                     3435.34   56794.89

1252 rows selected.

Elapsed: 00:01:25.25
```
```Longest Routes
==============
ROOT_LEG       PATH_RNK   TOT_DIST    TOWN_ID NAME                             LEG_DIST   CUM_DIST
------------ ---------- ---------- ---------- ------------------------------ ---------- ----------
183 -> 230            1  649684.75        183 Nome, AK
230 Saint John's, NF                  7870.89    7870.89
148 Lihue, HI                         7576.95   15447.85
5 Alert, NT                         7905.76   23353.61
119 Hilo, HI                          7786.39   31139.99
271 Syndey, NS                        6867.36   38007.35
120 Honolulu, HI                      6973.04   44980.39
55 Charlottetown, PE                 6769.69   51750.08
8 Anchorage, AK                     6084.17   57834.25
243 San Juan, PR                       6499.8   64334.05
90 Fairbanks, AK                     6485.59   70819.64
113 Halifax, NS                        5979.6   76799.24
70 Dawson, YT                        5390.11   82189.35
169 Moncton, NB                       5290.95    87480.3
298 Whitehorse, YK                    4966.85   92447.16
229 Saint John, NB                    4896.82   97343.98
131 Juneau, AK                        4819.35  102163.34
98 Fredericton, NB                   4768.78  106932.11
209 Prince Rupert, BC                 4454.24  111386.35
19 Bangor, ME                        4310.99  115697.34
88 Eureka, CA                        3836.77  119534.11
15 Augusta, ME                        3765.4  123299.51
291 Victoria, BC                      3718.78  127018.29
205 Portland, ME                      3689.93  130708.23
290 Vancouver, BC                      3676.9  134385.13
207 Portsmouth, NH                    3646.55  138031.68
87 Eugene, OR                        3615.89  141647.57
40 Brockton, MA                      3600.15  145247.72
235 Salem, OR                         3599.44  148847.16
34 Boston, MA                        3595.59  152442.75
25 Bellingham, WA                    3580.78  156023.53
91 Fall River, MA                    3580.15  159603.68
206 Portland, OR                      3569.55  163173.24
46 Cambridge, MA                     3569.83  166743.06
273 Tacoma, WA                        3563.14   170306.2
145 Lawrence, MA                      3557.08  173863.27
241 San Francisco, CA                 3557.84  177421.11
213 Quebec City, QC                      3607  181028.11
186 Oakland, CA                       3596.53  184624.65
155 Lowell, MA                        3536.42  188161.06
252 Seattle, WA                       3541.57  191702.63
210 Providence, RI                     3540.8  195243.43
26 Berkeley, CA                      3524.68  198768.11
254 Sherbrooke, QC                    3533.82  202301.93
245 Santa Cruz, CA                    3527.03  205828.96
159 Manchester, NH                    3519.15  209348.11
242 San Jose, CA                      3506.93  212855.04
67 Concord, NH                       3502.92  216357.96
225 Sacramento, CA                    3466.46  219824.42
307 Worcester, MA                     3442.81  223267.23
268 Stockton, CA                      3432.24  226699.47
284 Trois-Rivieres, QC                3408.48  230107.95
244 Santa Barbara, CA                 3351.71  233459.66
171 Montpelier, VT                     3326.1  236785.76
308 Yakima, WA                        3315.62  240101.39
263 Springfield, MA                   3325.25  243426.64
99 Fresno, CA                        3280.93  246707.57
38 Brattleboro, VT                   3289.35  249996.92
219 Reno, NV                          3273.12  253270.05
117 Hartford, CT                      3259.94  256529.98
48 Carson City, NV                   3258.04  259788.02
178 New Britain,CT                    3251.14  263039.16
17 Bakersfield, CA                   3224.24   266263.4
43 Burlington, VT                    3226.83  269490.23
153 Los Angeles, CA                   3193.66  272683.89
163 Meriden, CT                        3181.7  275865.59
309 Yellowknife, NT                   3219.55  279085.14
164 Miami, FL                         3467.82  282552.96
82 Edmonton, AB                      2998.65  285551.61
136 Key West, FL                      2971.34  288522.96
261 Spokane, WA                       2934.85  291457.81
179 New Haven, CT                     3105.67  294563.47
193 Pasadena, CA                      3163.09  297726.57
172 Montreal, QC                      3157.19  300883.76
240 San Diego, CA                     3118.23  304001.99
202 Pittsfield, MA                     3107.7  307109.68
293 Walla Walla, WA                   3125.94  310235.63
50 Central Islip, NY                 3140.18   313375.8
239 San Bernardino, CA                3080.98  316456.79
39 Bridgeport, CT                    3084.78  319541.56
33 Boise, ID                         2975.73  322517.29
266 Stamford, CT                      2952.96  325470.25
311 Yuma, AZ                           2896.3  328366.55
285 Troy, NY                          2911.41  331277.97
144 Las Vegas, NV                      2899.2  334177.16
3 Albany, NY                        2893.98  337071.14
45 Calgary, AB                       2842.81  339913.95
296 West Palm Beach, FL               2889.69  342803.64
146 Lethbridge, AB                    2761.59  345565.23
299 White Plains, NY                  2761.87   348327.1
44 Butte, MT                         2700.79  351027.89
181 New York, NY                      2687.05  353714.95
199 Phoenix, AZ                       2677.74  356392.69
251 Schenectady, NY                   2713.16  359105.85
203 Pocatello, ID                     2660.51  361766.36
128 Jersey City, NJ                    2655.1  364421.46
118 Helena, MT                         2653.8  367075.27
177 Newark, NJ                        2647.25  369722.51
93 Flagstaff, AZ                     2617.66  372340.18
194 Paterson, NJ                      2619.56  374959.74
187 Ogden, UT                         2611.96   377571.7
83 Elizabeth, NJ                     2609.47  380181.16
107 Great Falls, MT                   2605.85  382787.01
13 Atlantic City, NJ                  2609.3  385396.31
161 Medicine Hat, AB                  2613.82  388010.13
283 Trenton, NJ                        2576.5  390586.63
237 Salt Lake City, UT                2566.97  393153.59
289 Utica, NY                         2538.01   395691.6
286 Tucson, AZ                        2578.23  398269.82
191 Ottawa, ON                        2575.89  400845.71
211 Provo, UT                          2487.2  403332.91
198 Philadelphia, PA                  2521.63  405854.54
27 Billings, MT                      2338.33  408192.87
302 Wilmington, DE                    2314.81  410507.68
248 Saskatoon, SK                     2317.41  412825.09
247 Sarasota, FL                      2394.44  415219.54
59 Churchill, MB                     2311.24  417530.77
234 Saint Petersburg, FL              2279.52  419810.29
173 Moose Jaw, SK                     2220.06  422030.35
190 Orlando, FL                       2249.04  424279.39
218 Regina, SK                        2208.47  426487.86
72 Daytona Beach, FL                 2195.17  428683.03
255 Sheridan, WY                      2090.58  430773.61
6 Allentown, PA                     2193.28  432966.89
102 Gallup, NM                        2324.19  435291.08
29 Binghamtom, NY                    2312.96  437604.04
105 Grand Junction, CO                2264.43  439868.47
301 Wilkes-Barre, PA                  2262.27  442130.74
84 El Paso, TX                       2213.93  444344.68
137 Kingston, ON                      2237.67  446582.35
4 Albuquerque, NM                    2170.5  448752.84
272 Syracuse, NY                      2178.26   450931.1
246 Santa Fe, NM                      2120.23  453051.33
217 Reading, PA                       2098.29  455149.62
74 Denver, CO                        2008.13  457157.75
208 Portsmouth, VA                    1992.18  459149.93
57 Cheyenne, WY                      1993.01  461142.94
184 Norfolk, VA                       1993.78  463136.72
62 Colorado Springs, CO              1976.45  465113.17
129 Johnstown, PA                     1972.05  467085.22
212 Pueblo, CO                        1959.85  469045.06
141 Lancaster, PA                     1959.48  471004.54
216 Rapid City, SD                    1881.23  472885.77
303 Wilmington, NC                    1875.13   474760.9
167 Minot, ND                         1881.45  476642.36
275 Tampa, FL                         1912.76  478555.12
36 Brandon, MB                       1940.02  480495.14
101 Gainesville, FL                   1855.41  482350.55
31 Bismarck, ND                      1741.25   484091.8
18 Baltimore, MD                     1749.02  485840.82
143 Laredo, TX                        1779.18  487620.01
24 Belleville, ON                    1918.78  489538.79
156 Lubbock, TX                       1847.76  491386.54
116 Harrisburg, PA                    1786.27  493172.82
7 Amarillo, TX                      1758.66  494931.47
223 Rochester, NY                     1760.64  496692.12
68 Corpus Christi, TX                1730.17  498422.29
279 Timmins, ON                       1812.36  500234.65
238 San Antonio, TX                   1774.49  502009.14
185 North Bay, ON                     1763.41  503772.55
1 Abilene, TX                       1701.18  505473.73
197 Peterborough, ON                  1685.89  507159.62
16 Austin, TX                         1650.4  508810.02
269 Sudbury, ON                       1627.33  510437.35
121 Houston, TX                       1539.52  511976.87
41 Buffalo, NY                       1455.86  513432.73
77 Dodge City, KS                    1503.01  514935.73
294 Washington, DC                    1589.78  516525.51
200 Pierre, SD                        1654.69   518180.2
52 Charleston, SC                    1622.39  519802.59
305 Winnipeg, MB                      1683.01  521485.61
127 Jacksonville, FL                  1729.19   523214.8
92 Fargo, ND                          1549.3   524764.1
220 Richmond, VA                       1482.8  526246.89
292 Waco, TX                          1422.07  527668.96
282 Toronto, ON                       1483.47  529152.43
103 Galveston, TX                     1453.39  530605.82
182 Niagara Falls, ON                 1446.61  532052.43
97 Ft Worth, TX                      1451.32  533503.75
227 Saint Catherines, ON               1447.6  534951.35
69 Dallas, TX                        1414.51  536365.85
42 Burlington, ONT                   1383.45   537749.3
204 Port Arthur, TX                   1349.79   539099.1
111 Guelph, ON                        1334.48  540433.58
23 Beaumont, TX                      1333.91  541767.49
115 Hamilton, ON                      1332.75  543100.24
188 Oklahoma City, OK                 1326.53  544426.77
138 Kitchener, ON                     1306.17  545732.94
85 Enid, OK                          1303.54  547036.48
215 Raleigh, NC                       1330.04  548366.51
258 Sioux Falls, SD                   1358.74  549725.26
250 Savannah, GA                      1337.75  551063.01
228 Saint Cloud, MN                   1296.84  552359.85
274 Tallahassee, FL                   1248.21  553608.06
278 Thunder Bay, ON                   1287.21  554895.27
180 New Orleans, LA                   1273.63  556168.89
249 Sault Ste Marie, ON               1205.19  557374.08
20 Baton Rouge, LA                   1199.28  558573.36
37 Brantford, ON                     1151.44   559724.8
300 Wichita, KS                       1232.93  560957.73
80 Durham, NC                         1279.4  562237.14
236 Salina, KS                         1307.8  563544.94
109 Greensboro, NC                    1245.96   564790.9
257 Sioux City, IA                    1230.47  566021.37
64 Columbia, SC                      1213.26  567234.63
150 Lincoln, NE                       1177.83  568412.46
221 Roanoke, VA                       1181.08  569593.54
189 Omaha, NE                         1139.08  570732.62
306 Winston-Salem, NC                 1141.42  571874.04
79 Duluth, MN                        1103.04  572977.08
195 Pensacola, FL                     1179.96  574157.04
270 Superior, WI                      1175.77  575332.81
14 Augusta, GA                       1152.38  576485.19
166 Minneapolis, MN                    1113.9  577599.09
54 Charlotte, NC                     1091.15  578690.24
233 Saint Paul, MN                    1080.39  579770.63
157 Macon, GA                         1061.49  580832.12
81 Eau Claire, WI                     989.72  581821.84
28 Biloxi, MS                        1012.28  582834.12
152 London, ON                        1016.65  583850.76
160 Marshall, TX                      1158.56  585009.32
86 Erie, PA                          1188.43  586197.75
287 Tulsa, OK                          1174.1  587371.86
201 Pittsburgh, PA                    1144.29  588516.15
256 Shreveport, LA                    1096.48  589612.63
310 Youngstown, OH                    1081.83  590694.46
277 Texarkana, TX                     1066.85  591761.31
267 Steubenville, OH                  1043.65  592804.96
281 Topeka, KS                        1043.45  593848.41
297 Wheeling, WV                      1035.82  594884.23
95 Ft Smith, AR                       998.79  595883.02
47 Canton, OH                         974.26  596857.28
130 Joplin, MO                         943.13  597800.41
2 Akron, OH                          939.34  598739.75
176 Natchez, MS                        948.25  599688.01
22 Bay City, MI                       980.29   600668.3
112 Gulfport, MS                       982.13  601650.43
108 Green Bay, WI                      980.65  602631.08
168 Mobile, AL                         955.25  603586.33
222 Rochester, MN                      970.35  604556.68
260 Spartanburg, NC                    960.77  605517.44
231 Saint Joseph, MO                   952.41  606469.86
110 Greenville, SC                     925.02  607394.87
75 Des Moines, IA                     904.35  608299.23
10 Asheville, NC                      869.08   609168.3
133 Kansas City, KS                     868.8   610037.1
61 Cleveland, OH                      908.59  610945.69
134 Kansas City, MO                    905.45  611851.14
53 Charleston, WV                     895.98  612747.12
264 Springfield, MO                    809.82  613556.95
312 Zanesville, OH                     802.13  614359.08
151 Little Rock, AR                    795.57  615154.65
226 Saginaw, MI                        831.32  615985.97
126 Jackson, MS                         880.9  616866.87
94 Flint, MI                          865.78  617732.65
170 Montgomery, AL                     757.41  618490.06
295 Waterloo, IA                       814.78  619304.84
65 Columbus, GA                       859.51  620164.34
49 Cedar Rapids, IA                   804.18  620968.53
12 Atlanta, GA                        759.63  621728.16
78 Dubuque, IA                        744.13  622472.29
30 Birmingham, AL                     675.42   623147.7
253 Sheboygan, WI                      709.66  623857.37
100 Gadsden, AL                        683.03   624540.4
158 Madison, WI                        668.43  625208.83
56 Chattanooga, TN                    622.55  625831.37
124 Iowa City, IA                      627.43   626458.8
139 Knoxville, TN                      656.94  627115.74
63 Columbia, MO                       616.95  627732.69
304 Windsor, ON                         687.3  628419.98
162 Memphis, TN                        694.56  629114.55
76 Detroit, MI                        693.11  629807.66
122 Huntsville, AL                     579.38  630387.04
165 Milwaukee, WI                      581.29  630968.33
11 Ashland, KY                        481.46  631449.79
232 Saint Louis, MO                    522.45  631972.25
9 Ann Arbor, MI                      513.15   632485.4
192 Paducah, KY                        491.81   632977.2
142 Lansing, MI                        480.06  633457.26
175 Nashville, TN                      479.16  633936.42
106 Grand Rapids, MI                   475.97  634412.39
35 Bowling Green, KY                  416.17  634828.56
224 Rockford, IL                       408.25  635236.82
66 Columbus, OH                       450.37  635687.19
262 Springfield, IL                    459.25  636146.44
280 Toledo, OH                         439.91  636586.35
196 Peoria, IL                         422.25  637008.59
265 Springfield, OH                    402.89  637411.49
32 Bloomington, IL                    360.32  637771.81
147 Lexington, KY                      356.49  638128.31
214 Racine, WI                         399.12  638527.43
154 Louisville, KY                     339.14  638866.57
135 Kenosha, WI                         331.4  639197.97
60 Cincinnati, OH                     331.61  639529.58
73 Decatur, IL                        314.29  639843.88
125 Jackson, MI                        355.83   640199.7
89 Evansville, IN                     366.87  640566.58
21 Battle Creek, MI                   342.27  640908.84
51 Champaign, IL                       260.8  641169.64
149 Lima, OH                           289.17  641458.82
288 Urbana, IL                         286.77  641745.59
71 Dayton, OH                         278.52  642024.11
58 Chicago, IL                        279.24  642303.35
114 Hamilton, OH                       272.42  642575.77
104 Gary, IN                           244.97  642820.74
174 Muncie, IN                         166.43  642987.17
276 Terre Haute, IN                    148.82  643135.98
132 Kalamazoo, MI                      232.44  643368.42
123 Indianapolis, IN                   178.76  643547.18
259 South Bend, IN                     132.47  643679.65
140 Lafayette, IN                       97.61  643777.26
96 Ft Wayne, IN                       130.36  643907.62
183 Nome, AK                          5777.13  649684.75
2  649684.62        183 Nome, AK
230 Saint John's, NF                  7870.89    7870.89
148 Lihue, HI                         7576.95   15447.85
5 Alert, NT                         7905.76   23353.61
119 Hilo, HI                          7786.39   31139.99
271 Syndey, NS                        6867.36   38007.35
120 Honolulu, HI                      6973.04   44980.39
55 Charlottetown, PE                 6769.69   51750.08
8 Anchorage, AK                     6084.17   57834.25
243 San Juan, PR                       6499.8   64334.05
90 Fairbanks, AK                     6485.59   70819.64
113 Halifax, NS                        5979.6   76799.24
70 Dawson, YT                        5390.11   82189.35
169 Moncton, NB                       5290.95    87480.3
298 Whitehorse, YK                    4966.85   92447.16
229 Saint John, NB                    4896.82   97343.98
131 Juneau, AK                        4819.35  102163.34
98 Fredericton, NB                   4768.78  106932.11
209 Prince Rupert, BC                 4454.24  111386.35
19 Bangor, ME                        4310.99  115697.34
88 Eureka, CA                        3836.77  119534.11
15 Augusta, ME                        3765.4  123299.51
291 Victoria, BC                      3718.78  127018.29
205 Portland, ME                      3689.93  130708.23
290 Vancouver, BC                      3676.9  134385.13
207 Portsmouth, NH                    3646.55  138031.68
87 Eugene, OR                        3615.89  141647.57
40 Brockton, MA                      3600.15  145247.72
235 Salem, OR                         3599.44  148847.16
34 Boston, MA                        3595.59  152442.75
25 Bellingham, WA                    3580.78  156023.53
91 Fall River, MA                    3580.15  159603.68
206 Portland, OR                      3569.55  163173.24
46 Cambridge, MA                     3569.83  166743.06
273 Tacoma, WA                        3563.14   170306.2
145 Lawrence, MA                      3557.08  173863.27
241 San Francisco, CA                 3557.84  177421.11
213 Quebec City, QC                      3607  181028.11
186 Oakland, CA                       3596.53  184624.65
155 Lowell, MA                        3536.42  188161.06
252 Seattle, WA                       3541.57  191702.63
210 Providence, RI                     3540.8  195243.43
26 Berkeley, CA                      3524.68  198768.11
254 Sherbrooke, QC                    3533.82  202301.93
245 Santa Cruz, CA                    3527.03  205828.96
159 Manchester, NH                    3519.15  209348.11
242 San Jose, CA                      3506.93  212855.04
67 Concord, NH                       3502.92  216357.96
225 Sacramento, CA                    3466.46  219824.42
307 Worcester, MA                     3442.81  223267.23
268 Stockton, CA                      3432.24  226699.47
284 Trois-Rivieres, QC                3408.48  230107.95
244 Santa Barbara, CA                 3351.71  233459.66
171 Montpelier, VT                     3326.1  236785.76
308 Yakima, WA                        3315.62  240101.39
263 Springfield, MA                   3325.25  243426.64
99 Fresno, CA                        3280.93  246707.57
38 Brattleboro, VT                   3289.35  249996.92
219 Reno, NV                          3273.12  253270.05
117 Hartford, CT                      3259.94  256529.98
48 Carson City, NV                   3258.04  259788.02
178 New Britain,CT                    3251.14  263039.16
17 Bakersfield, CA                   3224.24   266263.4
43 Burlington, VT                    3226.83  269490.23
153 Los Angeles, CA                   3193.66  272683.89
163 Meriden, CT                        3181.7  275865.59
309 Yellowknife, NT                   3219.55  279085.14
164 Miami, FL                         3467.82  282552.96
82 Edmonton, AB                      2998.65  285551.61
136 Key West, FL                      2971.34  288522.96
261 Spokane, WA                       2934.85  291457.81
179 New Haven, CT                     3105.67  294563.47
193 Pasadena, CA                      3163.09  297726.57
172 Montreal, QC                      3157.19  300883.76
240 San Diego, CA                     3118.23  304001.99
202 Pittsfield, MA                     3107.7  307109.68
293 Walla Walla, WA                   3125.94  310235.63
50 Central Islip, NY                 3140.18   313375.8
239 San Bernardino, CA                3080.98  316456.79
39 Bridgeport, CT                    3084.78  319541.56
33 Boise, ID                         2975.73  322517.29
266 Stamford, CT                      2952.96  325470.25
311 Yuma, AZ                           2896.3  328366.55
285 Troy, NY                          2911.41  331277.97
144 Las Vegas, NV                      2899.2  334177.16
3 Albany, NY                        2893.98  337071.14
45 Calgary, AB                       2842.81  339913.95
296 West Palm Beach, FL               2889.69  342803.64
146 Lethbridge, AB                    2761.59  345565.23
299 White Plains, NY                  2761.87   348327.1
44 Butte, MT                         2700.79  351027.89
181 New York, NY                      2687.05  353714.95
199 Phoenix, AZ                       2677.74  356392.69
251 Schenectady, NY                   2713.16  359105.85
203 Pocatello, ID                     2660.51  361766.36
128 Jersey City, NJ                    2655.1  364421.46
118 Helena, MT                         2653.8  367075.27
177 Newark, NJ                        2647.25  369722.51
93 Flagstaff, AZ                     2617.66  372340.18
194 Paterson, NJ                      2619.56  374959.74
187 Ogden, UT                         2611.96   377571.7
83 Elizabeth, NJ                     2609.47  380181.16
107 Great Falls, MT                   2605.85  382787.01
13 Atlantic City, NJ                  2609.3  385396.31
161 Medicine Hat, AB                  2613.82  388010.13
283 Trenton, NJ                        2576.5  390586.63
237 Salt Lake City, UT                2566.97  393153.59
289 Utica, NY                         2538.01   395691.6
286 Tucson, AZ                        2578.23  398269.82
191 Ottawa, ON                        2575.89  400845.71
211 Provo, UT                          2487.2  403332.91
198 Philadelphia, PA                  2521.63  405854.54
27 Billings, MT                      2338.33  408192.87
302 Wilmington, DE                    2314.81  410507.68
248 Saskatoon, SK                     2317.41  412825.09
247 Sarasota, FL                      2394.44  415219.54
59 Churchill, MB                     2311.24  417530.77
234 Saint Petersburg, FL              2279.52  419810.29
173 Moose Jaw, SK                     2220.06  422030.35
190 Orlando, FL                       2249.04  424279.39
218 Regina, SK                        2208.47  426487.86
72 Daytona Beach, FL                 2195.17  428683.03
255 Sheridan, WY                      2090.58  430773.61
6 Allentown, PA                     2193.28  432966.89
102 Gallup, NM                        2324.19  435291.08
29 Binghamtom, NY                    2312.96  437604.04
105 Grand Junction, CO                2264.43  439868.47
301 Wilkes-Barre, PA                  2262.27  442130.74
84 El Paso, TX                       2213.93  444344.68
137 Kingston, ON                      2237.67  446582.35
4 Albuquerque, NM                    2170.5  448752.84
272 Syracuse, NY                      2178.26   450931.1
246 Santa Fe, NM                      2120.23  453051.33
217 Reading, PA                       2098.29  455149.62
74 Denver, CO                        2008.13  457157.75
208 Portsmouth, VA                    1992.18  459149.93
57 Cheyenne, WY                      1993.01  461142.94
184 Norfolk, VA                       1993.78  463136.72
62 Colorado Springs, CO              1976.45  465113.17
129 Johnstown, PA                     1972.05  467085.22
212 Pueblo, CO                        1959.85  469045.06
141 Lancaster, PA                     1959.48  471004.54
216 Rapid City, SD                    1881.23  472885.77
303 Wilmington, NC                    1875.13   474760.9
167 Minot, ND                         1881.45  476642.36
275 Tampa, FL                         1912.76  478555.12
36 Brandon, MB                       1940.02  480495.14
101 Gainesville, FL                   1855.41  482350.55
31 Bismarck, ND                      1741.25   484091.8
18 Baltimore, MD                     1749.02  485840.82
143 Laredo, TX                        1779.18  487620.01
24 Belleville, ON                    1918.78  489538.79
156 Lubbock, TX                       1847.76  491386.54
116 Harrisburg, PA                    1786.27  493172.82
7 Amarillo, TX                      1758.66  494931.47
223 Rochester, NY                     1760.64  496692.12
68 Corpus Christi, TX                1730.17  498422.29
279 Timmins, ON                       1812.36  500234.65
238 San Antonio, TX                   1774.49  502009.14
185 North Bay, ON                     1763.41  503772.55
1 Abilene, TX                       1701.18  505473.73
197 Peterborough, ON                  1685.89  507159.62
16 Austin, TX                         1650.4  508810.02
269 Sudbury, ON                       1627.33  510437.35
121 Houston, TX                       1539.52  511976.87
41 Buffalo, NY                       1455.86  513432.73
77 Dodge City, KS                    1503.01  514935.73
294 Washington, DC                    1589.78  516525.51
200 Pierre, SD                        1654.69   518180.2
52 Charleston, SC                    1622.39  519802.59
305 Winnipeg, MB                      1683.01  521485.61
127 Jacksonville, FL                  1729.19   523214.8
92 Fargo, ND                          1549.3   524764.1
220 Richmond, VA                       1482.8  526246.89
292 Waco, TX                          1422.07  527668.96
282 Toronto, ON                       1483.47  529152.43
103 Galveston, TX                     1453.39  530605.82
182 Niagara Falls, ON                 1446.61  532052.43
97 Ft Worth, TX                      1451.32  533503.75
227 Saint Catherines, ON               1447.6  534951.35
69 Dallas, TX                        1414.51  536365.85
42 Burlington, ONT                   1383.45   537749.3
23 Beaumont, TX                      1349.56  539098.86
111 Guelph, ON                        1333.91  540432.77
204 Port Arthur, TX                   1334.48  541767.25
115 Hamilton, ON                      1332.86  543100.11
188 Oklahoma City, OK                 1326.53  544426.64
138 Kitchener, ON                     1306.17  545732.81
85 Enid, OK                          1303.54  547036.35
215 Raleigh, NC                       1330.04  548366.39
258 Sioux Falls, SD                   1358.74  549725.13
250 Savannah, GA                      1337.75  551062.88
228 Saint Cloud, MN                   1296.84  552359.72
274 Tallahassee, FL                   1248.21  553607.93
278 Thunder Bay, ON                   1287.21  554895.14
180 New Orleans, LA                   1273.63  556168.77
249 Sault Ste Marie, ON               1205.19  557373.95
20 Baton Rouge, LA                   1199.28  558573.23
37 Brantford, ON                     1151.44  559724.67
300 Wichita, KS                       1232.93   560957.6
80 Durham, NC                         1279.4  562237.01
236 Salina, KS                         1307.8  563544.81
109 Greensboro, NC                    1245.96  564790.77
257 Sioux City, IA                    1230.47  566021.24
64 Columbia, SC                      1213.26   567234.5
150 Lincoln, NE                       1177.83  568412.33
221 Roanoke, VA                       1181.08  569593.41
189 Omaha, NE                         1139.08  570732.49
306 Winston-Salem, NC                 1141.42  571873.91
79 Duluth, MN                        1103.04  572976.95
195 Pensacola, FL                     1179.96  574156.91
270 Superior, WI                      1175.77  575332.68
14 Augusta, GA                       1152.38  576485.06
166 Minneapolis, MN                    1113.9  577598.96
54 Charlotte, NC                     1091.15  578690.11
233 Saint Paul, MN                    1080.39   579770.5
157 Macon, GA                         1061.49  580831.99
81 Eau Claire, WI                     989.72  581821.71
28 Biloxi, MS                        1012.28  582833.99
152 London, ON                        1016.65  583850.64
160 Marshall, TX                      1158.56  585009.19
86 Erie, PA                          1188.43  586197.63
287 Tulsa, OK                          1174.1  587371.73
201 Pittsburgh, PA                    1144.29  588516.02
256 Shreveport, LA                    1096.48   589612.5
310 Youngstown, OH                    1081.83  590694.33
277 Texarkana, TX                     1066.85  591761.18
267 Steubenville, OH                  1043.65  592804.83
281 Topeka, KS                        1043.45  593848.28
297 Wheeling, WV                      1035.82   594884.1
95 Ft Smith, AR                       998.79  595882.89
47 Canton, OH                         974.26  596857.16
130 Joplin, MO                         943.13  597800.28
2 Akron, OH                          939.34  598739.63
176 Natchez, MS                        948.25  599687.88
22 Bay City, MI                       980.29  600668.17
112 Gulfport, MS                       982.13   601650.3
108 Green Bay, WI                      980.65  602630.95
168 Mobile, AL                         955.25   603586.2
222 Rochester, MN                      970.35  604556.55
260 Spartanburg, NC                    960.77  605517.32
231 Saint Joseph, MO                   952.41  606469.73
110 Greenville, SC                     925.02  607394.74
75 Des Moines, IA                     904.35   608299.1
10 Asheville, NC                      869.08  609168.17
133 Kansas City, KS                     868.8  610036.97
61 Cleveland, OH                      908.59  610945.56
134 Kansas City, MO                    905.45  611851.01
53 Charleston, WV                     895.98  612746.99
264 Springfield, MO                    809.82  613556.82
312 Zanesville, OH                     802.13  614358.95
151 Little Rock, AR                    795.57  615154.52
226 Saginaw, MI                        831.32  615985.85
126 Jackson, MS                         880.9  616866.74
94 Flint, MI                          865.78  617732.52
170 Montgomery, AL                     757.41  618489.93
295 Waterloo, IA                       814.78  619304.71
65 Columbus, GA                       859.51  620164.22
49 Cedar Rapids, IA                   804.18   620968.4
12 Atlanta, GA                        759.63  621728.03
78 Dubuque, IA                        744.13  622472.16
30 Birmingham, AL                     675.42  623147.57
253 Sheboygan, WI                      709.66  623857.24
100 Gadsden, AL                        683.03  624540.27
158 Madison, WI                        668.43   625208.7
56 Chattanooga, TN                    622.55  625831.25
124 Iowa City, IA                      627.43  626458.68
139 Knoxville, TN                      656.94  627115.61
63 Columbia, MO                       616.95  627732.56
304 Windsor, ON                         687.3  628419.86
162 Memphis, TN                        694.56  629114.42
76 Detroit, MI                        693.11  629807.53
122 Huntsville, AL                     579.38  630386.91
165 Milwaukee, WI                      581.29   630968.2
11 Ashland, KY                        481.46  631449.67
232 Saint Louis, MO                    522.45  631972.12
9 Ann Arbor, MI                      513.15  632485.27
192 Paducah, KY                        491.81  632977.08
142 Lansing, MI                        480.06  633457.13
175 Nashville, TN                      479.16  633936.29
106 Grand Rapids, MI                   475.97  634412.26
35 Bowling Green, KY                  416.17  634828.44
224 Rockford, IL                       408.25  635236.69
66 Columbus, OH                       450.37  635687.06
262 Springfield, IL                    459.25  636146.31
280 Toledo, OH                         439.91  636586.22
196 Peoria, IL                         422.25  637008.47
265 Springfield, OH                    402.89  637411.36
32 Bloomington, IL                    360.32  637771.68
147 Lexington, KY                      356.49  638128.18
214 Racine, WI                         399.12   638527.3
154 Louisville, KY                     339.14  638866.44
135 Kenosha, WI                         331.4  639197.84
60 Cincinnati, OH                     331.61  639529.45
73 Decatur, IL                        314.29  639843.75
125 Jackson, MI                        355.83  640199.57
89 Evansville, IN                     366.87  640566.45
21 Battle Creek, MI                   342.27  640908.71
51 Champaign, IL                       260.8  641169.51
149 Lima, OH                           289.17  641458.69
288 Urbana, IL                         286.77  641745.46
71 Dayton, OH                         278.52  642023.98
58 Chicago, IL                        279.24  642303.22
114 Hamilton, OH                       272.42  642575.65
104 Gary, IN                           244.97  642820.61
174 Muncie, IN                         166.43  642987.04
276 Terre Haute, IN                    148.82  643135.86
132 Kalamazoo, MI                      232.44  643368.29
123 Indianapolis, IN                   178.76  643547.05
259 South Bend, IN                     132.47  643679.52
140 Lafayette, IN                       97.61  643777.13
96 Ft Wayne, IN                       130.36  643907.49
183 Nome, AK                          5777.13  649684.62
5 -> 148              1  650614.77          5 Alert, NT
148 Lihue, HI                         7905.76    7905.76
230 Saint John's, NF                  7576.95   15482.71
183 Nome, AK                          7870.89   23353.61
271 Syndey, NS                        7389.33   30742.93
120 Honolulu, HI                      6973.04   37715.97
55 Charlottetown, PE                 6769.69   44485.66
119 Hilo, HI                          6665.33   51150.99
113 Halifax, NS                       6613.34   57764.33
8 Anchorage, AK                     6075.13   63839.46
243 San Juan, PR                       6499.8   70339.26
90 Fairbanks, AK                     6485.59   76824.85
169 Moncton, NB                        5881.4   82706.26
70 Dawson, YT                        5290.95   87997.21
229 Saint John, NB                    5223.21   93220.42
298 Whitehorse, YK                    4896.82   98117.25
98 Fredericton, NB                   4845.34  102962.58
131 Juneau, AK                        4768.78  107731.36
19 Bangor, ME                        4630.48  112361.84
209 Prince Rupert, BC                 4310.99  116672.83
15 Augusta, ME                       4247.95  120920.78
88 Eureka, CA                         3765.4  124686.18
205 Portland, ME                      3729.96  128416.14
291 Victoria, BC                      3689.93  132106.07
207 Portsmouth, NH                     3659.1  135765.18
290 Vancouver, BC                     3646.55  139411.72
40 Brockton, MA                      3637.58  143049.31
235 Salem, OR                         3599.44  146648.74
34 Boston, MA                        3595.59  150244.33
87 Eugene, OR                        3596.62  153840.95
46 Cambridge, MA                     3593.43  157434.38
25 Bellingham, WA                    3577.51  161011.89
91 Fall River, MA                    3580.15  164592.04
206 Portland, OR                      3569.55  168161.59
145 Lawrence, MA                      3564.53  171726.12
241 San Francisco, CA                 3557.84  175283.96
213 Quebec City, QC                      3607  178890.96
186 Oakland, CA                       3596.53  182487.49
155 Lowell, MA                        3536.42  186023.91
273 Tacoma, WA                           3547  189570.91
210 Providence, RI                    3545.83  193116.74
252 Seattle, WA                        3540.8  196657.53
159 Manchester, NH                    3529.69  200187.22
26 Berkeley, CA                      3528.99  203716.21
254 Sherbrooke, QC                    3533.82  207250.03
245 Santa Cruz, CA                    3527.03  210777.06
67 Concord, NH                       3515.24   214292.3
242 San Jose, CA                      3502.92  217795.22
307 Worcester, MA                     3477.76  221272.98
225 Sacramento, CA                    3442.81  224715.79
284 Trois-Rivieres, QC                 3415.3  228131.09
268 Stockton, CA                      3408.48  231539.57
171 Montpelier, VT                    3393.96  234933.53
244 Santa Barbara, CA                  3326.1  238259.63
38 Brattleboro, VT                   3308.76  241568.39
308 Yakima, WA                           3323   244891.4
263 Springfield, MA                   3325.25  248216.65
99 Fresno, CA                        3280.93  251497.58
117 Hartford, CT                      3271.83  254769.41
219 Reno, NV                          3259.94  258029.35
178 New Britain,CT                     3253.1  261282.44
48 Carson City, NV                   3251.14  264533.58
163 Meriden, CT                        3248.8  267782.39
17 Bakersfield, CA                   3221.22  271003.61
43 Burlington, VT                    3226.83  274230.43
153 Los Angeles, CA                   3193.66   277424.1
179 New Haven, CT                      3170.9  280594.99
309 Yellowknife, NT                   3219.25  283814.25
164 Miami, FL                         3467.82  287282.06
82 Edmonton, AB                      2998.65  290280.72
136 Key West, FL                      2971.34  293252.06
261 Spokane, WA                       2934.85  296186.91
50 Central Islip, NY                 3092.23  299279.15
293 Walla Walla, WA                   3140.18  302419.32
39 Bridgeport, CT                    3137.06  305556.38
193 Pasadena, CA                      3142.69  308699.07
172 Montreal, QC                      3157.19  311856.26
240 San Diego, CA                     3118.23  314974.49
202 Pittsfield, MA                     3107.7  318082.19
239 San Bernardino, CA                3097.28  321179.47
285 Troy, NY                          3070.66  324250.12
33 Boise, ID                         2937.92  327188.04
266 Stamford, CT                      2952.96     330141
311 Yuma, AZ                           2896.3   333037.3
3 Albany, NY                        2905.84  335943.14
144 Las Vegas, NV                     2893.98  338837.12
251 Schenectady, NY                   2883.23  341720.35
45 Calgary, AB                       2828.13  344548.48
296 West Palm Beach, FL               2889.69  347438.17
146 Lethbridge, AB                    2761.59  350199.76
299 White Plains, NY                  2761.87  352961.63
44 Butte, MT                         2700.79  355662.42
181 New York, NY                      2687.05  358349.48
199 Phoenix, AZ                       2677.74  361027.22
128 Jersey City, NJ                   2673.06  363700.28
203 Pocatello, ID                      2655.1  366355.39
177 Newark, NJ                        2648.53  369003.92
118 Helena, MT                        2647.25  371651.17
13 Atlantic City, NJ                 2646.38  374297.55
161 Medicine Hat, AB                  2613.82  376911.37
83 Elizabeth, NJ                     2604.16  379515.53
93 Flagstaff, AZ                     2614.32  382129.85
194 Paterson, NJ                      2619.56  384749.41
187 Ogden, UT                         2611.96  387361.37
283 Trenton, NJ                       2573.35  389934.72
107 Great Falls, MT                   2575.55  392510.27
198 Philadelphia, PA                  2550.72  395060.99
237 Salt Lake City, UT                2538.22  397599.21
289 Utica, NY                         2538.01  400137.22
286 Tucson, AZ                        2578.23  402715.44
191 Ottawa, ON                        2575.89  405291.33
211 Provo, UT                          2487.2  407778.53
6 Allentown, PA                     2499.13  410277.67
102 Gallup, NM                        2324.19  412601.86
29 Binghamtom, NY                    2312.96  414914.82
27 Billings, MT                       2265.6  417180.42
302 Wilmington, DE                    2314.81  419495.23
248 Saskatoon, SK                     2317.41  421812.65
247 Sarasota, FL                      2394.44  424207.09
59 Churchill, MB                     2311.24  426518.32
234 Saint Petersburg, FL              2279.52  428797.84
173 Moose Jaw, SK                     2220.06   431017.9
190 Orlando, FL                       2249.04  433266.94
218 Regina, SK                        2208.47  435475.41
72 Daytona Beach, FL                 2195.17  437670.58
255 Sheridan, WY                      2090.58  439761.16
184 Norfolk, VA                       2189.22  441950.37
105 Grand Junction, CO                2234.59  444184.96
301 Wilkes-Barre, PA                  2262.27  446447.23
84 El Paso, TX                       2213.93  448661.17
137 Kingston, ON                      2237.67  450898.84
4 Albuquerque, NM                    2170.5  453069.33
272 Syracuse, NY                      2178.26  455247.59
246 Santa Fe, NM                      2120.23  457367.82
217 Reading, PA                       2098.29  459466.11
74 Denver, CO                        2008.13  461474.24
208 Portsmouth, VA                    1992.18  463466.42
57 Cheyenne, WY                      1993.01  465459.43
141 Lancaster, PA                     1971.66  467431.09
62 Colorado Springs, CO              1972.03  469403.12
129 Johnstown, PA                     1972.05  471375.16
212 Pueblo, CO                        1959.85  473335.01
18 Baltimore, MD                     1935.73  475270.74
216 Rapid City, SD                    1868.74  477139.48
303 Wilmington, NC                    1875.13  479014.61
167 Minot, ND                         1881.45  480896.06
275 Tampa, FL                         1912.76  482808.82
36 Brandon, MB                       1940.02  484748.84
101 Gainesville, FL                   1855.41  486604.25
31 Bismarck, ND                      1741.25  488345.51
127 Jacksonville, FL                  1744.35  490089.86
305 Winnipeg, MB                      1729.19  491819.04
52 Charleston, SC                    1683.01  493502.06
200 Pierre, SD                        1622.39  495124.45
294 Washington, DC                    1654.69  496779.14
156 Lubbock, TX                       1753.74  498532.87
24 Belleville, ON                    1847.76  500380.63
143 Laredo, TX                        1918.78  502299.41
279 Timmins, ON                       1920.31  504219.72
68 Corpus Christi, TX                1812.36  506032.08
185 North Bay, ON                      1786.7  507818.78
238 San Antonio, TX                   1763.41  509582.19
223 Rochester, NY                     1726.57  511308.76
7 Amarillo, TX                      1760.64   513069.4
116 Harrisburg, PA                    1758.66  514828.06
1 Abilene, TX                       1668.54   516496.6
197 Peterborough, ON                  1685.89  518182.49
16 Austin, TX                         1650.4  519832.89
269 Sudbury, ON                       1627.33  521460.22
121 Houston, TX                       1539.52  522999.73
41 Buffalo, NY                       1455.86   524455.6
77 Dodge City, KS                    1503.01   525958.6
220 Richmond, VA                      1558.59  527517.19
92 Fargo, ND                          1482.8  528999.99
250 Savannah, GA                      1489.99  530489.98
258 Sioux Falls, SD                   1337.75  531827.74
215 Raleigh, NC                       1358.74  533186.48
85 Enid, OK                          1330.04  534516.52
182 Niagara Falls, ON                 1380.26  535896.78
292 Waco, TX                          1483.03  537379.81
282 Toronto, ON                       1483.47  538863.29
97 Ft Worth, TX                       1449.6  540312.89
227 Saint Catherines, ON               1447.6  541760.49
103 Galveston, TX                     1444.61  543205.09
42 Burlington, ONT                   1421.73  544626.82
69 Dallas, TX                        1383.45  546010.27
115 Hamilton, ON                      1368.85  547379.12
23 Beaumont, TX                      1332.75  548711.87
111 Guelph, ON                        1333.91  550045.78
204 Port Arthur, TX                   1334.48  551380.26
138 Kitchener, ON                     1324.27  552704.53
188 Oklahoma City, OK                 1306.17   554010.7
37 Brantford, ON                     1299.42  555310.11
300 Wichita, KS                       1232.93  556543.05
80 Durham, NC                         1279.4  557822.45
236 Salina, KS                         1307.8  559130.25
109 Greensboro, NC                    1245.96  560376.22
257 Sioux City, IA                    1230.47  561606.68
64 Columbia, SC                      1213.26  562819.94
228 Saint Cloud, MN                   1208.61  564028.55
274 Tallahassee, FL                   1248.21  565276.76
278 Thunder Bay, ON                   1287.21  566563.97
180 New Orleans, LA                   1273.63   567837.6
249 Sault Ste Marie, ON               1205.19  569042.78
20 Baton Rouge, LA                   1199.28  570242.06
79 Duluth, MN                        1130.44  571372.51
195 Pensacola, FL                     1179.96  572552.47
270 Superior, WI                      1175.77  573728.24
14 Augusta, GA                       1152.38  574880.62
150 Lincoln, NE                       1134.43  576015.05
221 Roanoke, VA                       1181.08  577196.13
189 Omaha, NE                         1139.08  578335.21
306 Winston-Salem, NC                 1141.42  579476.63
166 Minneapolis, MN                   1088.91  580565.53
54 Charlotte, NC                     1091.15  581656.69
233 Saint Paul, MN                    1080.39  582737.08
157 Macon, GA                         1061.49  583798.57
81 Eau Claire, WI                     989.72  584788.28
28 Biloxi, MS                        1012.28  585800.56
152 London, ON                        1016.65  586817.21
160 Marshall, TX                      1158.56  587975.77
86 Erie, PA                          1188.43   589164.2
287 Tulsa, OK                          1174.1   590338.3
201 Pittsburgh, PA                    1144.29  591482.59
256 Shreveport, LA                    1096.48  592579.08
310 Youngstown, OH                    1081.83   593660.9
277 Texarkana, TX                     1066.85  594727.75
267 Steubenville, OH                  1043.65  595771.41
281 Topeka, KS                        1043.45  596814.86
297 Wheeling, WV                      1035.82  597850.68
95 Ft Smith, AR                       998.79  598849.47
61 Cleveland, OH                      974.07  599823.54
176 Natchez, MS                        959.96  600783.49
22 Bay City, MI                       980.29  601763.78
112 Gulfport, MS                       982.13  602745.92
108 Green Bay, WI                      980.65  603726.56
168 Mobile, AL                         955.25  604681.82
222 Rochester, MN                      970.35  605652.16
260 Spartanburg, NC                    960.77  606612.93
231 Saint Joseph, MO                   952.41  607565.34
47 Canton, OH                         933.28  608498.62
130 Joplin, MO                         943.13  609441.75
2 Akron, OH                          939.34  610381.09
133 Kansas City, KS                    915.85  611296.95
53 Charleston, WV                     899.41  612196.36
134 Kansas City, MO                    895.98  613092.34
110 Greenville, SC                     891.55  613983.89
75 Des Moines, IA                     904.35  614888.24
10 Asheville, NC                      869.08  615757.32
295 Waterloo, IA                       827.18   616584.5
65 Columbus, GA                       859.51  617444.01
253 Sheboygan, WI                      802.52  618246.52
126 Jackson, MS                         809.5  619056.02
226 Saginaw, MI                         880.9  619936.92
151 Little Rock, AR                    831.32  620768.24
304 Windsor, ON                        828.42  621596.66
264 Springfield, MO                    795.38  622392.04
312 Zanesville, OH                     802.13  623194.17
63 Columbia, MO                       716.36  623910.53
76 Detroit, MI                        682.93  624593.46
170 Montgomery, AL                      724.3  625317.77
158 Madison, WI                        770.17  626087.93
12 Atlanta, GA                        731.47  626819.41
49 Cedar Rapids, IA                   759.63  627579.04
100 Gadsden, AL                        675.88  628254.92
78 Dubuque, IA                        668.88   628923.8
30 Birmingham, AL                     675.42  629599.22
94 Flint, MI                          690.27  630289.49
162 Memphis, TN                        698.85  630988.33
142 Lansing, MI                           647  631635.33
122 Huntsville, AL                     570.44  632205.78
124 Iowa City, IA                      588.25  632794.02
139 Knoxville, TN                      656.94  633450.96
224 Rockford, IL                       563.81  634014.76
56 Chattanooga, TN                    563.58  634578.34
165 Milwaukee, WI                      580.71  635159.05
11 Ashland, KY                        481.46  635640.51
232 Saint Louis, MO                    522.45  636162.96
9 Ann Arbor, MI                      513.15  636676.12
192 Paducah, KY                        491.81  637167.92
125 Jackson, MI                        459.78   637627.7
175 Nashville, TN                      451.22  638078.92
106 Grand Rapids, MI                   475.97  638554.89
35 Bowling Green, KY                  416.17  638971.07
214 Racine, WI                         406.98  639378.05
147 Lexington, KY                      399.12  639777.17
196 Peoria, IL                         399.56  640176.73
66 Columbus, OH                       458.14  640634.87
262 Springfield, IL                    459.25  641094.13
280 Toledo, OH                         439.91  641534.03
73 Decatur, IL                        393.78  641927.82
265 Springfield, OH                    355.61  642283.42
32 Bloomington, IL                    360.32  642643.75
149 Lima, OH                           338.23  642981.98
89 Evansville, IN                     305.64  643287.62
21 Battle Creek, MI                   342.27  643629.89
154 Louisville, KY                     283.85  643913.74
135 Kenosha, WI                         331.4  644245.14
60 Cincinnati, OH                     331.61  644576.75
58 Chicago, IL                         288.4  644865.14
71 Dayton, OH                         279.24  645144.39
51 Champaign, IL                      281.04  645425.42
114 Hamilton, OH                       259.18   645684.6
288 Urbana, IL                         256.66  645941.26
132 Kalamazoo, MI                      235.55  646176.81
276 Terre Haute, IN                    232.44  646409.25
96 Ft Wayne, IN                        195.3  646604.55
104 Gary, IN                           156.52  646761.07
174 Muncie, IN                         166.43   646927.5
259 South Bend, IN                     118.99  647046.49
123 Indianapolis, IN                   132.47  647178.96
140 Lafayette, IN                       66.81  647245.77
5 Alert, NT                         3369.01  650614.77
2  650613.92          5 Alert, NT
148 Lihue, HI                         7905.76    7905.76
230 Saint John's, NF                  7576.95   15482.71
183 Nome, AK                          7870.89   23353.61
271 Syndey, NS                        7389.33   30742.93
120 Honolulu, HI                      6973.04   37715.97
55 Charlottetown, PE                 6769.69   44485.66
119 Hilo, HI                          6665.33   51150.99
113 Halifax, NS                       6613.34   57764.33
8 Anchorage, AK                     6075.13   63839.46
243 San Juan, PR                       6499.8   70339.26
90 Fairbanks, AK                     6485.59   76824.85
169 Moncton, NB                        5881.4   82706.26
70 Dawson, YT                        5290.95   87997.21
229 Saint John, NB                    5223.21   93220.42
298 Whitehorse, YK                    4896.82   98117.25
98 Fredericton, NB                   4845.34  102962.58
131 Juneau, AK                        4768.78  107731.36
19 Bangor, ME                        4630.48  112361.84
209 Prince Rupert, BC                 4310.99  116672.83
15 Augusta, ME                       4247.95  120920.78
88 Eureka, CA                         3765.4  124686.18
205 Portland, ME                      3729.96  128416.14
291 Victoria, BC                      3689.93  132106.07
207 Portsmouth, NH                     3659.1  135765.18
290 Vancouver, BC                     3646.55  139411.72
40 Brockton, MA                      3637.58  143049.31
235 Salem, OR                         3599.44  146648.74
34 Boston, MA                        3595.59  150244.33
87 Eugene, OR                        3596.62  153840.95
46 Cambridge, MA                     3593.43  157434.38
25 Bellingham, WA                    3577.51  161011.89
91 Fall River, MA                    3580.15  164592.04
206 Portland, OR                      3569.55  168161.59
145 Lawrence, MA                      3564.53  171726.12
241 San Francisco, CA                 3557.84  175283.96
213 Quebec City, QC                      3607  178890.96
186 Oakland, CA                       3596.53  182487.49
155 Lowell, MA                        3536.42  186023.91
273 Tacoma, WA                           3547  189570.91
210 Providence, RI                    3545.83  193116.74
252 Seattle, WA                        3540.8  196657.53
159 Manchester, NH                    3529.69  200187.22
26 Berkeley, CA                      3528.99  203716.21
254 Sherbrooke, QC                    3533.82  207250.03
245 Santa Cruz, CA                    3527.03  210777.06
67 Concord, NH                       3515.24   214292.3
242 San Jose, CA                      3502.92  217795.22
307 Worcester, MA                     3477.76  221272.98
225 Sacramento, CA                    3442.81  224715.79
284 Trois-Rivieres, QC                 3415.3  228131.09
268 Stockton, CA                      3408.48  231539.57
171 Montpelier, VT                    3393.96  234933.53
244 Santa Barbara, CA                  3326.1  238259.63
38 Brattleboro, VT                   3308.76  241568.39
308 Yakima, WA                           3323   244891.4
263 Springfield, MA                   3325.25  248216.65
99 Fresno, CA                        3280.93  251497.58
117 Hartford, CT                      3271.83  254769.41
219 Reno, NV                          3259.94  258029.35
178 New Britain,CT                     3253.1  261282.44
48 Carson City, NV                   3251.14  264533.58
163 Meriden, CT                        3248.8  267782.39
17 Bakersfield, CA                   3221.22  271003.61
43 Burlington, VT                    3226.83  274230.43
153 Los Angeles, CA                   3193.66   277424.1
179 New Haven, CT                      3170.9  280594.99
309 Yellowknife, NT                   3219.25  283814.25
164 Miami, FL                         3467.82  287282.06
82 Edmonton, AB                      2998.65  290280.72
136 Key West, FL                      2971.34  293252.06
261 Spokane, WA                       2934.85  296186.91
50 Central Islip, NY                 3092.23  299279.15
293 Walla Walla, WA                   3140.18  302419.32
39 Bridgeport, CT                    3137.06  305556.38
193 Pasadena, CA                      3142.69  308699.07
172 Montreal, QC                      3157.19  311856.26
240 San Diego, CA                     3118.23  314974.49
202 Pittsfield, MA                     3107.7  318082.19
239 San Bernardino, CA                3097.28  321179.47
285 Troy, NY                          3070.66  324250.12
33 Boise, ID                         2937.92  327188.04
266 Stamford, CT                      2952.96     330141
311 Yuma, AZ                           2896.3   333037.3
3 Albany, NY                        2905.84  335943.14
144 Las Vegas, NV                     2893.98  338837.12
251 Schenectady, NY                   2883.23  341720.35
45 Calgary, AB                       2828.13  344548.48
296 West Palm Beach, FL               2889.69  347438.17
146 Lethbridge, AB                    2761.59  350199.76
299 White Plains, NY                  2761.87  352961.63
44 Butte, MT                         2700.79  355662.42
181 New York, NY                      2687.05  358349.48
199 Phoenix, AZ                       2677.74  361027.22
128 Jersey City, NJ                   2673.06  363700.28
203 Pocatello, ID                      2655.1  366355.39
177 Newark, NJ                        2648.53  369003.92
118 Helena, MT                        2647.25  371651.17
13 Atlantic City, NJ                 2646.38  374297.55
161 Medicine Hat, AB                  2613.82  376911.37
83 Elizabeth, NJ                     2604.16  379515.53
93 Flagstaff, AZ                     2614.32  382129.85
194 Paterson, NJ                      2619.56  384749.41
187 Ogden, UT                         2611.96  387361.37
283 Trenton, NJ                       2573.35  389934.72
107 Great Falls, MT                   2575.55  392510.27
198 Philadelphia, PA                  2550.72  395060.99
237 Salt Lake City, UT                2538.22  397599.21
289 Utica, NY                         2538.01  400137.22
286 Tucson, AZ                        2578.23  402715.44
191 Ottawa, ON                        2575.89  405291.33
211 Provo, UT                          2487.2  407778.53
6 Allentown, PA                     2499.13  410277.67
102 Gallup, NM                        2324.19  412601.86
29 Binghamtom, NY                    2312.96  414914.82
27 Billings, MT                       2265.6  417180.42
302 Wilmington, DE                    2314.81  419495.23
248 Saskatoon, SK                     2317.41  421812.65
247 Sarasota, FL                      2394.44  424207.09
59 Churchill, MB                     2311.24  426518.32
234 Saint Petersburg, FL              2279.52  428797.84
173 Moose Jaw, SK                     2220.06   431017.9
190 Orlando, FL                       2249.04  433266.94
218 Regina, SK                        2208.47  435475.41
72 Daytona Beach, FL                 2195.17  437670.58
255 Sheridan, WY                      2090.58  439761.16
184 Norfolk, VA                       2189.22  441950.37
105 Grand Junction, CO                2234.59  444184.96
301 Wilkes-Barre, PA                  2262.27  446447.23
84 El Paso, TX                       2213.93  448661.17
137 Kingston, ON                      2237.67  450898.84
4 Albuquerque, NM                    2170.5  453069.33
272 Syracuse, NY                      2178.26  455247.59
246 Santa Fe, NM                      2120.23  457367.82
217 Reading, PA                       2098.29  459466.11
74 Denver, CO                        2008.13  461474.24
208 Portsmouth, VA                    1992.18  463466.42
57 Cheyenne, WY                      1993.01  465459.43
141 Lancaster, PA                     1971.66  467431.09
62 Colorado Springs, CO              1972.03  469403.12
129 Johnstown, PA                     1972.05  471375.16
212 Pueblo, CO                        1959.85  473335.01
18 Baltimore, MD                     1935.73  475270.74
216 Rapid City, SD                    1868.74  477139.48
303 Wilmington, NC                    1875.13  479014.61
167 Minot, ND                         1881.45  480896.06
275 Tampa, FL                         1912.76  482808.82
36 Brandon, MB                       1940.02  484748.84
101 Gainesville, FL                   1855.41  486604.25
31 Bismarck, ND                      1741.25  488345.51
127 Jacksonville, FL                  1744.35  490089.86
305 Winnipeg, MB                      1729.19  491819.04
52 Charleston, SC                    1683.01  493502.06
200 Pierre, SD                        1622.39  495124.45
294 Washington, DC                    1654.69  496779.14
156 Lubbock, TX                       1753.74  498532.87
24 Belleville, ON                    1847.76  500380.63
143 Laredo, TX                        1918.78  502299.41
279 Timmins, ON                       1920.31  504219.72
68 Corpus Christi, TX                1812.36  506032.08
185 North Bay, ON                      1786.7  507818.78
238 San Antonio, TX                   1763.41  509582.19
223 Rochester, NY                     1726.57  511308.76
7 Amarillo, TX                      1760.64   513069.4
116 Harrisburg, PA                    1758.66  514828.06
1 Abilene, TX                       1668.54   516496.6
197 Peterborough, ON                  1685.89  518182.49
16 Austin, TX                         1650.4  519832.89
269 Sudbury, ON                       1627.33  521460.22
121 Houston, TX                       1539.52  522999.73
41 Buffalo, NY                       1455.86   524455.6
77 Dodge City, KS                    1503.01   525958.6
220 Richmond, VA                      1558.59  527517.19
92 Fargo, ND                          1482.8  528999.99
250 Savannah, GA                      1489.99  530489.98
258 Sioux Falls, SD                   1337.75  531827.74
215 Raleigh, NC                       1358.74  533186.48
85 Enid, OK                          1330.04  534516.52
182 Niagara Falls, ON                 1380.26  535896.78
292 Waco, TX                          1483.03  537379.81
282 Toronto, ON                       1483.47  538863.29
97 Ft Worth, TX                       1449.6  540312.89
227 Saint Catherines, ON               1447.6  541760.49
103 Galveston, TX                     1444.61  543205.09
42 Burlington, ONT                   1421.73  544626.82
69 Dallas, TX                        1383.45  546010.27
115 Hamilton, ON                      1368.85  547379.12
23 Beaumont, TX                      1332.75  548711.87
111 Guelph, ON                        1333.91  550045.78
204 Port Arthur, TX                   1334.48  551380.26
138 Kitchener, ON                     1324.27  552704.53
188 Oklahoma City, OK                 1306.17   554010.7
37 Brantford, ON                     1299.42  555310.11
300 Wichita, KS                       1232.93  556543.05
80 Durham, NC                         1279.4  557822.45
236 Salina, KS                         1307.8  559130.25
109 Greensboro, NC                    1245.96  560376.22
257 Sioux City, IA                    1230.47  561606.68
64 Columbia, SC                      1213.26  562819.94
228 Saint Cloud, MN                   1208.61  564028.55
274 Tallahassee, FL                   1248.21  565276.76
278 Thunder Bay, ON                   1287.21  566563.97
180 New Orleans, LA                   1273.63   567837.6
249 Sault Ste Marie, ON               1205.19  569042.78
20 Baton Rouge, LA                   1199.28  570242.06
79 Duluth, MN                        1130.44  571372.51
195 Pensacola, FL                     1179.96  572552.47
270 Superior, WI                      1175.77  573728.24
14 Augusta, GA                       1152.38  574880.62
150 Lincoln, NE                       1134.43  576015.05
221 Roanoke, VA                       1181.08  577196.13
189 Omaha, NE                         1139.08  578335.21
306 Winston-Salem, NC                 1141.42  579476.63
166 Minneapolis, MN                   1088.91  580565.53
54 Charlotte, NC                     1091.15  581656.69
233 Saint Paul, MN                    1080.39  582737.08
157 Macon, GA                         1061.49  583798.57
81 Eau Claire, WI                     989.72  584788.28
28 Biloxi, MS                        1012.28  585800.56
152 London, ON                        1016.65  586817.21
160 Marshall, TX                      1158.56  587975.77
86 Erie, PA                          1188.43   589164.2
287 Tulsa, OK                          1174.1   590338.3
201 Pittsburgh, PA                    1144.29  591482.59
256 Shreveport, LA                    1096.48  592579.08
310 Youngstown, OH                    1081.83   593660.9
277 Texarkana, TX                     1066.85  594727.75
267 Steubenville, OH                  1043.65  595771.41
281 Topeka, KS                        1043.45  596814.86
297 Wheeling, WV                      1035.82  597850.68
95 Ft Smith, AR                       998.79  598849.47
61 Cleveland, OH                      974.07  599823.54
176 Natchez, MS                        959.96  600783.49
22 Bay City, MI                       980.29  601763.78
112 Gulfport, MS                       982.13  602745.92
108 Green Bay, WI                      980.65  603726.56
168 Mobile, AL                         955.25  604681.82
222 Rochester, MN                      970.35  605652.16
260 Spartanburg, NC                    960.77  606612.93
231 Saint Joseph, MO                   952.41  607565.34
47 Canton, OH                         933.28  608498.62
130 Joplin, MO                         943.13  609441.75
2 Akron, OH                          939.34  610381.09
133 Kansas City, KS                    915.85  611296.95
53 Charleston, WV                     899.41  612196.36
134 Kansas City, MO                    895.98  613092.34
110 Greenville, SC                     891.55  613983.89
75 Des Moines, IA                     904.35  614888.24
10 Asheville, NC                      869.08  615757.32
295 Waterloo, IA                       827.18   616584.5
65 Columbus, GA                       859.51  617444.01
253 Sheboygan, WI                      802.52  618246.52
126 Jackson, MS                         809.5  619056.02
226 Saginaw, MI                         880.9  619936.92
151 Little Rock, AR                    831.32  620768.24
304 Windsor, ON                        828.42  621596.66
264 Springfield, MO                    795.38  622392.04
312 Zanesville, OH                     802.13  623194.17
63 Columbia, MO                       716.36  623910.53
76 Detroit, MI                        682.93  624593.46
170 Montgomery, AL                      724.3  625317.77
158 Madison, WI                        770.17  626087.93
12 Atlanta, GA                        731.47  626819.41
49 Cedar Rapids, IA                   759.63  627579.04
100 Gadsden, AL                        675.88  628254.92
78 Dubuque, IA                        668.88   628923.8
30 Birmingham, AL                     675.42  629599.22
94 Flint, MI                          690.27  630289.49
162 Memphis, TN                        698.85  630988.33
142 Lansing, MI                           647  631635.33
122 Huntsville, AL                     570.44  632205.78
124 Iowa City, IA                      588.25  632794.02
139 Knoxville, TN                      656.94  633450.96
224 Rockford, IL                       563.81  634014.76
56 Chattanooga, TN                    563.58  634578.34
165 Milwaukee, WI                      580.71  635159.05
11 Ashland, KY                        481.46  635640.51
232 Saint Louis, MO                    522.45  636162.96
9 Ann Arbor, MI                      513.15  636676.12
192 Paducah, KY                        491.81  637167.92
125 Jackson, MI                        459.78   637627.7
175 Nashville, TN                      451.22  638078.92
106 Grand Rapids, MI                   475.97  638554.89
35 Bowling Green, KY                  416.17  638971.07
214 Racine, WI                         406.98  639378.05
147 Lexington, KY                      399.12  639777.17
196 Peoria, IL                         399.56  640176.73
66 Columbus, OH                       458.14  640634.87
262 Springfield, IL                    459.25  641094.13
280 Toledo, OH                         439.91  641534.03
73 Decatur, IL                        393.78  641927.82
265 Springfield, OH                    355.61  642283.42
32 Bloomington, IL                    360.32  642643.75
149 Lima, OH                           338.23  642981.98
89 Evansville, IN                     305.64  643287.62
21 Battle Creek, MI                   342.27  643629.89
154 Louisville, KY                     283.85  643913.74
135 Kenosha, WI                         331.4  644245.14
60 Cincinnati, OH                     331.61  644576.75
58 Chicago, IL                         288.4  644865.14
71 Dayton, OH                         279.24  645144.39
288 Urbana, IL                         278.52  645422.91
114 Hamilton, OH                       256.66  645679.57
51 Champaign, IL                      259.18  645938.75
132 Kalamazoo, MI                      237.21  646175.96
276 Terre Haute, IN                    232.44   646408.4
96 Ft Wayne, IN                        195.3   646603.7
104 Gary, IN                           156.52  646760.22
174 Muncie, IN                         166.43  646926.65
259 South Bend, IN                     118.99  647045.64
123 Indianapolis, IN                   132.47  647178.11
140 Lafayette, IN                       66.81  647244.92
5 Alert, NT                         3369.01  650613.92

1252 rows selected.

Elapsed: 00:01:24.28
```

Summary of Results

Here we list the best solutions found for each root leg, i.e. those with PATH_RNK = 1. We do not know what the optima are.

```Shortest Routes
===============
ROOT_LEG       TOT_DIST
------------ ----------
184 -> 208     55744.86
51 -> 288      56794.75

Longest Routes
==============
ROOT_LEG       TOT_DIST
------------ ----------
183 -> 230    649684.75
5 -> 148      650614.77
```

Execution Plan for Shortest Routes, USCA312

```----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                             | Name        | Starts | E-Rows | A-Rows |   A-Time   | Buffers | Reads  | Writes |  OMem |  1Mem | Used-Mem |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                                      |             |      1 |        |   1252 |00:01:24.88 |      10M|    113K|  10654 |       |       |          |
|   1 |  WINDOW SORT                                          |             |      1 |     10 |   1252 |00:01:24.88 |      10M|    113K|  10654 |   267K|   267K|  237K (0)|
|   2 |   NESTED LOOPS OUTER                                  |             |      1 |     10 |   1252 |00:01:24.88 |      10M|    113K|  10654 |       |       |          |
|   3 |    MERGE JOIN                                         |             |      1 |     10 |   1252 |00:01:24.87 |      10M|    113K|  10654 |       |       |          |
|   4 |     TABLE ACCESS BY INDEX ROWID                       | TOWNS       |      1 |      5 |    312 |00:00:00.01 |     205 |      0 |      0 |       |       |          |
|   5 |      INDEX FULL SCAN                                  | SYS_C008004 |      1 |      5 |    312 |00:00:00.01 |       1 |      0 |      0 |       |       |          |
|*  6 |     SORT JOIN                                         |             |    312 |     10 |   1252 |00:01:24.87 |      10M|    113K|  10654 |   133K|   133K|  118K (0)|
|   7 |      VIEW                                             |             |      1 |     10 |   1252 |00:01:24.86 |      10M|    113K|  10654 |       |       |          |
|   8 |       WINDOW SORT                                     |             |      1 |     10 |   1252 |00:01:24.86 |      10M|    113K|  10654 |  1895K|   658K| 1684K (0)|
|   9 |        MERGE JOIN CARTESIAN                           |             |      1 |     10 |   1252 |00:01:24.85 |      10M|    113K|  10654 |       |       |          |
|  10 |         VIEW                                          |             |      1 |      1 |    313 |00:00:00.01 |       1 |      0 |      0 |       |       |          |
|  11 |          CONNECT BY WITHOUT FILTERING                 |             |      1 |        |    313 |00:00:00.01 |       1 |      0 |      0 |       |       |          |
|  12 |           VIEW                                        |             |      1 |      1 |      1 |00:00:00.01 |       1 |      0 |      0 |       |       |          |
|  13 |            SORT AGGREGATE                             |             |      1 |      1 |      1 |00:00:00.01 |       1 |      0 |      0 |       |       |          |
|  14 |             INDEX FULL SCAN                           | SYS_C008004 |      1 |      5 |    312 |00:00:00.01 |       1 |      0 |      0 |       |       |          |
|  15 |         BUFFER SORT                                   |             |    313 |     10 |   1252 |00:01:24.85 |      10M|    113K|  10654 |  9216 |  9216 | 8192  (0)|
|* 16 |          VIEW                                         |             |      1 |     10 |      4 |00:01:24.85 |      10M|    113K|  10654 |       |       |          |
|* 17 |           WINDOW SORT PUSHED RANK                     |             |      1 |     10 |      4 |00:01:24.85 |      10M|    113K|  10654 |  9216 |  9216 | 8192  (0)|
|  18 |            NESTED LOOPS                               |             |      1 |        |      4 |00:00:34.80 |      10M|    113K|  10654 |       |       |          |
|  19 |             NESTED LOOPS                              |             |      1 |     10 |      4 |00:00:34.80 |      10M|    113K|  10654 |       |       |          |
|* 20 |              VIEW                                     |             |      1 |     12 |      4 |00:00:34.80 |      10M|    113K|  10654 |       |       |          |
|  21 |               UNION ALL (RECURSIVE WITH) BREADTH FIRST|             |      1 |        |    192K|00:00:04.53 |      10M|    113K|  10654 |       |       |          |
|* 22 |                VIEW                                   |             |      1 |     10 |      2 |00:00:00.10 |     693 |      1 |      0 |       |       |          |
|* 23 |                 WINDOW SORT PUSHED RANK               |             |      1 |     10 |      3 |00:00:00.10 |     693 |      1 |      0 |  2048 |  2048 | 2048  (0)|
|  24 |                  WINDOW BUFFER                        |             |      1 |     10 |  48516 |00:00:00.08 |     693 |      1 |      0 |  3100K|   779K| 2755K (0)|
|  25 |                   TABLE ACCESS BY INDEX ROWID         | DISTANCES   |      1 |     10 |  48516 |00:00:00.04 |     693 |      1 |      0 |       |       |          |
|* 26 |                    INDEX FULL SCAN                    | DISTANCE_PK |      1 |     10 |  48516 |00:00:00.02 |     212 |      0 |      0 |       |       |          |
|  27 |                WINDOW SORT                            |             |    311 |      2 |    192K|00:00:04.40 |    5664 |      1 |      0 |   619K|   472K|  550K (0)|
|  28 |                 NESTED LOOPS                          |             |    311 |        |    192K|00:00:05.39 |    5664 |      1 |      0 |       |       |          |
|  29 |                  NESTED LOOPS                         |             |    311 |      2 |    192K|00:00:05.08 |    2392 |      0 |      0 |       |       |          |
|  30 |                   RECURSIVE WITH PUMP                 |             |    311 |        |   1242 |00:00:00.01 |       0 |      0 |      0 |       |       |          |
|* 31 |                   INDEX RANGE SCAN                    | DISTANCE_PK |   1242 |      1 |    192K|00:00:06.49 |    2392 |      0 |      0 |       |       |          |
|  32 |                  TABLE ACCESS BY INDEX ROWID          | DISTANCES   |    192K|      1 |    192K|00:00:00.15 |    3272 |      1 |      0 |       |       |          |
|* 33 |              INDEX UNIQUE SCAN                        | DISTANCE_PK |      4 |      1 |      4 |00:00:00.01 |       6 |      0 |      0 |       |       |          |
|  34 |             TABLE ACCESS BY INDEX ROWID               | DISTANCES   |      4 |      1 |      4 |00:00:00.01 |       4 |      0 |      0 |       |       |          |
|  35 |    TABLE ACCESS BY INDEX ROWID                        | DISTANCES   |   1252 |      1 |   1248 |00:00:00.01 |    2498 |      0 |      0 |       |       |          |
|* 36 |     INDEX UNIQUE SCAN                                 | DISTANCE_PK |   1252 |      1 |   1248 |00:00:00.01 |    1250 |      0 |      0 |       |       |          |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

6 - access("TWN"."ID"="TOP"."TOWN_ID")
filter("TWN"."ID"="TOP"."TOWN_ID")
16 - filter("CIRCUITS"."PATH_RNK"<=:KEEP_NUM)
17 - filter(ROW_NUMBER() OVER ( PARTITION BY "R"."ROOT_LEG" ORDER BY :SIGN*("R"."TOT_PRICE"+"D"."DST"))<=:KEEP_NUM)
20 - filter(("R"."LEV"="R"."N_TOWNS" AND "R"."PATH_RNK"<=:KEEP_NUM))
22 - filter("D"."RNK_BY_DST"<=:KEEP_NUM_ROOT)
23 - filter(ROW_NUMBER() OVER ( ORDER BY :SIGN*"DST")<=:KEEP_NUM_ROOT) 26 - filter("B">"A")
31 - access("D"."A"="R"."NXT_ID")
filter("R"."PATH" NOT LIKE '%|'||LPAD(TO_CHAR("D"."B"),3,'0')||'%')
33 - access("D"."A"="R"."NXT_ID" AND "D"."B"="R"."ROOT")
36 - access("DST"."A"="TOP"."TOWN_ID_PRIOR" AND "DST"."B"="TOP"."TOWN_ID")
```

Notes

• In the closed version of TSP that we have considered here, the starting point does not essentially affect the set of possible solutions; however, it may affect the solutions actually obtained by an approximate algorithm; partitioning by a set of root legs is designed to improve the quality of solutions obtained
• I found that the query uses increasing amounts of temp tablespace as the keep values are increased for the larger problem; in my previous article, on a knapsack problem, I included a PL/SQL solution that had the flexibility to discard all but the best solutions as it went, thus keeping space usage to a minimum; it also had the flexibility of the conventional ‘branch and bound’ algorithms to retain the best solution values globally and close off paths that could not beat them. This is difficult to do in SQL, but against that, the SQL is much simpler

Conclusions

Following my earlier two articles on related subjects, we have again seen that the recursive capabilities of Oracle’s SQL from v11.2 can provide surprisingly simple approximate solutions to ‘hard’ combinatorial problems in reasonable execution times.

20 February 2016: Added attachment with the input data files, DDL and raw results:

TSP Files: input data files, DDL and raw results

The new (November 2017) GitHub project also includes scripts and will be easier to install: Brendan’s repo for interesting SQL