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

[Regina Obe]

Additional note.
For loading the pointclouds, you'll want to use PDAL.

Documentation for that is here:

https://pdal.io/en/latest/stages/writers.pgpointcloud.html



> -----Original Message-----
> From: Regina Obe [mailto:lr at pcorp.us]
> Sent: Thursday, March 2, 2023 10:48 AM
> To: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>
> Subject: RE: [postgis-users] Lidar & 3D data handling & processin with Postgis
> 
> 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