[postgis-users] pointcloud extentions

[Rémi Cura]

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 <remi.cura at gmail.com>:

> 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/b0d68162/attachment.html>