I have a pointcloud in PostgreSQL/postgis imported via PDAL, everything is fine, I chipped it into groups of 600 points, no problems.
I then manipulated the data, first exploding the patches and saving the coordinates to a new table:
CREATE TABLE pointcloud52 AS
SELECT
st_x(PC_EXPLODE(pa)::geometry) as x,
st_y(PC_EXPLODE(pa)::geometry) as y,
st_z(PC_EXPLODE(pa)::geometry) as z
From pointclouds
Now I have columns x,y,z how do I re-patch these, i.e. return the points to a patched geometry?
I've been trying with the PC_Patch() function, but it refuses to work