¿What are the data that appear in the reports? ¿Which variables do we have to look to? ¿What is their meaning? In this post (continuation of Visualising the anual account records of a municipality - Part II, we will look at the data we extracted to understand what are we going to visualize.
In Spain, account reports of anual revenue and expenses of the municipalities and other public organizations are monitored by the Tribunal de Cuentas and their regional delegations. These account reports are available at rendiciondecuentas.es, but in a not-very-friendly format if what you want is to download the information for analysis. If you write to the different delegations they can prepare the data in the format you want, but here we will look at a method to extract that information directly from the web and process it.
When we create a blog, one of the most important features we need is usually a comment system so that visitors can write their suggestions and share their ideas, questions or advice about what we write. Grav has the JSComments plugin that can be set to integrate with Disqus, IntenseDebate, Facebook and Muut and generate comment strings for each of our posts. Here we explain how to install the plugin in GRAV from the command line and how to set it up to add comments to each of our posts using Disqus as an example.
Grav is a rising in popularity CMS, characterized for being file based (doesn't need a database to run). It uses the template generation tool Twig, and supports Markdown for content editing. It a very light management system, very easy to set up and to use. It also has great documentation and a very active support community. This guide shows how to install Apache, PHP, and set up our web using GRAV in a virtual server Debian 7.