Feature request #21875

add support for "triangles" PostGIS geometry type

Added by Darafei Praliaskouski 8 months ago. Updated 7 months ago.

Status:Open
Priority:Normal
Assignee:-
Category:Data Provider/PostGIS
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:29690

Description

I have a table of TRIANGLE's in PostGIS. QGIS shows it as Polygon layer, and when I click using Idenify tool on triangles, they show up, but they are not rendered by main map as polygons.

triangles.sqld.bz2 (4.26 MB) Darafei Praliaskouski, 2019-04-18 01:38 PM

2019-04-18 151330.jpg (231 KB) Darafei Praliaskouski, 2019-04-18 02:14 PM

Screenshot_20190418_131631.png (682 KB) Giovanni Manghi, 2019-04-18 02:17 PM

History

#1 Updated by Giovanni Manghi 8 months ago

  • Status changed from Open to Feedback

Can you attach a sump of the table (even with sample data)?

#2 Updated by Darafei Praliaskouski 8 months ago

Please find dump attached. (why 5mb limit?:)

#3 Updated by Giovanni Manghi 8 months ago

the layer loads here, but is not identifiable or selectable or editable, is that what you mean?

#4 Updated by Darafei Praliaskouski 8 months ago

Layer loads for me, it is identifiable but renders nothing. If I click somewhere contours of objects render.

#5 Updated by Giovanni Manghi 8 months ago

Darafei Praliaskouski wrote:

Layer loads for me, it is identifiable but renders nothing. If I click somewhere contours of objects render.

map show here, not identifiable or selectable (is editable, it just needs a primary key).

#6 Updated by Darafei Praliaskouski 8 months ago

Found it. "Simplify on provider's side if possible" triggers this.

```
gis=# select ST_Simplify(geom, 0) from delaunay_triangles limit 10;
ERROR: lwgeom_simplify_in_place: unsupported geometry type: Triangle
```

I will try to fix this on PostGIS side, but that will be PostGIS v3+ since it's essentially a feature. Would be great to see this error on UI somewhere at least.

PostGIS ticket: https://trac.osgeo.org/postgis/ticket/4380

#7 Updated by Giovanni Manghi 8 months ago

  • Tracker changed from Bug report to Feature request
  • Subject changed from Triangle in PostGIS is half-working to add support for "triangles" PostGIS geometry type
  • Status changed from Feedback to Open

#8 Updated by Darafei Praliaskouski 7 months ago

these functions shouldn't fail on triangles in PostGIS starting next release:
https://github.com/postgis/postgis/commit/4335b10ac3152c9a5a8008dc022a8b50adac66c6

Also available in: Atom PDF