# readers.sqlite

The SQLite Reader allows you to read data stored in a SQLite database using a scheme that PDAL wrote using the writers.sqlite writer. The SQLite driver stores data in tables that contain rows of patches. Each patch contains a number of spatially contiguous points

Dynamic Plugin

This stage requires a dynamic plugin to operate

## Example

    [
        {
            "type":"readers.sqlite",
            "connection":"inputfile.sqlite",
            "query":"SELECT b.schema, l.cloud, l.block_id, l.num_points, l.bbox, l.extent, l.points, b.cloud\r\n                      FROM simple_blocks l, simple_cloud b\r\n                     WHERE l.cloud = b.cloud and l.cloud in (1)\r\n                    order by l.cloud"
        },
        {
            "type":"writers.las",
            "filename":"outputfile.las"
        }
    ]

## Options

query

  SQL statement that selects a schema XML, cloud id, bbox, and extent [Required]

count

  Maximum number of points to read. [Default: unlimited]

override_srs

  Spatial reference to apply to the data. Overrides any SRS in the input itself. Can be specified as a WKT, proj.4 or EPSG string. Can’t use with ‘default_srs’ [Default: none]

default_srs

  Spatial reference to apply to the data if the input does not specify one. Can be specified as a WKT, proj.4 or EPSG string. Can’t use with ‘override_srs’ [Default: none]