[postgis-users] Lidar & 3D data handling & processin with Postgis

[Regina Obe]

Wow looks like you have a lot of postgis related extensions there.  Pretty much the full list I am aware of.

The extension designed for storing point cloud data (LIDAR) are the pointcloud and pointcloud_postgis.
Pointcloud has all the pointcloud specific types and functions.  Pointcloud_postgis is mostly a bridge extension to allow switching between pcpatch / postgis geometry types.

The documentation pointcloud is here:

https://pgpointcloud.github.io/pointcloud/

Hope that helps,
Regina


> -----Original Message-----
> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
> Of Raivo Rebane
> Sent: Thursday, March 2, 2023 10:43 AM
> To: postgis-users at lists.osgeo.org
> Subject: [postgis-users] Lidar & 3D data handling & processin with Postgis
> 
> Hi
> 
> How can I save Lidar data and other 3D data into postgis database, if I have
> following extensions in my database :
> 
> lidar0=> \dx
> 
> List of installed extensions
>            Name          | Version |   Schema
> |                                                     Description
> ------------------------+---------+------------+------------------------
> ------------------------+---------+------------+------------------------
> ------------------------+---------+------------+------------------------
> ------------------------+---------+------------+------------------------
> ------------------------+---------+------------+---------------------
> 
>   address_standardizer   | 3.3.2   | public     | Used to parse an address into
> constituent elements. Generally used to support geocoding address
> normalization step.
>   fuzzystrmatch          | 1.1     | public     | determine similarities and distance
> between strings
>   h3                     | 4.0.3   | public     | H3 bindings for PostgreSQL
>   h3_postgis             | 4.0.3   | public     | H3 PostGIS integration
>   ogr_fdw                | 1.1     | public     | foreign-data wrapper for GIS data
> access
>   pgrouting              | 3.4.2   | public     | pgRouting Extension
>   plpgsql                | 1.0     | pg_catalog | PL/pgSQL procedural language
>   pointcloud             | 1.2.4   | public     | data type for lidar point clouds
>   pointcloud_postgis     | 1.2.4   | public     | integration for pointcloud LIDAR
> data and PostGIS geometry data
>   postgis                | 3.3.2   | public     | PostGIS geometry and geography
> spatial types and functions
>   postgis_raster         | 3.3.2   | public     | PostGIS raster types and functions
>   postgis_sfcgal         | 3.3.2   | public     | PostGIS SFCGAL functions
>   postgis_tiger_geocoder | 3.3.2   | tiger      | PostGIS tiger geocoder and
> reverse geocoder
>   postgis_topology       | 3.3.2   | topology   | PostGIS topology spatial types
> and functions (
> 
> And how can operate in Postgis database with following extensions with 3D
> data.
> 
> Please send me links to User Manuals and exaples
> 
> Regards
> 
> Raivo
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users