Stadiums

Moderator: Update Team (Director)

User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

do you mean inserted (updated) in the database?
User avatar
SteveHarle
Reserve Team Player
Posts: 359
Joined: Mon May 04, 2020 10:02 pm
Location: Essex, England
Has thanked: 12 times
Been thanked: 2 times

Stadiums

Post by SteveHarle »

*Baw* wrote: Wed Sep 16, 2020 10:18 pm do you mean inserted (updated) in the database?
Yes, that's right - I have finally got round to updating all of your work into the database! That list is just a checklist for me to make sure I don't miss any!

Once I have done, I will run a new data extract to see what is left :)
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

SteveHarle wrote: Wed Sep 16, 2020 10:54 pm
Yes, that's right - I have finally got round to updating all of your work into the database! That list is just a checklist for me to make sure I don't miss any!

Once I have done, I will run a new data extract to see what is left :)
then over the weekend I pass you more material ;)
User avatar
SteveHarle
Reserve Team Player
Posts: 359
Joined: Mon May 04, 2020 10:02 pm
Location: Essex, England
Has thanked: 12 times
Been thanked: 2 times

Stadiums

Post by SteveHarle »

Thanks..... (I think?) haha.

Really good work from what I have seen so far.

It takes as long to create the stadiums, cities etc as it does to find the information so with the info you are giving us it halves the effort requirements our side so it is a great help.
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

SteveHarle wrote: Thu Sep 17, 2020 2:39 pm Thanks..... (I think?) haha.

Really good work from what I have seen so far.

It takes as long to create the stadiums, cities etc as it does to find the information so with the info you are giving us it halves the effort requirements our side so it is a great help.
:lol: :lol: :lol:
....
....Speaking of information, I noticed that some teams in the list of teams without stadiums do not have the correct name (extended and / or short), if it comes back to me, can I mark it in a separate column when I share the file with the stadiums?
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

Stadium updates:
  • Democratic Republic of Congo
  • Denmark
  • Dominica
  • Dominican Republic
  • Egypt
  • Equatorial Guinea
  • Eritrea
  • Faroe Islands
  • Fiji
  • Finland
  • France
  • French Guiana
  • FYR of Macedonia
  • Gabon
DOWNLOAD
User avatar
SteveHarle
Reserve Team Player
Posts: 359
Joined: Mon May 04, 2020 10:02 pm
Location: Essex, England
Has thanked: 12 times
Been thanked: 2 times

Stadiums

Post by SteveHarle »

*Baw* wrote: Fri Sep 18, 2020 1:12 pm
SteveHarle wrote: Thu Sep 17, 2020 2:39 pm Thanks..... (I think?) haha.

Really good work from what I have seen so far.

It takes as long to create the stadiums, cities etc as it does to find the information so with the info you are giving us it halves the effort requirements our side so it is a great help.
:lol: :lol: :lol:
....
....Speaking of information, I noticed that some teams in the list of teams without stadiums do not have the correct name (extended and / or short), if it comes back to me, can I mark it in a separate column when I share the file with the stadiums?
For consistency - with team names, the "long name" we match them up with the Transfermarkt website. This is to make sure (as there are quite a few of us working on the database) we don't duplicate when creating new teams, for example, we don't want an "Inter Milan, Internazionale and Inter" in Serie A do we... one is enough :)

If you see a team has completely changed it's name, for example if "Tottenham Hotspur" changed to "Gareth Bale FC" - absolutely make a note of it - that would be very helpful and we will correct it, but it must be the same as Transfermarkt (whether it is right or wrong!). Hope that makes sense?
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

SteveHarle wrote: Mon Sep 21, 2020 8:07 am [ time=1600353558 user_id=75]
...
If you see a team has completely changed it's name, for example if "Tottenham Hotspur" changed to "Gareth Bale FC" - absolutely make a note of it - that would be very helpful and we will correct it, but it must be the same as Transfermarkt (whether it is right or wrong!). Hope that makes sense?
It makes a lot of sense as you say, better to use only one source so that the final result is more homogeneous. In case of substantial changes where and how can I report the change to you?
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

Stadium updates:

* Georgia
* Germany
* Ghana
* Greece
* Grenada
* Guadeloupe
* Guam
* Guatemala
* Guinea
* Guinea-Bissau
* Guyana
* Haiti
* Holland
* Honduras
* Hong Kong
* Hungary
* Iceland
* India
* Indonesia

DOWNLOAD
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

Stadium updates:

*Iran
*Iraq
*Israel
*Ivory Coast
*Jamaica

DOWNLOAD
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

Stadium updates:

*Jordan
*Kazakhstan
*Kenya
*Kosovo
*Kuwait
*Kyrgyzstan
*Laos
*Latvia
*Lebanon
*Lesotho
*Libya

DOWNLOAD
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

ok, I'm picky. Despite my meticulous research of some clubs I cannot find the stadium (I will send you new ones over the weekend). Thinking about how to solve this problem, it occurred to me that I could contact some of these teams via Facebook and ask them directly. Before proceeding I would like to ask your opinion. Do I do it or is it better to give up?
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

*Baw* wrote: Tue Oct 06, 2020 5:05 pm ok, I'm picky. Despite my meticulous research of some clubs I cannot find the stadium (I will send you new ones over the weekend). Thinking about how to solve this problem, it occurred to me that I could contact some of these teams via Facebook and ask them directly. Before proceeding I would like to ask your opinion. Do I do it or is it better to give up?
Since answers and advice are slow to arrive, as I said I tried to contact some teams on Facebook, I think I have sent a dozen messages with Messenger and FB, they are not very updated and the messages have not even been read ... the search goes come on. :D
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

Stadium updates:

*Lithuania
*Luxembourg
*Macau
*Madagascar
*Malawi
*Malaysia
*Maldives
*Mali

DOWNLOAD
User avatar
Redknapp69
Reserve Team Player
Posts: 265
Joined: Mon Jan 20, 2020 7:49 pm
Has thanked: 5 times
Been thanked: 2 times

Stadiums

Post by Redknapp69 »

*Baw* wrote: Tue Oct 06, 2020 5:05 pm ok, I'm picky. Despite my meticulous research of some clubs I cannot find the stadium (I will send you new ones over the weekend). Thinking about how to solve this problem, it occurred to me that I could contact some of these teams via Facebook and ask them directly. Before proceeding I would like to ask your opinion. Do I do it or is it better to give up?
Would any official (or not official) fan groups be an idea to contact if you really wanted to?
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

Redknapp69 wrote: Sat Oct 10, 2020 7:18 pm Would any official (or not official) fan groups be an idea to contact if you really wanted to?
Yours is a good idea too. First I try with the official club page, so we are 100% sure about the information received and it is also easier to find the page. In case I can't even do this I can try a fan page, although I think they are hard to find since usually the clubs that lack the stadium are small clubs from minor leagues of minor leagues.
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

Stadium updates:

*Malta
*Mauritius
*Mexico
*Moldova
*Mongolia
*Montenegro
*Montserrat
*Morocco
*Mozambique
*Myanmar
*Namibia
*Nepal
*New Caledonia
*New Zealand
*Nicaragua
*Niger
*Nigeria
*North Korea
*North Macedonia
*Northern Ireland
*Norway
*Oman

DOWNLOAD
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

Stadium updates:

- Pakistan
- Palestine
- Panama
- Papua New Guinea
- Paraguay
- Pays Basque
- Peru
- Poland
- Portugal
- Puerto Rico
- Qatar
- Republic of Ireland
- Réunion
- Romania
- Russia
- Rwanda
- Saint Lucia
- Saint-Martin
- Samoa

DOWNLOAD
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

Stadium updates:

- São Tomé & Principe
- Saudi Arabia
- Senegal
- Serbia
- Seychelles
- Sierra Leone
- Singapore
- Sint Maarten
- Slovakia
- Solomon Islands
- Somalia
- South Sudan
- Spain
- Sri Lanka
- St Kitts & Nevis
- St Vincent & The Grenadines
- Sudan
- Surinam
- Swaziland
- Sweden
- Switzerland
- Tahiti
- Tajikistan
- Tanzania
- Thailand
- The Congo
- The Gambia
- The Philippines
- Timor


DOWNLOAD
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

Stadium updates:

- Togo
- Tonga
- Trinidad & Tobago
- Tunisia
- Turkey
- Turkmenistan
- Turks and Caicos Islands
- Uganda
- Ukraine
- United Arab Emirates
- United States
- Uruguay
- US Virgin Islands
- Uzbekistan
- Vanuatu
- Venezuela
- Vietnam
- Wales
- Yemen
- Yugoslavia
- Zaire
- Zambia
- Zimbabwe

DOWNLOAD
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

... and this was the last part of the list of clubs I was able to track down. Those that I could not find I will try to contact them directly via Facebook, let's see how it will go.
User avatar
Redknapp69
Reserve Team Player
Posts: 265
Joined: Mon Jan 20, 2020 7:49 pm
Has thanked: 5 times
Been thanked: 2 times

Stadiums

Post by Redknapp69 »

Incredible work mate!
User avatar
SteveHarle
Reserve Team Player
Posts: 359
Joined: Mon May 04, 2020 10:02 pm
Location: Essex, England
Has thanked: 12 times
Been thanked: 2 times

Stadiums

Post by SteveHarle »

Baw, this is an unbelievable effort mate thank you!
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

I have tried to contact via Facebook or via email the clubs whose stadium I could not find, but almost no one has answered for the moment or have replied the boots, so I would say not to wait any longer for my updates on this, in case I receive any helpful answer we could always add them in next year's update.
User avatar
*Baw*
Decent Young Player
Posts: 57
Joined: Thu Jun 04, 2020 8:34 pm
Location: Italy
Has thanked: 5 times
Been thanked: 14 times

Stadiums

Post by *Baw* »

...By the way, I almost forgot that I found these too, I first put them here rather than send excel files....


Long Name | Short Name | Nationality | Stadium | City | Capacity
RUS Binche | Binche | Belgium | Stade Aimé Vachaudez | Binche10 | 1000
RUS Genly-Quévy 89 | Genly-Quévy | Belgium | Stade de La Motte | Genly100 | 1000
Ypiranga (SC) | Ypiranga (SC) | Brazil | Estádio Olímpico Colosso da Lagoa | Erechim | 25000
Post Reply