Wikidata:WikiProject Bulgaria/Administrative Entities/Maintenance

Maintenance of Bulgarian Administrative Entities

Data sources

• Kmetstvo : https://www.nsi.bg/nrnm/ekatte/town-halls ek_kmet.xlsx
• Populated Place : https://www.nsi.bg/nrnm/ekatte/territorial-units ek_atte.xlx
• Settlement Formation : https://www.nsi.bg/nrnm/ekatte/territorial-formations

Updating Kmetstvo

1. Reconcile ek_kmet.xlsx using values in ekatte column

select ?s ?sid {
  ?x p:P3990 ?st .
  ?st pq:P518 wd:Q4224624 ; ps:P3990 ?ekatte .
  filter not exists { 
    ?st prov:wasDerivedFrom ?ref_ekatte .
    ?ref_ekatte pr:P813 ?date 
  }  
  bind(strafter(str(?x),str(wd:)) as ?qid)
  bind(replace(strafter(str(?st),str(wds:)),concat(?qid,"-"),concat(?qid,"\\$")) as ?sid)
  bind(concat("-STATEMENT") as ?s)
}

Try it!