SDG content

The objective of this recently incorporated interface (2021) is to incorporate the data structure of the Sustainable Development Goals (SDGs) and goals of the 2030 Agenda into the CONSUL DEMOCRACY information architecture.

According to all the methodology developed by the United Nations that accompanies the SDGs, it is essential that the data structure is related to the goals. This is because the relationship with the SDG Indicators and with any other data is based on the corresponding goal. This data architecture is internationally used and is the one that allows a greater degree of interoperability between them. To apply this information architecture in CONSUL DEMOCRACY, a module has been developed that allows adding to all the data models of the system their relationship with the corresponding TARGETS and SDGs.

In the menu on the left, we find these sections:

3.6.1 Objectives and Goals:

In this section, we will find three tabs: "Objectives" where the 17 SDGs of the 2030 Agenda are listed; "Goals", where the different specific goals of each objective are listed, and "Local goals" where the local goals by the institution are listed and added.

To create a local goal, click on the "Create local goal" button that appears in the upper right part of the "located goals" tab, which will show us the following screen

The form to add a new Located Goal must be filled out taking into account the following indications.

  1. All Localized Goals must be related to a Global Goal.

  2. The Localized Target code must follow the related target code followed by “.” and the code you want below. Example: 1.1.3-MAD 2.

  3. It must have a title.

  4. It must have a description. The Localized Goals can be internationalized, so that it will be possible to register the Localized Goals in different languages

3.6.2 SDG home page

This interface allows you to customize the public page where all the information on the SDGs in the portal is collected and that allows navigation through all the content related to the SDGs.

To customize this page, according to the needs of each CONSUL DEMOCRACY installation, the following sections are available:

  1. SDG header

  2. phases

In the ODS header you can create a custom header with the following fields:

  • Label (optional)

  • Qualification

  • Description

  • link text

  • link URL

  • Image

In addition, the header is internationalizable, one can be defined for each language that is defined.

In the Phases section, you can add cards similar to those available on the CONSUL DEMOCRACY main page, associated with 3 phases.

The name of the phases can be modified through the translations file.

The options that the cards allow you to add are the following:

  • Label (optional)

  • Qualification

  • Description

  • link text

  • link URL

  • Image

In addition, they are internationalizable, one can be defined for each language of the portal. They can also be adapted by defining columns to be able to customize the page according to the needs of the CONSUL DEMOCRACY installation.

The ODS page will look like this after the content has been added.

Users who access the SDG page (/sdg/goals) will be able to navigate by accessing a specific page for each of the SDGs. On each page, you will see the following information:

  • The name and icon of each ODS can be translated into each corresponding language of the CONSUL DEMOCRACY installation. There is an automatic translation system that allows the above contents to be translated into other languages when the administrators or users themselves have not done so.

  • A descriptive text of each SDG. These texts have been adopted from the United Nations portal (www.un.org/sustainabledevelopment) or from other sources of the same body and all these texts are translatable.

  • More active proposals related to the corresponding SDG(s).

  • More active discussions related to the corresponding SDG(s).

  • Participatory processes related to the corresponding SDG(s).

  • The Global Goals corresponding to that SDG.

  • The Local Targets corresponding to that SDG.

Like other CONSUL DEMOCRACY views, this page can be adapted following the recommendations of the CONSUL DEMOCRACY documentation regarding customization of HTML View Customization.

If you want to modify the HTML of a page you can do it by copying the HTML from app/views and putting it in app/views/custom respecting the subdirectories you find there. For example, if you want to modify app/views/pages/conditions.html you must copy it and modify it in app/views/custom/pages/conditions.html.erb

Each of the content blocks (most active Proposals, most active Debates and Processes) also allows direct access to the general view of each one with the filter corresponding to the SDG being consulted.

These blocks also show other SDGs in case the content is aligned with more than one SDG or Goal.

The view of the main page of an ODS will be the following:

3.6.3. discussions

From this management interface, the Administration profile or the profile with the ODS Management role will be able to moderate the content that has been created in this section, aligned with the ODS.

All open discussions on the portal are collected and managed.

All debates that have not been reviewed are classified as Pending. In the All tab there are all, those reviewed and not reviewed, and in the Marked as reviewed tab, there are those that have been reviewed.

From the SDG Administration or Management profile, the SDGs or Goals aligned in each entry can be modified by clicking on the Actions icon and editing the SDGs and/or Goals assigned to each entry.

To facilitate the management, entries can be filtered by SDGs or Goals or search for specific content.

3.6.4. proposals

From this management interface, the Administration profile or the profile with the ODS Management role will be able to moderate the content that has been created in this functionality aligned with the ODS.

From this interface, it will be possible to manage all the proposals created through the CONSUL DEMOCRACY Proposals module.

All those that have not been reviewed are classified as Pending. On the All tab are all proposals (reviewed and unreviewed) and on the Marked as reviewed tab are those that have already been reviewed.

From the SDG Administration or Management profile, you can modify the SDGs or Goals aligned in each entry by clicking on the Actions icon and editing the SDGs and/or Goals assigned to each entry.

To facilitate the management, entries can be filtered by SDGs or Goals or search for specific content.

3.6.5. voting

From this management interface, the Administration profile or profile with the ODS Management role will be able to moderate the content that has been created in this functionality aligned with the ODS.

This interface allows you to edit and manage the alignment of the Voting processes.

3.6.6. collaborative legislation

From this management interface, the Administration profile or the person with the SDG Management role will be able to moderate the content that has been created in this section, aligned with the SDGs.

3.6.7. Proposals within Collaborative Legislation

From this management interface, the administrator or the person with the SDG Management role will be able to moderate the content that has been created in this section, aligned with the SDGs.

Collaborative legislation includes complex processes that consist of different phases. One of them is the Proposal Phase, a period in which specific proposals to contribute to the Legislative process are compiled. In this interface, it is possible to manage these proposals to modify their alignment with the SDGs.

3.6.8. Participatory Budgets

From this management interface, the administrator or the person with the SDG Management role will be able to moderate the content that has been created in this section, aligned with the SDGs.

In this case, the spending proposals associated with the Participatory Budgets functionality can be managed from this interface.

All those that have not been reviewed are classified as Pending. In the All tab there are all the proposals (reviewed and not reviewed) and in the Marked as reviewed tab, there are those that have already been reviewed.

Last updated