“Red zones” in Sicily: a story of civic hacking

Redazione Open Data Sicilia
Redazione Open Data Sicilia

Latest posts by Redazione Open Data Sicilia (see all)

    Note: this is a translation of an original piece published by Salvatore Fiandaca on the 10th April 2021. / Questa è una traduzione (più o meno letterale) di un articolo pubblicato da Salvatore Fiandaca il 10 aprile 2021. Thanks to Paola Chiara Masuzzo for translating it into English.


    If you live in Sicily and want to know if your city is currently red, i.e. under specific COVID-19 restrictions (Italy uses a colour coded schema), all you need to do is read 197 pages of PDF files published by the regional government.

    The official website of Sicily (Regione Siciliana) does not report any list of the cities currently red (which is the highest of the restrictions imposed): this information is trapped within a webpage that collects the so-called ‘ordinanze’ (we will refer to these documents as ‘decrees’ in the rest of this piece), a bunch of PDF files reporting the latest decisions made by the regional government.

    This list is not really updated: at noon on the 10th April 2021, the files of the 9th April (number 37 and 38) were still not available.

    A possible alternative way to consult these data is the map built by the ‘Dipartimento della Protezione Civile Regionale’, which, however, presents quite some limitations:

    • at 11:30 am on the 10th of April 2021, the map lists several cities that will only become red from the 11th of April, the following day
    • the map does not provide any information on the timeline of the restrictions: since when and until when the city has red zone restrictions; this information is absolutely key, and given the above point, we can’t even be sure that the map provides a precise photo of the current situation
    • it’s impossible, from the map, to go back to the files that delineate the restrictions, their timings, and their scope. It’s crucial to be able to link back this type of data to the raw, official source of information (especially given that this information is provided and published by the local authorities) 
    • the geographic representation of the map alone is not enough: a structured and updated list of files embedding the data represented is nowhere to be found

    So, we thought about it: https://tinyurl.com/zonerossesicilia


    Note: after the publication of the original post in Italian, the “Dipartimento della Protezione Civile Regionale” has updated its map, corrected it and added the necessary basic information. We appreciate that, it is a nice result of the action of this community.


    The documents that list the governmental decisions for the red zones in Sicily (often not even real PDF, but simply the result of the documents scanning) are collected on the official website under the section “SERVIZI INFORMATIVI | ORDINANZE COVID-19”; when this article was written (10th of April 2021), there were 36 of these files. 

    PDF files are not the easiest to read, especially if these are images (you can’t even search for text, in this latter case), not from machines, nor from humans, who would be lost in front of a big amount of bureaucratic jargon. So we thought of collecting all the cities in Sicily with red-zone restrictions in a public Google sheet.

    The PDF files are on average 7 pages long, the section that contains the useful data is usually in the last two pages:

    To remedy to these ugly PDF files (sigh) and make it easier to both create and read maps and structured lists of text, we created a Google sheet where we annotated (after having read every single PDF online from 2021) the cities in red code, together with the time interval, including the possible extension of the restrictions, and a final link to the decree file in PDF.

    The main idea is to create a list like the one shown in the screenshot below, allowing these data to become public goods, or, in Italian, ‘bene comune’ (Open Data Sicilia is a big promoter of the running campaign).

    What we would like to have is a dataset with at least the following five attributes:

    1. comune, the name of the city as reported in the PDF file
    2. pro_com, the unique, numeric ISTAT code
    3. dataInizio, the beginning date of the red code for the city
    4. dataFine, the end date of the red code for the city
    5. link, the URL of the PDF file.

    We read all the PDF of 2021 (28 at the time of writing of this piece) and it took us about one hour, certainly a reasonable amount of time.

    After we were done with the sheet, we initiated the second phase, which consisted in rendering these tabular data in a map easily accessible to everyone:

    Important to notice, it is possible to download both the entire dataset and the PDF for each city reported directly from the map

    Final notes

    Creating and publishing an up-to-date list, a CSV file – really, any kind of format of structured text that machines and humans can read – isn’t that much work, but is, first and foremost, a matter of providing a public service to the citizens, a service that is very much needed and due. 

    Scanned PDFs prevent text searches and make usability for blind people impossible. In our opinion, these two points alone suffice to say that Sicilian authorities need to do better, but there are also official regulations that point these matters out, like the Digital Administration Code (Codice dell’Amministrazione Digitale, CAD).

    These documents must be accessible and usable regardless of personal abilities, according to the accessibility criteria defined by the technical requirements referred in Article 11 of the Law of 9 January 2004, n. 4.

    For 2021, 16 out of 28 decrees are scanned.

    We therefore ask the Sicilian Region and the ‘Dipartimento della Protezione Civile Regionale’ to create a list of the red areas in the Sicilian territory, readable by people and personal computers, complete with the essential information that we have listed, in which it is also possible to read the temporal changes of the assignments of the restrictions.

    Finally, we also urge for a speedy solution of the aforementioned problems on accessibility.

    References

    The cover image of this piece refers to the situation until the 10th of April 2021, right before the decree number 38 of the 9th of April 2021.