[pgpointcloud] how define schema to store double data?

[Zhiyong Weng]

Thank you. I am new with postGIS and pointcloud extension, I use simple sql
to insert point.

I did some homework and found it is PC_AsText, which lost precision when
build JSON string.
if use PC_Get, the precision is correct.

2015-11-17 6:17 GMT+08:00 Howard Butler <howard at hobu.co>:

>
> > On Nov 15, 2015, at 7:49 PM, Zhiyong Weng <zhiyong.weng at gmail.com>
> wrote:
> >
> > Hi All,
> >
> >    I try to store double data like point(-127.12345678, 45.12345678,
> 124.012345678, 4.012345678), I want keep the full precision.
> >    and I define pc:interpretation is double,
> >    but when I get data from db,only get 6 precision double,like this:
> > SELECT PC_AsText(PC_MakePoint(8, ARRAY[-127.123456, 45.123456,
> 124.0123456, 4.0123456]));
> > "{"pcid":8,"pt":[-127.123,45.1235,124.012,4.01235]}"
> >
> >    How shall I define the schema? Thanks.
> >
> >   attached my schema file.
>
> Are you using a PDAL pipeline or something to insert your data? We need
> more information to be able to help you.
>
> Howard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20151117/35dc7852/attachment.html>