[pgpointcloud] how define schema to store double data?

Howard Butler howard at hobu.co
Mon Nov 16 14:17:36 PST 2015


> 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


More information about the pgpointcloud mailing list