writers.sqlite¶
The SQLite driver outputs point cloud data into a PDAL-sepecific scheme that matches the approach of readers.pgpointcloud and readers.oci.
Dynamic Plugin
This stage requires a dynamic plugin to operate
Example¶
[
{
"type":"readers.las",
"filename":"inputfile.las"
},
{
"type":"filters.chipper",
"capacity":50
},
{
"type":"writers.sqlite",
"connection":"output.sqlite",
"cloud_table_name":"SIMPLE_CLOUD",
"pre_sql":"",
"post_sql":"",
"block_table_name":"SIMPLE_BLOCKS",
"cloud_column_name":"CLOUD",
"filename":"outputfile.pcd"
}
]
Options¶
- connection
SQLite filename [Required]
- cloud_table_name
Name of table to store cloud (file) information [Required]
- block_table_name
Name of table to store patch information [Required]
- cloud_column_name
Name of column to store primary cloud_id key [Default: “cloud”]
- compression
Use LAZperf compression technique to store patches. [Default: false]
- overwrite
Drop the table before writing. To append to the table set to
false
. [Default: true]- pre_sql
Optional SQL to execute before running the translation. If the value references a file, the file is read and any SQL inside is executed. Otherwise the value is executed as SQL itself.
- post_sql
Optional SQL to execute after running the translation. If the value references a file, the file is read and any SQL inside is executed. Otherwise the value is executed as SQL itself.
- scale_x, scale_y, scale_z / offset_x, offset_y, offset_z
If ANY of these options are specified the X, Y and Z dimensions are adjusted by subtracting the offset and then dividing the values by the specified scaling factor before being written as 32-bit integers (as opposed to double precision values). If any of these options is specified, unspecified scale_<x,y,x> options are given the value of 1.0 and unspecified offset_<x,y,z> are given the value of 0.0.
- output_dims
If specified, limits the dimensions written for each point. Dimensions are listed by name and separated by commas.
- where
An expression that limits points passed to a writer Points that don’t pass the expression skip the stage but are available to chained writers in a pipeline. [Default: no filtering]