[pgpointcloud] pointcloud version and variant

Thu Apr 26 01:16:48 PDT 2018

Thanks.

First of all,  I do not know what kind of versioning schema pointcloud is using.  The pointcloud "packge" is called "1.1.0(dev)" and the pointcloud and pointcloud_postgis extensions have version 1.1.0 and 1.0 respectively. It appears that all these versions have not been changed in some time (?) but the code has been updated. From an outside perspective it is difficult to know if you are using the latest version of pointcloud hence my comment about considering to increment a version number. This is just an observation 😊

________________________________
Fra: Regina Obe <lr at pcorp.us>
Sendt: 26. april 2018 09:36
Til: 'Lars'; pgpointcloud at lists.osgeo.org
Kopi: 'Éric Lemoine'
Emne: RE: [pgpointcloud] pointcloud version and variant

Okay I'll add that.  I had put it in the readme that neither is included yet but LAZPERF I will try to include.

Version number?  Where are you looking?

From: Lars [mailto:laasunde at hotmail.com]
Sent: Thursday, April 26, 2018 2:56 AM
To: Regina Obe <lr at pcorp.us>; pgpointcloud at lists.osgeo.org
Cc: 'Éric Lemoine' <eric.lemoine at oslandia.com>
Subject: Sv: [pgpointcloud] pointcloud version and variant

Regina,

Thank you so much for your help.

I will update to newest extension 😊

If you are making a new official release maybe consider updating the version number which I believe has been fixed since 2015.

Just a minor request, would it be possible to include if GHT and/or LAZPERF is enabled in the pgpointcloud_version.txt?

kind regards Lars

________________________________

Fra: Regina Obe <lr at pcorp.us<mailto:lr at pcorp.us>>
Sendt: 25. april 2018 21:12
Til: 'Lars'; pgpointcloud at lists.osgeo.org<mailto:pgpointcloud at lists.osgeo.org>
Kopi: 'Éric Lemoine'
Emne: RE: [pgpointcloud] pointcloud version and variant

Lars,

I've rebuilt the 9.5, 9.6, 10 64-bit builds with the latest head.  It should have a pgpointcloud_version.txt

With content - GIT_REVISION: HEAD detached at 0146bd7

Please use this one and you should have the function you are missing.

https://winnie.postgis.net/download/windows/pg95/buildbot/extras/pointcloud-pg95-binaries-1.1.0devw64gcc48.zip

I didn't test though because I think the tests require liblas compression included, which I haven't revised the builds to build with.  I'll reenable the tests after I have the liblas compression in place.

I don't plan to build with libght since it was difficult to build the library and Paul had told me a while ago (not sure if it's still true) that libght didn't provide much of a performance improvement and was an experimental format.

Eric,

If you want to go ahead and tag an official release for this, that would be great especially since the currently released doesn't work past PostgreSQL 9.5.

Thanks,

Regina

From: Regina Obe [mailto:lr at pcorp.us]
Sent: Wednesday, April 25, 2018 10:41 AM
To: 'Lars' <laasunde at hotmail.com<mailto:laasunde at hotmail.com>>; 'pgpointcloud at lists.osgeo.org' <pgpointcloud at lists.osgeo.org<mailto:pgpointcloud at lists.osgeo.org>>
Subject: RE: [pgpointcloud] pointcloud version and variant

Just a note, I'm running the PostgreSQL 10.3 windows build and I DO see a

pc_envelopegeometry(pcpatch)  function.

Also looking at the latest built, pointcloud for 9.5 which is here:

https://winnie.postgis.net/download/windows/pg95/buildbot/extras/

I do see a version.txt file, which does include the HASH info of the git repo, the sql file.

I confirm does seem to be missing the PC_EnvelopeGeometry function.

POSTGIS POINTCLOUD: 1.1.0dev

PostgreSQL: 9.5 w64

Built: 20160607

GIT_REPO: https://github.com/pointcloud/pointcloud

GIT_BRANCH: origin/master

GIT_REVISION: 206bd54c459c53ef158e36389d80d25ba79e9183

Is there a reason you can't use the newer PostgreSQL 9.6 or 10? (though I see for some reason though those are newer, the version.txt file was not added so I'll revisit that)

Anyway when I build next I'll build newer for PostgreSQL 9.5 as well so will have that function.

From: pgpointcloud [mailto:pgpointcloud-bounces at lists.osgeo.org] On Behalf Of Lars
Sent: Wednesday, April 25, 2018 6:58 AM
To: pgpointcloud at lists.osgeo.org<mailto:pgpointcloud at lists.osgeo.org>
Subject: [pgpointcloud] pointcloud version and variant

Hello,

Running Win7+SP1, PostgreSQL 9.5 and bundle95x64_2.3.0.1.

•  The following query produces "function pc_envelopegeometry does not exist"

•  SELECT ST_AsText(PC_EnvelopeGeometry(pa)) FROM patches LIMIT 5;

The following query works are expected:

SELECT PC_Intersects('SRID=4326;POINT(-126.451 45.552)'::geometry, pa) FROM patches limit 5;

Why is PC_Intersects available but not PC_EnvelopGeometry when both are listed in PointCloud documentation?

How can I determine if I am running latest version of pointcloud extension?

How can I determine if pointcloud is built with GHT and/or LAZPERF ?

•  Opening psql and running the following command;

\d po*

postgis 2.3.0

pointcloud 1.1.0

pointcloud_postgis 1.0

kind regards, Lars

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20180426/1a745128/attachment-0001.html>