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 subsequent stages in a pipeline. [Default: no filtering]
where_merge: A strategy for merging points skipped by a ‘where’ option when running in standard mode. If true, the skipped points are added to the first point view returned by the skipped filter. If false, skipped points are placed in their own point view. If auto, skipped points are merged into the returned point view provided that only one point view is returned and it has the same point count as it did when the writer was run. [Default: auto]