Lessons learnt building and maintaining National Treasury’s open budget data viz portal

A video talk given at the recent PyCon conference in Durban about an application developed for National Treasury:

We built an open data visualisation portal for National Treasury – https://vulekamali.gov.za/. Vulekamali had to make a range of structured and semi-structured data, and many other files, easily accessible to everyone in South Africa. And in ways that are meaningful both to experienced data analysts, as well as someone who never did high school accounting.

We built this using Django as a core component that manages and pulls together data from an open source Python data management system (CKAN) and an open fiscal data query platform (OpenSpending).

In this talk we share the architecture and implementation decisions that paid off, and the decisions we still regret, as well as our thoughts on how we could improve on them.

We’ll cover things like building a system to handle partial data, automating bulk file uploads, how hard it is to get people to format data correctly, and giving them helpful feedback automatically.

Source code at https://github.com/vulekamali/static-budget-portal

Watch the video at https://www.youtube.com/live/JSfg-H5XIHI

#python #django #nationaltreasury #budget

French Ministry of Foreign Affairs launches open source toolbox to fight disinformation

Source: French Ministry of Foreign Affairs

On the occasion of the 2019 European elections and ahead of France’s 2022 presidential elections, the French Ministry of Foreign Affairs launched in 2019 a toolbox of open source software and open resources to fight disinformation. As of December 2021, Internet users can access software to detect fake Twitter accounts, assess the legality of political advertisement on Facebook, and use multiple further resources on good practices to counter disinformation. Further work is ongoing to develop and deploy additional online resources.

Fake news, disinformation, misinformation: in the past decade, the manipulation of publicly available information on online platforms and social media soared tremendously in Europe and beyond. In 2018, 83% of respondents to a Eurobarometer survey indicated that fake news represent a danger to democracy.

See https://joinup.ec.europa.eu/collection/open-source-observatory-osor/news/disinfo-open-toolbox-fight-disinformation

The north-German state of Schleswig-Holstein plans to switch to open source software, including LibreOffice, in its administration and schools

In doing so, the state wants to reduce its dependence on proprietary software, and eventually end it altogether. By the end of 2026, Microsoft Office is to be replaced by LibreOffice on all 25,000 computers used by civil servants and employees (including teachers), and the Windows operating system is to be replaced by GNU/Linux.

The necessary steps for this are specified in the planning of the Schleswig-Holstein state parliament (German), as digital minister Jan Philipp Albrecht explains in an interview with c’t.

German State moving to LibreOffice

See https://blog.documentfoundation.org/blog/2021/11/18/german-state-planning-to-switch-25000-pcs-to-libreoffice/

In the spirit of open government, France dumps 9,067 repos online with public sector open-source code, to show off its FOSS credentials

The release happened as a result of a decree of Open Government from 30 October 2019 after the French government joined the Open Government Partnership in April 2014. After two years of work, the site hit version 1.0 on Wednesday.

This really allows further re-use of publicly funded code, and also serves as a boost for their own small businesses who want to make use of it for themselves or to serve their customers.

See https://www.theregister.com/2021/11/11/french_government_foss/

#opensource #opengovernment #france #publicsector

A Fresh Look at FOSS Policy Failure in the SA Government

A presentation by Dr Derek W. Keats on an ecosystem approach to FOSS policy failure in the South African government. Watch at https://youtu.be/1bUMnpAgwK0 or click below.

An ecosystem approach to FOSS policy failure in the South African government

Very Positive To See An Open Source Tender Advertised By SANParks

The organisation is also looking for an accredited service provider for the provision of open source e-business technologies on an on-demand basis for a period of three years.
Non-compulsory briefing: 21 Feb
Tender no: GNP- 039- 19
Information: Technical: Nedret Saidova, Tel: (012) 426 5283, E-mail: Nedret.Saidova@sanparks.org. General: Quinton Chetty, Tel: (012) 426 5247, E-mail: Quinton.Chetty@sanparks.org.
Closing date: 6 Mar 2020

‘SA needs tech boost in case Trump recalls US companies’ says SA Comms Minister Stella Ndabeni-Abrahams

Communications minister Stella Ndabeni-Abrahams  is concerned that SA relies heavily on software produced by the West or the East and says its time government focuses on home-grown technologies.

Her reasoning is that if US president Donald Trump, for example, was to prevent all US companies from operating in SA, the country could be in trouble.

Our view is that open source software offers the ideal vehicle for this as it’s already available, in use in many enterprises as well as governments, and can be modified for use within South Africa without starting from scratch. No-one can disable or refuse our access to open source software, and this also gives South Africa an opportunity to contribute back to open source communities globally. Open source would also mean that South Africa cannot be held hostage even by local vendors (which has happened in the past). Savings from existing annual licensing can be ploughed into this initiative as local economic investment.

See the media article at https://www.dispatchlive.co.za/news/2020-01-30-sa-needs-tech-boost-in-case-trump-recalls-us-companies/

SA Gov FOSS Policy Annex A: Policy on Free and Open Source Software Use for South African Government

Published in August 2006 by the National Department of Public Service and Administration (DPSA). It outlines the background leading up to the approval of the policy.