oups, forget you use windows. My code is bash script, won't be able to use it. However the sql inside the bash may be usefull.
Cheers, Rémi-C 2014-08-20 19:37 GMT+02:00 Rémi Cura <[email protected]>: > 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
