<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
{<br>
"pipeline": [<br>
{<br>
"type": "readers.las",<br>
"filename": "c:\\tmp\input.laz"<br>
},<br>
{<br>
"type":"filters.chipper",<br>
"capacity":5000<br>
},<br>
{<br>
"type": "writers.pgpointcloud",<br>
"connection": "host=...",<br>
"table": "test_1",<br>
"compression":"none",<br>
"output_dims":"X,Y,Z"<br>
}<br>
]<br>
}</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<hr tabindex="-1" style="width: 98%; display: inline-block;">
<div id="divRplyFwdMsg" dir="ltr"><font color="#000000" face="Calibri, sans-serif" style="font-size: 11pt;"><b>Fra:</b> Andrew Bell <andrew.bell.ia@gmail.com><br>
<b>Sendt:</b> fredag 6. juli 2018 16.06<br>
<b>Til:</b> Lars<br>
<b>Kopi:</b> pdal@lists.osgeo.org<br>
<b>Emne:</b> Re: [pdal] Pgpointcloud writer SRID</font>
<div> </div>
</div>
<meta content="text/html; charset=utf-8">
<div>
<div dir="ltr">There is no attached file, so it's hard to see what the issue might be. Please just reply with the pipeline in question.
<div><br>
</div>
<div>Thanks,</div>
</div>
<div class="x_gmail_extra"><br>
<div class="x_gmail_quote">On Fri, Jul 6, 2018 at 7:33 AM, Lars <span dir="ltr"><<a href="mailto:laasunde@hotmail.com" target="_blank">laasunde@hotmail.com</a>></span> wrote:<br>
<blockquote class="x_gmail_quote" style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid;">
<div dir="ltr">
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
Hello,</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
We used a pipeline (see attched file) to read a laz file and write it to pgpointcloud. The pipeline was able to write data to database but we notice the SRID was incorrect. Turns out the laz was using UTM Zone and pgpointcloud used 4326 (the default). By adding
a reprojection filter to the pipeline we were able to fix the issue.</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
We mistakenly thought that pgpointcloud would "reproject" the input data to srid 4326 but it makes sense the this task belongs in a filter.</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
It is unfortunte that PDAL allowed us to create what I consider is invalid data which could have been prevented. The "srid" parameter used in the pipeline appears to be a string with sole purpose of being added to the pointcloud_formats table. In pgpointcloud
witer, would it be possible to use input-srid (in_srs) as default if available instead of always using 4326? Another option could be to give the user a warning if input-srs does not match the "srid" specified for pgpointcloud writer.</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
It might be worth adding more information about pgpointcloud writer "srid" to the documentation to help others.</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
Kind regards, Lars</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
</div>
<br>
______________________________<wbr>_________________<br>
pdal mailing list<br>
<a href="mailto:pdal@lists.osgeo.org">pdal@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pdal" target="_blank" rel="noreferrer">https://lists.osgeo.org/<wbr>mailman/listinfo/pdal</a><br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div class="x_gmail_signature">Andrew Bell<br>
<a href="mailto:andrew.bell.ia@gmail.com" target="_blank">andrew.bell.ia@gmail.com</a></div>
</div>
</div>
</body>
</html>