[pdal] Pgpointcloud writer SRID

[Lars]

{
  "pipeline": [
    {
      "type": "readers.las",
      "filename": "c:\\tmp\input.laz"
    },
    {
      "type":"filters.chipper",
      "capacity":5000
    },
    {
      "type": "writers.pgpointcloud",
      "connection": "host=...",
      "table": "test_1",
      "compression":"none",
      "output_dims":"X,Y,Z"
    }
  ]
}


________________________________
Fra: Andrew Bell <andrew.bell.ia at gmail.com>
Sendt: fredag 6. juli 2018 16.06
Til: Lars
Kopi: pdal at lists.osgeo.org
Emne: Re: [pdal] Pgpointcloud writer SRID

There is no attached file, so it's hard to see what the issue might be.  Please just reply with the pipeline in question.

Thanks,

On Fri, Jul 6, 2018 at 7:33 AM, Lars <laasunde at hotmail.com<mailto:laasunde at hotmail.com>> wrote:
Hello,

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.

We mistakenly thought that pgpointcloud would "reproject" the input data to srid 4326 but it makes sense the this task belongs in a filter.

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.

It might be worth adding more information about pgpointcloud writer "srid" to the documentation to help others.

Kind regards, Lars


_______________________________________________
pdal mailing list
pdal at lists.osgeo.org<mailto:pdal at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/pdal



--
Andrew Bell
andrew.bell.ia at gmail.com<mailto:andrew.bell.ia at gmail.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pdal/attachments/20180711/f280b741/attachment.html>