Raw Package Information
Package: postgresql-9.6-pointcloud
Source: pgpointcloud
Version: 1.2.1-8.pgdg20.04+1
Architecture: amd64
Maintainer: Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org>
Installed-Size: 262
Depends: postgresql-9.6, libc6 (>= 2.14), libxml2 (>= 2.7.4), zlib1g (>= 1:1.1.4)
Homepage: https://github.com/pgpointcloud/pointcloud
Priority: optional
Section: database
Filename: pool/main/p/pgpointcloud/postgresql-9.6-pointcloud_1.2.1-8.pgdg20.04+1_amd64.deb
Size: 64412
SHA256: b4d7083f0733c94e0e2723ec51e3f9513025a8dd7b25615cacb1b0afb9b0059e
SHA1: 7d886a0435f373fe5bb7ce402da9bb5f3974c3a4
MD5sum: 31d7952d5de8ef28c90824c680a87d25
Description: PostgreSQL extension for storing point cloud (LIDAR) data
LIDAR sensors quickly produce millions of points with large numbers of
variables measured on each point. The challenge for a point cloud database
extension is efficiently storing this data while allowing high fidelity access
to the many variables stored.
.
Much of the complexity in handling LIDAR comes from the need to deal with
multiple variables per point. The variables captured by LIDAR sensors varies
by sensor and capture process. Some data sets might contain only X/Y/Z values.
Others will contain dozens of variables: X, Y, Z; intensity and return number;
red, green, and blue values; return times; and many more. There is no
consistency in how variables are stored: intensity might be stored in a 4-byte
integer, or in a single byte; X/Y/Z might be doubles, or they might be scaled
4-byte integers.
.
PostgreSQL Pointcloud deals with all this variability by using a "schema
document" to describe the contents of any particular LIDAR point. Each point
contains a number of dimensions, and each dimension can be of any data type,
with scaling and/or offsets applied to move between the actual value and the
value stored in the database. The schema document format used by PostgreSQL
Pointcloud is the same one used by the PDAL library.