User:Fexpr/KeibaProject

The goal of this project is to import the data related to horse racing (particularly in Japan) into Wikidata.
I will provide this page with more information as the project goes.

Structure and properties

Breeder dataset

Completing the breeder (horse stud farm dataset) from Japanese Wikipedia, JBIS, Umanity, netkeiba

Basic:

• Label: en, ja, id, fr, de
• Description: en ("horse stud farm in...."), id ("peternakan kuda di....")
• Also known as: fill with appropriate values (if any)

Statements:

• instance of (P31) fill with horse stud farm (Q108696)
• country (P17) fill with corresponding country (for now, most of it was filled with Japan (Q17)
• location (P276) fill with the item of the town
• official website (P856) fill with the official website stated in Wikipedia's article, and check whether the link is obsolete or not
• coordinate location (P625) fill with the coordinates taken from Maps

Identifier:

• Twitter (X) username (P2002) fill with Twitter username
• Instagram username (P2003) fill with Instagram username
• Ameblo username (P3502) fill with Ameblo username
• (to do) propose new identifier for breeder ID in Japan Bloodstock Information System, Umanity, and netkeiba.

Horse dataset

Completing the race horse dataset from Japanese Wikipedia, JBIS, Umanity, netkeiba

Basic:

• Label: en, ja, id, fr, de
• Description: en ("Japanese Thoroughbred race horse...."), id ("kuda pacu ....")
• Also known as: fill with appropriate values (if any)

SPARQL Query

List of horse stud farms in Japan

#List of all horse stud farms in Japan
SELECT DISTINCT ?stud ?studLabel ?studDescription ?studLabel_ja ?website ?locationLabel
WHERE {
	?stud wdt:P31/wdt:P279* wd:Q108696 ;
		wdt:P17 wd:Q17
	OPTIONAL {
		?stud rdfs:label ?studLabel_ja filter (lang(?studLabel_ja) = "ja")
	}
    OPTIONAL {
		?stud wdt:P856 ?website
	}
    OPTIONAL {
		?stud wdt:P276 ?location
	}
	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "en,ja" .
	}
}

Try it!

Show the location of horse stud farms in Japan, with its information

#Locations of horse stud farm all over Japan
#defaultView:Map
SELECT ?stud ?studLabel ?studDescription ?studLabel_ja ?countryLabel ?website ?coord ?article
WHERE {
	?stud wdt:P31/wdt:P279* wd:Q108696 ;
		wdt:P17 wd:Q17
	OPTIONAL {
		?stud rdfs:label ?studLabel_ja filter (lang(?studLabel_ja) = "ja")
	}
    OPTIONAL {
		?article schema:about ?stud .
        ?article schema:isPartOf <https://ja.wikipedia.org/>.
	}
    OPTIONAL {
		?stud wdt:P856 ?website
	}
    OPTIONAL {
		?stud wdt:P625 ?coord
	}
	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "en,ja" .
	}
}

Try it!