New Travels and Stats Discussion

[yakra]

Or...
mysql> select traveler, count(trav.systemName), sum(TravMi) from
    -> ( select
    ->     traveler,
    ->     systemName,
    ->     sum(mileage) as TravMi
    ->   from clinchedSystemMileageByRegion
    ->   where systemName != 'usadc'
    ->   group by traveler, systemName
    -> ) as trav
    -> left join
    -> ( select
    ->     systemName,
    ->     sum(mileage) as fullMi
    ->   from systemMileageByRegion
    ->   where systemName != 'usadc'
    ->   group by systemName
    -> ) as whole
    -> on trav.systemName = whole.systemName
    -> where TravMi = fullMi
    -> group by traveler
    -> order by count(trav.systemName);
+-----------------+------------------------+--------------------+
| traveler        | count(trav.systemName) | sum(TravMi)        |
+-----------------+------------------------+--------------------+
| jeffm           |                      1 |    5153.7822265625 |
| eucitizen       |                      1 | 172.58987426757812 |
| cougar1989      |                      1 | 337.92071533203125 |
| deathtopumpkins |                      1 |  3318.619384765625 |
| dharwood        |                      1 |  11.58397102355957 |
| charliezeb      |                      1 | 1325.0406494140625 |
| paddy           |                      1 |  1.039400339126587 |
| synkdorbit      |                      1 |      6374.80859375 |
| ChrisZwolle     |                      1 | 1558.6917724609375 |
| iowahighways    |                      1 |    5153.7822265625 |
| master_son      |                      1 |        8695.671875 |
| cinx            |                      2 |  387.1887969970703 |
| froggie         |                      2 |  2753.053272485733 |
| drebbin37       |                      2 | 3266.3001098632812 |
| dougtone        |                      2 |  5306.368959933519 |
| vespertine      |                      2 | 20651.670057356358 |
| bogdymol        |                      2 |  492.9820251464844 |
| htm_duke        |                      2 |  5767.284851074219 |
| cl94            |                      2 |  12694.05473601818 |
| duke87          |                      4 |  7909.960144042969 |
| mapcat          |                      5 |  37710.59513670206 |
| oscar           |                      8 |  16711.11094391346 |
| michih          |                     16 | 23855.830348849297 |
+-----------------+------------------------+--------------------+
23 rows in set (0.16 sec)

[Jim]

I didn't realize we had a system (niram) that was just a single segment, making it an all or nothing.  Looks like only michih and paddy have traveled/clinched its single mile-long route.

[Eth]

Back from a week in Puerto Rico, where my first visit to the island netted 137 miles on 29 routes, including seven clinches: PR18, PR24, PR26, PR38, PR66, PR870, and by far my highest ever route number traveled, PR9938. I fell just short of a clinch of unsigned I-PR1 also, missing the last couple miles in Ponce. That's about 3.3% of the total active/preview mileage, good enough for 4th place in the region.

(As an aside, I find it deeply weird that distances are signed in km, but speed limits are still in MPH.)

[michih]

I've traveled 29 TM regions traveled in 2018: AUT, BEL, BIH, CHE, CZE, DEU-BB, DEU-BW, DEU-BE, DEU-BY, DEU-HE, DEU-MV, DEU-NW, DEU-NI, DEU-RP, DEU-SL, DEU-SN, DEU-ST, DEU-TH, ENG, FRA, HRV, IRL, ITA, LUX, NIR, SCT, SVN, SVK, WLS
And I've added more than 12,000 mi this year.

My progress since I've joined TM (CHM) 5 years ago:
End of 2013 mileage:   9,615 mi   
End of 2014 mileage:  16,818 mi ; + 7,203 mi
End of 2015 mileage:  19,169 mi ; + 2,351 mi
End of 2016 mileage:  36,983 mi ; +17,814 mi (~5,500mi added due to new deub system)
End of 2017 mileage:  58,190 mi ; +21,207 mi (~2,500mi added due to new deubyst, deubwl, deuhel, deunwl, deurpl, deusll systems)
End of 2018 mileage:  70,811 mi ; +12,621 mi (~400mi added due to new remaining deuxxl systems)

I've traveled 38 TM regions in 2019: ALB, AUT, BEL, BIH, BGR, CHE, CZE, DEU-BB, DEU-BW, DEU-BE, DEU-BY, DEU-HE, DEU-NW, DEU-NI, DEU-RP, DEU-SN, DEU-ST, DEU-TH, ENG, FRA-ARA, FRA-GES, FRA-HDF, FRA-IDF, FRA-NOR, FRA-PAC, GRC, HRV, HUN, ITA, LUX, MKD, MLT, MNE, NLD, POL, SVN, SRB, SVK

And I've added more than 13,000 mi this year:

End of 2019 mileage:  84,500 mi = +13,689 mi

[dave1693]

November and the first half of December travels ranged up and down the middle East Coast from NC to CT. 5 significant trips.

New clinches:
US 202 in NY (joining US 202 in DE, PA, and NJ), US6/202 Alternate (Garrison NY), NY 45, NY 303, NY 340, NY 403, NY 895, Northern St Pkwy in NY, NJ 29, PA 72, PA 230, PA 241, PA 433, PA 696, PA 743, PA 987, PA 997 Truck (Culbertson), PA AirportConnector (Middletown/Harrisburg), MD 25, MD 103, VA 20

New segments (of highways not clinched):
I-295 in NY, US 6 in NY, US 9 in NY, US 9W in NY, US 209 Business (Stroudsburg PA), US 15 in NC, US 15 in VA, US 58 Business (Clarksville VA), US 158 in NC, US 158 Business (Oxford NC), US 360 Business (Keysville VA), US 460 in VA, US 501 in NC, US 501 in VA, CT 9, CT 10, CT 30, CT 69, CT 71, CT 372, Willow Brook Connector (unsigned CT 571), NY 22, NY 35, NY 59, NY 112, NY 118, NY 347, NY 454, Cross Island Pkwy in NY, Sagtikos St Pkwy in NY, Taconic St Pkwy in NY, PA 32, PA 441, PA 611, PA 641, PA 946, MD 2, MD 139, MD 170, VA 6, VA 49, NC 49, NC 57, NC 96, NC 157, NC 751

My next update will be mostly cleanup, and I probably won't have much to add by way of new roads until January at the earliest. Hope everyone has safe travel during the winter solstice related holidays.

[mapcat]

I got 2 trips in this month. The first added mileage in NC, VA, DC, MD, & WV, and brought me up to 100% in DC (something I had been putting off while Beach Drive was being rebuilt). There were two main objectives for this three-day endeavor: setting up for the second trip by clinching all of US 17 north of SC and all VA US highways except US 1, and finally meeting the legendary Oscar Voss. Both were met, and Oscar turned out to be a fascinating fellow with a great personality. We had a great conversation over burgers in Reston. Ride on, GOAT!

The second, a six-day affair, took me a little further south, via TN and GA to FL, then back through SC, NC, and VA. This trip had three objectives: clinch US 1, US 17, and US 41. Two were met; failure to finish 41 came from my own carelessness/stupidity as I neglected to zoom in far enough during trip planning to notice that I was missing a tiny segment in High Springs surrounded by miles of driven highways in all directions. It would have been doable, adding about an hour to my routing if I had known about it, but as things worked out I'm left with a 3-block gap and a 99.99% for the route that will probably remain until the next time I get to Florida, which won't be anytime soon.

One reason it won't be anytime soon is that I cleared out all the US highways in the state east of Tallahassee, and since I don't have a strong interest in clinching the Florida State Roads set, I can't think of any significant TM-related reasons to be in the area. Mapkitten is supposed to perform at WDW the summer after next, so I might be able to convince the family to take a detour on the way there or back, but for the foreseeable future it's just going to sit there annoying me.

Nevertheless the positives of the trip greatly outweighed the negatives, as I got to experience nearly all of US1 in the state north of Homestead, visit a few colorful Miami neighborhoods, witness the absurd police presence surrounding Mar-a-Lago, get loads of new clinches, and increase my usaus mileage to 79% (and 150 total routes). My Sunpass balance covered all the tolls. My Airbnb hosts didn't murder me. And although it rained for much of the trip home, I managed to stay ahead of the flooding and rolled into my driveway just shy of 10:00.

Total new mileage: 2913 (out of around 6700 miles driven)
Total new clinches: 130 (90 of which were in VA and FL)
Rank in DC: from 19 up to 1(tie)

[yakra]

It rained? Oh you lucky devil...

[mapcat]

I like how michih posted his annual accomplishments below and would enjoy seeing more of that. Here's mine from last year:

My mileage increased in 32 regions: CA, CO, CT, DE, DC, FL, GA, KS, KY, ME, MD, MA, MO, NV, NB, NH, NJ, NM, NY, NC, OH, OK, PA, QC, RI, SC, TN, TX, UT, VT, VA, WV. The OH increase was .28 mi of newly-identified usaush that I had probably driven years ago, but wanted to confirm.

Total 2019 new mileage: 15,887.33 mi. Top 5 regions: PA, KY, ME, FL, NY (all >1000 new miles).
New clinches: 778. +201 in KY, +89 in PA, +77 in VA.
New interstates clinched: 4, which completed the signed interstates until I-5 Truck was added.
New US highways clinched: 13, including the two longest ones I've clinched to date (50 & 1).

Stats for previous years:

2018: +21,284.12 mi / +653 clinches
2017: +19,547.92 mi / +582
2016: +17,101.26 mi / +514
2015: +28,363.75 mi / +553
2014: +13,046.83 mi / +380
2013: +14,214.20 mi / +412 (I joined CHM in 2012)

It was a lot easier for me to add mileage when we were developing new North American systems every year!

[Eth]

Excluding corrections (typos in my .list file, fixes for point name changes, and in one case a point addition allowing me to mark a previously-covered route), I added mileage in the following regions:

GA: +22.39 mi, +1 route, +1 clinch (GA371)
WA (new region): +61.28 mi, +6 routes
TX (new region): +221.54 mi, +12 routes, +1 clinch (I-345)
OK (new region): +74.30 mi, +4 routes
PR (new region): +136.57 mi, +26 routes, +7 clinches (PR18, PR24, PR26, PR38, PR66, PR870, PR9938)

A total of 516 new miles, 49 new routes, and 9 clinches. So a pretty light year, but at least I got on the board in 4 new regions.

[dave1693]

Jumping on the year-end bandwagon...

My mileage increased in 9 regions in 2019: CT, NY, NJ, DE, PA, OH, WV, MD, NC.  That's pretty much the entire extent of territory I traveled in at all over the past year.  (My TM mileage increased in other regions, but those reflected entry of earlier travels, error corrections, and new highway systems.)

Total 2019 new mileage is something I can't easily calculate and don't have the brain to seriously try right now.
New clinches: 85, one in at least each of the 9 regions if I was reading correctly.
New interstates clinched: 1. Plus all of an X0 in one state.
New US highways clinched: None, though I did clinch a couple of "US X in YY" where YY is a particular state.

[US 89]

Let's see...in 2019, my mileage increased in UT, CO, WY, ID, NV, GA, AL, and FL. I clinched US 91 (only my third mainline US clinch ever) and also finished off the western I-86 and I-985.

[SSOWorld]

Year-end? How about I-90.  Also: I-94 and Washington I's

[froggie]

Had my first new mileage in 6 months, with a trip down to Boston and my in-laws last week.  Filled in several of my US 20 gaps (only one left) and clinched a number of routes, including MA 37, MA 49, MA 106, and MA 140.  I was thwarted in my attempt to clinch MA 30, though...a lengthy detour in North Grafton plus the Massachusetts propensity to station cops at EVERY work zone.

[Bickendan]

Finally, new clinchage!

I'm in India and I have 60 or so km of AH 1/NH 2 from Kolkata to Burdwan. As I'm not driving, I don't know how much more clinching I'll actually do (I suspect I'll get some more when we do the Taj Mahal excursion).

Both AH 1 and NH 2 are surprisingly well signed, though some access points involved cars turning around onto the opposing carriageway via the median u-turns or even 'drifting' into opposing traffic and exiting onto the far shoulder to access the businesses on the shoulder!

[mapmikey]

Just returned from a week at Cedar Key FL...

New clinches - FL 21, FL 320, FL 331, FL 345, GA 300 CONN
Picked up new mileage on FL 44 btw US 19 and US 41; US 41 from FL 44 to US 27 ALT; US 280 from Cordele to US 80; GA 30 from Cordele to its eastern end at GA 25 Port Wentworth