I have a building dataset and I am trying to perform a spatial analysis, to determine which building should be developed as a 3D model, for a mapping project.
Because in some areas the building density is too high, I have created a Ranking Matrix, so in the case that the buildings are too close from one another, the one with the higher rank will be chosen. And if the rank is the same, the one with the larger footprint will be preferred.
Can anyone suggest how the formula inside the Field Calculator should look like, so it would perform this analysis? I have tried many iterations and I can't seem to figure this out.
I would like the end result of this analysis to be another field, with 1 and 0, for suitable/not suitable for 3D development.
UPDATE: the features I want to compare are 100m buffers of the above mentioned buildings. So if the 100m buffers overlap, I want to compare the ranks of the two (or more) overlapping features. If the ranks are different, I want the formula to update the attribute table with '1' - for the suitable building. If the ranks are the same, I want to chose the building with the larger footprint and update that with '1', else, it should be '0'. Also, if there is no overlapping, those features should be also '1'