Agrifood-EU-SCIENCE-1

[igrypari]

Ι would like to request a report.

The user flow that leads to the report is the following

• Browse topics for Climate > EU > select category "Agrifood"

The title of the report should read "Αgrifood - EU'

The report should contain the following tabs that remain at the top of the page when you scroll down:

There is a total of 6 tabs:

• Science
• Technology
• Industry

•  ESG Reports
  

• Green Skills
• Regulations

Tab Name: Science

Number Indicators
Publications (total number of publications using I01, SV00)
Citations (total number of citations using I06, SV00)
Publications cited in patents (total number using I13A, SV00)

Chart Group 1: Scientific Production Trends

    Chart 1:
        Title: Publications in Agrifood over Time
        Description: The graph shows the evolution in the number of publications in the Agrifood domain, in the EU (at least one author is affiliated to an EU organization) We identified the set of publications in Agrifood by .. (http://doi.org/10.3389/frma.2023.1149834)  _Data Source:_ [OpenAIRE Graph](https://graph.openaire.eu/)
        Type: area chart 
        Indicator: I01, SV01
        xAxisName: year 
        yAxisName: publications
        xColumnField: key
        yColumnField: value
        GroupingByField: --


         Chart 2:
       Title: Share of publications in Agrifood Topics over Time
        Description: The graph shows the evolution in the share of publications in different topics in the Agrifood domain in the EU, over time. The assignment of topics is taken from Abbate, Centobelli, Cerchione (2023) (https://doi.org/10.1016/j.techfore.2022.122222) which we enhanced and mapped to topics in our Fields of Science (FoS) publication classification system (http://doi.org/10.3389/frma.2023.1149834). _Data Source:_ [OpenAIRE Graph](https://graph.openaire.eu/)
        Type: stacked area chart
        Indicator: I03
        xAxisName: year 
        yAxisName: publications
        xColumnField: key
        yColumnField: value
        GroupingByField: topic

Chart Group 2: Scientific Production Origins

    Chart 1:
        Title: Publications by Country
        Description: The graph shows the number of publications in Agrifood by the country of the affiliated organization of an author  (with at least one author affiliated to an EU organization). In the case of multiple authors each organization and corresponding country is counted as a separate publication (e.g., one publication with three authors, where two are from Greece and one is from Spain is counted as two publications in Greece and one in Spain). Data Source:_ [OpenAIRE Graph](https://graph.openaire.eu/)
        Type: world map
        Indicator: I01, SV09
        xAxisName: 
        yAxisName: 
        xColumnField: key
        yColumnField: value
        GroupingByField:_ 

Chart 2:
Title: Publications by Organization (top 100)
Description: The graph shows the top 100 organizations in terms of the number of publications in Agrifood with at least one author from an EU organization. Data Source: OpenAIRE Graph
Type: column with the ability to move the x-axis range. Initialize at top 20
Indicator: I01, SV06
xAxisName: organization
yAxisName: publications
xColumnField: key
yColumnField: value
GroupingByField:

---

Chart Group 3: Scientific Production Characteristics

Chart 1:
Title: Publications by SDG
Description: The graph shows the number of publications in Agrifood with at least one author from an EU organization, by UN Sustainable Development Goal (SDG, https://sdgs.un.org/goals). Our SDG classification system uses deep learning techniques to assign a scientific publication to the SDGs that are related to it. Data Source: OpenAIRE Graph
Type: tree map with multiple colors, plz use SDG colors (https://echarts.apache.org/examples/en/editor.html?c=treemap-disk)
Indicator: I01, SV05
xAxisName:
yAxisName:
xColumnField: key
yColumnField: value
GroupingByField:

Chart 2:
Title: Top 50 Journals
Description: The graph shows the top 50 journals by the number of scientific publications in Agrifood, with at least one author from an EU organization. Data Source: OpenAIRE Graph
Type: column graph (careful, the journal names should be readable)
IndicatorL I01, SV10
xAxisName: journal
yAxisName: publications
xColumnField: key
yColumnField: value
GroupingByField:

---

Chart Group 4: Scientific Impact Trends

Chart 1:
Title: Publications Cited in Patents
Chart Subtitle:
Description: The graph shows the total number of publications, superimposed with the number of those that are cited in patents, over time, using data on publications and patents in the Agrifood domain in the EU. _ Data Sources: OpenAIRE Graph, Patstat - EPO dataset.
Type/Indicator: column (publications - I01, SV01), line chart (publications cited in patents - I13A, SV01)
xAxisName: year
yAxisName: publications
xColumnField: key
yColumnField: value
GroupingByField:

Chart 2: 
        Title: Average Citations per Publication over Time
        Chart Subtitle: 
        Description: The graph shows the average number of citations per scientific publication in the Agrifood domain, with at least one author from an EU organization, over time, by the year of publication. _ Data Source: [OpenAIRE Graph](https://graph.openaire.eu/) using the integrated [Open Citations](https://opencitations.net/) dataset.
       Type: area
        Indicator: I07, SV01
        xAxisName: year 
        yAxisName: citations per publication
        xColumnField: key
        yColumnField: value
        GroupingByField: 
    
        Chart 3: 
        Title:  Total Citations over Time
        Chart Subtitle: 
        Description: The graph shows the total number of citations for scientific publications in Agrifood, with at least one author from an EU organization, over time by the year of publication. _ Data Source: [OpenAIRE Graph](https://graph.openaire.eu/) using the integrated [Open Citations](https://opencitations.net/) dataset.
        Type: area
        Indicators I06, SV01
        xAxisName: year 
        yAxisName: citations
        xColumnField: key
        yColumnField: value
        GroupingByField: 
    

        Chart 4: 
       Title: Field-weighted Citation Index over Time
        Chart Subtitle: 
        Description: The graph shows the evolution of the field-weighted citation index of publications in Agrifood, with at least one author from an EU organization. The index is defined as the average number of citations received over the average number in the same subject in the field world-wide, in a 3-year window. _ Data Source: [OpenAIRE Graph](https://graph.openaire.eu/) using the integrated [Open Citations](https://opencitations.net/) dataset.
        Type: area
       Indicator: I08, SV01 
        xAxisName: year 
        yAxisName: citation index
        xColumnField: key
        yColumnField: value
        GroupingByField: 

---

Chart Group 5: Scientific Impact Origins

    Chart 1:
        Title: Citations per Publication by Country
        Description: The graph shows the average number of citations per publication, in Agrifood with at least one author from an EU organization, by the country of the affiliated organization of an author. In the case of multiple authors each organization and corresponding country is counted as a separate publication (e.g., one publication with three authors, where two are from Greece and one is from Spain is counted as two publications in Greece and one in Spain). _ Data Source_: [OpenAIRE Graph](https://graph.openaire.eu/) using the integrated [Open Citations](https://opencitations.net/) dataset.
        Type: world map
        Indicator: I07, SV09 	
        xAxisName: country
        yAxisName: citations per publication
        xColumnField: key
        yColumnField: value
        GroupingByField: 


    Chart 2:
        Title: Citations per Publication by Organization (top 100)
        Description: The graph shows the top 100 organizations in terms of the average number of citations per publication in Agrifood with at least one author from an EU organization. _ Data Source_: [OpenAIRE Graph](https://graph.openaire.eu/) using the integrated [Open Citations](https://opencitations.net/) dataset.
        Type: column with the ability to move the x-axis range and filter for organization name. Initialize at top 20
        IndicatorL I07, SV06
        xAxisName: organization
        yAxisName: citations per publication
        xColumnField: key
        yColumnField: value
        GroupingByField: 

---

Chart Group 6: Scientific Impact Characteristics

Chart 1:
Title: Publications Cited in Patents by Topic in Agrifood
Chart Subtitle:
Description: The graph shows the number of publications cited in patents by topic within the Agrifood domain, both publications and patents are limited to the in the Agrifood domain in the EU. The assignment of topics is taken from Abbate, Centobelli, Cerchione (2023) (https://doi.org/10.1016/j.techfore.2022.122222) which we enhanced and mapped to topics in our Fields of Science (FoS) publication classification system (http://doi.org/10.3389/frma.2023.1149834)._ Data Sources_: OpenAIRE Graph, Patstat - EPO dataset.
Type: ordered nightingale chart with the legend on the side (https://echarts.apache.org/examples/en/editor.html?c=pie-roseType-simple but legend on side)
Indicator: I13A, SV02
xAxisName: topic
yAxisName: publications cited in patents
xColumnField: key
yColumnField: value
GroupingByField:

Chart 2:
Title: Publications cited in patents by SDG
Chart Subtitle:
Description: The graph shows the number of publications cited in patents by UN Sustainable Development Goal (SDG, https://sdgs.un.org/goals), both publications and patents are limited to the Agrifood domain in the EU. Our SDG classification system uses deep learning techniques to assign a scientific publication to the SDGs that are related to it. _ Data Sources_: OpenAIRE Graph, Patstat - EPO dataset.
Type: tree map with SDG colors
Indicator: I13A, SV05
xAxisName: SDG
yAxisName: publications cited in patents
xColumnField: key
yColumnField: value
GroupingByField:

Chart 3:
Title: Citations per publication by topic in Agrifood
Description: The graph shows the average number of citations per scientific publication for different topics in the Agrifood domain. The assignment of topics is taken from Abbate, Centobelli, Cerchione (2023) (https://doi.org/10.1016/j.techfore.2022.122222) which we enhanced and mapped to topics in our Fields of Science (FoS) publication classification system (http://doi.org/10.3389/frma.2023.1149834). _ Data Source_: OpenAIRE Graph using the integrated Open Citations dataset.
Type: ordered nightingale chart with the legend on the side (https://echarts.apache.org/examples/en/editor.html?c=pie-roseType-simple but legend on side)
xAxisName: topic
yAxisName: citations per publication
xColumnField: key
yColumnField: value
GroupingByField:

        Chart 4: 
 Title: Citations per publication by SDG
        Chart Subtitle: 
        Description: The graph shows the average number of citations per scientific publication in Agrifood, by UN Sustainable Development Goal (SDG, https://sdgs.un.org/goals). Our SDG classification system uses deep learning techniques to assign a scientific publication to the SDGs that are related to it.  _ Data Source_: [OpenAIRE Graph](https://graph.openaire.eu/) using the integrated [Open Citations](https://opencitations.net/) dataset.**

        Type: tree map with multiple colors (https://echarts.apache.org/examples/en/editor.html?c=treemap-disk)
        Indicator: I07, SV05
        xAxisName: SDG
        yAxisName: citations per publication
        xColumnField: key
        yColumnField: value
        GroupingByField: 

---

Chart Group 7: Scientific Collaborations
Chart 1:
Title: International collaborations over time
Description: The graph shows the evolution in the number of publications in Agrifood with authors affiliated to organizations in at least two different countries, one of which is in the EU. Superimposed is the number of those that are cited by at least one publication. Data Source_: OpenAIRE Graph using the integrated Open Citations dataset.
Type: column chart (publications over time, I01, SV01) and super-imposed two line chart which are (international co-publications, I19, SV01) and (citable international co-publications, I20, SV01)
xAxisName: year (2000 to most recent available)
yAxisName: publications
xColumnField: key
yColumnField: value
GroupingByField:

        Chart 2
         Title: International collaborations by topic 
        Description: The graph shows the number of publications with authors affiliated to organizations in at least two different countries, one of which is in the EU, by topic in the Agrifood domain. The assignment of topics is taken from Abbate, Centobelli, Cerchione (2023) (https://doi.org/10.1016/j.techfore.2022.122222) which we enhanced and mapped to topics in our Fields of Science (FoS) publication classification system (http://doi.org/10.3389/frma.2023.1149834). Data Source_: [OpenAIRE Graph](https://graph.openaire.eu/)** 
          Type: ordered nightingale chart with the legend on the side (https://echarts.apache.org/examples/en/editor.html?c=pie-roseType-simple but legend on side)
        Indicator: I19, SV02
        xAxisName: topic
        yAxisName: publications
        xColumnField: key
        yColumnField: value
        GroupingByField: 

        Chart 3
         Title: Collaboration Index by SDG 
        Description: The graph shows the average number of authors, i.e. the collaboration index, in publications in Agrifood by UN Sustainable Development Goal (SDG, https://sdgs.un.org/goals). Our SDG classification system uses deep learning techniques to assign a scientific publication to the SDGs that are related to it. The size of the bubble indicates the number of publications associated with that SDG. Data Source_: [OpenAIRE Graph](https://graph.openaire.eu/ 
          Type:  https://echarts.apache.org/examples/en/editor.html?c=scatter-aqi-color, ideally with SDG colors
        Indicator: I19A, SV05
        xAxisName: SDG
        yAxisName: collaboration index
        xColumnField: key
        yColumnField: value
        GroupingByField: 
        Size of bubble: # of publications by SDG by I01, SV05

[dtziotzios]

First implementation deployed.
Issues:
Chart Group 2 - Chart 2 data dg01 pv02 i27 sv00 should be changed to sv06 to have them in the same chart with i01
Chart Group 5 - Chart 2 data dg01 pv02 i28 sv00 should be changed to sv06 to have them in the same chart with i01

@gkountouris

[dtziotzios]

All the above issues are resolved with the new data provided.