Database Reference
In-Depth Information
How to do it...
Now, we copy data from the point cloud into our table.
\copy chp07.uas from '/path/to/data/
headless_uas_points.ply' DELIMITER ' ';
Wewillconvertourimplicitspatialdatatoexplicitspatialdatawiththefollowingcode:
ALTER TABLE chp07.uas ADD COLUMN the_geom
GEOMETRY(PointZ, 0);
UPDATE chp07.uas SET the_geom =
ST_SetSRID(ST_MakePoint(x,y,z),0);
These data, as viewed in MeshLab from the
ply
file, are pretty interesting:
