I am working with QGIS.
The aim of the task is to label (auto populate) the 'Road From' and 'Road To' columns in the attribute table based on which roads the street intersects with.
Looking at the example below. Central Ave is divided into segments based on the intersections as highlighted in red below. I want the attribute table to auto populate this row in the Road From and Road To columns to ‘Deakin St’ and ‘Barton St’.
Is it possible to write a code in the field calculator to tell the Road From column to fill according to the ‘Road name’ of the line it intersects with.
I guess the issues (besides can this be done) are that Central Ave intersects with itself as well as Deakin St. So the code will have to specify ‘does not equal itself’. Another one is can you tell it to fill the Road To colum … from the other road it did not put in the Road From Column.
To answer a question I got: No, I am not familiar with python (although when I was researching I did notice people using it) ... and Yes, I did look around at the plugins available. Do you think that Python is the potential answer ?