Routes with the most or fewest drivers

[bejacob]

I was looking at my travels in Kentucky the other day and noticed that I am the only driver who has traveled KY99 (total drivers: 1, total clinched: 1). It got me thinking about which routes have either the most drivers or those with the fewest number of drivers. It seems the information is kept in the db.

Is there an easy way to see which routes have the largest number of drivers or those that have the fewest (excluding any routes that have zero drivers)?

This is more of a curiosity than an actual need. I figure, you don't get to learn the answer unless you ask the question.

[si404]

I-76 in PA has 108 user http://tm.teresco.org/hb/index.php?u=si404&r=pa.i076 I believe this is the highest.
I-95 in MD has 107 http://tm.teresco.org/hb/index.php?u=si404&r=md.i095
NJTP has 100 http://tm.teresco.org/hb/index.php?u=si404&r=nj.njtpk and I've not found any more than these 3 that are in the 100 club in my 'educated guess' look.

[Jim]

I hope to add "heat maps" like CHM had.  Or maybe someone else will...

[Thing342]

Top 100 driven routes: (plus percent of users)

Code: [Select]

pa.i076,108,0.7347
pa.us030,108,0.7347
md.i095,107,0.7279
md.i495,105,0.7143
va.i095,104,0.7075
va.us017,102,0.6939
va.i495,101,0.6871
va.i081,101,0.6871
tn.i040,101,0.6871
va.i064,101,0.6871
pa.us322,101,0.6871
nj.njtpk,100,0.6803
il.i094,100,0.6803
de.i095,98,0.6667
il.i090,98,0.6667
nc.i040,97,0.6599
il.i055,96,0.6531
nj.i095,96,0.6531
pa.i070,96,0.6531
md.i070,96,0.6531
pa.i081,96,0.6531
md.us040,96,0.6531
fl.i004,95,0.6463
ny.i090,94,0.6395
nc.us070,94,0.6395
va.us011,93,0.6327
de.us202,93,0.6327
pa.us022,93,0.6327
tn.i075,93,0.6327
nc.us074,92,0.6259
fl.i095,92,0.6259
oh.i071,92,0.6259
va.i066,92,0.6259
pa.i095,90,0.6122
oh.i080,90,0.6122
va.us001,90,0.6122
oh.i090,90,0.6122
dc.us001,90,0.6122
oh.i075,89,0.6054
tn.i024,89,0.6054
il.i057,89,0.6054
nc.i085,88,0.5986
pa.i080,88,0.5986
tn.us025w,88,0.5986
dc.i395,88,0.5986
ga.i075,88,0.5986
md.us522,88,0.5986
in.i080,88,0.5986
in.i090,88,0.5986
ny.i087,87,0.5918
sc.i095,87,0.5918
sc.us017,87,0.5918
il.us051,87,0.5918
pa.i079,86,0.585
ga.i085,86,0.585
fl.i075,86,0.585
tn.us064,86,0.585
dc.us050,86,0.585
fl.us001,86,0.585
nj.i295,86,0.585
tn.i065,86,0.585
va.i077,85,0.5782
mo.us040,85,0.5782
il.i080,85,0.5782
md.i695,85,0.5782
mo.us071,85,0.5782
oh.i070,85,0.5782
de.us040,85,0.5782
ky.i075,84,0.5714
il.us041,84,0.5714
oh.i076,84,0.5714
in.i065,84,0.5714
nj.us040,84,0.5714
il.i074,83,0.5646
va.us052,83,0.5646
nc.us064,83,0.5646
il.i064,83,0.5646
oh.oh004,83,0.5646
va.us460,83,0.5646
ca.us101,83,0.5646
de.i295,83,0.5646
il.us040,83,0.5646
md.us050,82,0.5578
in.i070,82,0.5578
ma.us001,82,0.5578
ny.i190,82,0.5578
fl.us017,82,0.5578
va.us220,82,0.5578
ky.i064,82,0.5578
va.i395,82,0.5578
mo.i044,82,0.5578
co.us006,82,0.5578
il.il003,81,0.551
il.il110,81,0.551
nc.us029,81,0.551
mo.i055,81,0.551
sc.i026,81,0.551
nc.us064trkhen,81,0.551
il.us006,81,0.551
co.i070,81,0.551

Top 50 clinched route sections:

Code: [Select]

dc.i495 79 0.5374
dc.i095 79 0.5374
de.i295 78 0.5306
va.i395 73 0.4966
tn.i024cha 71 0.4830
ga.i095 67 0.4558
wv.i070 65 0.4422
de.i095 64 0.4354
dc.i395 62 0.4218
wv.i068 62 0.4218
md.i295 62 0.4218
il.i041 62 0.4218
dc.i295 62 0.4218
ga.i024 62 0.4218
md.i270sprash 61 0.4150
md.i095 60 0.4082
md.i068 60 0.4082
md.i595 60 0.4082
in.i090 60 0.4082
md.i081 60 0.4082
ma.i084 59 0.4014
wv.i081 59 0.4014
va.i077 58 0.3946
dc.dc295 58 0.3946
va.i495 58 0.3946
md.i395 58 0.3946
ny.i290 58 0.3946
md.i495 57 0.3878
md.i270 56 0.3810
nv.i011futhen 56 0.3810
nh.i095 56 0.3810
pa.i078 55 0.3741
nc.i095 55 0.3741
ct.i095 55 0.3741
in.i094 55 0.3741
dc.i066 54 0.3673
md.i097 54 0.3673
va.i095 54 0.3673
in.i080 53 0.3605
tn.i081 53 0.3605
pa.i090 52 0.3537
ri.i095 52 0.3537
ny.i078 52 0.3537
de.i495 52 0.3537
ms.i010 51 0.3469
dc.i695 51 0.3469
va.i085 51 0.3469
nj.i076 51 0.3469
sc.i085 51 0.3469
nj.i095sec 50 0.3401

And top 50 clinched entire routes:

Code: [Select]

md.i270sprash,61,0.4150
wv.i068,60,0.4082
md.i595,60,0.4082
md.i295,60,0.4082
va.i395,59,0.4014
md.i395,58,0.3946
dc.dc295,58,0.3946
ny.i290,58,0.3946
nv.i011futhen,56,0.3810
md.i270,56,0.3810
md.i097,54,0.3673
va.i495,52,0.3537
de.i495,52,0.3537
dc.i695,51,0.3469
nj.i095sec,50,0.3401
md.i195,47,0.3197
il.i190,47,0.3197
oh.i470,47,0.3197
pa.i283,47,0.3197
wi.i894,46,0.3129
md.i895,46,0.3129
pa.i279,46,0.3129
oh.i280,45,0.3061
pa.i276,45,0.3061
ga.i475,45,0.3061
sd.i190,45,0.3061
in.i865,44,0.2993
az.i011futkin,43,0.2925
nj.njtpk,43,0.2925
nc.i074,43,0.2925
tn.i640,43,0.2925
pa.i579,42,0.2857
il.i294,42,0.2857
nc.i074futpil,41,0.2789
in.i069futind,41,0.2789
nv.i215,41,0.2789
co.i225,40,0.2721
co.i270,40,0.2721
ia.i235,40,0.2721
nv.i515,38,0.2585
tx.i345,38,0.2585
fl.i004,38,0.2585
pa.i676,37,0.2517
ma.i290,37,0.2517
va.i066,37,0.2517
fl.i110,37,0.2517
il.i290,37,0.2517
la.i610,36,0.2449
ky.i471,36,0.2449
il.i024,36,0.2449


[mapcat]

Top 100 driven routes: (plus percent of users)

This is great. I'd love to see it, or something like it, on the main page. Thanks for posting.

[oscar]

As for fewest drivers, without diving into the database (have better things to do on Maui the next week and a half), you are going to have a lot of routes out west or in the Arctic with only one user (in Arctic North America, usually me) or zero users.

Might be more productive to focus on the better-used systems, such as Interstates or U.S. routes, for more meaningful "least traveled" stats.

[bejacob]

Great stuff everyone.

I realized as I was looking over the info on the most traveled routes, that there are likely many routes with just a single driver. I rarely see that in my own stats, though I do see many routes where I'm one of 2 or 3. Occasionally I'll see one where I'm the sole driver (KY99) or one I've clinched that only one or two others have driven at all (UT73). Given that I live in mapcat territory, it's almost certain that he's driven many of the same roads I have, at least within a reasonable distance from home (like everything in Ohio). 

Oscar is right, getting that detail for systems in tier 3, 4, or 5 is probably not particularly meaningful.

[Markkos1992]

One route that I had found odd that I am the only one to have clinched is PA 902 (goes from US 209 in Lansford to PA 443 near Lehighton via Summit Hill).  I guess it is just an afterthought to the other mentioned routes.

This will never be in the case for me in VA as long as mapmikey is around though.   

[mapmikey]

Act now and you can beat me to these segments that have changed since I finished Virginia in 2010:

VA 80 near Kentucky Line
US 460/VA 83 bypass at Grundy
VA 172 west of VA 134
VA 164 extension
US 17 bridge over Intercoastal  Waterway

I will be picking up these last 3 in April.

Already too late for anyone to beat me to:

VA 8 bypass at Stuart
VA 280
VA 281

 

[Markkos1992]

All of these (the top two via the Pikeville 2013 Meet as I believe VA 80 was already realigned then) have been clinched by me except for VA 8 (who knows if I will ever get to this one) and VA 280. I still consider the widened section of US 58 west of Meadows of Dan clinched as the alignment change was minor enough to be seen from its old route as it was under construction when I clinched it in 2014.

For the record, the stats still only show you as having clinched VA 80 and VA 83.  Others have already reclinched VA 172 (though that was an original clinch for me) and VA 164 (I remember thing342 posting pictures on AARoads) so I am still not alone on any total route clinches in VA.   


Mark AKA 74/171FAN

[Thing342]

Coming soon to a pull request near you: http://107.20.99.209:9999/overall_stats.php 

[rschen7754]

Interesting that they're virtually all on the East Coast, except for a stretch of future I-11 (!)

[michih]

Coming soon to a pull request near you: http://107.20.99.209:9999/overall_stats.php 

Cool

However, why do you limit it to 25? What's about a drop-down menu so that the user can select, e.g.  25 - 50 - 100 - 200 - 500 - 1000? Dunno if "all" would make sense (loading time etc.). For instance, I'd like to know which route is number one in Europe. Maybe even a region/system selection etc. one day?

btw: What's about table no. 4 "Most Driven Routes"?