Two sets of 1000 points A.geom and B.geom in PostGIS
- From Set A take the first point and find its nearest neighbour in Set B
- Calculate the 3D distance between these two points
- Save the result to the dist column of Set A
I've been testing out various python libraries, I thought I had it working in shapely just to discover it ignores the z-dimension.
I think SFCGAL is the way to go, but I am inexperienced, is this a simple query, can anyone help me with this?