I have two layers, one with lots, one with subway stations (NYC). There are to scenarios:
Case 1. I want to rank the lots relative to the proximity to subways.
(1.a.) The closer to closest station, the better or
(1.b.) The closer to multiple stations, the better.
Case 2. I want to evaluate the area surrounding the lots, say 500m radius. I would calculate the distance from the center of each block to the nearest subway station(s). For each block, the distance will be multiplied by the number of residents. Then the sum of those values will be divided by the total population in the area.
How can I do this in QGIS or/and PostGis?