Outline of the video

• Now that you have been processing data and needed to actually work with the data, you are very familiar with what you have and might also have realised what you don’t have. This is where this week’s module comes in, the data gap analysis.
• Goal: Make an overview of where you have data and where there are gaps. The data gap analysis will help you determine where you (1) need to do additional calculations OR (2) find additional data to close these gaps and then downscale if needed.
• The actual downscaling and calculations will take place in the next module. So make sure to focus on the analysis of the gaps and the collecting and processing of additional data where needed.
• M2:48, What are gaps?
  • Stating that you don’t have economic activity is NOT a gap. Stating that the activity doesn’t exist in the city is a confirmation for someone else that there is no gap here, but an informed assessment of the local situation.
  • Data on flows and/or stock is missing although the economic activity takes place in your city
  • Data that exists only for one year that doesn’t match the reference year;
  
  
• M6:06, How do you go about determining if there is a data gap?
• go through the decision tree diagram
• M8:00, We will rely on the template that you have worked with so far and extend it by a number of columns.
• Don’t worry, the order of the first columns haven’t changed. If you have used it so far, you can simply copy paste your data here and continue.
• There are 4 cases of possible situations that we can go through.
• If you do have data on a higher spatial scale, then you also need to add the proxy data.
• M11:58, recap: Once you’ve assessed where you have gaps, you need to look to higher spatial scales to fill them. Ideally you start with low scales, as explained in the decision making tree. If you don’t know where to find additional data, be sure to remember the Eurostat data.
• The Eurostat grid, shows you which data there is on which scale.
• In the economy-wide Material Flow Accounts dataset, the data can also be found. There you can browse by different materials, as well as different lifecycle stages (extraction, consumption) on the national level.
• Finally, we strongly recommend that you fill in this template. It is not just an exercise to make an overview and keep track of the status of your data collection. This data gap analysis matrix will also become part of your SCA report. It will help to share with others where gaps indeed exist and where data on higher scales were found and used or where simply there was no data at all.

Resources

• To more easily browse and search the Eurostat data, you can also use the Eurostat library on the Data Hub.
• decision tree diagram
• Data gap matrix tabs - construction sector
• Data gap matrix tabs - biomass sector