[Qgis-user] QGIS and PostGIS, dimensions problems

[Matthias Kuhn]

Hi Jakob,

When adding a new Layer, QGIS checks the column definition in postgis 
and configures it accordingly.

I suspect either of the following:

- You have a project created on an old table definition and the table 
was altered later

- There is a misconfiguration in your column definition (-> ST_PointZ is 
a function, so I suspect you are using a view as layer, which might have 
been created as 2D and writing to a 3D table or similar).

Matthias

On 2/14/20 8:05 AM, Jakob Götesson wrote:
>
> Hello everyone!
>
> I have a point-layer in Postgis v12 which is ST_pointZ according to 
> PostGIS.
>
> When creating a new point in QGIS and then tries to save it, I get an 
> error:
>
> ”Column has Z dimension but geometry does not”
>
> When looking in to the object identifier the derived attributes only 
> contains X and Y. However, the rest of the points that loads from the 
> database has a Z-value set to 0 attached to them. So i get that my 
> created point dosen´t have a Z-value.
>
> Isn't it possible to create new data in 3 dimensional tables from 
> Postgis in QGIS? Even with a deafult value of 0, I don´t even need to 
> specify the Z-value at this moment.
>
> (Found a work around but I prefer not to use this:
> If I save the QGIS-project and open the .qgs-file in text editor and 
> look into the datasource-tag for the the layer I have:
>
> /type=Point/
>
> When changing this to:
>
> /type=PointZ/
>
> saves the project and try to create a new object, it works fine.)
>
> Regards
>
> *Jakob Götesson
> *GIS-ingenjör
> - - - - - - - - - - - - - - - - - - - - - - - - - - -
> *Borås Stad* – Samhällsbyggnadsförvaltningen
> Kungsgatan 55, 501 80 Borås
> 033-35 84 66
> boras.se
> facebook.com/borasstad**
>
> När du kommunicerar med Borås Stad behandlar vi dina personuppgifter. 
> För mer information hur Borås Stad hanterar personuppgifter se 
> boras.se/publänk till annan webbplats <https://www.boras.se/pub>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200214/26737d63/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 262 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200214/26737d63/attachment.png>