Feature request #21875
add support for "triangles" PostGIS geometry type
| 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.
History
#1
Updated by Giovanni Manghi over 5 years ago
- Status changed from Open to Feedback
Can you attach a sump of the table (even with sample data)?
#2
Updated by Darafei Praliaskouski over 5 years ago
- File triangles.sqld.bz2 added
Please find dump attached. (why 5mb limit?:)
#3
Updated by Giovanni Manghi over 5 years ago
the layer loads here, but is not identifiable or selectable or editable, is that what you mean?
#4
Updated by Darafei Praliaskouski over 5 years ago
- File 2019-04-18 151330.jpg added
Layer loads for me, it is identifiable but renders nothing. If I click somewhere contours of objects render.
#5
Updated by Giovanni Manghi over 5 years ago
- File Screenshot_20190418_131631.png added
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 over 5 years 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 over 5 years 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 over 5 years ago
these functions shouldn't fail on triangles in PostGIS starting next release:
https://github.com/postgis/postgis/commit/4335b10ac3152c9a5a8008dc022a8b50adac66c6