Estadi Comunal
Identity
- City
- Andorra la Vella
- Nation
- Andorra
- Capacity
- 1,299
- Seating capacity
- 1,299
- Expansion capacity
- 5,000
- Built
- —
- Owner club
- Fútbol Club Santa Coloma
- Ownership type
- Not set
- Nearby stadium
- —
A capacity of 0 is a stored zero and is shown as one; a blank is a value the export did not record.
Build dates run from the nineteenth century to dates in the game's future, and are shown as stored.
Pitch and roof
- Pitch type
- Synthetic soft
- Pitch length
- 1050 105 m, derived
- Pitch width
- 700 70 m, derived
- Pitch condition
- 200
- Covered
- —
- Under-soil heating
- —
- Retractable roof
- —
The source stores pitch dimensions in decimetres — Old Trafford, the Camp Nou and Wembley all hold 1050 by 680 —
so the stored number is shown first and the metre figure beside it is derived by this application, not something
the database contains. A stored 0 means the row has no dimensions and converts to nothing.
stadium.pitch_condition is a raw source scale running to 200 with no lookup table, and is printed as
stored.
Location
- Coordinates
- 42.501293, 1.513846
Resident clubs
Clubs come from club.stadium_uid. One shared ground in the data carries 119 of them, so the list is
paginated rather than loaded whole.
Teams based here
| Team | Container | Reputation |
|---|---|---|
| Andorra | Andorra National | — |
| Club Esportiu Principat B | Club Esportiu Principat | 420 |
| F.C. Lusitans B | Fútbol Club Lusitans | 500 |
| Fútbol Club Encamp B | Fútbol Club Encamp | 340 |
Teams come from club_team.stadium_uid, which only a small minority of squads populate. The
container column reads club_team.national first and then shows whichever of
club_uid or nation_uid that flag says is the populated one.