![Page 1: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/1.jpg)
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 AthensUSING OPEN DATA: policy modeling, citizen empowerment, data journalism, Brussels,
19,20/6/12
![Page 2: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/2.jpg)
Apps, Apps, Apps…..
2
![Page 3: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/3.jpg)
WHERE MY MONEY GOES in Greece publicspending.gr
• the first LOD App in Greece• daily updates• open spending linked data,
endpoint & visualizations
3
![Page 4: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/4.jpg)
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 pdf
2. TAXIS (official Tax Information System)VAT number validation and profile request
4
![Page 5: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/5.jpg)
Just numbers…
Spending decisions: 1.521.556
Spending amount: ~ 27 billion euros
RDF Triples: 42.252.565Payers: 31.115
Payees: 374.729Active CPV categories: 6.323 / 9.454Active CPA categories: 1.642/(~10.000)
5
![Page 6: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/6.jpg)
Website live
6
![Page 7: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/7.jpg)
Classification of products by ActivityPAYERS
7
![Page 8: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/8.jpg)
Classification of products by ActivityPAYEES
8
![Page 9: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/9.jpg)
Query for top CPV Code 45000000-7 “Construction Works” and its substituent cpv codes
9
![Page 10: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/10.jpg)
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
![Page 11: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/11.jpg)
Dbpedia query http://dbpedia.org/sparql
11
select * where{ ?mun dbpprop:popMunicipality ?a .FILTER(?a>90000 && ?a <120000)}
![Page 12: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/12.jpg)
Comparative statistics
12
![Page 13: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/13.jpg)
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
![Page 14: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/14.jpg)
public spending: results
14
![Page 15: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/15.jpg)
public spending: comparisons
• Litchfield repair expenses = 0.44%
• Kalithea repair expenses = 0.54%
• Can you think of others?
15
![Page 16: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/16.jpg)
WHERE MY MONEY GOESinterlinking business in global scale
• building a Greek business repository (ongoing)
• examining global interconnections (e.g. Open
Corporates, CPA->NAICS)
16
![Page 17: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/17.jpg)
some last thoughts
ofirst 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
![Page 18: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/18.jpg)
?
18
![Page 19: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/19.jpg)
appendix
19
![Page 20: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/20.jpg)
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
![Page 21: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/21.jpg)
Counting spending decisions
21
![Page 22: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/22.jpg)
22
publicspending.gr architecture
![Page 23: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/23.jpg)
Ontology
obuild on the approach of the UK payment ontology and Core Bus. Voc.
oCPV, CPAoWESO PSC ontology, OC, data
cube, Organization ontology, …
23
![Page 24: The case of Publicspending.gr: Greek public spending in a nutshell M. VafopoulosM. Vafopoulos, M. Meimaris, A. Papantoniou, I. Anagnostopoulos,I. Anagnostopoulos](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b8034550346a10a8b510c/html5/thumbnails/24.jpg)
24
publicspending.gr ontology