Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Adjust Wikidata query to also cover non-administrative areas of NRW #764

Closed
acka47 opened this issue Mar 8, 2018 · 7 comments

Comments

Projects
None yet
2 participants
@acka47
Copy link
Contributor

commented Mar 8, 2018

Sub-issue of #627.

See #627 (comment) for the list of area types to be covered.

@acka47 acka47 self-assigned this Mar 8, 2018

@acka47 acka47 added the working label Mar 8, 2018

@acka47

This comment has been minimized.

Copy link
Contributor Author

commented Mar 8, 2018

Started working on this. Before adjusting the wikidata query more, I will have to see how many and which strings are associated with notations that are not 99,97,96 (i.e. I have to update the last column in #627 (comment)).

acka47 added a commit that referenced this issue Mar 8, 2018

First adjustments to the SPARQL query
See #764.
Using p:/ps: instead of wdt: and adding areas from the catholic and protestant church.
@acka47

This comment has been minimized.

Copy link
Contributor Author

commented Mar 15, 2018

We can get the "Evangelische Kirchenkreise" listed in https://gist.github.com/acka47/86552f99092a2900a6137a2a58cedb08 with this query:

SELECT ?item ?itemLabel
WHERE {
  { ?item wdt:P361 wd:Q1380992 }
  UNION
  { ?item wdt:P361 wd:Q1381014 }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],de". }
}

Try it!

@acka47

This comment has been minimized.

Copy link
Contributor Author

commented Mar 15, 2018

Manual matching for GSW of n28 (see here):

@acka47

This comment has been minimized.

Copy link
Contributor Author

commented Mar 15, 2018

Manual matching for GSW of n52 (see here):

@acka47

This comment has been minimized.

Copy link
Contributor Author

commented Mar 15, 2018

Manual matching for GSW of n72 (see here):

@acka47 acka47 added ready and removed working labels Mar 19, 2018

@acka47

This comment has been minimized.

Copy link
Contributor Author

commented Apr 16, 2018

Manual matching for n74 (see here):

"Nassau-Siegen | 74" http://www.wikidata.org/entity/Q736029
"Grafschaft Rietberg | 74" http://www.wikidata.org/entity/Q457468
"Grafschaft Tecklenburg | 74" http://www.wikidata.org/entity/Q881030
"Grafschaft Limburg | 74" http://www.wikidata.org/entity/Q315663 (Da scheint aber in Wikidata einiges durcheinander zu sein, siehe den "Nachfolger" und die Entstehungsdaten.)
"Grafschaft Sayn-Wittgenstein-Berleburg | 74" http://www.wikidata.org/entity/Q48755303
"Herrschaft Rheda | 74" http://www.wikidata.org/entity/Q932656
"Herrschaft Gemen | 74" http://www.wikidata.org/entity/Q477038
"Grafschaft Arnsberg | 74" http://www.wikidata.org/entity/Q315288
"Grafschaft Lingen | 74" http://www.wikidata.org/entity/Q879507
"Grafschaft Sayn-Wittgenstein-Hohenstein | 74" http://www.wikidata.org/entity/Q16831619
"Grafschaft Pyrmont | 74" http://www.wikidata.org/entity/Q825489
"Herrschaft Lembeck | 74" null (gibt nur Schloss Lemberg
"Grafschaft Wittgenstein | 74" null Es gibt nur Wittgensteiner Land
"Grafschaft Sayn-Wittgenstein | 74" null
"Grafschaft Steinfurt | 74" http://www.wikidata.org/entity/Q1614442
"Fürstentum Minden | 74" http://www.wikidata.org/entity/Q876546
"Staat Waldeck | 74" ??
"Herrschaft Volmarstein | 74" null
"Grafschaft Sayn-Wittgenstein-Wittgenstein | 74" null (nur Sayn-Wittgenstein)
"Fürstentum Salm | 74" http://www.wikidata.org/entity/Q11026135
"Fürstentum Rheina-Wolbeck | 74" http://www.wikidata.org/entity/Q628609
"Herrschaft Canstein | 74" null (nur Schloss Canstein
"Nassau-Dillenburg | 74" http://www.wikidata.org/entity/Q328545
"Herrschaft Anholt | 74" null (nur Anholt)
"Grafschaft Schwalenberg | 74" http://www.wikidata.org/entity/Q1541799
"Grafschaft Grönebach | 74" null
"Grafschaft Dortmund | 74" http://www.wikidata.org/entity/Q1265044
"Herrschaft Büren | 74" http://www.wikidata.org/entity/Q1020946
"Herrschaft Lembeck | 74" null (wie oben, (gibt nur Schloss Lemberg)
"Grafschaft Sternberg | 74" http://www.wikidata.org/entity/Q1452958
"Herrschaft Horstmar | 74" gibt nur Salm-Horstmar
"Herrlichkeit Heessen | 74" null (gibt nur Schloss Heessen)
"Grafschaft Sayn-Wittgenstein-Sayn | 74" null (nur Sayn-Wittgenstein)
"Grafschaft Sayn-Altenkirchen | 74" http://www.wikidata.org/entity/Q544579

@acka47

This comment has been minimized.

Copy link
Contributor Author

commented Apr 16, 2018

We can get the "Katholische Bistümer/Diözesen" (n36) with this query:

SELECT ?item ?itemLabel
WHERE {
  ?item wdt:P31/wdt:P279* wd:Q3146899 ;
        p:P131 ?inS .
  ?inS ps:P131 wd:Q1198 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],de". }
}

Try it!

@acka47 acka47 added working and removed ready labels Apr 17, 2018

acka47 added a commit that referenced this issue Apr 17, 2018

@acka47 acka47 added review and removed working labels Apr 17, 2018

@acka47 acka47 removed their assignment Apr 17, 2018

@dr0i dr0i closed this in #805 Apr 19, 2018

@dr0i dr0i removed the review label Apr 19, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.