I am in the process of making the database for 9 consecutive years in 150 local administrative units. To do that I have to clip 9 line layers (roads for 9 years) with 150 polygon layers.
So far I have been doing it with the clipping tool in Batch process, but there are several problem I would like to solve a bit more easier.
Problem 1) When I clip the line layers I have to manually update the length of the lines. Since there are 1350 cases (9 years x 150 administrative units), it would take me a 2-3 days of repetitive and boring work that I would like to avoid. (Question 1) So the question is if there is any tool/plugin that can clip multiple line layers with multiple polygon layers and create separate new line layers for every year and administrative area. (Question 2) Or, is there any tool/plugin to update all the new layers at the same time
Problem 2) When I am done with clipping and updating of the line lengths, (Question 3) is there any tool/plugin that allows me to export all the line layers into one excel or CSV file?
I am using QGIS Desktop 3.10.2 with GRASS 7.8.2