IntelCompH2020 / sti-viewer

European Union Public License 1.2
0 stars 0 forks source link

ENERGY-EU-TECHNOLOGY-1 #7

Open igrypari opened 1 year ago

igrypari commented 1 year ago

I would like to request additions to the Energy-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)

Chart Group 1: Technological Production Trends

    Chart 1:
        Title: Patents in Energy over time
        Description: The graph shows the evolution in the number of in the Energy domain granted by the EPO and still valid in 2021-Q2 by priority year. _Data Source:_ [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html 
        Type: area chart 
        Note: Indicator I09 
        xAxisName: year (2000 to most recent available)
        yAxisName: patents
        xColumnField: key
        yColumnField: value
        GroupingByField: --

       Chart 2:
       Title: Share of patents in Energy topics over time
        Description: The graph shows the evolution in the share of patents in different topics in the Energy domain, granted by the EPO and still valid in 2021-Q2. The ontology of topics is taken from the technical annex of the Final Report of the [EU taxonomy for sustainable activities](https://finance.ec.europa.eu/sustainable-finance/tools-and-standards/eu-taxonomy-sustainable-activities_en#documents) (Chapter 4. “Electricity, gas, steam and air conditioning supply,” p. 205). We assigned patents to  topics, by matching topics to CPC codes. _Data Source:_ [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
       Note: Indicator I09B, SV01 (please make sure the topics are visible in the legend, also the pop-up when hovering is not readable)
        Type: stacked area chart
        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 Energy domain granted by the EPO and still valid in 2021-Q2 by the country of the applicant . _Data Source:_ [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
       Note: Indicator I09, SV09
        Type: world map
        xAxisName: 
        yAxisName: 
        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 Energy domain granted by the EPO and still valid in 2021-Q2. 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) NOTE: 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 Energy domain granted by the EPO and currently valid (at least until 2021 Q2) by the type of patent applicant. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html Note: Indicator I09, SV08 Type: doughnut chart (https://echarts.apache.org/examples/en/editor.html?c=pie-doughnut) xAxisName: yAxisName: 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 Energy domain granted by the EPO and still valid in 2021-Q2 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 NOTE: Indicator – I09, SV07 Type: https://echarts.apache.org/examples/en/editor.html?c=pie-legend xAxisName: yAxisName: 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 Energy domain granted by the EPO and still valid in 2021-Q2 by IPC. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html NOTE: Indicator – I09, SV13 Type: horizontal bar chart xAxisName: yAxisName: xColumnField: key yColumnField: value GroupingByField:

Chart 3: Title: Patents by topic Description: The graph shows the number of patents by topic in the Energy domain, granted by the EPO and still valid in 2021-Q2. The ontology of topics is taken from the technical annex of the Final Report of the EU taxonomy for sustainable activities (Chapter 4. “Electricity, gas, steam and air conditioning supply,” p. 205). We assigned patents to topics, by matching topics to CPC codes. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html NOTE: Indicator – I09, SV02 Type: Type: ordered nightingale chart with the legend (https://echarts.apache.org/examples/en/editor.html?c=pie-roseType-simple but legend on side) xAxisName: yAxisName: 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 Energy domain granted by the EPO and still valid in 2021-Q2 by priority year. 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 the 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 Note: 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 Energy domain, granted by the EPO and still valid in 2021-Q2. Data Source: Patstat - EPO dataset.
Note: Indicator I11 SV01 (average backward citations), I12 SV02 (average forward citations) Type: two basic line chart with legend xAxisName: year (2000 to most recent available) 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 in the Energy domain granted by the EPO and still valid in 2021-Q2 by the country of the applicant, for different types of patent. 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 the 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 Note: Indicator I12A, SV09 Type: world map with choice of which of the four classes to view the map for (initiate at pioneers) xAxisName: yAxisName: 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 of patent applicants in terms of the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2, for different types of patents. 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 the 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: 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) NOTE: 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 in the Energy domain granted by the EPO and currently valid (at least until 2021 Q2) by the type of patent applicant, for different types of patents. 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 the 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 Note: Indicator I12A, SV08 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) xAxisName: yAxisName: 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 in the Energy domain granted by the EPO and still valid in 2021-Q2 by the NACE (Nomenclature of Economic Activities) codes of patents as assigned by PATSTAT, for different types of patents. 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 the 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 . Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html NOTE: Indicator – I12A, SV07 with choice of which of the four classes to view the graph for (initiate at pioneers) Type: https://echarts.apache.org/examples/en/editor.html?c=pie-legend xAxisName: yAxisName: 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 20 IPC (International Patent Classification) codes by the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2 by IPC, for different types of patents. 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 the 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 NOTE: Indicator – I12A, SV13 with choice of which of the four classes to view the graph for (initiate at pioneers) Type: horizontal bar chart xAxisName: yAxisName: xColumnField: key yColumnField: value GroupingByField: Filter: type of patent (adopters, enablers, pioneers, mavericks)

Chart 3: Title: Patents by topic Description: The graph shows the number of patents by topic in the Energy domain, granted by the EPO and still valid in 2021-Q2, for different types of patents. 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 the low is defined as below average, and high as above average. The ontology of topics is taken from the technical annex of the Final Report of the EU taxonomy for sustainable activities (Chapter 4. “Electricity, gas, steam and air conditioning supply,” p. 205). We assigned patents to topics, by matching topics to CPC codes. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html NOTE: Indicator – I12A, SV02 with choice of which of the four classes to view the graph for (initiate at pioneers)

        Type: Type: ordered nightingale chart with the legend (https://echarts.apache.org/examples/en/editor.html?c=pie-roseType-simple but legend on side) 
        xAxisName: 
        yAxisName: 
        xColumnField: key
        yColumnField: value
        GroupingByField: 
   Filter: type of patent (adopters, enablers, pioneers, mavericks)
igrypari commented 1 year ago

@dtziotzios

I note the following errors on the report, as I see it in BSC today. Please indicate which ones of them are due to data issues.

a. The number indicators requested at the beginning of the report are not shown.

b. Chart Group 1, chart 2: The legend on the side is not visible, and when hovering the legend covers the entire chart making it un-usable. Legend in the bottom and when hovering only show the category you're hovering over?

c. Chart Group 2, chart 3: there is a big chunk of data with an empty label

d. Chart Group 3, chart 3: legend and labels not visible

e. Chart Group 4, chart 1: please make it so that the ombre effect created is consistent over time, so that 2021 is darker than 2020 is darker than 2019 etc.. Right now it gets darker till 2013 and then lighter again.

f. Chart Group 5, chart 2 "no data"

g. Chart Group 5, chart 3 legend, labels and filter choice not legible

dtziotzios commented 1 year ago

Some updates regarding @igrypari notes. Please keep in mind that the following changes will be available after the next BSC installation update. I'll inform you here after the update.

a. We are looking into it. b. Fixed using the echarts legend functionality to wrap the text. c. This is an issue with the data. Some names are empty text. We are getting data from pv01 i09 sv08. d. Fixed using the echarts legend functionality to wrap the text. e. We are looking into it. f. Maybe you mean Chart group 6 - chart 2? If yes, then data are missing. We were looking for i12a sv13. g. We are looking into it.

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.

gkountouris commented 1 year ago

Groupchart 2 chart 2 Probably has a mistake. The data I have given seems to be ok. Groupchart 5 chart 2 Also has the same mistake. Groupchart 5 chart 1 funny number with Mali having the highest average of citations per publication.

@dtziotzios @igrypari

dtziotzios commented 1 year ago

@gkountouris for Groupchart 2 chart 2 the data from pv01 - i09 - sv06 grouped by key are used, as described by Ioanna above. for Groupchart 5 chart 2 the data from pv01 - i12a - sv06 grouped by key and filtered by tag are used, as described by Ioanna above. for Groupchart 5 chart 1 the data from pv01 - i12a - sv09 grouped by metric_scope and filtered by key are used, as described by Ioanna above.

Are these the correct data?

gkountouris commented 1 year ago

@dtziotzios

Yes those are the correct data.

igrypari commented 1 year ago

Hello here are some issues I found, please excuse me if they are mentioned in the open tickets above.

https://sti-viewer.intelcomp.bsc.es/indicator-report/dashboard?params=%7B%22keywordFilters%22:%5B%7B%22field%22:%22domain%22,%22values%22:%5B%22Climate%22%5D%7D,%7B%22field%22:%22country%22,%22values%22:%5B%22EU%22%5D%7D,%7B%22field%22:%22pv%22,%22values%22:%5B%22Energy%22%5D%7D%5D,%22displayName%22:%22Energy%20-%20EU%22,%22dashboard%22:%22dg01_pv01_dashboard%22%7D

Climate --> EU --> Energy --> technology

  1. @gkountouris Number indicator: Average forward citations - the number is wrong. This is supposed to be the average number of forward citations per patent.

  2. @dtziotzios @GeorgeEnglezosCite technological production trends, share of patents in energy topics over time: when hovering i would like to see the label of only ONE line, otherwise illegible

  3. @dtziotzios @GeorgeEnglezosCite technological production characteristics, patents by Nace code. Unfortunately this visualisation doesn't handle the type of data we have nicely, can we please try a radial polar bar (with multiple colors) or a bar chart (with multiple colors) both ranked by number of patents, and with ability to zoom is/select the range in the axis?

  4. @dtziotzios @GeorgeEnglezosCite technological production characteristics, patents by IPC code.

  1. @dtziotzios @GeorgeEnglezosCite technological impact trends, technological value of patents over time the description has an extra "the" /// it says "where the low is defined as" - please make it "where low is defined as" ---- IF you can please do this change in all of the following charts, the same mistake is carried through, big thanks

  2. @dtziotzios @GeorgeEnglezosCite technological impact origins, patents by country and technological value, please switch description to" Description/Source: The graph shows the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2 by the country of the applicant, for different types of patent. Use the filter on the top right to switch between different types. 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 the low is defined as below average, and high as above average. Data Source: Patstat - EPO dataset

  3. @dtziotzios @GeorgeEnglezosCite Technological Impact Origins, patents by organisation (top 100) and technological value - please change description to: The graph shows the top 100 organizations of patent applicants in terms of the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2, for different types of patents. Use the filter on the top right to switch between different types. 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 the low is defined as below average, and high as above average. Data Source: Patstat - EPO dataset

  4. @dtziotzios @GeorgeEnglezosCite technological impact origins, patents by sector and technological value,

"The graph shows the number of patents in the Energy domain granted by the EPO and currently valid (at least until 2021 Q2) by the type of patent applicant, for different types of patents. Use the filter on the top right to switch between different types. 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 the low is defined as below average, and high as above average. Data Source: Patstat - EPO dataset"

  1. @dtziotzios @GeorgeEnglezosCite technological impact characteristics, patents by nace code and by technological value
  1. @gkountouris technological impact characteristics, patents by nace code and by technological value - i am surprised that there are so few NACE codes when at the chart further up "technological production characteristics, patents by NACE code" there were so many different ones - can you double check the data?

  2. @dtziotzios @GeorgeEnglezosCite technological impact characteristics, patents by IPC code (top 20 codes) and by technological value

  1. @dtziotzios @GeorgeEnglezosCite technological impact characteristics, patents by topic
dtziotzios commented 1 year ago

Requested changes are deployed.