the case of publicspending.gr : greek public spending in a nutshell
DESCRIPTION
The case of Publicspending.gr : Greek public spending in a nutshell. M. Vafopoulos , M. Meimaris , A. Papantoniou , I. Anagnostopoulos , G. Alexiou , I. Avraam , I. Xidias , G. Vafeiadis and V. Loumos National Technical University of Athens - PowerPoint PPT PresentationTRANSCRIPT
The case of Publicspending.gr: Greek
public spending in a nutshell
M. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,
G. Alexiou, I. Avraam, I. Xidias, G. Vafeiadis and V. LoumosNational Technical University of Athens
USING OPEN DATA: policy modeling, citizen empowerment, data journalism, Brussels, 19,20/6/12
Apps, Apps, Apps…..
2
WHERE MY MONEY GOES in Greece publicspending.gr
• the first LOD App in Greece• daily updates• open spending linked data,
endpoint & visualizations
3
WHERE MY MONEY GOES in Greece publicspending.gr
• Input 1.“Diavgeia” (all public spending decisions online daily )ΕΧ-ΑΝΤΕ, API, average data quality, rich information• Payer, payee (amount, VAT number, name)• CPA 2008: Classification of products by Activity• CPV 2008: Common Procurement Vocabulary• Original decision text in pdf2. TAXIS (official Tax Information System)
VAT number validation and profile request
4
Just numbers…Spending decisions: 1.521.556Spending amount: ~ 27 billion euros RDF Triples: 42.252.565Payers: 31.115Payees: 374.729Active CPV categories: 6.323 / 9.454Active CPA categories: 1.642/(~10.000)
5
Website live
6
Classification of products by ActivityPAYERS
7
Classification of products by ActivityPAYEES
8
Query for top CPV Code 45000000-7 “Construction Works” and its substituent cpv codes
9
WHERE MY MONEY GOESlocal spending in EU level
demo ① Litchfield district–NUTS LAU1 region–population ≈100k
② Find places with similar characteristics in Greece
(Dbpedia)10
Dbpedia query http://dbpedia.org/sparql
11
select * where{ ?mun dbpprop:popMunicipality ?a .FILTER(?a>90000 && ?a <120000)}
Comparative statistics
12
public spending
SPARQL Query about Kalithea in publicspending.gr and in the Litchfield endpoint
• not compatible product/service classifications (ontology alignment needed)
• Litchfield decisions: >500 £• Kalithea decisions: no limitations
13
public spending: results
14
public spending: comparisons
• Litchfield repair expenses = 0.44%
• Kalithea repair expenses = 0.54%
• Can you think of others?15
WHERE MY MONEY GOESinterlinking business in global scale
• building a Greek business repository (ongoing)
• examining global interconnections (e.g. Open
Corporates, CPA->NAICS)
16
some last thoughtsofirst App on the Greek LODo try to initiate the virtuous cycle
of creationoco-operations &
interconnections are in the top of our agenda
oget people to be involved
17
?
18
appendix
19
Checklist ① Ontology – enriching with core vocub. ② Basic visualizations ③ SPARQL endpoint - thedatahub④ Interconnections– Product classifications – Open Corporates– Greek LOD (e-proc, geodata, dbpedia)– EU and US (CPV -> NAICS)
⑤ Demos & services⑥ Public awareness - working with the media ,
hackathons, courses, theses 20
Counting spending decisions
21
22
publicspending.gr architecture
Ontologyobuild on the approach of the UK
payment ontology and Core Bus. Voc.
oCPV, CPAoWESO PSC ontology, OC, data
cube, Organization ontology, …
23
24
publicspending.gr ontology