[pgpointcloud] [EXTERNAL] readers.pgpointcloud to writers.las

[Dean.Hand.ctr at nga.mil]

Classification: UNCLASSIFIED
======================================================

Got it.  Scale and offset.

PC_Intersects(pa, ST_MakeEnvelope(560037.36, 5114846.45, 562667.31, 5118943.24, 26910)) gives a rectangle.

How do you get the radius in METERS?  ST_DWithin((560037.36,  5114846.31, 26910, 200); ?

-----Original Message-----
From: pgpointcloud-bounces at lists.osgeo.org [mailto:pgpointcloud-bounces at lists.osgeo.org] On Behalf Of Dean.Hand.ctr at nga.mil
Sent: Tuesday, August 04, 2015 4:44 PM
To: howard at hobu.co
Cc: Michael.Smith at erdc.dren.mil; pgpointcloud at lists.osgeo.org
Subject: Re: [pgpointcloud] [EXTERNAL] readers.pgpointcloud to writers.las

Classification: UNCLASSIFIED
======================================================

I ran several queries on my database.  It appears to be good.
1. The patches view renders in openlayers 2. pc_explode returns  good info with varying geometries, like so:
{p "pcid": 6 "pt": [128,0,0,1,0,0,0,0,0,0,0,0,0,lng,lat,ele,i]}

When I export, I request in Decimal degrees with like so:
 -90.21385, 38.63989,-90.20398, 38.63353

The LAS file that is produced has four columns of textured points and the coordinates are rounded to the nearest 100th like so:
-90.21000, 38.64000, -90.20000, 38.63000

Dean

-----Original Message-----
From: Howard Butler [mailto:howard at hobu.co]
Sent: Tuesday, August 04, 2015 10:12 AM
To: Hand Dean NGA-II USA CTR
Cc: Mike Smith; pgpointcloud at lists.osgeo.org
Subject: Re: [pgpointcloud] [EXTERNAL] readers.pgpointcloud to writers.las

Attempt to confirm that the query is returning the correct data into psql and determine whether or not PDAL or the PDAL pipeline is the issue.

> On Aug 4, 2015, at 10:09 AM, <Dean.Hand.ctr at nga.mil> <Dean.Hand.ctr at nga.mil> wrote:
> 
> Classification: UNCLASSIFIED
> ======================================================
> 
> That's a typo. I am using writers.las.
> 
> -----Original Message-----
> From: Smith, Michael ERDC-RDE-CRREL-NH 
> [mailto:Michael.Smith at erdc.dren.mil]
> Sent: Tuesday, August 04, 2015 9:56 AM
> To: Hand Dean NGA-II USA CTR; pgpointcloud at lists.osgeo.org
> Subject: Re: [EXTERNAL] [pgpointcloud] readers.pgpointcloud to 
> writers.las
> 
> If you are making a las file, you want writers.las, not writers.text.
> 
> Mike
> 
> --
> Michael Smith
> 
> Remote Sensing/GIS Center
> US Army Corps of Engineers
> 
> 
> 
> On 8/4/15,  10:40 AM, "pgpointcloud-bounces at lists.osgeo.org on behalf of Dean.Hand.ctr at nga.mil" <pgpointcloud-bounces at lists.osgeo.org on behalf of Dean.Hand.ctr at nga.mil> wrote:
> 
>> Classification: UNCLASSIFIED
>> ======================================================
>> 
>> I'm trying to write a .LAS file from point cloud data that's stored 
>> in my PostGIS using this .xml and pdal pipeline:
>> 
>> <?xml version="1.0" encoding="utf-8"?> <Pipeline version="1.0"> 
>> <Writer type="writers.text">
>>   <Option name="filename">output.txt</Option>
>>   <Option name="spatialreference">EPSG:4326</Option>
>>   <Reader type="readers.pgpointcloud">
>>     <Option name="connection">dbname='lidar' user='user'</Option>
>>     <Option name="table">lidar</Option>
>>     <Option name="column">pa</Option>
>>     <Option name="spatialreference">EPSG:4326</Option>
>>     <Option name="where">
>>       PC_Intersects(pa, ST_MakeEnvelope(38.6361, 
>> -90.1934,38.6294,-90.1934, 4326))
>>     </Option>
>>   </Reader>
>> </Writer>
>> </Pipeline>
>> 
>> What I get when I open it in QTM is four columns of points that I 
>> assume are the extents.  What am I doing wrong?
>> 
>> 
>> Dean E. Hand
>> Image Scientist
>> NGA | InnoVision |BITC
>> Phone:  314-676-0899
>> VOIP:  577-5860
>> SBU:  dean.hand.ctr at nga.mil
>> JWICS:  dean.hand at coe.ic.gov
>> 
>> 
>> ======================================================
>> Classification: UNCLASSIFIED
>> 
>> _______________________________________________
>> pgpointcloud mailing list
>> pgpointcloud at lists.osgeo.org
>> BLOCKEDlists.osgeo.org/cgi-bin/mailman/listinfo/pgpointcloudBLOCKED
>> 
> 
> ======================================================
> Classification: UNCLASSIFIED
> 
> _______________________________________________
> pgpointcloud mailing list
> pgpointcloud at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/pgpointcloud

======================================================
Classification: UNCLASSIFIED

_______________________________________________
pgpointcloud mailing list
pgpointcloud at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/pgpointcloud
======================================================
Classification: UNCLASSIFIED