Database Reference
In-Depth Information
ply
format ascii 1.0
element vertex 153781
property float x
property float y
property float z
property float nx
property float ny
property float nz
property uchar red
property uchar green
property uchar blue
end_header
-1.32668 1.00806 -1.89154 0.261367 -0.869846
0.418395 81 110 63
-1.32696 1.00782 -1.89235 0.0799267 -0.788881
0.609326 81 111 64
-1.32637 1.01745 -1.91275 0.788484 0.435774
0.434043 58 69 51
-1.31129 1.02467 -1.92708 0.522892 -0.825308
0.213189 45 67 42
...
This is the header portion of our file. It specifies the format,
ply
, the encoding
format ascii 1.0
,thenumberofvertices,andthenthecolumnnamesforeach
of the data returned,
x
,
y
,
z
,
nx
,
ny
,
nz
,
red
,
green
, and
blue
.
ForimportintoPostGIS,wewillimportallfields,butwillfocuson
x
,
y
,and
z
forour
pointcloud,aswellaslooktocolor.Forourinterests,thisfilespecifiesrelativex,y,
andzcoordinatesandthecolorofeachofthosepointsinchannels
red
,
green
,and
blue
. These colors are 24-bit colors—8 bits for each channel—and thus, they can
have integer values between 0 and 255.
Fortheremainderoftherecipe,letuscreateatableintowhichwewillenterthepoint
cloud data and get some SfM point cloud data into our database.
