[Wikidata-bugs] [Maniphest] [Commented On] T211178: WDQ CONSTRUCT times out

[VladimirAlexiev]

VladimirAlexiev added a comment.


  Use construct when you want to get an rdf graph out of the repo, especially 
when you want the data to be shaped differently or to use  ontology terms 
different  from the original

TASK DETAIL
  https://phabricator.wikimedia.org/T211178

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: VladimirAlexiev
Cc: Esc3300, Liuxinyu970226, Acka47, Aklapper, VladimirAlexiev, darthmon_wmde, 
Premeditated, Nandana, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Jonas, Xmlizer, 
jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T211178: WDQ CONSTRUCT times out

[Esc3300]

Esc3300 added a comment.


  Independently of the above, is there a way to use CONSTRUCT ?
  
  I haven't figured out how it works and when it could be useful.

TASK DETAIL
  https://phabricator.wikimedia.org/T211178

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Esc3300
Cc: Esc3300, Liuxinyu970226, Acka47, Aklapper, VladimirAlexiev, darthmon_wmde, 
alaa_wmde, Nandana, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Jonas, Xmlizer, 
jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T211178: WDQ CONSTRUCT times out

[Acka47]

Acka47 added a comment.
I can confirm that the CONSTRUCT query times out. Also, it is not giving an error message so that you first think everything should be fine. I am running into a similar problem as Vladimir with the following query using curl in the command line (see also this Github comment and the one afterwards):

$ curl -H "Accept: text/turtle" -G "https://query.wikidata.org/sparql" --data-urlencode query='
CONSTRUCT {
?lobidURI a skos:Concept ;
skos:inScheme  ;
skos:prefLabel ?wikidataURILabel ;
foaf:focus ?wikidataURI ;
skos:notation ?QID ;
skos:broader ?broaderURI .
  }
WHERE {
 {
  { ?wikidataURI wdt:P131* wd:Q1198 . }
   UNION
  { ?wikidataURI p:P131 [ ps:P131 wd:Q1198 ] . }
  { ?wikidataURI p:P31 [ ps:P31 wd:Q829277 ] . } # Regierungsbezirk in NRW
  UNION
  { ?wikidataURI p:P31 [ ps:P31 wd:Q106658 ] . } # Landkreis in Deutschland 
  UNION
  { ?wikidataURI p:P31 [ ps:P31 wd:Q5283531 ] . } # Landkreis in Preußen
  UNION
  { ?wikidataURI p:P31 [ ps:P31 wd:Q262166 ] . } # Gemeinde in Deutschland
  UNION
  { ?wikidataURI p:P31 [ ps:P31 wd:Q22865 ] . } # kreisfreie Stadt in Deutschland
  UNION
  { ?wikidataURI p:P31 [ ps:P31 wd:Q253019 ]. } # Ortsteil
  UNION
  { ?wikidataURI p:P31 [ ps:P31 wd:Q2983893 ]. } # Stadtteil
  UNION
  { ?wikidataURI p:P31 [ ps:P31 wd:Q42744322 ]. } # Stadtgemeinde Deutschlands
  UNION
  { ?wikidataURI p:P31 [ ps:P31 wd:Q134626 ]. } # Kreisstadt
  UNION
  { ?wikidataURI p:P31 [ ps:P31 wd:Q448801 ]. } # Große Kreisstadt
  UNION
  { ?wikidataURI p:P31 [ ps:P31 wd:Q1548518 ]. } # Große kreisangehörige Stadt
  UNION
   { ?wikidataURI p:P31 [ ps:P31 wd:Q54935786 ]. } # Mittlere kreisangehörige Stadt
  UNION
  { ?wikidataURI p:P31 [ ps:P31 wd:Q1852178 ] . } # Stadteil von Düsseldorf
  UNION
  { ?wikidataURI p:P31 [ ps:P31 wd:Q15632166 ] . } # Stadtteil von Köln
  UNION
 { ?wikidataURI p:P31 [ps:P31 wd:Q1780389 ] . } # Kommunalverband der besonderen Art (derzeit nur "Städteregion Aachen")
   UNION
   { ?wikidataURI wdt:P31/wdt:P279*  wd:Q4286337 . } # Stadtbezirk, für Geocache auskommentieren
  OPTIONAL  { ?wikidataURI wdt:P131 ?broader . }
 }
# FILTER (?wikidataURI in (wd:Q1295))
 FILTER (?wikidataURI != wd:Q1787449 && ?wikidataURI != wd:Q16500124 && ?wikidataURI != wd:Q1465811 && ?wikidataURI != wd:Q1787449
   && ?wikidataURI != wd:Q16832627 && ?wikidataURI != wd:Q1113210 && ?wikidataURI != wd:Q19288281 && ?wikidataURI != wd:Q1662807
&& ?wikidataURI != wd:Q1351319 ) # Herausfiltern von Altkreisen, die namensidentisch sind mit Neukreisen
 BIND (STRAFTER (STR(?wikidataURI),"entity/") AS ?QID)
 BIND (STRAFTER (STR(?broader),"entity/") AS ?broaderQID)
 BIND (URI(CONCAT ("http://purl.org/lobid/nwbib-spatial#", ?QID)) AS ?lobidURI)
 BIND (URI(CONCAT ("http://purl.org/lobid/nwbib-spatial#", ?broaderQID)) AS ?broaderURI)
 SERVICE wikibase:label {  bd:serviceParam wikibase:language "de" }
}'

I only get back the fully constructed statements for around 1650 resources while for the other 6671 resources I only get the skos:prefLabel statement.TASK DETAILhttps://phabricator.wikimedia.org/T211178EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Acka47Cc: Acka47, Aklapper, VladimirAlexiev, Nandana, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, Jonas, Xmlizer, jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs