[pgpointcloud] Overlapping patches

[Paul Ramsey]

On January 30, 2014 at 5:12:51 AM, Nilesh Vyavahare (nilesh.vyavahare at seazone.com) wrote:
Hello everyone,

1) I am using PDAL pcpipeline to upload some data into Postgres. In the pcpipeline I have specified to split the data into the patches of 400 points. From the demonstration example I understand that the patches will not be overlapping but when I look at the extents of patches (and the points themselves) they appear to be overlapping. I have attached the pipeline xml I am using. Am I missing some trick here?

I’ll wait for Howard to answer this one, but even if the patches are not perfectly non-overlapping that’s not the end of the world, pgpointcloud really doesn’t care either way, and patches that are “mostly not overlapping” will be just as efficient as ones “totally not overlapping"

2) Another thing I was wondering is that, in PDAL you have one filter called “filters.hexabin” which is supposed draw an outline around the patch. At the moment the only way I could get the patch extent out, is to write out an xml file. Is there any way to write that extent into PostGIS directly next to the patch?

You can get the extent of the patch just by casting it to geometry.  To experience, just

select st_astext(mypatch::geometry) from mytable;

Now, it may be that I made the wrong choice in that cast and it should create a multi-point, but I’m sticking with it for now. Folks who want points can also explode their patches first. Casting a pcpoint to geometry returns a pointz.

P.






 

Just a note, in case you are specifying pre_sql/post_sql inside your pipeline, specifying the SQL statement inside the pipeline xml file didn’t work for me so I had to write SQL statement in some other file and put the location of that sql file in there and it worked.

 

Thanks in advance for your help.

 

Regards,

Nilesh

 

Nilesh Vyavahare
Senior GIS Analyst, SeaZone

E: nilesh.vyavahare at seazone.com
T: +44 (0)1491 822861





SeaZone
Howbery Park, Wallingford, Oxfordshire OX10 8BA, United Kingdom
T: +44 (0)870 013 0607     F: +44 (0)870 013 0608
www.seazone.com




SeaZone uses faxes and emails for confidential and legally privileged business communications. They do not of themselves create legal commitments. Disclosure to parties other than addressees requires our specific consent. We are not liable for unauthorised disclosures nor reliance upon them.
If you have received this message in error please advise us immediately and destroy all copies of it.

SeaZone is a division of HR Wallingford Limited.
Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom
Registered in England No. 2562099

- Pipeline_Template.xml, 4 KB
_______________________________________________ 
pgpointcloud mailing list 
pgpointcloud at lists.osgeo.org 
http://lists.osgeo.org/cgi-bin/mailman/listinfo/pgpointcloud
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20140130/bc99178d/attachment-0001.html>