Re: [Qgis-user] QGIS - repeated connections

[Alexandre Neto via Qgis-user]

Hello Mauricio,

That is "normal". Several different components of QGIS can establish
different and independent connections to PostgreSQL. For example, the
browser panel can create a connection, the database manager another, and so
on.

Alexandre Neto

A terça, 8/03/2022, 20:14, Mauricio Vieira Cardoso Filho via Qgis-user <
qgis-user@lists.osgeo.org> escreveu:

> I use QGIS 3.16 and I'm having an operation that I believe to be abnormal.
> I use QGIS connected to a postgres database. My problem is that QGIS is
> creating five simultaneous connections for each database user. (For
> example, when opening qgis and connecting to the bank, on my server I have
> five connections created with my username). Does anyone have any idea what
> could be happening?
>
> Best
> Maurício Vieira Cardoso Filho
> Gerente TI Infra
> Tel: +556137995051
> email : mcard...@topocart.com.br;
> skype: mauricio.cardoso1974
> ___
> 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] Model Designer - GDAL - Vector Conversion

[Johanna Botman via Qgis-user]

Hi Brent,
I think that is the way that I have to go. I was hoping that it would be a good 
use of the Modeller

Johanna Botman

Assets / GIS Officer - Melton City Council



From: Brent Wood 
Sent: Wednesday, 9 March 2022 10:50 AM
To: qgis-user@lists.osgeo.org; Johanna Botman 
Subject: Re: Model Designer - GDAL - Vector Conversion

You don't often get email from brent.w...@niwa.co.nz. Learn why this is 
important
Have you considered a script or batch file using ogr2ogr to do this for you?

Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529

From: Qgis-user  on behalf of Johanna Botman 
via Qgis-user 
Sent: Wednesday, March 9, 2022 12:41
To: qgis-user@lists.osgeo.org 
Subject: [Qgis-user] Model Designer - GDAL - Vector Conversion


I am trying to use the Model Designer to automate the creation of Tab files 
from SQL Database Tables.

I am using GDAL - Vector Conversion - Convert format

The resulting Tab file is missing the Primary Key field.

If use that same algorithm to export to a Geopackage, the PK is there.

I know that I can right click the SQL Table and select Export. That Tab file 
contains the PK. I need to export 30 tables so am looking for some automation.



Why does the algorithm produce a table without the key field?







Johanna Botman



Assets / GIS Officer - Melton City Council











***
The information in this message is privileged and confidential, intended only 
for the use of the individual or entity named above. If you are not the 
intended recipient you are hereby notified to delete the message and that any 
dissemination, copying or use of its content is strictly prohibited. If you 
have received this message in error please notify the Melton City Council.
***
[Image removed by 
sender.]
Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
+64-4-386-0529

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: 
niwa.co.nz
 
Facebook
 
LinkedIn
 
Twitter
 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems

Re: [Qgis-user] Model Designer - GDAL - Vector Conversion

[Brent Wood via Qgis-user]

Have you considered a script or batch file using ogr2ogr to do this for you?

Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529

From: Qgis-user  on behalf of Johanna Botman 
via Qgis-user 
Sent: Wednesday, March 9, 2022 12:41
To: qgis-user@lists.osgeo.org 
Subject: [Qgis-user] Model Designer - GDAL - Vector Conversion


I am trying to use the Model Designer to automate the creation of Tab files 
from SQL Database Tables.

I am using GDAL – Vector Conversion – Convert format

The resulting Tab file is missing the Primary Key field.

If use that same algorithm to export to a Geopackage, the PK is there.

I know that I can right click the SQL Table and select Export. That Tab file 
contains the PK. I need to export 30 tables so am looking for some automation.



Why does the algorithm produce a table without the key field?







Johanna Botman



Assets / GIS Officer – Melton City Council











***
The information in this message is privileged and confidential, intended only 
for the use of the individual or entity named above. If you are not the 
intended recipient you are hereby notified to delete the message and that any 
dissemination, copying or use of its content is strictly prohibited. If you 
have received this message in error please notify the Melton City Council.
***

[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
+64-4-386-0529

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems
___
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] Model Designer - GDAL - Vector Conversion

[Johanna Botman via Qgis-user]

I am trying to use the Model Designer to automate the creation of Tab files 
from SQL Database Tables.
I am using GDAL - Vector Conversion - Convert format
The resulting Tab file is missing the Primary Key field.
If use that same algorithm to export to a Geopackage, the PK is there.
I know that I can right click the SQL Table and select Export. That Tab file 
contains the PK. I need to export 30 tables so am looking for some automation.

Why does the algorithm produce a table without the key field?



Johanna Botman

Assets / GIS Officer - Melton City Council






***
The information in this message is privileged and confidential, intended only 
for the use of the individual or entity named above. If you are not the 
intended recipient you are hereby notified to delete the message and that any 
dissemination, copying or use of its content is strictly prohibited. If you 
have received this message in error please notify the Melton City Council.
***
___
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 - repeated connections

[Mauricio Vieira Cardoso Filho via Qgis-user]

I use QGIS 3.16 and I'm having an operation that I believe to be abnormal.
I use QGIS connected to a postgres database. My problem is that QGIS is
creating five simultaneous connections for each database user. (For
example, when opening qgis and connecting to the bank, on my server I have
five connections created with my username). Does anyone have any idea what
could be happening?

Best
Maurício Vieira Cardoso Filho
Gerente TI Infra
Tel: +556137995051
email : mcard...@topocart.com.br;
skype: mauricio.cardoso1974
___
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] QgsLayoutExporter and Raster Layers

[Eric Younkin - NOAA Federal via Qgis-user]

Hello,

I am using the QgsLayoutExporter to build a screenshot of my QgsMapCanvas
view, following the code in the Quick Print plugin (
https://github.com/MarcoDuiker/QGIS_QuickPrint/blob/d1c946a7b6187553c92ffad7a0cc23d39a1bc593/quick_print3.py
).

I build the QgsLayoutItemMap as follows (including only relevant lines):

map = qgis_core.QgsLayoutItemMap(layout)
...
mylayers = self.project.mapThemeCollection().masterVisibleLayers()
map.setLayers(mylayers)
...
layout.addLayoutItem(map)
...
exporter = qgis_core.QgsLayoutExporter(layout)
exporter.exportToImage(fil,
qgis_core.QgsLayoutExporter.ImageExportSettings())

mylayers correctly lists the layers that I have loaded in my application.

[,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

https://a.tile.openstreetmap.org/%7Bz%7D/%7Bx%7D/%7By%7D.png=19=0=EPSG:4326'
(wms)>]


Each of these layers correctly shows in the screenshot, with the exception
of the first one, the vsimem based raster layer. This layer shows in my app
in the canvas, but is missing from the screenshot. I have tried exporting
that layer by itself, messing with renderers and opacity, etc. I can't seem
to get the vsimem raster layer to show in the screenshot. I thought the WMS
raster layer was going to be an issue, but it shows just fine.


Is there any issue with vsimem gdal layers? Should this layer work, if I
can visualize it on the canvas in my app? I can't figure out where to go
next to diagnose this issue.


Thanks, Eric


-- 
Eric Younkin
Physical Scientist
NOAA OCS, Hydrographic Systems and Technology Branch
1315 East-West Highway
N/CS11, Room 6604
Silver Spring, MD 20910
Office: 240-847-8208
Cell: 828-331-8197
___
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] Fwd: Your message to Qgis-user awaits moderator approval

[Richard Duivenvoorde via Qgis-user]

Yep, we are short in moderators :-)

But... I could not find it. Can you resent?

Richard

On 3/8/22 19:04, Cory Albrecht via Qgis-user wrote:


Could a moderator deal with this, please? It's been sitting for a few days. I 
attached some images to explain my problem. Thanks in advance.

-- Forwarded message -
From: mailto:qgis-user-ow...@lists.osgeo.org>>
Date: Sat, Mar 5, 2022 at 5:22 PM
Subject: Your message to Qgis-user awaits moderator approval
To: mailto:m...@hanfastolfe.com>>


Your mail to 'Qgis-user' with the subject

     Dynamic, per-feature control over feature rendering?

Is being held until the list moderator can review it for approval.

The reason it is being held:

     Message body is too big: 682355 bytes with a limit of 100 KB

Either the message will get posted to the list, or you will receive
notification of the moderator's decision.  If you would like to cancel
this posting, please visit the following URL:

https://lists.osgeo.org/mailman/confirm/qgis-user/5755de8ba5d92f917687b0d3ab9a692ce6ab339e
 



___
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] Fwd: Your message to Qgis-user awaits moderator approval

[David Strip via Qgis-user]

  
  
On 3/8/2022 11:04 AM, Cory Albrecht via
  Qgis-user wrote:


  
  
  Could a
moderator deal with this, please? It's been sitting for a few
days. I attached some images to explain my problem. Thanks in
advance.


you could always just upload your images to some hosting service
like imgur or a cloud drive (google drive, OneDrive, etc), then put
links in your email. That avoids the need for the moderator to
intervene,
  

___
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] Fwd: Your message to Qgis-user awaits moderator approval

[Cory Albrecht via Qgis-user]

Could a moderator deal with this, please? It's been sitting for a few days.
I attached some images to explain my problem. Thanks in advance.

-- Forwarded message -
From: 
Date: Sat, Mar 5, 2022 at 5:22 PM
Subject: Your message to Qgis-user awaits moderator approval
To: 


Your mail to 'Qgis-user' with the subject

Dynamic, per-feature control over feature rendering?

Is being held until the list moderator can review it for approval.

The reason it is being held:

Message body is too big: 682355 bytes with a limit of 100 KB

Either the message will get posted to the list, or you will receive
notification of the moderator's decision.  If you would like to cancel
this posting, please visit the following URL:


https://lists.osgeo.org/mailman/confirm/qgis-user/5755de8ba5d92f917687b0d3ab9a692ce6ab339e
___
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] Atlas Map book - Display only one feature on each page.

[krishna Ayyala via Qgis-user]

Stefan,
Those steps helped me accomplish my task. Thanks a lot for your help.

Regards.


On Tue, Mar 8, 2022 at 12:47 AM Stefan Giese (WhereGroup) <
stefan.gi...@wheregroup.com> wrote:

> This is a bit tricky but can be done with rule based renderer:
>
> In my example I have an attibute "name" and with the following rule:
>
> *name=attributes(@atlas_feature)['name']*
>
> you can set the visible features to the atlas feature and then only the
> atlas feature will be displayed in your atlas
>
> Am 08.03.2022 um 04:24 schrieb krishna Ayyala via Qgis-user:
>
> Hello,
> I am reposting this question. Can anyone help me?This is the map on my
> Print composer window. In my attribute table, I have a field called
> Line_ID. There are three lines in this field; LINE 1, LINE 2 AND LINE 3..I
> wish to export this to mapbook. My mapbook will have 3 pages. I wish to
> export such that, each page has only one line. i.e. Page1 should have LINE
> 1, Page2 should have LINE 2 AND Page3 should have LINE 3. What should be
> the setting in my Atlas window to accomplish this task?
> [image: image.png]
> [image: image.png]
>
>>
>>
> ___
> Qgis-user mailing listqgis-u...@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
> --
> Mit freundlichen Grüßen
> Stefan Giese
> Projektleiter/Consultant
> **
> FOSSGIS Konferenz
> 09.-12. März 2022 onlinehttps://www.fossgis-konferenz.de/
> **
> WhereGroup GmbH
> Schwimmbadstr. 2
> 79100 Freiburg
> Germany
>
> Tel.: +49 (0)761 / 519 102 - 61
> Fax: +49 (0)761 / 519 102 - 11
> stefan.gi...@wheregroup.comwww.wheregroup.com
> Geschäftsführer:
> Olaf Knopp, Peter Stamm
> Amtsgericht Bonn, HRB 9885
>
>
___
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