Project Statistics

[kjslaughter]

Curious to know what is the most-clinched highway by TM users?

I'm guessing DC 295, which has 116 clinches by 121 total drivers. 

(If we have another thread for these kinds of questions, please feel free move it there.)

I wanna say this is the best thread for it.

Of course, Jim or yakra will give us the updated stats in a few hours.   

LOL, sometimes I'm too fond of shell scripts for my own good. I wasted a bunch of time pulling ConnectedRoute data from the user logs, only to realize that unrelated routes would be counted together, e.g. all flavors of A1 (prta, mara, fraa, etc.) and that I should just query the DB instead.

This doesn't harm us for ConnectedRoutes though, as the top 10 aren't affected by this:
098   I-495 (Washington, DC)
099   I-290 (New York)
102   I-97
104   I-495 (Delaware)
108   I-270 (Maryland)
109   I-295 (Maryland - District of Columbia)
113   I-395 (Baltimore, MD)
114   I-695 (District of Columbia)
116   DC295
116   I-595 (Maryland)
116   I-68
126   I-270Spr (Ashleigh, MD)

So does everyone on site live near DC or it's just a very popular place to visit?

[jayhawkco]

Interesting that GA I-95 is on there.  All of the other top 10 segments are < 25 miles and GA I-95 is 114.18 miles.  Also not in the same area as most of the others.

[Markkos1992]

So does everyone on site live near DC or it's just a very popular place to visit?

I would argue that the answer is sort of both.  Many of us live in the Mid-Atlantic or Northeast.  The most highly attended road meets are in this area for a reason.

Interesting that GA I-95 is on there.  All of the other top 10 segments are < 25 miles and GA I-95 is 114.18 miles.  Also not in the same area as most of the others.

I would presume this is because most of us heading to Florida use I-95, and stopping in Georgia is not very beneficial beyond Savannah.  Georgia does have gas stations called "El Cheapo".   

[jayhawkco]

Another interesting question to ask is what segment of highway have the most users been on, i.e. I-95 in DE between exits 2 and 4.  I bet there is some location that beats out I-95/495 in DC.

[osu-lsu]

This doesn't harm us for ConnectedRoutes though, as the top 10 aren't affected by this:
098   I-495 (Washington, DC)
099   I-290 (New York)
102   I-97
104   I-495 (Delaware)
108   I-270 (Maryland)
109   I-295 (Maryland - District of Columbia)
113   I-395 (Baltimore, MD)
114   I-695 (District of Columbia)
116   DC295
116   I-595 (Maryland)
116   I-68
126   I-270Spr (Ashleigh, MD)

So does everyone on site live near DC or it's just a very popular place to visit?

Can't speak for others, but when I was a kid, my school district would send the 8th Graders on a multi-day field trip to Washington DC. There were fundraisers and parents would help foot the bill, teachers would accompany us as chaperones.
Thus my mileage around D.C.* was based on (attempting to) remembering the routing, and what was built, 30 (now 33) years ago.
* - not counting mileage I picked around Northern Virginia a year and a half ago

[Jim]

Another interesting question to ask is what segment of highway have the most users been on, i.e. I-95 in DE between exits 2 and 4.  I bet there is some location that beats out I-95/495 in DC.

One way to check this with a program is to use the traveled format graphs and see which has the most travelers.  But maybe more fun for those who want to search visually, load up mapview, switch to "Color by Traveler Count" and your legend at the lower left will show the highest number of travelers among the segments in the current view.

[jayhawkco]

Another interesting question to ask is what segment of highway have the most users been on, i.e. I-95 in DE between exits 2 and 4.  I bet there is some location that beats out I-95/495 in DC.

One way to check this with a program is to use the traveled format graphs and see which has the most travelers.  But maybe more fun for those who want to search visually, load up mapview, switch to "Color by Traveler Count" and your legend at the lower left will show the highest number of travelers among the segments in the current view.

Unless I'm missing another, DE I-95 between exits 4A and 5A has 177 travelers.  Haven't found more than that yet.

[yakra]

098   I-495 (Washington, DC)
099   I-290 (New York)
102   I-97
104   I-495 (Delaware)
108   I-270 (Maryland)
109   I-295 (Maryland - District of Columbia)
113   I-395 (Baltimore, MD)
114   I-695 (District of Columbia)
116   DC295
116   I-595 (Maryland)
116   I-68
126   I-270Spr (Ashleigh, MD)

So does everyone on site live near DC or it's just a very popular place to visit?

I would argue that the answer is sort of both.  Many of us live in the Mid-Atlantic or Northeast.  The most highly attended road meets are in this area for a reason.

Good-ol' eastern seaboard. The most users, the densest population in the US, densest freeway network, and probably by extension the most places people are likely to travel to. Surely the highest AADTs and VMTs. With DC as a pretty central location, and a destination in its own right.
Worth noting that all those ConnectedRoutes enter a region the I-95 corridor is in, with only I-68 not being entirely in I-95 regions.

Interesting that GA I-95 is on there.  All of the other top 10 segments are < 25 miles and GA I-95 is 114.18 miles.  Also not in the same area as most of the others.

Interesting fact about the mileage; that's quite an outlier.
The ones that surprised me a little were the I-24 entries.
Then there's IL I-41, farther away from the east coast but a pretty easy clinch at 1.05 mi. It's also part of I-94.

Another interesting question to ask is what segment of highway have the most users been on, i.e. I-95 in DE between exits 2 and 4.  I bet there is some location that beats out I-95/495 in DC.

This got some discussion in the past. I won't search for it (could even be earlier in this thread? Maybe?), not having a good search term, but I do remember the most-traveled segment was somewhere on DE I-95. My first guess was between the PA border and the I-495 split (maybe it was at some point in the past?), but nope. Your answer is pretty close...

One way to check this with a program is to use the traveled format graphs and see which has the most travelers.

Thought of doing this as a shell script before deciding to again just query the DB -- though not everyone has a DB to query.
So here's a shell script anyway just for fun:

Code: [Select]

max=0
v=`head -n 2 tm-master-traveled.tmg | tail -n 1 | cut -f1 -d' '`
e=`head -n 2 tm-master-traveled.tmg | tail -n 1 | cut -f2 -d' '`
n=0
for line in `tail -n +$(expr $v + 3) tm-master-traveled.tmg | tr ' ' '%'`; do
  echo -en "$n/$e\r"
  t=0
  code=`echo $line | cut -f4 -d%`
  for c in `echo $code | sed -r 's~(.)~\1 ~g'`; do
    case $c in
    1) t=`expr $t + 1`;;
    2) t=`expr $t + 1`;;
    3) t=`expr $t + 2`;;
    4) t=`expr $t + 1`;;
    5) t=`expr $t + 2`;;
    6) t=`expr $t + 2`;;
    7) t=`expr $t + 3`;;
    8) t=`expr $t + 1`;;
    9) t=`expr $t + 2`;;
    A) t=`expr $t + 2`;;
    B) t=`expr $t + 3`;;
    C) t=`expr $t + 2`;;
    D) t=`expr $t + 3`;;
    E) t=`expr $t + 3`;;
    F) t=`expr $t + 4`;;
    esac
  done
  if [ $max -le $t ]; then
    max=$t
    printf "$t: %s from %s to %s\n" \
      `echo $line | cut -f3 -d'%'` \
      `tail -n +$(expr $(echo $line | cut -f1 -d'%') + 3) tm-master-traveled.tmg | head -n 1 | cut -f1 -d' '` \
      `tail -n +$(expr $(echo $line | cut -f2 -d'%') + 3) tm-master-traveled.tmg | head -n 1 | cut -f1 -d' '`
  fi
  n=`expr $n + 1`
doneThis will take quite a long time to run.

But maybe more fun for those who want to search visually, load up mapview, switch to "Color by Traveler Count" and your legend at the lower left will show the highest number of travelers among the segments in the current view.

Ooh nice. I Color by Traveler Count pretty infrequently, and hadn't really paid attention to the legend. This is a good clue of what to look for.
Start in DC, enable "Always Update Visible Routes", scroll around up toward Philadelphia, ?, profit!
This will surely be more fun for the majority of people who aren't crazy into coding.

Unless I'm missing another, DE I-95 between exits 4A and 5A has 177 travelers.  Haven't found more than that yet.

Ding ding ding! We have a winner! The DB says DE I-95 4A 4B and DE I-95 4B 5A () are tied for 1^st place.

Can't speak for others, but when I was a kid, my school district would send the 8th Graders on a multi-day field trip to Washington DC. There were fundraisers and parents would help foot the bill, teachers would accompany us as chaperones.
Thus my mileage around D.C.* was based on (attempting to) remembering the routing, and what was built, 30 (now 33) years ago.

I'd also need to reconstruct travels from when I was a small child; I visited DC around age 2. I could probably get away with marking I-95 down to I-695. South of there, no idea if I was on 95 or 295 or what.

[Markkos1992]

The most traveled segment in PA seems to be the I-95/US 322 concurrency (PA I-95 3 4) with 155 travelers. 

I was thinking that it would be somewhere on I-81, but I-70 has segments that are much closer (153 with I-76 between 146 and 161 with the entire I-70/I-76 concurrency being between 149 and 153 travelers, and then 149 travelers on the I-70/I-79 concurrency in Washington).

In VA, I am getting VA I-95 130 133, but all of I-95 between I-295 and I-495 seems to stay consistently above 170 travelers.

[yakra]

The most traveled segment in all four Siena area graphs is the I-87/90 overlap, with 132 travlers.


PA & VA are tied for the most travelers in a region, at 243.

Code: [Select]

for g in *-region-traveled.tmg; do printf "%03i $g\n" `tail -n 1 $g | wc -w`; done | grep -v ^000 | sort

[formulanone]

It's funny that the most-travelled "state route" is DC 295, also not in a state.

Or are there any other Tier 3 route segments with more travelers?

[yakra]

State routes are Tier 4.

Code: [Select]

select count(cl.segmentId), cl.segmentId, s.root, w1.pointName, w2.pointName, r.systemName, h.tier from clinched as cl left join segments as s on s.segmentId = cl.segmentId left join routes as r on r.root = s.root left join systems as h on h.systemName = r.systemName left join waypoints as w1 on w1.pointId = s.waypoint1 left join waypoints as w2 on w2.pointId = s.waypoint2 where tier = 4 group by cl.segmentId order by count(cl.segmentId) asc;The most traveled Tier 4 segment is IL IL3 I-55(1A) I-55(1B), with 154 travelers.

Code: [Select]

select count(cl.route), cl.route, r.systemName, h.tier from clinchedRoutes as cl left join routes as r on r.root = cl.route left join systems as h on h.systemName = r.systemName where tier = 4 group by cl.route order by count(cl.route) asc;The most traveled Tier 4 route is CA1, with 177 travelers.

Code: [Select]

select count(cl.route), cl.route, r.systemName, h.tier from clinchedRoutes as cl left join routes as r on r.root = cl.route left join systems as h on h.systemName = r.systemName where tier = 4 and clinched = 1 group by cl.route order by count(cl.route) asc;The most clinched is, as we know, DC295 with 116 travelers.


Other fun ideas for stats:
mean & median # of travelers/clinchers for HighwaySegments, chopped Routes, and ConnectedRoutes, including & excluding those with 0 travelers.

[dave1693]

I'd also need to reconstruct travels from when I was a small child; I visited DC around age 2. I could probably get away with marking I-95 down to I-695. South of there, no idea if I was on 95 or 295 or what.

My first two visits to DC were in 1968 but the first of those was by train. The second, just after Christmas, was by car, which was my introduction to the Delaware Memorial Bridge, Baltimore Harbor Tunnel, and a very small chunk of the DC Beltway. I-95 didn't follow the NJ Turnpike all the way to Exit 6 as it does now, so we didn't tough it until we reached Delaware, picking it up at the modern I-95/295/495 interchange and taking it down to the north/east end of I-895 in Baltimore. I-95 in Maryland was not completed anywhere through or south of Baltimore until after the spring of 1972; we went by car to DC that spring, in part to see the pandas at the National Zoo, and the Baltimore-Washington Parkway was the only freeway connection open between 695 and 495. It was still marked with "Temporary I-95" signs then.

Pretty sure that I-95 was signed all the way from Templeton (south of Petersburg) to US 50 in DC (north end of the Capitol Hill Tunnel) by 1972, but my old maps are in storage so I can't doublecheck.

[yakra]

Would have been 1982-1983ish for me, before the Fort McHenry Tunnel opened.
We'd have surely stopped to visit relatives in Baltimore. Where though?
*does quick Google search*
*gets actual meaningful results*
In all likelihood, went around the north side of 695.

[dave1693]

Would have been 1982-1983ish for me, before the Fort McHenry Tunnel opened..

Yes, pre-Fort McHenry Tunnel. I-95 did exist inside 695 but don't know how close it got to the north/east end of the unbuilt tunnel then. 95 went as far as 395 on the south/west side. On occasion I would drive up 95 and 395, and around the Inner Harbor to the south end of the JFX, er, I-83. (For those that don't know, JFX is Baltimorese for the Jones Falls Expressway, which is I-83 inside 695 plus the tiny stub that connects to MD 25 just outside 695.)

South/west of 695, by 1982-83 I-95 was complete in Maryland and followed its current routing all the way to the DC line, and was complete in Virginia. The last segment in southern VA was finished in... I want to say 1979 but cannot verify off the top of my head.