[Qgis-user] QGIS and PostGIS, dimensions problems

[Jakob Götesson]

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/pub[länk till 
annan webbplats]

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] raster layer and vector layer ---> create 3D view from it

[Saber Razmjooei]

Hi Larissa,

hmmm, the SRTM is not going to give a proper indication of elevation when
used in conjunction with buildings. The SRTM is very coarse dataset and it
will probably be flat for your extent. Have you considered having seperate
sections for 3d data visualisations, each with its own dataset. One section
could be vectors (there is quite a bit to cover there: points as 3d models,
3d lines and buildings), rasters (to cover terrain and probably mesh) and
another for creating animations and fly-overs.

I am available most of next week. Feel free to drop me an email
off-the-list and happy to show you in a webconferencing session how to use
those features.

Many thanks,
Saber


On Thu, 13 Feb 2020 at 13:30, Larissa Junek  wrote:

> Hello Saber,
> in the meantime I used New York 3D data to check out the 3D view tool.
> Using the hints of your blog I'm having
>
>- a Buildings_3D_Multipatch layer from a
>DA10_3D_Buildings_Multipatch.gdb (vector layer)
>- SRTM data N40W074.hgt (raster layer)
>
> now.
>
> Next steps:
>
>- the srtm data in the 3D view tool: Type = DEM (raster layer) ,
>Elevation = N40W074
>- single symbol setting in the 3D view properties of
>Buildings_3D_Multipatch
>
> Using SRTM data this way doesn't help to depict the vectors in 3D (I
> thought the srtm data have the function of a master). Do I have to convert
> file formats?
> I'm using QGIS 3.10.2 and win10.
>
> Cheers, Larissa
>
>
>  Weitergeleitete Nachricht 
> Betreff: Re: [Qgis-community-team] 3D view of LIDAR data city of boulder
> Datum: Tue, 11 Feb 2020 17:22:32 +0100
> Von: Larissa Junek  
> An: Saber Razmjooei 
> ,
> qgis-community-t...@lists.osgeo.org
>
> Hi Saber,
>
> ok will the clipped Boulder data be suitable for the 3D dataset that we
> want to provide in the qgis sample data?
>
> I wonder if srtm data will have a good resolution. Will you also clip a
> srtm dataset for usage in the qgis sample data?
>
> Then I would of course prefer to use this data so that a user can quickly
> check out the usage of the 3D view functionalities!
>
> Cheers, Larissa (-:
> Am 10.02.2020 um 16:55 schrieb Saber Razmjooei:
>
> Hi Larissa,
>
> I was clipping the Boulder data to something manageable. But if you have
> moved to NY data, that should be fine too.
>
> In terms of the underlying terrain, we have a separate blog post.
>
> https://www.lutraconsulting.co.uk/blog/2018/03/01/working-with-qgis-3d-part-1/
>
> Usually the z-scales in terrain and buildings do not line up nicely,
> therefore I thought it is better to have 2 different sections: one on
> terrain (rasters) and one on buildings (vector).
>
> Let me know if you have any questions.
>
> Kind regards
> Saber
>
> On Mon, 10 Feb 2020 at 15:38, Larissa Junek  wrote:
>
>> Hi Saber,
>>
>> I switched the location and prepared a geopackage with the 3D data of new
>> york.
>>
>> I think your blog should be updated as I still only can depict a flat
>> plane of the data in the 3d view tool.
>>
>> Sorry for bothering but it's my task to write about the 3D settings in
>> QGIS 3.10 ...
>>
>> Cheers, Larissa
>> Am 10.02.2020 um 15:17 schrieb Larissa Junek:
>>
>> Hi Saber,
>>
>> thanks for giving me the hint. Do I need to add a raster layer with
>> height information like geoTiff (SRTM data etc.)
>>
>> in order to define the position of the 3D buildings ? I got this
>> information in a presentation on youtube. Right now, after
>>
>> defining the single symbol of walls and roofs (data city of Boulder),
>> there is only a plane :-(
>>
>> Cheers Larissa
>> Am 08.02.2020 um 13:38 schrieb Saber Razmjooei:
>>
>> Hi Larissa,
>>
>> Apologies. Boulder data indeed contain walls and roofs.
>>
>> To view the data in 3D, you need to go to each layer and open
>> Properties > 3D view and change the style to Single symbol.
>>
>> Also, the dataset is very large. It would be easier if you crop the data
>> to a smaller area.
>>
>> Regards
>> Saber
>>
>>
>> On Sat, 8 Feb 2020 at 12:00, Saber Razmjooei <
>> saber.razmjo...@lutraconsulting.co.uk> wrote:
>>
>>> Hi Larissa,
>>>
>>> Many thanks for looking into documenting this.
>>>
>>> I had a quick look at the data. It is only the footprint. So, you can
>>> only extrude the data (based on height).
>>>
>>> There is a good data source of 3D buildings here:
>>> https://github.com/wonder-sk/3d-spatial-data
>>>
>>> And for building in New York, we wrote a blog post here. The data have
>>> z-valuse and should automatically get picked up by the 3D map view.
>>> https://www.lutraconsulting.co.uk/blog/2017/10/16/buildings-in-qgis3d/
>>>
>>> Feel free to use any of the content from our website in the
>>> documentation.
>>>
>>> Kind regards
>>> Saber
>>>
>>> On Fri, 7 Feb 2020 at 13:59, Larissa Junek  wrote:
>>>
 Hello folks,

 for documentation purposes I'd like to visualize the 3d data of the city
 of boulder in qgis 3.10 .

 https://bouldercolorado.gov/open-data/city-of-boulder-3d-buildings/

 Unfortunately

Re: [Qgis-user] SVG files in QGIS print layout

[Andreas Neumann]

Hi Doug, 


Can you share your SVG file? I'd like to have a look at it. Inkscape
sometimes does peculiar things to SVG text elements (like adding complex
matrices where they aren't really necessary). That might lead to issues
with QGIS, because QGIS doesn't support the full SVG profile, but only
the SVG tiny part of the specification. 


Inkscape also offers several different optimizations when saving to
different SVG versions. One might be better suitable for QGIS than the
other. But I'd need to see your file first to give recommendations. 


Unfortunately, you are limited to the SVG tiny profile when importing
SVG into QGIS. QGIS relies on the QT library for SVG support and QT only
supports SVG Tiny (and from this specification only the static part).
See https://www.w3.org/TR/SVGTiny12/ 


There is nothing easy we can do to improve the situation. The solution
would be to improve the qt library first to also render more than SVG
tiny, more features from the full profile that Inkscape normally
produces. This would require financial investments into the QT library
and also patience, until this ends up in QGIS, because it would then
require a newer qt version. 

Greetings, 

Andreas 


On 2020-02-13 15:05, Newcomb, Doug wrote:

Hi Folks, 
I recently made up a poster using QGIS 3.10.2 and ran across a few issues with SVG files when using add image. 

1) I use Inkscape 0.92.4 on windows to create customized North Arrows.  When adding a large text  N to the SVG file, it will not appear until I convert the text to a path using object to path. 

2) Exporting a graph from R to an svg file  using: 
svg(file="graph_filename.svg", width=7, height=7). 
When using add image to the print layout, none of the text associated with the graph is visible.  Loading the svg file in Inkscape , the text shows up fine, but the convert text to a path method does not work on these files. 

Before I dive into this further, is this known behavior that is being worked on? Do folks have an easy fix? 

Yes, I could use png files, but vector graphics look better 🙂 

Doug 

Doug Newcomb - Cartographer 
USFWS 
551F Pylon Dr 
Raleigh, NC 
919-856-4520 ext. 14 doug_newc...@fws.gov 
- 

_NOTE: This email correspondence and any attachments to and from this sender is subject to the Freedom of Information Act (FOIA) and may be disclosed to third parties._​ 
___

Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] SVG files in QGIS print layout

[Newcomb, Doug]

Hi Folks,
I recently made up a poster using QGIS 3.10.2 and ran across a few issues with 
SVG files when using add image.

1) I use Inkscape 0.92.4 on windows to create customized North Arrows.  When 
adding a large text  N to the SVG file, it will not appear until I convert the 
text to a path using object to path.

2) Exporting a graph from R to an svg file  using:
svg(file="graph_filename.svg", width=7, height=7).
When using add image to the print layout, none of the text associated with the 
graph is visible.  Loading the svg file in Inkscape , the text shows up fine, 
but the convert text to a path method does not work on these files.

Before I dive into this further, is this known behavior that is being worked 
on? Do folks have an easy fix?

Yes, I could use png files, but vector graphics look better 🙂

Doug


Doug Newcomb - Cartographer
USFWS
551F Pylon Dr
Raleigh, NC
919-856-4520 ext. 14 doug_newc...@fws.gov
-

NOTE: This email correspondence and any attachments to and from this sender is 
subject to the Freedom of Information Act (FOIA) and may be disclosed to third 
parties.​

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] raster layer and vector layer ---> create 3D view from it

[Larissa Junek]

Hello Saber,

in the meantime I used New York 3D data to check out the 3D view tool.
Using the hints of your blog I'm having

 * a Buildings_3D_Multipatch layer from a
   DA10_3D_Buildings_Multipatch.gdb (vector layer)
 * SRTM data N40W074.hgt (raster layer)

now.

Next steps:

 * the srtm data in the 3D view tool: Type = DEM (raster layer) ,
   Elevation = N40W074
 * single symbol setting in the 3D view properties of
   Buildings_3D_Multipatch

Using SRTM data this way doesn't help to depict the vectors in 3D (I
thought the srtm data have the function of a master). Do I have to
convert file formats?
I'm using QGIS 3.10.2 and win10.

Cheers, Larissa


 Weitergeleitete Nachricht 
Betreff:Re: [Qgis-community-team] 3D view of LIDAR data city of boulder
Datum:  Tue, 11 Feb 2020 17:22:32 +0100
Von:Larissa Junek 
An: Saber Razmjooei ,
qgis-community-t...@lists.osgeo.org



Hi Saber,

ok will the clipped Boulder data be suitable for the 3D dataset that we
want to provide in the qgis sample data?

I wonder if srtm data will have a good resolution. Will you also clip a
srtm dataset for usage in the qgis sample data?

Then I would of course prefer to use this data so that a user can
quickly check out the usage of the 3D view functionalities!

Cheers, Larissa (-:

Am 10.02.2020 um 16:55 schrieb Saber Razmjooei:

Hi Larissa,

I was clipping the Boulder data to something manageable. But if you
have moved to NY data, that should be fine too.

In terms of the underlying terrain, we have a separate blog post.
https://www.lutraconsulting.co.uk/blog/2018/03/01/working-with-qgis-3d-part-1/

Usually the z-scales in terrain and buildings do not line up nicely,
therefore I thought it is better to have 2 different sections: one on
terrain (rasters) and one on buildings (vector).

Let me know if you have any questions.

Kind regards
Saber

On Mon, 10 Feb 2020 at 15:38, Larissa Junek mailto:l.ju...@gmx.net>> wrote:

Hi Saber,

I switched the location and prepared a geopackage with the 3D data
of new york.

I think your blog should be updated as I still only can depict a
flat plane of the data in the 3d view tool.

Sorry for bothering but it's my task to write about the 3D
settings in QGIS 3.10 ...

Cheers, Larissa

Am 10.02.2020 um 15:17 schrieb Larissa Junek:


Hi Saber,

thanks for giving me the hint. Do I need to add a raster layer
with height information like geoTiff (SRTM data etc.)

in order to define the position of the 3D buildings ? I got this
information in a presentation on youtube. Right now, after

defining the single symbol of walls and roofs (data city of
Boulder), there is only a plane :-(

Cheers Larissa

Am 08.02.2020 um 13:38 schrieb Saber Razmjooei:

Hi Larissa,

Apologies. Boulder data indeed contain walls and roofs.

To view the data in 3D, you need to go to each layer and open
Properties > 3D view and change the style to Single symbol.

Also, the dataset is very large. It would be easier if you crop
the data to a smaller area.

Regards
Saber


On Sat, 8 Feb 2020 at 12:00, Saber Razmjooei
mailto:saber.razmjo...@lutraconsulting.co.uk>> wrote:

Hi Larissa,

Many thanks for looking into documenting this.

I had a quick look at the data. It is only the footprint.
So, you can only extrude the data (based on height).

There is a good data source of 3D buildings here:
https://github.com/wonder-sk/3d-spatial-data

And for building in New York, we wrote a blog post here. The
data have z-valuse and should automatically get picked up by
the 3D map view.
https://www.lutraconsulting.co.uk/blog/2017/10/16/buildings-in-qgis3d/

Feel free to use any of the content from our website in the
documentation.

Kind regards
Saber

On Fri, 7 Feb 2020 at 13:59, Larissa Junek mailto:l.ju...@gmx.net>> wrote:

Hello folks,

for documentation purposes I'd like to visualize the 3d
data of the city
of boulder in qgis 3.10 .

https://bouldercolorado.gov/open-data/city-of-boulder-3d-buildings/

Unfortunately qgis crashes when loading the shapefile
into the 3d view.

Also, where do I have access to the z-coordinate so that
there will be a
3d view. At the moment there is only visible a plane
with the vectors
but no "z-value"  in the 3d view application. Extrusion
doesn't help
solute the problem.

There is a hint that these data have something to do
with GeoJSon, so
maybe I have to find another 3d data suitable for using
in the 3D view
application.

Can somebody help?

Cheers, Larissa

_

Re: [Qgis-user] Uninstall NOOSA

[Patrick Dunford]

You can have multiple versions installed with the OSGEO4W installation, 
so it will be sitting in there along with any other versions installed.


Just delete the shortcut off your start menu if you aren't confident 
about deleting the folder.


On 13/02/20 10:19 pm, Mark Page wrote:

Hi,

I've upgraded to A Coruna, and now I want to unistall Noosa.

I'm Windows 10 64 bit.

Trouble is it's not in C:\Program files\ etc, and therefore doesn't 
show up in add/remove programs. I've downloaded "Advanced uninstaller" 
and it doesn't find it either.


There is a file on my C:\OSGeo4W64 which seems to be where it might be.

Any thoughts anyone?

--
Cheers

Mark

Mark B Page
Chartered Forester
Smiddybank Cottage
Heiton
Kelso
TD5 8LB

01573 450298
07775 817776

m...@pageforestry.co.uk
www.pageforestry.co.uk

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Scalebar issues on QGIS 3.10.2

[David Addy]

I am making maps using OSGB36 which is 27700 CRS. My issue comes when I use
the Print Layout option.
In one case the Print Layout simply did not draw a scalebar, but left a pair
of dotted lines on the layout. So I left it out.
In another case the scalebar was drawn but the scale of kilometres was
apparently ten times what I expected. Where I expected a box showing 10 and
20 km, it gave 100 and 200 km.
I use the  Windows 10 pre-built package and except for this issue QGIS
3.10.2 latest version works very well for me. I also use the latest OS
transformation as recommended by the system, which I had to download. I
wonder if this transform, which is said to be accurate to 1 metre (compared
to the old transform of 2 to 4 metre accuracy) is causing this issue.
Anybody else run into this, or have any suggestions or comments?



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Make selected features dominant in view

[SEGGIE Graeme]

Brilliant, thanks Richard - that works perfectly. As you say would be good if 
was default, but not too onerous and perhaps speeds up rendering to not have it 
doing so for every layer etc.

Graeme.


Hi Graeme,

I do not know an answer, but I checked and it's not that selected items always 
would end up on top...

This sounds very reasonable though... and helpfull :-) If it is not already 
there, it would make a nice Feature Request!

There is in the Layer Properties/Symbology/Layer Rendering an option to 
'Control feature rendering order' ...
Ok, so you can make an  an expression like:

 is_selected( $currentfeature )

which then makes your selected features draw last (on top).
You could at least try that.
I'm wondering if that would/could not be default painting behaviour?

Regards,

Richard Duivenvoorde

On 12/02/2020 17.34, SEGGIE Graeme wrote:
> Is there a way to have selected features dominate in the map view? I
> mean when selected not all selected features of a layer show as yellow
> (default) if there are other features in the same layer above them in
> the drawing order. In Arc – anything selected is always shown as such,
> which is a lot handier for tracking things down spatially, quickly. Am
> wondering if there is a preference that sets this, which I have not
> done.  I know I can create a sub-layer with filtering as an
> alternative to do this, but that seems like more work than it should be.
>
>
>
> Graeme
>
>
>
>
>
>
>
> This message has been scanned for malware. This message and any
> attachments (the "message") are confidential, intended solely for the
> addressees, and may contain legally privileged information. Any
> unauthorised use or dissemination of the message or its contents is
> prohibited. The confidential or legally privileged nature of the
> information contained in the message is not waived, lost or destroyed
> if it is sent other than to the addressee. Use or dissemination of the
> information contained in the message, by a recipient other than the
> addressee, may cause commercial damage to either or both of the sender
> and the addressee. If you are not the addressee of this message,
> please contact the sender immediately and delete this message. All
> email communications to and from SYSTRA Limited are filtered and
> stored for risk management purposes in accordance with SYSTRA
> Limited’s policies and legal obligations. E-mails are susceptible to
> alteration. Neither our company or any of its subsidiaries or
> affiliates shall be liable for the message if altered, changed or
> falsified. SYSTRA Limited is a company registered in England and
> Wales, (number 03383212). Registered
> office: 3rd Floor 5 Old Bailey, London, England, EC4M 7BA. Registered
> VAT number: GB1823826/95
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>

This message has been scanned for malware. This message and any attachments 
(the "message") are confidential, intended solely for the addressees, and may 
contain legally privileged information. Any unauthorised use or dissemination 
of the message or its contents is prohibited. The confidential or legally 
privileged nature of the information contained in the message is not waived, 
lost or destroyed if it is sent other than to the addressee. Use or 
dissemination of the information contained in the message, by a recipient other 
than the addressee, may cause commercial damage to either or both of the sender 
and the addressee. If you are not the addressee of this message, please contact 
the sender immediately and delete this message. All email communications to and 
from SYSTRA Limited are filtered and stored for risk management purposes in 
accordance with SYSTRA Limited’s policies and legal obligations. E-mails are 
susceptible to alteration. Neither our company or any of its subsidiaries or 
affiliates shall be liable for the message if altered, changed or falsified. 
SYSTRA Limited is a company registered in England and Wales, (number 03383212). 
Registered office: 3rd Floor 5 Old Bailey, London, England, EC4M 7BA. 
Registered VAT number: GB1823826/95
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Uninstall NOOSA

[Mark Page]

Hi,

I've upgraded to A Coruna, and now I want to unistall Noosa.

I'm Windows 10 64 bit.

Trouble is it's not in C:\Program files\ etc, and therefore doesn't show 
up in add/remove programs. I've downloaded "Advanced uninstaller" and it 
doesn't find it either.


There is a file on my C:\OSGeo4W64 which seems to be where it might be.

Any thoughts anyone?

--

Cheers

Mark

Mark B Page
Chartered Forester
Smiddybank Cottage
Heiton
Kelso
TD5 8LB

01573 450298
07775 817776

m...@pageforestry.co.uk
www.pageforestry.co.uk

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user