Travel Mapping

Web Design Discussion => General Web Design Discussion => Topic started by: Jim on January 03, 2022, 11:53:04 pm

Title: New page: routes traveled by number
Post by: Jim on January 03, 2022, 11:53:04 pm
A suggestion was made on AARoads in https://www.aaroads.com/forum/index.php?topic=24342.msg2694805#msg2694805 to make a web front-end version of the code that gets routes by number.  I got going on it, turns out it was pretty simple.

The new page user/routesbynumber.php is now just on tmdevel but once some eyes have had a chance to check it out and report problems and offer suggestions, I'll put it on the main site and link from user/index.php.

Comments welcome.
Title: Re: New page: routes traveled by number
Post by: si404 on January 04, 2022, 06:46:34 am
Looks good, if a little visually odd with the plain white table.

I'll second Oscar's point about '0'. There are legit route zeros in Belgium (https://travelmapping.net/hb/showroute.php?r=bel.r000), Czechia (https://travelmapping.net/hb/showroute.php?r=cze.d000) and Hungary (https://travelmapping.net/hb/showroute.php?r=hun.m000). The others are unnumbered and ought to be listed at the bottom of the table (if at all?) under '-' or some other N/A descriptor.

There's also some false positives where a named road has a number in it, like T5 Spur (https://travelmapping.net/hb/showroute.php?r=eng.t5spr) (the spur of the motorway network to Heathrow Terminal 5), or MKAD2 (https://travelmapping.net/hb/showroute.php?r=blr.mkad2) (the 2nd Minsk Motorway Ring)

My score of 69 is surprisingly good, looking at that thread and seeing how low ranked, generally, I am in travels. It's also quite nice to be able to see the highest number I've travelled on (8008 - my travels seem to be rather childishly dirty!).

----
"TM is chock full of toys for subsets of the userbase!"

Are there toys for other similar games that use our database and user data that could also be implemented?

How about a stat for how many unique numbers has someone travelled on? (and in a 4-digit only variant, I think I might win - certainly top 5. Thanks GB numbering scheme!) Could be put on the same page as it is a similar game.

There's also how many different prefixes you've done (not the same as how many systems as many systems share prefixes like A, B, N or D, and others have several prefixes, like in Spain), but that might be a bit harder to implement.

And then there's the "have I done every route with that number game". It's a little meaningless with higher numbers that are likely to be unique, and with the global nature of the TM database would be rather impossible, but filters and the like to get it down to something meaningful allowing you to say something along the lines of "hey, I've done part of every route 1 in the US and Canada" sounds like a fun game.

----

There's the general geekery stuff that doesn't use user data - roads of same numbers but different type meeting each other (excluding banners), concurrency stats (longest, most), nodes with the most branches out of them, what numbers don't have roads attached to them?, etc. Would pages for them be a good idea?
Title: Re: New page: routes traveled by number
Post by: Markkos1992 on January 04, 2022, 06:56:42 am
Would it be useful to put the missing route numbers in its own table?
Title: Re: New page: routes traveled by number
Post by: michih on January 04, 2022, 09:40:40 am
Bug: Zero also outputs O and o ???

https://tmdevel.teresco.org/user/routesbynumber.php?u=terescoj

Code: [Select]
ONQEW, ONGar, TCH, OreMot, AtlCityExpy, BeltPkwy, BerCon, BroRivPkwy, CroCouPkwy, DalNorTlwy, EveTpk, FLTpk, FDRooDr, GarStaPkwy, GraCenPkwy, HarRivDr, HenHudPkwy, HutRivPkwy, InnLoop, JamWhiPkwy, JohnKilTpk, LakeOntPkwy, MTAppRd, MilPkwy, NJTpk, PalIntPkwy, PenaBlvd, PreBidExpy, RalChaExpy, SawMillPkwy, ScaCon, SolFieRd, SprBroPkwy, StoDr, TacStaPkwy, VetMemPkwy, VetPkwy, WanStaPkwy, CadSumRd, ParkLpRd, MainParkRd, BadLpRd, BalWasPkwy, SouRimDr, BlueRidPkwy, LinFalRd, IslSkySceDr, CraCrkRd, CraLakeHwy, CraLakeRimDr, ParkRd, DevTowRd, GWMemPkwy, TetParkRd, CliDomeRd, CraRd, ChaCraRd, CraRimDr, RocMemPkwy, CaveCityRd, MamCavePkwy, SteCynRd, BriViewDr, PetForRd, LoopRd, EastRivRd, SceLpDr, DunDr, EEntRd, GraLpRd, NorCynRd, NEntRd, NEEntRd, SEntRd, WEntRd, AudPkwy, GarExpy, RingRd, DtAlpStr, BearMtnPkwy, KorWarPkwy, MosPkwy, SevLakDr
Title: Re: New page: routes traveled by number
Post by: si404 on January 04, 2022, 09:44:08 am
Bug: Zero also outputs O and o ???
It's anything that doesn't use the numbers 1-9.
Title: Re: New page: routes traveled by number
Post by: michih on January 04, 2022, 09:48:48 am
And then there's the "have I done every route with that number game". It's a little meaningless with higher numbers that are likely to be unique, and with the global nature of the TM database would be rather impossible, but filters and the like to get it down to something meaningful allowing you to say something along the lines of "hey, I've done part of every route 1 in the US and Canada" sounds like a fun game.

Like! With filter "All regions" / "Regions I've traveled" and filter "Traveled" / "Clinched".
Title: Re: New page: routes traveled by number
Post by: mapcat on January 04, 2022, 09:56:25 am
This is fun, even if it gives me something new to obsess over:

Missing numbers: 525 673 688 738 767 793 809 813 816 831 843 853 877 887 918 929 939 942 945 959 962 963 972

I've been on OH 767 but unfortunately it's not signed.
Title: Re: New page: routes traveled by number
Post by: oscar on January 04, 2022, 10:12:33 am

Missing numbers: 525 673 688 738 767 793 809 813 816 831 843 853 877 887 918 929 939 942 945 959 962 963 972


If you can scrounge up a 525 somewhere near you, you can jump into the game. and go straight to the top, overtaking me at 609. That will make Rothman (leader of the "get Oscar" brigade) very happy.

My own 525 is in Washington state, but maybe you can find something farther east.
Title: Re: New page: routes traveled by number
Post by: mapcat on January 04, 2022, 10:24:59 am
If you can scrounge up a 525 somewhere near you, you can jump into the game. and go straight to the top, overtaking me at 609. That will make Rothman (leader of the "get Oscar" brigade) very happy.

My own 525 is in Washington state, but maybe you can find something farther east.

KY 525 (https://travelmapping.net/hb/showroute.php?units=miles&u=mapcat&r=ky.ky0525) looks like the best candidate. No plans to head out to that part of Kentucky anytime soon, though. From looking at the Wikipedia "List of highways numbered xxx" pages, it seems that there may be some numbers below 1000 with no signed routes at all, at least in North America.
Title: Re: New page: routes traveled by number
Post by: jayhawkco on January 04, 2022, 03:41:20 pm
Jim, I posted this in the aaroads thread, but it might have gotten missed.  Any way that the specific highways that pop up could be linked to their highway browser entries?  Useful for understanding how you've been on a route if it was concurrent with something else.
Title: Re: New page: routes traveled by number
Post by: Jim on January 04, 2022, 04:13:25 pm
Jim, I posted this in the aaroads thread, but it might have gotten missed.  Any way that the specific highways that pop up could be linked to their highway browser entries?  Useful for understanding how you've been on a route if it was concurrent with something else.

It is possible but could complicate things a bit for connected routes.

If you'd like to see every segment TM credited for you based on a concurrency, there's a massive log file generated on each site update available here: https://travelmapping.net/logs/concurrencies.log

It's much easier to deal with outside of a browser by logging into the server and using grep.  If you wanted a copy of your account's entries, I can grep out the section and email it on request.
Title: Re: New page: routes traveled by number
Post by: yakra on January 04, 2022, 04:23:14 pm
Jim, I posted this in the aaroads thread, but it might have gotten missed.  Any way that the specific highways that pop up could be linked to their highway browser entries?  Useful for understanding how you've been on a route if it was concurrent with something else.

It is possible but could complicate things a bit for connected routes.
How so? Doesn't strike me as terribly difficult; am I missing something?
Title: Re: New page: routes traveled by number
Post by: Jim on January 04, 2022, 04:39:08 pm
Jim, I posted this in the aaroads thread, but it might have gotten missed.  Any way that the specific highways that pop up could be linked to their highway browser entries?  Useful for understanding how you've been on a route if it was concurrent with something else.

It is possible but could complicate things a bit for connected routes.
How so? Doesn't strike me as terribly difficult; am I missing something?

Just more things to grab from the DB to have the root not just the route, and I'm asking for distinct route so for example I-35, I-35E, and I-35W would appear just once each, even though TM has three connected routes that are I-35 and two each of the others.  If we wanted every chopped route in the tables, that's one thing, but here I'm just trying to keep it simple with one of each unique route entry.
Title: Re: New page: routes traveled by number
Post by: osu-lsu on January 04, 2022, 05:20:55 pm

Missing numbers: 525 673 688 738 767 793 809 813 816 831 843 853 877 887 918 929 939 942 945 959 962 963 972


If you can scrounge up a 525 somewhere near you, you can jump into the game. and go straight to the top, overtaking me at 609. That will make Rothman (leader of the "get Oscar" brigade) very happy.

Mr. Roth would change the name of the game from "Get Oscar" to "Catch the Geographer."  8)
Title: Re: New page: routes traveled by number
Post by: Jim on January 04, 2022, 06:05:38 pm
Missing numbers now in a table, looking slightly nicer.

Routes with no number in the label are now in a separate "unnumbered" row, allowing one to find a route with a 0 more easily.  This means 0 also shows up for most in the missing numbers list.
Title: Re: New page: routes traveled by number
Post by: mapcat on January 04, 2022, 06:11:33 pm
Looks great! How hard would it be to add a "travelled/clinched" option?
Title: Re: New page: routes traveled by number
Post by: Jim on January 04, 2022, 07:36:26 pm
Looks great! How hard would it be to add a "travelled/clinched" option?

For this, I wonder if it's better to add a "group by route number" option to https://travelmapping.net/shields/clinched.php instead.
Title: Re: New page: routes traveled by number
Post by: mapcat on January 04, 2022, 10:44:26 pm
For this, I wonder if it's better to add a "group by route number" option to https://travelmapping.net/shields/clinched.php instead.
I'd like to see that!
Title: Re: New page: routes traveled by number
Post by: Jim on January 04, 2022, 10:54:33 pm
For this, I wonder if it's better to add a "group by route number" option to https://travelmapping.net/shields/clinched.php instead.
I'd like to see that!

https://github.com/TravelMapping/Web/issues/708
Title: Re: New page: routes traveled by number
Post by: michih on January 05, 2022, 01:34:34 am
Any way that the specific highways that pop up could be linked to their highway browser entries?

I don't think that it is possible. Where should A1 link too? UK, Netherlands, Belgium, Luxembourg, Germany, Switzerland, Austria, Poland, Italy, Romania, Greece, Serbia, Slovenia, Croatia,...?
Title: Re: New page: routes traveled by number
Post by: rlee on January 05, 2022, 05:20:46 am
I'm actually glad the list stops at route number 999 by default. The list would get very congested if I searched nto the 4 digit range of both Louisiana and Kentucky.

Looks like my lowest non-0 is 170. A good number of the numbers between 301 and 613 will come off the untraveled list when Mississippi is fully on board.

https://tmdevel.teresco.org/user/routesbynumber.php?u=rlee
Title: Re: New page: routes traveled by number
Post by: Duke87 on January 06, 2022, 12:12:11 am
I'm noting that the list seems to be handling bannered routes as identical to their parents, which is not really ideal behavior.

For example https://tmdevel.teresco.org/user/routesbynumber.php?u=duke87 says I've been on OH100, but... I haven't! Look at https://travelmapping.net/shields/clinched.php?units=miles&u=duke87&cort=traveled and it correctly shows OH100 Truck (South Tiffin) as traveled but not OH100 itself.
Title: Re: New page: routes traveled by number
Post by: oscar on January 06, 2022, 12:48:33 am
Any way that the specific highways that pop up could be linked to their highway browser entries?

I don't think that it is possible. Where should A1 link too? UK, Netherlands, Belgium, Luxembourg, Germany, Switzerland, Austria, Poland, Italy, Romania, Greece, Serbia, Slovenia, Croatia,...?

And there are duplicate numbers even within systems. For example, five NT 5s, four AK 7s, three A-440s, two QC 136s. But at least there could be a link to one of them, with the HB's "jump to similar route" feature pointing you to the others.
Title: Re: New page: routes traveled by number
Post by: Jim on January 06, 2022, 10:07:52 am
I need to put it aside for now with some pressing work deadlines coming up, so I have updated the text on the new page a bit, added a link to the traveled/clinched routes page, and put it on the production site.  Please feel free to add GitHub Issues related to problems and/or feature requests.
Title: Re: New page: routes traveled by number
Post by: Bickendan on January 11, 2022, 04:23:48 pm
This is fun, even if it gives me something new to obsess over:

Missing numbers: 525 673 688 738 767 793 809 813 816 831 843 853 877 887 918 929 939 942 945 959 962 963 972

I've been on OH 767 but unfortunately it's not signed.
This makes me want to add the ORH system all the more...I could actually get a 48 (US 395 from John Day to Burns) onto my list! I've seen both ends of 48 at least...
Title: Re: New page: routes traveled by number
Post by: michih on January 15, 2022, 09:29:30 am

Missing numbers: 525 673 688 738 767 793 809 813 816 831 843 853 877 887 918 929 939 942 945 959 962 963 972


If you can scrounge up a 525 somewhere near you, you can jump into the game. and go straight to the top, overtaking me at 609. That will make Rothman (leader of the "get Oscar" brigade) very happy.

My own 525 is in Washington state, but maybe you can find something farther east.

The best way to find a route is by using https://travelmapping.net/hb/findroute.php

(https://forum.travelmapping.net/index.php?action=dlattach;topic=4774.0;attach=455)

I think that it would help more "for the game" having links on https://travelmapping.net/user/routesbynumber.php to findroute.php for the "Missing Numbers".
You can easily filter the result, e.g. for continent. However, findroute (currently) outputs all routes containing the string, that means, also KY1525 and KY3525. And the url is (currenlty) not updated based on the filter.

Edit: https://github.com/TravelMapping/Web/issues/711
Title: Re: New page: routes traveled by number
Post by: michih on February 02, 2022, 03:34:27 pm

Missing numbers: 525 673 688 738 767 793 809 813 816 831 843 853 877 887 918 929 939 942 945 959 962 963 972


If you can scrounge up a 525 somewhere near you, you can jump into the game. and go straight to the top, overtaking me at 609. That will make Rothman (leader of the "get Oscar" brigade) very happy.

I still hang at 144 but there is one (https://travelmapping.net/hb/showroute.php?r=frages.d01446ae) quite close to me, just a 2.5 hour drive to get there. The missing 300s and 400s are in a similar distance up to 3.5 hours from home. I can catch a lot of these missing numbers with a simple one-day trip.
575 (https://travelmapping.net/hb/showroute.php?r=deunw.l575), 576 (https://travelmapping.net/hb/showroute.php?r=bel.n576) and 581 (https://travelmapping.net/hb/showroute.php?r=deunw.l581) are more challenging but doable with two-day-trips. Once done, 625 will be the next missing route which will be a little bit easier to catch - just like the remaining 600s around Dortmund, DEU-NW, or Strasbourg, FRA-GES.

Sounds like a nice little goal for 2022 :)


Edit: @oscar, you wrote that you are at 609 but I think you also miss "0 386 399 437 498 539 554 600 606" (https://travelmapping.net/user/routesbynumber.php?u=oscar), don't you?
Title: Re: New page: routes traveled by number
Post by: formulanone on February 02, 2022, 06:11:37 pm
Edit: @oscar, you wrote that you are at 609 but I think you also miss "0 386 399 437 498 539 554 600 606" (https://travelmapping.net/user/routesbynumber.php?u=oscar), don't you?

If he's like me, many Mississippi highways are not yet out of development in TM which would count towards that number. There are also lots of Texas Farm-to-Market and Ranch-to-Market roads not included, as well as Virginia State Secondary Routes which are not in TM at all...though FM/RMs are a work in progress.

That puts me at 479; if we include shielded county-maintained roads (a bone of contention at AARoads), I'm up to 558 as my personal lowest.
Title: Re: New page: routes traveled by number
Post by: oscar on February 02, 2022, 08:00:04 pm
Edit: @oscar, you wrote that you are at 609 but I think you also miss "0 386 399 437 498 539 554 600 606" (https://travelmapping.net/user/routesbynumber.php?u=oscar), don't you?

If he's like me, many Mississippi highways are not yet out of development in TM which would count towards that number. There are also lots of Texas Farm-to-Market and Ranch-to-Market roads not included, as well as Virginia State Secondary Routes which are not in TM at all...though FM/RMs are a work in progress.

My count includes two Virginia state routes not in TM (386 was decommissioned after I clinched it, 399 is unsigned); three signed county routes (437 in Alabama, 539 and 554 in New Jersey); one signed Mississippi state route not yet in TM (498); and two Virginia state secondary routes that aren't and never will be in TM (600 and 606).

Zero doesn't count under the rules of the AARoads game, which is limited to positive integers (no West Virginia fractional routes either).