TIBHannover / confiDent-dataimports

Query data donators for Scientific Events. Map those events to aeon ontology. Export to Mediawiki pages.
0 stars 0 forks source link

What other external IDs are present in wikidata instance of scientific conference series #18

Open andrecastro0o opened 4 years ago

andrecastro0o commented 4 years ago

By studying WikiCFP conference series ID we can see that, WikiCFP conference series ID is:

Hence we could ask in SPARQL query to all other instance of scientific conference series what are the instance of : "Wikidata property for an identifier" `


The formater URL property could also be used in issue 16 http://wikicfp.com/cfp/program?id=$1

andrecastro0o commented 4 years ago

lost :{

SELECT DISTINCT ?item ?prop ?val  ?isInstance ?idprop ?idpropLabel

# prop wikicfp id wdt:P5127

WHERE
{
    ?item wdt:P31 wd:Q47258130.
    ?item ?prop "2212" . 

  # lets ask questions about ?prop

#     wdt:P5127 ?propprop ?propval .

#     ?prop wdt:P31 ?isInstance .
#   {
#     SELECT ?idprop 
#     WHERE { ?prop wdt:P31 wd:Q19847637 .}
#   }
#      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 100

https://stackoverflow.com/questions/56310085/find-wikidata-properties-with-sparql-and-use-them-in-the-same-query-or-using-a might offer some clues


SELECT DISTINCT ?item ?prop ?val  ?propprop ?propval
# ?isInstance ?idprop ?idpropLabel

# prop wikicfp id wdt:P5127

WHERE
{
    ?item wdt:P31 wd:Q47258130.
    ?item ?prop "2212" . 
    ?prop ?propprop ?propval . 

  # lets ask questions about ?prop

#     wdt:P5127 ?propprop ?propval .

#     ?prop wdt:P31 ?isInstance .
#   {
#     SELECT ?idprop 
#     WHERE { ?prop wdt:P31 wd:Q19847637 .}
#   }
#      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 100
andrecastro0o commented 4 years ago

From https://www.wikidata.org/wiki/Q17087718 ?prop and ?val: select those with datatype = xsd:string.

Identifiers tend to be strings

SELECT DISTINCT ?item ?prop ?val ?d 
# prop wikicfp id wdt:P5127

WHERE
{
    wd:Q17087718 ?prop ?val .

   FILTER (DATATYPE(?val) = xsd:string).
   BIND(DATATYPE(?val) as ?d ). 
  }
LIMIT 100

See: https://www.wikidata.org/wiki/Wikidata:Identifiers

https://www.wikidata.org/wiki/Special:ListDatatypes

https://en.wikibooks.org/wiki/SPARQL/Property_paths