Wikidata:WikiProject Rowing/organizations

WikiProject Rowing

WikiProject start page • participants • statistics • l10n

• core items
• equipment
• people
• venues
• organizations
• teams
• boat classes
• competition classes
• regattas & events
• results
• meta items

Structural items

• “rowing organization”
  • rowing association (Q43445087) (all associations which do not fall into a subcategory)
    • rowing club (Q7372078) (Category:Rowing clubs (Q8683575); associations which actively exercise rowing)
    • rowing governing body (Q21281028) (Category:Rowing governing bodies (Q8683645); associations with governing and sanctioning power over the sport of rowing in some region)
  • companies, manufacturers (Category:Rowing equipment manufacturers (Q8683641))
    • RowPerfect (Q7371747), Concept2 (Q81003), Croker (Q5187535), Empacher (Q454811), Filippi Boats (Q1413764), Vespoli (Q7923317), Eton Racing Boats (Q5404800), Hudson Boatworks (Q5928581), Janousek Racing Boats (Q6155304), Levator Boatworks (Q6534945), Lola Aylings (Q3836503), Pocock Racing Shells (Q7206497), Resolute Racing Shells (Q7315666), Stämpfli Racing Boats (Q7629911), Sykes Racing (Q7660516), WinTech Racing (Q8023611), BBG Bootsbau Berlin (Q795618), …
  • training bases (Bundesstützpunkt Dortmund (Q1006316), Ruderakademie Ratzeburg (Q1522329), Trakų ISM (Q12675234), …)
  • regional rowing (rowing in the Faroe Islands (Q361819), university rowing in the United Kingdom (Q7896791), women's rowing in Australia (Q8031229), college rowing in the United States (Q5146905), …)
  • rowing families (see Wikidata:WikiProject Rowing/people for modelling)
  • rowing teams (see Wikidata:WikiProject Rowing/teams)
  • peer group rowing (women's rowing (Q12398903))

How to tag

For rowing clubs we may start tagging using the next scheme. Feel free to add more properties or discuss what you want.

Overview: Wikidata:List of properties/Organization. Important for rowing organisations:

1. Tag as a rowing club:
   • instance of (P31): rowing club (Q7372078) used for pure rowing clubs
   • instance of (P31): sports club (Q847017) + sport (P641): rowing (Q159354) if the club is not only for rowing (you can add other sports)
2. Formation:
   • inception (P571)
   • founded by (P112)
   • location of formation (P740)
   • separated from (P807), if the club was created from another
3. Place information:
   1. headquarters location (P159) with the next qualifiers: (try to put most of them to have a good map of clubes)
      • coordinate location (P625)
      • P969 (P969) (full street address)
      • postal code (P281) or location (P276)
      • located in the administrative territorial entity (P131)
      • country (P17)
      • located in or next to body of water (P206) (The lake, river, sea, harbor... the body of water where the team rows)
4. Images (tbd).
   • logo image (P154) Logo
   • P:rowing blade?: To be discussed or find another existing property to use for the picture of the rowing blade
5. Legal information
   • legal form (P1454) (values depend on country)
   • native label (P1705)
6. Contact information
   • phone number (P1329)
   • official website (P856)
7. Social media
   • Facebook username (P2013)
   • Instagram username (P2003)
   • X username (P2002)
   • YouTube channel ID (P2397)
   • Google+ ID (P2847)

Already tagged

Rowing clubs and sports clubs with rowing departments

SELECT DISTINCT ?item ?itemLabel ?countryLabel ?locationLabel ?headquarters ?coordinates WHERE {
  { ?item wdt:P31 wd:Q7372078 } UNION { ?item wdt:P31 wd:Q847017; wdt:P641/wdt:P279* wd:Q159354 } UNION { ?item p:P31 [ ps:P31 wd:Q847017; pq:P641/wdt:P279* wd:Q159354 ] } .
  OPTIONAL { { ?item wdt:P17 ?country } UNION { ?item p:P159 [ pq:P17 ?country ] } }
  OPTIONAL { ?item wdt:P131 ?location }
  OPTIONAL { ?item wdt:P159 ?headquarters }
  OPTIONAL { { ?item wdt:P625 ?coordinates } UNION { ?item p:P159 [ pq:P625 ?coordinates ] } }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} ORDER BY ASC(?countryLabel) ASC(?itemLabel)

Try it!

International (con)federations

SELECT ?item ?itemLabel WHERE {
  ?item wdt:P31 wd:Q21281028 , wd:Q11422536 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}

Try it!

National federations

tbd