Skip to content

Example: Foreign Aid and R&D Budgets

Timothy Lebo edited this page Feb 14, 2012 · 9 revisions
csv2rdf4lod-automation is licensed under the [Apache License, Version 2.0](https://github.com/timrdf/csv2rdf4lod-automation/wiki/License)

See Examples.

(results):

prefix rdf:        <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix muo:        <http://purl.oclc.org/NET/muo/muo#>
prefix base_vocab: <http://logd.tw.rpi.edu/vocab/>

select ?provider ?quantity ?units ?recipient ?purpose
where {
  graph <http://logd.tw.rpi.edu/source/data-gov/dataset/1554/version/2011-Jan-12> {
    ?aid 
      a                    base_vocab:Transaction ;
      base_vocab:provider  ?provider ;
      rdf:value            ?quantity;
      muo:measuredIn       ?units;
      base_vocab:recipient ?recipient;
      base_vocab:purpose   ?purpose
  }
}

results of same query above, but with graph http://logd.tw.rpi.edu/source/dfid-gov-uk/dataset/statistics-on-international-development-2009/version/2009-Nov-10

results - as csv:

prefix rdf:        <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix owl:        <http://www.w3.org/2002/07/owl#>
prefix dcterms:    <http://purl.org/dc/terms/>
prefix muo:        <http://purl.oclc.org/NET/muo/muo#>
prefix base_vocab: <http://logd.tw.rpi.edu/vocab/>

select ?provider ?quantity ?units ?recipient ?time ?purpose ?dataset

where {
  { graph <http://logd.tw.rpi.edu/source/dfid-gov-uk/dataset/statistics-on-international-development-2009/version/2009-Nov-10> {
    ?aid 
      a                      base_vocab:Transaction ;
      base_vocab:provider    ?provider ;
      rdf:value              ?quantity;
      muo:measuredIn         ?units;
      base_vocab:recipient   [ owl:sameAs ?recipient ];
      dcterms:temporal       ?time;
      base_vocab:purpose     ?purpose;
      dcterms:isReferencedBy ?dataset
  }
  } union {
  graph <http://logd.tw.rpi.edu/source/data-gov/dataset/1554/version/2011-Jan-12> {
    ?aid 
      a                      base_vocab:Transaction ;
      base_vocab:provider    ?provider ;
      rdf:value              ?quantity;
      muo:measuredIn         ?units;
      base_vocab:recipient   [ owl:sameAs ?recipient ];
      dcterms:temporal       ?time;
      base_vocab:purpose     ?purpose;
      dcterms:isReferencedBy ?dataset
  } }
}
Clone this wiki locally