You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
createtablesource_point_clouds_partitioned
(
id bigserialnot null,
patch pcpatch not null
);
Create a patch with one point:
INSERT INTO source_point_clouds_partitioned (patch) VALUES(PC_MakePatch(9, ARRAY[525282.053, 7179377.239, -13.125]));
Retrieve point:
SELECT PC_AsText(patch) pa from source_point_clouds_partitioned;
Output:
{"pcid":9,"pts":[[525282,7.17938e+06,-13.125]]}
Note the discrepancy between Y value inserted and retrieved. It was rounded from 7179377.239 to 7179380.
How can I store coordinates without loss of precision?
Thank you.
The text was updated successfully, but these errors were encountered:
Description
Coordinates get rounded off when retrieving point data with PC_AsText function.
Step to reproduce
Have pointcloud_postgis installed on postgresql 12.
DBMS: PostgreSQL (ver. 12.10 (Debian 12.10-1.pgdg110+1)) Case sensitivity: plain=lower, delimited=exact Driver: PostgreSQL JDBC Driver (ver. 42.2.5, JDBC4.2)
Create pointcloud_formats definition below as pcid 9:
Create a table for patch data:
Create a patch with one point:
Retrieve point:
Output:
Note the discrepancy between Y value inserted and retrieved. It was rounded from 7179377.239 to 7179380.
How can I store coordinates without loss of precision?
Thank you.
The text was updated successfully, but these errors were encountered: