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

0 Members and 4 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 #360 on: November 07, 2019, 11:35:25 am »
I assume it to be the Region of DC Metro Centered Urban Sprawl. Splat.
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca

Offline oscar

  • TM Collaborator
  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1523
  • Last Login:Yesterday at 07:38:46 pm
    • Hot Springs and Highways pages
Re: New Travels and Stats Discussion
« Reply #361 on: November 08, 2019, 01:37:52 am »
As a resident in the Fedrosplat core, I think it's an appropriate term (certainly better than the unjustly popular "DMV" -- why give the region the same abbreviation as the hated Department of Motor Vehicles?). But I think it refers mainly to the broad geographic range of the D.C.-area Federal offices and employees (reaching to eastern WV, south central PA, and Baltimore for its Social Security complex) rather than the smaller area of D.C./suburbs urban sprawl.
« Last Edit: November 08, 2019, 01:40:48 am by oscar »

Offline Highway63

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 528
  • Gender: Female
  • Last Login:February 16, 2024, 01:40:37 am
Re: New Travels and Stats Discussion
« Reply #362 on: November 12, 2019, 07:04:14 pm »
It was almost all new miles for my car (TM user a3), which went from about 1650 TM miles to nearly 2600.  Since I'd never taken the car on a trip toward the west before, the trace of this trip is very evident from http://travelmapping.net/user/mapview.php?units=miles&u=a3&rg=NY,PA,OH,WV
You can show multiple states at once!? :o :o

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2727
  • Last Login:Yesterday at 10:00:41 pm
Re: New Travels and Stats Discussion
« Reply #363 on: November 12, 2019, 08:38:21 pm »
It was almost all new miles for my car (TM user a3), which went from about 1650 TM miles to nearly 2600.  Since I'd never taken the car on a trip toward the west before, the trace of this trip is very evident from http://travelmapping.net/user/mapview.php?units=miles&u=a3&rg=NY,PA,OH,WV
You can show multiple states at once!? :o :o

Just need to figure out a nice way to support it from the GUI.

Offline clong

  • Newbie
  • *
  • Posts: 39
  • Last Login:Yesterday at 02:22:21 pm
Re: New Travels and Stats Discussion
« Reply #364 on: November 13, 2019, 04:35:00 pm »
Recently had the opportunity to finish off I-40 in TN. I've had Memphis to Nashville since I was 12 or 13. Got the Nashville to Cookeville section last year. Got the Knoxville to NC section this Spring. Filled the gap from Cookeville to Knoxville last weekend.

Now to start working on the Asheville to Winston-Salem gap in NC.

Offline SSOWorld

  • Full Member
  • ***
  • Posts: 222
  • Last Login:March 17, 2024, 04:04:24 pm
Re: New Travels and Stats Discussion
« Reply #365 on: November 14, 2019, 06:40:53 pm »
It was almost all new miles for my car (TM user a3), which went from about 1650 TM miles to nearly 2600.  Since I'd never taken the car on a trip toward the west before, the trace of this trip is very evident from http://travelmapping.net/user/mapview.php?units=miles&u=a3&rg=NY,PA,OH,WV
You can show multiple states at once!? :o :o
Amazing what you can do with a command line
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 oscar

  • TM Collaborator
  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1523
  • Last Login:Yesterday at 07:38:46 pm
    • Hot Springs and Highways pages
Re: New Travels and Stats Discussion
« Reply #366 on: November 14, 2019, 08:44:17 pm »
Just got back from a three-week+ road trip, including two forays into Canada (one revisiting five provinces from Nova Scotia to Ontario, including Prince Edward island; the other revisiting Saskatchewan). These covered new alignments in the Trans-Canada Highway system (one each in PEI, Quebec, and Saskatchewan), bringing me back to 100% of that system until next time. In Saskatchewan, I also clinched the longest provincial route (SK 2, from the U.S. border to the northern community of La Ronge), and re-clinched the shorter but still major SK 11.

In the U.S., I added to my coverage of the U.S. routes systems (usaus and usausb), inching closer to 80%. I filled in several gaps in my coverage of U.S. 52 (my latest completion project), leaving only gaps in Iowa and North Carolina for future trips.

I had to deal with snow earlier in the year than I'm used to, starting with a few inches in Michigan's Upper Peninsula just after I re-entered the U.S. at Sault Ste. Marie, then in both stops in Saskatchewan and North Dakota. My stay in Moose Jaw was extended by a day since I was worried about the condition of SK 2 south to the border. Otherwise, the winter weather was unpleasant but manageable.

No significant border hassles. My vehicle got a light but brief search while I was in line (agent just popped open the trunk, and peeked in my cooler) at the low-traffic Opheim crossing on my second return to the U.S. at MT 24/SK 2. Nothing more than brief questioning on the other three border crossings on my trip (ME 161/NB 190, I-75, MT 16/SK 6).

My stops in Minnesota included visits to an elderly aunt, and a cousin and her daughter, in the Minneapolis area, and in Pope County MN to the only farm left in my family. My father was born on a family farm in northeastern South Dakota, and other relatives also had farms there, until they all got bought out.
« Last Edit: January 07, 2020, 02:56:30 am by oscar »

Offline mikeandkristie

  • Full Member
  • ***
  • Posts: 124
  • Last Login:March 16, 2024, 08:41:52 pm
Re: New Travels and Stats Discussion
« Reply #367 on: November 15, 2019, 12:03:36 am »
Last month, we spent two weeks on the Big Island of Hawaii for our 10th anniversary.  That's also where we honeymooned, but this time we didn't island hop.  The first time in three days there, we did the south part of the island, getting almost all of HI 11, tiny parts of HI 19 and HI 190 as we turned around a bit past Kona, and Hawaii Volcanoes NP and HI 130 down to see lava.  This time around, with two weeks to work with, we finished up the rest of the island and actually revisited all of the previous roads as well.  I was pretty meticulous to not miss anything.  That shot us up to 5th place in Hawaii.

Then, a couple of weekends ago, Kristie gave me free reign on a shopping trip over to Greensboro, NC to buy more turkey plates.  Normally, it is just over an hour on I-40.  I took the opportunity to fill in some new segments and get us over the hump from 49.97% to 50.42% in NC.  That puts us at only a few more permutations to go in between Raleigh and Greensboro between US 64 and US 158.
  • Clinched NC 902 by taking it out of Pittsboro to NC 22/42.
  • Then, once NC 22 and 42 split, we took the 22 leg this time up to US 64.
  • Stayed straight on US 64 past Asheboro to then get some NC 109 up to Thomasville connecting with an existing section.
  • A little more US29/70 and soon to be former I-85 Business to the NC 68 exit where we finished the rest of NC 68 through High Point.
  • The store and where we wanted to eat were both on Wendover Ave.  Took the proactive step to drive all of Wendover through Greensboro as I'd seen that had just gotten approved by the AASHTO as a reroute for US 70.  We'd just had bits and pieces before.
  • And finally, heading north and then east on NC 62 from US 70 in Burlington then switched to NC 49 over to NC 86.

Mike

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4554
  • Last Login:Yesterday at 02:35:49 pm
Re: New Travels and Stats Discussion
« Reply #368 on: November 15, 2019, 09:31:03 am »
I took the opportunity to fill in some new segments and get us over the hump from 49.97% to 50.42% in NC.

Your travel stats seem to be mike or kristie, not mike and kristie?

Offline mikeandkristie

  • Full Member
  • ***
  • Posts: 124
  • Last Login:March 16, 2024, 08:41:52 pm
Re: New Travels and Stats Discussion
« Reply #369 on: November 15, 2019, 11:25:00 pm »
I took the opportunity to fill in some new segments and get us over the hump from 49.97% to 50.42% in NC.

Your travel stats seem to be mike or kristie, not mike and kristie?

Well, our file is for our travels together.  I did consider also doing a Mike only file to cover either lifetime or at least I started driving, but trips that far back was just too unreliable in terms of exact routes.  I do however keep a Mike only counties map.  But, with regards to our travels, I'm the trip planner and mapgeek/roadgeek and I'm also the one that obsessively tracks out National Parks, counties, and all our road segments.  Kristie is in charge of "passengering" on trips.  I pour over maps and since I started doing our file on the site, I'm the one "scheming" to maximize our routes.  And Kristie tolerates her husband's hobby, like a lot of wives do.  :-)

And since I'm the one doing all of the site stuff, I do realize that I flip between I and we a lot and I don't always catch all of the inconsistencies.

Mike

Offline ntallyn

  • TM Collaborator
  • Sr. Member
  • *****
  • Posts: 326
  • Last Login:Yesterday at 10:16:50 pm
Re: New Travels and Stats Discussion
« Reply #370 on: November 16, 2019, 04:31:06 pm »
Several trips in the last couple of months to allowed me to get plenty of new miles.

A Labor Day weekend trip to Disney World, Daytona Beach, and Cape Canaveral got the fewest new miles: FL 405, FL 407, and US 1 around Titusville.

In early October, a business trip for my wife to Ohio with a side trip to visit some family near Fort Wayne, IN got some new routes: OH 119, IN 26, IN 116, IN 301, IN 124, OH 697, OH 117, OH 501, and US 33.

A late October solo trip to Orlando allowed me to finish a couple of nearby routes: FL 44, FL 414 (complete), FL 434, FL 429, FL 46, US 441, FL 44, and FL 11 (complete).

And a county-collecting trip to Atlanta for a concert with my wife: US 82, US 19, GA 92, GA 85, GA 331, GA 154, US 23, GA 16, GA 212, GA 22, GA 16, GA 123, GA 102, GA 15, GA 68, GA 112, US 23, US 129, US 319, GA 206, and US 441.

Next trip will be a county-collecting trip around Myrtle Beach, Wilmington, and Raleigh.

Offline dave1693

  • Full Member
  • ***
  • Posts: 185
  • Last Login:November 21, 2023, 11:28:54 pm
Re: New Travels and Stats Discussion
« Reply #371 on: November 20, 2019, 09:33:08 pm »
Multiple trips between eastern PA and the DC FedroSplat in the past month for me have yielded more new mileage.

What is the FedroSplat? I keep seeing that term used here but cannot find a definition when I Google it. In fact some of the Google search results take me back to this website.

FedroSplat is a term referring to the Greater DC Metro area. It seems to have been superseded in recent years by the term "the DMV" (referring to District [of Columbia], Maryland, Virginia) -- a term of which I cannot approve, for the same reasons as oscar. It appears to have come into use about 25 years ago in radio local to the area, based off an earlier radio term "the FedroPlex". "Fedro-" refers to how much of the local economy has traditionally been (and still is) based on the high level of federal government activity in the region. "-Splat" refers to the high rate of suburban sprawl compared to most metro areas on the East Coast. (The urban center of DC/Arlington/Alexandria and the most immediate neighboring areas is rather less densely populated than the centers of most Northeastern and Mid-Atlantic US metro areas traditionally were.)

I suspect it never got past being a localism, so never made it into the wider pop lexicon. I use it because it reflects my opinion of the area, and because it was coming into vogue when I first moved there in the very early 1990s. I've heard it used to refer to both the more immediate "DC and suburbs" (aka "the DMV") area, and also to the "extended area where there are lots of federal agencies" described by oscar, though more often to the former.
« Last Edit: November 20, 2019, 09:40:26 pm by dave1693 »

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4554
  • Last Login:Yesterday at 02:35:49 pm
Re: New Travels and Stats Discussion
« Reply #372 on: December 07, 2019, 03:59:02 pm »
I'll finish a 2-weeks-trip through Northwest Europe tomorrow. I've been to the Netherlands, Belgium, Luxembourg, France and England. I met Si and we traveled 253 miles together. I've clinched gbnm (1937mi), gbnam (227mi) and fraa (7222mi) motorway systems and re-clinched deua (8218mi).
I have currently clinched 16 TM systems* with a total mileage of about 23,800mi. Has anyone clinched more TM systems?  ;D

*After next site update

Offline oscar

  • TM Collaborator
  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1523
  • Last Login:Yesterday at 07:38:46 pm
    • Hot Springs and Highways pages
Re: New Travels and Stats Discussion
« Reply #373 on: December 07, 2019, 05:25:17 pm »
I have currently clinched 16 TM systems* with a total mileage of about 23,800mi. Has anyone clinched more TM systems?  ;D

*After next site update

Not me. I have 10 clinched (one of those will be shown as 100% after my next list file update), and only a few miles missing from the huge usai system.
« Last Edit: December 08, 2019, 06:29:33 pm by oscar »

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 #374 on: December 12, 2019, 01:09:09 am »
Code: [Select]
select traveler, count(trav.systemName), sum(TravMi) from
( select
    traveler,
    systemName,
    sum(mileage) as TravMi
  from clinchedSystemMileageByRegion
  group by traveler, systemName
) as trav
left join
( select
    systemName,
    sum(mileage) as fullMi
  from systemMileageByRegion
  group by systemName
) as whole
on trav.systemName = whole.systemName
where TravMi = fullMi
group by traveler
order by count(trav.systemName);
| cinx             |                      2 |  387.1887969970703 |
| dougtone         |                      2 |  5306.368959933519 |
| charliezeb       |                      2 |  1329.297993183136 |
| dharwood         |                      2 | 15.841314792633057 |
| bogdymol         |                      2 |  492.9820251464844 |
| deathtopumpkins  |                      2 | 3322.8767285346985 |
| froggie          |                      3 | 2757.3106162548065 |
| cl94             |                      3 | 12698.312079787254 |
| drebbin37        |                      3 | 3270.5574536323547 |
| vespertine       |                      3 |  20655.92740112543 |
| htm_duke         |                      3 |  5771.542194843292 |
| duke87           |                      5 |  7914.217487812042 |
| mapcat           |                      6 | 37714.852480471134 |
| oscar            |                      9 | 16715.368287682533 |
| michih           |                     16 | 23855.830348849297 |
+------------------+------------------------+--------------------+
105 rows in set (0.14 sec)
« Last Edit: December 12, 2019, 01:13:00 am by yakra »
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca