[postgis-users] pointcloud extentions

[Mohammed Kabeer]

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 | Skype: mkabeer2000
Riyadh, Saudi Arabia

 

[Nicolas Ribot]

Hi,

This extension is not part of standard postgis installation (afaik).

You have to install it manually: https://github.com/pramsey/pointcloud

Nicolas

_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[Mohammed Kabeer]

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

[Nicolas Ribot]

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

[Mohammed Kabeer]

Dear Sir,

 

Right now I have windows environment existing

 

You mean I need to move to linux environment or how

[Mohammed Kabeer]

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

[Mohammed Kabeer]

Dear sir,

 

Would you please guide me how can I install that pointcloud package in my postgis on windows

 

Thanks once again

[Ralf Suhr]

Have a look at https://www.google.com/search?q=pointcloud+postgis+windows

> Tel +966 1217 0152 | Mobile +966 545548353 <tel:%2B966%20545548353> |

> Skype: mkabeer2000 Riyadh, Saudi Arabia
>

[Mohammed Kabeer]

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

[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

[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