LinkedSpending: OpenSpending becomes Linked Open Data
Konrad H¨
- ffner
October 5, 2013
Konrad H¨
- ffner
konrad.hoeffner@uni-leipzig.de
LinkedSpending: OpenSpending becomes Linked Open Data Konrad H - - PowerPoint PPT Presentation
LinkedSpending: OpenSpending becomes Linked Open Data Konrad H offner October 5, 2013 Konrad H offner konrad.hoeffner@uni-leipzig.de Open Spending Data government spending data available to everyone what amount of money spent for which
Konrad H¨
konrad.hoeffner@uni-leipzig.de
Konrad H¨
konrad.hoeffner@uni-leipzig.de
Konrad H¨
konrad.hoeffner@uni-leipzig.de
Konrad H¨
konrad.hoeffner@uni-leipzig.de
Konrad H¨
konrad.hoeffner@uni-leipzig.de
Konrad H¨
konrad.hoeffner@uni-leipzig.de
Konrad H¨
konrad.hoeffner@uni-leipzig.de
1still under development
Konrad H¨
konrad.hoeffner@uni-leipzig.de
information need SPARQL Query 1 all years which have
in the de-bund dataset from 2020 onwards s e l e c t d i s t i n c t ? date {?o a qb : Observation . ?o qb : dataSet l s : de−bund . ?o sdmxd : r e f P e r i o d ? date . FILTER ( xsd : date (? date ) >= ”2020−1−1”ˆˆxsd : date ) } 2 spendings of more than 100 billion e s e l e c t ∗ {?o l s o : amount ?a . ?o dbo : c u r r e n c y dbpedia : Euro . FILTER ( xsd : i n t e g e r (? a)>”1E11”ˆˆ xsd : i n t e g e r ) } 3 datasets with multiple years s e l e c t ?d count (? y ) as ? count { ?d a qb : DataSet . ?d l s o : r e f Y e a r ?y . } having ( count (? y)>1) 4 sums of amounts for each reference year of the dataset berlin de s e l e c t ?y (sum( xsd : i n t e g e r (? amount ) ) as ?sum) {?o qb : dataSet l s : b e r l i n d e . ?o l s o : r e f Y e a r ?y . ?o l s o : amount ?amou 5 datasets with curren- cies whose inflation rate is greater than 10 % s e l e c t d i s t i n c t ?d ? c ? r {?o qb : dataSet ?d . ?o dbo : c u r r e n c y ? c . ? c dbp : i n f l a t i o n R a t e ? r . f i l t e r (? r > 10)} 6 Berlin city subsectors
tion that have had their budget reduced from 2012 to 2013 . . . Konrad H¨
konrad.hoeffner@uni-leipzig.de
Konrad H¨
konrad.hoeffner@uni-leipzig.de