Hello,
The sportdb Ruby gem [1] that lets you read plain text fixtures for
teams, matches, tournaments, leagues, and more now also includes a new
grounds table (for stadiums/venues). Plus the games table and the
events table now include references for grounds.
For example, using the World Cup event in Brazil 2014 you can get
all twelve stadiums by using:
event = Event.find_by key: 'world.2014'
event.ground.count # => 12
event.grounds # => [
'Estádio do Maracanã -- Rio de Janeiro',
'Estádio Nacional Mané Garrincha -- Brasília',
'Arena Corinthians -- São Paulo',
..
]
To get the city for a game
# (1) Thu Jun/12 Brazil - Croatia @ Arena de São Paulo, São Paulo
for example, use:
game.ground.title # => Arena de São Paulo
game.ground.city.title # => São Paulo
And so on and so forth. See the World Cup 2014 fixtures [2], for an
example for plain text games/match fixtures with stadium/venue
location included.
Cheers.
[1] github.com/geraldb/sport.db.ruby
[2] github.com/openfootball/world-cup/blob/master/2014/cup.txt