Timeline for Creating View with new geometry field in PostGIS
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 2, 2019 at 20:01 | history | edited | PolyGeo♦ | CC BY-SA 4.0 |
deleted 14 characters in body; edited tags; edited title
|
| Dec 15, 2017 at 9:14 | vote | accept | Acicate | ||
| Nov 14, 2013 at 2:15 | answer | added | Cao Minh Tu | timeline score: 2 | |
| Nov 13, 2013 at 17:39 | comment | added | Evil Genius | Yes, the tables show up, but QGIS isn't aware of the Z. At least that's the case for QGIS 2.0.1 with PostGIS 2. Try identifying a 3D geometry...you'll only see X and Y coordinates. At any rate, I've tried creating a view with the example point from my first comment and it shows up just fine in QGIS. I can add the layer and see both it's (2D) geometry and attributes. | |
| Nov 13, 2013 at 15:16 | comment | added | Acicate | I don´t think so about QGIS. I have some tables with 3D geometry and I can see them perfectly. | |
| S Nov 12, 2013 at 15:48 | history | suggested | ylka | CC BY-SA 3.0 |
fixed grammar
|
| Nov 12, 2013 at 15:43 | review | Suggested edits | |||
| S Nov 12, 2013 at 15:48 | |||||
| Nov 12, 2013 at 14:45 | comment | added | Evil Genius | I think your problem is more with QGIS than it is with PostGIS. ST_Force_3DZ only sets the Z to 0 if it doesn't exist. From the looks of this issue, QGIS doesn't support 3D geometry from PostGIS. | |
| Nov 12, 2013 at 14:31 | comment | added | Acicate | The problem is not the content, the problem is the name of the column. The right way is column geom of type geometry(PointZ, 25830), but my result is a column geom of type geometry (it's not exact). So when I try to see this table in QGIS, the table is not detected. | |
| Nov 12, 2013 at 12:30 | comment | added | Evil Genius |
What exactly doesn't work? When I do something like SELECT ST_Zmflag(ST_SetSRID(ST_MakePoint(50,100,5), 25830)) it returns 2 which signifies the geometry is 3dz.
|
|
| Nov 12, 2013 at 12:18 | history | asked | Acicate | CC BY-SA 3.0 |