[postgis-users] pointcloud extentions

[Rémi Cura]

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 <mkabeer at tamimicg.com>:

> 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:Ralf.Suhr at itc-halle.de]
> Sent: Wednesday, August 20, 2014 4:50 PM
> To: postgis-users at lists.osgeo.org
> 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:mkabeer at tamimicg.com]
> > Sent: Wednesday, August 20, 2014 2:07 PM
> > To: 'PostGIS Users Discussion'
> > Cc: mkabeer at tamimicg.com
> > 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:mkabeer at tamimicg.com]
> > Sent: Wednesday, August 20, 2014 1:50 PM
> > To: 'PostGIS Users Discussion'
> > Cc: mkabeer at tamimicg.com
> > 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: postgis-users-bounces at lists.osgeo.org
> > [mailto:postgis-users-bounces at lists.osgeo.org] 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 <mkabeer at tamimicg.com> 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: postgis-users-bounces at lists.osgeo.org
> > [mailto:postgis-users-bounces at lists.osgeo.org] 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 <mkabeer at tamimicg.com> 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
> > postgis-users at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> >
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140820/14188d47/attachment.html>