BIG DATA EUROPEPILOT SC6: CITIZEN BUDGET ON MUNICIPAL LEVEL
MICHALIS VAFOPOULOS SOFTWARE AND KNOWLEDGE ENGINEERING LABORATORYNATIONAL CENTER FOR SCIENTIFIC RESEARCH “DEMOKRITOS”
Economy (data) in new contextBDE SC6 workshop on 5.12 in Cologne
Today: Web 2.5
mobile low costfallacy
not only contentCONTEXT
Data: big, open, linked Big: scale Open: access Linked: use
Economic Data: current status Big, Open, but heterogeneous &
immature
Bridging data gaps Create a common vocabulary to link data
from different sourcese.g. supplier=payee=ανάδοχος=proveedor
Build constant & automatic connections to data sources (data stream)
You: from comments to data stories
Your Data stories in brief
Orchestration Interlinking data, experts, audience & social media (Linked Data)
Sustainabilitybusiness models (e.g. freemium & app market)
YourDataStories project in action
1-click provenance
Public contracts 3.0: social + gov. data
How? The LinkedEconomy model
A common semantic model that captures an integrated view of the economic activity and is:
o Economic-theory driveno Based on existing vocabularieso Structured and open development
process (GitHub)o Easy to be consumed by any systemo Scalable and reusable 1 mai 2023
LinkedEconomy model
1 mai 2023
LinkedEconomy model analysed
1 mai 2023
BDE piltot: Idea & ObjectivesState of the Art
o Budget: the most important document of public policy
o Budget execution affects everyday liveso Citizens are more involved in city level
activitiesObjectiveCan we make budgets more useful for citizens, researchers and decision makers?
1 mai 2023
The main aspects Create an online Dashboard on
Economic Datao Harvest – heterogeneous formats o Normalise – RDF o Link & map the data – attributes & structureo Analyse the data – custom comparisons &
predictionso Visualise – online dashboardo Procide raw data – further re-use as open
data1 mai 2023www.big-data-
europe.eu
Potential users & usagesCitizens & Journalists
o Infographics & simplified analysis Decision makers (politics & business)
o Financial ratiosResearchers
o Detailed & aligned datasets in machine-readable format 1 mai 2023
Data used / produced in Pilot
Budget Data and Budget Execution Data Municipality of Athens, Greece
o Description: budget execution data in detail (account level)o Frequency: dailyo Ownership: openo Format: API
Municipality of Thessaloniki & Kalamaria, Greeceo Description: budget execution data in detail (account level) o Frequency: dailyo Ownership: openo Format: csv, xls (files for download provided)
1 mai 2023www.big-data-europe.eu
• Additional Open Data o Description: LOD Greek Census 2011o Ownership: openo Format: RDF o E.g. population per municipality
• Size of Datao ~ 7 MB / week
From mass input to fine output
1 mai 2023
Expense code
Description Budgeted Committed
Approved
Spending
6011 Regular salaries €17,696,000
€17,696,000
€2,865,379
€1,436,983
0111
Rentals from residential real estate
€17,696 €17,696 €17,696 €17,696
0114Rentals of municipal market
€17,696 €17,696 €17,696 €17,696
0115
Rentals of the allocation of communal areas for the placement of advertising media
€17,696 €17,696 €17,696 €17,696
Revenue code
Description Budgeted Approved Spending
0621 Coverage spending of welfare benefits
€68,317,583
€11,707,243
€11,707,243
…
Financial Ratio (2015)
City of Athens
City of Thessaloniki
City of Kalamaria
Revenues per capita
€ 643 € 825 €
338
Two H2020 projects working together on the SC6 Pilot
• Big Data Europe
• Your Data Stories
SC6 Pilot core team: Ivana Versic (Cessda), Michalis Vafopoulos (NCSR-D), Martin Kaltenböck (SWC), Jürgen Jakobitsch (SWC), Hossein Abroshan (Cessda)
SC6 Pilot Partners
Questions
Let us discuss!
1 mai 2023www.big-data-europe.eu
Contact & Links: NCSR-D, http://www.demokritos.gr/?lang=en Michalis Vafopoulos, vafopoulos.org, [email protected]
https://github.com/BDE-social-pilothttps://github.com/YourDataStories
1 mai 2023www.big-data-europe.eu
