I have a table where properties are identified by their PID. A property can have multiple civic address points (e.g. larger buildings), but even when they do they still tend to border on only one street.
For example in the table below Property #3459 has three civic addresses that all border on Main Street:
PID CIVIC STREET3459 330 Main2309 255 Quinpool0014 26 Main0187 99 SummerNULL NULL NULL3459 332 Main2309 4890 Oxford3459 334 MainBUT... Property #2309 is one of those rare cases that borders on MORE than one street (perhaps it's a corner lot).
I want to select all properties (like #2309) that border on MORE than one street.In other words, select all rows with MORE THAN ONE unique PID/STREET combination.
QUESTION: What is the simplest way to achieve this in QGIS python scripting?
أكثر...
For example in the table below Property #3459 has three civic addresses that all border on Main Street:
PID CIVIC STREET3459 330 Main2309 255 Quinpool0014 26 Main0187 99 SummerNULL NULL NULL3459 332 Main2309 4890 Oxford3459 334 MainBUT... Property #2309 is one of those rare cases that borders on MORE than one street (perhaps it's a corner lot).
I want to select all properties (like #2309) that border on MORE than one street.In other words, select all rows with MORE THAN ONE unique PID/STREET combination.
QUESTION: What is the simplest way to achieve this in QGIS python scripting?
أكثر...