IntelCompH2020 / sti-viewer

European Union Public License 1.2
0 stars 0 forks source link

Agrifood-EU-TECHNOLOGY-1 #10

Open igrypari opened 1 year ago

igrypari commented 1 year ago

I would like to request additions to the Agrifood-EU report, in the tab “Technology”.

The user flow that leads to the report is the following:

Tab Name: Technology

Number Indicators Patents (total number of publications using I09) Average forward citations (average number using I12)

Charts Chart Group 1: Technological Production Trends

    Chart 1:
        Title: Patents in Agrifood over Time
        Description: The graph presents the number of Agrifood patents granted by the EPO and still valid in 2021-Q2, by their respective priority years. To identify Agrifood-related patents in the EU, we initially conducted a comprehensive selection process using predefined patent categories. Subsequently, we matched CPC (Cooperative Patent Classification) codes to Agrifood topics (as described in Abbate, Centobelli, and Cerchione (2023), https://doi.org/10.1016/j.techfore.2022.122222). Finally, we filtered the patents to include only those where at least one inventor or applicant is affiliated with an EU organization. _Data Source:_ [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html 
        Type: area chart 
        Indicator: I09, SV01 
        xAxisName: year 
        yAxisName: patents
        xColumnField: key
        yColumnField: value
        GroupingByField: --
       Chart 2:
       Title: Share of Patents in Agrifood Topics over Time
        Description: The graph shows the evolution in the share of patents in different topics in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization. The topics are taken from Abbate, Centobelli, Cerchione (2023) (https://doi.org/10.1016/j.techfore.2022.122222) which we mapped to CPC codes. _Data Source:_ [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
       Type: stacked area chart.
        Indicators: I09B, SV01
        xAxisName: year (2000 to most recent available)
        yAxisName: patents
        xColumnField: key
        yColumnField: value
        GroupingByField: topic

Chart Group 2: Technological Production Origins

    Chart 1:
        Title: Patents by Country
        Description: The graph shows the number of patents in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization, categorized by the country of the applicant. _Data Source:_ [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
       Type: world map
        Indicator I09, SV09
        xAxisName: country  
        yAxisName: patents
        xColumnField: key
        yColumnField: value
        GroupingByField: 

Chart 2: Title: Patents by Organization (top 100) Description: The graph shows the top 100 organizations of patent applicants in terms of the number of patents in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html Type: column with the ability to move the x-axis range (like in data4impact societal impact tab) and filter for organization name. Initialize at top 20) Indicator: I09 – SV06 xAxisName: organization yAxisName: patents xColumnField: key yColumnField: value GroupingByField:

Chart 3: Title: Patents by Sector Description: The graph shows the number of patents in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization, categorized by the type of patent applicant. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html

        Type: doughnut chart (https://echarts.apache.org/examples/en/editor.html?c=pie-doughnut)  Indicator: I09, SV08
        xAxisName: sector
        yAxisName: patents
        xColumnField: key
        yColumnField: value
        GroupingByField:_ 

Chart Group 3: Technological Production Characteristics

Chart 1: Title: Patents by NACE code Description: The graph shows the number of patents in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization, categorized by the NACE (Nomenclature of Economic Activities) codes of patents as assigned by PATSTAT. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html Type: https://echarts.apache.org/examples/en/editor.html?c=pie-legend Indicator: I09, SV07 xAxisName: NACE code yAxisName: patents xColumnField: key yColumnField: value GroupingByField:

Chart 2: Title: Patents by IPC code (top 20 codes) Description: The graph shows the top 20 IPC (International Patent Classification) codes by the number of patents in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html Type: horizontal bar chart Indicator: I09, SV13 xAxisName: IPC code yAxisName: patents xColumnField: key yColumnField: value GroupingByField:

Chart 3: Title: Patents by Τopic Description: The graph shows the number of patents by topic in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization. The topics are taken from Abbate, Centobelli, Cerchione (2023) (https://doi.org/10.1016/j.techfore.2022.122222) which we mapped to CPC codes. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html Type: ordered nightingale chart (https://echarts.apache.org/examples/en/editor.html?c=pie-roseType-simple but legend on side) Indicator: I09, SV02 xAxisName: topic yAxisName: patents xColumnField: key yColumnField: value GroupingByField:


Chart Group 4: Technological Impact Trends

Chart 1: Title: Technological Value of Patents over Time Description: The graph shows the evolution in the type of patents in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where “low” is defined as below average, and “high” as above average. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html Type: https://echarts.apache.org/examples/en/editor.html?c=radar2 Indicator I12A – SV01 xAxisName: (end points) class of patents (adopters, enablers, pioneers, mavericks) yAxisName: patents xColumnField: key yColumnField: value GroupingByField: year

Chart 2: Title: Patent Citations over Time Chart Subtitle: Description: The graph shows the average number of backward and forward citations to other patents for patents in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization. Data Source: Patstat - EPO dataset.
Type: two basic line chart with legend Indicator: I11 SV01 (average backward citations), I12 SV02 (average forward citations) xAxisName: year yAxisName: average citations xColumnField: key yColumnField: value GroupingByField:


Chart Group 5: Technological Impact Origins Title: Patents by Country and Technological Value Description: The graph shows the number of patents by country for different types of patents in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where “low” is defined as below average, and “high” as above average. Use the filter on the top right to change the type selection. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html Type: world map with choice of which of the four classes to view the map for (initizalize at pioneers)
Indicator: I12A, SV09 xAxisName: country yAxisName: patents xColumnField: key yColumnField: value GroupingByField:_ Filter: type of patent (adopters, enablers, pioneers, mavericks)

Chart 2: Title: Patents by Organization (top 100) and technological value Description: The graph shows the top 100 organizations by the number of patents for different types of patents in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where “low” is defined as below average, and “high” as above average. Use the filter on the top right to change the type selection. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html Type: column graph with x-axis range option (initiate at top 20) with choice of which of the four classes to view the graph for (initiate at pioneers) Indicator: I12A – SV06 xAxisName: organization yAxisName: patents xColumnField: key yColumnField: value GroupingByField: Filter: type of patent (adopters, enablers, pioneers, mavericks)

Chart 3: Title: Patents by Sector and Technological value Description: The graph shows the number of patents by sector for different types of patents in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where “low” is defined as below average, and “high” as above average. Use the filter on the top right to change the type selection. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html Type: doughnut chart (https://echarts.apache.org/examples/en/editor.html?c=pie-doughnut) with choice of which of the four classes to view the graph for (initiate at pioneers) Indicator: I12A, SV08 xAxisName: sector yAxisName: patents xColumnField: key yColumnField: value GroupingByField:_ Filter: type of patent (adopters, enablers, pioneers, mavericks)


Chart Group 6: Technological Impact Characteristics

Chart 1: Title: Patents by NACE code and by technological value Description: The graph shows the number of patents by NACE (Nomenclature of Economic Activities) code for different types of patents in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where “low” is defined as below average, and “high” as above average. Use the filter on the top right to change the type selection. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html Type: https://echarts.apache.org/examples/en/editor.html?c=pie-legend
Indicator – I12A, SV07 with choice of which of the four classes to view the graph for (initiate at pioneers) xAxisName: NACE code yAxisName: patents xColumnField: key yColumnField: value GroupingByField: Filter: type of patent (adopters, enablers, pioneers, mavericks)

Chart 2: Title: Patents by IPC code (top 20 codes) and by technological value Description: The graph shows the top IPC codes by number of patents, for different types of patents in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where “low” is defined as below average, and “high” as above average. Use the filter on the top right to change the type selection. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html

        Type: horizontal bar chart
        Indicator: I12A, SV13 with choice of which of the four classes to view the graph for (initiate at pioneers)
        xAxisName: IPC code
        yAxisName: patents
        xColumnField: key
        yColumnField: value
        GroupingByField: 
      Filter: type of patent (adopters, enablers, pioneers, mavericks)

Chart 3: Title: Patents by Topic The graph shows the number of patents by topic for different types of patents in the Agrifood domain, granted by the EPO and still valid in 2021-Q2, where at least one inventor or applicant is affiliated with an EU organization. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where “low” is defined as below average, and “high” as above average. The topics are taken from Abbate, Centobelli, Cerchione (2023) (https://doi.org/10.1016/j.techfore.2022.122222) which we mapped to CPC codes. Use the filter on the top right to change the type selection. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
Type: Type: ordered nightingale chart with the legend (https://echarts.apache.org/examples/en/editor.html?c=pie-roseType-simple but legend on side)
Indicator – I12A, SV02 with choice of which of the four classes to view the graph for (initiate at pioneers) xAxisName: yAxisName: xColumnField: key yColumnField: value GroupingByField: Filter: type of patent (adopters, enablers, pioneers, mavericks)

dtziotzios commented 1 year ago

First implementation deployed. Issues: Chart Group 1 - Chart 2 - Missing data I09B, SV01 Chart Group 5 - Chart 1 - Data are missing the Tag field, so we don't have filtering Chart Group 5 - Chart 2 - Data are missing the Tag field, so we don't have filtering Chart Group 5 - Chart 3 - Data are missing the Tag field, so we don't have filtering Chart Group 6 - Chart 1 - Data are missing the Tag field, so we don't have filtering Chart Group 6 - Chart 2 - Data are missing the Tag field, so we don't have filtering

@gkountouris

dtziotzios commented 1 year ago

@gkountouris please also provide the SVXX for the Number Indicators.

dtziotzios commented 1 year ago

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