stade Marcel-Deflandre (Q3495729)

  • matcher place: Charente-Maritime (relation 7431), La Rochelle (relation 117858), La Rochelle (relation 1661547), Communauté d'agglomération de La Rochelle (relation 1918944)
  • view on Wikidata
  • Wikipedia: English, French, Italian, Portuguese
  • Wikimedia Commons
  • English Wikipedia categories: Buildings and structures in La Rochelle, French sports venue stubs, Rugby union stadiums in France, Rugby union stubs, Sports venues completed in 1926, Sports venues in Charente-Maritime, Stade Rochelais, Tourist attractions in La Rochelle
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,46.15806,-1.17806)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,46.15806,-1.17806)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,46.15806,-1.17806)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,46.15806,-1.17806)[sport][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,46.15806,-1.17806)[sport][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,46.15806,-1.17806)[sport][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,46.15806,-1.17806)["amenity"="community_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,46.15806,-1.17806)["amenity"="community_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,46.15806,-1.17806)["amenity"="community_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,46.15806,-1.17806)["amenity"="events_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,46.15806,-1.17806)["amenity"="events_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,46.15806,-1.17806)["amenity"="events_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,46.15806,-1.17806)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,46.15806,-1.17806)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,46.15806,-1.17806)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,46.15806,-1.17806)["landuse"="recreation_ground"][name];
    way(around:1000,46.15806,-1.17806)["landuse"="recreation_ground"][name];
    rel(around:1000,46.15806,-1.17806)["landuse"="recreation_ground"][name];
    node(around:1000,46.15806,-1.17806)["leisure"="sports_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,46.15806,-1.17806)["leisure"="sports_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,46.15806,-1.17806)["leisure"="sports_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,46.15806,-1.17806)[leisure=stadium][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,46.15806,-1.17806)[leisure=stadium][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,46.15806,-1.17806)[leisure=stadium][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,46.15806,-1.17806)[tourism=attraction][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,46.15806,-1.17806)[tourism=attraction][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,46.15806,-1.17806)[tourism=attraction][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,46.15806,-1.17806)[tourism=museum][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,46.15806,-1.17806)[tourism=museum][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,46.15806,-1.17806)[tourism=museum][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from Français / French Wikipedia (frwiki)

Le stade Marcel-Deflandre est le principal stade de la ville de La Rochelle. Il est situé à l'ouest de la ville et est aujourd'hui uniquement destiné au rugby à XV.

Summary from English Wikipedia (enwiki)

Stade Marcel-Deflandre is a sports stadium in La Rochelle, France. It was built by Emile Sourcile. It is the home ground of rugby union team Stade Rochelais of the Top 14 who have played there since it was opened in 1926. It has undergone significant redevelopment since 1995 and the present capacity is 16,000 (2,500 added during summer 2014). The stadium is named after Marcel Deflandre, a president of the club who was executed in 1944 during the Second World War.

Wikidata location: 46.1581, -1.1781 view on OSM or edit on OSM

matches

login to upload wikidata tags

found 2 match candidates

way: Stade Marcel-Deflandre (OSM)exact location match [show tags]
lit: yes
name: Stade Marcel-Deflandre
sport: rugby_union
source: cadastre-dgi-fr source : Direction Générale des Impôts - Cadastre;mise à jour : 2008
leisure: pitch
surface: grass
way: Stade Marcel-Deflandre (OSM)exact location match [show tags]
name: Stade Marcel-Deflandre
leisure: sports_centre

Search criteria from Wikidata

view with query.wikidata.org

sports venue (Q1076486) sport, sport=multi, leisure=sports_centre
event venue (Q18674739) amenity=events_venue
sports location (Q23764314) sport, sport=multi
building (Q41176) building=yes, building
stadium (Q483110) building=stadium, leisure=stadium

Search criteria from categories

Rugby union stadiums in France landuse=recreation_ground, sport, leisure=sports_centre, leisure=stadium, amenity=community_centre
Sports venues completed in 1926 landuse=recreation_ground, sport, leisure=sports_centre, leisure=stadium, amenity=community_centre
Sports venues in Charente-Maritime landuse=recreation_ground, sport, leisure=sports_centre, leisure=stadium, amenity=community_centre
Tourist attractions in La Rochelle tourism=museum, tourism=attraction