I have one point layer and one polygon layer with a common identifier attribute field called "N", same objects amounts but Feature IDs (FID) are different.
I have to iterate on the first one and what I want is to get the FID from the second using an attribute join (access to FID from the polygon using the specific field value of "N" as a bridge between both layers.
for feature in pointsLayer
bridge = feature.GetField('N')
# Here I want to select my feature from my other layer
# which has the same attribute value "N"
polygonsLayer.GetFeature(...)
As I read for now, I have 2 solutions, SQL request or create a matching table N-idPolygon?
Any hint what would be more efficient? We talk about 10000 features max in each layer.