Skip to content

Instantly share code, notes, and snippets.

@pwalsh
Last active February 25, 2016 14:21
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pwalsh/9c23ba38b8e053ed66ff to your computer and use it in GitHub Desktop.
Save pwalsh/9c23ba38b8e053ed66ff to your computer and use it in GitHub Desktop.
OpenSpending and OpenBudgets.eu Roadmap alignment

OpenSpending and OpenBudgets.eu Roadmaps

Some links to work in progress:

2015 December

OpenSpending

  • Data Migration
    • Current database ported to FDP
    • Current database available from OS Datastore
    • Current OpenSpending read-only
  • Fiscal Data Packager
    • Multiple files
    • Concept groups (multiple fields)
    • Concept hierarchies (nested relationships)
  • Fiscal Data Package Viewer
    • Directly from FDP using local storage
  • Fiscal Data JS
    • Works with CSV and FDP
  • Cosmopolitan API
    • First iteration providing countries, continents, currencies, polygons

OpenBudgets.eu

Month 8
  • D1.8 Linking data structure definitions to vocabularies (UEP)

2016 January

  • OS: By end of January, we have an operational way to import data and basic visualisations over the data.

OpenSpending

  • OS Import
    • Wraps Fiscal Data Packager
    • Writes datapackage.json and data sources to OS Datastore
    • Requires authz for write, and auth to identify user
  • OS Authz
    • Add user ID integration
    • Hand out JWT for various consumers (OS Datastore CLI, OS Import)
  • OS Registry
    • Lists all packages in OS Datastore
    • Detail view for each package based on Fiscal Data Package Viewer
      • Preview file(s) with data pipes
      • Export data
  • Visualisation Libs (getting "essential" coverage of previous OpenSpending Vis)
    • Bubble Tree
    • Treemap
    • Pie/Bar/Line
    • Other simple things

OpenBudgets.eu

Month 9
  • No deliverables

2016 February

  • OS: By end of February, we have an operational API compatible with the current OpenSpending API, based on SpenDB.

OpenSpending

  • OS API
    • SpendDB API as OS API
    • Populate SpenDB when package hits OS Datastore
  • OS Package Editor
    • SpenDB Pivot Table
      • Integrate with Fiscal Data JS/Package Viewer components
  • OS Registry
    • Various search and filter functions of registry

OpenBudgets.eu

  • No deliverables
Month 10
  • D1.9 Linking code lists to external datasets (UEP)
  • D2.1 Tools for semantic lifting of multi-format budgetary data (UBONN)

2016 March

  • OS: By end of March, we have an operational API to search metadata across packages.

OpenSpending

  • OS API
    • Cross-package API
  • OS Cosmopolitan
    • Inflation indicators
    • Socio-economic indicators
    • Population indicators
  • OS Reconcile
    • Code lists for classification dimensions
      • How to map? Nomenklatura?

OpenBudgets.eu

Month 11
  • No deliverables

2016 April

  • OS: By end of April, we have an operational, experimental API to do comparative queries.
  • OS & OB.eu: roundtrip RDF <> FDP. Get OB.eu data into OpenSpending.
  • OB.eu: Serious work on components for the platform under WP4 starts (7 months to prototype).

OpenSpending

  • OS API
    • Comparative queries
    • Not applicable to all datasets (need some core requirements)
    • Using Redshift, Elastic Search, or similar

OpenBudgets.eu

Month 12
  • D2.2 Data optimisation, enrichment and preparation for analysis (UEP)
  • D2.3 Requirements for statistical analytics and data mining (UBONN)

2016 May

OpenSpending

  • OS DataMine
    • Adhoc query interface over all data
    • Investigative work

OpenBudgets.eu

Month 13
  • No deliverables

2016 June

OpenSpending

  • OS Pipelines
    • Pipelines to get data into Fiscal Data Package from other formats in a semi-automated fashion

OpenBudgets.eu

Month 14
  • No deliverables

2016 July

OpenSpending

  • No deliverables

OpenBudgets.eu

Month 15
  • No deliverables

2016 August

OpenSpending

  • No deliverables

OpenBudgets.eu

Month 16
  • D3.2 Visualisations creation framework (OKGR)

2016 September

OpenSpending

  • No deliverables

OpenBudgets.eu

Month 17
  • No deliverables

2016 October

OpenSpending

  • No deliverables

OpenBudgets.eu

Month 18
  • D3.3 Comparative analysis presentation and creation tools (OKGR)
  • D3.6 Spending and budget visualisation social network features (OKGR)
  • D4.3 Integrated OpenBudgets.eu Platform - Prototype (OKGR)

2016 November

OpenSpending

  • No deliverables

OpenBudgets.eu

Month 19
  • No deliverables

2016 December

OpenSpending

  • No deliverables

OpenBudgets.eu

Month 20
  • D2.4 Data mining and statistical analytics techniques (UBONN)
  • D3.4 Packaging specifications (J++)
  • D3.5 Demonstration visualisations (J++)

2017 January

OpenSpending

  • No deliverables

OpenBudgets.eu

Month 21
  • No deliverables

2017 February

OpenSpending

  • No deliverables

OpenBudgets.eu

Month 22
  • No deliverables

2017 March

OpenSpending

  • No deliverables

OpenBudgets.eu

Month 23
  • No deliverables

2017 April

OpenSpending

  • No deliverables

OpenBudgets.eu

Month 24
  • D2.5 Data mining interfaces (UEP)
  • D4.4 OpenBudgets.eu Platform documentation (OKGR)
  • D4.5 Integrated OpenBudgets.eu Platform - Final (OKGR)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment