[FEATURE REQ] Stadium <-> location mapping

[alecglen]

From discord discussion.

A mapping from stadiums to their city, or more generally their location, would enable stuff like map-based graphics and "distance traveled by away_team" metrics for analysis.

Here is a start for the mapping: stadiums.csv

[padraigf]

Thanks for creating Alec. As you correctly point out, it should probably be location rather than city, as some, like Gillette are in Foxborough, which is a town.

You've got country and timezone as well, that's great (would be great to include these).

[greerreNFL]

Have also been thinking about field orientation (ie relative to north), which would enable better weather analytics -- ie being able to tell when a team is going into the wind or facing a cross breeze

[mrcaseb]

I have started something like that a while ago but got distracted. https://x.com/mrcaseb/status/1759620009062445519

[mrcaseb]

Here is the dataset I was working on. It is based on the wikipedia list of NFL stadiums

stadiums.csv

Glimpse:

Rows: 39
Columns: 12
$ name               <chr> "Acrisure Stadium", "Allegiant Stadium", "Arrowhead Stadium", "AT&T Stadium", "Bank of…
$ team               <chr> "Pittsburgh Steelers", "Las Vegas Raiders", "Kansas City Chiefs", "Dallas Cowboys", "C…
$ location           <chr> "Pittsburgh, Pennsylvania", "Paradise, Nevada", "Kansas City, Missouri", "Arlington, T…
$ capacity           <chr> "68,400", "65,000", "76,416", "80,000", "74,867", "73,208", "76,125", "67,838", "65,00…
$ surface            <chr> "Kentucky bluegrass", "Bermuda grass", "Bermuda grass", "Hellas Matrix Turf", "FieldTu…
$ roof_type          <chr> "Open", "Fixed", "Open", "Retractable", "Open", "Fixed", "Open", "Open", "Fixed", "Ope…
$ opened             <chr> "2001", "2020", "1972", "2009", "1996", "1975", "2001", "1995", "2002", "2002", "1987"…
$ stadium_detail_url <chr> "https://en.wikipedia.org//wiki/Acrisure_Stadium", "https://en.wikipedia.org//wiki/All…
$ latitude           <chr> "40°26′48″N", "36°05′26″N", "39°2′56″N", "32°44′52″N", "35°13′33″N", "29°57′3″N", "39°…
$ longitude          <chr> "80°0′57″W", "115°11′2″W", "94°29′2″W", "97°5′34″W", "80°51′10″W", "90°4′52″W", "105°1…
$ maps_url           <chr> "https://www.google.com/maps/search/?api=1&query=40°26′48″N%2C80°0′57″W&basemap=satell…
$ maps_url2          <chr> "https://www.google.com/maps/@?api=1&map_action=map&center=40.4466666666667%2C-80.0158…