Database Reference
In-Depth Information
SELECT
AddGeometryColumn('chp07','lidar','the_geom',3734,'POINT',
3);
UPDATE chp07.lidar SET the_geom =
ST_SetSRID(ST_MakePoint(x,y,z),3734);We add a
primary key:
ALTER TABLE chp07.lidar ADD COLUMN gid serial;
ALTER TABLE chp07.lidar ADD PRIMARY KEY (gid);
Now, we can view our data as shown in the following image:
See also
• The
Performing 3D queries on a LiDAR point cloud
recipe
