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:[email protected]] > Sent: Thursday, March 2, 2023 10:48 AM > To: 'PostGIS Users Discussion' <[email protected]> > 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:[email protected]] On > > Behalf Of Raivo Rebane > > Sent: Thursday, March 2, 2023 10:43 AM > > To: [email protected] > > 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 > > [email protected] > > https://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
