Use latest green skills lists

[lizgzil]

We are currently mapping to v1.1.1 ESCO green skills. But there is an updated version.

https://esco.ec.europa.eu/en/about-esco/escopedia/escopedia/esco-versions

Full ESCO versions ESCO v1 (first full-scale ESCO version): Released in mid 2017 ESCO v1.1 (Major): Released in January 2022 ESCO v1.1.1 (Minor): Released in September 2022 ESCO v1.1.2 (Minor): Released in February 2024 ESCO v1.2 (Major): Released in May 2024

[lizgzil]

Some analysis of the old v1.1.1 compared to the new v1.2.0 greenSkillsCollection_en.csv:

Looking at the skill id column:

There are 570 old green skill IDs and 591 new green skill IDs.
12 IDs were in the old green skills set but not in the new
33 IDs were in the new green skills set but not in the old
558 IDs were in both the old and new green skills sets

Looking at the description column (preferred or alt labels):

There are 3869 old green skill descriptions and 4206 new green skill descriptions.
144 descriptions were in the old green skills set but not in the new
481 descriptions were in the new green skills set but not in the old
3725 descriptions were in both the old and new green skills sets

The preferred labels:

The preferred labels of ids only in the old green skills set: ['gas consumption', 'supervise crop production', 'gas contaminant removal processes', 'combined heat and power generation', 'research recycling grant opportunities', 'dispose waste', 'operate steam turbine', 'perform a feasibility study on combined heat and power', 'handle waste', 'oil rig legislation', 'safety engineering', 'assist in plant propagation']

The preferred labels of ids only in the new green skills set: ['advise on chemical use reduction', 'sustainable technologies', 'ensure responsible sourcing in food supply chains', 'wind energy', 'ecosystem management', 'sustainable manufacturing', 'habitat restoration', 'design building retrofitting solutions', 'food ethics', 'safety engineering', 'geothermal energy', 'urban sustainability', 'sustainable building design', 'promote ethical eating', 'energy micro-generation technologies', 'green building standards', 'alternative energy', 'environmental management standards', 'produce sustainable products', 'green chemistry', 'green automotive technologies', 'green building practices', 'solar products', 'ecopedagogy', 'advise on carbon emissions reduction', 'resource-efficient technologies', 'sustainability consulting', 'energy conservation', 'marine energy', 'reforestation', 'photovoltaic systems', 'alternative fuels', 'corporate sustainability']

Note: some of these do exist worded a bit differently. e.g "conduct reforestation surveys" - 4fdcf911-b738-4cf4-80ab-aa5a14d22f73 is in the old green dataset.

But in the new data there are two 'reforestation' ones:

Truely old green skills - descriptions and ids are only in the old green skills data: {'research recycling grant opportunities', 'combined heat and power generation', 'supervise crop production', 'assist in plant propagation', 'gas consumption', 'perform a feasibility study on combined heat and power', 'oil rig legislation', 'operate steam turbine', 'gas contaminant removal processes'}

Kind of old green skills - descriptions are only in the old data, but id exists in new data: {'relationship between buildings, people and the environment', 'perform a feasibility study on district heating and cooling.', 'Code of Conduct for Responsible Fisheries', 'environmental aspects of inland waterway transportation', 'by-products and waste', 'solar thermal energy systems for hot water and heating', 'understand fresh water ecosystems'} Selection deleted

Truely new green skills - descriptions and ids are only in the new green skills data: {'food ethics', 'marine energy', 'green building standards', 'advise on chemical use reduction', 'ecosystem management', 'energy micro-generation technologies', 'produce sustainable products', 'resource-efficient technologies', 'corporate sustainability', 'sustainability consulting', 'alternative fuels', 'sustainable technologies', 'ensure responsible sourcing in food supply chains', 'green automotive technologies', 'habitat restoration', 'environmental management standards', 'alternative energy', 'green building practices', 'wind energy', 'sustainable manufacturing', 'photovoltaic systems', 'advise on carbon emissions reduction', 'design building retrofitting solutions', 'promote ethical eating', 'urban sustainability', 'green chemistry', 'ecopedagogy', 'solar products', 'reforestation', 'sustainable building design'}

Kind of new green skills - descriptions are only in the new data, but id exists in old data: {'code of Conduct for Responsible Fisheries', 'manage environmental aspects of inland waterway transportation', 'monitor manufacturing impact', 'perform a feasibility study on district heating and cooling', 'study the relationship between buildings, people and the environment', 'by-products', 'operate solar thermal energy systems for hot water and heating', 'evaluate potential aquaculture conflicts', 'renewable energy', 'fresh water ecosystems'}