I have a main addresses
point layer and a areas
point layer. Both layers have XYZ coordinates in the attribute table. I need to create a table based from the addresses
layer which calculates the 3D distance to every area
point. The output I'm after is similar to the table below
ADDRESSES | AREA1 | AREA2 | AREA3 | ...
addressA | ..... | ..... | ..... | ...
addressB | ..... | ..... | ..... | ...
addressC | ..... | ..... | ..... | ...
I've written a custom script which does this but it gets very slow since I have around 15,000 address points and 6,000 areas. I've read here on GSE that PostGIS is good for large datasets so installed it. But I do not know to how to do the query to achieve what I'm after.