Author Topic: New Travels and Stats Discussion  (Read 228313 times)

0 Members and 8 Guests are viewing this topic.

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4234
  • Last Login:February 13, 2024, 07:19:36 pm
  • I like C++
Re: New Travels and Stats Discussion
« Reply #375 on: December 12, 2019, 01:17:29 am »
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)
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2732
  • Last Login:Yesterday at 10:14:53 pm
Re: New Travels and Stats Discussion
« Reply #376 on: December 12, 2019, 07:13:56 am »
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.

Offline Eth

  • Jr. Member
  • **
  • Posts: 70
  • Last Login:March 26, 2024, 04:01:53 pm
Re: New Travels and Stats Discussion
« Reply #377 on: December 19, 2019, 08:34:04 am »
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.)

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4555
  • Last Login:Yesterday at 04:04:16 pm
Re: New Travels and Stats Discussion
« Reply #378 on: December 21, 2019, 12:24:04 pm »
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

Offline dave1693

  • Full Member
  • ***
  • Posts: 185
  • Last Login:November 21, 2023, 11:28:54 pm
Re: New Travels and Stats Discussion
« Reply #379 on: December 21, 2019, 05:35:10 pm »
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.

Offline mapcat

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1627
  • Last Login:March 26, 2024, 09:50:25 am
Re: New Travels and Stats Discussion
« Reply #380 on: December 30, 2019, 08:59:15 pm »
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)
« Last Edit: December 30, 2019, 09:02:39 pm by mapcat »
Clinched:

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4234
  • Last Login:February 13, 2024, 07:19:36 pm
  • I like C++
Re: New Travels and Stats Discussion
« Reply #381 on: January 01, 2020, 06:00:00 pm »
It rained? Oh you lucky devil... ;D
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca

Offline mapcat

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1627
  • Last Login:March 26, 2024, 09:50:25 am
Re: New Travels and Stats Discussion
« Reply #382 on: January 06, 2020, 06:57:11 pm »
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!
Clinched:

Offline Eth

  • Jr. Member
  • **
  • Posts: 70
  • Last Login:March 26, 2024, 04:01:53 pm
Re: New Travels and Stats Discussion
« Reply #383 on: January 06, 2020, 08:23:53 pm »
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.

Offline dave1693

  • Full Member
  • ***
  • Posts: 185
  • Last Login:November 21, 2023, 11:28:54 pm
Re: New Travels and Stats Discussion
« Reply #384 on: January 11, 2020, 08:10:22 pm »
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.

Offline US 89

  • Full Member
  • ***
  • Posts: 141
  • Last Login:March 15, 2024, 08:50:53 am
Re: New Travels and Stats Discussion
« Reply #385 on: January 14, 2020, 03:30:01 pm »
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.

Offline SSOWorld

  • Full Member
  • ***
  • Posts: 222
  • Last Login:Yesterday at 09:35:08 pm
Re: New Travels and Stats Discussion
« Reply #386 on: January 14, 2020, 08:46:08 pm »
Year-end? How about I-90.  Also: I-94 and Washington I's
Completed:
* Systems: DC, WI
* by US State: AR: I&; AZ: I; DE: I; DC: I, US, DC; IL: I; IN: I*; IA: I, KS: I; MD: I, MA: I, MI: I; MN: I; MO: I*; NE: I; NJ, I; OH: I; RI: I; SD: I; WA: I; WV: I; WI: I,US,WI; (AR, IN pending expansions.)

*Previously completed

Offline froggie

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 801
  • Last Login:Yesterday at 07:53:11 pm
Re: New Travels and Stats Discussion
« Reply #387 on: January 22, 2020, 10:05:19 am »
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.

Offline Bickendan

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 543
  • Last Login:March 26, 2024, 08:55:56 pm
Re: New Travels and Stats Discussion
« Reply #388 on: February 07, 2020, 04:41:43 am »
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!

Offline mapmikey

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1171
  • Last Login:Today at 06:18:24 am
    • Co-curator Virginia Highways Project
Re: New Travels and Stats Discussion
« Reply #389 on: February 10, 2020, 02:45:03 pm »
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