Provided by: liblas-bin_1.8.1-6build1_amd64 
NAME
las2col - LAS translation to MonetDB binary format
SYNOPSIS
las2col [OPTIONS]
DESCRIPTION
las2col performs LAS translation to MonetDB binary format with optional configuration.
OPTIONS
-h, -help, --help
produce help message
-v, --verbose
Verbose message output
--num_read_threads number
Set number of threads
-s, --skip_invalid
Skip writing invalid point(s)
-parse string, --parse string
Specify which entries of the LAS/LAZ will be extracted (default is xyz). For example, 'txyzia'
means that six columnar (binary) MonetDB files will be generated, the first one containing all
gpstime values, the next three containing values for x, y, and z coordinates, the next one with
intensity values and the last one with scan angle values. The supported entries are:
t - gpstime as double
x - x coordinate as double
y - y coordinate as double
z - z coordinate as double
X - x coordinate as decimal(num_digits_unscaled_max_x,num_digits_scale_x)
Y - y coordinate as decimal(num_digits_unscaled_max_y,num_digits_scale_y)
Z - z coordinate as decimal(num_digits_unscaled_max_z,num_digits_scale_z)
a - scan angle as tinyint
i - intensity as smallint
n - number of returns for given pulse as smallint
r - number of this return as smallint
c - classification number as tinyint
u - user data as tinyint
p - point source ID as smallint
e - edge of flight line as smallint
d - direction of scan flag as smallint
R - red channel of RGB color as smallint
G - green channel of RGB color as smallint
B - blue channel of RGB color as smallint
M - vertex index number as integer
k - Morton 2D code using X and Y (unscaled and no offset) as bigint
-moffset x,y, --moffset x,y
Specify a global offset in X and Y to be used when computing the Morton 2D code. Values must be
unscaled
-check x,y, --check x,y
Check suitability to compute Morton 2D codes. It checks specified scale matches the one in input
file. If --moffset is provided it also checks that obtained Morton 2D codes will be consistent,
i.e. global X,Y within [0,2^31]
-i arg, -in arg, -input arg, --input arg
file with the list las/laz files
-f arg, -file arg, --file arg
input LAS file
-o arg, -out arg, --out arg, --output arg
output prefix
EXAMPLE
Convert a las/laz file into columnar format (binary) of MonetDB, outputs for each entry a file
output_prefix_col_entry_name.dat:
las2col -i input_file -o output_prefix
Convert a list of las/laz files (still outputs for each entry a file output_prefix_col_entry_name.dat):
las2col -i las_file_1 -i las_file_2 -o output_prefix
Alternatively:
las2col -f file_with_the_list_las/laz_files -o output_prefix
Convert a list of las/laz files using num_read_threads threads (default is 1):
las2col -f file_with_the_list_las/laz_files -o output_prefix --num_read_threads number_of_threads
After generating the columnar files, import them in MonetDB. Example:
mclient db_name -s "COPY BINARY INTO flat FROM ('full_parent_path/out_col_x.dat','full_parent_path/out_col_y.dat','full_parent_path/out_col_z.dat')"
Note that full paths of the columnar files MUST be used. Also note that a table called flat has to be
created in a MonetDB DB beforehand. The table must have the columns in the same order as specified by
the --parse option, and the column types must be the ones specified above. Example:
mclient db_name -s "create table flat (x double, y double, z double)"
Note that for decimal entries (XYZ) the column definition at table-creation time must be
decimal(num_digits_unscaled_max,num_digits_scale) For example, if the maximum X value of a file (or a
list of files) is 638982.55, then the X definition when creating the table is decimal(8,2). Example:
mclient db_name -s "create table flat (x decimal(8,2), y decimal(8,2), z decimal(8,2))"
17 December 2017 las2col(1)