OpenRefine

From EU Knowledge Graph
Revision as of 08:56, 26 June 2022 by Admin (talk | contribs)
Jump to navigation Jump to search

This page contains instructions to connect OpenRefine to edit the Eu Knowledge Graph.

Requirements

Setup

  • Upload you data. For example
    • Create Project
    • Clipboard
    • Insert the data in the Table below
    • Next
    • Create Project
entity program cci website
https://linkedopendata.eu/entity/Q2463293 2014GR16M1OP001 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/Greece/2014GR16M1OP001
https://linkedopendata.eu/entity/Q2463518 2014TC16I5CB001 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB001
https://linkedopendata.eu/entity/Q2463519 2014TC16I5CB002 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB002
https://linkedopendata.eu/entity/Q2463520 2014TC16I5CB003 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB003
https://linkedopendata.eu/entity/Q4294076 2014TC16I5CB004 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB004
https://linkedopendata.eu/entity/Q2463524 2014TC16I5CB005 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB005
https://linkedopendata.eu/entity/Q2463525 2014TC16I5CB006 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB006
https://linkedopendata.eu/entity/Q2463526 2014TC16I5CB007 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB007
https://linkedopendata.eu/entity/Q2463529 2014TC16I5CB008 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB008
https://linkedopendata.eu/entity/Q2463530 2014TC16I5CB009 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB009
https://linkedopendata.eu/entity/Q2463531 2014TC16I5CB010 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16I5CB010
https://linkedopendata.eu/entity/Q2463534 2014TC16M4TN001 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16M4TN001
https://linkedopendata.eu/entity/Q2463535 2014TC16M4TN002 https://ec.europa.eu/regional_policy/EN/atlas/programmes/2014-2020/europe/2014TC16M4TN002
  • Configure the Eu Knowledge Graph as a Wikibase
    • On the top right click on the Extensions Wikidata button and select "Select Wikibase instance"
    • Add Wikibase
    • Paste
{
   "version":"1.0",
   "mediawiki":{
      "name":"EU Knowledge Graph",
      "root":"https://linkedopendata.eu/wiki/",
      "main_page":"https://linkedopendata.eu/wiki/Main_Page",
      "api":"https://linkedopendata.eu/w/api.php"
   },
   "wikibase":{
      "site_iri":"https://linkedopendata.eu/entity/",
      "tag":"",
      "maxlag":5,
      "properties":{
         "instance_of":"P35",
         "subclass_of":"P302"
      },
      "constraints":{
         "property_constraint_pid":"P861",
         "exception_to_constraint_pid":"P406",
         "constraint_status_pid":"P1150",
         "mandatory_constraint_qid":"Q236765",
         "suggestion_constraint_qid":"Q236827",
         "distinct_values_constraint_qid":"Q196794"
      }
   },
   "reconciliation":{
      "endpoint":"https://openrefine-reconciliation.linkedopendata.eu/${lang}/api"
   },
   "editgroups":{
      "url_schema":"([[:toollabs:editgroups/b/OR/${batch_id}|details]])"
   }
}

Reconcile your data

Model your data using the Wikibase Schema

Upload your data