You have several ways. Essentially, look here toward the end : https://github.com/pramsey/pointcloud to do it using PDAL
You can use another way that is LAS File *--las tools-->* CSV File *---COPY statement-->* table(X,Y,Z,Intensity...) *-- PC_Patch(PC_Point(X,Y,Z ..))-->* patch table Of course you need first to create the appropriate schema. You can take inspiration and explanation and code from here : https://github.com/Remi-C/Pointcloud_in_db It may be an overkill (designed to be used on several billions point cloud) (if you really want to use it, you'll have to use a exe converting from Las to csv.) Cheers, Rémi-C 2014-08-20 16:47 GMT+02:00 Mohammed Kabeer <[email protected]>: > Thank you sir > > I copied those files and working > > How to create pointcloud table and How to store .las files in in my postgis > pointclolud table > > Thanks once again for your help > > Kabeer > > -----Original Message----- > From: Ralf Suhr [mailto:[email protected]] > Sent: Wednesday, August 20, 2014 4:50 PM > To: [email protected] > Cc: Mohammed Kabeer > Subject: Re: [postgis-users] pointcloud extentions > > Have a look at https://www.google.com/search?q=pointcloud+postgis+windows > > Am Mittwoch 20 August 2014, 16:36:51 schrieb Mohammed Kabeer: > > Dear sir, > > > > > > > > Would you please guide me how can I install that pointcloud package in > > my postgis on windows > > > > > > > > Thanks once again > > > > Kabeer > > > > > > > > From: Mohammed Kabeer [mailto:[email protected]] > > Sent: Wednesday, August 20, 2014 2:07 PM > > To: 'PostGIS Users Discussion' > > Cc: [email protected] > > Subject: RE: [postgis-users] pointcloud extentions > > > > > > > > It will be easier, though, to install a PostGIS version on a Linux > > box, then tell OpenGeoSuite to use this installation > > > > > > > > How can I do this process > > > > > > > > Thanks > > > > Kabeer > > > > > > > > From: Mohammed Kabeer [mailto:[email protected]] > > Sent: Wednesday, August 20, 2014 1:50 PM > > To: 'PostGIS Users Discussion' > > Cc: [email protected] > > Subject: RE: [postgis-users] pointcloud extentions > > > > > > > > Dear Sir, > > > > > > > > Right now I have windows environment existing > > > > > > > > You mean I need to move to linux environment or how > > > > > > > > Thanks > > > > Kabeer > > > > > > > > From: [email protected] > > [mailto:[email protected]] On Behalf Of Nicolas > > Ribot > > Sent: Wednesday, August 20, 2014 1:27 PM > > To: PostGIS Users Discussion > > Subject: Re: [postgis-users] pointcloud extentions > > > > > > > > I guess you have to install Cygwin or another Linux env on Windows, > > then install all necessary packages and compile PointCloud. > > > > > > > > It will be easier, though, to install a PostGIS version on a Linux > > box, then tell OpenGeoSuite to use this installation. > > > > > > > > Nicolas > > > > > > > > > > > > On 20 August 2014 12:17, Mohammed Kabeer <[email protected]> wrote: > > > > Thank you very much > > > > > > > > How to install in windows environment > > > > > > > > // Create file as pointcloud.control and copy following code in it > > > > > > > > > > # pointcloud extension > > > > > > comment = 'data type for lidar point clouds' > > > > > > default_version = '1.0' > > > > > > module_pathname = '$libdir/pointcloud' > > > > > > relocatable = true > > > > > > superuser = true > > > > > > #requires = 'postgis' > > > > > > > > Would you please guide me how to install in windows > > > > > > > > > > > > > > Thanks > > > > Kabeer > > > > > > > > From: [email protected] > > [mailto:[email protected]] On Behalf Of Nicolas > > Ribot > > Sent: Wednesday, August 20, 2014 1:09 PM > > To: PostGIS Users Discussion > > Subject: Re: [postgis-users] pointcloud extentions > > > > > > > > Hi, > > > > > > > > This extension is not part of standard postgis installation (afaik). > > > > You have to install it manually: https://github.com/pramsey/pointcloud > > > > > > > > Nicolas > > > > > > > > On 20 August 2014 11:37, Mohammed Kabeer <[email protected]> wrote: > > > > Dear Sir, > > > > > > > > I installed postgis with opengeosuit4. 1 (OpenGeoSuite-latest.exe) and > > created database and working fine > > > > > > > > I run CREATE EXTENSION postgis: // working fine > > > > > > > > But when I run CREATE EXTENSION pointcloud; // it gives me ERROR: > > could not open extension control file "C:/Program Files > > (x86)/Boundless/OpenGeo/bin/../pgsql/share/extension/pointcloud.control": > > No such file or directory > > > > SQL state: 58P01 > > > > > > > > How to fix this problem > > > > > > > > Thanks > > > > Kabeer > > > > > > > > Mohammed Kabeer Ahmed | Spatial Technologies| Tamimi Consulting Group| > > > > Tel +966 1217 0152 | Mobile +966 545548353 <tel:%2B966%20545548353> | > > Skype: mkabeer2000 Riyadh, Saudi Arabia > > > > specialistCard > > > > > > > > > > _______________________________________________ > > postgis-users mailing list > > [email protected] > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > > > > > > > > > _______________________________________________ > > postgis-users mailing list > > [email protected] > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
