Author Topic: Non-connected related routes - definition discussion  (Read 9308 times)

0 Members and 1 Guest are viewing this topic.

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4555
  • Last Login:Yesterday at 04:04:16 pm
Re: Non-connected related routes - definition discussion
« Reply #15 on: July 02, 2020, 02:45:14 pm »
A stupid question -- where can I find the tmtest version of the HB (and anything else on tmtest)? I'm on the road, haven't had time to look at tmtest.

Examples:
https://tmtest.teresco.org/hb/showroute.php?u=oscar&r=qc.a440
https://tmtest.teresco.org/hb/showroute.php?u=oscar&r=qc.tchkir (@Jim, why AntChiMaz?)
https://tmtest.teresco.org/hb/showroute.php?u=oscar&r=eng.m001

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2732
  • Last Login:Yesterday at 10:14:53 pm
Re: Non-connected related routes - definition discussion
« Reply #16 on: July 02, 2020, 02:54:09 pm »
(@Jim, why AntChiMaz?)

Looks like it has "tCh" in the middle!

Offline si404

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1944
  • Last Login:Yesterday at 08:28:40 pm
Re: Non-connected related routes - definition discussion
« Reply #17 on: July 02, 2020, 02:54:41 pm »
@Jim, why AntChiMaz?
Not Jim, but I believe my bolding it has explained why.

This stopgap is useful and good - it gives back the related routes function in some form so you can find the route you actually want if you went onto the wrong one, but not the problematic form of mapview.

Offline oscar

  • TM Collaborator
  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1524
  • Last Login:Today at 01:36:37 am
    • Hot Springs and Highways pages
Re: Non-connected related routes - definition discussion
« Reply #18 on: July 02, 2020, 03:08:57 pm »
I think it's a decent stopgap, even if the "similar routes" list is longer than the old "related routes" list such as by including stuff like "AntChiMaz" (I would not worry too much about fixing that). I also am OK with the term "similar routes", to reserve "related routes" for a more refined definition used for non-HB purposes.

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4555
  • Last Login:Yesterday at 04:04:16 pm
Re: Non-connected related routes - definition discussion
« Reply #19 on: July 02, 2020, 03:14:05 pm »
(@Jim, why AntChiMaz?)

Looks like it has "tCh" in the middle!

Ok, but why does https://tmtest.teresco.org/hb/showroute.php?r=deurp.a001 output A1 routes only and not A10, A11, A12 etc.?

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2732
  • Last Login:Yesterday at 10:14:53 pm
Re: Non-connected related routes - definition discussion
« Reply #20 on: July 02, 2020, 04:03:13 pm »
(@Jim, why AntChiMaz?)

Looks like it has "tCh" in the middle!

Ok, but why does https://tmtest.teresco.org/hb/showroute.php?r=deurp.a001 output A1 routes only and not A10, A11, A12 etc.?

Here's the query:

Code: [Select]
select * from routes where (route like '".$routeInfo['route']."' or route regexp '".$routeInfo['route']."[A-Za-z]');
where $routeInfo['route'] is the route name without region, banner, abbrev.  This just about the old Mapview query.  The regexp part is going to match anything that starts with the route plus a single letter.  So that gets NY30A from NY30, I-35W from I-35.  The like part is a little more mysterious to me.  I think maybe I should replace it with an exact match.

Offline si404

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1944
  • Last Login:Yesterday at 08:28:40 pm
Re: Non-connected related routes - definition discussion
« Reply #21 on: February 07, 2021, 12:54:55 pm »
TM data has no way to say that the 3 I-35's and 2 US 20's are the same route in some meaningful way, but pairs like the pairs of I-84, I-86, I-87, I-88, are not.
If we add more data, the data can do that - all you'd need some other .csv file. A simplish reworking usai_con.csv gives us usai_rel.csv below. I've only done the 2dis in the lower 48, as that gives examples of everything while keeping it both concise, but complete (rather than just having random rows out of it), based on the following notions: disjointed routes (a lack of construction, suffixed routes, ferries, etc) are merged, along with branching routes (NJ I-95Sec), bannered routes* (I-5Trk, though if I did the 3dis then the two I-895Spr routes) and suffixed routes (YMMV as to whether they count here). I've got I-74s as well as 76s, 84s, 86s, 87s and 88s, but only one I-69 as there's actually a desire to link the segments of that route.

Code: [Select]
RelatedRouteGroup;GroupName;roots
I-2;;tx.i002
I-4;;fl.i004
I-5;;ca.i005,or.i005,wa.i005,ca.i005trknew
I-8;;ca.i008,az.i008
I-10;;ca.i010,az.i010,nm.i010,tx.i010,la.i010,ms.i010,al.i010,fl.i010
I-11;;nv.i011
I-12;;la.i012
I-14;;tx.i014
I-15;;ca.i015,nv.i015,az.i015,ut.i015,id.i015,mt.i015
I-16;;ga.i016
I-17;;az.i017
I-19;;az.i019
I-20;;tx.i020,la.i020,ms.i020,al.i020,ga.i020,sc.i020
I-22;;ms.i022,al.i022
I-24;;il.i024,ky.i024,tn.i024,ga.i024,tn.i024cha
I-25;;nm.i025,co.i025,wy.i025
I-26;;tn.i026,nc.i026fau,nc.i026,sc.i026
I-27;;tx.i027
I-29;;mo.i029,ia.i029,sd.i029,nd.i029
I-30;;tx.i030,ar.i030
I-35;;tx.i035,tx.i035e,tx.i035w,tx.i035gai,ok.i035,ks.i035,mo.i035,ia.i035,mn.i035far,mn.i035e,mn.i035w,mn.i035
I-37;;tx.i037
I-39;;il.i039,wi.i039
I-40;;ca.i040,az.i040,nm.i040,tx.i040,ok.i040,ar.i040,tn.i040,nc.i040
I-41;;il.i041,wi.i041
I-43;;wi.i043
I-44;;tx.i044,ok.i044,mo.i044
I-45;;tx.i045
I-49;;la.i049,la.i049bel,ar.i049tex,ar.i049,mo.i049
I-55;;la.i055,ms.i055,tn.i055,ar.i055,mo.i055,il.i055
I-57;;mo.i057,il.i057
I-59;;la.i059,ms.i059,al.i059,ga.i059
I-64;;mo.i064,il.i064,in.i064,ky.i064,wv.i064,va.i064
I-65;;al.i065,tn.i065,ky.i065,in.i065
I-66;;va.i066,dc.i066
I-68;;wv.i068,md.i068
I-69;;tx.i069c,tx.i069e,tx.i069erob,tx.i069w,tx.i069,ms.i069,ky.i069,in.i069whe,in.i069,mi.i069
I-70;;ut.i070,co.i070,ks.i070,mo.i070,il.i070,in.i070,oh.i070,wv.i070,pa.i070,md.i070
I-71;;ky.i071,oh.i071
I-72;;mo.i072,il.i072
I-73;;nc.i073
I-74;Iowa - Ohio;ia.i074,il.i074,in.i074,oh.i074
I-74;North Carolina;nc.i074,nc.i074hig,nc.i074pem
I-75;;fl.i075,ga.i075,tn.i075,ky.i075,oh.i075,mi.i075
I-76;Colorado - Nebraska;co.i076,ne.i076
I-76;Ohio - New Jersey;oh.i076,pa.i076,nj.i076
I-77;;sc.i077,nc.i077,va.i077,wv.i077,oh.i077
I-78;;pa.i078,nj.i078,ny.i078
I-79;;wv.i079,pa.i079
I-80;;ca.i080,nv.i080,ut.i080,wy.i080,ne.i080,ia.i080,il.i080,in.i080,oh.i080,pa.i080,nj.i080
I-81;;tn.i081,va.i081,wv.i081,md.i081,pa.i081,ny.i081
I-82;;wa.i082,or.i082
I-83;;md.i083,pa.i083
I-84;Oregon - Utah;or.i084,id.i084,ut.i084
I-84;Pennsylvania - Massachusetts;pa.i084,ny.i084,ct.i084,ma.i084
I-85;;al.i085,ga.i085,sc.i085,nc.i085,va.i085
I-86;Idaho;id.i086
I-86;Pennsylvania - New York;pa.i086,ny.i086,pa.i086swa,ny.i086bin
I-87;New York;ny.i087
I-87;North Carolina;nc.i087
I-88;Illinois;il.i088
I-88;New York;ny.i088
I-89;;nh.i089,vt.i089
I-90;;wa.i090,id.i090,mt.i090,wy.i090,sd.i090,mn.i090,wi.i090,il.i090,in.i090,oh.i090,pa.i090,ny.i090,ma.i090
I-91;;ct.i091,ma.i091,vt.i091
I-93;;ma.i093,nh.i093,vt.i093
I-94;;mt.i094,nd.i094,mn.i094,wi.i094,il.i094,in.i094,mi.i094
I-95;;fl.i095,ga.i095,sc.i095,nc.i095,va.i095,dc.i095,md.i095,de.i095,pa.i095,nj.i095,ny.i095,ct.i095,ri.i095,ma.i095,nh.i095,me.i095,nj.i095sec
I-96;;mi.i096
I-97;;md.i097
I-99;;pa.i099,ny.i099

Whether it's worth the effort is a different matter.

*Of course there's the business routes in another system, but that makes it more complex - I ditched the system column so I could integrate usaib, but decided against doing it as it would be relatively easy here, but could get messy with multi-state routes and such.

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4555
  • Last Login:Yesterday at 04:04:16 pm
Re: Non-connected related routes - definition discussion
« Reply #22 on: February 07, 2021, 01:07:23 pm »
Thanks for all of the suggestions.  I want to make sure these don't get lost, so I'll point to existing or new Issues about these.  Some are specific to topstats and some will apply anywhere we use the shields.

Overall stats for disconnected connected routes (e.g. I-35, US 20)

This gets back to the problem we discussed a lot last summer about "related routes".  TM data has no way to say that the 3 I-35's and 2 US 20's are the same route in some meaningful way, but pairs like the pairs of I-84, I-86, I-87, I-88, are not.

There is no technical solution right now and there was no consense on WHAT counts as "Interrupted connected routes".