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
