[postgis-users] Does ST_SimplifyPreserveTopology preserve "contains" property

2015-03-26 Thread Igor Stassiy
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 ST_Contains(ST_SimplifyPreserveTopolog

Re: [postgis-users] 2.1.6 Released

2015-03-26 Thread Jonathan Moules
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] O

Re: [postgis-users] 2.1.6 Released

2015-03-26 Thread Rémi Cura
Hey, if you use the compression of patch and sensible xml schema, you should already have a 1:2 to 1:4 compression of the point size. (compared to binary ply in my case) Cheers, Rémi-C 2015-03-26 18:05 GMT+01:00 Jonathan Moules : > Hi Paul, > > I suspect I know the answer to this (“no”), but t

Re: [postgis-users] 2.1.6 Released

2015-03-26 Thread Paul Ramsey
"no", a different kind of issue entirely On Thu, Mar 26, 2015 at 10:05 AM, Jonathan Moules wrote: > 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? > >

Re: [postgis-users] 2.1.6 Released

2015-03-26 Thread Jonathan Moules
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, pc_get(

Re: [postgis-users] 2.1.6 Released

2015-03-26 Thread Rémi Cura
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 th

Re: [postgis-users] Does ST_SimplifyPreserveTopology preserve "contains" property

2015-03-26 Thread Paul Ramsey
No, it preserves internal topology, not relative topology. On Thu, Mar 26, 2015 at 9:59 AM, Igor Stassiy wrote: > 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