Author Topic: Project Statistics  (Read 262014 times)

0 Members and 7 Guests are viewing this topic.

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4422
  • Last Login:November 11, 2024, 12:50:03 pm
  • I like C++
Re: Project Statistics
« Reply #255 on: January 23, 2022, 11:00:12 pm »
Baltimorese
The language of Balmer Murland!*

Visiting said relative's parents' house in `92, I found a book entitled (iirc) Baltimorese.
There was an entry for each letter of the alphabet; the only one I remember now is
Quote
K is for Kroddy,
a far eastern art.
A kick to the jaw
is a good way to start.
*Don't know if "Merlin" is a more common spelling, but the book used Murland.
« Last Edit: February 11, 2022, 01:20:02 pm by yakra »
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4422
  • Last Login:November 11, 2024, 12:50:03 pm
  • I like C++
Re: Project Statistics
« Reply #256 on: February 11, 2022, 01:17:05 pm »
Top 10 routes for most labels in use:
for line in `tail -n +2 pointsinuse.log | tr ' ' '#'`; do printf '%03i %s\n' `expr $(echo "$line" | tr '#' ' ' | wc -w) - 1` `echo "$line" | cut -f1 -d'('`; done | sort | tail
145 nc.us064
149 ny.ny005
158 ga.us041
160 tn.us070
169 ca.ca001
169 ky.us060
175 nc.us070
177 ca.i005
218 fl.us001
261 ca.us101
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4422
  • Last Login:November 11, 2024, 12:50:03 pm
  • I like C++
Re: Project Statistics
« Reply #257 on: February 13, 2022, 11:21:12 am »
Highest ratio of chopped to connected routes:
1.736    33    19   cantch
1.869   286   153   deua
1.883   373   198   chng
2.057   144    70   asiah
2.444   836   342   eure
2.500    45    18   afrtah
2.512   103    41   eure2
2.764    94    34   indnh
3.363   148    44   asiahp
3.613   813   225   usaus


Not ratios, just the raw differences between the counts
0090   429   339   espn
0104   148    44   asiahp
0115   737   622   itass2
0133   286   153   deua
0166   606   440   mexf
0175   373   198   chng
0198   556   358   usai
0236   965   729   deub
0494   836   342   eure
0588   813   225   usaus
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4849
  • Last Login:November 20, 2024, 11:21:09 am
Re: Project Statistics
« Reply #258 on: March 08, 2022, 03:48:50 pm »
We have 20 travelers in the 100,000 miles club now*. Welcome @formulanone :)

*preview+active systems

Offline formulanone

  • Full Member
  • ***
  • Posts: 141
  • Last Login:November 20, 2024, 11:28:08 am
Re: Project Statistics
« Reply #259 on: March 09, 2022, 09:34:20 am »
Thanks for the welcome to the 100K club!

Though Ib3kii is on an absolute tear and will overtake me soon enough...

Offline Ib3kii

  • Milwaukeye
  • Full Member
  • ***
  • Posts: 130
  • Gender: Male
  • Last Login:January 12, 2023, 02:02:21 pm
  • I want to be the first one to collect them all!
    • Travel Mapping User Page
Re: Project Statistics
« Reply #260 on: March 10, 2022, 03:51:13 pm »
Thanks for the welcome to the 100K club!

Though Ib3kii is on an absolute tear and will overtake me soon enough...

Ha! I wish. I did a lot of damage to my car in 2021. I went from the east coast to the west coast twice and probably doubled my total miles in one year alone. After my last trip, my car hit 200,000 miles (had only about 120,000 a year prior) and then it started making noise...

Long story short, it will be a few months before I will be traveling again. Rest assured I'll be going back to large trips every other weekend when that time comes.
-The journey of a thousand miles begins with a single step... on the gas.

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4849
  • Last Login:November 20, 2024, 11:21:09 am
Re: Project Statistics
« Reply #261 on: April 10, 2022, 10:49:19 am »
Inspired by this. What's (currently) the lowest number missing on TM? Lowest overall number, lowest in EUR, lowest in NA?

That means, what's the (current) "end of the game"?

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4422
  • Last Login:November 11, 2024, 12:50:03 pm
  • I like C++
Re: Project Statistics
« Reply #262 on: April 10, 2022, 12:05:42 pm »
Lowest overall number, lowest in EUR, lowest in NA?
Just going for the lowest overall number here; not going to attempt to break it down by continent.

Including only systems in the HB (whether devel systems are included or not), it's 1386.
Adding in systems commented out of systems.csv fills in 56 missing numbers, bringing us up to 1928.

Showing my work. From the HighwayData/hwy_data/_systems directory:
Code: [Select]
# Keep track of commented-out systems; these will be highlighted in red in the results
BigOlRegex=$(tail -n +2 ../../systems.csv | grep '^#' | grep -v 'Systems' | cut -f1 -d';' | tr '#\n' '^;' | sed -e 's~;~;\.\*|~g' -e 's~|$~~')

# Make a list of CSVs for all system codes in systems.csv
# Put commented-out systems at the end to ensure we only get results from these systems if there's no other option
l_csvs=$(tail -n +2 ../../systems.csv | grep -v '^#' | cut -f1 -d';' | sed 's~.*~&.csv~'; \
         tail -n +2 ../../systems.csv | grep '^#' | grep -v 'Systems' | cut -f1 -d';' | sed -r 's~#(.*)~\1.csv~')

# List only those .csv files that actually exist
e_csvs=''
for csv in $l_csvs; do
  if [ -e $csv ]; then e_csvs="$e_csvs $csv"; fi
done

# Iterate thru numbers & search, stopping when there's no result
res=SomethingWithOneOrMoreCharacters
e=`echo -en '\e'`
n=1
while [ `echo -n "$res" | wc -c` != 0 ]; do
  res=$(cat $e_csvs | grep -m 1 ".*;.*;[A-Za-z]*$n[A-Za-z]*;.*;.*;.*;.*;.*")
  echo "$res" | sed -r "s~$BigOlRegex~$e[31m&$e[0m~"
  n=`expr $n + 1`
done


Edit: Last sed expression in BigOlRegex
« Last Edit: April 10, 2022, 08:53:05 pm by yakra »
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4849
  • Last Login:November 20, 2024, 11:21:09 am
Re: Project Statistics
« Reply #263 on: April 10, 2022, 12:22:09 pm »
Thanks :)

Offline froggie

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 858
  • Last Login:Yesterday at 06:24:33 pm
Re: Project Statistics
« Reply #264 on: April 10, 2022, 06:56:05 pm »
a.k.a the lowest route number that doesn't exist in Kentucky or elsewhere...

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4422
  • Last Login:November 11, 2024, 12:50:03 pm
  • I like C++
Re: Project Statistics
« Reply #265 on: April 10, 2022, 08:56:38 pm »
Indeed, lots of Kentucky in the results of that script, despite usaky being pretty late in the alphabet.
The vast majority is in KY from about route 1540 up.
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca

Offline si404

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2067
  • Last Login:Today at 12:54:41 am
Re: Project Statistics
« Reply #266 on: April 11, 2022, 04:55:47 am »
1540 sounds like a B road. The zonal system kills a continuous number stream of 3500 routes.

Offline formulanone

  • Full Member
  • ***
  • Posts: 141
  • Last Login:November 20, 2024, 11:28:08 am
Re: Project Statistics
« Reply #267 on: April 15, 2022, 06:08:41 pm »
Our 1-2-3 Road Sign game at AARoads nearly came to a halt until I found De Kalb County had a few 1900 routes near Rainsville, Alabama:


Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4422
  • Last Login:November 11, 2024, 12:50:03 pm
  • I like C++
Re: Project Statistics
« Reply #268 on: April 19, 2022, 05:11:20 pm »
Code: [Select]
#cd $HOME/tm/HighwayData/hwy_data/_systems/ #or like wherever
systems=$(tail -n +2 ../../systems.csv | grep -v '^#' | cut -f1 -d';')
region_counts=$(for s in $systems; do printf "%03i;$s\n" $(tail -n +2 $s.csv | cut -f2 -d';' | sort | uniq | wc -l); done | sort)

for region_count in $(echo "$region_counts" | cut -f1 -d';' | sort | uniq); do
  system_count=$(echo "$region_counts" | grep -c "^$region_count;")
  if [ $system_count = 1 ]
    then s_plural=''
         e_plural='s'
    else s_plural='s'
         e_plural=''
  fi
  printf "%i system%s exist%s in %i region" \
    $system_count \
    "$s_plural" \
    "$e_plural" \
    $(echo $region_count | sed 's~^0*~~')
  if [ $region_count -gt 1 ]
    then echo -n s
    else echo -n ' each'
  fi
  if [ $system_count -le 5 ]
    then echo -n ": "; echo ": $region_counts" | grep "^$region_count;" | cut -f2 -d';' | tr '\n' ',' | sed -e 's~,~, ~g' -e 's~, $~\n~'
    else echo
  fi
done
360 systems exist in 1 region each
75 systems exist in 2 regions
16 systems exist in 3 regions
5 systems exist in 4 regions: asiaho, ausn, ausstr, cism, fraidfd77
3 systems exist in 5 regions: afrea, ausm, cannf
3 systems exist in 7 regions: asimo, ausa, mexed
1 system exists in 8 regions: asim
1 system exists in 10 regions: cantch
3 systems exist in 12 regions: fraa, fran, index
3 systems exist in 13 regions: afrrtr, mexsf, usaif
1 system exists in 14 regions: indnh
2 systems exist in 15 regions: espa, usaush
2 systems exist in 16 regions: deua, eurtr
1 system exists in 17 regions: espn
1 system exists in 19 regions: deub
1 system exists in 23 regions: afrtah
3 systems exist in 25 regions: asiah, usaib, usasf
1 system exists in 30 regions: chng
2 systems exist in 31 regions: mexd, usanp
2 systems exist in 32 regions: eursf, mexf
1 system exists in 48 regions: usausb
(MA has none)
1 system exists in 49 regions: usaus
1 system exists in 50 regions: asiahp
1 system exists in 52 regions: usai
1 system exists in 92 regions: eure


Mean: 2.778 regions per system
Median: 1
« Last Edit: April 21, 2022, 09:22:34 am by yakra »
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca

Offline osu-lsu

  • Full Member
  • ***
  • Posts: 169
  • Last Login:Yesterday at 10:29:32 pm
Re: Project Statistics
« Reply #269 on: April 20, 2022, 10:56:56 pm »
Which region has 360 systems?