The kit is a set of documents describing the process, methods and techniques for implementing a policy of open data within an institution. He is primarily focused on organs and entities of the federal public administration for the creation and implementation of their respective Plans Open Data (PDAs), but tries to be generic enough so you can be leveraged in other institutions.
Background and objective
Publishing open data is present in the new digital government of Brazil and several countries worldwide trend strategy. His commitment was made by President Dilma at the signing of the statement of the Open Government Partnership (OGP) and the various organs of the executive in both the Partnership Action Plans.
The recommendation of the Presidency and the Ministry of Planning, Budget and Management is that public managers deal with the agenda of creating Open Data Plans in their organizations.
Organizations developing Open Data Plans need guidance, methods and techniques for their creation and implementation. The proposal of the Kit is to provide the necessary inputs for these moments and serve as a guide for future reference.
Definitions and concepts
1 What is open data - Basic Settings on characteristics of open data 2 Advantages of publishing open data 3 Open Government Partnership - About the International Partnership 4 The Brazilian Open Data Portal - About the catalog data 5 What is the National Infrastructure Open Data - INDA 6 Glossary of the terms used in this kit
Guide to implementation of a Plan of Open Data
The creation and implementation of a Plan of Open Data for an institution can be organized into activity streams as in the following diagram:
This process can be seen in greater detail in the document Systemic Process Plan Open Data - PDA.
The following sub-processes are detailed:
Tools
This section is an illustrative and non-exhaustive list of useful tools for projects opening data. All are free tools, created by communities free software, and can be used by government agencies without restriction. In general, solutions for extraction, handling and preparation of data for publication on the Internet. The list is based on the Open Project Data and ODI open date Review tech. However, is restricted to tools that can be used without the need for programming knowledge.
Creation of open data APIs
- API to CSV - Dynamically generates static Restful APIs CSVs files
- Sandman - Creates Restful API automatically from connecting to relational databases
Data Conversion
- JSON-to-CSV Converter - Converter manual and online JSON files to View member as spreadsheet and download it in CSV format.
- Dat - Tool for conversion and transformation of data from the command line
- Csvkit - Transformations and treatment of csv files
- ESRI2Open - tool that converts spatial data and non-spatial ESRI software owner on open data files, CSV, JSON or GeoJSON
Sanitizing data
- Open Refine - Cleaning and data transformation, unification of duplicate records, etc.
More Resources
- Guide to Open Data (Date open Handbook) - the open Knowledge
- Manual of open data: Government - the W3C Brazil
Published PDAs
Related Legislation
- Access to Information Act - Provides for access to public information, including the Internet
- Decree No. 7724 - Regulates Law of access to information under the federal executive power
- Instruction of INDA - Establishes the National Infrastructure of open data and its operation
- Decree of September 15, 2011 - Establishes the CIGA and the National Plan for Open Government