KM Wikidata export: Difference between revisions

From Inguma Wikibase
Line 48: Line 48:
}    order by ?doi  
}    order by ?doi  
</sparql>
</sparql>
= Find Wikidata-creator using ORCID =
<sparql tryit="1">
PREFIX iwb: <https://wikibase.inguma.eus/entity/>
PREFIX idp: <https://wikibase.inguma.eus/prop/direct/>
PREFIX ip: <https://wikibase.inguma.eus/prop/>
PREFIX ips: <https://wikibase.inguma.eus/prop/statement/>
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/>
select distinct ?wb_item ?title ?doi ?wd_item ?wd_doi
where {
 
   
  ?wb_item idp:P5 iwb:Q5.
filter not exists {  ?wb_item idp:P1 ?linked_wd.}
  ?wb_item idp:P39 ?orcid.
 
#  bind(iri(concat(str(wd:),?linked_wd)) as ?wd_item)
  SERVICE <https://query.wikidata.org/sparql> {
          select * where
                            {?wd_item wdt:P496 ?orcid.
  } }
}    order by ?orcid
</sparql>
= Find Wikidata-creator using inguma =
= Find Wikidata-creator using inguma =
<sparql tryit="1">
<sparql tryit="1">

Revision as of 17:28, 2 November 2024

KM aipatzen duten ASJU artikuluak

PREFIX iwb: <https://wikibase.inguma.eus/entity/>
PREFIX idp: <https://wikibase.inguma.eus/prop/direct/>
PREFIX ip: <https://wikibase.inguma.eus/prop/>
PREFIX ips: <https://wikibase.inguma.eus/prop/statement/>
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/>

select distinct ?aipatzen_duena  ?title ?data (group_concat(distinct strafter(str(?egilea),str(iwb:))) as ?egileak)
?issue ?sp ?ep
where {
  ?oocc_item ip:P89 ?oocc_st.
    
  ?aipatzen_duena idp:P37 iwb:Q13228; idp:P62 [idp:P88* ?oocc_item].
  filter not exists {?aipatzen_duena idp:P1 ?wd.}
  
  ?aipatzen_duena idp:P19 ?data; idp:P17 ?egilea; idp:P10 ?title. filter(lang(?title)="eu")
  ?aipatzen_duena idp:P20 ?doi.
  optional {?aipatzen_duena idp:P26 ?issue.}
  optional {?aipatzen_duena idp:P27 ?sp.}
  optional {?aipatzen_duena idp:P28 ?ep.}

}  
group by ?aipatzen_duena ?title ?data ?egileak ?issue ?sp ?ep

Try it!

Find Wikidata-article using DOI

PREFIX iwb: <https://wikibase.inguma.eus/entity/>
PREFIX idp: <https://wikibase.inguma.eus/prop/direct/>
PREFIX ip: <https://wikibase.inguma.eus/prop/>
PREFIX ips: <https://wikibase.inguma.eus/prop/statement/>
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/>

select distinct ?wb_item ?title ?doi ?wd_item ?wd_doi
where {
  
    
   ?wb_item idp:P37 iwb:Q13228; idp:P62 ?cit.
 filter not exists {   ?wb_item idp:P1 ?linked_wd.}
   ?wb_item idp:P19 ?data; idp:P10 ?title. filter(lang(?title)="eu")
  ?wb_item idp:P20 ?doi. bind (ucase(?doi) as ?wd_doi)  
#  bind(iri(concat(str(wd:),?linked_wd)) as ?wd_item)
  SERVICE <https://query.wikidata.org/sparql> {
           select * where
                            {?wd_item wdt:P356 ?wd_doi.
   } }

}     order by ?doi

Try it!

Find Wikidata-creator using ORCID

PREFIX iwb: <https://wikibase.inguma.eus/entity/>
PREFIX idp: <https://wikibase.inguma.eus/prop/direct/>
PREFIX ip: <https://wikibase.inguma.eus/prop/>
PREFIX ips: <https://wikibase.inguma.eus/prop/statement/>
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/>

select distinct ?wb_item ?title ?doi ?wd_item ?wd_doi
where {
  
    
   ?wb_item idp:P5 iwb:Q5.
 filter not exists {   ?wb_item idp:P1 ?linked_wd.}
   ?wb_item idp:P39 ?orcid.
  
#  bind(iri(concat(str(wd:),?linked_wd)) as ?wd_item)
  SERVICE <https://query.wikidata.org/sparql> {
           select * where
                            {?wd_item wdt:P496 ?orcid.
   } }

}     order by ?orcid

Try it!


Find Wikidata-creator using inguma

PREFIX iwb: <https://wikibase.inguma.eus/entity/>
PREFIX idp: <https://wikibase.inguma.eus/prop/direct/>
PREFIX ip: <https://wikibase.inguma.eus/prop/>
PREFIX ips: <https://wikibase.inguma.eus/prop/statement/>
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/>

select distinct ?egilea ?egilea_label ?wd ?wikidata ?inguma ?ing_wikidata

where {
  ?oocc_item ip:P89 ?oocc_st.

  ?aipatzen_duena idp:P37 iwb:Q13228; idp:P62 [idp:P88* ?oocc_item].


  ?aipatzen_duena idp:P19 ?data; idp:P17 ?egilea; idp:P10 ?title. filter(lang(?title)="eu")
  ?egilea rdfs:label ?egilea_label. filter(lang(?egilea_label)="en")
  optional {?egilea idp:P3 ?inguma.}
  optional {

   SERVICE <https://query.wikidata.org/sparql> {
           select ?ing_wikidata ?inguma where
                            {?ing_wikidata wdt:P7558 ?inguma.}
   } }
   optional {?egilea idp:P1 ?wd. bind(iri(concat(str(wd:),?wd)) as ?wikidata)}
  
  }

Try it!

Find KM items not linked to OOCC

PREFIX iwb: <https://wikibase.inguma.eus/entity/>
PREFIX idp: <https://wikibase.inguma.eus/prop/direct/>

select ?older ?olderLabel 
where {?aip idp:P62 ?older. ?older idp:P17 iwb:Q201. 
       filter not exists {?older idp:P88 ?oocc .} # exclude items linked to OOCC
       filter not exists {?older idp:P89 ?oocc_id .} # exclude OOCC items themselves
       filter not exists {?contained idp:P42 ?older .} # exclude containers
       
       SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". }
      } group by ?older ?olderLabel

Try it!


Export ASJU articles (for articles-to-wikidata.py)

PREFIX iwb: <https://wikibase.inguma.eus/entity/>
PREFIX idp: <https://wikibase.inguma.eus/prop/direct/>
PREFIX ip: <https://wikibase.inguma.eus/prop/>
PREFIX ips: <https://wikibase.inguma.eus/prop/statement/>
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/>

select distinct ?aipatzen_duena ?wd ?inguma ?title ?data (group_concat(distinct concat('"',?sordinal,'": "',?wd_egilea,'"'); SEPARATOR=", ") as ?wd_egileak)
?issue ?sp ?ep ?doi
where {
  

  ?aipatzen_duena idp:P37 iwb:Q13228; idp:P62 ?cit.

  ?aipatzen_duena idp:P19 ?data; ip:P17 [ips:P17 ?egilea; ipq:P36 ?sordinal]; idp:P10 ?title. filter(lang(?title)="eu")
  ?aipatzen_duena idp:P20 ?doi.
  ?egilea idp:P1 ?wd_egilea.
  filter not exists {?aipatzen_duena idp:P1 ?wd.}
  optional {?aipatzen_duena idp:P12 ?inguma.}
  optional {?aipatzen_duena idp:P26 ?issue.}
  optional {?aipatzen_duena idp:P27 ?sp.}
  optional {?aipatzen_duena idp:P28 ?ep.}

}
group by ?aipatzen_duena ?wd ?inguma ?title ?data ?wd_egileak ?issue ?sp ?ep ?doi

Try it!

Export OOCC articles (for oocc-to-wikidata.py)

PREFIX iwb: <https://wikibase.inguma.eus/entity/>
PREFIX idp: <https://wikibase.inguma.eus/prop/direct/>
PREFIX ip: <https://wikibase.inguma.eus/prop/>
PREFIX ips: <https://wikibase.inguma.eus/prop/statement/>
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/>

select distinct ?oocc_item ?title (lang(?title) as ?title_lang) ?wd_lang (group_concat(distinct concat('"',?sordinal,'": "',?wd_egilea,'"'); SEPARATOR=", ") as ?wd_egileak)
?pag ?oocc (count(?citing) as ?citations) (min(xsd:integer(?regexdata)) as ?data) ?wd_container ?oocc_wd
where {
  

  ?oocc_item idp:P42 ?oocc.
  ?oocc_item ip:P89 ?oocc_st.
  ?oocc_st ips:P89 ?oocc_id.
  ?oocc_st ipq:P75 ?oocc_text.
  bind(replace(?oocc_text, "(.*)(19[0-9][0-9])(.*)", "$2") as ?regexdata)
  ?km_item idp:P88* ?oocc_item.
  ?citing idp:P62 ?km_item.
  ?km_item idp:P19 ?old_date.
  ?oocc idp:P1 ?wd_container.
  ?oocc_item ip:P17 ?creator_st. 
  optional {?creator_st ips:P17 ?egilea.} 
  optional {?creator_st ipq:P36 ?sordinal.} 
  ?oocc_item idp:P10 ?title.
  ?oocc_item idp:P16 [idp:P1 ?wd_lang].
    
  ?egilea idp:P1 ?wd_egilea.
  # filter not exists {?oocc_item idp:P1 ?wd.}
  optional {?oocc_item idp:P12 ?inguma.}
  optional {?oocc_item idp:P26 ?issue.}
  optional {?oocc_item idp:P80 ?pag.}
  optional {?oocc_item idp:P1 ?oocc_wd.}
 
}
group by ?oocc_item ?title ?wd_lang ?wd_egileak ?pag ?oocc  ?citations ?data ?wd_container ?oocc_wd
order by desc(?citations)

Try it!

Export citations (for citation-to-wikidata.py)

PREFIX iwb: <https://wikibase.inguma.eus/entity/>
PREFIX idp: <https://wikibase.inguma.eus/prop/direct/>
PREFIX ip: <https://wikibase.inguma.eus/prop/>
PREFIX ips: <https://wikibase.inguma.eus/prop/statement/>
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/>

select distinct ?aipatzen_duena ?aipatzen_duenaLabel (group_concat(?egileaLabel; SEPARATOR=", ") as ?egileak) (year(?data) as ?urtea) ?oocc_item ?oocc_title ?wd_cit_iturri ?wd_cit_xede
where {
  ?oocc_item ip:P89 ?oocc_st.
  ?oocc_st ips:P89 ?oocc_id.
  ?oocc_st ipq:P75 ?oocc_text.
  ?oocc_item idp:P10 ?oocc_title.
  ?oocc_item idp:P1 ?wd_cit_xede.
  
  ?aipatzen_duena idp:P62 [idp:P88* ?oocc_item].
  ?aipatzen_duena idp:P19 ?data; idp:P17 [rdfs:label ?egileaLabel]. filter(lang(?egileaLabel)="eu")
  optional {?aipatzen_duena idp:P1 ?wd_cit_iturri.}
  
 SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". }
}  
group by ?aipatzen_duena ?aipatzen_duenaLabel ?egileak ?data ?oocc_item ?oocc_id ?oocc_title ?wd_cit_iturri ?wd_cit_xede
order by ?aipatzen_duena

Try it!

Retrieved from "https://wikibase.inguma.eus/w/index.php?title=KM_Wikidata_export&oldid=150355"