Hello,
does any postgis implementation of ST_SimplifyPreserveTopology preserve
contains property for polygons and multilines, that is, if I have a
(Multi)Polygon Parent and a (Multi)Linestring/(Multi)Polygon Child s.t.
ST_Contains(Parent, Child) holds, will
Hi Paul,
I suspect I know the answer to this (“no”), but to confirm, is the disk saving
for points going to apply to points stored using the pointcloud extension in a
postgis database?
Thanks,
Jonathan
From: postgis-users-boun...@lists.osgeo.org
[mailto:postgis-users-boun...@lists.osgeo.org]
Hum you can do a simple test,
for the table you are using,
look at the pgpoint column type number (called pcid)
You can know this like this
SELECT pc_astext(pt)
FROM xyz_patches, pc_explode(pa) as pt
LIMIT 1
Know look into public.pointcloud_formats, the xml schema corresponding to
Hi Rémi,
Thanks for the reply and information.
I’m afraid I inherited this database and don’t know much about it (or
pointcloud).
Looking into though, I doubt it’s compressed, we extract the data with:
select block_id , pc_get(pc_explode(pa), 'X') as x, pc_get(pc_explode(pa), 'Y')
as y,