Re: [Qgis-user] Use of "description column" in "value relation widget"

[Karl Magnus Jönsson via QGIS-User]

Hi!
As I know it you get the description when you hover the different options in 
the dropdown. It would sometimes have been nice to have the description visible 
to the user in the dropdown and the value (not visible) stored in the attribute.

Kind regards

Karl-Magnus Jönsson

-Ursprungligt meddelande-
Från: QGIS-User  För Klaus Mithöfer via 
QGIS-User
Skickat: den 16 januari 2024 12:32
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] Use of "description column" in "value relation widget"

Dear all,

I'd like to use the "description column" in "value relation widget". I thought 
I could create an expression fro the drop-down list like 
concat("field1","field2"). But it doesn't work. What ist the "description 
column" good for?

Kind regards
Klaus
___
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

Re: [Qgis-user] [EXTERNAL] Re: Geopackage slow on NAS if not read-only

[Karl Magnus Jönsson via QGIS-User]

Hi!
If just storing and reading is the scope and not editing, maybe another file 
format would be suitable. Like https://flatgeobuf.org/. Not tested by me but 
could be a good alternative.

Karl-Magnus Jönsson


Från: QGIS-User  För Árni Geirsson via 
QGIS-User
Skickat: den 16 mars 2023 15:08
Till: Sadowski Jarosław 
Kopia: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] [EXTERNAL] Re: Geopackage slow on NAS if not read-only

I do appreciate the good advice to use DBMS, I am doing that too and understand 
the advantages. I would never consider using a geopackage if I thought that 
multiple people would want to edit them at the same time. But that is not the 
case and that is not my problem. Sometimes, I just want to keep geodata in a 
file on a network share and run the risk (in my case insignificant) that the 
file will be corrupted by multi user access. This I can do with shapefiles, but 
unlike the shapefiles, I have to set the read-only flag on the geopackages 
stored on the network to get decent rendering speed, without ever wanting to 
edit the files. I think wanting to use file based storage for geodata in a 
networked environment is not unreasonable, even if there is some danger of 
corruption. All file based formats are probably subject to that risk, but I 
repeat, that issue is not what I am talking about, just the rendering speed of 
data in a geopackage that is not set to read-only.
I suspect that there is no solution and that I will just have to live with this 
- as I have done for years. It is just a bit annoying. And I am surprised how 
little it is discussed.

Árni


On Thu, 16 Mar 2023 at 13:46, Sadowski Jarosław via QGIS-User 
mailto:qgis-user@lists.osgeo.org>> wrote:
+1

Don’t use file formats to edit by multiple users. I was occurring some critical 
problems, as for example disappearing objects from database or LONG read 
for first time ☹

Use PostgreSQL or other solutions like:
Mergin Maps: Collect, Store and Analyze your Geo-Data 
Easily<https://merginmaps.com/>
GIS Support » GIS.Box 
(gis--support-pl.translate.goog)<https://gis--support-pl.translate.goog/gis-box/?_x_tr_sl=pl&_x_tr_tl=en&_x_tr_hl=pl&_x_tr_pto=wapp>



_

Jarosław Sadowski
Kierownik Zespołu ds. Ochrony Środowiska | Biuro Strategii i Planowania, 
Projektowania i Inżynierii Podprogramu Kolejowego
Environmental Protection Team Leader | Railway Subprogramme Strategy & 
Planning, Design & Engineering Department
e: jaroslaw.sadow...@cpk.pl<mailto:jaroslaw.sadow...@cpk.pl>
m: +48 532 720 230
From: QGIS-User 
mailto:qgis-user-boun...@lists.osgeo.org>> 
On Behalf Of Bo Victor Thomsen via QGIS-User
Sent: Thursday, March 16, 2023 2:35 PM
To: qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org>
Subject: Re: [Qgis-user] [EXTERNAL] Re: Geopackage slow on NAS if not read-only

UWAGA: Ta wiadomość pochodzi spoza CPK Sp. z o.o. Proszę pomóż zadbać o 
bezpieczeństwo naszej organizacji. Zastanów się, zanim otworzysz link lub 
załącznik.


When any user on your network access the geopackage layer and (maybe 
unnecessarily) puts the layer in edit mode, there will be created 2 extra files 
in the same directory as the gpkg file resides in. And QGIS behaves different 
regarding both read and write operations when these file are present. This is 
probably the explanation of the longer reading times, even if nobody actually 
is editing the layer. When the user stops the editing mode for the layer, the 2 
files disappear.

You can check if this is the explanation:

  1.  Open the gpkg layer in read mode on one computer, check the access speed 
of the same layer on another computer.
  2.  Set the layer in edit mode on the first computer, check the access speed 
to the layer on the second computer
  3.  Revert the edit mode on the first computer, check the access speed to the 
layer on the second computer.
I am guessing, that situations 1 and 3 are fast, while situation 2 is slow.

First of all: Never, ever try to implement some kind of multi-user editing on a 
file based format, where the file resides on a networked drive. It will never, 
ever work reliably. At some point 2 users will try to edit the same layer at 
the same time and it will go kaboom (I can read from your mails that you are 
aware about this). This goes for - probably - every file based format on a 
network drive.

Secondly: What about making the gpkg file read-only at the network share level 
for most of the users. And only granting write access to the gpkg file for 
certain users that are instructed in not setting the layer in edit mode unless 
it's strictly necessary ?

The best solution: Install Postgres/PostGIS on your NAS

Med venlig hilsen / Best regards



Bo Victor Thomsen
Den 16-03-2023 kl. 13:49 skrev Árni Geirsson via QGIS-User:
Thank you for the various responses.
Let me be clear that what I am griping about is not the locking aspect that 
would allow mul

Re: [Qgis-user] Strange digitising behavior

[Karl Magnus Jönsson via Qgis-user]

Hi!
It's  a new thing that could be a bit confusing. When you digitize you can 
choose between segment, stream, curve, shape in the advanced digitizing 
toolbar. And there is a toolbar for choosing shapes as well.

[cid:image001.png@01D8A1BE.516FCFD0]

Karl-Magnus Jönsson


Från: Qgis-user  För Grant Boxer via 
Qgis-user
Skickat: den 27 juli 2022 13:18
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] Strange digitising behavior

I have somehow altered a setting whereby anytime I try to digitise points for a 
polygon layer, QGIS draws a rectangle, like a create shapes type action. This 
doesn't happen if I use a new profile, so it is a setting somewhere in my set 
up but I have not been able to find it. Has anyone else had this issue and can 
tell me how to fix it? I am running 3.26 on Windows10.

Grant Boxer
Perth Western Australia


___
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] Identify tool and closest vertices (z-values)

[Karl Magnus Jönsson via Qgis-user]

I tested against:
PostgreSQL 11.5 on x86_64-alpine-linux-musl, compiled by gcc (Alpine 8.3.0) 
8.3.0, 64-bit
Postgis:
2.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1

Karl-Magnus Jönsson


Från: Andreas Neumann 
Skickat: den 24 maj 2022 12:22
Till: Karl Magnus Jönsson 
Kopia: QGIS User List 
Ämne: Re: Sv: [Qgis-user] Identify tool and closest vertices (z-values)


Hi Karl-Magnus,

Thank you for your confirmation.

It must be something weird about 3D detection from QGIS for Postgis layers. I 
tested with other 3D layers and they work fine, but the layer that fails to 
work with Z-Values is from a much older Postgis-DB.

Maybe it would work fine if we transfer the data to a more modern Postgis-DB ...

QGIS display the Metadata as Polygon (PolygonZ) though ...

Strange ...

Andreas

On 2022-05-24 11:21, Karl Magnus Jönsson wrote:

Hi!

It seems to work for me in 3.22.5 with Postgis PolygonZ. Can't remember that 
I've done any custom settings for that.

[cid:image001.png@01D86F76.4EA1F2D0]



Karl-Magnus Jönsson





Från: Qgis-user 
mailto:qgis-user-boun...@lists.osgeo.org>> 
För Andreas Neumann via Qgis-user
Skickat: den 24 maj 2022 10:53
Till: QGIS User List 
mailto:Qgis-user@lists.osgeo.org>>
Ämne: [Qgis-user] Identify tool and closest vertices (z-values)



Hi,

We have a a Postgis PolygonZ data set an want to query the third dimension of 
the closest vertex. According to my users, this used to work fine in older QGIS 
versions, but now we can only see the x/y values and not z-values anymore.

I just tested it on QGIS 3.22 (LTR) and can conform that the z-values are not 
displayed in the derived data of the identify tool.

Is there any hidden setting that helps us to display the z-values again - or a 
connection parameter that forces QGIS to treat it correctly as a 3d data set?

Thank you for any hints,

Andreas


___
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] Identify tool and closest vertices (z-values)

[Karl Magnus Jönsson via Qgis-user]

Hi!
It seems to work for me in 3.22.5 with Postgis PolygonZ. Can’t remember that 
I’ve done any custom settings for that.
[cid:image001.png@01D86F60.2F0463B0]

Karl-Magnus Jönsson


Från: Qgis-user  För Andreas Neumann via 
Qgis-user
Skickat: den 24 maj 2022 10:53
Till: QGIS User List 
Ämne: [Qgis-user] Identify tool and closest vertices (z-values)


Hi,

We have a a Postgis PolygonZ data set an want to query the third dimension of 
the closest vertex. According to my users, this used to work fine in older QGIS 
versions, but now we can only see the x/y values and not z-values anymore.

I just tested it on QGIS 3.22 (LTR) and can conform that the z-values are not 
displayed in the derived data of the identify tool.

Is there any hidden setting that helps us to display the z-values again - or a 
connection parameter that forces QGIS to treat it correctly as a 3d data set?

Thank you for any hints,

Andreas
___
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] (Un)force hide form in relation widget

[Karl Magnus Jönsson]

Hi all!
Just discovered a peculiar thing with relations and forms. If it is a bug it is 
strange no one have reported it before. Or it is just me not knowing how to use 
it properly. Anyway.

I have two tables from PostgreSQL with foreign keys and a 1:N relation set up 
in QGIS. In the child table I have NOT NULL constraint on a field (other than 
the foreign key) in the database.
I set up automatic transaction groups and it works well adding child features 
and add values to the not null field.
When I check the "Force hide form on add feature" option for the child 
relation, in the Layer properties, Attributes form, Drag and drop designer, 
Relations options, I get an error from the database since I have no default 
value for the NOT NULL constraint field.
OK. That's maybe make sense. I can remove the constraint or remove automatic 
transaction groups and it works. A default would also work but I can't set a 
correct value. Depends on other things. But I'd rather show the standalone form 
for the new child feature again.
But I can't undo this option and make it work. Still doesn't open a standalone 
form. Seems that the option becomes global in some way. It works in a fresh 
install or profile. But not a new project.

Does someone knows where this option can be unset? Unsetting it in the UI 
doesn't work. QGIS 3.22.3 on Windows.
But the same since 3.16 at least.

Best regards

Karl-Magnus Jönsson


___
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] Slooooow spatial joins

[Karl Magnus Jönsson]

Hi!
How about just execute some SQL in an algorithm or model since you have the 
data in Postgis? And do the spatial join directly in the database. Like (not 
tested):
UPDATE polygonlayer p
SET p.field = pt.field
FROM pointlayer pt
WHERE st_within(pt.geom,p.geom);

Karl-Magnus Jönsson

Från: Qgis-user  För Ryan Peel
Skickat: den 18 maj 2021 12:24
Till: Nyall Dawson 
Kopia: qgis-user 
Ämne: Re: [Qgis-user] Slow spatial joins

I can appreciate that but it forces to create another layer/file I think.  I 
really don't want to have to re-import my entire table back into postgis just 
to get this one column.

On Mon, May 17, 2021, 10:29 PM Nyall Dawson 
mailto:nyall.daw...@gmail.com>> wrote:
On Tue, 18 May 2021 at 11:59, Ryan Peel 
mailto:ryanp...@gmail.com>> wrote:
>
> I have tried using MMQGIS plugin, refFunctions geomwith function and the 
> aggregate function.  I am using 3.18 QGIS
>
> Despite having spatial indexes on both tables, when I try to use any of these 
> operations to assign the value of a field in the polygon layer to one in the 
> point layer, it goes very slow.  Like, ridiculously slow and of no value.  
> And, I only have 600 records in the points layer and just a few thousand 
> records in the polygon layer.
>
> What can I do to speed this up?

The absolute fastest way to join is to use the Processing tool: Join
Attributes by Location -- no plugins necessary :D

Nyall
___
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] How to select a polygon feature underneath another in the same ArcGIS REST feature layer.

[Karl Magnus Jönsson]

Hi!
How does the new feature (3.18), right click with the select tool to get an 
menu, work with this data?
https://www.qgis.org/en/site/forusers/visualchangelog318/index.html#feature-select-features-context-menu

Karl-Magnus Jönsson

Från: Qgis-user  För Michael Dufty
Skickat: den 14 maj 2021 09:01
Till: qgis-user 
Ämne: [Qgis-user] How to select a polygon feature underneath another in the 
same ArcGIS REST feature layer.

Does anyone know the best way to select a feature entirely underneath another 
in an ArcGIS REST feature layer.
The standard select tool seems to only select one feature, is there a setting 
to let is select all?
Freehand select actually seemed to work well to get both features, which was 
enough for my purpose.
Radius select initiated an indexing of the whole layer which freezes QGIS for 
about 15 minutes (huge layer).

Related question is there any way to cancel these indexing operations?  Turning 
on snap with such a layer active causes the same issue.

Michael Dufty
Senior Environmental Engineer

[cid:image002.jpg@01D74AF7.CE0A0660]

MBS ENVIRONMENTAL
4 Cook Street, West Perth  WA 6005

t:+61 8 9226-3166
e:   mdu...@mbsenvironmental.com.au<mailto:mdu...@mbsenvironmental.com.au>
w:   www.mbsenvironmental.com.auhttp://www.mbsenvironmental.com.au/>

Disclaimer:
The information contained in this message is intended for those to whom it is 
addressed. It may contain confidential or privileged information and if you are 
not the intended recipient, you must not copy, distribute or take any action in 
reliance on it. If you received this message in error please destroy it and 
reply to the sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 
8 9226 3166 immediately. All care has been taken to ensure that this message 
and any attachments are virus free; we do not accept responsibility for any 
virus infections caused by receipt of this message

___
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] Loading filtered database table as temp layer

[Karl Magnus Jönsson]

Hi!
Wouldn't it be possible to use the "Execute SQL" algorithm under "Vector 
general" instead of the "PostgreSQL SQL execute and load" in the Model 
Designer? It outputs a (temporary) layer if you choose that. I'm not sure how 
to use it correctly though. 

Karl-Magnus Jönsson


-Ursprungligt meddelande-
Från: Qgis-user  För Michael Gieding
Skickat: den 4 maj 2021 11:18
Till: QGIS-User Mailinglist 
Ämne: Re: [Qgis-user] Loading filtered database table as temp layer

Hello Richard,

thank you for the addition. But I fear, that this is not suitable for my target 
group.
Difficult enough for them to get the basics in QGIS. So it would be nice to 
offer a simple tool for their work.
Maybe a good chance for me to dive into plugin programming. Seems to be a 
reachable goal.


Kind regards,
Michael Gieding



Von: Richard McDonnell 
Gesendet: Dienstag, 4. Mai 2021 10:58
An: Michael Gieding; QGIS-User Mailinglist
Cc: thaye...@yahoo.com
Betreff: RE: Loading filtered database table as temp layer

Hi Michael,

To add to Thayer's message.

There is currently no way to do exactly what you are looking for, but, I would 
suggest the following as an alternative, which is simple enough to follow.



There are three ways to load a filtered layer into QGIS

Firstly, You can load a Layer using SQL Filter using the either the Data Source 
Manager or DB Manager.

1.   Data Source Manager will allow you to use the Set Filter option on 
your selected Table

2.   DB Manager will do the same when you highlight the Layer you want to 
load and click on the SQL Window [cid:image002.png@01D740CC.14351C50]

3.   Load the Layer in in its entirety, then use the Filter option by right 
clicking on the layer and selecting Filter.



Whichever of the above you use, the Filtered Layers can be temporally saved out 
as whatever format you would like while being worked on. This can be achieved 
by right clicking on the layer, selecting Export => Save Feature As



I Hope that helps in some way.



Regards,



Richard







--
Richard McDonnell MSc GIS, FME Certified Professional FRM Data Management

--
Oifig na nOibreacha Poiblí
Office of Public Works

Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36 Jonathan Swift 
Street, Trim, Co Meath, C15 NX36 -- M +353 87 688 5964 T +353 46 942 2409 
https://gov.ie/opw ___
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

Re: [Qgis-user] Shortcut letter for pan up/down/left/right

[Karl Magnus Jönsson]

Hi!
I often press space for panning while digitizing. Is that an option?

Karl-Magnus


-Ursprungligt meddelande-
Från: Qgis-user  För Richard Duivenvoorde
Skickat: den 12 april 2021 08:41
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Shortcut letter for pan up/down/left/right

On 4/11/21 9:24 PM, Lene Fischer wrote:
> Hi
> 
> While digitizing  I want to use keyboard arrow up/down. But the are on the 
> right side of my keyboard.
> 
> How can I assign WADS keys as up/down ect.

Hi Lene,

I think(!) these are hardcoded:

https://github.com/qgis/QGIS/blob/master/src/gui/qgsmapcanvas.cpp#L1723-L1745

so you cannot change them using 'Settings / Keyboard Shortcuts' (?).

Most actions using keyboard shortcuts are rea 'QActions' so attached to the 
real activating of an QAction. Your key-clicks are more 'helper' keys, calling 
mapCanvas.setCenter ...?

Maybe a dev can answer the question: IS it possible to put these kind of 
PressEvents in the list of Keyboard Shortcuts?

Else maybe something is possible on Operating System level, but that is 
probably too much...

Regards,

Richard Duivenvoorde



___
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

Re: [Qgis-user] First steps with 3D Scan Data?

[Karl Magnus Jönsson]

Hi!
Lots of suggestions here. But if I understand you correct it is lidar data and 
all about photogrammetry is not in question. Why not pdal? Open source, 
powerful and what QGIS is using in 3.18.

https://pdal.io/

Karl-Magnus


-Ursprungligt meddelande-
Från: Qgis-user  För Bernd Vogelgesang
Skickat: den 26 mars 2021 09:35
Till: Benoit de Cabissole ; qgis-user 

Ämne: Re: [Qgis-user] First steps with 3D Scan Data?

Hi Benoit,

ok, thanks. las then.

But when I read about the lastools plugin, the description says that I need to 
install the lastools software, and the website there tells me that the license 
is about 1500€ which is a little too much for some learning efforts.

Any other options?

Cheers,

Bernd


On 26.03.21 09:28, Benoit de Cabissole wrote:
> Hi Bernd,
>
> OK, that more info!
>
> The files are likely to be in Timble RealWorks format.
> So you will have to get your contractor to provide you with .las 
> files, otherwise your stuck buying RealWorks!
> Or, perhaps, the viewer is able to export in .las??
>
> When you get las files, you can use lastools plugin for QGIS to 
> process them.
>
> Cheers,
> Benoit
>
>
> On 26/03/2021 10:01, Bernd Vogelgesang wrote:
>> Hi Benoit,
>>
>> as I was not present when the scans were made, I can only assume that 
>> this was a laser scanner on a tripod.
>>
>> With the sent data, there is a Trimble Scan Explorer Viewer software 
>> where I can make a "virtual walk" through the scene, so there have to 
>> be photos but also laser scan data as I can see from different view modes.
>>
>> As I said, this is the very first time I get in touch with this 
>> stuff, and Google was of no big help so far.
>>
>> Besides of tons of other files, the bigger ones with around 50 to 80 
>> MB are .rwcx and .tzf files.
>> I hoped that someone would know what these file explicitly hold, and 
>> what I have to do to get them e.g. into QGIS or other open source 
>> software.
>>
>> Cheers,
>>
>> Bernd
>>
>> On 26.03.21 08:40, info wrote:
>>> Hi Bernd,
>>>
>>> Well, could you give more info? E.g. what kind of scan:
>>> laser/lidar/photo/other? This will influence your workflow.
>>>
>>> +/-Open source laser/lidar could be based on lastools [1]
>>> Open source photogrammetry could be based on AliceVision meshroom 
>>> [2,3],  MeshLab [4] and blender [5]
>>>
>>> In photogrammetry: Agisoft metashape [6] and pix4D [7] as good 
>>> commercial products.
>>>
>>> BTW: 32 scans, if photos, is quite a very low number of photos for 
>>> reconstructing a 3D scene!
>>>
>>> Hope this helps.
>>> Cheers,
>>> Benoit de Cabissole
>>>
>>> [1] http://lastools.org/
>>> [2] https://alicevision.org/#photogrammetry
>>> [3] https://github.com/alicevision/meshroom
>>> [4] https://www.meshlab.net/
>>> [5] https://www.blender.org/
>>> [6] https://www.agisoft.com/
>>> [7] https://www.pix4d.com/
>>>
>>>
>>>
>>> On 25/03/2021 23:07, Bernd Vogelgesang wrote:
 Hi folks,

 in a project on a former dumpside now to be transformed into a sand 
 lizard habitat, I saw the chance to get my hands dirty for the 
 first time on 3D scan data (terrestrial). I received 10GB of stuff, 
 and now I'm completely lost.

 The data consists of .rwcx files, .tzf files and lots of other stuff.

 Is there any chance that I can process any of this data with an 
 open source stack?
 Or what should be done, to make them digestible?

 Second step: There seem to be 32 different scans of the area form 
 all angles. In case I succeed to somehow load the data, how do I 
 combine them ?

 For the first steps, I actually "only" would like to generate a 
 decent DEM from the data to be able to place some features on a map 
 for the guys in charge to do the habitat stuff.

 Any kind of hints or links to reads about this topic would be 
 appreciated

 Cheers,

 Bernd


 ___
 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 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] Access database via cmd

[Karl Magnus Jönsson]

Hi!
Good news! Thanks. I wonder if you tried to connect to a PostGIS database from 
command line. As a parameter. In graphical mode it works and looks like:

'postgres://dbname=\'geodb\' host=servername port=5432 user=\'user\' 
password=\'pwd\' sslmode=disable key=\'UNIK\' estimatedmetadata=true srid=3008 
type=PolygonZ checkPrimaryKeyUnicity=\'1\' table=\"pri\".\"byggnad_\" (geom)'

If it's possible in cmd I don't know how to format it properly.

Karl-Magnus Jönsson


-Ursprungligt meddelande-
Från: Qgis-user  För Christoph Jung
Skickat: den 12 mars 2021 06:50
Till: Nyall Dawson 
Kopia: qgis-user 
Ämne: Re: [Qgis-user] Save log to file via cmd

That’s great, Nyall. Thank you for your effort :)

Regards,
Christoph 

> Am 11.03.2021 um 23:46 schrieb Nyall Dawson :
> 
> On Tue, 9 Mar 2021 at 00:41, Christoph Jung  wrote:
>> 
>> Hello everyone,
>> 
>> I created a model and added the function “Save log to file” at the end of my 
>> model. If I start the model directly in the QGIS application, it works fine 
>> (the log file will be created and contains information).
>> 
>> Now I want to call this model from the command line to schedule this task. I 
>> created a batch file, setting up the osgeo4w environment and calling the 
>> model via qgis_processing-qgis-ltr in this script. The log file will be 
>> created, but there is no information in it. There is no error message or 
>> something else in the command prompt too. Does anybody has an idea how I 
>> could get the information in my log files when I call my model via command 
>> line?
> 
> Thanks, fixed here: https://github.com/qgis/QGIS/pull/42208/files
> 
> Nyall
___
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

Re: [Qgis-user] Save log to file via cmd

[Karl Magnus Jönsson]

No, unfortunately not. I guess it is a bug that has to be reported.

Karl-Magnus Jönsson


-Ursprungligt meddelande-
Från: Christoph Jung  
Skickat: den 9 mars 2021 09:33
Till: Karl Magnus Jönsson 
Kopia: qgis-user 
Ämne: Re: [Qgis-user] Save log to file via cmd

Thank you for you answer, Karl. Did you found another solution to create such 
log files? I tried to write the output of the command to a file via 
“qgis_processing-qgis-ltr [...] > path_to_logfile.log”. But only the input 
section will be written to this file, not the result section. 

> Am 08.03.2021 um 17:03 schrieb Karl Magnus Jönsson 
> :
> 
___
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] Save log to file via cmd

[Karl Magnus Jönsson]

Hi, I've experienced the same thing. Haven't found/heard of a solution yet. 
Would be interested in that.

Regards
Karl-Magnus Jönsson


-Ursprungligt meddelande-
Från: Qgis-user  För Christoph Jung
Skickat: den 8 mars 2021 15:41
Till: qgis-user 
Ämne: [Qgis-user] Save log to file via cmd

Hello everyone,

I created a model and added the function “Save log to file” at the end of my 
model. If I start the model directly in the QGIS application, it works fine 
(the log file will be created and contains information). 

Now I want to call this model from the command line to schedule this task. I 
created a batch file, setting up the osgeo4w environment and calling the model 
via qgis_processing-qgis-ltr in this script. The log file will be created, but 
there is no information in it. There is no error message or something else in 
the command prompt too. Does anybody has an idea how I could get the 
information in my log files when I call my model via command line?

Regards,
Christoph
___
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

Re: [Qgis-user] QGIS server WMS cascade getfeatureinfo

[Karl Magnus Jönsson]

Hi!
I don't have the same setup but I do some cascading WMS. I can usually get some 
hints from the QGIS Server log if there are problems. Maybe also look at the 
requests that the client sends to the server.

Karl-Magnus Jönsson 


-Ursprungligt meddelande-
Från: Qgis-user  För frippe12573
Skickat: den 18 februari 2021 11:03
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] QGIS server WMS cascade getfeatureinfo

Hi all,

I know that WMS cascade in QGIS server should be possible.
However, I have problems in visualization. 

The WMS is originally served by geoserver and the preview is well rendered as 
well as getfeatureinfo works fine.
The same WMS loaded in a QGIS project works fine, and the getfeatureinfo 
returns the right information.

So I set the layer as WMTS in the QGIS project properties and I set the WCS 
capabilities for the layer.
Then I set the layer in the Lizmap plugin, enabling the popup and get layer 
from third parties.
The result on the client is that the layer is listed in the table of contents 
the legend is not visible and the layer is not visible and queriable.

I posted the same question in the
Lizmap mailing list without any answer so far.
Do you have any clue?
QGIS server version > 3.0

Thank you in advance for any answer.

Regards,

Eugenio



--
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
___
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] QGIS processing command line

[Karl Magnus Jönsson]

Hi all!
I'm trying the new, relatively, features of the processing toolbox, using the 
graphical modeler and to run the model from command line. Most works fine but 
there are some things that I can't get working. Either I don't know how to 
configure it properly, or it is a bug or feature request. The documentation is 
quite short on this subject and I haven't found any more good examples. My test 
model reads two vector feature sources, buffer one of the, clip them against 
each other, write a shapefile, export to PostgreSQL as well, run some SQL and 
saves a log to a file. This works fine in graphical mode. In command line I 
have a few problems:

· Works fine with shape files but how to read directly from a database 
table? In graphical mode I can browse for a table and use it like 
'postgres://dbname=\'geodata\' host=sbkgeodata port=5432 user=\'user\' 
password=\'pwd\' sslmode=disable key=\'UNIK\' estimatedmetadata=true srid=3008 
type=PolygonZ checkPrimaryKeyUnicity=\'1\' table=\"pri\".\"byggnad_\" (geom)' 
but I don't know how to write it as a parameter in command line.

· The log file is created but it is empty from command line.

· Is there an option to use an existing table in the database and 
truncate it instead of dropping and recreate? Thought there would be. This is 
not connected to command line.

Is there someone else that have been testing features like this or are there 
any good examples to view? Maybe write bug report/feature requests/enhancement 
proposals to describe and discuss if isn't  just me using it the wrong way. I'm 
on Windows 10 with QGIS 3.16.3 Standalone installer.

Karl-Magnus Jönsson


___
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] Http access to json return

[Karl Magnus Jönsson]

Hi!
I’m also interested this functionality. Need to use OAuht2 authentication but 
that seems not to be available. Guess there is just an solution 
programmatically then.

Karl-Magnus

Från: Qgis-user  För Ben Hur Pintor
Skickat: den 24 juni 2020 10:23
Till: Steve Sgalowski 
Kopia: QGIS User 
Ämne: Re: [Qgis-user] Http access to json return

Hi!

If it's a vector layer (e.g. geojson response) that you'll load via API, you 
can try using the Data Source Manager -> Vector Tab and use Protocol: HTTP(S), 
cloud, etc.. You can select the proper Type and input the URI similar to the 
image below. This will load the file/response as a QGIS layer.

[https://user-images.githubusercontent.com/22940966/84317347-3248c100-ab9f-11ea-8a33-98bff1d91e19.png]

I haven't tried it yet for CSV / non-spatial data though.

All the best,
Ben Hur

On Wed, Jun 24, 2020 at 2:23 PM Andreas Neumann 
mailto:a.neum...@carto.net>> wrote:

Hi Steve,

Not that I know of, but:

- you could have an onload Python script that runs when the form opens

- you could have a web-widget with an onload javascript that does some network 
requests

Such rather "developer centric" questions are more likely to get responses on 
the qgis-developer mailing lists, btw.

Greetings,

Andreas

On 2020-06-24 07:22, Steve Sgalowski wrote:
Is there  widget  on qgis that does http out with api and returns data in json 
or csv format?.

Stephen.


___
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


--
---
Ben Hur S. Pintor
bnhr.xyz
h...@bnhr.xyz

[https://docs.google.com/uc?export=download=1RWxakH_JIlVojbdRj8QYwVsdJVnAYVHT=0B5hrESDcDUYodlYvUjBmbnp6RlB0YmRVemlJSzJ1TldvVHY0PQ]
open spatial & data solutions
___
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] Styling polygon borders: preventing double rendering between polygons

[Karl Magnus Jönsson]

Hi!
I had a similar problem. I’ve made a view ( in PostGIS) to transform the 
boundaries to lines and remove the duplicate lines. Should be doable in virtual 
layers as well. Quite complicated SQL since I have several different types of 
lines depending on the attributes.

Karl-Magnus Jönsson

Från: Qgis-user  För Christoph Jung
Skickat: den 11 juni 2020 13:11
Till: Jorge Gustavo Rocha 
Kopia: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Styling polygon borders: preventing double rendering 
between polygons

Hi Jorge,

If it is just a visual thing, than you could transform your polygons to lines 
and delete the duplicate geometries.

Sincerely,
Christoph


Am 11.06.2020 um 12:45 schrieb Jorge Gustavo Rocha 
mailto:j...@geomaster.pt>>:

Hi QGisers,
I'm trying to style a polygon layer (districts) using a marker line (using the 
'+' sign). It works well for lines.
When I use it in polygons, the outer line is ok, but the lines between polygons 
are rendered twice.
To make this question more clear, I've attached the following print screen: 
https://nextcloud.geomaster.pt/index.php/s/e3ztdJ894RCf9j6
The line near the sea is rendered just once. The line going to east between the 
polygons is rendered twice. We can see double '+'  on that line.
How do I render all the lines exactly the same way, without this "double" 
rendering between polygons?
Regards,
Jorge Gustavo
--
[Logo]<https://www.geomaster.pt/>

Geomaster
Jorge Gustavo Rocha | Software Engineer

e: j...@geomaster.pt<mailto:j...@geomaster.pt> | m: +351 910 333 888
g: 41.54094,-8.40490 | v: 510 906 109
a: Rua António Cândido Pinto, 67, 4715-400 Braga



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org<mailto: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

Re: [Qgis-user] Save projects to DB without creator's permissions

[Karl Magnus Jönsson]

Hi!
Alessandro, you where quicker! ☺

If I understand correct, the actual credentials isn’t stored to the project. 
Just the auth config ID. If the user doesn’t have this in his local 
authentication database, or has it with other credentials(read) the project 
will not open with admin credentials.

Karl-Magnus Jönsson

Från: Qgis-user  För Cliff Patterson
Skickat: den 1 juni 2020 15:36
Till: Alessandro Pasotti 
Kopia: qgis-user 
Ämne: Re: [Qgis-user] Save projects to DB without creator's permissions

That's exactly the problem with the auth system. If you connect to a DB using 
the auth system and store a map in the DB (or anywhere for that matter), the 
map contains your credentials/permissions for EVERY layer that you added. So if 
you create a map while logged in as DB owner (i.e. full perms for every layer), 
any user who opens it will have full permissions on every layer in the map. The 
only workaround for this is to remember to use basic auth and uncheck "store" 
beside password whenever creating a shared project.

Any other less vulnerable workarounds would be very helpful, though I doubt any 
exist.

Cliff

On Fri, May 29, 2020 at 3:03 PM Alessandro Pasotti 
mailto:apaso...@gmail.com>> wrote:
Maybe all that you need is in the QHIS auth system is 
https://docs.qgis.org/3.10/en/docs/user_manual/auth_system/auth_workflows.html#changing-authentication-config-id

The master password can be stored in the operating system wallet so that the 
user will not need to type his password.

Regards


On Fri, May 29, 2020, 19:39 Cliff Patterson 
mailto:cpatter...@psdrcs.com>> wrote:
PS: I realize I can create maps with basic auth and not store the PW, which 
prompts the user to enter their creds. But is there a better way now to achieve 
the same result?

Cliff

On Fri, May 29, 2020 at 1:29 PM Cliff Patterson 
mailto:cpatter...@psdrcs.com>> wrote:
What is the best approach to save QGIS projects to PostgreSQL without saving 
the project-creator's credentials/permissions? If the DB admin creates a 
project and saves it to the DB, anyone opening that project will attain the 
admin's permissions on layers in that map.

To recreate:

1) Create a map containing PostGIS layers and save project to DB. All layers 
should be editable by the admin. Admin is logged into DB with auth config, not 
basic auth.
2) Create a new read-only user and new profile in QGIS and log in to DB.
3) Open the project and try to edit layers. Read-only user will be able to see 
and edit all layers just like the DB Admin.

Is there a way to save projects to DB WITHOUT saving any user creds/permissions?

Cliff

--

Cliff Patterson Ph.D.

PSD | Senior GIS Consultant
P: 519-690-2565 ext. 2616
www.psdrcs.com<http://www.psdrcs.com>
London | 148 Fullarton St. 9th Floor

[http://psdrcs.com/assets/email_signature.png]


--

Cliff Patterson Ph.D.

PSD | Senior GIS Consultant
P: 519-690-2565 ext. 2616
www.psdrcs.com<http://www.psdrcs.com>
London | 148 Fullarton St. 9th Floor

[http://psdrcs.com/assets/email_signature.png]
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org<mailto:Qgis-user@lists.osgeo.org>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


--

Cliff Patterson Ph.D.

PSD | Senior GIS Consultant
P: 519-690-2565 ext. 2616
www.psdrcs.com<http://www.psdrcs.com>
London | 148 Fullarton St. 9th Floor

[http://psdrcs.com/assets/email_signature.png]
___
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] QGIS 3.10: Dimensioning with on-board equipment

[Karl Magnus Jönsson]

Hi!
Wouldn’t that be round($length,2) for getting two decimal places for meters?

Karl-Magnus Jönsson

Från: Qgis-user  För Richard McDonnell
Skickat: den 5 maj 2020 10:51
Till: hdiens...@aol.com; qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment

Hi,
In my original response, I mentioned using round(100*( $length) ) || ' cm' 
which would give you the dimensions in centimetres only.
If you want meters only then remove the 100*, which would look like this 
round($length) || ' m'

Now if you want both dimensions shown, for example <-- 10.52m (1052cm) -->, 
then this can be achieved by using the following

round( $length) || ' m' || ' ( ' || round(100*( $length) ) || ' cm)'

Hope that helps!!
Regards,

Richard

——
Richard McDonnell MSc GIS, FME Certified Professional
FRM Data Management

——
Oifig na nOibreacha Poiblí
Office of Public Works

Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36
Jonathan Swift Street, Trim, Co Meath, C15 NX36
——
M +353 87 688 5964 T +353 1 647 6543
https://www.opw.ie

——
To send me files larger than 30MB, please use the link below 
https://filetransfer.opw.ie/filedrop/richard.mcdonn...@opw.ie

Email Disclaimer: https://www.opw.ie/en/disclaimer/

From: Qgis-user 
mailto:qgis-user-boun...@lists.osgeo.org>> 
On Behalf Of hdiens...@aol.com<mailto:hdiens...@aol.com>
Sent: 01 May 2020 17:15
To: qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org>
Subject: Re: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment

Hi Richard,

As I had written to you on April 20, I have successfully implemented your 
proposal.

The only thing missing is an answer to my question:
How would I have to change the command to get a result in m.(,)cm (e.g. 10.52 m 
or 10,52 m) format?

Regards,

Hartmut

___
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] Embedded projects and QGIS server

[Karl Magnus Jönsson]

Hi all!
I'm trying to embed some thematic projects into a master project containing all 
themes for publishing a service in QGIS Server. Works nice in desktop but the 
WMS service just contains empty group layers for the embedded projects. Paths 
seems to be relative. It would have been nice to be able to publish layers or 
projects in different master projects and not have to duplicate the cartography 
and settings in several projects. Does anyone know if it is intended to work 
with embedded projects in QGIS Server? Or have another smart solution for this? 
Thanks in advance.

Karl-Magnus Jönsson

___
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] Clicking the georeferencer doesn't result in any reaction

[Karl Magnus Jönsson]

Hi!
Do you sometimes have multiple screens? I’ve experienced that when moving the 
georeference window to the second screen it doesn’t show up when using just 
one. Try to connect the second screen again and move it back to the main 
screen. Otherwise it is a setting somewhere. Maybe in the Windows register or 
user profile. At least when I had the problem.

Karl-Magnus


Från: Qgis-user  För  
Skickat: den 26 februari 2020 07:54
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] Clicking the georeferencer doesn't result in any reaction

Hello,

I'm using QGIS 3.6.3, with window 10 pro.
When clicking on the georeferencer button, nothing happen.
I tried to uninstall and reinstall version 3.12, but still it doesn't work..

Thanks,
Hila

___
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] Applying multiple styles to the same layer

[Karl Magnus Jönsson]

Hi,
Another option is to add named styles to the layer and switch between them. And 
if you want, associate them with map themes for quick switching.

https://docs.qgis.org/3.4/en/docs/user_manual/introduction/general_tools.html#manage-custom-style

Karl Magnus Jönsson | Gis-Utvecklare
Geografisk information
Miljö- och samhällsbyggnadsförvaltningen
Kristianstads kommun
Besöksadress: Västra Storgatan 12
Postadress: 291 80 KRISTIANSTAD
Telefon: 044-135416 | Mobil: 0733-135416
E-post: 
karl-magnus.jons...@kristianstad.se<mailto:karl-magnus.jons...@kristianstad.se>
www.kristianstad.se<http://www.kristianstad.se>


Från: Qgis-user  För Alexandre Neto
Skickat: den 7 januari 2020 08:55
Till: Patrick Dunford 
Kopia: qgis-user ML 
Ämne: Re: [Qgis-user] Applying multiple styles to the same layer

Hi Patrick,

I don't think that duplicating a layer is such a big problem. I only advice you 
to avoid editing the two layers at the same time.

Another option is to use rule-based symbology, which allows you to set a rule 
(filter) for when the feature are drawn. If you create non exclusive filter, a 
feature can be drawn several times.

https://docs.qgis.org/3.4/en/docs/user_manual/working_with_vector/vector_properties.html#rule-based-renderer

Hope it helps,

Alexandre Neto
QGIS Support
www.QCooperative.net<http://www.QCooperative.net>

A terça, 7/01/2020, 04:29, Patrick Dunford 
mailto:enzedrailm...@gmail.com>> escreveu:
Good day to all.

I have a Qgis project in which I would like to be able to have the same
layer appear twice in the layer list so that I can apply different
styling to it in each instance.

At the moment I am not aware of how I might do this apart from adding
the same layer to my project twice.

The layers are local Geopackage files (.gpkg) and there is known the
issue that Sqlite documentation does recommend against multiple
connections to a dataset, especially over a network, as this is somewhat
outside the design expectations of Sqlite.

Is there any other way I can have two different styles applied to a layer?

TIA

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org<mailto: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

Re: [Qgis-user] QGIS 3 - Joins

[Karl Magnus Jönsson]

Hi!
It could work editing views if you set up some triggers or rules for editing 
the view. 

Karl-Magnus 

-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För 
burghardt.scho...@stadt.wolfsburg.de
Skickat: den 18 oktober 2019 12:09
Till: b.j.kob...@utwente.nl; qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] QGIS 3 - Joins

Hi Barend,

you're right, I know this way and use it a lot as well. Unfortunately I have to 
edit features in this layer and that doesn't work with views.

Burghardt

> -Ursprüngliche Nachricht-
> Von: b.j.kob...@utwente.nl [mailto:b.j.kob...@utwente.nl]
> Gesendet: Freitag, 18. Oktober 2019 11:53
> An: Scholle, Burghardt (15-3 GIS); qgis-user@lists.osgeo.org
> Betreff: Re: [Qgis-user] QGIS 3 - Joins
> 
> Another way would be to leave the joining up to Postgres, i.e. create a VIEW
> with the Join and load that view as a layer in QGIS...
> --
> Barend Köbben
> 
> On 18/10/2019, 10:16, "Qgis-user on behalf of
> burghardt.scho...@stadt.wolfsburg.de"  on behalf of burghardt.scho...@stadt.wolfsburg.de> wrote:
> 
> Dear list,
> 
> I have a postgres layer that is connected to other postgres lookup tables 
> via
> joins. QGIS does not take these joins into account when copying a layer (to
> another project) or when creating style or layer files. This is really 
> annoying if
> you have to rebuild the joins by hand over and over again. Am I doing
> something wrong? In the dialog window "Edit Vector Join" I see no further
> ways. I only activated the option "Cache join layer in virtual memory".
> 
> Any hint is appreciated, thanks.
> I'm using QGIS LTR 3.4.12
> 
> Regards
> Burghardt
> 
> ***
> 
> Stadt Wolfsburg
> Geschäftsbereich IT - 15-3 GIS
> Rathaus E, Zi. E 313, Porschestraße 47A, D-38440 Wolfsburg
> Tel +49 5361 28-2531
> Fax +49 5361 28-1765
> mailto:burghardt.scho...@stadt.wolfsburg.de
> 
> 
> 
> ___
> 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 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] Forms, realtions and foreign keys

[Karl Magnus Jönsson]

Thanks. Works perfect. I  missed the "initially deferred" in the FK.

Karl-Magnus

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Matthias Kuhn
Skickat: den 4 juni 2019 11:27
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Forms, realtions and foreign keys


Hello,

If you enable "evaluate default values server side" and "automatic transaction 
groups" and set the foreign key check in the database to initially deferred 
you'll get pretty much what you want :)

Hope that helps

Matthias
On 6/4/19 11:14 AM, Karl Magnus Jönsson wrote:
Hi list!
I have a project with tree tabels stored in PostGIS. One is holding the 
geometry the other two is holding data related to the first table as child and 
grandchild. I have set up foreign keys between the tables in the database to be 
sure that there will be no orphan records. In QGIS there are relations and 
(sub)forms. When I digitize a new geometry I get the new id from the database 
(before it's saved, OK) in the form but I can't add any children. I get a 
database error that says that there are no parent with that ID (and that's 
true). I have to  press OK to create the feature in QGIS, change tool to 
identify, find the feature and klick on it to open the form again. Then I can 
add children. But I haven't saved so there is still no parent. But it works 
then. It's the same with the grandchild table but then the grandparent form is 
still open so it's not such a big problem. Anyone got a better way to skip this 
closing and reopening of the form in the workflow?

Karl-Magnus Jönsson | Gis-Utvecklare
Geografisk information
Miljö- och samhällsbyggnadsförvaltningen
Kristianstads kommun
Besöksadress: Västra Storgatan 12
Postadress: 291 80 KRISTIANSTAD
Telefon: 044-135416 | Mobil: 0733-135416
E-post: 
karl-magnus.jons...@kristianstad.se<mailto:karl-magnus.jons...@kristianstad.se>
www.kristianstad.se<http://www.kristianstad.se/>

Läs mer om hur vi hanterar dina personuppgifter på 
www.kristianstad.se/personuppgifter<http://www.kristianstad.se/personuppgifter>




___

Qgis-user mailing list

Qgis-user@lists.osgeo.org<mailto: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

Re: [Qgis-user] exporting layout to pdf changes output of locked maps

[Karl Magnus Jönsson]

Hi!
Have you tried to create different map themes and associate them with the 
appropriate layout map frame?

Karl-Magnus Jönsson 

-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Reginald
Skickat: den 4 juni 2019 09:50
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] exporting layout to pdf changes output of locked maps

Hello users and devs,

I've been trying to create a A1 maplayout containing two A2 maps.
One of the maps I put on the layout shows an aereal photo, the other shows a
topographical map on another scale.
When my layout was ready I locked all the items and clicked on the export to
pdf icon.
The result is that both maps on the layout get refreshed and the pdf shows
the same topographical map in each A2 map window.
Is it not posible to use two different maps in one layout?
I tried different strategies but no luck.
I'm using the latest version of QGIS on windows 7 (OSGeo4W).

Regards,



--
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
___
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] Print Composer Filter

[Karl Magnus Jönsson]

Hi,
Good it worked. Posting it to the list as well.

/Karl-Magnus Jönsson

29 maj 2019 kl. 00:05 skrev Xan Vieiro 
mailto:gallaec...@gmail.com>>:


Hi Karl,

your recipe works fine. Many thanks for the hint!

It will be great if there were a feature filter in the map element at print 
composer, so map themes could be reduced.


Kind regards,


Xan V.

El mar., 28 may. 2019 a las 11:46, Karl Magnus Jönsson 
(mailto:karl-magnus.jons...@kristianstad.se>>)
 escribió:
Ok. One option is to create a rule based style with a filter for the layer. 
Then add the style as a named style: In the layers symbology tab -> Style 
button -> Add… and name it e.g. print style. Then make sure all layers are 
visible and looks like you want in the layout. Add a map theme e.g print theme 
and associate the map in the layout with this map theme. Then you can change 
the style in main window as you wish, alter to default style for the layer and 
remove the rule based styling, make more named styles and map themes for 
different purposes.

Regards
Karl-Magnus Jönsson

Från: Xan Vieiro [mailto:gallaec...@gmail.com<mailto:gallaec...@gmail.com>]
Skickat: den 28 maj 2019 11:15
Till: Karl Magnus Jönsson
Ämne: Re: [Qgis-user] Print Composer Filter

Hi Karl,
Hi!
How do you mean? You do the filtering in the layer properties in the QGIS main 
window.
No, I don't. I just want to keep the whole layer at main window and doing 
filtering directly at print composer.

For atlas there are some more variables or functions available when doing this.

Karl-Magnus Jönsson

Regards,

Xan V.
___
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] Print Composer Filter

[Karl Magnus Jönsson]

Ok. One option is to create a rule based style with a filter for the layer. 
Then add the style as a named style: In the layers symbology tab -> Style 
button -> Add… and name it e.g. print style. Then make sure all layers are 
visible and looks like you want in the layout. Add a map theme e.g print theme 
and associate the map in the layout with this map theme. Then you can change 
the style in main window as you wish, alter to default style for the layer and 
remove the rule based styling, make more named styles and map themes for 
different purposes.

Regards
Karl-Magnus Jönsson

Från: Xan Vieiro [mailto:gallaec...@gmail.com]
Skickat: den 28 maj 2019 11:15
Till: Karl Magnus Jönsson
Ämne: Re: [Qgis-user] Print Composer Filter

Hi Karl,
Hi!
How do you mean? You do the filtering in the layer properties in the QGIS main 
window.
No, I don't. I just want to keep the whole layer at main window and doing 
filtering directly at print composer.

For atlas there are some more variables or functions available when doing this.

Karl-Magnus Jönsson

Regards,

Xan V.
___
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] Print Composer Filter

[Karl Magnus Jönsson]

Hi!
How do you mean? You do the filtering in the layer properties in the QGIS main 
window. For atlas there are some more variables or functions available when 
doing this.

Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Xan Vieiro
Skickat: den 27 maj 2019 22:03
Till: QGIS User List
Ämne: [Qgis-user] Print Composer Filter


Hi,



is it possible to filter a layer from print composer? I know an attribute layer 
can be filtered from composer and even it is possible to do some kind of 
filtering using Atlas, but I don't find a way to filter any feature from print 
composer. Any ideas?



Thanks in advance.
___
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] Layer panel docking problem

[Karl Magnus Jönsson]

Hi!
The Layer Panel should be dockable. Could be a little bit tricky. Try several 
times.

Karl-Magnus

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Susan Iremonger
Skickat: den 19 maj 2019 16:32
Till: qgis-user
Ämne: [Qgis-user] Layer panel docking problem

Hi All,
Please help me with this: I am using QGIS 3.4. Somehow I un-docked my Layer 
Panel and now it just floats over the display, which now takes up all the space 
on my screen. So the Layer Panel obscures the left side of the display of the 
map/data. I have tried moving the panel all the way to the left to see if it 
will dock again for me, without joy.  I have also tried the same thing moving 
it to the right. I have even uninstalled and installed the program again, and 
it has the same problem.
Before this happened I think I clicked a little icon next to the "x" at the 
right hand upper corner of the Layer Panel . This has disappeared now but it 
might have had somehting to do with the undocking of the panel. Any help much 
appreciated.
Susan.

--
Carra Lodge
Pound road
Carrabaun
Westport
Co. Mayo F28 VK58
Ireland
___
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] las files

[Karl Magnus Jönsson]

Hi!
There is a plugin called "Fusion for processing" that might work for you. 
Marked as experimental.

http://forsys.cfr.washington.edu/FUSION/fusion_overview.html

Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Tony Shepherd 
(FarmMaps NZ)
Skickat: den 20 maj 2019 09:11
Till: Qgis-user@lists.osgeo.org
Ämne: [Qgis-user] las files

Hi All

I'm new to QGIS after using MapInfo for more years than I dare to admit and 
finding QGIS great.  I'm making full use of the 3D features as I work mainly in 
the forestry industry and as they say, a picture says a thousand words, 
particularly when showing topography.  My question is, I am trying to find a 
way of converting some LiDar data that I have (las files) to something that 
QGis can use when creating 3D views.  Currently I'm using tif DEM files, so can 
anyone point me in the right direction to creating a dem from las files?  I 
can't see any plugins so wonder how others are achieving this?


Cheers
Tony

Tony Shepherd  |  GeoSpatial
Ph 027 435 6193  |  E t...@farmmaps.nz
FarmMaps NZ, 3 Kerwood Place, Gore 9740

[FM_logo1_small (Custom)]


[cid:image002.png@01D50EFE.5D8113C0]<http://tonyshepherd8.wixsite.com/home>[cid:image003.png@01D50EFE.5D8113C0]<https://www.wunderground.com/personal-weather-station/dashboard?ID=ISTLGORE2>

___
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] QGIS3 Server on Windows Server and IIS

[Karl Magnus Jönsson]

Hi!
I think the problem is under point 3. No one will do this for free just for 
fun. But I think you’ve got a point. One reason for QGIS success is the easy 
installation process (on Windows). And I think QGIS Server have a great 
potential to be more used if it was easier to deploy.

So let’s put this in another way. What would it take to make and maintain a 
server package that would work on Windows (and other platforms)? Maybe with 
Docker or some handy technology. Is it doable? I think of an installation 
wizard that would set up an environment with reasonable defaults like:

· Do you want a spatial database? (some config)

· Do you want QGIS Server? (some config)

· Do you want a caching mechanism? (some config)

· Do you want some of these web clients? (some config)

· Done! Let’s play ☺

Could there be an interest, proposal or estimation of that?

Regards
Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Mats Elfström
Skickat: den 9 maj 2019 09:16
Till: qgis-user
Ämne: [Qgis-user] QGIS3 Server on Windows Server and IIS

Hi All!
I have once again made a futile attempt to establish a QGIS Server on a Windows 
Server. This time with a twist, I want to use IIS instead of Apache as web 
server. These two posts seem to indicate that this is possible.
https://domasin.github.io/valgrande/qgisserveriis.html
https://github.com/mapserver/mapserver/wiki/Installing-Mapserver-under-IIS-7.n-with-FastCGI
I also second this Stackexchange question which so far is unresponded to. 
https://gis.stackexchange.com/q/315932
These are my assumptions:

• I believe that QGIS 3 Server can run on a Windows Server machine 
(2012 is my current option)

• I believe that IIS can be the web server for QGIS server.

• I believe that a stable process for this installation can be proven 
and documented.
However, available descriptions do not work. In many cases, they describe 
specific paths and files which may differ from case to case, and thus create 
errors. It would be better if someone who really knows could describe what 
needs to be done in general terms, rather than “copy these files from here to 
there”.
I will once again extend an offer to provide a solution to this situation.

1.   I will, at my own cost, provide full access to a vanilla Windows 2012 
Server to perform and fully document a complete QGIS3 LTR desktop and server 
installation and configuration, using IIS as web server. Configuring IIS will 
be part of this.

2.   The offer is open to any individual who can indicate relevant 
experience, and for a reasonable amount of time. The documentation will of 
course be tested and released as open source and hopefully also be part of the 
QGIS3 documentation.

3.   My contribution will be the cost for the machine and time for testing. 
The applicant will provide his/her time and knowledge.
Applicants please respond to this thread, as I want the effort to be as open as 
possible.
Regards, Mats.E
__
Mats Elfström, Väpplingvägen 21, SE-227 38 LUND, Sweden
tel: +46 46 145959 / mob: +46 70 595 39 35
alt e-mail: mats.elfst...@giskraft.com<mailto:mats.elfst...@telia.com>
___
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] HTML in layout

[Karl Magnus Jönsson]

Hi list!
I'm working on setting up an automated workflow for getting layouts from QGIS 
and possibly QGIS server. So far I'm surprised over the endless possibilities. 
I have one suspected bug or I misunderstand how to use it. I use a HTML frame 
in the layout and populates the source with an URL with expression. It works 
but when I go back to edit the source, the expression isn't there and it's 
deactivated. If I reenter the expression and activate it, it doesn't affect the 
result. I still uses the first entered expression. I had a look in the project 
file and found that the first entered data defined property (the expression 
used) is stored in a tag called  and the second (not used) in 
a tag . I suspect that the first one is a child to the latter one. 
The problem is that edits ends up in the parent object that doesn't get used 
and I can't edit the child. Has anyone used this and got the same result? Am I 
using it wrong or is it a bug? Can't find one reported.

PS. Looks like a bug. You must create a new HTML frame when something else than 
a HTML item properties is visible in item properties to get it working. If one 
already is visible the expression isn't used (but remains editable).

QGIS 3.6.2

/Karl-Magnus Jönsson

___
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] How calculate sequential values based on spatial pattern

[Karl Magnus Jönsson]

Hi!
One way could be to calculate the sequence and coordinates in Excel or 
something similar. If the points are regularly spaced of course. Then save to 
csv, import in QGIS and save to whatever.

Cheers!

Karl-Magnus Jönsson 


-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Fernando M. Roxo 
da Motta
Skickat: den 2 maj 2019 02:16
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] How calculate sequential values based on spatial pattern

On Wed, 1 May 2019 16:38:41 -0500, Apoyo Carbono
 wrote:


> Hi!
> I need your help. I need to Create a numbers sequentially in a "Points
> shapefile"  with a spacial pattern.
> For example, the point number 1 start northwestern and the next
> numbers points will be order from west to east. For the next row (to
> South) going from west to east too.
> And so on, the values points increase to the south. Therefore the last
> point will be in the southeast.
> For now I'm doing manual but it is around 1,000 points!

  This looks like a lot to a 3D seismic survey.  樂樂樂

  I had a script for Qgis 2.x that worked well enough to be useful to
me.  The points were generated using a grid support.  In your case I
would have a set of EW lines spaced regularly from north to south, and
numbered that way.

  During the points generation I had two (among others) attributes
associated to each point.   The first one was a point number within the
line and the other the line number.

  The points were generated so that all points with the same point
number were parallel to another set of line (usually perpendicular to
the first one).

  I don't know if this is like you are looking for, the point here (pun
unintended) were to associate the numbering attribut while generating
the points.

  Hope this helps.


> 
> I hope that you understand my situation. Can you help me? I could
> send you the shapefile with an example better explained
> 


  Roxo

P.S.- It is possible to still have tose set of scripts luking around
somewhere, they were never ported to 3.X.  They were too horrible to
begin with.  
-- 
 Non luctari, ludare ---+ WYSIWYG
Fernando M. Roxo da Motta   | Editor?
Except where explicitly stated I speak on my own behalf.|  VI !!
PU5RXO  | I see text,
 Quis custodiet ipsos custodes?-+ I get text!
 
___
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

Re: [Qgis-user] Opening a project from QGIS 2.14 in §.4

[Karl Magnus Jönsson]

Hi!
Try to open and save the project in 2.18 before 3.4. I think there are problems 
to use too old versions of project files in 3.x versions

Karl-Magnus Jönsson 

-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Maria Shinoto
Skickat: den 31 oktober 2018 07:23
Till: qgis-user
Ämne: [Qgis-user] Opening a project from QGIS 2.14 in §.4

Hi, 

I am working with a project that I started in QGIS 2.14, and I want to test 
QGIS 3.4 with a copy from this project. 

When I open the copy as is, I get a message that layers are defect, but when I 
mark these layers and click "Apply", nothing happens, and when I click "OK", I 
am asked that it is OK to go on with the layers being dropped from the project. 
I seems that there is no other option. 

Then I am left only with the grpups and subgroups, no layers. 

What am I doing wrong? 

Best, 
Maria

___
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

Re: [Qgis-user] Geopagkage and "geom" in DBmanager

[Karl Magnus Jönsson]

Hi!
A question related to this. I have set up a PostGIS structure with tables, 
rules, views, triggers and constraints. To this there is a QGIS project with 
styling, forms, relations and so on. If I want to make a file based version of 
this for testing, working copies, versions, distribution etc. where do I put 
the database logic? Could it fit in a file based database or virtual layers? 
Which strategy is the best? Any ideas or experiences?

Regards
Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Bo Victor Thomsen
Skickat: den 13 september 2018 22:40
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Geopagkage and "geom" in DBmanager

Ok, after some googling, I have a glimmer of understanding of the (technical 
and personal) issues. Enough said about that...

So technically, GPKG support in QGIS is a hybrid of a "simple" GPKG 
implementation bundled/merged with the spatialite sqlite-extension incl. 
conversion functions, so you can convert the GPKG binary object to and fro a 
spatialite ditto -  when you have to use som spatialite-specific functionality 
like spatial SQL, projection support and so on ?
(If there is a web page somewhere that explains this in detail, i'll 
respecfully redraw my questions and do some RTFM)

Regards
Bo Victor Thomsen

Den tor. 13. sep. 2018 kl. 16.00 skrev Luigi Pirelli 
mailto:lui...@gmail.com>>:
you should look into the history of the gpkg format definition vs spatialite 
format adoption. Nothing related with QGIS, or gdal or etc etc
Luigi Pirelli

**
* LinkedIn: https://www.linkedin.com/in/luigipirelli
* Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
* GitHub: https://github.com/luipir
* Mastering QGIS 2nd Edition:
* 
https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
* Hire me: http://goo.gl/BYRQKg
**


On Thu, 13 Sep 2018 at 14:30, Bo Victor Thomsen 
mailto:bo.victor.thom...@gmail.com>> wrote:
Ok.. From the Spatialite 4.2.0 wiki:

· CastAutomagic(): will indifferently accept both GPKG and SpatiaLite 
BLOB Geometries, then returning anyway a SpatiaLite's own BLOB Geometry.

I can confirm, that using the "CastAutomagic(geom)" function instead of the 
simple field "geom"  will get the st_area and other ogc functions in the QGIS 
Databasemanager Dataprovider for GeoPackage to work.

That means that the geopackage binary format for geometry is incompatible with 
the underlying spatialite spatial system and functions.

This is not the most helpful and thoughtful user oriented solution I've 
encountered ... Or should I have RTFM somewhere in the QGIS.org site ?

However it does work. Thanks for the tip




Den tor. 13. sep. 2018 kl. 13.20 skrev Jean-Baptiste Desbas 
mailto:jb.des...@gmail.com>>:
Hi,

I have to use st_area(CastAutomagic(geom)) instead of st_area(geom), otherwise 
null column is retourned.

Le jeu. 13 sept. 2018 à 11:45, Bo Victor Thomsen 
mailto:bo.victor.thom...@gmail.com>> a écrit :
Hi Lene -

I've made a few observations regarding the use of GeoPackage in DBManager...

I have a GeoPackage based table called "renhold" containing polygons. Primary 
key column is an integer called "fid" and the geometry column is called "geom" 
- It's pretty close to your setup

If I use the DBManager with the GeoPackage dataprovider and execute the 
following statement: select fid, st_area (geom) from renhold , it returns a 
table with 2 columns as expected. However , column nr. 2 contains only nulls. 
However, the statement does not result in an error. The function "st_area" 
simply doesn't return a value besides null.

An now the mystery!! :

If I use the DBManager with the Virtual Layers -> Project layers dataprovider 
and execute the following statement: select fid, st_area (geometry) from 
renhold , it returns a table with 2 columns as expected. And column nr. 2 do 
contain the expected area values. Go figure...

NB! The "renhold" layer is visible in the map and named "renhold"
NBB! In the Virtual Layers dataprovider you have to use the standard name 
"geometry" to represent the geometry column - not the real column name ("geom" 
in this case)

Actually I have a reasonable explanation: The 2 different dataproviders uses 
different internal functions to calculate the area. However the function used 
by the GeoPackage Dataprovider doesn't work !


Regards
Bo Victor Thomsen
LIFA Denamrk

Den tor. 13. sep. 2018 kl. 09.27 skrev Alexandre Neto 
mailto:senhor.n...@gmail.com>>:
Hi Lee,

Can you try removing the quotation marks around geom?

Best wishes,

Alex Neto
A qui, 13/09/2018, 02:04, Lene Fischer mailto:l...@ign.ku.d

[Qgis-user] drill down default values

[Karl Magnus Jönsson]

Hi!
I'm trying out the new great "drill-down forms support" in QGIS 3.2. Is there a 
way to achieve the same behavior for default values? In other words: default 
values depends on what you choose in another form field. I think that make 
sense.

Karl-Magnus Jönsson

___
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] hide vector under raster?

[Karl Magnus Jönsson]

Hi!
How about using the no symbols renderer in the style tab in Layer properties? 
Wouldn't that do?

Regards

Karl-Magnus Jönsson

-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Tobias Wendorff
Skickat: den 29 maj 2018 13:08
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] hide vector under raster?

Hi there,

is it possible to hide a vector layer under a raster layer?

The "click through" identify function allows to query data from the
vector, but on each zoom the vector layer gets rendered completely
again. Sure, it makes use of an spatial index, but since there are
many vector elements, it takes a while.

I tried to hide the vector layer using visibility at fixed scale,
but then it's not possible to query it...

Best regards,
Tobias

___
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

Re: [Qgis-user] STORY PLUGIN

[Karl Magnus Jönsson]

Hi all!
There is a Swedish article about it. I guess it's pretty much the same info as 
in the video. The author says it an experiment. But if you are interested you 
are welcome to contact him to discuss improvements.

https://geosupportsystem.wordpress.com/2016/08/05/qgis-story/

Regards

Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Lukas Winiwarter
Skickat: den 13 april 2018 10:19
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] STORY PLUGIN


Hello Tabaré,

apparently you can get it from here:

https://github.com/klakar/scheherazade

Regards, Lukas

On 12.04.2018 20:58, Borys Jurgiel wrote:

Dnia czwartek, 12 kwietnia 2018 20:10:01 CEST Tabare Martinez pisze:

> I saw this video and I thought I was going to be able to find it:

> https://www.youtube.com/watch?v=9MGupLsU9Eg

>

> I can see in the video that the plugin is "experimental", I use the option

> that enables the experimental plugins, but still can't find it.



AFAIK it was never published - there is only a concept in the video. I'd just 
contact the authors and ask if it's available somewhere.



Regards,

Borys








___

Qgis-user mailing list

Qgis-user@lists.osgeo.org<mailto: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

Re: [Qgis-user] Building models in QGIS

[Karl Magnus Jönsson]

Hi!
I'm playing around with the possibilities of 3D-building in the 
qgis2threejs-plug-in. You can use collada models, exportable from Sketchup, on 
point features in the plug-in. So I've made a point on the desired building, 
attached the model and a proper scaling. I've had some luck with it but think 
it will be hard to to for more than a few buildings at a time. Would be nice to 
hear if you make progress in either way.

/Karl-Magnus

2 nov. 2017 kl. 19:37 skrev Saber Razmjooei 
>:

HI Tyler,

Did you try to enable 3d styling for your vectors (available from Style panel)?
No other dependcy is needed. The documentation for 3 is underway but you can 
refer to the links from Andreas' email.

Regards
Saber




On 2 Nov 2017 4:53 pm, "Tyler Veinot" 
> wrote:
Andreas;
I installed the QGIS 2.99 and added some data, the 3D map seems to work well 
with grid/raster dems but it doesn't display XYZ/XYZM geometries based on the Z 
coordinate. I only did a basic install using the downloadable installer; is 
there other dependencies I should install or is it only for viewing rasters and 
DEM's in 3D?
Tyler

On Thu, Nov 2, 2017 at 9:56 AM, Tyler Veinot 
> wrote:
Andreas;
Thanks for the reply; I knew there was a QGIS 3 in the works but I didn't think 
there was a 'working/usable' dev out, thanks for that. I am certainly going to 
install and play around with it.
Tyler

On Thu, Nov 2, 2017 at 9:17 AM, Andreas Neumann 
> wrote:

Hi Tyler,

3D visualization will be a core feature in QGIS 3.

If you want to play with 3D visualization, I recommend that you try/test QGIS 
3, even if it is still in bug fixing mode and not officially released.

You can either use the OSGeo4W installer and install the dev version or use the 
weeklies (the newest one published at 
http://qgis.org/downloads/weekly/?C=M;O=D).

See also http://www.lutraconsulting.co.uk/blog/2017/10/16/buildings-in-qgis3d/ 
and https://twitter.com/lutraconsulting

Martin Dobias from Lutra is the main developer of the new 3D viz functionality 
in QGIS 3.

Greetings,
Andreas

On 2017-11-02 13:02, Tyler Veinot wrote:

Hello;
Is anyone out there doing anything with building models in QGIS? I have some 
sketchup buildings in DXF format I have been playing with in AutoCAD and QGIS. 
Trying to find a way to bring them into QGIS for viewing in the qgs2threejs 
plugin, but when I do I get a crash dump.
Tried a simple cube as well.
I can bring in Z aware dxf files and view them so I am wondering how big of a 
step is it to go from there to simple building models? Is anyone working in 
this direction that has some insights or thoughts to share?
Thanks;
Tyler

___
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 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

Re: [Qgis-user] Updating a field set with default global variable on edit

[Karl Magnus Jönsson]

An option in the layer properties to save without username and password? Or a 
possibility to change database connection for a layer? To one connection with 
another user or a connection with no user stored. Could be useful. Though it is 
efficient to use an text editor to change it always feels a bit unsecure not 
using the GUI.

Karl-Magnus Jönsson 

-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Fernando M. Roxo 
da Motta
Skickat: den 23 augusti 2017 02:28
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Updating a field set with default global variable on edit

On Tue, 22 Aug 2017 15:45:17 +0200, Casper Bertelsen <casperb...@gmail.com> 
wrote:


> Hi Ross,
> 
> If you make your project without saving username and password, the 
> project will prompt for a user and password when opened. Then each 
> member can login using their assigned login and thus making it 
> possible to use current_user in postgres.
> 
> To remove saved username and password from your current project file 
> (make a copy, beforehand), you can open it in a text editor and seach 
> for  untill you find
> 

  It seems to me that this can be useful for a lot of groups.   Could
this kind of save option be an interesting request for improvement?

  Slds.


> dbname='xx' host=yy port=5432 four lines above 
> and remove the username and password-part only .
> 
> 
> Mvh. / Best regards
> Casper Bertelsen
> 
> On 22/08/2017 15:36, McDonaldR wrote:
> >
> > Thanks Karl-Magnus
> >
> > We use triggers in the database already and they work perfectly but 
> > if we want to record the specific user creating and editing features 
> > then we’d have to create separate projects for each user.
> > At the moment the team of about 10 users all use a set of centrally 
> > stored project files – one for each different task.
> >
> > I found this post on Stackexchange
> > (https://gis.stackexchange.com/questions/217011/how-to-automatically
> > -update-wfs-edits-with-a-user-id) where global variables are used to 
> > populate fields when features are added.  However, as Matthias notes 
> > in the comments this doesn’t work on feature  “update”.  If this 
> > were possible then it would meet all our needs.  Maybe something 
> > that could be funded?
> >
> > Ross
> >
> > *From:*Karl Magnus Jönsson
> > [mailto:karl-magnus.jons...@kristianstad.se] *Sent:* 22 August 2017
> > 12:34 *To:* McDonaldR; qgis-user@lists.osgeo.org
> > *Subject:* SV: [Qgis-user] Updating a field set with default global 
> > variable on edit
> >
> > Hi!
> >
> > I’ve made the same things with triggers in the database. To avoid 
> > getting same username I’ve chosen not to save the username and 
> > password in the project. But then the user have to enter it every 
> > time the projects opens. If you can find a solution to your 
> > suggested approach it would be nice.
> >
> > *Karl-Magnus *
> >
> > *Från:*Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] *För 
> > *McDonaldR
> > *Skickat:* den 22 augusti 2017 13:12
> > *Till:* qgis-user@lists.osgeo.org <mailto:qgis-user@lists.osgeo.org>
> > *Ämne:* [Qgis-user] Updating a field set with default global 
> > variable on edit
> >
> > Hi List,
> >
> > Anyone know how to update a field that has a global variable set as 
> > the default value when records are edited (geometry and/or 
> > attributes)?
> >
> >
> > We have a QGIS project with a PostGIS layer loaded and configured 
> > with look-ups and relations so the users can update all the relevant 
> > fields. There are also "*created_by*" and "*updated_by*"
> > fields. These are updated by a trigger in the database with the 
> > "*current_user*" database variable. This works fine if you are the 
> > current user that added the layer to the project - the trigger works 
> > perfectly.
> >
> > If you give the project to someone else and they create and edit 
> > features in the layer the fields are still updated with your name as 
> > you are the person who added the layer to the project. Not what we 
> > want.
> >
> > QGIS has global variables and there are some new ones -
> > *user_account_name* and *user_full_name* that can be set as default 
> > values for the fields. When a new feature is created the field is 
> > populated with the correct name. Which is what we want.
> >
> > However, when we update an existing record we'd like the 
> > "*updated_by*" field to be updated with the current 
> > "*user_account_

Re: [Qgis-user] Updating a field set with default global variable on edit

[Karl Magnus Jönsson]

No, it's no big deal. That's why we are using it. And it's only one time per 
qgis session.

Karl-Magnus

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Casper Bertelsen
Skickat: den 22 augusti 2017 14:34
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Updating a field set with default global variable on edit

Hi too,

Well logging into the QGIS-project should really be a big deal right ? - You 
only have to log in once no matter how many layers are loaded from the 
database. I have a table inside my QGIS project where I can create new users 
inside the database and administer reading/writing/admin-privileges.

Mvh. / Best regards
Casper Bertelsen

On 22/08/2017 13:34, Karl Magnus Jönsson wrote:
Hi!
I've made the same things with triggers in the database. To avoid getting same 
username I've chosen not to save the username and password in the project. But 
then the user have to enter it every time the projects opens. If you can find a 
solution to your suggested approach it would be nice.

Karl-Magnus

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För McDonaldR
Skickat: den 22 augusti 2017 13:12
Till: qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org>
Ämne: [Qgis-user] Updating a field set with default global variable on edit

Hi List,

Anyone know how to update a field that has a global variable set as the default 
value when records are edited (geometry and/or attributes)?

We have a QGIS project with a PostGIS layer loaded and configured with look-ups 
and relations so the users can update all the relevant fields. There are also 
"created_by" and "updated_by" fields. These are updated by a trigger in the 
database with the "current_user" database variable. This works fine if you are 
the current user that added the layer to the project - the trigger works 
perfectly.

If you give the project to someone else and they create and edit features in 
the layer the fields are still updated with your name as you are the person who 
added the layer to the project. Not what we want.

QGIS has global variables and there are some new ones - user_account_name and 
user_full_name that can be set as default values for the fields. When a new 
feature is created the field is populated with the correct name. Which is what 
we want.

However, when we update an existing record we'd like the "updated_by" field to 
be updated with the current "user_account_name". Like a trigger in the database 
would do on update. Then we would have a better idea of the history of the 
feature.

Ross

Ross McDonald | GIS Data Coordinator | Angus Council, People, IT | Angus House, 
Orchardbank Business Park, Sylvie Way, Forfar DD8 1AT | t: 01307 476419


This message is strictly confidential. If you have received this in error, 
please inform the sender and remove it from your system. If received in error 
you may not copy, print, forward or use it or any attachment in any way. This 
message is not capable of creating a legal contract or a binding representation 
and does not represent the views of Angus Council. Emails may be monitored for 
security and network management reasons. Messages containing inappropriate 
content may be intercepted. Angus Council does not accept any liability for any 
harm that may be caused to the recipient system or data on it by this message 
or any attachment.




___

Qgis-user mailing list

Qgis-user@lists.osgeo.org<mailto: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

Re: [Qgis-user] Updating a field set with default global variable on edit

[Karl Magnus Jönsson]

Hi!
I've made the same things with triggers in the database. To avoid getting same 
username I've chosen not to save the username and password in the project. But 
then the user have to enter it every time the projects opens. If you can find a 
solution to your suggested approach it would be nice.

Karl-Magnus

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För McDonaldR
Skickat: den 22 augusti 2017 13:12
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] Updating a field set with default global variable on edit

Hi List,

Anyone know how to update a field that has a global variable set as the default 
value when records are edited (geometry and/or attributes)?

We have a QGIS project with a PostGIS layer loaded and configured with look-ups 
and relations so the users can update all the relevant fields. There are also 
"created_by" and "updated_by" fields. These are updated by a trigger in the 
database with the "current_user" database variable. This works fine if you are 
the current user that added the layer to the project - the trigger works 
perfectly.

If you give the project to someone else and they create and edit features in 
the layer the fields are still updated with your name as you are the person who 
added the layer to the project. Not what we want.

QGIS has global variables and there are some new ones - user_account_name and 
user_full_name that can be set as default values for the fields. When a new 
feature is created the field is populated with the correct name. Which is what 
we want.

However, when we update an existing record we'd like the "updated_by" field to 
be updated with the current "user_account_name". Like a trigger in the database 
would do on update. Then we would have a better idea of the history of the 
feature.

Ross

Ross McDonald | GIS Data Coordinator | Angus Council, People, IT | Angus House, 
Orchardbank Business Park, Sylvie Way, Forfar DD8 1AT | t: 01307 476419


This message is strictly confidential. If you have received this in error, 
please inform the sender and remove it from your system. If received in error 
you may not copy, print, forward or use it or any attachment in any way. This 
message is not capable of creating a legal contract or a binding representation 
and does not represent the views of Angus Council. Emails may be monitored for 
security and network management reasons. Messages containing inappropriate 
content may be intercepted. Angus Council does not accept any liability for any 
harm that may be caused to the recipient system or data on it by this message 
or any attachment.
___
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] Strike and dip symbology and labels

[Karl Magnus Jönsson]

Hi!
I can't visualize, in my head, what you are trying to achieve and what's going 
wrong. Can you supply a simple sketch?

Karl-Magnus Jönsson


-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Lester Anderson
Skickat: den 15 augusti 2017 15:06
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] Strike and dip symbology and labels

Hello,

I have strike and dip structural geology data and would like to plot the 
symbols with correctly positioned labels for the dip marker. The strike angle 
can be used for the rotation in a clockwise direction, but labelling the dip 
vector of the symbol is very hit and miss.

A typical data file would be:

Longitude, Latitude, Strike (clockwise from 0 degrees), dip direction 
(orthogonal to strike).

Is there an easy method to deal with this? I can manually position the labels 
with offsets, but for a lot of data this would be a time consuming task!

Thanks

Lester

QGIS version 2.18.11
___
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

Re: [Qgis-user] Georeferenced work won't write to file

[Karl Magnus Jönsson]

Hi!
Did you hit the ”play”-button (green triangle)? Otherwise nothing happens. It’s 
just the settings. Could be a litte unclear.

Karl-Magnus Jönsson | Gis-Utvecklare
Geografisk information
Miljö- och samhällsbyggnadsförvaltningen
Kristianstads kommun
Besöksadress: Västra Storgatan 12
Postadress: 291 80 Kristianstad
www.kristianstad.se

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Nicolas Cadieux
Skickat: den 12 augusti 2017 18:59
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Georeferenced work won't write to file

Did you specify the file name in a existing directory?
Nicolas

Le 12 août 2017 à 10:00, Charles Barrows [via OSGeo.org<http://OSGeo.org>] 
<[hidden email]> a écrit :
Georeferenced work won’t write to file

Cannot figure out what I’m doing wrong.  My georeferenced work on a raster file 
contains 7 points in the GCP table.  The pixel/Easting/Northings  calculated 
with no trouble and filled the table.  The data points with labels show up on 
the raster display.  Using Thin Plate Spline, which was the only transform type 
that has worked for me before.  Resampling method Nearest Neighbor.  Target 
SRS: (Kansas South)  Everything sets up, but after clicking OK the modified.TIF 
file doesn’t show up anywhere on the disk drive.
Frustrated in Denver

___
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

If you reply to this email, your message will be added to the discussion below:
http://osgeo-org.1560.x6.nabble.com/Georeferenced-work-won-t-write-to-file-tp5331337.html
To start a new topic under QGIS - User, email [hidden 
email]
To unsubscribe from QGIS - User, click here.
NAML<http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer=instant_html%21nabble%3Aemail.naml=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>


View this message in context: Re: Georeferenced work won't write to 
file<http://osgeo-org.1560.x6.nabble.com/Georeferenced-work-won-t-write-to-file-tp5331337p5331350.html>
Sent from the QGIS - User mailing list 
archive<http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html> at 
Nabble.com.
___
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] Selecting displaced symbols

[Karl Magnus Jönsson]

Hi!
When talking about this. I’ve had a thought of improvement of the select tool. 
When there is several features in the same (or almost the same) location in one 
layer it is difficult to select one particular feature. Could we have the same 
functionality with select tool as with identify? Right click gets you a 
pull-down menu with potential features and you can select one from the list 
that gets selected. Understandable? Has this already been thought of? A 
workaround is to use the identify tool with right click. At the bottom of the 
list you can open the attribute table and select the desired features from the 
table. Works but one step more.

Karl-Magnus

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Neumann, Andreas
Skickat: den 30 maj 2017 11:11
Till: Martin Bain
Kopia: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Selecting displaced symbols


Hi Martin,

As far as I know, picking is totally independent of the rendering. So the "Info 
tool" doesn't know about the displacement renderer. I know it is not ideal, but 
it is a technical limitation and there are no known workarounds.

You can, however, display the central point (with a separate symbol) so the 
user knows where to pick. Also, you can easily access each individual point by 
changing the identify mode to "Layer choice" - where you get a pull-down menu 
and you can identify each individual point by its "display attribute".

Maybe a dev knows a solution to this problem - but currently I think there are 
no known workarounds.

Andreas

On 2017-05-30 03:39, Martin Bain wrote:
Hi,
I have the familiar situation of a layer with multiple points at the same 
coordinates.  The points have data defined SVG symbols

I’m using the Point Displacement renderer to overcome having overlapping 
symbols.  This definitely makes for an improved appearance.

However if you want to use the info tool or the select tool you cant click on 
the displaced symbol.  You can only select all points via the central point.

Is there a trick to select a point by its offset symbol instead of the true 
coordinates?  I have half a memory of reading something about this once before 
but maybe I imagined it :P

I would prefer to leave the points in their original position – the data is of 
traffic accidents, provided by the state government.

Thank you,
Martin.

This email is intended for the named recipient only. The information it 
contains may be confidential. If you are not the intended recipient you must 
not reproduce or distribute any part of this email, disclose its contents to 
any other party or take any action in reliance on it. If you have received this 
email in error, please contact the sender immediately and delete the message.

___
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

Re: [Qgis-user] Unique IDs in a PostGIS view

[Karl Magnus Jönsson]

Good! And good to know.

Karl-Magnus

Från: Árni Geirsson [mailto:a...@alta.is]
Skickat: den 12 april 2017 15:19
Till: Steve Toutant
Kopia: Karl Magnus Jönsson; qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Unique IDs in a PostGIS view

I left the over clause empty. Based on your suggestion, I tried the following:

SELECT row_number() over (
  order by
fillline_a.id<http://fillline_a.id>,

(st_dumppoints(fillline_a.geom)).path,

st_x((st_dumppoints(fillline_a.geom)).geom),

st_y((st_dumppoints(fillline_a.geom)).geom)
  ) as id,
(fillline_a.z)::real AS z,
(st_dumppoints(fillline_a.geom)).path[1] as p,
st_x((st_dumppoints(fillline_a.geom)).geom) as x,
st_y((st_dumppoints(fillline_a.geom)).geom) as y,
((st_dumppoints(fillline_a.geom)).geom)::geometry(Point,3057) AS geom
FROM v0103.fillline_a

The problem here is that everything in the over clause remains constant for 
each line and therefore the row_number is not incremented for each point. Maybe 
I am doing something wrong. Anyway, I wonder if it should count as a bug in 
QGIS that I can use the nextval() method to see the correctly constructed view 
when listed as a table in DB Manager but not on the map canvas. Anyway, I found 
a simple way around the numbering problem:

with t as (
select  z, (st_dumppoints(fillline_a.geom)).geom from v0103.fillline_a)
select row_number() over () as id, z, geom from t

Problem solved :)
Thanks for the input.

Árni


Árni Geirsson
Alta ehf // +354 582 5000 // +354 897 9549

On 12 April 2017 at 12:48, Steve Toutant 
<steve.tout...@inspq.qc.ca<mailto:steve.tout...@inspq.qc.ca>> wrote:
It would help to see how you used row_number and what field you put in it.

You could create row_number after the dumping
select row_number() OVER (ORDER BY path,st_x,st_y...) AS id, *
 from
(select .ST_DumpPoints. from  ...)

-"Qgis-user" 
<qgis-user-boun...@lists.osgeo.org<mailto:qgis-user-boun...@lists.osgeo.org>> a 
écrit : -
A : Karl Magnus Jönsson 
<karl-magnus.jons...@kristianstad.se<mailto:karl-magnus.jons...@kristianstad.se>>
De : Árni Geirsson
Envoyé par : "Qgis-user"
Date : 12/04/2017 07:13
Cc: "qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org>" 
<qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org>>
Objet : Re: [Qgis-user] Unique IDs in a PostGIS view

Thanks for the suggestion Karl.
I have used row_number() also but in the case of dumping vertex points from a 
line, multiple points are created from each line feature and therefore, the 
row_number is repeated for all points on the same line.

Árni


Árni Geirsson
Alta ehf // +354 582 5000<tel:582%205000> // +354 897 9549<tel:897%209549>

On 12 April 2017 at 09:45, Karl Magnus Jönsson 
<karl-magnus.jons...@kristianstad.se<mailto:karl-magnus.jons...@kristianstad.se>>
 wrote:
Hi!
I’ve used something like this to get unique Ids:
SELECT row_number() OVER (ORDER BY s.omrade_id, s.kod) AS id, …. ORDER BY 
s.omrade_id, s.kod;

If the ordering isn’t necessary I guess you can skip that.

https://www.postgresql.org/docs/current/static/functions-window.html


Karl-Magnus Jönsson

Från: Qgis-user 
[mailto:qgis-user-boun...@lists.osgeo.org<mailto:qgis-user-boun...@lists.osgeo.org>]
 För Árni Geirsson
Skickat: den 12 april 2017 11:34
Till: qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org>
Ämne: [Qgis-user] Unique IDs in a PostGIS view

I am trying to create a view that extracts vertices from lines using 
ST_DumpPoints and to get unique IDs I have set up a sequence to generate the 
numbers using nextval(). The query executes normally in the DB Mananger and I 
see the results as a table in the table view. However, when I attempt to load 
the results of the view as a layer in QGIS, I get an error: "Database error: 
ERROR:  cannot execute nextval() in a read-only transaction". No features are 
loaded.
Are there any smart tricks out there to work around this or other means of 
generating the IDs?

Árni Geirsson

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

Si vous n'êtes pas le destinataire de ce message, veuillez le détruire près 
avoir informé l'expéditeur de son erreur. Par ailleurs, il est interdit de 
copier ou de modifier ce courriel sans l'autorisation de l'auteur.

L'Institut national de santé publique du Québec n'assume aucune responsabilité 
à l'égard du contenu des messages personnels envoyés par ses employés.

___
Qgis-user mailing list
Qgis

Re: [Qgis-user] Unique IDs in a PostGIS view

[Karl Magnus Jönsson]

Hi!
I’ve used something like this to get unique Ids:
SELECT row_number() OVER (ORDER BY s.omrade_id, s.kod) AS id, …. ORDER BY 
s.omrade_id, s.kod;

If the ordering isn’t necessary I guess you can skip that.

https://www.postgresql.org/docs/current/static/functions-window.html


Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Árni Geirsson
Skickat: den 12 april 2017 11:34
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] Unique IDs in a PostGIS view

I am trying to create a view that extracts vertices from lines using 
ST_DumpPoints and to get unique IDs I have set up a sequence to generate the 
numbers using nextval(). The query executes normally in the DB Mananger and I 
see the results as a table in the table view. However, when I attempt to load 
the results of the view as a layer in QGIS, I get an error: "Database error: 
ERROR:  cannot execute nextval() in a read-only transaction". No features are 
loaded.
Are there any smart tricks out there to work around this or other means of 
generating the IDs?

Árni Geirsson
___
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] Retrieve Postgis user from connection string

[Karl Magnus Jönsson]

Maybe you can test that in the trigger. Something like:

IF current_user != 'lizmap_editor' THEN
NEW.GivenUser = current_user;
END IF;

Karl-Magnus Jönsson 


-Ursprungligt meddelande-
Från: Rossin Pietro [mailto:pietro.ros...@arpa.fvg.it] 
Skickat: den 22 mars 2017 11:34
Till: Karl Magnus Jönsson; qgis-user@lists.osgeo.org
Ämne: R: Retrieve Postgis user from connection string

Thanks Karl
Your solution is fine if I edit my postgis layer only with Qgis desktop.

My problem is that I have two different client that can modify this layer.

This layer is served in a webgis editing environment using Lizmap Web Client 
(LWC) and at the same time could be modified by Qgis Desktop.

With Qgis desktop there is no problem using your trigger, because each layer is 
loaded with a given user so NEW.GivenUser = current_user; Is fine

In LWC there is a big problem
When you create a Qgis Project to be served with LWC  you use a defined 
postgresql user, let's say "lizmap_editor"
This user is used by qgis-server that is on the back of Lizmap Web Client In 
LWC environment there are users and groups that can be (or not) those present 
in Postgresql.
If I use your trigger when I  commit an edit session in LWC "lizmap_editor" 
will be written in NEW.GivenUser..
I don't want this to happen.
I want the user logged in LWC client to be inserted in NEW.GivenUser.

So we found a way to catch the LWC user logged in and insert it into the 
"GivenUser" field in using javascript on the web client.
This user, as I said, is different from the one used to load the postgis layer 
(lizmap_editor)

So during commit I must distinguish if the field GivenUser has a value coming 
from LWC.

And at the same time if I edit this layer using Qgis Desktop I want the 
Postgresql current user to be recorded..

Sorry for my bad English explanation... (bad explanation in general indeed ;) )

Any other solution?

Bye
Pietro


-Messaggio originale-
Da: Karl Magnus Jönsson [mailto:karl-magnus.jons...@kristianstad.se]
Inviato: mercoledì 22 marzo 2017 08:27
A: Rossin Pietro <pietro.ros...@arpa.fvg.it>; qgis-user@lists.osgeo.org
Oggetto: SV: Retrieve Postgis user from connection string

Hi Pietro!
Wouldn't a trigger do the job on the database side anyway? I have a trigger:

CREATE TRIGGER update_skotselobjekt_curuser
  BEFORE UPDATE
  ON park.skotselobjekt
  FOR EACH ROW
  EXECUTE PROCEDURE park.update_curuser_column();

That executes this trigger function:

CREATE OR REPLACE FUNCTION park.update_curuser_column()
  RETURNS trigger AS
$BODY$
BEGIN
   --IF row(NEW.*) IS DISTINCT FROM row(OLD.*) THEN
  NEW.anvandare = current_user;
  RETURN NEW;
   --ELSE
   --   RETURN OLD;
  -- END IF;
END;
$BODY$


Works fine for me. I don't use the check "if the new row is distinct from the 
old" since small changes in geometry didn't get caught as a different record.

Karl-Magnus Jönsson

-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Rossin Pietro
Skickat: den 21 mars 2017 17:16
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] Retrieve Postgis user from connection string

Hello
In qgis 2.18 is there some way to automatically get the user name used to load 
a postgis layer?
I need it to populate a table field qgis side, not postgis side (I know I can 
do the latest using a trigger).

On Postgis I use

IF NEW.user_inser is NULL or NEW.user_inser = '' then NEW.user_inser = (select 
current_user); END IF; IF NEW.user_modif is NULL or NEW.user_modif = '' then 
NEW.user_modif = (select current_user); END IF; NEW.data_inser = 
current_timestamp; NEW.data_modif = current_timestamp;

To trap a user who is inserting a new feature and set both insertion and 
modification user/data

Then If I want to get a user/data that updates a record, how can I do?
I mean as a user insert a feature or that feature is updated then next time I 
can't use

IF NEW.user_modif is NULL or NEW.user_modif = '' then NEW.user_modif = (select 
current_user);

And as I load this layer in legend Qgis doesn't change user_modif field.
So I'm searching a way to let Qgis change authomatically user_modif field on 
edit session

I tried to load a query like

select row_number() over(), current_user::text as user

To get the user of a given connection and it performs well but then How can I 
insert user value in user_modif field?

Any other better way??

Thanks
Pietro Rossin

AVVISO DI RISERVATEZZA Informazioni riservate possono essere contenute nel 
messaggio o nei suoi allegati. Se non siete i destinatari indicati nel 
messaggio, o responsabili per la sua consegna alla persona, o se avete ricevuto 
il messaggio per errore, siete pregati di non trascriverlo, copiarlo o inviarlo 
ad alcuno. In tal caso vi invitiamo a cancellare il messaggio ed i suoi 
allegati. Grazie.
CONFIDENTIALITY NOTICE Confidential information may be contained in this 
message or in its attachments. If you ar

Re: [Qgis-user] Retrieve Postgis user from connection string

[Karl Magnus Jönsson]

Hi Pietro!
Wouldn't a trigger do the job on the database side anyway? I have a trigger:

CREATE TRIGGER update_skotselobjekt_curuser
  BEFORE UPDATE
  ON park.skotselobjekt
  FOR EACH ROW
  EXECUTE PROCEDURE park.update_curuser_column();

That executes this trigger function:

CREATE OR REPLACE FUNCTION park.update_curuser_column()
  RETURNS trigger AS
$BODY$
BEGIN
   --IF row(NEW.*) IS DISTINCT FROM row(OLD.*) THEN
  NEW.anvandare = current_user; 
  RETURN NEW;
   --ELSE
   --   RETURN OLD;
  -- END IF;
END;
$BODY$


Works fine for me. I don't use the check "if the new row is distinct from the 
old" since small changes in geometry didn't get caught as a different record. 

Karl-Magnus Jönsson 

-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Rossin Pietro
Skickat: den 21 mars 2017 17:16
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] Retrieve Postgis user from connection string

Hello
In qgis 2.18 is there some way to automatically get the user name used to load 
a postgis layer?
I need it to populate a table field qgis side, not postgis side (I know I can 
do the latest using a trigger).

On Postgis I use

IF NEW.user_inser is NULL or NEW.user_inser = '' then NEW.user_inser = (select 
current_user); END IF; IF NEW.user_modif is NULL or NEW.user_modif = '' then 
NEW.user_modif = (select current_user); END IF; NEW.data_inser = 
current_timestamp; NEW.data_modif = current_timestamp;

To trap a user who is inserting a new feature and set both insertion and 
modification user/data

Then If I want to get a user/data that updates a record, how can I do?
I mean as a user insert a feature or that feature is updated then next time I 
can't use

IF NEW.user_modif is NULL or NEW.user_modif = '' then NEW.user_modif = (select 
current_user);

And as I load this layer in legend Qgis doesn't change user_modif field.
So I'm searching a way to let Qgis change authomatically user_modif field on 
edit session

I tried to load a query like

select row_number() over(), current_user::text as user

To get the user of a given connection and it performs well but then How can I 
insert user value in user_modif field?

Any other better way??

Thanks
Pietro Rossin

AVVISO DI RISERVATEZZA Informazioni riservate possono essere contenute nel 
messaggio o nei suoi allegati. Se non siete i destinatari indicati nel 
messaggio, o responsabili per la sua consegna alla persona, o se avete ricevuto 
il messaggio per errore, siete pregati di non trascriverlo, copiarlo o inviarlo 
ad alcuno. In tal caso vi invitiamo a cancellare il messaggio ed i suoi 
allegati. Grazie.
CONFIDENTIALITY NOTICE Confidential information may be contained in this 
message or in its attachments. If you are not the addressee indicated in this 
message, or responsible for message delivering to that person, or if you have 
received this message in error, you may not transcribe, copy or deliver this 
message to anyone. In that case, you should delete this message and its 
attachments. Thank you.
___
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

Re: [Qgis-user] can't editing view using rules

[Karl-Magnus Jönsson]

Integer (4 bytes). I'll have a look at the view.

Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Matthias Kuhn
Skickat: den 18 januari 2017 09:21
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] can't editing view using rules


Hi Karl-Magnus,

What datatype is your primary key? I think returning is only required for 64 
bit integer or compound primary keys.

For an example of a complex view with return, have a look here:

https://github.com/QGEP/datamodel/blob/master/view/vw_qgep_wastewater_structure.sql

Best regards

Matthias

On 18/01/17 09:11, Karl-Magnus Jönsson wrote:
Hi again!
I've made some more testing. By adding a RETURNING clause to the rule I 
succeeded to insert features. But since it appears that the RETURNING clause 
has to return all the attributes in the view and my view is complex and 
consists of attributes from several tables I couldn't just add RETURNING * (It 
will just return the attributes from the table inserted into). I had to list 
all fields in right order, make some attributes up and cast them to the right 
data type. Like this:

CREATE OR REPLACE RULE lekplatsredskap_ins AS
ON INSERT TO park.v_lekplatsredskap DO INSTEAD  INSERT INTO 
park.skotselpunkt (kod, antal, inkopsar, fabrikat, nr, fritext, utforare, geom)
  VALUES (new.kod, new.antal, new.inkopsar, new.fabrikat, new.nr, new.fritext, 
new.utforare, new.geom)
  RETURNING skotselobj_id,1,kod, 'text'::character 
varying,1234,4567,'plkod'::text, antal, inkopsar, fabrikat, nr, 
fritext,utforare,'2017-01-18'::date,'b_resultat'::character 
varying,'status'::character varying,geom ;

Please let me know if you find a way to solve this better or a way to turn this 
feature off in QGIS.

Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Karl-Magnus 
Jönsson
Skickat: den 17 januari 2017 17:32
Till: Luca Lanteri
Kopia: qgis-user
Ämne: Re: [Qgis-user] can't editing view using rules

Could it be connected with the new feature to "execute expressions on the 
server side if possible"? Then you should get the new primay key from the 
database before you save edits so you can use it for childs in subforms etc.

/Karl-Magnus

17 jan 2017 kl. 11:16 skrev Luca Lanteri 
<lklant...@gmail.com<mailto:lklant...@gmail.com>>:
This is the postgres log [0]:
In fact the 2.18 query add a RETURNING clause that is non present in QGIS 2.14

I've just opened this ticket: http://hub.qgis.org/issues/16083

Luca

[0]
With QGIS 2.18
2017-01-17 11:09:32 CET [25093]: [5-1] user=l_lanteri,db=sigeo,app=QGIS 
STATEMENT:  INSERT INTO 
"sicod"."v_dif_spon"("geom","oper_id","padr_id","sigla_rile","cod_opera","prog_opera","localita","sponda","alt_min","alt_max","lung","tipologia","efficienza","stato","mat_massi","mat_c_secc","mat_c_int","mat_a_secc","mat_a_int","mat_gabbio","mat_cls","mat_legna","i_manuten","i_nessuna","i_prolung","i_pulizia","i_ricostru","i_sottomur","i_svuotam","so_dissest","so_interra","so_scalzat","so_sifonat","data_rilev","note","utente_crea","data_crea","utente_mod","data_mod","fonte","desc_fonte","font_elab","font_sopr","font_altro")
 VALUES 
(st_multi(st_geomfromwkb($1::bytea,32632)),$2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,'0','0','0',NULL,'0','0','0','0','0','0','0','0','0','0','0','2000-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
 RETURNING "oper_id"

With QGIS 2.14
2017-01-17 11:12:01 CET [26026]: [3-1] user=l_lanteri,db=sigeo,app=QGIS LOG:  
execute addfeatures: INSERT INTO 
"sicod"."v_dif_spon"("geom","oper_id","padr_id","sigla_rile","cod_opera","prog_opera","localita","sponda","alt_min","alt_max","lung","tipologia","efficienza","stato","mat_massi","mat_c_secc","mat_c_int","mat_a_secc","mat_a_int","mat_gabbio","mat_cls","mat_legna","i_manuten","i_nessuna","i_prolung","i_pulizia","i_ricostru","i_sottomur","i_svuotam","so_dissest","so_interra","so_scalzat","so_sifonat","data_rilev","note","utente_crea","data_crea","utente_mod","data_mod","fonte","desc_fonte","font_elab","font_sopr",&q

Re: [Qgis-user] can't editing view using rules

[Karl-Magnus Jönsson]

Hi again!
I've made some more testing. By adding a RETURNING clause to the rule I 
succeeded to insert features. But since it appears that the RETURNING clause 
has to return all the attributes in the view and my view is complex and 
consists of attributes from several tables I couldn't just add RETURNING * (It 
will just return the attributes from the table inserted into). I had to list 
all fields in right order, make some attributes up and cast them to the right 
data type. Like this:

CREATE OR REPLACE RULE lekplatsredskap_ins AS
ON INSERT TO park.v_lekplatsredskap DO INSTEAD  INSERT INTO 
park.skotselpunkt (kod, antal, inkopsar, fabrikat, nr, fritext, utforare, geom)
  VALUES (new.kod, new.antal, new.inkopsar, new.fabrikat, new.nr, new.fritext, 
new.utforare, new.geom)
  RETURNING skotselobj_id,1,kod, 'text'::character 
varying,1234,4567,'plkod'::text, antal, inkopsar, fabrikat, nr, 
fritext,utforare,'2017-01-18'::date,'b_resultat'::character 
varying,'status'::character varying,geom ;

Please let me know if you find a way to solve this better or a way to turn this 
feature off in QGIS.

Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Karl-Magnus 
Jönsson
Skickat: den 17 januari 2017 17:32
Till: Luca Lanteri
Kopia: qgis-user
Ämne: Re: [Qgis-user] can't editing view using rules

Could it be connected with the new feature to "execute expressions on the 
server side if possible"? Then you should get the new primay key from the 
database before you save edits so you can use it for childs in subforms etc.

/Karl-Magnus

17 jan 2017 kl. 11:16 skrev Luca Lanteri 
<lklant...@gmail.com<mailto:lklant...@gmail.com>>:
This is the postgres log [0]:
In fact the 2.18 query add a RETURNING clause that is non present in QGIS 2.14

I've just opened this ticket: http://hub.qgis.org/issues/16083

Luca

[0]
With QGIS 2.18
2017-01-17 11:09:32 CET [25093]: [5-1] user=l_lanteri,db=sigeo,app=QGIS 
STATEMENT:  INSERT INTO 
"sicod"."v_dif_spon"("geom","oper_id","padr_id","sigla_rile","cod_opera","prog_opera","localita","sponda","alt_min","alt_max","lung","tipologia","efficienza","stato","mat_massi","mat_c_secc","mat_c_int","mat_a_secc","mat_a_int","mat_gabbio","mat_cls","mat_legna","i_manuten","i_nessuna","i_prolung","i_pulizia","i_ricostru","i_sottomur","i_svuotam","so_dissest","so_interra","so_scalzat","so_sifonat","data_rilev","note","utente_crea","data_crea","utente_mod","data_mod","fonte","desc_fonte","font_elab","font_sopr","font_altro")
 VALUES 
(st_multi(st_geomfromwkb($1::bytea,32632)),$2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,'0','0','0',NULL,'0','0','0','0','0','0','0','0','0','0','0','2000-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
 RETURNING "oper_id"

With QGIS 2.14
2017-01-17 11:12:01 CET [26026]: [3-1] user=l_lanteri,db=sigeo,app=QGIS LOG:  
execute addfeatures: INSERT INTO 
"sicod"."v_dif_spon"("geom","oper_id","padr_id","sigla_rile","cod_opera","prog_opera","localita","sponda","alt_min","alt_max","lung","tipologia","efficienza","stato","mat_massi","mat_c_secc","mat_c_int","mat_a_secc","mat_a_int","mat_gabbio","mat_cls","mat_legna","i_manuten","i_nessuna","i_prolung","i_pulizia","i_ricostru","i_sottomur","i_svuotam","so_dissest","so_interra","so_scalzat","so_sifonat","data_rilev","note","utente_crea","data_crea","utente_mod","data_mod","fonte","desc_fonte","font_elab","font_sopr","font_altro")
 VALUES 
(st_multi(st_geomfromwkb($1::bytea,32632)),$2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,'0','0','0',NULL,'0','0','0','0','0','0','0','0','0','0','0','2000-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)


2017-01-17 10:41 GMT+01:00 Karl-Magnus Jönsson 
<karl-magnus.jons...@kristianstad.se<mailto:karl-magnus.jons...@kristianstad.se>>:
Hi!
Ok. When I try another view with an INSERT rule I have the same problem in 
2.18.2. Works in 2.14. UPDATE and DELETE are ok as well. Can we check the 
resulting SQL from QGIS? Must be some

Re: [Qgis-user] can't editing view using rules

[Karl-Magnus Jönsson]

Could it be connected with the new feature to "execute expressions on the 
server side if possible"? Then you should get the new primay key from the 
database before you save edits so you can use it for childs in subforms etc.

/Karl-Magnus

17 jan 2017 kl. 11:16 skrev Luca Lanteri 
<lklant...@gmail.com<mailto:lklant...@gmail.com>>:

This is the postgres log [0]:
In fact the 2.18 query add a RETURNING clause that is non present in QGIS 2.14

I've just opened this ticket: http://hub.qgis.org/issues/16083

Luca

[0]
With QGIS 2.18
2017-01-17 11:09:32 CET [25093]: [5-1] user=l_lanteri,db=sigeo,app=QGIS 
STATEMENT:  INSERT INTO 
"sicod"."v_dif_spon"("geom","oper_id","padr_id","sigla_rile","cod_opera","prog_opera","localita","sponda","alt_min","alt_max","lung","tipologia","efficienza","stato","mat_massi","mat_c_secc","mat_c_int","mat_a_secc","mat_a_int","mat_gabbio","mat_cls","mat_legna","i_manuten","i_nessuna","i_prolung","i_pulizia","i_ricostru","i_sottomur","i_svuotam","so_dissest","so_interra","so_scalzat","so_sifonat","data_rilev","note","utente_crea","data_crea","utente_mod","data_mod","fonte","desc_fonte","font_elab","font_sopr","font_altro")
 VALUES 
(st_multi(st_geomfromwkb($1::bytea,32632)),$2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,'0','0','0',NULL,'0','0','0','0','0','0','0','0','0','0','0','2000-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
 RETURNING "oper_id"

With QGIS 2.14
2017-01-17 11:12:01 CET [26026]: [3-1] user=l_lanteri,db=sigeo,app=QGIS LOG:  
execute addfeatures: INSERT INTO 
"sicod"."v_dif_spon"("geom","oper_id","padr_id","sigla_rile","cod_opera","prog_opera","localita","sponda","alt_min","alt_max","lung","tipologia","efficienza","stato","mat_massi","mat_c_secc","mat_c_int","mat_a_secc","mat_a_int","mat_gabbio","mat_cls","mat_legna","i_manuten","i_nessuna","i_prolung","i_pulizia","i_ricostru","i_sottomur","i_svuotam","so_dissest","so_interra","so_scalzat","so_sifonat","data_rilev","note","utente_crea","data_crea","utente_mod","data_mod","fonte","desc_fonte","font_elab","font_sopr","font_altro")
 VALUES 
(st_multi(st_geomfromwkb($1::bytea,32632)),$2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,'0','0','0',NULL,'0','0','0','0','0','0','0','0','0','0','0','2000-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)


2017-01-17 10:41 GMT+01:00 Karl-Magnus Jönsson 
<karl-magnus.jons...@kristianstad.se<mailto:karl-magnus.jons...@kristianstad.se>>:
Hi!
Ok. When I try another view with an INSERT rule I have the same problem in 
2.18.2. Works in 2.14. UPDATE and DELETE are ok as well. Can we check the 
resulting SQL from QGIS? Must be some difference there. I don’t know if we can 
turn on logging on our database.

Karl-Magnus Jönsson

Från: mesca...@gmail.com<mailto:mesca...@gmail.com> 
[mailto:mesca...@gmail.com<mailto:mesca...@gmail.com>] För Luca Lanteri
Skickat: den 16 januari 2017 14:44
Till: Karl-Magnus Jönsson
Kopia: qgis-user
Ämne: Re: [Qgis-user] can't editing view using rules

Hi Magnus, thanks for the answer.

I think my rules are ok also because they work fine with QGIS 2.14.
The strange things is that the error say about an "INSERT RETURNING" when I 
don't need any RETURING clause.
The problem happens only with INSERT rules. UPDATE and DELETE are ok.


this is my INSERT rule:

CREATE OR REPLACE RULE dif_spon_insert AS
ON INSERT TO sicod.v_dif_spon DO INSTEAD  INSERT INTO sicod.dif_spon 
(padr_id, sigla_rile, prog_opera, localita, sponda, alt_min, alt_max, lung, 
tipologia, efficienza, stato, mat_massi, mat_c_secc, mat_c_int, mat_a_secc, 
mat_a_int, mat_gabbio, mat_cls, mat_legna, i_manuten, i_nessuna, i_prolung, 
i_pulizia, i_ricostru, i_sottomur, i_svuotam, so_dissest, so_interra, 
so_scalzat, so_sifonat, note, data_rilev, desc_fonte, font_elab, font_sopr, 
font_altro, geom)
  VALUES (new.padr_id, new.sigla_rile, new.prog_opera, new.localita, 
new.sponda, new.alt_min, new.alt_max, new.lung, new.tipologia, new.effi

Re: [Qgis-user] can't editing view using rules

[Karl-Magnus Jönsson]

Hi!
Are you sure it isn’t an issue with the view? I have a view with rules and it 
work in 2.18. When you have conditions in the rule you must have another rule 
on the same event that is unconditional. Check the last paragraph in the 
description : https://www.postgresql.org/docs/current/static/sql-createrule.html

In my case I have a unconditional rule that does nothing:

CREATE OR REPLACE RULE v_prislistor_upd_ins AS
ON UPDATE TO park.v_prislistor
   WHERE old.id IS NULL DO INSTEAD  INSERT INTO park.priser (kod, pris, 
utforare)
  VALUES (new.kod, new.pris, new.utforare);

CREATE OR REPLACE RULE v_prislistor_upd_nothing AS
ON UPDATE TO park.v_prislistor DO INSTEAD NOTHING;

CREATE OR REPLACE RULE v_prislistor_upd_upd AS
ON UPDATE TO park.v_prislistor
   WHERE old.id IS NOT NULL DO INSTEAD  UPDATE park.priser SET pris = new.pris
  WHERE priser.id = old.id;

Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Luca Lanteri
Skickat: den 13 januari 2017 16:39
Till: qgis-user
Ämne: [Qgis-user] can't editing view using rules

Hi to all,

starting fron QIS 2.16 I can't edit anymore postgres views with rules. When I 
try to insert a new feature I have this error [0]. All works fine with QGIS 2.14

Can anyone confirm the issue ?
Thanks

Luca

[0]

Impossibile applicare le modifiche al vettore v_frane_pol_full



Errori: ERRORE: 1 geometria non aggiunta.

Errori della sorgente dati:

Errore PostGIS nell'aggiunta delle geometrie: ERROR: cannot perform INSERT 
RETURNING on relation "v_frane_pol_full"

HINT: You need an unconditional ON INSERT DO INSTEAD rule with a RETURNING 
clause.

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

Re: [Qgis-user] spatialjoin

[Karl-Magnus Jönsson]

Actually it is (easier). Or could be. If you are able to use spatial sql as in 
postgis. Maybe you could do something similar in spatialite. A little more work 
to set up the database but in the end there are a lot more possibilities. I 
would have done something like this (maybe not correct syntax. Read the 
referece!):

Create or replace view [viewname] as
Select
A.id,
A.attribute1,
B.attribute2,
A.geom
>From pointtable A, polygontable B
Where st_within(A.geom,B.geom);

If A.geom has to be transformed you could use st_transform inside the st_within 
function.
/Karl-Magnus Jönsson

21 dec 2016 kl. 19:23 skrev Laurent Bourlet 
<laurentbourle...@gmail.com<mailto:laurentbourle...@gmail.com>>:

Hi,

i thought it was more easy ...

In fact , i don't use a GPS because these points don't need precision : they 
are only used to identify the parcels . And i would like to catch their 
identity ( a number for each parcel and the owner ) if possible with a dynamic 
spatialjoin...

With booth data ( number of parcel and name of owner ) , i could talk with the 
fisc administration :-)

Randy was right ...i didn't have the same EPSG for the two layers . It's now OK 
! but without the feature "dynamic" .

Indeed , i would avoid building many temporaries layers and i thought it 
existed a plugin for this  " dynamic" feature.

If no , i will ask my users to make spatialjoins some time to time ...

Waiting , i will try the solution of Bernd...

Thank you anyway !

laurent


Le 21/12/2016 à 17:46, Bernd Vogelgesang a écrit :
Hi,

for me this sounds more like he is getting new points once in a while and
wants to join those attributes to the new points "automatically" from the
parcel layer.

The biggest problem for users is to rethink the workflow from the end to
the beginning and to know the limitations.

The outcome should be a point layer with the polygons attributes. If those
points (layer A) are from GPS as Randy assumes, they have to be
reprojected to the parcels layer (layer B) before being able to join them
spatially(layer C). The spatial join in the toolbox produces layer D.

Most probably, the resulting layer D is going to to be edited in some way
(adding notes about size, the progress, classifications, whatever), so you
will have to find a way to preserve those new attribute while being able to
add new points without much trouble.

The processing toolbox is a good way to do these steps, though it produces
a lot of temporary files cluttering the project.

A better way for all those repetitive tasks, is to use the graphical
modeller, to create a workflow which only has to be triggered once new
points come in, and the resulting file can be saved as new a file e.g.
with the current date in the name, so you have kind of an archive and do not
overwrite previous files (and destroy your work in case something goes
wrong).

So I can imagine a model with input layer A (new points in WGS84 without 
attributes) and a parcel layer B (in whatever projection).
reproject layer A and C will be created as an intermediate step.

Next input layer is the latest result layer D, reprojected and with attributes.
Merge layer C and D -> E. Now delete all columns which are from layer B (from 
the last spatial join. Unfortunately, you can only delete one field at a time 
in the modeller, so you'll will have to add the command several times in a row 
to the model) -> Fn
Do the spatial join of Fn with B.

The last result G will now hold all points with the corresponding parcel info 
plus additional fields you might have added to the points.
G will be the input D in the next run with fresh points.

So, do not add new points to the already existing collection of points in WGS84 
(it is never save to edit layers without backup), but just import them as a new 
input set and then run the model with the parcel layer and the last result 
layer.

The modeller is not as intuitive as it should be, but it can save you a lot of 
time once you managed to set up a model.

Maybe I was completely wrong analysing the problem, but maybe someone else has 
the problem that fits to my solution ;)
Cheers
Bernd





Am 21.12.2016, 14:07 Uhr, schrieb Randal Hale
<rjh...@northrivergeographic.com<mailto:rjh...@northrivergeographic.com>>:

2 things:

1. In QGIS there is a processing toolbox (I assume you are one something as new 
as version 2.14.8). Open it (it's at the top -> Processing -> Toolbox). You can 
search for tools. Search for "join" and you should see a "Join Attributes by 
location". This is a spatial join.

2. THE MOST IMPORTANT THING. You mentioned you had collected points with a GPS. 
Possibly these points are in EPSG:4326. I'm going to guess that your parcel 
layer isn't. If you right click your parcel layer (in the layers panel) it will 
allow you to select properties. On the General Tab you will see the Coordinate 
Reference System mentioned and many times it 

Re: [Qgis-user] Tool to copy the content of the map canvas to the clipboard

[Karl-Magnus Jönsson]

Hi!
As I use Windows I usually use the Snipping tool in Windows for such needs. 
Isn’t that an option? Useful for other programs too.

Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Larry Shaffer
Skickat: den 20 december 2016 21:44
Till: DelazJ
Kopia: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Tool to copy the content of the map canvas to the 
clipboard

Hi,

On Tue, Dec 20, 2016 at 11:02 AM, DelazJ 
<del...@gmail.com<mailto:del...@gmail.com>> wrote:
Hi,
2016-12-20 18:23 GMT+01:00 Bo Victor Thomsen 
<bo.victor.thom...@gmail.com<mailto:bo.victor.thom...@gmail.com>>:
Hi List-members -

Is there in Qgis a function / button / menu-item / short-cut / plugin to make a 
simple bitmap copy of the current content of the map-canvas and save it to the 
clipboard ? My users need this to make a copy of the map and paste into MS-Word 
or other software.

While not part of the QGIS app, one could use this PyQGIS snippet to do so 
(tested quickly on macOS 10.11.6 under QGIS 2.14) from the PyQGIS console:

from PyQt4.QtGui import *
QApplication.clipboard().setImage(QImage(QPixmap.grabWidget(iface.mapCanvas(

This avoids having to re-render the QGraphicsView (QgsMapCanvas) to a paint 
device, like an image. Code can be wrapped in a plugin, then have some key 
bindings applied (would need some more PyQt).

Larry Shaffer
Dakota Cartography
Black Hills, South Dakota

I really need the functionality for my users and I can't seem to find it. The 
closest I've come is the "save as png" menu-item in the project menu. But it's 
to cumbersome to use in this case.

Afaics, there's no "save as png" option but "save as image" in Project menu, 
option from which you can choose the image file format (bmp, jpg...). It's not 
on the clipboard but easier and more accessible than print composer.
Regards,
Harrissou


I'm familiar with the composer function. My users can't use this neither 
because it takes to long to activate (to many choices and to many buttons to 
click)

So I've decided to make a simple plugin to cover this functionality. But first 
I want to be very sure the function actually is missing ;-)

Regards
Bo Victor Thomsen
Municipality of Frederikssund, Denmark.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org<mailto:Qgis-user@lists.osgeo.org>
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org<mailto:Qgis-user@lists.osgeo.org>
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

Re: [Qgis-user] How to edit repetitive data in QGIS

[Karl-Magnus Jönsson]

Hi!
Instead of editing the lines or attributes with all that work you can do this 
in the styling. In the labels tab of the layer properties there are rendering 
options. There is a checkbox for merging connected lines to avoid duplicate 
labels. Hope this works.

Karl-Magnus Jönsson 

-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Raymond Nijssen
Skickat: den 15 december 2016 08:58
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] How to edit repetitive data in QGIS

Hi Charlotte,

You can use the "dissolve" tool for merging features that have value(s) in 
common. In this case the field "name" contains that value.

Go:
Vector >> Geoprocessing tools >> Dissolve...
Remove the check mark at "Dissolve all (do not use field)"
Add the field "name" to unique ID fields list Run

This worked for me. Only drawback is that all roads without a name were merged 
together. If you mind that, you can select and remove them before running the 
dissolve algorithm.

Good luck,
Raymond




On 15-12-16 07:07, Matt Boyd wrote:
> Can you select the features you want by a function using the same 
> street name, then Edit - merge selected features.
>
> On 15 Dec 2016 08:40, "Charlotte Wolter" <techl...@techlady.com 
> <mailto:techl...@techlady.com>> wrote:
>
> Hello, all,
>
> I created a query for data from OpenStreetMap using
> overpassturbo.eu <http://overpassturbo.eu>. I needed major street,
> so used the expression highway=primary. The area was a large section
> of Los Angeles, about 1/6th of the city, the area called South Bay.
> I got the steeets I need, no problem. But, I also got the
> street names repeating over and over, because the streets are broken
> into segments by changes, such as a bridge or a change in speed
> limit, etc., etc.
> I am looking for a way to solve this issue, such as editing
> the data to remove the names from some of these segments. I have
> opened the data in the "Attributes Table," but I can't seem to edit
> it there (which would be handy). So, if QGIS does not support
> editing a data file, is there some other way to do it?
> Thanks!
>
> Charlotte Wolter
>
>
>
> Charlotte Wolter
> 927 18th Street Suite A
> Santa Monica, California
> 90403
> +1-310-597-4040 <tel:%2B1-310-597-4040>
> techl...@techlady.com <mailto:techl...@techlady.com>
> Skype: thetechlady
>
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> <http://lists.osgeo.org/mailman/listinfo/qgis-user>
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> <http://lists.osgeo.org/mailman/listinfo/qgis-user>
>
>
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>

--
Terglobo
Fahrenheitstraat 1
5223 BJ 's-Hertogenbosch
06 25 31 49 83
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Checking validity

[Karl-Magnus Jönsson]

Hi all!
Just curious if everyone thinks that moving everything to processing is the 
best solutions for everything. I’m want correct geometries in our PostGIS 
database and want also my not that experienced GIS users to check geometry 
before saving. The old tool in QGIS 2.14 creates a simple list of every error. 
By clicking on the error you get zoomed to the error. You correct the error and 
then hit the OK button to rerun the evaluation and get an new hopefully smaller 
list and save the edits. A smooth workflow. I suppose the new tool in 
processing does the same. But it’s more difficult. It pollutes your project 
with temporary layers for every run. And it is more clicking to find the 
errors. Or is there a better way to do this? I guess that if you do a lot of 
data manipulation/analysis/processing with input and output data this is a good 
approach but my focus is more often maintaining/updating/editing data. Then it 
gets more complicated.

Karl-Magnus Jönsson │GIS-utvecklare
Miljö- och samhällsbyggnadsförvaltningen, avd. Geografisk information
Kristianstads kommun
291 80 Kristianstad
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Jointure request

[Karl-Magnus Jönsson]

Hi,
How do you do the spatial join? Are you using a database?

Karl-Magnus Jönsson 


-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Erwan Conseil
Skickat: den 13 oktober 2016 13:02
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Jointure request

i forgot ...the geometries are correct ..

Le 13/10/2016 à 12:40, Erwan Conseil a écrit :
> Hi
>
> i a have a little pb with the jointures ... certainly simple ...but ..
>
> I try a spatial jointure between  a layer with buildings and a layer 
> with plots of land  . With that , i try to have all the polts of land 
> with a building ... So , i make a spatial jointure with " plots of 
> land" contains " buildings" . But some plots are indeed in the layer 
> of plots of land ( exist in the table and visible on the map ) . Also 
> the buidings of these plots exist in the table of buiding ( and 
> visible on the map ). But ...but , the spatial jointure give nothing 
> for these plots and buiding ...On the map , i see the buiding , the 
> plot but the plot dos'nt appear like a "plot with buiding"...
>
> The too layers are in the same projection ... I don't know wher is the 
> pb and ..the solution !
>
> Thank a lot for the help !!
>
> Laurent
>
> ( precisions : work with a Mac and Qgis 2.16 )
>
>

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

Re: [Qgis-user] Project CRS doesn't update when layer is added

[Karl-Magnus Jönsson]

Hi!
I've just tried this in 2.16. In Settings -> Options -> CRS there are three 
options for new projects. With the two first options, don’t enable and 
automatically enable on the fly reprojections, I get the project to change from 
the default CRS set in the dropdown just below. I don't remember witch option 
that is default from installation.

Karl-Magnus Jönsson 

-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Lee Hachadoorian
Skickat: den 10 oktober 2016 05:35
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] Project CRS doesn't update when layer is added

I recently updated to QGIS 2.16. As I recall, previous version behavior was for 
CRS to change to the CRS of the first layer added to the project. This doesn't 
seem to be happening anymore. Project CRS defaults to WGS 84 (EPSG:4326) for a 
new project and remains that when I add a layer that uses a different CRS.

Is this (a) an intentional change, (b) a bug, or (c) not new behavior and I am 
misremembering the way it used to be?

QGIS 2.16.3
Linux Mint 18
Installed from http://qgis.org/ubuntugis repository

Best,
--Lee

--
Lee Hachadoorian
Assistant Professor of Instruction, Geography & Urban Studies Assistant 
Director, Professional Science Master's in GIS Temple University 
http://geospatial.commons.gc.cuny.edu
http://freecity.commons.gc.cuny.edu

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

Re: [Qgis-user] [Qgis-developer] Discussion on the QGIS grant proposals

[Karl-Magnus Jönsson]

Hi,
As a user and not (yet) a voting member or developer I can just agree with 
Andreas and Vincent. The QGIS grant program, at least now, should focus on QGIS 
3 release, broad under the hood structural changes that moves QGIS into a 
better and more stable platform and not narrow or local features more easily 
funded in other ways.

Regards
Karl-Magnus Jönsson
Kristianstads kommun

-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Vincent Picavet 
(ml)
Skickat: den 22 september 2016 10:10
Till: Neumann, Andreas; QGIS Developers List; QGIS User List
Ämne: Re: [Qgis-user] [Qgis-developer] Discussion on the QGIS grant proposals

Hello,

Thanks Andreas for raising this topic and clearing up facts and giving your 
position.
I agree 100% with what you stated, and I do think this is something which 
should be emphasized much more, if not even constrained.

Some more notes below.

On 22/09/2016 08:14, Neumann, Andreas wrote:
> [..] Now comes my personal position/opinion - note that this is not 
> the official opinion of the QGIS.ORG board.
Same here

> I would personally welcome, if this round of the QGIS grants program 
> could focus on the QGIS 3.0 release.

This is indeed the main challenge for QGIS in the coming months.
Focusing on all aspects of making QGIS3 a real thing should be our top priority 
when confronted to choices.

> I personally also think that the QGIS grants program, at least at the 
> current time, should not pay for development of new features (at least 
> not features visible in the GUI for the users). These features can be 
> "relatively easy" funded by companies and government organizations out 
> there. So our limited QGIS.ORG funds should be rather spent a) to 
> community work or b) infrastructure work or c) development work in the 
> core of QGIS, such as API modifications, code redesign - stuff that 
> isn't really visible to the users, but essential for the success of 
> the project.

From a developer's company point of view, I can only applause to this.
We have numerous demands for new features with paid contract, and the global 
pace of feature development in QGIS is really fast. The very large majority of 
them are funded by clients.
Meanwhile, all tasks like refactoring, code cleaning, bug triaging, 
infrastructure and long term core development efforts are really difficult to 
get funded. Public sector organization generally can't pay for this due to 
public tender bid constraints, and generally end-users do not realize that this 
kind of work is at the same time necessary and time consuming.
In my opinion, the role of QGIS organization, hence the QGIS Grant program, is 
to compensate for this disequilibrium.

> Documentation and PyQT documentation work is already budgeted in our 
> annual budget. The money for 2016 hasn't even been spent for both 
> items. So I think we should first use the budgeted money for such 
> work. I think that user and developer documentation should be an 
> ongoing effort and should be supported every year, und budgeted every 
> year as such. We can increase the documentation budget positions next 
> year, should it be necessary. In reality, it was more a lack of people 
> willing to do the work, rather than a lack of funding. So, I am happy 
> to see some proposals around documentation and developer documentation 
> - so it seems that we have some volunteers. I just suggest that we 
> consider documentation work separately and do it anyway - regardless 
> of the outcome of the voting on these items.

Documentation is crucial, and I am also fully in favor of having a dedicated 
yearly budget to improve it. It should be stated in the QGIS grant application 
call too.

> Several proposals have a very limited local focus, only useful to one 
> single country, or a very limited subset of our users. I suggest that 
> such proposals could best be financed by local user groups or interest 
> groups. It can't be the purpose of the QGIS grants program to finance 
> such projects.

+1 also

Since I have more or less the same priority list as Andreas, I will also add a 
few comments below.

> ---
> 
> Here is my own personal list of priorities:

In my own priority order :

> ​11)​ Introduce everything necessary for QGIS3 to OSGeo4W
> 
> The majority of our users are on Windows (like it or not). This is the 
> platform that matters most in our user base. The introduction of QGIS 
> 3.0 means porting everything to newer libraries and means a lot of 
> work. This should be one of our main priorities. Jürgen does it works 
> silently in the background many days of work each year that go 
> unnoticed. Jürgen usually only hears complaints if something fails - 
> maybe not so much praise. Having Windows nightly builds and releases 

[Qgis-user] Update multiple features in relation

[Karl-Magnus Jönsson]

Hi!
I'd like to update all related records(children) in a sub form. Is there a way 
to do that? To have the Field calculator in the sub form would be a nice 
solution. But it isn't there (yet). Does anyone have a workaround?

/Karl-Magnus Jönsson
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Transaction groups in 2.16

[Karl-Magnus Jönsson]

Thanks! Found it now :) And it works. However as I'm speaking to the 
developer:) I have a default value for the current user. And I'm getting a SQL 
error when enabling "Evaluate default values on provider side". Actually it 
evaluates OK but when trying to insert the error arises.

Column definition:
anvandare character varying(20) DEFAULT "current_user"(),

Then QGIS tries to insert my user name as a string without '' resulting in not 
finding any column with my user name. 

Karl-Magnus Jönsson │GIS-utvecklare
Miljö- och samhällsbyggnadsförvaltningen, avd. Geografisk information
Kristianstads kommun
291 80 Kristianstad
Besöksadress: Västra Storgatan 12
Tel 044-13 54 16 │ Mobil: 0733-13 54 16 │karl-magnus.jons...@kristianstad.se
www.kristianstad.se

-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Matthias Kuhn
Skickat: den 8 september 2016 11:45
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Transaction groups in 2.16

Hi Karl-Magnus,

it has been moved to project properties.

Matthias

On 09/08/2016 10:16 AM, Karl-Magnus Jönsson wrote:
> Hi!
> 
> I can’t find the option for transaction groups in QGIS  2.16.2. I 
> should be in Settings -> Options -> Data Sources. Is there in 2.14 
> anyway. I’d like to try it out. Anyone who knows about it?
> 
>  
> 
> *Karl-Magnus Jönsson*│GIS-utvecklare
> 
> Miljö- och samhällsbyggnadsförvaltningen, avd. Geografisk information
> 
> Kristianstads kommun
> 
> 291 80 Kristianstad
> 
> Besöksadress: Västra Storgatan 12
> 
> Tel 044-13 54 16 │Mobil: 0733-13 54 16 
> │karl-magnus.jons...@kristianstad.se
> 
> www.kristianstad.se <http://www.kristianstad.se/>
> 
>  
> 
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Transaction groups in 2.16

[Karl-Magnus Jönsson]

Hi!
I can’t find the option for transaction groups in QGIS  2.16.2. I should be in 
Settings -> Options -> Data Sources. Is there in 2.14 anyway. I’d like to try 
it out. Anyone who knows about it?

Karl-Magnus Jönsson │GIS-utvecklare
Miljö- och samhällsbyggnadsförvaltningen, avd. Geografisk information
Kristianstads kommun
291 80 Kristianstad
Besöksadress: Västra Storgatan 12
Tel 044-13 54 16 │ Mobil: 0733-13 54 16 │karl-magnus.jons...@kristianstad.se
www.kristianstad.se<http://www.kristianstad.se/>

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

Re: [Qgis-user] Auto-fill id in attribute table when creating a feature

[Karl-Magnus Jönsson]

OK. Maybe not. But are you not interested in adding attribute values to the 
features you can set that the attribute form doesn’t show after adding 
features. Look in the top of section digitizing in the options dialog.

http://docs.qgis.org/2.8/en/docs/user_manual/introduction/qgis_configuration.html#options


Karl-Magnus Jönsson

Från: Simon Muirhead [mailto:si...@simsurf.com.au]
Skickat: den 31 maj 2016 15:27
Till: Karl-Magnus Jönsson
Ämne: Re: SV: [Qgis-user] Auto-fill id in attribute table when creating a 
feature


Hi Karl, it won't let you create a shape file without at least one field in the 
attribute table.

Regards, Simon Muirhead
Written from my Nexus 6P so don't expect Tolstoy.
On 31 May 2016 23:19, "Karl-Magnus Jönsson" 
<karl-magnus.jons...@kristianstad.se<mailto:karl-magnus.jons...@kristianstad.se>>
 wrote:
Hi!
Do you really need the ID field in the shapefile? If not you can drop it, hide 
it or ignore it and it works anyway. If you need a counter as primary key 
consider using another data provider suggested by Andreas.

Karl-Magnus Jönsson

Från: Qgis-user 
[mailto:qgis-user-boun...@lists.osgeo.org<mailto:qgis-user-boun...@lists.osgeo.org>]
 För Neumann, Andreas
Skickat: den 31 maj 2016 14:04
Till: Simon Muirhead
Kopia: qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org>
Ämne: Re: [Qgis-user] Auto-fill id in attribute table when creating a feature


Hi Simon,

It is a bit data provider dependent. For many data providers (e.g. Postgis, 
SpatiaLite, Geopackage) you just don't fill in this value (or better set the 
edit widget to "read only") - provided that the database has a sequence defined 
for the primary key column. The values are filled in when saving the data. In 
2.16 there is a new mode for PostgreSQL to immediately get the id value 
(experimental).

What data format are you using?

Greetings,

Andreas

On 2016-05-31 13:43, Simon Muirhead wrote:

Hi, I am new to QGIS, coming from ARCGiS. I was wondering when creating a new 
feature in a shape file, QGIS asks to fill in the id in the attribute table for 
every feature created. Is there anyway to have this done automatically like 
ARCGiS does?

Regards, Simon Muirhead
Written from my Nexus 6P so don't expect Tolstoy.

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org<mailto:Qgis-user@lists.osgeo.org>
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user



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

Re: [Qgis-user] Auto-fill id in attribute table when creating a feature

[Karl-Magnus Jönsson]

Hi!
Do you really need the ID field in the shapefile? If not you can drop it, hide 
it or ignore it and it works anyway. If you need a counter as primary key 
consider using another data provider suggested by Andreas.

Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Neumann, Andreas
Skickat: den 31 maj 2016 14:04
Till: Simon Muirhead
Kopia: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Auto-fill id in attribute table when creating a feature


Hi Simon,

It is a bit data provider dependent. For many data providers (e.g. Postgis, 
SpatiaLite, Geopackage) you just don't fill in this value (or better set the 
edit widget to "read only") - provided that the database has a sequence defined 
for the primary key column. The values are filled in when saving the data. In 
2.16 there is a new mode for PostgreSQL to immediately get the id value 
(experimental).

What data format are you using?

Greetings,

Andreas

On 2016-05-31 13:43, Simon Muirhead wrote:

Hi, I am new to QGIS, coming from ARCGiS. I was wondering when creating a new 
feature in a shape file, QGIS asks to fill in the id in the attribute table for 
every feature created. Is there anyway to have this done automatically like 
ARCGiS does?

Regards, Simon Muirhead
Written from my Nexus 6P so don't expect Tolstoy.

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org<mailto:Qgis-user@lists.osgeo.org>
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user



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

Re: [Qgis-user] Project file data loss

[Karl-Magnus Jönsson]

Hi,
We've had some problems with large project files. The saving of the file takes 
quite long time and occasionally users don't wait for the process to finish and 
terminate the program ending up with a corrupt file. But then users can't open 
the file. Maybe not the same problem. The .qgs~ files and backups have saved us 
several times.

Karl-Magnus Jönsson │GIS-utvecklare
Miljö- och samhällsbyggnadsförvaltningen, avd. Geografisk information
Kristianstads kommun
291 80 Kristianstad
Besöksadress: Västra Storgatan 12
Tel 044-13 54 16 │ Mobil: 0733-13 54 16 │karl-magnus.jons...@kristianstad.se
www.kristianstad.se

-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För johnrobot
Skickat: den 26 april 2016 08:58
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] Project file data loss

Hi
When opening a .qgs file used yesterday, I noticed that the project had lost 
almost all of the data, such as linked SHP-files. I have lost a few hours of 
work due to this and this is a bit worrying for further work. It is this first 
time I observe this and I am the only one working with the project file. Any 
suggestions on how to narrow this down? I would like to find the cause of this.

QGIS 2.14.0, 64 bit
Windows 7, 64 bit

Magnus



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Project-file-data-loss-tp5262903.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Atlas: Filter Empty Pages

[Karl-Magnus Jönsson]

Hi!
QGIS likes to have something unique. Try to add something like this in your 
select statement. This is a snippet from a view I made that works:

SELECT row_number() OVER (ORDER BY o.id, s.id) AS uid,
 s.id,
...

Row_number creates a counter and then you have to decide the order in "OVER()". 
o.id and s.id is just what I use to sort on in my tables.

Karl-Magnus Jönsson │GIS-utvecklare
Miljö- och samhällsbyggnadsförvaltningen, avd. Geografisk information
Kristianstads kommun
291 80 Kristianstad
Besöksadress: Västra Storgatan 12
Tel 044-13 54 16 │ Mobil: 0733-13 54 16 │karl-magnus.jons...@kristianstad.se
www.kristianstad.se

-Ursprungligt meddelande-
Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Albin Blaschka
Skickat: den 22 mars 2016 15:59
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Atlas: Filter Empty Pages

Hello!

So, finally, I was successful: The idea with the virtual layer made it simple, 
as the point data is a postgis layer anyway, after storing the grid in the 
database, I created a view, where I have my grid and the count of points per 
cell, which I use for the creation of the atlas. 
Brings other advantages as well... (...wondering why I had this idea not
earlier...)
The only caveat was that QGIS did not want to load the view as layer directly - 
It said, the layer is not valid. But after doing a "select * from myview" in 
the DB-Manager and adding the result as layer, it worked. Will look into it 
later...
(Postgres 9.4.6, PostGIS 2.1, pretty standard Ubuntu server - QGIS 2.14 on Win7 
- maybe somebody has an idea on that, too?)

Thank you all for your help and specially Andreas!
best regards,
Albin

Am 21.03.2016 um 17:00 schrieb Andreas Neumann:
> hm - actually, I was wrong.
>
> It is not so easy to filter dynamically - as $geometry equals 
> @atlas_geometry and you don't have a relation with the points.
>
> My next try would be to use a "Virtual Layer" and add a spatial 
> relationship between your atlas coverage layer (the grid) and a column 
> containing the count of points within the atlas feature.
>
> See
> https://www.qgis.org/en/site/forusers/visualchangelog214/index.html#fe
> ature-virtual-layers
>
> You need QGIS 2.14 to use the virtual layers.
>
> You can add a virtual column to the atlas coverage layer that uses a 
> spatial relation, group by and count. If the count is zero you can 
> filter that coverage feature away.
>
> This should hopefully work. Let us know if you are stuck.
>
> Andreas
>
> On 21.03.2016 16:41, Andreas Neumann wrote:
>> Hi Albin,
>>
>> You can do this dynamically. The Atlas filter also accepts geometry 
>> relationship functions. Have a look at the QGIS expression editor.
>>
>> You can try with the intersects / within / overlaps tests and test 
>> $geometry against @atlas_geometry.
>>
>> Your filter could look like:
>>
>> within( $geometry,  @atlas_geometry )
>>
>> Can you please report back if that works?
>>
>> Greetings,
>> Andreas
>>
>>
>>
>> On 21.03.2016 14:47, Albin Blaschka wrote:
>>> Am 21.03.2016 um 14:20 schrieb Bernd Vogelgesang:
>>>> sounds maybe to easy, but why don't you just make a spatial query 
>>>> on your coverage grid to select and save those elements which do 
>>>> have points inside (Grid Layer Contains Points Layer e.g.) and then 
>>>> use that new coverage layer to produce your Atlas?
>>>>
>>>> Or do you search for a more clever approach?
>>>>
>>>> Cheers
>>>> Bernd
>>>
>>> Hello Bernd, Joris & List!
>>>
>>> Ah, yes - that would be a possibility, which I did not think of - 
>>> Thank you both!
>>> ...but in general I was on the quest for a "more clever" meaning 
>>> here "dynamic" approach, I have to admit: So, the aim would be in 
>>> future, just opening the project, printing the atlas without further 
>>> intervention and getting an "up-to-date" atlas...
>>> But in the meanwhile, it should be ok with the "manual" approach.
>>>
>>> Thanks and greetings!
>>> Albin
>>>
>>>> Am 21.03.2016, 13:53 Uhr, schrieb Albin Blaschka
>>>> <albin.blasc...@standortsanalyse.net>:
>>>> Hello List!
>>>>
>>>> I am starting to use the Atlas feature for the first time and had 
>>>> the following problem:
>>>> I have a coverage-layer (a vector grid) and a point layer 
>>>> (collection sites). At the moment, there are grid cells in which no 
>>>

Re: [Qgis-user] DB Manager geometry problems

[Karl-Magnus Jönsson]

Hi Chris

Appears that the user can’t access the view geometry_columns in the public 
schema. The information is accessed from there. Grant select privileges.

Karl-Magnus Jönsson │GIS-utvecklare
Miljö- och samhällsbyggnadsförvaltningen, avd. Geografisk information
Kristianstads kommun
291 80 Kristianstad
Besöksadress: Västra Storgatan 12
Tel 044-13 54 16 │ Mobil: 0733-13 54 16 │karl-magnus.jons...@kristianstad.se
www.kristianstad.se<http://www.kristianstad.se/>

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Chris Buckmaster
Skickat: den 18 mars 2016 16:34
Till: qgis-user@lists.osgeo.org
Ämne: [Qgis-user] DB Manager geometry problems

Hi

I have several datasets loaded into PostGIS 2.0 with the owner as ‘superuser’ 
that has full permissions. I have then assigned select permissions to some 
other users, but I am not sure if they completely have the access they require 
as the DB Manager doesn’t show the spatial reference, and it says there is no 
entry in geometry_columns (attached are two screenshots which show what I get).

For my superuser connection, the geometry symbol is next to the layer name and 
it has all of the geometry information in the window, but for one of my select 
only users it does not show – do I need to give my select only users permission 
to access other tables in PostGIS? I have noticed that for larger datasets it 
takes quite a bit longer for the datasets to be loaded into PostGIS as well 
which leads me to believe that perhaps they are not accessing the spatial 
indexes or something?

Thanks, Chris

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