Stadt, Land, Fluss (web)

Stadt, Land, Fluss für den Browser.

In einem Browser Spiel hosten und Kategorien festlegen
Mit anderen Browsern dem Spiel beitreten
Fertig

Features

Live-Anzeige wann Mitspieler Antworten einloggen
Bonus-Punkte auf Basis von Antwortreihenfolge
Standard-Punkte (0, 5, 10, 20) wie üblich manuell vergeben

Technik

Implementiert mit PeerJS
UI mit BULMA

WIP Notes

functional improvements
- ...

Ideas

columns with assigned score check/functions
- change game.columns from a list of strings to a list of (<column name>, <scoring function>) tuples
- in the server UI, let the user set one column after the other (new input once a column is defined)
  - input: column name (text input) and a scoring function (dropdown)

API based porperty retrieval

Wikidata

General
- browse
- query w/ SPARQL

Data coverage tests

Cities

initial tests

City: 9,100
- w/ population: 5,995
also City?
City or town: 1,284
- w/ population: 1,341 (?!)
Municipality: 561
- seems to be the transitive parent class of at least Germany cities
Human settlement: 569,669
- w/ population: 75,476
- w/ coordinate location: 436,697
- w/ inception: 4,045
- w/ elevation above sea level: 146,370
- w/ area: 17.093
- ~~w/ attribute “located in or next to body of water”: 1.236~~ seems very unreliable

Query

SELECT (COUNT(?city) AS ?count)
WHERE
{
  ?city wdt:P31 wd:Q486972.
  ?city wdt:P1082 ?population.
}

Query for number of municipalities with population information (208,673).
(using human settlement, only 89,706)

SELECT (COUNT(?mu) AS ?count)
WHERE
{
  ?submu wdt:P279* wd:Q15284.
  ?mu wdt:P31 ?submu.
  ?mu wdt:P1082 ?population.
}

Municipalities next to or in a body of water (Germany as example). As below includes rivers which could be filtered.

SELECT ?mu ?muLabel ?wtrLabel
WHERE
{
  ?musubclass wdt:P279* wd:Q15284.
  ?mu wdt:P31 ?musubclass.
  ?mu wdt:P17 wd:Q183. # P17: "country", Q183: "Germany"
  ?mu wdt:P206 ?wtr.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en". }
}

Types of X

SELECT ?subcls ?subclsLabel
WHERE
{
  ?subcls wdt:P279* wd:Q15324.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}

Gewässer
- Ozean
- Wasserfall
- Flussarm
- Priel
- Bucht
- Loch (e.g. Loch Ness)
- Sumpf
- Eisberg
- Unterwasser-Solebecken
- Wellenbad
- Privatbrunnen
Naturerscheinung
- Leben
- Föhn
- Dämmerung
- Bodenerosion
- Doppelregenbogen
- Sternfleck
- Superblüte
- Sonnenwende
- Gravitationskollaps
- Haarfarbe
- Heißer Tag
- Eiallergie
- Eifersuchtswahn
geografische Entität von Menschenhand
- Kornkreis
- Mautbrücke
- Zoo

Entertainment

TV series by number of episodes

SELECT ?tvseries ?tvseriesLabel ?numeps
WHERE
{
  ?subcls wdt:P279* wd:Q5398426.
  ?tvseries wdt:P31 ?subcls.
  ?tvseries wdt:P1113 ?numeps.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}
ORDER BY DESC(?numeps)
LIMIT 100000

IllDepence/slf_web