Re: [Qgis-user] Advance Digitising Tools- compass bearings

2024-05-17 Per discussione Alessandro Pasotti via QGIS-User
Hi Philip,

Is this what you are looking for?

https://github.com/qgis/QGIS/pull/53061



On Fri, May 17, 2024 at 3:50 AM Philip Ryan via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hello,
> I am trying to digitise a series of old gold lease "portion plans"
> produced in the 1880s in Australia by a mining surveyor using a compass and
> chain. The data for each gold lease includes a table of  1) compass
> bearings in degrees and 2) distance measurements in links (0.2 m) for each
> vertex of the lease polygon (mostly a rectangle or trapezoid but sometimes
> more complex).
> The Advance Digitizing Tools would seem to be ideal for this data except
> for the angle measure (a) which I can't input as a compass bearing (0-360
> deg). The current settings with 90 deg E as the zero makes conversion of
> compass bearings very tedious.
> Is it possible to change the angle variable (a) to a compass bearing?
> Regards,
> Phil Ryan
> ___
> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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: Parsing WFS capabilites with JavaScript

2023-10-31 Per discussione Alessandro Pasotti via QGIS-User
Why don't try OAPIF (aka WFS 3)? You get JSON directly.

Il lun 30 ott 2023, 15:13 Jakob Miksch via QGIS-User <
qgis-user@lists.osgeo.org> ha scritto:

> Dear QGIS Server people,
>
>
>
> I have a QGIS Server running. I would like to access the WFS Capabilities
> with JavaScript, more specifically I would like to know which WFS layers
> are published by QGIS Server. Unfortunately, QGIS Server only supports WFS
> 1.0.0 and 1.1.0. But the only parser for WFS capabilities I have found only
> support WFS 2.0.0 ( https://github.com/GastonZalba/ol-wfs-capabilities ).
>
>
>
>
> Does anyone have a hint how to parse the WFS Capabilities from QGIS Server
> with JavaScript?
>
> best regards,
> Jakob
>
>
>
>
>
>
> Jakob Miksch
> Consultant
>
> +49 170 9036956
> siticom.online
>
>
>
> siticom GmbH • Werner-von-Siemens-Straße 2-6 • 76646 Bruchsal • Deutschland
> Geschäftsführer: Jürgen Hatzipantelis, Stefan Höltken
> Sitz der Gesellschaft: Weiterstadt • Amtsgericht Darmstadt • HRB 9276
> Umsatzsteuer-ID Nr.: DE 197 925 589
>
>
> ___
> 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 - GetLegendGraphics request confusion

2023-10-17 Per discussione Alessandro Pasotti via QGIS-User
Hi,

QGIS server actually accepts both requests:

else if ( QSTR_COMPARE( req, "GetLegendGraphic" ) || QSTR_COMPARE( req,
"GetLegendGraphics" ) )


On Mon, Oct 16, 2023 at 6:20 PM Jakob Miksch via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hi everyone!
>
>
>
> I have a QGIS Server running. Requesting the legend of a layer works fine
> as explained in the docs: 3.2. Web Map Service (WMS) — QGIS Documentation
> documentation
> <https://docs.qgis.org/3.28/en/docs/server_manual/services/wms.html#getlegendgraphics>
>
> However, I noticed that in QGIS Server the request must be called
> “GetLegendGraphics” with a trailing “s”, whereas GeoServer (GetLegendGraphic
> — GeoServer 2.25.x User Manual
> <https://docs.geoserver.org/latest/en/user/services/wms/get_legend_graphic/index.html>),
> MapServer (WMS Server — MapServer 8.0.1 documentation
> <https://mapserver.org/de/ogc/wms_server.html#getlegendgraphic-request>),
> deegree and OpenLayers (OpenLayers v8.1.0 API - Class: ImageWMS
> <https://openlayers.org/en/latest/apidoc/module-ol_source_ImageWMS-ImageWMS.html#getLegendUrl>)
> expect the request to be called “GetLegendGraphic” WITHOUT the trailing
> “s”.
>
>
>
> Is there a reason why QGIS Server provides legends differently compared to
> other established geospatial software?
>
> Best regards,
>
> Jakob
>
>
>
>
> Jakob Miksch
> Consultant
>
> +49 170 9036956
> siticom.online
>
>
>
> siticom GmbH • Werner-von-Siemens-Straße 2-6 • 76646 Bruchsal • Deutschland
> Geschäftsführer: Jürgen Hatzipantelis, Stefan Höltken
> Sitz der Gesellschaft: Weiterstadt • Amtsgericht Darmstadt • HRB 9276
> Umsatzsteuer-ID Nr.: DE 197 925 589
>
>
> ___
> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Data Privacy

2023-10-12 Per discussione Alessandro Pasotti via QGIS-User
Hi,

no information about your data will be shared with anyone.

Here is the list of network calls that QGIS can make:
https://docs.qgis.org/testing/en/docs/user_manual/appendices/qgis_desktop_network_connections.html

As far as  I know all of them can be disabled by configuration settings.

Kind regards.



On Thu, Oct 12, 2023 at 12:58 PM Toby Clemett via QGIS-User
 wrote:
>
> Good Afternoon,
>
> I have a question regarding Data Privacy:
>
> If a company or organisation decided to open locally stored sensitive 
> location data within Vanilla QGIS, would the information stay on the user's 
> hard drive and not be shared with QGIS or anyone else externally?
>
> Please could you also provide details on QGIS's terms and conditions 
> regarding data protection?
>
> Thanks,
>
> TC
>
>
> ___
> 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



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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: programmatic configuration

2023-07-17 Per discussione Alessandro Pasotti via QGIS-User
On Mon, Jul 17, 2023 at 3:03 PM Jakob Miksch via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hello everyone,
>
>
>
> To my knowledge it is only possible to change a QGIS server project via
> the QGIS desktop GUI. However, I would like to dynamically add or remove
> layers in a QGIS server project.
>
>
>
> Is there or has there been any approach to accomplish this?
>
> My spontaneous idea is to use pyQGIS to edit the QGIS server project
> directly without using the GUI, but maybe other approaches exist. I would
> be grateful for any experiences, ideas or hints.
>
>
>
> Thanks, and best regards,
>
> Jakob
>

Hi,

you can change a project in memory on each request using server plugins:
https://docs.qgis.org/3.28/en/docs/pyqgis_developer_cookbook/server.html,
the project is accessible via QgsProject.instance().

If you want a permanent change to the project you need to rewrite the
project XML on the storage.

Kind regards





>
>
>
> Jakob Miksch
> Consultant
>
> +49 170 9036956
> siticom.online
>
>
>
> siticom GmbH • Werner-von-Siemens-Straße 2-6 • 76646 Bruchsal • Deutschland
> Geschäftsführer: Jürgen Hatzipantelis, Stefan Höltken
> Sitz der Gesellschaft: Weiterstadt • Amtsgericht Darmstadt • HRB 9276
> Umsatzsteuer-ID Nr.: DE 197 925 589
>
>
> ___
> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] WFS - Env variable QGIS_SERVER_API_WFS3_MAX_LIMIT not working

2023-02-14 Per discussione Alessandro Pasotti via QGIS-User
' (PostgreSQL connection strings used
> by the landing page service to find projects): '' (read
>   from DEFAULT_VALUE)
> 10:41:20 INFO Server[90]:   - QGIS_SERVER_LOG_PROFILE /
> '/qgis/server_log_profile' (Add detailed profile information to the logs,
> only effective when QGIS_SERVER_LOG_LEVEL=0): 'false' (read from
> DEFAULT_VALUE)
> 10:41:20 INFO Server[90]:   - QGIS_SERVER_WMTS_SERVICE_URL /
> '/qgis/server_wmts_service_url' (The default WMTS service URL): '' (read
> from DEFAULT_VALUE)
> 10:41:20 INFO Server[90]:   - QGIS_OPTIONS_PATH / '' (): '' (read from
> DEFAULT_VALUE)
> 10:41:20 INFO Server[90]:   - QGIS_OPTIONS_PATH / '' (): '' (read from
> DEFAULT_VALUE)
> 10:41:20 INFO Server[90]:   - QGIS_OPTIONS_PATH / '' (): '' (read from
> DEFAULT_VALUE)
> 10:41:20 INFO Server[90]:   - QGIS_OPTIONS_PATH / '' (): '' (read from
> DEFAULT_VALUE)
> 10:41:20 INFO Server[90]:   - QGIS_SERVER_LANDING_PAGE_PREFIX /
> '/qgis/server_landing_page_base_url_prefix' (Landing page base URL path
> prefix): '' (read from DEFAULT_VALUE)
> 10:41:20 INFO Server[90]:   - QGIS_SERVER_PROJECT_CACHE_CHECK_INTERVAL /
> '/qgis/server_project_cache_check_interval' (The default project cache
> check interval): '0' (read from DEFAULT_VALUE)
>
>
> Thank you and best regards,
> Tommaso
>
> ___
> 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



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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 not installing properly

2023-02-09 Per discussione Alessandro Pasotti via QGIS-User
Garth,

thank you for the valuable explanation.

I am wondering if we (the QGS community) should put this information
somewhere to make it easily findable. We are currently in the process
of redesigning the QGIS website (which includes links to the downloads
for various operating systems).

Jessica,

how was your way to find a solution for your installation problem?
Where did you start your research?

Kind regards.


On Thu, Feb 9, 2023 at 10:07 PM Garth Fletcher via QGIS-User
 wrote:
>
> jessica swan wrote:
> > I am wanting to use QGIS for a project,
> > but it will not open on my laptop because "this device cannot scan QGIS for
> > malware". I have a MacBook Air from 2016 - its software should be updated
> > enough to run the QGIS system, but it seems that something is wrong. Could
> > I please get some assistance on the issue?
>
> A good problem report should include the OS X version you are using.
> I'm guessing that on a 2016 Mac you may be using OS X 10.13 (High Sierra) or 
> possibly 10.14 or 10.15.
>
> By default these, and later versions such as OS X 11, refuse to run programs 
> that are not "officially signed", UNLESS you give them permission to do so.
>
> You only have to give permission once (for a given app); there are 2 ways:
> 1) control-click on the application and select Open, or
> 2) right after having plain clicked and gotten the refusal, go to
>   Apple > System Preferences > Security & Privacy
> where you may see a message about the rejection and an offer to authorize 
> the rejected app
>
> I always use #1.  As I say, you only have to do it once.  Thereafter single 
> clicking on the app, or one of its files, will start up QGIS.
>
> By the way, while in Security & Privacy / General you will see:
>Allow apps downloaded from:
>  ( ) App Store
>  (o) App Store and indentified developers
> That is usually set for the 2nd choice, but might have been changed to the 
> first
> Neither setting allows UNsigned apps, unless you give permission as outlined 
> above for each UNsigned app you want to run.
>
> QGIS runs beautifully on Macs.  I'm using a 2011 Mac mini with OS X 10.13 for 
> making maps with many hundreds of layers and many many GB of rasters, 
> including LIDAR based DEMs with 1.5 foot resolution and orthophotography with 
> 0.5 foot resolution.
>
> Cordially,
>
> --
> Garth Fletcher
>
> ___
> 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



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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: how to log database queries

2023-02-03 Per discussione Alessandro Pasotti via QGIS-User
No, there is no (easy) way to log the SQL in QGIS server.

You may try with a server plugin that uses the new debugging panel
query logger but I'm not sure if that will work (I didn't try).

Kind regards.


On Fri, Feb 3, 2023 at 5:38 PM Tommaso via QGIS-User
 wrote:
>
> Hello,
> my WFS service - based on docker-qgis-server/  3.28.0 (the camptocamp image) 
> -  is not returning all features I expect, when I use a spatial query.
> To debug the problem, I would like to see the queries, which Qgis send to the 
> database. But it seems that the maximal log level is INFO, which logs only 
> the HTTP requests:
>
> QGIS_SERVER_LOG_LEVEL=0
>
> https://docs.qgis.org/2.18/en/docs/user_manual/working_with_ogc/server/config.html#logging
>
>
> There is way to see database queries? Unfortunately I don't have access to 
> the machine, where the database is running, so I cannot check the queries on 
> that machine.
>
> Best regards, Tommaso
>
> --
> ___
> 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



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] PostGIS raster layer filtered by attribute

2022-11-09 Per discussione Alessandro Pasotti via Qgis-user
Please CC @elpaso when you file the bug, I'll assign it to me.

On Tue, Nov 8, 2022 at 8:36 PM Thayer Young  wrote:
>
> Hi Dirk,
>
> I have not seen a bug report for this yet. Would you like me to issue one?
>
> I was able to reproduce that the provider for views of raster tables did work 
> in 3.10 but stopped working by 3.14.
>
> -Thayer
>
>
>
> On Friday, November 4, 2022 at 08:06:48 AM EDT, Alessandro Pasotti 
>  wrote:
>
>
> On Fri, Nov 4, 2022 at 12:18 PM  wrote:
> >
> > Thanks to Thayer and Alesandro.
> > I made a lot of tests today. Not all is working, but it's on a good way.
> >
> > I did not see the "Filter" option on the raster layer in QGIS 3.22 because 
> > I searched in the layer properties analog to where the filter is placed for 
> > vector layers.
> > The filter option works in general but throws a lot of critical errors, 
> > when no raster is in  the result of the filter query.
> >
> > Another solution I tried is to use a view where the raster table is 
> > filtered.
> > This works in QGIS 3.10 but not in 3.22, where QGIS generates an invalid 
> > query against the PostgreSQL catalog when adding the raster layer.
> >
>
> Sounds like a bug to me.
>
> Can you file a ticket with all the necessary information and a minimal
> SQL dump to reproduce the issue?
>
>
>
> --
> Alessandro Pasotti
> QCooperative:  www.qcooperative.net
> ItOpen:  www.itopen.it



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] PostGIS raster layer filtered by attribute

2022-11-04 Per discussione Alessandro Pasotti via Qgis-user
On Fri, Nov 4, 2022 at 12:18 PM  wrote:
>
> Thanks to Thayer and Alesandro.
> I made a lot of tests today. Not all is working, but it's on a good way.
>
> I did not see the "Filter" option on the raster layer in QGIS 3.22 because I 
> searched in the layer properties analog to where the filter is placed for 
> vector layers.
> The filter option works in general but throws a lot of critical errors, when 
> no raster is in  the result of the filter query.
>
> Another solution I tried is to use a view where the raster table is filtered.
> This works in QGIS 3.10 but not in 3.22, where QGIS generates an invalid 
> query against the PostgreSQL catalog when adding the raster layer.
>

Sounds like a bug to me.

Can you file a ticket with all the necessary information and a minimal
SQL dump to reproduce the issue?


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] PostGIS raster layer filtered by attribute

2022-11-03 Per discussione Alessandro Pasotti via Qgis-user
Right click on the raster in the legend and choose "Filter..."


On Thu, Nov 3, 2022 at 2:58 PM Thayer Young via Qgis-user
 wrote:
>
> Hi Dirk,
>
> I have looked into this and found no easy solution. As you have noticed there 
> is no "Provider Feature Filter" in the Source tab of the layer properties for 
> a raster layer. The next obvious path would be to write a SELECT statement in 
> an SQL Window in the Database Manager and "Load as New Layer", but this is 
> only set up for geometry columns, not raster. Next is to create a view or a 
> materialized view with the associated indexes in the database and try adding 
> that to QGIS using the four methods for adding layers. All of these result in 
> the same PostGIS errors, that a primary key can not be found for the raster 
> table, that the raster layer is invalid and that the "Data type size for band 
> 1 could not be found: num bands is: 0 and the type size map for bands 
> contains: 0 item(s)".
>
> I have searched the QGIS issues page on Github and not found anything beyond 
> the basic functionality of adding PostGIS rasters. I believe that if you are 
> interested in this functionality you should file a feature request on the 
> qgis/QGIS issues page on Github.
>
> This is what I found, note that all of the issues are closed:
> https://github.com/qgis/QGIS/issues?q=is%3Aissue+postgresraster+
>
> -Thayer
>
>
>
> > Date: Wed, 2 Nov 2022 12:08:08 +
> > From: 
> > To: 
> > Subject: [Qgis-user] PostGIS raster layer filtered by attribute
> > Message-ID: <8766215b88b84d3ba770e6c0a7979...@stadt-koeln.de>
> >Content-Type: text/plain; charset="us-ascii"
> >
> >Hi list,
> >
> > I import TIFF-files into a PostgreSQL/PostGIS table with FME. In addition 
> > to the raster column my table has some more columns.
> > Is it possible to filter the raster layer based on my table by these 
> > additional columns?
> > It seems that QGIS (up to 3.28) doesn't handle addional columns in raster 
> > layers, but maybe someone knows a trick to do so.
> > Thanks and regards
> >
> > Dirk
>
> ___
> 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



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] SQL Logging in the debugging/development panel - SpatiaLite

2022-10-11 Per discussione Alessandro Pasotti via Qgis-user
Hi,

Johannes, can you please file a bug report?

On Tue, Oct 11, 2022 at 4:30 PM Johannes Echterhoff via Qgis-user
 wrote:
>
> Hello,
>
>
>
> Today I tried the SQL logging in the debugging/development panel (a feature 
> introduced through QEP 
> https://github.com/qgis/QGIS-Enhancement-Proposals/issues/242). The database 
> I’m using is a SpatiaLite one. My QGIS version is 3.26.3.
>
>
>
> Should the SQL logging in this case also cover addition of features? 
> Reviewing the statement log produced while adding a feature, I could not find 
> any INSERT statement, just a whole range of SELECT statements and two save 
> point related messages. When I add a feature into a PostgreSQL-based layer 
> instead, the log does contain an INSERT statement.
>
>
>
> The reason I am asking this question is that I am trying to find a way to 
> debug editing features in a SpatiaLite-based layer. We have had the behavior 
> that upon saving a new feature, it completely vanished, without any error 
> message in QGIS – so I’d like to understand which commands were sent to the 
> SQLite database.
>
>
>
> Best regards,
>
> Johannes
>
> ___
> 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



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] PR review needed

2022-09-28 Per discussione Alessandro Pasotti via Qgis-user
Yes, I know pip install is quite a barrier, I've been using this plugin for
years and never used the standard console again.

I guess this is more a personal project than a plugin for a wider audience.

I'm glad that you've found it useful.

Regards.


On Wed, Sep 28, 2022 at 8:59 AM Johannes Kröger (WhereGroup) <
johannes.kroe...@wheregroup.com> wrote:

> Thank you! I had that in my tabs to try out and did so yesterday. It is
> impressive but of course requires the user to manually install some
> packages (which is a HUGE blocker for 99% of users) and is missing
> integration in the script editor. I will probably still use it for myself
> though so thank you very much!
> Am 27.09.22 um 16:43 schrieb Alessandro Pasotti:
>
>
> You may want to check this out (Works For Me (TM)):
> https://plugins.qgis.org/plugins/IPyConsole/  autocompletion and other
> IPython features works just fine.
>
>
>
> On Tue, Sep 27, 2022 at 4:37 PM Johannes Kröger (WhereGroup) via Qgis-user
>  wrote:
>
>> > jedi autocompletion
>>
>> I can't say just how awesome it would be to have some "proper"
>> autocompletion in the console and editor. One that knows about the actual
>> object it is used on instead of suggesting random text string matches from
>> anywhere in its database.
>>
>> Honestly, this would make learning and teaching Python and the PyQGIS API
>> infinitely easier and fun.
>>
>> Seeing the GIFs on https://yoannqdq.github.io/qgis-better-editor/ makes
>> me jealous of the people who used your plugin when it was working in the
>> older versions. Wow!
>>
>> Cheers, Hannes
>> Am 27.09.22 um 14:48 schrieb Yoann QUENACH DE QUIVILLIC via Qgis-user:
>>
>> Hi everyone,
>>
>> Some 2 years ago, I was frustrated with some of the features of the
>> embedded python console, so I developed a plugin called Better Editor (
>> https://plugins.qgis.org/plugins/bettereditor) which offered smart
>> brackets / parenthesis, better toggle comment action, code formatting with
>> black, jedi autocompletion...
>>
>> I was quite happy with it, but unfortunately, this plugin was heavily
>> reliant on monkey patching existing classes, so it broke very often across
>> QGIS versions.
>>
>> I'm now trying to backport some of the features I developed in the plugin
>> in QGIS, starting (small) with the toggle comment action.
>>
>> I'd be really thankful if a QGIS maintainer could take the time to review
>> my PR:
>>
>> https://github.com/qgis/QGIS/pull/50341
>>
>> Regards,
>>
>> *--*
>> *Yoann Quenach de Quivllic*
>>
>>
>> ___
>> 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
>>
>
>
> --
> Alessandro Pasotti
> QCooperative:  www.qcooperative.net
> ItOpen:   www.itopen.it
>
> --
> Johannes Kröger / GIS-Entwickler/-Berater
>
> -
> Schon gewusst?
> In unserem Blog geben wir Tipps & Tricks zu Open-Source-GIS-Software
> und berichten aus unserem Experten-Alltag:https://wheregroup.com/blog/
> -
>
> WhereGroup GmbH
> Grevenweg 89
> 20537 Hamburg
> Germany
>
> Tel: +49 (0)228 / 90 90 38 - 36
> Fax: +49 (0)228 / 90 90 38 - 11
> johannes.kroe...@wheregroup.comwww.wheregroup.com
> Geschäftsführer:
> Olaf Knopp, Peter Stamm
> Amtsgericht Bonn, HRB 9885
> ---
>
>

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] PR review needed

2022-09-27 Per discussione Alessandro Pasotti via Qgis-user
You may want to check this out (Works For Me (TM)):
https://plugins.qgis.org/plugins/IPyConsole/  autocompletion and other
IPython features works just fine.



On Tue, Sep 27, 2022 at 4:37 PM Johannes Kröger (WhereGroup) via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> > jedi autocompletion
>
> I can't say just how awesome it would be to have some "proper"
> autocompletion in the console and editor. One that knows about the actual
> object it is used on instead of suggesting random text string matches from
> anywhere in its database.
>
> Honestly, this would make learning and teaching Python and the PyQGIS API
> infinitely easier and fun.
>
> Seeing the GIFs on https://yoannqdq.github.io/qgis-better-editor/ makes
> me jealous of the people who used your plugin when it was working in the
> older versions. Wow!
>
> Cheers, Hannes
> Am 27.09.22 um 14:48 schrieb Yoann QUENACH DE QUIVILLIC via Qgis-user:
>
> Hi everyone,
>
> Some 2 years ago, I was frustrated with some of the features of the
> embedded python console, so I developed a plugin called Better Editor (
> https://plugins.qgis.org/plugins/bettereditor) which offered smart
> brackets / parenthesis, better toggle comment action, code formatting with
> black, jedi autocompletion...
>
> I was quite happy with it, but unfortunately, this plugin was heavily
> reliant on monkey patching existing classes, so it broke very often across
> QGIS versions.
>
> I'm now trying to backport some of the features I developed in the plugin
> in QGIS, starting (small) with the toggle comment action.
>
> I'd be really thankful if a QGIS maintainer could take the time to review
> my PR:
>
> https://github.com/qgis/QGIS/pull/50341
>
> Regards,
>
> *--*
> *Yoann Quenach de Quivllic*
>
>
> ___
> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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: missing tags in GetFeatureInfo-Response

2022-09-16 Per discussione Alessandro Pasotti via Qgis-user
On Fri, Sep 16, 2022 at 3:13 PM Inka Tauber via Qgis-user
 wrote:
>
> Hello,
>
> QGIS Server GFI HTML response starts and ends with the HEAD tag. Some parts, 
> that are necessary to form a complete  HTML (DOCTYPE, HTML tag) are missing.  
> This may be useful, if the receiving application already creates the outer 
> HTML frame. But sometimes complete HTML or XML responses are needed. Is there 
> perhaps an configuration option to switch between full and only the inner 
> parts of GFI HTML and XML documents? Or is writing a plugin (similar to the 
> one described in 
> https://www.itopen.it/qgis-server-getfeatureinfo-with-style/) the only option?
>

That's the only option at the moment.

A PR to make it template-based is under development:
https://github.com/qgis/QGIS/issues/49851#issuecomment-1229899652




--
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Using QGIS Server python API from system's default Python

2022-09-09 Per discussione Alessandro Pasotti via Qgis-user
Probably not the answer you are looking for but I strongly recommend
you to use Linux for development and deployment (a virtual machine
will work just fine): it will make your developer life much easier.

We (https://github.com/g3w-suite/g3w-admin) have a Django-based
application with QGIS API embedded, it works very well and I can
recommend that approach.

Kind regards.



On Fri, Sep 9, 2022 at 5:13 AM MA via Qgis-user
 wrote:
>
> Hello,
>
> I'm starting to investigate and decide how to manage QGIS server access
> from within a Django project.
>
> The EMBEDDING option looks amazing for this I think but I'm having
> issues (as expected). Tried to make symlinks of python QGIS from OSGEO4W
> to my default /site-packages/ dir and it seems to work, except the PyQt
> part. Tried installing PyQt to same version Qgis uses (using the output
> version mismatch from error messages), but still not, can't start the
> server.
>
> There are common workarounds people uses to circumvent this?
>
> In my case if the option is to move all the framework to inside OSGEO4W
> python then my option will be trying  other approaches like creating
> python plugins for the scheme I need.
>
> So I'm hoping using it the way I described initially is feasible/possible.
>
> Thanks!
>
> Rodrigo
>
>
> ___
> 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



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Two different raster calculators in QGIS and negative value handling - any explanation?

2022-09-08 Per discussione Alessandro Pasotti via Qgis-user
On Wed, Sep 7, 2022 at 11:43 AM Michael Dufty via Qgis-user
 wrote:
>
> It appears that there are two different native raster calculator tools in QGIS
>
> One is found in at the top of the raster menu
>
> The other is in the processing toolbox in the raster analysis group
>

Yeah, we know it's a mess.

Both are based on the same QGIS core implementations, they just use a
different GUI but they must give the same results.

>
>
> (Not to mention the GDAL raster calculator and SAGA raster calculator)
>

This one is based on GDAL instead and it may give different results.

>
>
> Can anyone explain the reason for there being two, and what the differences 
> are?
>
> I’ve been very confused by it, mainly because the one in the raster menu does 
> not appear to handle negative values correctly.  I’d been wondering why NDVI 
> type expressions with negatives randomly worked or not, and discovered it 
> just depended on which raster calculator I used.
>
> Is it expected that the one in the raster menu doesn’t handle negative values 
> correctly?  It looks like it might do calculations based on unsigned integers 
> regardless of the input and output raster formats.
>

You could file a bug report attaching a small dataset to reproduce the
issue and if you are using OpenCL acceleration (see global QGIS
settings).


Kind regards.


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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 and Active Directory

2022-08-30 Per discussione Alessandro Pasotti via Qgis-user
Hi,

not out of the box, but you might be able to develop a Python server
plugin to implement custom authorization/authentication for the
server.

A few examples are available here:
https://github.com/elpaso/qgis3-server-vagrant/tree/master/resources/web/plugins

see httpbasic for example.


On Tue, Aug 30, 2022 at 11:39 AM Christoph Jung via Qgis-user
 wrote:
>
> Hello everyone,
>
> Does anybody have experience with the authorisation of web services published 
> by the QGIS Server, especially using AD users/groups? Is it possible to 
> create services that are usable without further action for some authorised 
> users and all other users cannot consume this services?
>
> Kind 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



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Troubles with Join of two layers

2022-03-16 Per discussione Alessandro Pasotti via Qgis-user
Just guessing, maybe it doesn't like a table name that starts with a digit.

On Wed, Mar 16, 2022 at 9:20 AM Roland Spielhofer via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hi,
> I am trying to join two layers using the DB Manager.
> One layer is a shape file, one is a pure attribute table without geometry.
> I have two fields that are identical in both layers, which should be used
> for the join.
>
> The SQL statement goes like this:
>
> SELECT *
> FROM 210914_Joined_Ebenheit as a,
> 20210914_sqlbatch_20220315_161846_erfassungsdaten as b
>  WHERE
> a.Filename = b.Filename AND
> b.frameNr = b.Frame;
>
> What I get is the following error message:
>
> Query execution error on CREATE TEMP VIEW _tview AS SELECT *  FROM
> 210914_Joined_Ebenheit as a,
> 20210914_sqlbatch_20220315_161846_erfassungsdaten as b  WHERE a.Filename =
> b.Filename AND b.frameNr = b.Frame: 1 - unrecognized token:
> "210914_Joined_Ebenheit"
>
> I don't get the meaning of "unrecognized token" - What I am doing wrong?
> I have "Load as new layer" ticked on - I want a new layer.
>
> Any help appreciated!
>
> Regards,
> Roland
> ___
> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Hello, new to QGIS

2022-03-09 Per discussione Alessandro Pasotti via Qgis-user
Hi,

you have several options: you can store the QGIS project on a remote
postgres DB and provided that the layer's data is also stored in a remote
accessible DB you should be ready to go.

If the data are stored on disk, you'll have to transfer them to the server
in order to have them accessible on the server.

Of course if you have other filesystem-based assets used by your project
(icons, svgs etc.) you need to transfer them as well, keeping paths
relative to the project path will make everything easier in that regard.

If you don't want/can store the project in the remote postgres DB you can
transfer the project and all other filesystem-based assets to the server.


Kind regards




On Wed, Mar 9, 2022 at 8:02 PM Ben Siewert via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hello,
>
> I'm new to QGIS. I'm a web developer and helping a friend with a QGIS
> project.
>
> I'm wondering how I can sync a local QGIS desktop project with a QGIS
> server.
>
> One thing I'm really confused about is on the QGIS server documentation, I
> need the url to point to a file (world.qgs in the docs, link here
> <https://docs.qgis.org/3.16/en/docs/server_manual/getting_started.html#serve-a-project>
> ).
>
> So my question is:
>
> In order to sync project changes from the Desktop app to the server, do I
> need to only connect to the remote Postgres database? Or do I also need to
> upload this file and point the url to it?
>
> Or is it possible to only have to sync the database?
>
> Thanks a ton in advance, and I'm pretty impressed with this project!
>
> Ben
> ___
> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] automate connection to a PostGIS db for QGIS

2022-01-07 Per discussione Alessandro Pasotti
Hi,

you have a few options:

1. a shared global settings ini file with your pre-configured connections
https://docs.qgis.org/3.16/en/docs/user_manual/introduction/qgis_configuration.html#deploying-qgis-within-an-organization
2. a shared python init script
https://docs.qgis.org/3.16/en/docs/user_manual/introduction/qgis_configuration.html#code
, then you can write python code to initialize the connections or anything
else.

Kind regards.


On Fri, Jan 7, 2022 at 1:52 AM tim dunlevie  wrote:

> Hi guys,
>
> About to host a PostGIS db on our server, and want users to connect to the
> db in QGIS.
> Is there a way I can push out a script (?) to all user's machines that
> sets the connection to the postgis db for QGIS?
> Rather than manually entering authentication on each machine?
> I have one generic role for users as they will be read-only users.
>
> thanks,
> Tim
> ___
> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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 minimal qgs project file?

2021-12-13 Per discussione Alessandro Pasotti
Hi,

I'm afraid there is no such information anywhere.

We have done some optimization a few months ago that allow to skip the
parsing of some parts that are not relevant to the server when loading a
project, see:

https://github.com/qgis/QGIS/pull/40418
https://github.com/qgis/QGIS/pull/40360

Kind regards


On Mon, Dec 13, 2021 at 8:31 AM U.Archi  wrote:

> Hi list!
>
> I want to dynamically create qgs xml project files for qgis server.
> Creating a template from a qgis desktop project works fine, but the qgs
> xml is quite large with what seems to me a lot of settings related to
> qgis desktop.
>
> I checked the qgis-server docs, but I can't find any hints what can be
> discarded for serving projects from qgis-server.
>
> Any ideas where to look?
>
> Thanks!
> Urs
> ___
> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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 project templates and PostGIS connections

2021-11-22 Per discussione Alessandro Pasotti
Hi Frank,

you can safely use a custom authentication ID for the connection (choose
something easy to type), then instruct your users to create an
authentication configuration with the same ID but with their own
credentials.

This could be automated at the company level with a custom python init
script, you can even place that on a network folder for easy access from
sys admins.

There used to be some examples around back from Boundless times, probably a
little old but you can get the idea.

https://boundless-desktop.readthedocs.io/en/latest/system_admins/init_scripts.html#add-an-authentication-configuration

Hope this helps.


On Mon, Nov 22, 2021 at 8:42 PM Frank Broniewski 
wrote:

> Hi fellow QGIS user!
>
> I am scratching my head on the following problem. I want to create a
> QGIS project template which has PostGIS layers in it. I want to be able
> to pass this template to other users who might use them for different
> tasks.
>
> The problem now is the connection string to the PostGIS database. When
> using the authentication manager each PostGIS connection gets its own ID
> which in turn is then referenced in the connection string to the layer.
> But now this ID to the PostGIS connection is different for each user, so
> the stored connection string in the template is not valid anymore. And
> each user has his own credentials for logging into PostGIS as well.
>
> I see that I can give a custom ID to a connection in the authentication
> manager, but it is locked by default, so I am hesitant to unlock it. But
> is this a viable option? Create the PostGIS connection under the same ID
> for each user?
>
> There's also the PostgreSQL connection service file [1] which might be
> an option? Does anyone have some experience to share, especially when
> talking Windows PC?
>
> How do you manage PostGIS connections for "simple" users on a somewhat
> larger scale? I am talking about 20 users, just enough to be annoying
> enough for manual deployment ...
>
> Many thanks for any tips,
>
> Frank
>
>
> [1] https://www.postgresql.org/docs/12/libpq-pgservice.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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Crashing with snapping and WFS !?

2021-10-22 Per discussione Alessandro Pasotti
Hi,

this really sounds like a bug, can you file a ticket if there isn't one
already?

On Fri, Oct 22, 2021 at 4:16 AM Michael Dufty <
mdu...@mbsenvironmental.com.au> wrote:

> I'm not sure if its related, but I often have issues with snapping and
> arcgis rest layers.  The problem is if snapping is enabled QGIS will index
> the entire layer.  If it happens to be a national dataset - the sort of
> thing web layers are great for, this can take an hour or so, with QGIS
> unresponsive for the whole time often it won't actually crash if you are
> patient enough, but better to force quit if you have saved.  Often I don't
> even want to snap to that layer, just accidentally had snap to all layers
> enabled, and once you realise it is happening it is too late to save the
> setting.  Even worse the settings only seem to be available when snap is
> enabled, so to fix it, you need to hide the layer, turn snap on, change the
> settings, then turn the layers back on.
>
> Michael Dufty
> -Original Message-
> From: Qgis-user  On Behalf Of Lars I.
> Nielsen
> Sent: Wednesday, 20 October 2021 7:29 PM
> To: Julien Cabieces 
> Cc: qgis-user@lists.osgeo.org
> Subject: Re: [Qgis-user] Crashing with snapping and WFS !?
>
> Thanks Julien.
>
> It's on Windows. It's at a customer, so I'm not entirely sure what
> version, except that it's Windows 10.
>
> I did a bug report on it: # 45589.
>
> Cheers
> Lars
>
> -Oprindelig meddelelse-
> Fra: Julien Cabieces [mailto:julien.cabie...@oslandia.com]
> Sendt: 18. oktober 2021 09:15
> Til: Lars I. Nielsen
> Cc: qgis-user@lists.osgeo.org
> Emne: Re: [Qgis-user] Crashing with snapping and WFS !?
>
>
> Hi,
>
>
> Could you please open an issue here https://github.com/qgis/QGIS/issues
> ?
>
> Does it happen on Linux or Windows ?
>
> Do you manage to reproduce the issue every time or it happen randomly?
>
> Kind regards,
> Julien
>
> > Hi list.
> >
> >
> >
> > We’re running a dataset via WFS (Geoserver 2.16) into QGIS.
> >
> > The user has snap turned on while digitizing/editing, and too often this
> combo results in QGIS crashing.
> >
> >
> >
> > However, this crash does not happen when digitizing/editing, but during
> other operations like panning the map or something similar.
> >
> >
> >
> > The stack dump mentions “snapPoint”, “snapToMap”, “nearestVertex”, and
> “closestVertex”, which to me implies the snapping function in action.
> >
> > It also mentions “canvasMoveEvent”, which to me implies a panning
> operation.
> >
> >
> >
> > I expect the snapping operation to be entirely local, i.e. independent
> of actual data source type, but this apparently only happens when using a
> WFS data source.
> >
> >
> >
> > Can anyone shed some light on this unexpected behavior ? Is it a bug ?
> >
> >
> >
> > Here’s the crash dialog box:
> >
> > *
> >
> >
> >
> > QGIS is version 3.16.10, as the stack dump shows.
> >
> >
> >
> >
> >
> > Med venlig hilsen
> >
> > Lars I. Nielsen
> > GIS-kons., FME+Python Certified Professional
> > GeoData
> >
> >
> >
> > *
> >  Dir. +4563136849
> >  Tlf.  +4563136800
> >  Mail  +l...@lifa.dk
> > *
> >
> >
> >
> > LIFA A/S · Tlf +4563136800 · lifa.dk · CVRI20937289
> >
> > Odense · København · Fredericia · Vejle · Kolding · Aarhus · Middelfart
> · Vissenbjerg · Kerteminde
> >
> > * Følg os på LinkedIn og læs de seneste nyheder fra LIFA A/S
> > *
>
> ___
> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Front page and download page

2021-10-18 Per discussione Alessandro Pasotti
On Sun, Oct 17, 2021 at 1:49 AM  wrote:

> Every time I update QGIS I feel that the front page and the download page
> of the website (in English) needs a bit of tweaking to guide the
> non-technical into making informed choices.
>
>
>
> The distinction between LTR and current release needs to be explained
> better and I have really have no idea about what QGIS in OSGeo4W
> (recommended for regular users) is/does. I don’t think it is clearly
> expressed.
>
>
>
> I am happy to help in suggesting change but I am not sure how the process
> works.
>
>
>
> Cheers
>
>
>
Hi,

you can start by making a pull request (PR) with your proposed changes
here:
https://github.com/qgis/QGIS-Website/blob/master/source/site/forusers/alldownloads.rst

Thanks!

Kind regards.


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Configuring QGIS server on Ubuntu 20.4

2021-10-01 Per discussione Alessandro Pasotti
On Fri, Oct 1, 2021 at 9:46 AM Mats Elfström 
wrote:

> Hi Alessandro!
>

Please keep the conversation on the user list so that others can benefit
from it or jump in and give some advice.


> I'd be glad to help. Just to make sure, which of these three docs is valid?
> You linked to the first, but I used the second, since I am on QGIS 3.20.
>
>
> https://docs.qgis.org/3.16/en/docs/server_manual/getting_started.html#installation-on-debian-based-systems
>
>
They all probably have the same content.

These are probably best suit for 3.20 even if they (theoretically) might
contain features that are not yet available for 3.20 :

https://docs.qgis.org/testing/en/docs/server_manual/getting_started.html#installation-on-debian-based-systems
>
> https://docs.qgis.org/testing/pdf/en/QGIS-testing-ServerUserGuide-en.pdf
>


> I have tried Docker, but my cloud computing provider did not support that
> kind of containerization. Tomcat works fine, though. Would it be possible
> to build a QGIS server *.war file?
>

No, AFAIK war is for java applications.

Best regards.



> I'll be back.
>
> Mats.E
>
> Den tors 30 sep. 2021 kl 21:25 skrev Alessandro Pasotti <
> apaso...@gmail.com>:
>
>>
>> Hi, I'm sorry to hear that: we have even recently spent a considerable
>> amount of time (and money, because it was financed with a grant) to rewrite
>> the QGIS Server documentation with detailed information about deployment
>> [1], we have clearly missed the goal if you couldn't find what you needed
>> in these pages.
>>
>> It would be useful to know what exactly were your problems and what did
>> you try to do.
>>
>> A common problem with server deployments is that there are multiple ways
>> of doing things, it really depends on what you need, for example we are now
>> commonly using docker containers (there are many out there that provide a
>> QGIS Server working installation almost without the need to manually
>> configure anything).
>>
>> Also, I tend to use nginx, but apache is totally fine too.
>>
>> [1]
>> https://docs.qgis.org/3.16/en/docs/server_manual/getting_started.html#installation-on-debian-based-systems
>>
>>
>> On Thu, Sep 30, 2021 at 8:24 PM Mats Elfström 
>> wrote:
>>
>>> Hi!
>>> I am setting up a Geodata stack. I have installed PostgreSQL/Postgis and
>>> Geoserver under Tomcat9 and FME:d a lot of data to PostGIS. All is up and
>>> running.
>>> Then I installed QGIS 3.20. No problems so far. Then I decided to try
>>> QGIS server as an alternative to Geoserver. But I am having trouble
>>> configuring QGIS server, or Apache2 rather.
>>> Over the past 5-6 years, I have spent more time and energy than I care
>>> to mention trying to make QGIS server run on Windows servers. Asking for
>>> advice on those occasions, I have more than once got the advice to use
>>> Linux instead, since no QGIS developers really know Windows servers. And
>>> Linux would be much easier.
>>> Fair enough. So now I am on Ubuntu, sudoing this and that and it works
>>> pretty well.
>>> Apart from QGIS server. I find the same mess of incomplete or
>>> contradictory instructions. No wonder QGIS server is under-used.
>>> If Linux(Ubuntu) is so simple, how come no one has put together a
>>> working script to configure and deploy QGIS server on a standard setup?
>>> I am most disappointed, having spent yet 5 hrs that I will never get
>>> back on QGIS server.
>>>
>>> Regards, Mats.E
>>>
>>> --
>>>
>>>
>>> *GisKraft*, Geodatakonsult
>>>
>>> Mats Elfström, Marsvinsholms stationsväg 80, 271 93 Ystad, Sweden
>>> tel: +46 70 595 39 35 / www.giskraft.se
>>> _______
>>> 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
>>>
>>
>>
>> --
>> Alessandro Pasotti
>> QCooperative:  www.qcooperative.net
>> ItOpen:   www.itopen.it
>>
>
>
> --
>
>
> *GisKraft*, Geodatakonsult
>
> Mats Elfström, Marsvinsholms stationsväg 80, 271 93 Ystad, Sweden
> tel: +46 70 595 39 35 / www.giskraft.se
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Configuring QGIS server on Ubuntu 20.4

2021-09-30 Per discussione Alessandro Pasotti
Hi, I'm sorry to hear that: we have even recently spent a considerable
amount of time (and money, because it was financed with a grant) to rewrite
the QGIS Server documentation with detailed information about deployment
[1], we have clearly missed the goal if you couldn't find what you needed
in these pages.

It would be useful to know what exactly were your problems and what did you
try to do.

A common problem with server deployments is that there are multiple ways of
doing things, it really depends on what you need, for example we are now
commonly using docker containers (there are many out there that provide a
QGIS Server working installation almost without the need to manually
configure anything).

Also, I tend to use nginx, but apache is totally fine too.

[1]
https://docs.qgis.org/3.16/en/docs/server_manual/getting_started.html#installation-on-debian-based-systems


On Thu, Sep 30, 2021 at 8:24 PM Mats Elfström 
wrote:

> Hi!
> I am setting up a Geodata stack. I have installed PostgreSQL/Postgis and
> Geoserver under Tomcat9 and FME:d a lot of data to PostGIS. All is up and
> running.
> Then I installed QGIS 3.20. No problems so far. Then I decided to try QGIS
> server as an alternative to Geoserver. But I am having trouble configuring
> QGIS server, or Apache2 rather.
> Over the past 5-6 years, I have spent more time and energy than I care to
> mention trying to make QGIS server run on Windows servers. Asking for
> advice on those occasions, I have more than once got the advice to use
> Linux instead, since no QGIS developers really know Windows servers. And
> Linux would be much easier.
> Fair enough. So now I am on Ubuntu, sudoing this and that and it works
> pretty well.
> Apart from QGIS server. I find the same mess of incomplete or
> contradictory instructions. No wonder QGIS server is under-used.
> If Linux(Ubuntu) is so simple, how come no one has put together a working
> script to configure and deploy QGIS server on a standard setup?
> I am most disappointed, having spent yet 5 hrs that I will never get back
> on QGIS server.
>
> Regards, Mats.E
>
> --
>
>
> *GisKraft*, Geodatakonsult
>
> Mats Elfström, Marsvinsholms stationsväg 80, 271 93 Ystad, Sweden
> tel: +46 70 595 39 35 / www.giskraft.se
> ___
> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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, Lizmap / OpenLayer, QGIS2Web

2021-06-30 Per discussione Alessandro Pasotti
On Wed, Jun 30, 2021 at 4:11 PM Gerald Kogler  wrote:

> Hi,
>
> qgis2web exports a static version of your QGIS project to web using
> OpenLayers or Leaflet as webmap technologies. It gives you some options
> on export, furthermore you could take the exported code and customize it
> furthermore. It produces pure HTML+JS+CSS so you could host it on any
> server.
>
> One limitation is that all your data is exported as GeoJSON, so it's
> only suitable for limited amount of data as loading of big files could
> be quite slow on web.
>
> QGIS Server needs a more powerful server infrastructure as you have to
> install QGIS Server package with all it's dependencies. It has the big
> advantage that it serves QGIS projects with all it's symbology exactly
> as they are shown on desktop. But you have to code your own web viewer,
> for example using OpenLayers.
>

That's not entirely correct: since 3.16 QGIS Server provides you a simple
catalog and map viewer out of the box:
https://docs.qgis.org/3.16/en/docs/server_manual/services.html#qgis-server-catalog

No need for additional software.

WFS3 also has a (even more simpler) integrated map viewer.

Regards.

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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 - serve WMS with basic authentication

2021-06-22 Per discussione Alessandro Pasotti
On Tue, Jun 22, 2021 at 12:47 PM Marco Casalboni 
wrote:

> I'm sorry to bother you more.
> With the examples provided I can easily set up my role permissions, but it
> works on layers only: the accessControlFilter.layerPermissions doesn't seem
> to take care of layer groups in the GetCapabilities request.
> If the layer group has 0 layers because none of the sublayers is readable
> by the authenticated user, it still remains in the GetCapabilities response.
>
> Is it possible to exclude a group with 0 layers in the GetCapabilities
> response?
>

This sounds like a bug to me... I cannot see any valid reason to keep an
empty group in the capabilities response.

Or better:
> Is it possible to apply the AccessControl plugin to a layer group?
>

I don't think so, because a group is not a layer and the plugin filter
current implementation works on layers.

Regards.

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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 - serve WMS with basic authentication

2021-06-21 Per discussione Alessandro Pasotti
On Mon, Jun 21, 2021 at 10:06 AM Marco Casalboni 
wrote:

> Thank you for the accurate informations, this will be very helpful.
>
> One more thing: is it possible to filter the wms GetCapabilities request's
> layer list according to an authenticated user (or role)?
>

Yes:
https://docs.qgis.org/3.16/en/docs/pyqgis_developer_cookbook/server.html#access-control-filters



> regards,
>
> Marco
>
> Il giorno ven 18 giu 2021 alle ore 03:29 Germán Carrillo <
> carrillo.ger...@gmail.com> ha scritto:
>
>> Hi Marco,
>>
>>
>> I published a blog where I configured permissions based on user roles for
>> a QGIS Server workshop.
>> Keep in mind that it was just a demo. It was based on some plugin
>> examples by Alessandro Pasotti.
>>
>> One single project, one single WMS, several user roles and different
>> permissions (based on spatial and non-spatial filters) per role.
>>
>> You can read here [1] the instructions.
>> They are unfortunately only in Spanish. Even though I created an English
>> version, we are migrating the whole website at the moment, so it's
>> unavailable.
>> I hope you manage to translate them.
>>
>>
>> BTW, according to your use case, you would need to focus on
>> "layerPermissions" (see the link Thomas posted earlier in this thread).
>>
>>
>> Regards,
>>
>> Germán
>> 
>> [1]
>> https://geotux.tuxfamily.org/2019/05/07/accediendo-a-datos-de-qgis-server-con-base-en-roles-de-usuario/#qs-10
>>
>>
>> El jue, 17 jun 2021 a las 16:45, Thomas Gratier (<
>> osgeo.mailingl...@gmail.com>) escribió:
>>
>>> Hi,
>>>
>>> You may create a QGIS Server plugin to manage your permissions e.g
>>> https://docs.qgis.org/3.16/en/docs/pyqgis_developer_cookbook/server.html#accesscontrol-py
>>>
>>> Regards
>>>
>>> Thomas
>>> ___
>>> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Locale not respected by layouts

2021-06-09 Per discussione Alessandro Pasotti
Hi,

can you please file a ticket and assign it to me (elpaso)?

I'm planning to fix this kind of issues in the future.



On Wed, Jun 9, 2021 at 12:50 PM António Pestana 
wrote:

> I'm on QGIS 3.18.3 using the "Portuguese Portugal" (pt_PT) locale. For
> this locale the decimal separator is a comma. However, when creating a
> layout that includes a table having decimal fields, the decimal separator
> used by QGIS becomes a point! How can I prevent this odd behavior?
>
> Use the link
> <https://drive.google.com/drive/folders/1vrGAU00HEzVtPwTQ57J-7GBXEV3QDtS2?usp=sharing>
>  to
> load three (very small) files, as follows:
> - "Points", a geopackage consisting of one points layer only, whose
> attribute table has decimal fields;
> - "TableWithCommas", printscreen of the attribute table as displayed by
> the "Open Attribute Table" command (the decimal separator is a comma, as it
> should be);
> - "LayoutWithoutCommas", printscreen of the Print Layout Window after
> adding the attribute table to the layout (the decimal separator is now a
> point).
>
> António
>
> ___
> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Editing attributes in embedded forms

2021-06-03 Per discussione Alessandro Pasotti
This PR https://github.com/qgis/QGIS/pull/43529 should fix the issue.


On Thu, Jun 3, 2021 at 10:40 AM Alessandro Pasotti 
wrote:

> Yeah, good catch.
>
> I'm working on it now, a patch is on the way.
>
> Cheers
>
>
> On Thu, Jun 3, 2021 at 10:30 AM Bo Victor Thomsen <
> bo.victor.thom...@gmail.com> wrote:
>
>> There is something odd about how QGIS fetches values from the sequence:
>>
>> The error message states that :
>>
>> *2021-06-03T09:22:31 WARNING**Erroneous query: SELECT
>> nextval("sample_point_fid_seq"::regclass) returned 7 [ERROR: column
>> "sample_point_fid_seq" does not exist*
>>
>> * LINE 1: SELECT nextval("sample_point_fid_seq"::regclass)*
>>
>>   ^
>>
>> However - a correct call to the "nextval" function should loke like this:
>>
>> *SELECT nextval('sample_point_fid_seq'::regclass)*
>>
>> *Not* like this ( " contra ') :
>>
>> *SELECT nextval("sample_point_fid_seq"::regclass)*
>>
>> So the call fails twice : It calls a non-existing sequence and the
>> function argument should be 'sample_point_fid_seq'::regclass , not
>> "sample_point_fid_seq"::regclass
>>
>> Med venlig hilsen / Kind regards
>>
>> Bo Victor Thomsen
>>
>> Den 03-06-2021 kl. 08:23 skrev Pekka Sarkola:
>>
>> Hi,
>>
>> You repeat this "ERROR: column "sample_point_fid_seq" does not exist"
>> -problem with:
>> Create very simple table to PostGIS (choose your own CRS):
>>
>> CREATE TABLE IF NOT EXISTS sample_point
>> (
>> fid integer NOT NULL GENERATED ALWAYS AS IDENTITY,
>> wkb_point geometry(Point,3067),
>> name varchar,
>> CONSTRAINT sample_point_pk PRIMARY KEY (fid)
>> );
>>
>> Add table to QGIS. Editing works, without errors.
>>
>> If you tick on from project properties: "Evaluate default values on
>> provider side", error will happen:
>>
>> 2021-06-03T09:22:31 WARNINGErroneous query: SELECT
>> nextval("sample_point_fid_seq"::regclass) returned 7 [ERROR: column
>> "sample_point_fid_seq" does not exist
>>
>>  LINE 1: SELECT nextval("sample_point_fid_seq"::regclass)
>>
>>   ^
>>
>>  ]
>>
>> Rgs,
>>
>> Pekka
>>
>> Pekka Sarkola
>> Gispo Oy
>> pekka.sark...@gispo.fi   - GSM +358 40 725 2042
>> www.gispo.fi – www.paikkatieto.com
>>
>>
>> to 3. kesäk. 2021 klo 8.47 Pekka Sarkola (pe...@gispo.fi) kirjoitti:
>>
>>> Hi Alexandre et al,
>>>
>>> I re-create a database (sample one), create a new QGIS project, add
>>> layers => same error. Maybe I open an issue in Github and I can share more
>>> SQL and snapshots.
>>>
>>> Rgs,
>>>
>>> Pekka
>>>
>>> Pekka Sarkola
>>> Gispo Oy
>>> pekka.sark...@gispo.fi   - GSM +358 40 725 2042
>>> www.gispo.fi – www.paikkatieto.com
>>>
>>>
>>> ti 1. kesäk. 2021 klo 16.36 Alexandre Neto (senhor.n...@gmail.com)
>>> kirjoitti:
>>>
>>>> From that last error...
>>>>
>>>> Are you sure your table was not changed after being loaded to QGIS? It
>>>> seems to expect a sequence that no longer exists.
>>>>
>>>> Alexandre Neto
>>>>
>>>> A terça, 1/06/2021, 12:22, Pekka Sarkola  escreveu:
>>>>
>>>>> Hi Andreas,
>>>>>
>>>>> Trasnsactions groups are enabled: editing is working (not in embedded
>>>>> forms) as expected.
>>>>>
>>>>> If I enable "Evaluate default values.."-option, I will get error:
>>>>>
>>>>> 2021-06-01T14:11:44 WARNINGErroneous query: SELECT
>>>>> nextval("sample_point_fid_seq"::regclass) returned 7 [ERROR: column
>>>>> "sample_point_fid_seq" does not exist
>>>>>  LINE 1: SELECT nextval("sample_point_fid_seq"::regclass)
>>>>>
>>>>> Primary key of the geometry table is "fid" and it has been defined as
>>>>> IDENTITY column (fid integer NOT NULL GENERATED ALWAYS AS IDENTITY (
>>>>> INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ).
>>>>>
>>>>> I presume this evaluation of the default values is not the solution
>>>>> for

Re: [Qgis-user] Editing attributes in embedded forms

2021-06-03 Per discussione Alessandro Pasotti
gt; "Properties" --> "Data Sources".
>>>>>
>>>>> I usually enable all three check boxes:
>>>>>
>>>>> - Automatically create transaction groups where possible
>>>>>
>>>>> - Evaluate default values on provider side
>>>>>
>>>>> - Trust project when data source has no metadata
>>>>>
>>>>> The transaction mode allows to edit all layers from the same data base
>>>>> connection (needs identical db connection string and credentials) and -
>>>>> together with "evaluate default values on provider side" - immediately
>>>>> retrieves primary keys from the DB, so that you can link objects
>>>>> immediately, without having to save first.
>>>>>
>>>>> Greetings,
>>>>>
>>>>> Andreas
>>>>>
>>>>> On 2021-06-01 09:55, Pekka Sarkola wrote:
>>>>>
>>>>> Hi folks!
>>>>>
>>>>> I have a problem editing feature attributes in embedded forms. Data is
>>>>> stored in PostGIS and I have a simple 1:1 relationship with the geometry
>>>>> table and an additional attribute table. QGIS version is 3.18.3 on Ubuntu.
>>>>>
>>>>> I have created a custom form with a drag-and-drop designer. I can edit
>>>>> additional attribute table attributes in embedded form, but those edits 
>>>>> are
>>>>> not stored anywhere. I have to open a separate form and then edit 
>>>>> attribute
>>>>> values of the related attribute table. This is quite annoying for the end
>>>>> user.
>>>>>
>>>>> Any suggestions? Or should I write a better description to the Github?
>>>>>
>>>>> Rgs,
>>>>>
>>>>> Pekka
>>>>>
>>>>> Pekka Sarkola
>>>>> Gispo Oy
>>>>> pekka.sark...@gispo.fi   - GSM +358 40 725 2042
>>>>> www.gispo.fi – www.paikkatieto.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 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 listqgis-u...@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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Editing attributes in embedded forms

2021-06-03 Per discussione Alessandro Pasotti
>>>>
>>>>> Hi folks!
>>>>>
>>>>> I have a problem editing feature attributes in embedded forms. Data is
>>>>> stored in PostGIS and I have a simple 1:1 relationship with the geometry
>>>>> table and an additional attribute table. QGIS version is 3.18.3 on Ubuntu.
>>>>>
>>>>> I have created a custom form with a drag-and-drop designer. I can edit
>>>>> additional attribute table attributes in embedded form, but those edits 
>>>>> are
>>>>> not stored anywhere. I have to open a separate form and then edit 
>>>>> attribute
>>>>> values of the related attribute table. This is quite annoying for the end
>>>>> user.
>>>>>
>>>>> Any suggestions? Or should I write a better description to the Github?
>>>>>
>>>>> Rgs,
>>>>>
>>>>> Pekka
>>>>>
>>>>> Pekka Sarkola
>>>>> Gispo Oy
>>>>> pekka.sark...@gispo.fi   - GSM +358 40 725 2042
>>>>> www.gispo.fi – www.paikkatieto.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 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Authentication Manager master password protection

2021-04-13 Per discussione Alessandro Pasotti
On Tue, Apr 13, 2021 at 8:26 PM Frank Broniewski
 wrote:
>
> Hello all,
>
> I am looking for a more protective setting for the authentication manager.
>
> Currently, as far as I understand, the master password for the authentication
> manager is requested once per QGIS session and is never requested again while
> QGIS remains open.
>
> Is there a way to change this behaviour? Ideally there would be a setting that
> the master password is always requested when accessing an authentication entry
> in the manager. Or is there some kind of time-out as a setting that I can
> activate - just like on  a banking website, where your session is cancelled
> after a certain time period of inactivity?
>
> Does something like this exist? My initial research did not reveal anything in
> that regards. Or can I maybe use the Python API to achieve something in that
> regard?
>
> Many thanks for any hints,
> Frank
>


Hi Frank,

this functionality does not exist, but I think it can be done with a
python plugin.

The authentication manager API is on purpose not complete: we didn't
want a malicious python plugin to be able to access and disclose the
credentials, however many functionality are exposed, I didn't check if
all you need is actually available in the API but my gut feeling is
that it is.

It might be tricky to define the inactivity period though, web
services typically use temporary connections and they may require to
retrieve the credentials after some time when further data is
requested from the server.


Kind regards.

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Hind the QGS path in the MAP Variable

2021-04-08 Per discussione Alessandro Pasotti
On Thu, Apr 8, 2021 at 9:10 AM Nicolas Boisteault  wrote:
>
> Hi,
>
> I think you should use QGIS_PROJECT_FILE environment variable for this 
> purpose.
>


... or mod_rewrite as an alternative for Apache.

Nginx has a similar functionality.

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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 WFS3 collections list works only for QGIS_PROJECT_FILE

2021-03-31 Per discussione Alessandro Pasotti
On Wed, Mar 31, 2021 at 7:23 PM 1520 gis
 wrote:
>
>   Hi developers,
>
> I have configured a qgis-server instance following this tutorial.
>
> I realized that WFS3 collections list the layers only for QGIS_PROJECT_FILE 
> [1] env variable. How can I change the settings to show collections for any 
> .qgs file?
>

If you want to see the layers (collections) from multiple QGIS
projects in the same call there is no way.

You need different endpoints for each QGIS project file you are
serving, or pass a MAP=/... (which is not allowed by the WFS3/OAPIF
specifications but still works on QGIS Server).

I believe the documentation is not bad in this case:
https://docs.qgis.org/3.16/en/docs/server_manual/services.html#wfs3-ogc-api-features

Regards.


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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 WFS3 Supports Shapefiles Layers Request

2021-03-25 Per discussione Alessandro Pasotti
On Thu, Mar 25, 2021 at 5:54 PM 1520 gis
 wrote:
>
> Dear users,
>
> I have a qgis project that contains postgis and shapefiles layers. QGIS- 
> Server WFS3 Collections list only postgis layers, but shapefiles. Does WFS3 
> request support shapefile layers ?

Absolutely yes, QGIS server makes no difference between data providers.

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


Re: [Qgis-user] Raster Layer Symbology Problem

2021-03-11 Per discussione Alessandro Pasotti
out for printing which includes a legend.
>>> >
>>> > In QGIS 3.16.4 LTR and previous versions:
>>> >
>>> > Doing the same I get the 5 color classes separately and the
>>> > corresponding values for each of the 5 classes in the "Legend Panel"as
>>> > well as in the layout manger.
>>> >
>>> >
>>> > My question: Is this a bug in the new QGIS version or does QGIS 3.18
>>> not
>>> > provide this functionality anymore?
>>> >
>>> >
>>> > Thanks a lot for a comment.
>>> >
>>> >
>>> > Regards
>>> >
>>> >
>>> > Martin
>>> >
>>> >
>>> >
>>> > --
>>> > This email has been checked for viruses by Avast antivirus software.
>>> > https://www.avast.com/antivirus
>>> >
>>> > _______
>>> > 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
>>>
>>
>>
>> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=icon>
>>  Virus-free.
>> www.avast.com
>> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=link>
>> <#m_-262278322626076534_m_726336712862281711_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>
> ___
> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Best practice, database vs WFS

2021-01-06 Per discussione Alessandro Pasotti
Hi Paul,

if you want to share geodata within your organization on a private
network a database is the best solution: faster and simpler. The
constraint is that you will need an application (like QGIS) to access
your data..

WFS is a web service standard for interoperability, it is ideal for
sharing data on the internet over HTTP, there is no need for a
particular application to use the service: any HTTP client is able to
do that.

Regards


On Wed, Jan 6, 2021 at 3:43 PM Paul Wittle
 wrote:
>
> Hi,
>
>
>
> As I’m sure is clear from the number of posts I’ve done of late we are 
> currently looking at how we use QGIS within our business. I thought I’d ask a 
> question here to see if others are considering it as I can’t find too much 
> chat online about it but I wondered if perhaps there should be some.
>
>
>
> We have concluded that in theory the WFS and WFS-T protocols are an OGC 
> standard (https://www.ogc.org/standards/wfs) and that using an OGC compliant 
> server they can be used to front various data source formats; i.e. Postgres, 
> Oracle, SQL Server etc. In theory that means that if you use WFS and WFS-T in 
> QGIS it should mean that user experience becomes more consistent for the 
> people using those layers in QGIS.
>
>
>
> That all sounds great, but I can’t seem to even get my WFS to load correctly 
> in QGIS at present and it doesn’t seem to be something that is recommended 
> online. Given that both WFS and direct database access both return full 
> details (vector geometries and attributes) to QGIS; would you expect 
> performance of WFS to be similar or significantly slower?
>
>
>
> Is the use of OGC compliant WFS something that you personally feel is 
> something we should be aspiring to use more widely at the local / network 
> level in QGIS or do you favour just loading directly from databases?
>
>
>
> I’m honestly very interested to hear what others think on this as 
> theoretically you would think the creation of an OGC standard would have this 
> sort of aspiration but I’m increasingly concluding that this kind of use of 
> WFS is very limited. It seems to me that the most common use case is just for 
> occasional layers where you need to work with others over the internet.
>
>
>
> To ensure we are talking about the same thing; I’m thinking that the access 
> to WFS in this context would be locally within your own network or device as 
> clearly going over the internet will add a significant overhead and potential 
> for delay.
>
>
>
> Feel free to message me back directly or message the group if you think it is 
> a worthwhile discussion but as I say I’d love to hear what others think.
>
>
>
> Cheers,
>
> Paul
>
>
>
>
>
> This e-mail and any files transmitted with it are intended solely for the use 
> of the individual or entity to whom they are addressed. It may contain 
> unclassified but sensitive or protectively marked material and should be 
> handled accordingly. Unless you are the named addressee (or authorised to 
> receive it for the addressee) you may not copy or use it, or disclose it to 
> anyone else. If you have received this transmission in error please notify 
> the sender immediately. All traffic may be subject to recording and/or 
> monitoring in accordance with relevant legislation. Any views expressed in 
> this message are those of the individual sender, except where the sender 
> specifies and with authority, states them to be the views of Dorset Council. 
> Dorset Council does not accept service of documents by fax or other 
> electronic means. Virus checking: Whilst all reasonable steps have been taken 
> to ensure that this electronic communication and its attachments whether 
> encoded, encrypted or otherwise supplied are free from computer viruses, 
> Dorset Council accepts no liability in respect of any loss, cost, damage or 
> expense suffered as a result of accessing this message or any of its 
> attachments. For information on how Dorset Council processes your 
> information, please see www.dorsetcouncil.gov.uk/416433
> _______
> 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



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Rendering time on line layer

2020-12-14 Per discussione Alessandro Pasotti
On Mon, Dec 14, 2020 at 3:42 PM Mathieu Gillot
 wrote:
>
> Hello,
>
> I've got a line layer (gpkg)  with reasonable complex symbologies (multiple 
> rule based) and labels whose content is calculated with virtual fields. 
> Number of entities is about 1500 objects.
>
> This layer is very slow to refresh when I pan or even if I open the table.
>
> Is there a simple way to know what is involved is this slow-down ? Like a 
> console, or anything like that?
>


Hi Mathieu,

yes: in 3.16 there is a developer console where you can browse
profiling information.

Settings -> Panels -> Debugging tools (or something like that).


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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 really slow with .gpkg layers

2020-12-10 Per discussione Alessandro Pasotti
On Thu, Dec 10, 2020 at 3:41 PM Francesco Pelullo  wrote:
>
> Hi all,
>
> I'm running QGIS 3.10 LTR on Windows 10.
>
> My project has 6 .gpkg files connected, everyone of these has 14 layers with 
> points geometries, every layer counts about 16.000 features.
>
> So my QGIS project manage about 1.344.000 points, not used at same time.
>
> When i open this project, QGIS needs about 15 minutes for go ready.
>
> Instead, if i store these points in separate .TXT files, QGIS needs only few 
> seconds for load layers and go ready. Also .shp layer format seems more 
> performant than .gpkg
>
> It seems to me that they are not really efficient for these points layers.
>
> Is this a my problem? Or there are some tricks i could use?
>


Hi,

if you can share your project and data we can check if it also happens
on other machines or if it is a local issue.

But first you should also check if the issue is still valid with QGIS 3.16.

Regards

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Delete a class from QgsPalettedRasterRenderer

2020-11-24 Per discussione Alessandro Pasotti
On Tue, Nov 24, 2020 at 8:17 AM PIERRE Sylvain 
wrote:

> Hi List,
>
> I want to remove some class from a QgsPalettedRasterRenderer in a python
> script.
>
> I got the renderer and classes with :
>
> renderer = myLayer.renderer()
>
> clas = renderer.classes()
>
> I can iterate classes, modify label and so on.
>
> But I don’t find any tips to delete a class as I can do in the ui.
>
>
>
> Any idea?
>


There is apparently no API for that, you could try to use

QgsPalettedRasterRenderer::classDataToString

modify the string and then call:
QgsPalettedRasterRenderer::classDataFromString



Kind regards.

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Saving project to geopackage

2020-10-29 Per discussione Alessandro Pasotti
On Thu, Oct 29, 2020 at 1:42 PM Jorge Gustavo Rocha 
wrote:

> Hi António (hi Luigi),
>
> Before saving the project, you must create a connection (in the browser
> panel) to the geopackage. If you don't create the connection, you are not
> able to save de project in the geopackage.
>
> This additional step is not "user friendly", but it is required right now.
>

This is actually not correct.

The additional step is not required anymore, I cannot remember since when
but it's been a while, just click on the three dots icon right of the
connections combo box and select your target GPKG.

Kind regards.


> Regards,
>
> Jorge Gustavo
> Às 12:29 de 29/10/20, Luigi Pirelli escreveu:
>
> save the project in the same gpkg from Menu Project->Save top->geopakage
> and select the geopakage where are located all your layers
>
> Luigi Pirelli
>
>
> **
> * LinkedIn: https://www.linkedin.com/in/luigipirelli
> * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
> * GitHub: https://github.com/luipir
> * Book: Mastering QGIS3 - 3rd Edition
> <https://www.packtpub.com/eu/application-development/mastering-geospatial-development-qgis-3x-third-edition>
> * Hire a team: http://www.qcooperative.net
>
> **
>
>
> On Thu, 29 Oct 2020 at 12:45, António Pestana 
> wrote:
>
>> I'm a brand new user trying to adapt my workflows to  QGIS.
>> I've created a project having more than twenty layers. In order to
>> keep things more manageable I've structured these layers using several
>> groups. I would like to save my project (layers, groups, formatings,
>> etc) and all my data using only one file and send it to one coworker
>> of mine. I suppose that exporting to one geopackage-type file is the
>> way to go. It seems to me that my needs shouldn't be uncommon but
>> unfortunately I don't know how to do that.
>>
>> I've searched QGIS user guide with no luck. Can anyone help me?
>>
>> Regards
>>
>> Antonio
>> ___
>> 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 listqgis-u...@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
> --
> [image: Logo] <https://www.geomaster.pt>
> *Geomaster*
> *Jorge Gustavo Rocha* | Software Engineer
> *e:* 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
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Geopackage file data loss issue

2020-10-14 Per discussione Alessandro Pasotti
On Wed, Oct 14, 2020 at 8:51 AM Patrick Dunford  wrote:
>
> Good day
>
> In most of my file-based projects I have converted all the shapefiles
> into geopackages as this is supposed to be better these days and I am
> sure with a database based format there should be significant overall
> benefits of stability etc of the data stored within these layers.
>
> However there does seem to be a major problem with Qgis in the way it
> handles errors from rejecting a change in the database table structure,
> specifically adding and removing columns. This appears to consistently
> result in all of the records of the table disappearing from view into
> temporary files associated with the database, from which they cannot
> actually be retrieved by the user.
>
> In the case of the layer shown in the attached picture, this has SHM and
> WAL files open that, according to the Sqlite specification, should
> contain unposted data from the table, but the end user has no way of
> forcing this data to be committed in this situation in which, in this
> case, an alter table or similar type of operation was rejected by the
> Sqlite library. Leaving 181 features in what appears to be a temporary
> table within the database and rendering the main data table (the first
> one in the list) in practice having no rows in it.
>
> There appear to be two issues: 1. the rejected data processing operation
> on the table, 2. the error recovery coded into Qgis when a situation
> like this comes about, in this case I have cancelled the post (save)
> operation on the geopackage, this should have rolled back the database
> to its previous state prior to attempting the data processing operation,
> but instead of this roll back taking place the table is left in this
> inconsistent state from which the user is unable to retrieve their data.
>
> Specifically (1)
>
> a. Qgis will treat a table's field names as case sensitive so that
> styles that apply to a field that are copied between otherwise similar
> tables will not apply to the field in the table they are copied to if
> that field has one letter that is different case from the original. This
> behaviour is not consistent with the Sqlite data engine behaviour which
> does not distinguish between case sensitive names of fields so that
> attempting to rename the field will be rejected by the Sqlite layer
> resulting in potential data loss in the table due to Qgis's failure to
> handle the error situation properly.
>
> b. I have seen a number of situations where attempting just to delete
> some columns out of a table will be rejected by the Sqlite layer for
> unknown reason, resulting in the same problem.
>
>
>

Hi Patrick,

I would recommend you to file an issue on the QGIS bug tracker, please
attach a small project + dataset and the step-by-step procedure to
trigger the issue.

Because you are reporting several maybe-related problems, please file
a separate issue for each of them.

Kind regards.


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] creating one portable QGIS project

2020-10-07 Per discussione Alessandro Pasotti
On Wed, Oct 7, 2020 at 12:27 PM Bernd Vogelgesang
 wrote:
>
> From what I now read and tried, that solution seems to be far from what Andre 
> wants.

What the Andre wants can be achieved by saving the filesystem-based
data in a directory under the project's directory and then setting the
project's option to store datasource paths as relative, if that
doesn't work it's a bug.
Then you can make a zip/tar.gz of the project and the underlying data
and send the zip.


> It seems, you can save it TO a gpkg and not AS a gpkg.
> So in case your complete project data is not already stored within a gpkg, it 
> won't collect and dump it as QConsolidate does. (correct?)
>

Correct.


> Maybe someone could shed a light about an best-practice-approach, how to 
> organize and store the data so this tool will give a smooth workflow. 
> (thinking e.g. of how to deal with big permanent datasets on networks drives 
> etc. )
>
> Cheers,
>
> Bernd
>
> On 07.10.20 11:56, Andreas Neumann wrote:
>
> For storing the .qgs file in a geopackage you can simply do "Project"
> --> "Save As" --> "Geopackage".
> I think you could even have multiple .qgs project files in a single
> Geopackage.
> Andreas
> On 2020-10-07 11:50, Richard Duivenvoorde wrote:
>
> On 10/7/20 11:45 AM, Andre Ulrich wrote:
>
> Dear community,
>
> I want to export a QGIS project. In this project there are a few layers (the 
> path for each layer is set according to where the data is saved on my 
> computer). I can open the project on my computer and all the layers are 
> available.
> But when I send the project (and all the data for the layers - everything is 
> in one repository) to a colleague, he can not view the layers (because the 
> paths are still set according to my computer). One can fix this in a few 
> minutes by setting up the correct paths, but this is very annoying. And once 
> the paths are set correctly, all the symbology from the layer properties is 
> lost (or reset to some standard).
>
> Is there a way to save a QGIS project and all the related data as one file 
> (so that another person, who opens this file on its own computer, does not 
> have to set up all the paths and edit the symbology)?
>
>
> Try the QConsolidate plugin from Alex Bruy:
> https://github.com/alexbruy/qconsolidate
> available from his plugin repo (or github)
> https://plugins.bruy.me/qconsolidate.html
>
> It is also possible to export your data to an geopackage yourself, as you can 
> also save symbology for layers into a geopackage, and..., wel you would need 
> to sent 2 files then: the gpkg with you data+symbology and your QGIS project 
> file
> (was there a plugin to write your projectfile into a gpkg?)
>
> HTH
>
> 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
>
> ___
> 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



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] creating one portable QGIS project

2020-10-07 Per discussione Alessandro Pasotti
On Wed, Oct 7, 2020 at 11:50 AM Richard Duivenvoorde
 wrote:
>
> On 10/7/20 11:45 AM, Andre Ulrich wrote:
> > Dear community,
> >
> > I want to export a QGIS project. In this project there are a few layers 
> > (the path for each layer is set according to where the data is saved on my 
> > computer). I can open the project on my computer and all the layers are 
> > available.
> > But when I send the project (and all the data for the layers - everything 
> > is in one repository) to a colleague, he can not view the layers (because 
> > the paths are still set according to my computer). One can fix this in a 
> > few minutes by setting up the correct paths, but this is very annoying. And 
> > once the paths are set correctly, all the symbology from the layer 
> > properties is lost (or reset to some standard).
> >
> > Is there a way to save a QGIS project and all the related data as one file 
> > (so that another person, who opens this file on its own computer, does not 
> > have to set up all the paths and edit the symbology)?
>
> Try the QConsolidate plugin from Alex Bruy:
> https://github.com/alexbruy/qconsolidate
> available from his plugin repo (or github)
> https://plugins.bruy.me/qconsolidate.html
>
> It is also possible to export your data to an geopackage yourself, as you can 
> also save symbology for layers into a geopackage, and..., wel you would need 
> to sent 2 files then: the gpkg with you data+symbology and your QGIS project 
> file
> (was there a plugin to write your projectfile into a gpkg?)

No plugins are needed to store a project in a GPKG, it's in core since
https://github.com/qgis/QGIS/pull/9381.

Regards.


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Tip: test a Pull Request for Windows users

2020-10-01 Per discussione Alessandro Pasotti
On Thu, Oct 1, 2020 at 4:01 PM Richard Duivenvoorde  wrote:
>
> Hi Devs/Users,
>
> Not sure if I was the only ignorant one here :-)
>
> But see: https://github.com/qgis/QGIS/issues/39081
>
> After Even Rouault had fixed an issue, I build and tested the PR on my Linux 
> machine.
> BUT... the person from the issues then told me that it was possible to 'just 
> download the artifact from the azure windows test suite and use that to test 
> the PR'.
>
> So for others (Windows) users: IF your issue is fixed and you want to test 
> the fix yourself in an easy way by logging in in Github, and then get the 
> artifact from the Windows azure test (at the PR), unzip/unpack it to disk and 
> just run that version!!
> No need to compile yourself, or wait for the nightly build to finish/be 
> available.
>
> I hope this is an eye-opener for others too (credits to @pathmapper !!)
>
> Regards,
>

Hi Richard,

Is that the MXE build?

If yes, it has nothing to do with Azure, it's cross-built in a Linux
Docker container using using github workflows and it has some
limitations (no Python is the most important one) but it's useful for
testing QGIS core/GUI changes if you don't need Python.

Kind regards

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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 do people unit test plugin code?

2020-09-24 Per discussione Alessandro Pasotti
On Thu, Sep 24, 2020 at 9:36 AM Ian Turton  wrote:
>
> I was toying with refactoring my plugin code the other day, but I thought I 
> would add some unit tests using pytest before I started to make sure I didn't 
> break anything. But when I try something like:
>
> def test_convertGridRef():
>  QgsExpression.registerFunction(convertGridRef)
>  e = QgsExpression('convertGridRef("SE2720")')
>  assert e.evaluate(None) == 'POINT (427000 42)'
>
> e.evaluate returns None - when it should either return a point or an exception
>
> Does anyone have some good plugin unit test examples I can take a look at?
>


Hi Jan,

There are many possible approaches to plugin testing, one of the most
interesting IMO is to use the testing docker which allows you to run
the tests inside a real QGIS instance and not a mocked one.

You can find examples of this setup in
https://github.com/inasafe/inasafe/blob/develop/.travis.yml and there
is some documentation in
https://github.com/qgis/QGIS/tree/master/.docker#running-unit-tests-inside-qgis

Hope this helps.


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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

2020-06-24 Per discussione Alessandro Pasotti
You can have a look to
https://qgis.org/pyqgis/3.2/core/File/QgsFileDownloader.html , store the
contents to a temporary file and then load it.

... or also
https://qgis.org/pyqgis/3.2/core/Network/QgsNetworkContentFetcher.html?highlight=fetcher#module-QgsNetworkContentFetcher

Both classes handle QGIS authentication configurations and proxies, OAuth2
is also supported by both.



On Wed, Jun 24, 2020 at 1:37 PM Karl Magnus Jönsson <
karl-magnus.jons...@kristianstad.se> wrote:

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



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Hyperlinks in the identify tool

2020-06-12 Per discussione Alessandro Pasotti
On Fri, Jun 12, 2020 at 2:34 PM Tyler Veinot  wrote:
>
> Hello;
> I know this is kind of a dumb question but is there a way to put hyperlinks 
> to files that can be used stright from the identify pane? I know I can use 
> "actions" but I want to consolidate everything into a 1 click function so 
> that users don't have to keep switching to the "Action Button". The screen 
> grab below shows the link to my file.
> When I click it though it tries to go to a webpage at 
> "http://g/Infrastructure/Vault+Drawings/F/Fox+Run+Drive+8.pdf; instead of 
> opening the file. Again I know how to do this using actions but I don't want 
> users to have to switch from tool to tool, I just want to set it up so that 
> identifying the feature will provide a list of links to associated files.
> Thanks;
> TYler
>
>

Hi Tyler, how is the form field configured in the layer properties?


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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

2020-06-01 Per discussione Alessandro Pasotti
Glad to hear that it worked!

If you feel like the documentation should include an example, feel free to
add some more content to the
https://docs.qgis.org/testing/en/docs/user_manual/auth_system/auth_workflows.html

There is also a section on organizations that might be relevant for this
kind of information.
https://docs.qgis.org/testing/en/docs/user_manual/introduction/qgis_configuration.html#deploying-qgis-within-an-organization



On Mon, Jun 1, 2020 at 5:29 PM Cliff Patterson 
wrote:

> Tested this solution and it works perfectly. When using the same ID in the
> authentication settings, the projects saved to the DB do not retain the
> creator's per-layer permissions.
>
> Thanks for the help!
>
> Cliff
>
> On Mon, Jun 1, 2020 at 11:19 AM Cliff Patterson 
> wrote:
>
>> Hi Karl and Alessandro,
>>
>> This is helpful but DEFINITELY not intuitive. I will test this
>> configuration and report back.
>>
>> Cheers,
>> Cliff
>>
>> On Mon, Jun 1, 2020 at 9:51 AM Karl Magnus Jönsson <
>> karl-magnus.jons...@kristianstad.se> wrote:
>>
>>> Hi!
>>>
>>> Alessandro, you where quicker! J
>>>
>>>
>>>
>>> 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 
>>> 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 
>>> 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 
>>> 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 u

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

2020-06-01 Per discussione Alessandro Pasotti
On Mon, Jun 1, 2020 at 3:35 PM Cliff Patterson 
wrote:

> 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, I probably misunderstood your issue.

What I was trying to say is that you can create a project with (say) one PG
layer that required your credentials (user "cliff")  to be created but you
want other users (user "alice") to be able to access the layer with her own
credentials.

You can create an authentication configuration and set its authid to some
easy to share value (you have 7 chars if I remember correctly), then you
will store your credentials in your authentication DB for that authid and
"alice" will store her credentials in her own authentication DB using the
same authid.

Note that "alice" credentials are different from "cliffs" credentials, the
authentication DB is also different (unless they are using the same machine
and the same OS account and the same user profile), the only thing that is
equal is the authentication configuration id.

The thing is that you don't share the authentication DB, you share the
authid 7 digits code only an the other users will use their own
credentials.

Kind regards,



> Cliff
>
> On Fri, May 29, 2020 at 3:03 PM Alessandro Pasotti 
> 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 
>> 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 
>>> 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
>>>> London | 148 Fullarton St. 9th Floor
>>>>
>>>>
>>>
>>> --
>>>
>>> Cliff Patterson Ph.D.
>>>
>>> *PSD* | Senior GIS Consultant
>>> P: 519-690-2565 ext. 2616
>>> www.psdrcs.com
>>> London | 148 Fullarton St. 9th Floor
>>>
>>> ___
>>> 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
>>
>>
>
> --
>
> Cliff Patterson Ph.D.
>
> *PSD* | Senior GIS Consultant
> P: 519-690-2565 ext. 2616
> www.psdrcs.com
> London | 148 Fullarton St. 9th Floor
>
>

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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

2020-05-29 Per discussione Alessandro Pasotti
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  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 
> 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
>> London | 148 Fullarton St. 9th Floor
>>
>>
>
> --
>
> Cliff Patterson Ph.D.
>
> *PSD* | Senior GIS Consultant
> P: 519-690-2565 ext. 2616
> www.psdrcs.com
> London | 148 Fullarton St. 9th Floor
>
> ___
> 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] Connecting to WMS does not work

2020-05-28 Per discussione Alessandro Pasotti
On Fri, May 29, 2020 at 6:59 AM Christoph Jung  wrote:
>
> Hello everyone,
>
> I have a very strange problem with QGIS. Only one user in my company is not 
> able to connect a external WMS. If we try to connect via the data source 
> manager, a dialog appears with the information, that the host cannot be 
> found. The url of the service is not the problem because it is inserted via a 
> plugin, i.e. all users using the same url. And for all other users it works 
> perfectly. We copied the url from QGIS into the browser and we can get the 
> capabilities. The same url works without problems in other software 
> (Smallworld, GSA, WindPro). The proxy in QGIS is correct. If I remove the 
> proxy settings we get another error message according to the proxy. The 
> parameters for the proxy are the same for all users and also inserted via a 
> plugin to avoid typing errors or something. It is not a problem of a 
> different IP segment or something because only QGIS has this problem and we 
> are not able to reproduce it with other users.
>
> Now the (for me very important ^^) question: does anybody had such a problem 
> in the past or could imagine other possibilities of problems?
>

It's unlikely, but there is only one thing I can think of: if the
user's QGIS uses a different QT version then his colleagues he might
be hitting this bug: https://bugreports.qt.io/browse/QTBUG-76821

Regards.

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] Relations in .qlr not restored ?

2020-05-06 Per discussione Alessandro Pasotti
On Wed, May 6, 2020 at 9:26 AM Yann Voté  wrote:
>
> Hi all,
>
> I've recently discovered a somewhat unadvertised new feature in QGIS
> 3.12: relations can now be exported as styles!
>
> Consequently, when exporting a bunch of layers as a QGIS Layer
> Definition file (.qlr), relations for each layer are now saved under the
> tags `` and ``.
>
> But when loading back the .qlr file, relations are not restored: project
> relations are empty. Am I missing something ? Is this by design ? A
> feature request ?
>
> Anyway, thanks to all developers and team for the excellent work !
>
> Regards.
>
> Yann
>

Hi Yann,

yes, the relations are now saved within the configuration of the form
widgets that are supposed to use them.

The idea behind that development is that we are now able to
automatically restore relations (and automatically search and load
related layers) when a layer is loaded (or restored if it was a "bad
layer") if the associated style uses a relation (i.e. the style uses a
form that requires a relation, such as relation-reference, but
value-relation also triggers automatic loading).

Coming to your question: it should work, given that the related layers
can be found.
Layers are searched by id, then name and a few providers (postgres)
can also automatically scan for the tables with the same name in the
"current" schema and in other schemas of the same DB of the original
layer (the one stored in the relation information in the style).

You can have a look to the PRs for further details:
https://github.com/qgis/QGIS/pull/33283
https://github.com/qgis/QGIS/pull/33103
https://github.com/qgis/QGIS/pull/32487

Hope this helps.

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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] PyQGIS to add PostGIS raster layer?

2020-04-30 Per discussione Alessandro Pasotti
On Thu, Apr 30, 2020 at 9:46 AM Yann Voté  wrote:
>
> Hi,
>
> Something like this should do.
>
> pg_layer = QgsVectorLayer(
>  "host=db.priv.example.org port=5432 authcfg=expauth srid=4326 "
>  "dbname=exampledb table='schema'.'table_name' (geometry) "
>  "type=MULTIPOLYGON sql=",
>  baseName='table_name',
>  providerLib='postgres',
> )
> QgsProject.instance().addMapLayer(pg_layer)
>
> Of course, adapt with your values. In particular, authcfg is the 7-chars
> identifier of the auth configuration that contains your login and
> password (or cert) to authenticate to PostgreSQL.
>
> See https://qgis.org/pyqgis/master/core/QgsVectorLayer.html

This won't work with rasters, you need to create a QgsRasterLayer, not
a vector one.

Coming to PG rasters, in QGIS 3.12 there are two providers that
support PG rasters:
- GDAL data provider
- native "postgresraster" data provider

GDAL data source uri uses the well known good old syntax to connect to
the raster (you can also test the connection from the command line
with "gdalinfo ").

The "postgresraster" provider is totally new in 3.12 and you can have
a look to the tests for PyQGIS use cases:
https://github.com/qgis/QGIS/blob/master/tests/src/python/test_provider_postgresraster.py#L82

Hope this helps.


>
> See also
> https://qgis.org/pyqgis/master/core/QgsDataSourceUri.html#qgis.core.QgsDataSourceUri
> for more options to build database connection strings.
>
> Regards.
>
> Yann
>
>
> Le 30/04/2020 à 00:24, thayeray a écrit :
> > Is it possible to add a PostGIS raster layer to a project using PyQGIS?
> > The PyQGIS Developer Cookbook mentions adding rasters from files,
> > geopackages and WCS services.
> > If I try using a QgsDataSourceUri by feeding it a raster column instead of a
> > geometry column, the PostGIS error that is generated shows that is not going
> > to work because raster is not a geometry:
> >
> > WARNINGErroneous query: SELECT 0, array_agg(DISTINCT
> > st_srid("rast")::text || ':' || UPPER(geometrytype("rast"))) FROM
> > "public"."indicators__g_economic_rebal_r_62ft" returned 7 [ERROR: function
> > geometrytype(raster) does not exist
> >
> > Any ideas of what I can do? Do I just have to give up on PostGIS rasters and
> > just turn it into WCS on the server?
> >
> >
> >
> >
> > --
> > 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] User setup for PostGres/PostGis use with QGIS

2020-04-26 Per discussione Alessandro Pasotti
Note that there is a little trick that might make things easier:
suppose you want to share a QGS project within an organization, by
using the QGIS authentication database you can create an
authentication configuration with a know ID  (the usually automatic 7
characters ID) and share the project withing your organization using
that authentication configuration to access the server, to load the
project (and to connect to the server) all what a user would need to
do is to create an authentication configuration with the same ID (but
with his/her own credentials).

We happily tested it with PKI user certificates on a postgis backend.


On Sun, Apr 26, 2020 at 9:26 AM Michael Dufty
 wrote:
>
> Good point on the security, so far we’ve been relying on the server only 
> being accessible from our network, but would be good to be able to open that 
> up.
>
> Other than that would simultaneous uses of the same account be likely to 
> cause issues.
>
>
>
> Michael Dufty
>
>
>
> From: Qgis-user  On Behalf Of Jeff Hubbs
> Sent: Sunday, 26 April 2020 1:45 AM
> To: qgis-user@lists.osgeo.org
> Subject: Re: [Qgis-user] User setup for PostGres/PostGis use with QGIS
>
>
>
> Agree, strongly. Even better to have an independent authentication system 
> (e.g. LDAP) that everything uses but at minimum, separate PostgreSQL accounts 
> for everybody is highly recommended.
>
>
>
> On 4/25/20 11:39 AM, Jo wrote:
>
> From a security perspective you definitely want to create a distinct user 
> account for each user. What if a user leaves your organisation? Will you 
> update the password and have to communicate it to everyone before they can do 
> further work? That's more cumbersome than doing it right from the start.
>
>
>
> After a while you may also discover that some users will need different 
> rights.
>
>
>
> Jo
>
>
>
> On Sat, Apr 25, 2020 at 12:23 PM Michael Dufty 
>  wrote:
>
> I’m looking at setting up a postGIS server for use to store mapping files to 
> use with QGIS.
>
> We have about a dozen users who will all need to be able to edit layers and 
> save new layers to the server, and any new layers they create need to be 
> editable by other users.
>
>
>
> Can anyone advise if having everyone use the same user account would be a 
> good idea?  Since everyone will have the same privileges this would seem to 
> simplify setup.  Often there will be different people editing the same QGIS 
> project at different times, and I think it would help with that, although it 
> looks like we would need to use the same id for the authentication on every 
> computer if we don’t want password prompts all the time.  I’m just concerned 
> this may cause issues with the server if the same user account is accessing 
> the database from different locations at the same time.
>
>
>
> As I understand it the alternative would be to create a role that all 
> accounts are members of, and alter the default privileges for each account so 
> the role gets access to any new tables created, which would be a bit of a 
> pain to set up for lots of accounts, but probably OK.
>
>
>
> I have struggled with this in the past, and the consultant who set up a 
> similar server for us in  the past to use with Manifold gave up on getting 
> permissions to work and just made every account a superuser.  This doesn’t 
> seem ideal, but hasn’t caused any issues in over 10 years.
>
>
>
>
>
> Michael Dufty
>
>
>
> ___
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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 installation on Windows via XAMPP

2020-04-15 Per discussione Alessandro Pasotti
On Wed, Apr 15, 2020 at 1:53 PM Richard Duivenvoorde
 wrote:
>
> On 4/15/20 1:40 PM, Alessandro Pasotti wrote:
>
> >> Is it an idea (feature request?) to let qgis_mapserver.exe spit out an
> >> INFO-message line telling the user that "Started a minimal http-server
> >> on localhost port 8000 for testing purposes" or so?
> >> OR is the code itself not aware it is being ran as a standalone http dev
> >> server at that moment?
> >
> > That's what it is supposed to do:
> > https://github.com/qgis/QGIS/blob/master/src/server/qgis_mapserver.cpp#L208
> >
> > I've no idea why you don't see it on windows.
>
> Ok it is there, but just buried beneath all other output...
> What about moving those lines to:
>
> https://github.com/qgis/QGIS/blob/master/src/server/qgis_mapserver.cpp#L241
>
> (/me thinking server.initPython() is the line that gave me the output:
> "INFO Server[178177]: No server python plugins are available"
> So if the server is 'waiting' for connections it is actually showing
> that info.
>
> Happy to do a pr if you want :-)

Yes please, sounds better.

But notice that there is actually a difference: all the debug info
goes to stderr, and the "listening" message goes to stdout.
You can actually silence all QGIS server internal debugging and
logging info by redirecting stderr to a file or /dev/null, you will
get only the output from the application which goes to stdout.

That was what I had in mind when I designed it.

>
> Regards,
>
> Richard
>


-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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 installation on Windows via XAMPP

2020-04-15 Per discussione Alessandro Pasotti
On Wed, Apr 15, 2020 at 1:32 PM Richard Duivenvoorde
 wrote:
>
> On 4/15/20 12:50 PM, Alessandro Pasotti wrote:
>
> >> @Allesandro: you say a standalone development server. But (even on
> >> windows) it's not that you run a webserver on port 80 if you run
> >> qgis_mapserver or qgis_mapserver.exe, is it?
> >
> > Yes, it's a full standalone HTTP development server.
> >
> >> If I run it here it's
> >> initing all QGIS machinery and ends with:
> >> INFO Server[178177]: No server python plugins are available
> >> seemingly waiting for a connection, but I do not know how
> >
> > try calling it with '-h'
>
> Ah, duh... thanks...
>
> YES, so it run's by default on port localhost:8000
>
> And it is also working (tested) on Windows:
>
> Saving a simple project into c:\tmp
> Starting qgis_mapserver.exe
> And in browser I go to:
> http://localhost:8000/?map=c:\tmp\nl.qgs=WMS=getcapabilities
> And I have a valid capabilities document!
>
> Thanks Ale! Works like a charm ( even on Windooz ;-) )
>
> Is it an idea (feature request?) to let qgis_mapserver.exe spit out an
> INFO-message line telling the user that "Started a minimal http-server
> on localhost port 8000 for testing purposes" or so?
> OR is the code itself not aware it is being ran as a standalone http dev
> server at that moment?

That's what it is supposed to do:
https://github.com/qgis/QGIS/blob/master/src/server/qgis_mapserver.cpp#L208

I've no idea why you don't see it on windows.

-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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 installation on Windows via XAMPP

2020-04-15 Per discussione Alessandro Pasotti
On Wed, Apr 15, 2020 at 12:41 PM Richard Duivenvoorde
 wrote:
>
> On 4/15/20 11:44 AM, Alessandro Pasotti wrote:
> > On Wed, Apr 15, 2020 at 11:39 AM Franko Naimarevic
>
> >> What am I missing?
> >
> > The web server component (apache or nginx or any other webserver you
> > can plug FCGI into).
> >
> > FCGI binary is not an HTTP server.
>
> I think Franko does have a running Apache webserver: in XAMPP the A
> stands for Apache?
>
> > If you have QGIS 3.12 you can try the standalone development server (I
> > have not tested it on windows but it may work), the executable name
> > should be qgis_mapserver.exe.
>
> @Allesandro: you say a standalone development server. But (even on
> windows) it's not that you run a webserver on port 80 if you run
> qgis_mapserver or qgis_mapserver.exe, is it?

Yes, it's a full standalone HTTP development server.

> If I run it here it's
> initing all QGIS machinery and ends with:
> INFO Server[178177]: No server python plugins are available
> seemingly waiting for a connection, but I do not know how

try calling it with '-h'

>
> To make more clear to Franko: QGIS comes with 2 mapservers:
> - a fastcgi module and a (simple) (you need mod_fastcgi (or something
> like that for it)
> - a cgi module: qgis_mapserver.exe is the simple cgi version.

No: that's not correct.

qgis_mapserver binary is NOT a CGI module, it is a full HTTP
(development) server. It listens on port 8000 by default (it should
print it on stdout when it starts).

As I said, I didn't test it on windows so I don't even know if that
works, work fine on Linux though.

>
> The last one is easiest, IF the environment of apache is ok, you should
> be able to put this in your cgi-bin dir of apache.

No! Don't use the development server in production. Is is a very naive
50 lines of code HTTP server implementation.

>
> To set the right environment, you could have a look into the
> osgeo4w64\httpd.d\httpd_qgis.conf (which comes with an osgeo4w64 install
> of qgis-server) which has most of the apache-config rules you need:
>
> DefaultInitEnv O4W_QT_PREFIX "C:\OSGeo4W64/apps/Qt5"
> DefaultInitEnv O4W_QT_BINARIES "C:\OSGeo4W64/apps/Qt5/bin"
> DefaultInitEnv O4W_QT_PLUGINS "C:\OSGeo4W64/apps/Qt5/plugins"
> DefaultInitEnv O4W_QT_LIBRARIES "C:\OSGeo4W64/apps/Qt5/lib"
> DefaultInitEnv O4W_QT_TRANSLATIONS "C:\OSGeo4W64/apps/Qt5/translations"
> DefaultInitEnv O4W_QT_HEADERS "C:\OSGeo4W64/apps/Qt5/include"
> DefaultInitEnv O4W_QT_DOC "C:\OSGeo4W64/apps/Qt5/doc"
>
> DefaultInitEnv PATH
> "C:\OSGeo4W64\apps\qt5\bin;C:\OSGeo4W64\bin;C:\OSGeo4W64\apps\qgis\bin;C:\OSGeo4W64\apps\grass\@grasspath@\bin;C:\OSGeo4W64\apps\grass\@grasspath@\lib;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem"
> DefaultInitEnv QGIS_PREFIX_PATH "C:\OSGeo4W64\apps\qgis"
> DefaultInitEnv QT_PLUGIN_PATH
> "C:\OSGeo4W64\apps\qgis\qtplugins;C:\OSGeo4W64\apps\qt5\plugins"
> DefaultInitEnv TEMP "C:\Users\richa\AppData\Local\Temp"
> DefaultInitEnv PYTHONHOME "C:\OSGeo4W64\apps\Python37"
> DefaultInitEnv PYTHONPATH
> "C:\OSGeo4W64\apps\Python37;C:\OSGeo4W64\apps\Python37\Scripts"
>
> Alias /qgis/ C:\OSGeo4W64/apps/qgis/bin/
>
> 
> SetHandler fcgid-script
> Options ExecCGI
> # Order/Allow is for Apache 2.2
> #Order allow,deny
> #Allow from all
> # Require is for Apache 2.4
> Require all granted
> 
>
> Off course this should all match your paths, but given this your cgi (or
> fastcgi) should be able to find all stuff needed to run qgis-server.
>
> Easiest way for me was to run an apache with modfcgi in it, install
> qgis-server with osgeo4w64 and then just 'include' the httpd_qgis.conf
> in your httpd.conf
>
> Hope this helps, regards,
>
> Richard Duivenvoorde
>
>


-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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 installation on Windows via XAMPP

2020-04-15 Per discussione Alessandro Pasotti
On Wed, Apr 15, 2020 at 11:39 AM Franko Naimarevic
 wrote:
>
> Hello,
>
> I'm trying to setup QGIS Server on my computer (Windows10) to experiment
> with how it works.
> I managed to get it running locally using XAMPP, following the official
> guide
> (https://docs.qgis.org/3.10/en/docs/user_manual/working_with_ogc/server/getting_started.html#installation-on-windows).
>
> I clicked
> http://localhost/cgi-bin/qgis_mapserv.fcgi.exe?SERVICE=WMS=1.3.0REQUEST=GetCapabilities
> as the guide suggests, and got "Layer(s) not valid", but I figured that
> the server was working, since I wasn't getting a "not found" error of
> some sorts.
>
> I then wanted to load my own map, but the guide doesn't really explain
> how to do it. After searching around on the internet, I tried:
> http://localhost/cgi-bin/qgis_mapserv.fcgi.exe?MAP=/OSGeo4W64/apps/qgis/bin/MAPNAME.qgs
>
> but got a "Project file error".
>
> What am I missing?

The web server component (apache or nginx or any other webserver you
can plug FCGI into).

FCGI binary is not an HTTP server.

If you have QGIS 3.12 you can try the standalone development server (I
have not tested it on windows but it may work), the executable name
should be qgis_mapserver.exe.


>
>
> Thanks for your help!
>
> ___
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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 and webmapping information

2020-04-10 Per discussione Alessandro Pasotti
On Fri, Apr 10, 2020 at 3:05 PM Etienne Trimaille
 wrote:
>
> Hi,
>
> qgis2web will generate a static website that you can easily move on a server 
> somewhere, without the need to install QGIS Server.
> The website will be generated from the plugin itself.
>
> If you install QGIS Server only, you will have only some OGC streams such as 
> WMS, WFS etc. It's just to publish "data" on the internet. But you won't have 
> the web viewer in an internet browser.
> Then you need to code the web application using Leaflet or OpenLayers.

That's not entirely correct anymore because WFS3 provides a very
simple browsable website, see
https://docs.qgis.org/3.10/en/docs/user_manual/working_with_ogc/server/services.html#wfs3-ogc-api-features

You could easily override the default HTML templates to show your WMS
layers too, no need to rebuild or compile anything.

Cheers




--
Alessandro Pasotti
w3:   www.itopen.it
___
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 I sell the maps produced from QGIS

2020-03-14 Per discussione Alessandro Pasotti
On Sat, Mar 14, 2020 at 3:51 PM krishna Ayyala  wrote:
>
> I am a self employed / Independent contractor. I wish to make few maps using 
> QGIS desktop. Can I sell these maps to another independent contractor or 
> agency? Or, do I need to obtain permission from QGIS?

You own the maps you make with QGIS, no need to ask anything.

You may need to check permissions on your source data of course, but
that applies to any software.

Kind regards



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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Relation widget values

2020-03-13 Per discussione Alessandro Pasotti
On Fri, Mar 13, 2020 at 10:59 PM Nyall Dawson  wrote:
>
> On Sat, 14 Mar 2020 at 07:54, Régis Haubourg  wrote:
> >
> > Hi,
> > No workaround. QGIS makes relations on the tables that are loaded in QGIS. 
> > You will always need both tables.
>
> That's correct, but I believe in 3.12 Alessandro improved this so that
> the dependent tables are automatically loaded when the qlr itself is
> loaded.
>
> Nyall

Yes, have a look at https://github.com/qgis/QGIS/pull/32487 for
value-relation widgets,
and there is another following PR for relation-reference widget.

It's in QGIS 3.12


>
> > Régis
> >
> > Le ven. 13 mars 2020 à 21:21, Jean-Philippe Chenel  a 
> > écrit :
> >>
> >> Hi,
> >>
> >> I've a question regarding the Value Relation Widget under Layer 
> >> Properties/Attributes Forms. Making the configuration work very well to 
> >> bind a field to a list of values of another table in the project.
> >>
> >> When all is done, I make a qlr file to save all the layer definitions.
> >>
> >> The problem appears when I reload the qlr file without all the relational 
> >> tables. The fields are bound, but the values aren’t displayed. To make 
> >> this work, I need to add the relational tables to the project too.
> >>
> >> Does it have a workaround or an alternative to make it work without adding 
> >> all the tables to the project? I saw in the qlr file that the connection 
> >> to postgresql and all needed information are in the file to make it work.
> >>
> >> Database: postgresql 9.6
> >> QGIS version 3.10.3
> >> Layers and tables are in the database.
> >>
> >> With best regards,
> >> ___
> >> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Create GeoPackage from scratch using python ?

2020-03-09 Per discussione Alessandro Pasotti
You can try QgsVectorLayerExporter

Cheers



On Mon, Mar 9, 2020 at 11:53 AM Bo Victor Thomsen
 wrote:
>
> Is there a method to create a GeoPackage file from scratch using QGIS
> and python (but not manually creating a layer using "create layer" in
> the user interface)
>
> Perhaps using the PyQt 5 QtSQL.QSqlDatabase method ??
>
>
> --
> Med venlig hilsen / Kind regards
>
> Bo Victor Thomsen
>
> ___
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] bug in 3.10.2 (after upgrading from 3.10.1) with NULL being lost in PostGIS

2020-02-04 Per discussione Alessandro Pasotti
Hi Jason,

the quickest way to test current master for your case is to unzip the
latest build artifact for windows 64bits (it's a zip inside a zip) on your
PC and launch the qgis.exe binary you find inside.
No installation is required and it's completely standalone, there is no
Python but you don't need it for your test case.

On every commit the artifact is automatically built:
https://github.com/qgis/QGIS/actions?query=workflow%3A%22Windows+cross+build+with+MXE%22

The patches are very recent and they will be backported to 3.10 but I'll do
that later this week.

Let me know how it goes.


On Tue, Feb 4, 2020 at 8:47 PM Jason Carlson 
wrote:

> Hi Alessandro,
>
> Thanks for your response.
>
> I've only used the standalone installers so it took me a bit to figure out
> how to start QGIS when using the OSGeo4W installer. My standalone was
> version 3.10.2-0 and in the OSGeo4W installer I see a 3.10.2-2 as well as
> the development version of 3.11.0-72.
>
> Wasn't sure which one you meant. If you meant the 3.11.0-72 then the issue
> is gone. If you had meant the 3.10.2-2 branch then it is still there but I
> discovered more stuff that may help but won't explain until I confirm the
> version I was to test against.
>
> Jason
>
> On Tue, Feb 4, 2020 at 9:05 AM Alessandro Pasotti 
> wrote:
>
>>
>>
>> On Tue, Feb 4, 2020 at 5:02 PM Jason Carlson 
>> wrote:
>>
>>> Can anyone else confirm this before I submit it?
>>>
>>
>>
>> Can you please check latest master builds first? I've done a couple of
>> fixes in the past few days that might have an impact on this issue.
>>
>> If the issue is still there, please file a ticket and attach a small SQL
>> dump and a QGS project to reproduce the issue.
>>
>>
>>
>>
>>
>>> After I upgraded from 3.10.1 to 3.10.2 I noticed an issue that it no
>>> longer handles null values correctly when updating records in PostGIS.
>>>
>>> I rolled back to version 3.10.1 and the issue goes away.
>>>
>>> Here is more detail:
>>> I have some PostgreSQL tables that have fields that can be NULL or text
>>> but I have check constraint in place saying it has to be NULL or one of a
>>> list of specific strings.
>>>
>>> In 3.10.1 if I go to edit a record that has some fields set as NULL,
>>> when the QGIS attribute form loads for editing, it shows those fields as
>>> NULL inside the text field (they can be text or null). I can make changes
>>> to any fields and save and the NULL fields remain as NULL.
>>>
>>> In 3.10.2 if I go to edit the same record, the QGIS attribute form when
>>> displayed for editing the record does not show those fields as being NULL
>>> but an empty string. When I submit changes, any fields that should still be
>>> NULL are not being submitted as NULL as I get a check constraint error
>>> saying it doesn't fit the criteria. I've tried entering into those fields
>>> manually as NULL or 'NULL' or "NULL" and a dozen or so other guesses and it
>>> still fails.
>>>
>>> Again, if I roll back to version 3.10.1 it works as it has on many
>>> previous versions all the way back to 2.8
>>> ___
>>> 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
>>
>>
>>
>> --
>> Alessandro Pasotti
>> w3:   www.itopen.it
>>
>

-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] bug in 3.10.2 (after upgrading from 3.10.1) with NULL being lost in PostGIS

2020-02-04 Per discussione Alessandro Pasotti
On Tue, Feb 4, 2020 at 5:02 PM Jason Carlson 
wrote:

> Can anyone else confirm this before I submit it?
>


Can you please check latest master builds first? I've done a couple of
fixes in the past few days that might have an impact on this issue.

If the issue is still there, please file a ticket and attach a small SQL
dump and a QGS project to reproduce the issue.





> After I upgraded from 3.10.1 to 3.10.2 I noticed an issue that it no
> longer handles null values correctly when updating records in PostGIS.
>
> I rolled back to version 3.10.1 and the issue goes away.
>
> Here is more detail:
> I have some PostgreSQL tables that have fields that can be NULL or text
> but I have check constraint in place saying it has to be NULL or one of a
> list of specific strings.
>
> In 3.10.1 if I go to edit a record that has some fields set as NULL, when
> the QGIS attribute form loads for editing, it shows those fields as NULL
> inside the text field (they can be text or null). I can make changes to any
> fields and save and the NULL fields remain as NULL.
>
> In 3.10.2 if I go to edit the same record, the QGIS attribute form when
> displayed for editing the record does not show those fields as being NULL
> but an empty string. When I submit changes, any fields that should still be
> NULL are not being submitted as NULL as I get a check constraint error
> saying it doesn't fit the criteria. I've tried entering into those fields
> manually as NULL or 'NULL' or "NULL" and a dozen or so other guesses and it
> still fails.
>
> Again, if I roll back to version 3.10.1 it works as it has on many
> previous versions all the way back to 2.8
> ___
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Problem with xyz tiles

2020-01-30 Per discussione Alessandro Pasotti
On Thu, Jan 30, 2020 at 1:43 PM Christoph Jung  wrote:

> Hi Víctor,
>
> Thank you for your advice. Yes, my tiles are in the opposite order in
> vertical direction. But only if I implement them via xyz tiles with a url
> like http://abc.def/{z}/{x}/{y}.png the tiles are in the wrong vertical
> order. Is there a possibility to adjust the values QGIS is using for the
> http parameters using an equation or something else?
>

Use "-y" for inverted Y

If I'm not wrong it's documented in the tooltip when you add/edit the URL.

Cheers




>
> Sincerely,
> Christoph
>
> Am 30.01.2020 um 10:06 schrieb Víctor Centella :
>
> 
>
> Hello Christoph,
>
> I had a similar issue, but not using mbtiles but generating tiles XYZ as
> files. I could solve it using the "Use inverted tile Y axis (TMS
> convention)" option, but this option is not available in the "Generate
> tiles XYZ (MBtiles)" tool, it is only in the "Generate tiles XYZ
> (Directory)" tool.
>
> 
>
> Regards,
>
> Víctor
>
>
> El 30/01/2020 a las 7:38, Christoph Jung escribió:
>
> Hello everyone,
>
> I have an mbtiles file with OSM-tiles. If I drag and drop this file into 
> QGIS, everything looks fine. Then I started a tomcat Server for providing 
> these tiles via url in my company and created a new connection for xyz tiles 
> in the QGIS browser. But the tiles are not on the right position. And they 
> are internally mixed too, i.e. the tiles are not in correct vertical order in 
> the map view. The settings of the xyz tiles connection should be okay. Have 
> had anybody a similar problem in the past? Is it possible to get the 
> GetMap-requests (or the similar name for xyz tiles), QGIS is generating for 
> the map view, logged or printed to the python console?
>
> Sincerely,
> Christoph
> ___
> 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
>
> --
> 
> Víctor Centella Fuster
> 
> Prodevelop
> http://www.prodevelop.es
> 
> <http://www.prodevelop.es>
> 
> *Aviso legal:*
> Este mensaje se dirige exclusivamente a su destinatario y puede contener
> información privilegiada o confidencial. Si ha recibido este mensaje por
> error, le rogamos que nos lo comunique inmediatamente por esta misma vía y
> proceda a su destrucción.
> De acuerdo con la nueva Ley de Servicios de la Sociedad de la Información
> y Comercio Electrónico aprobada por el Parlamento Español y de lo
> establecido en el Reglamento (UE) 2016/679 del Parlamento Europeo de
> Protección de Datos de Carácter Personal, le comunicamos que su dirección
> de correo electrónico forma parte de un tratamiento automatizado. Tiene
> usted derecho de oposición, acceso, rectificación, cancelación, y
> portabilidad de sus datos, mediante una respuesta a este e-mail. Asimismo,
> podrá dirigirse a la Autoridad de Control competente para presentar la
> reclamación que considere oportuna.
> --------
>
> ___
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Package Layers Algorithm

2019-12-18 Per discussione Alessandro Pasotti
On Wed, Dec 18, 2019 at 11:24 AM Grant Boxer  wrote:

> I have been using the Package Layers algorithm to create geopackages for
> complex projects. Who would I contact to see if we can improve this
> algorithm by packaging layers as per the order and grouping in the
> Layers Panel? Currently the package layers just copies all the layers in
> alphabetical order.
>
> Cheers Grant Boxer
>


Hi Grant,

there is a list of companies providing development services for QGIS, and
some of those companies are run by QGIS core developers:
https://www.qgis.org/en/site/forusers/commercial_support.html

I'd recommend you to choose a QGIS core developer near where you live.

Hope this helps!

-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] WMS Problem in QGIS 3.10

2019-12-13 Per discussione Alessandro Pasotti
Hi Nick,

I've just checked the ticket https://github.com/qgis/QGIS/issues/32740
the issue was fixed but it was not backported to 3.10.x (it still not
backported, I'll see if I can do it).

In any event it won't be available until the next point release.


On Fri, Dec 13, 2019 at 12:02 PM Nick Hopton  wrote:

> Thanks Alessandro, it was merged and closed. I'll reopen it and add the
> comment there.
>
> Best,
> Nick.
>
>
>
> --
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] WMS Problem in QGIS 3.10

2019-12-13 Per discussione Alessandro Pasotti
On Fri, Dec 13, 2019 at 11:44 AM Nick Hopton  wrote:

> Version 3.10.1 arrived here during the week. Sad to say it would appear
> that
> the WMS problem persists. Could anyone confirm this?
>
> Should I report this as a bug too?
>

No, if you already reported the original issue please add a comment to that
one.


> Best,
> Nick.
>
>
>
>
>
>
>
>
> --
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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 / GetPrint not rendering all the layers (XYZ Tiles for example)

2019-12-13 Per discussione Alessandro Pasotti
gt; FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH "/home/qgis/qgisserverdb"
>>> FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE
>>> "/home/qgis/qgisserverdb/qgis-auth.db"
>>> FcgidInitialEnv QGIS_PREFIX_PATH /usr
>>> FcgidInitialEnv QGIS_OPTIONS_PATH
>>> /data/owncloud-data/arnaud/files/GEOLAB/Transfert/webmapping-lizmap/QGIS3.ini
>>> 
>>> SetHandler fcgid-script
>>> FcgidWrapper /usr/lib/cgi-bin/qgis_mapserv.fcgi virtual
>>> Options +ExecCGI -MultiViews +FollowSymLinks
>>> Require all granted
>>> 
>>>
>>> ErrorLog ${APACHE_LOG_DIR}/map-error.log
>>> LogLevel warn
>>> CustomLog ${APACHE_LOG_DIR}/map-access.log combined
>>>
>>> And the permissions look good:
>>> ls -l /home/qgis/
>>> drwxr-xr-x 2 www-data www-data www-data 4096 Oct 25 08:46 cache
>>> drwxr-xr-xx 2 www-data www-data www-data 4096 Jun 20 07:32 qgisserverdb
>>>
>>> Do you have any idea what might cause this problem?
>>>
>>> Thank you in advance,
>>>
>>> Arnaud
>>> ___
>>> 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
>>
>>
>
> --
> 
> Arnaud Vandecasteele
> SIG - WebMapping - Spatial Ontology - GeoCollaboration
>
> Web Site
> http://geotribu.net/
> http://about.me/arnaud_vandecasteele
>
> ___
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Embed MULTIVAULUE RELATIONS IN A GEOPACKAG

2019-12-06 Per discussione Alessandro Pasotti
Hi Ed,

have a look to Value-Relation widgets and the drill-down functions and
https://www.youtube.com/watch?v=ipezh4KXrgo

Note that the function names has changed since the video was created but
the concept is still the same.

Also google for "qgis drill down forms"


On Fri, Dec 6, 2019 at 6:46 PM Ed Hawkins  wrote:

> I have created a project and I can embed all my widgets in that project
> and that works fine, what I want to do is create a multi value widget to
> select specific zip codes when I select the city name using the tables
> that I create in my geopackage. so that when I create my project file of
> Henderson County those multi value relations will follow the project as
> long as I have the geopackage available is that possible?
> Thanks,
> Ed Hawkins
> --
>
>
> *Edwin L. Hawkins Jr.,**AASGIS, GISP*
>
> A-Z Data Integrations (A2ZDI.COM)
>
> "Low Cost High Impact Solutions"
>
> CO FOUNDER/Senior GIS Consultant
>
> Cell 731.358.7932
>
>
> ___
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Handle local layers in resources folder when project saved in PostgreSQL

2019-12-05 Per discussione Alessandro Pasotti
On Thu, Dec 5, 2019 at 11:58 AM Yann Voté  wrote:

> Hi all,
>
> I can't find a solution to the following issue, or a way to work around
> it: I have created a project with some PostgreSQL layers to edit and
> some raster layers on local filesystem. I work on a Linux computer and
> have put the local layers into the pkg data path resources folder
> (/usr/share/qgis/resources/local/raster.gpkg).
>
>
Sorry but this is not a good idea, that path is usually not user-writeable
and should not be used to store any user related information.

But if I understand correctly what you were trying to do I'm afraid there
is not a solution: the concept of "relative path" means relative to the
project's storage path but that path does not make any sense in case of a
POSTGRES storage (because POSTGRES is not a local filesystem-based DB in
the same sense as GPKG or SPATIALITE are), so your file-system based asset
paths are not (and cannot be) converted to relative paths because there is
no project path we can relate to.

This makes portability an issue if the project has filesystem-based layers
(rasters in your case).

There is no solution I'm aware of, storing rasters into PG is also not a
viable option at the moment because support is currently buggy (see:
https://github.com/qgis/QGIS/issues/30392).

Cheers

I have also saved the project into PostgreSQL so that it can be shared
> easily. Other users work on Windows computers and have the same rasters
> under pkg data path resources folder
> (C:/PROGRAM~1/QGIS3~1.8/apps/qgis/resources/local/raster.gpkg). But when
> they open the project, Postgis layers are loaded fine, but QGIS says
> that raster.gpkg cannot be found under the /usr/share/... path.
>
> I would expect that layers in the pkg data path resources folder are
> saved with the inbuilt: prefix, but in fact they are not. Moreover, it
> seems that one cannot select "Relative" for saving layer paths, in
> project properties, when project is saved to PostgreSQL. Looks sensible
> (what is the relative path to a PostgreSQL table ?), but then what can I
> do to share a PostgreSQL project with local layers ?
>
> We all use QGIS 3.8.3.
>
> Thank you for any advice !
>
> Cheers
>
> Yann
> ___
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Problem connecting to PostGIS in QGIS 3.10

2019-12-02 Per discussione Alessandro Pasotti
On Mon, Dec 2, 2019 at 6:05 PM Cliff Patterson 
wrote:

> While testing QGIS 3.10 with PostGIS, I needed to create a new database
> user in PG and test that the user could access all tables in each schema. I
> use a "read_only" role to grant access to the tables. The newly created
> user was able to connect to the database, but each schema was inaccessible
> (table list could not be viewed), even though I am 100% sure the role was
> granted with usage on the DB, access to the schema, and read only access to
> each table. I even tested the new user's creds with PGAdmin4 and was able
> to execute a select query on every table in every schema. So, the problem
> is with QGIS 3.10.
>
> Thinking this might be a bug in 3.10, I installed 3.4.13 and the new user
> credentials work. I can access all tables in each schema, as expected. I
> also noticed that the rendering of large PostGIS layers is much slower in
> 3.10 and often leads to a momentary freezing.
>
> So if you are having trouble with PostGIS in 3.10, I recommend downgrading
> to QGIS 3.4, unless someone can recommend a solution -- perhaps a way to
> clear the credential cache or something in 3.10.
>
>

Hi Cliff,

did you check the issues?
https://github.com/qgis/QGIS/issues?utf8=%E2%9C%93=is%3Aissue+postgres%7Cpostgis

3.10 has serious issues with PG permissions, most of them have been fixed
already but if you have anything new to add, this is the right time to do
it.


-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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-Developer] Python Implementation of QgsNetworkContentFetcher

2019-11-25 Per discussione Alessandro Pasotti
On Tue, Nov 26, 2019 at 8:22 AM Richard Duivenvoorde 
wrote:

> On 26/11/2019 00.06, Nyall Dawson wrote:
>
> > There's not. But there's the ex-boundless "networkaccessmanager"
> > implementation that supports authcfg, which you can find at
> >
> https://github.com/north-road/qgis-redistricting-plugin/blob/master/redistrict/linz/networkaccessmanager.py
> > (and other projects -- as far as I'm aware there's no real upstream
> > for this... Alessandro?).
>
> I used this Boundless thingie for several plugins now (original source
> is now pointing/redirecting to planetlabs [0]).
>

Yes, that's the "upstream" but I don't know if that one is maintained
anymore.

Btw, there is also a specialized class for sync/async downloads that
supports authcfg: https://qgis.org/api/classQgsFileDownloader.html#details



>
> I think we already discussed several times that it would be good to
> incorporate this into a commons lib for QGIS. But if I'm correct the
> actual interface was not exactly what some wanted, and if I recall
> correct Nyall tried to pull this into c++ but hit some multithreading
> issues.
>
> But as Nyall says: I think this is a great lib to use in a plugin (also
> because it used the QgisNetwork-stuff, so you can receive the signals
> from it or log the precise urls, like we do in the QGISnetworklogger
> plugin [1]
>
> Regards,
>
> Richard Duivenvoorde
>
> [0]
>
> https://github.com/planetfederal/lib-qgis-commons/blob/master/qgiscommons2/network/networkaccessmanager.py
> [1] https://github.com/rduivenvoorde/qgisnetworklogger
> ___
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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 non-spatial JSON using Python

2019-11-25 Per discussione Alessandro Pasotti
Hi,

that doesn't look valid GeoJSON to me, you have no other options than
transforming  the JSON to valid GeoJSON (or to any other format recognized
by QGIS ogr provider), or you can create a vector layer from scratches and
and add the individual features in a loop, it largely depends on what you
need to do next with those data.

Both approaches require a bit of programming.



On Mon, Nov 25, 2019 at 6:10 PM Cliff Patterson 
wrote:

> I have a JSON endpoint that I want to load into a QGIS project as a flat
> table (no geometry). There are lat/ling coordinates in JSON (see below),
> but those coords are not important for my purpose since I want to
> eventually join the table with a spatial layer using a common ID. I can
> load the data into the console with:
>
> import urllib.request, json, csv
> with urllib.request.urlopen("https://my_json_endpoint;) as url:
> data = json.loads(url.read().decode())
> print(data)
>
> And I can load the table into QGIS as a GeoJSON with:
>
> import urllib.request, json
> uri = 'https://my_json_endpoint'
> iface.addVectorLayer(uri, 'Asset Data', 'ogr')
>
> but the table loads without attribute data and no rows.
>
> The JSON file looks like this (but with 20+ rows of data)
>
> {
> "Assets": [
> {
> "adjusted_cost": 1940993,
> "adjusted_eul": 240,
> "adjusted_quantity": 1,
> "amort_date": "2039-11-01",
> "attributes": [],
> "classifications": {
> "Acc. Amort. Code": "No Acc. Amort. Code",
> "Amort. Exp. Code": "No Amort. Exp. Code",
> "Capital Code": "No Capital Code",
> "Category": "Roads",
> "Class": "Infrastructure",
> "Department": "No Department",
> "Function": "No Function",
> "Schedule 51B Code": "No Schedule 51B Code",
> "Schedule 75C Code": "No Schedule 75C Code",
> "Segment": "Surface",
> "Sub-Function": "No Sub-Function"
> },
> "condition": 100,
> "condition_assessment_date": "Age-based",
> "condition_ratio": 1,
> "description": null,
> "eul": 240,
> "gis_feature_id": "roads.1",
> "historical_cost": 1940993,
> "id": 1,
> "import_id": "PATCH-1",
> "initial_quantity": 1,
> "is_fully_disposed": false,
> "is_fully_transferred": false,
> "is_lifecycle_excluded": true,
> "lat": 42.985708676898,
> "lifecycle_eul": 240,
> "lifecycle_eul_events": 240,
> "location": null,
> "lon": -81.254337208244,
> "name": "Road name 1",
> "profile": "Default Profile",
> "replacement_cost": 0,
> "replacement_date": "2039-11-01",
> "risk_consequence": 5,
> "risk_probability": 1,
> "risk_rating": 5,
> "service_date": "2019-11-12",
> "unit_of_measure": "Area (m2)"
> },
>
>  ...
>
> }
>
>
> I could write a script to load the data into a DB table dynamically, but it 
> would be much better to load the data dynamically in QGIS. The ultimate 
> objective would be to create a tool that loads the data for the user.
>
> Any ideas how I can achieve this?
>
> Thanks!
>
> Cliff
>
> ___
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Per discussione Alessandro Pasotti
sts.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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Per discussione Alessandro Pasotti
On Wed, Nov 20, 2019 at 11:58 AM Hernán De Angelis 
wrote:

> Thank you, Jan-Eric! Very good point. It is not redundant att all.
>
> Best
>
> Hernán
>
>
> On 2019-11-20 11:47, Jan-Eric Oskarsson wrote:
> > Hi Hernán!
> > Maybe this comment is redundant but you have to set up a strong security
> to prevent hackers to hack your database and steal your data and cause
> damage.
> > I hope uthat you already have thought about this issu!
> >
> > Kind Regards
> > Jan-Eric
> >
>


I would recommend considering PKI for authentication, it works well on both
sides (QGIS and postgres) and it gives you military grade security.

Also, we've had pretty bad performances on Azure cloud deployments (see
Andreas comments about latency), but that's another story.


-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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 Attribute Form

2019-11-15 Per discussione Alessandro Pasotti
On Fri, Nov 15, 2019 at 10:24 PM Cliff Patterson 
wrote:

> Hello!
>
> I am building an attribute form for a single spatial layer ( stored in
> PostGIS). For value maps, I am using the Value Relation to link to a few
> flat tables that are pulled into the project from Postgres/PostGIS. I am
> able to save the style as default in the Postgres/PostGIS database, but
> when I load the layer into a new project with the associated tables, the
> relations are broken -- none of the drop down menus work -- they appear
> with "(no selection)" as the only option in the dropdown menu.
>
> Is there a way to either (1) point the value relations directly to a
> database table to avoid having to load them with the spatial layer or (2)
> preserve/save the Value Relations in the default layer style? Without
> either of these two functions, it is hard to truly create a relational DB.
>
> Is this, perhaps, a bug or a good feature request?
>
> Thanks,
> Cliff
>
>
Hi Cliff,

Perhaps this will solve your issue:  https://github.com/qgis/QGIS/pull/32487
It will be in QGIS 3.12

Hope this helps.

--
Alessandro Pasotti
w3:   www.itopen.it
___
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] Change the datasource of a layer

2019-11-13 Per discussione Alessandro Pasotti
On Wed, Nov 13, 2019 at 10:47 AM DelazJ  wrote:

> Hi Andreas
>
> Le mer. 13 nov. 2019 à 10:44, Andreas Neumann  a
> écrit :
>
>> Hi Bruno,
>>
>> There is a Python Plugin available called "changeDataSource" from Enrico
>> Ferreguti that allows you, after installation, to right-click on a layer
>> and change it's source - or globally for all layers in a project by
>> clicking on the plugin icon.
>>
>> Maybe you can try this.
>>
>> But I agree, it would be nice, if such functionality would be in QGIS
>> core. If there is no feature request yet, it would be useful to open one.
>>
> The feature seems to be there already though I fail to find who implements
> it, browsing all the recent changelogs.
>

It has been there for a while: Fri Nov 2 13:16:06 2018  commit
fd40042514d49becf17fed4ad2d03219a8ec941d

Since 3.6

Right-click on a layer in the legend to change data source.


Thanks,
>> Andreas
>>
>> On 2019-11-13 10:30, bru...@mailbox.org wrote:
>>
>> Hi there!
>> In QGIS 3.10 it is nice and easy to change a broken the data source of a
>> layer by clicking on the warning sign in the layers list.
>> How can I change a non broken datasource? There is no button in the
>> Source tab of Layer Properties...
>>
>> Should I open a feature request on github?
>> Thank you
>> Bruno
>>
>> Bruno Streit
>> Bahnstrasse 163
>> 3008 Bern
>> 077 440 92 43
>>
>> ___
>> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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.4.2 & 3 still very slow to work in Windows 10

2019-11-11 Per discussione Alessandro Pasotti
On Sun, Nov 10, 2019 at 7:32 PM David Addy  wrote:

> Just to update this issue. I am still getting slow start ups and qgis not
> responding freeze ups just as bad on QGIS 3.8.3.
> Every version since 3.4.1 have given these problems.
> I have gone through all the files from old versions that I could find and
> deleted them.
> I have tried new profiles, disabling plug ins and removing the browser
> panel.
> I have tried turning off my Kaspersky security software.
> None of these changes have made any significant difference.
> I realise that only a few of us experience these issues, but there must be
> an answer somewhere.
>
>
>
Hi David,
the answer is probably somewhere but someone has to spend some time working
on the issue to try find that answer.

The first step, where you can probably help is to find a way to reproduce
the problem on a developer's windows machine.

If you can find a way to reproduce it, please open a ticket on the QGIS
issues tracker attaching the step-by-step instructions to reproduce the
issue and all relevant test data and project.

Hope this helps.




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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] DB Manager error with PostgreSQL 12

2019-11-09 Per discussione Alessandro Pasotti
This issue was fixed yesterday.

On Sat, Nov 9, 2019, 19:35 Árni Geirsson  wrote:

> Hi
> I just upgraded my database to PostgreSQL 12 and PostGIS 3.0. Since then I
> get an error when trying to load layers with the DB Manager:
>
> column adef.adsrc does not exist
> LINE 8: adef.adsrc AS default_value,
>
> However, loading through the browser works well and other clients do not
> seem to have a problem.
> I see that this issue has already been reported here:
> https://github.com/qgis/QGIS/issues/32321
> I am not familiar enough with the Git workflow to be able to tell if this
> has been fixed and entered into the code, so that the problem is solved in
> the next release.  If not, I would have to downgrade to PostgreSQL 11. Can
> anyone tell me what the status of the fix is?
>
> Thanks
>
> Árni
>
> Árni Geirsson
> *Alta ehf* // +354 582 5003 // +354 897 9549
> ___
> 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] WMS Problem in QGIS 3.10

2019-11-08 Per discussione Alessandro Pasotti
On Fri, Nov 8, 2019 at 4:29 PM Nick Hopton  wrote:

> Thanks for this Richard, it's good to know what's causing the problem and
> I'll live with it for the time being. I've also reported the problem to the
> EA in the hope that they might be able to do something about it at the
> other
> end.
>
> Should I post a QGIS bug report?
>

Yes please, that's a bug.


-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Crash when opening project with QGIS 3.10

2019-10-30 Per discussione Alessandro Pasotti
On Wed, Oct 30, 2019 at 3:47 PM Even Rouault 
wrote:

> > What's this about? A social experiment?
>
> Yes, I'm "Ben Hutcher". Too bad you destroyed it so quickly :-)
>

Oh, I'm sorry :)

You should have told me ... you know, I'm in bug-fixing-mode and I couldn't
resist ;)


> I just discovered this functionnality of QGIS and this scared me. I
> believe I
> would have accepted the warning because I ignored that QGIS projects could
> contain Python code, and I presume a lot of users would. IMHO clicking on
> the
> Enable macros link should raise a dialog box with a more explicit message
> about the potential risks to double confirm.



> "Python macros cannot currently be run." sounds to me as "you should
> enable
> macros so things work as expected". It is not even clear that the macros
> come
> from the project itself. They could be some trusted code in QGIS itself.
> Once
> you know that functionnality is, then yes the current behaviour is
> probably
> fine. But if you don't know it, there's a high chance you could run
> untrusted
> code without realizing it.
>
> Even
>
>

Agreed (same for Python code embedded in forms btw).
We should warn users about the security threats associates to run untrusted
code (now forms have also the option to download code from the network and
run it!).

Plugins as well are of course a potential threat.


-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Crash when opening project with QGIS 3.10

2019-10-30 Per discussione Alessandro Pasotti
On Wed, Oct 30, 2019 at 2:54 PM ben hutcher  wrote:

> Hi,
> I've just tried the new release, and I have a crash when trying to reopen
> a project that I've just saved. Can other people replicate that with the
> attached project and advise how to fix that  ?
>


I actually unzipped and inspected the project before loading it (because I
know enough about QGIS internals to know what to trust).

What's this about? A social experiment?

om qgis.PyQt.QtWidgets import QMessageBox
QMessageBox.critical(None, "Nearly busted !",
"Do you realize you blindly accepted to run untrusted code " + \
"that could have destroyed your computer, stolen your passwords,
etc. ?\n" + \
"Be reassured, nothing at all apart emitting this message has been
done.\n" + \
"This was just an experiment to check how users react to the
default security warning. " + \
"If you've read that message, please add a new line to
http://collabedit.com/662b2;)



Thanks,
> Ben
> ___
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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 - Click Tolerance for GetFeatureInfo Requests

2019-10-26 Per discussione Alessandro Pasotti
On Fri, Oct 25, 2019, 10:00 Charlotte Toma (WhereGroup) <
charlotte.t...@wheregroup.com> wrote:

> Hello Alessandro,
>
> thanks - this is exactly what i was looking for!
>
> Can you define the FI_POINT_TOLERANCE, FI_LINE_TOLERANCE or
> FI_POLYGON_TOLERANCE in the project settings or your qgs-file?
>
> As far as I understand the documentation you can only add this parameter
> when you make an GetFeatureInfo requests, but I would like to add this
> parameter as a default value (like version/layers/e.g).
>



That's not currently possible.


Another question: Is it possible to use the MAPTIP instead of the normal
> attribute fields (e.g. ONLY_MAPTIP=true)? If you activate the function
> (WITH_MAPTIP=true), then it is at the end of the table as a new column -
> but i want it without the rest of the attribute columns for my wms.
>

Sorry, I am not sure if I understand this question.

Greetings,
> Charly
> Am 25.10.19 um 09:46 schrieb Alessandro Pasotti:
>
>
>
> On Fri, Oct 25, 2019 at 9:41 AM Charlotte Toma (WhereGroup) <
> charlotte.t...@wheregroup.com> wrote:
>
>>
>> Hello everybody,
>>
>> I would like to know if you can increase the click tolerance for the
>> GetFeatureInfo query from QGIS Server.
>>
>> I created some WMS and would like to change the sensitivity for point
>> based queries. I only know how to do that with Mapserver (TOLERANCE)...
>>
>> I am looking forward to your feedback and thanks!
>>
>> Charly
>>
>
>
> Hi Charly,
>
> isn't the answer to your question in the documentation?
>
>
> https://docs.qgis.org/3.4/en/docs/user_manual/working_with_ogc/server/services.html#getfeatureinfo
>
> If you had any problem finding the documentation then please let us know.
>
>
>
>> --
>> ***
>> Where2B Konferenz 2019
>> 12. Dezember 2019 in Bonn
>> where2b-conference.com
>> ***
>>
>> Charlotte Toma
>> GIS-Consultant
>> WhereGroup GmbH
>> Eifelstraße 7
>> 53119 Bonn
>> Germany
>>
>> Fon: +49 (0)228 / 90 90 38 - 24
>> Fax: +49 (0)228 / 90 90 38 - 11
>>
>> i...@wheregroup.com
>> www.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
>
>
>
> --
> Alessandro Pasotti
> w3:   www.itopen.it
>
> --
> ***
> Where2B Konferenz 2019
> 12. Dezember 2019 in Bonnwhere2b-conference.com
> ***
>
> Charlotte Toma
> GIS-Consultant
> WhereGroup GmbH
> Eifelstraße 7
> 53119 Bonn
> Germany
>
> Fon: +49 (0)228 / 90 90 38 - 24
> Fax: +49 (0)228 / 90 90 38 - 11
> i...@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
___
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 - Click Tolerance for GetFeatureInfo Requests

2019-10-25 Per discussione Alessandro Pasotti
On Fri, Oct 25, 2019 at 9:41 AM Charlotte Toma (WhereGroup) <
charlotte.t...@wheregroup.com> wrote:

>
> Hello everybody,
>
> I would like to know if you can increase the click tolerance for the
> GetFeatureInfo query from QGIS Server.
>
> I created some WMS and would like to change the sensitivity for point
> based queries. I only know how to do that with Mapserver (TOLERANCE)...
>
> I am looking forward to your feedback and thanks!
>
> Charly
>


Hi Charly,

isn't the answer to your question in the documentation?

https://docs.qgis.org/3.4/en/docs/user_manual/working_with_ogc/server/services.html#getfeatureinfo

If you had any problem finding the documentation then please let us know.



> --
> ***
> Where2B Konferenz 2019
> 12. Dezember 2019 in Bonn
> where2b-conference.com
> ***
>
> Charlotte Toma
> GIS-Consultant
> WhereGroup GmbH
> Eifelstraße 7
> 53119 Bonn
> Germany
>
> Fon: +49 (0)228 / 90 90 38 - 24
> Fax: +49 (0)228 / 90 90 38 - 11
>
> i...@wheregroup.com
> www.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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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

2019-10-18 Per discussione Alessandro Pasotti
On Fri, Oct 18, 2019 at 10:15 AM 
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".
>

Hi,

It's a known issue, the root cause is that the relations/joins are stored
by QGIS using the layer ID (which is unique) so the relations are lost in
case of layer copy or save/load from a style file, the good new is that
I've got a customer that has committed some budget to fix this problem and
I'll start to work on that soon.

The solution would imply storing some more information about the layers
that compose a relation so that we can at try to reconstruct the relation
by searching for "similar" layers in the existing project before giving up
with a broken relation/join.

The same issue applies to the value-relation widget.

-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] GeoPackage deadlocks (Andrea Peri)

2019-09-27 Per discussione Alessandro Pasotti
On Fri, Sep 27, 2019 at 9:13 AM Paul Wittle <
paul.wit...@dorsetcouncil.gov.uk> wrote:

> Hi Andrea and Enrico,
>
> Thank you for providing an answer even if it was not what I was hoping to
> hear; it was the conclusion I'd reached myself.
>
> Has this issue been considered given the official move from shapefile to
> geopackage as the default format?
>
> My understanding was that shapefiles could be used over a network and
> whilst multiple people editing was dangerous it did not cause deadlocks.
>
> Combined with the issues relating to MapInfo tab files over a network I've
> got into some hot water over my attempt to get QGIS rolled out in our
> organisation now. I'm going to have to think carefully about my next steps
> as it can be difficult to educate large numbers of staff and the two issues
> mean that people using QGIS incorrectly can cause pretty big issues.
>
> To summarise,
>  - You open a geopackage and save to the network; someone else comes along
> and opens it in their QGIS and everything looks okay until the PCs
> deadlock...ICT help calls and data corruption may occur.
>  - You open a MapInfo tab file from the network and it looks fine (accept
> that it my draw in a user projection). MapInfo user receive errors but this
> is unknown to the QGIS user...ICT help calls result.
>
> Whilst I'm glad the forums have helped to diagnose both behaviours I would
> personally say that the issues pose a bit of a threat to software adoption
> by larger companies and institutions that may be using Windows networks and
> potentially migrating from MapInfo.
>
> In both cases my gut feel is that the best solution might be to look into
> use detection. If GDAL (I assume) can be improved to detect that either
> file type is already open then it might be possible to simply ban a second
> user from opening the file at the same time. This might frustrate some
> users but most importantly it would make the application safer from an ICT
> perspective.
>
> These are of course just my personal opinion from my particular use case
> so please don't be offended by them if you disagree but I'd be really happy
> to hear how others are approaching the issues and/or opposing views?
>
> Many thanks,
> Paul



Hi Paul,

A deadlock is a QGIS bug (and quite a serious one).

Can you please file an issue on https://github.com/qgis/QGIS/issues ?
Please check if it's not there, and if it is, you can add your comments to
the existing issue.

Thanks

-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Why is QGIS crashing in the end of a session

2019-09-27 Per discussione Alessandro Pasotti
On Thu, Sep 26, 2019 at 5:33 PM Anders Gleerup 
wrote:

> From Version 3.4 up to now 3.8.3 QGIS crash when ending the session. Some
> memory error seems to be at hand.
>
> The table Report details looks like this:
>
> *Crash ID*: b4417c17e4e0afd551fca11b93f09b0325592b2f
>
>
>
See: https://github.com/qgis/QGIS/issues/28104




> *Stack Trace*
>
>
> proj_lpz_dist :
> proj_lpz_dist :
> QgsCoordinateTransformPrivate::freeProj qgscoordinatetransform_p.cpp:659
> QgsCoordinateTransformPrivate::~QgsCoordinateTransformPrivate
> qgscoordinatetransform_p.cpp:120
> QHashNode,QgsCoordinateTransform>::~QHashNode,QgsCoordinateTransform> :
> QHashData::free_helper :
> QHash,QgsCoordinateTransform>::clear qhash.h:591
> QgsCoordinateTransform::invalidateCache qgscoordinatetransform.cpp:958
> QgsApplication::exitQgis qgsapplication.cpp:1263
> QgisApp::~QgisApp qgisapp.cpp:1646
> QgisApp::`vector deleting destructor' :
> main main.cpp:1568
> BaseThreadInitThunk :
> RtlUserThreadStart :
>
>
>
>
> *QGIS Info*
> QGIS Version: 3.8.3-Zanzibar
> QGIS code revision: 685d8b15d2
> Compiled against Qt: 5.11.2
> Running against Qt: 5.11.2
> Compiled against GDAL: 2.4.1
> Running against GDAL: 2.4.1
>
>
>
> *System Info*
> CPU Type: x86_64
> Kernel Type: winnt
> Kernel Version: 10.0.18362
>
>
>
> W10 is always updated to the last version.
>
>
>
> Kind regards, Anders Gleerup, Sweden
>
>
> ___
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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 fix the raster calculator

2019-09-26 Per discussione Alessandro Pasotti
On Tue, Sep 24, 2019 at 12:19 PM Raymond Nijssen 
wrote:

> Hi,
>
> I've been using the raster calculator lately and bumped into some
> unexpected behaviour issues. They are hard to isolate but I will create
> issues
>
> One of the things is the creation of empty output grids, resulting in
> raster layers with a range as described earlier in this thread:
>
> ([-1.79769e+308 to 1.79769e+308] instead of [0 1].
>

Hi Raymond,

Working on it (I've been able to reproduce it), can you please file a
ticket for me to reference in the PR?


>
> Somehow this was fixed after changing the locale (!) from NL back to EN.
>

This looks completely impossible to me: there is no locale involved in the
formulas (and no translation of operators!).

I was using a model that contained raster calculators and a python
> script running it.
> No clue what it could be, maybe parameter names being translated (I hope
> not!) or locale settings for decimal point/comma.
>
> Also, the names of the model parameter are like
> 'qgis:rastercalculator_4:sub_calc_sqrt', still containing the
> 'rastercalculator_4' part which can not be found or changed using the
> model editor.
>
>
> Besides, I'm wondering why very common functionality is missing in the
> raster calculator. I need abs() and max() functions and they don't
> exist. Or am I missing something?
>

Yes, you missed the implementation :)

Nobody had already implemented it, but I've done that today.


-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] banging my head against the QGIS wall

2019-09-13 Per discussione Alessandro Pasotti
Have a look to http://www.itopen.it/bulk/qgis-server-ws and
https://github.com/elpaso/qgis3-server-vagrant

On Fri, Sep 13, 2019, 20:49 Tom Vogt  wrote:

> Interesting idea. How can I call the WMS interactively ?
>
>
> There is, to be honest, not enough documentation on the QGIS server. I
> still don’t understand how it picks a map file when you don’t give one
> explicitly, for example.
>
>
>
>
> Am 13.09.2019 um 20:39 schrieb Alessandro Pasotti :
>
> You can try with python, and call it interactively. Also increase the
> logging level and if you can access a debug build set QGIS debug on.
>
> Last resource you can use a real debugger, check this out:
> https://github.com/elpaso/qgis-dev-vagrant
>
>
>
> On Fri, Sep 13, 2019, 20:28 Tom Vogt  wrote:
>
>> Hey everyone,
>>
>> I’ve been playing with QGIS for many years, but now I’m on the mailing
>> list as well. I’ve been banging my head against QGIS for the past two days
>> and just can’t get it to work, so maybe I can find help here. It just
>> doesn’t give me WMS tiles or they are blank. Then I fiddle around and it
>> works, then I clean it up to make it work and it stops again. It’s driving
>> me crazy. :-)
>>
>>
>> Any hints on debugging qgis_mapserv.fcgi ?
>>
>>
>> Tom
>>
>> ___
>> 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] banging my head against the QGIS wall

2019-09-13 Per discussione Alessandro Pasotti
You can try with python, and call it interactively. Also increase the
logging level and if you can access a debug build set QGIS debug on.

Last resource you can use a real debugger, check this out:
https://github.com/elpaso/qgis-dev-vagrant



On Fri, Sep 13, 2019, 20:28 Tom Vogt  wrote:

> Hey everyone,
>
> I’ve been playing with QGIS for many years, but now I’m on the mailing
> list as well. I’ve been banging my head against QGIS for the past two days
> and just can’t get it to work, so maybe I can find help here. It just
> doesn’t give me WMS tiles or they are blank. Then I fiddle around and it
> works, then I clean it up to make it work and it stops again. It’s driving
> me crazy. :-)
>
>
> Any hints on debugging qgis_mapserv.fcgi ?
>
>
> Tom
>
> ___
> 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] failed to add WMS layer

2019-08-02 Per discussione Alessandro Pasotti
On Fri, Aug 2, 2019 at 2:31 PM Andrea Peri  wrote:

> Hi,
>
> I know the network plugin. It help me to understand this bug.
>
> The bug is due to the wms provider that when you click on "add to map"
> button try to read from the cache the capability info.
>
> If te cache is to zero , in old qgis 2.18 the wms provider do another
> request getcapabilities to the wms server to have it.
> Instead in the qgis 3, if the cache if to zero, the request is not saved
> and the read for add to map fail.
>
> I notice this happen with mapserver and geosevrver, instead with
> qgis-server don'.
>
> The only explanation I can do is that for qgis-server it used a differente
> code for provider wms.
>

Which is not the case.

-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] WMS/WMTS layers removed from project if offline

2019-07-28 Per discussione Alessandro Pasotti
On Sat, Jul 27, 2019 at 12:45 PM Patrick Dunford 
wrote:

> Good day
>
> I have three WMS/WMTS layers in my project and if the internet
> connection of my computer is active when I load the project, there is no
> problem with these layers. However if the internet is offline when I
> load the project, the layers are flagged as "missing layers" and are
> removed from the project.
>
> This makes absolutely no sense in the project. The missing layers dialog
> to me is one that comes up when the files that store the layers are
> physically not present on my computer. In this case, the details of
> these WMS/WMTS layers are stored in the project file, so they are not
> physically missing from the project. Whether there is an accessible
> internet connection to the layer should not actually matter unless I
> tried to display the layers.
>
> I don't know how to stop this problem from happening but I don't want to
> have to have two different versions of my project in case there might
> not be an internet connection available when I am using my laptop
> somewhere.
>
>
>From QGIS perspective they are broken layers, because they cannot be loaded.

What happens if you choose to keep them in the project when the bad layers
handler dialog appears?

-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] failed to add WMS layer

2019-07-25 Per discussione Alessandro Pasotti
On Thu, Jul 25, 2019 at 12:34 PM Manuel Fernandez 
wrote:

> Hi, everyone. I have a problem
> When adding a WMS layer, I get this error:
> Capabilities could not be downloaded: Capabilities download failed:
> Connection closed.
> It used to work.
>

Can you provide the WMS address?

BTW, I've recently hit a similar issues and it ended up being an upstream
QT issue: https://bugreports.qt.io/browse/QTBUG-76821




> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Using QgsAuthManager

2019-07-24 Per discussione Alessandro Pasotti
Hi,

you may try this nice plugin from Richard:
http://plugins.qgis.org/plugins/qgisnetworklogger/

On Wed, Jul 24, 2019 at 2:19 PM Paul Wittle <
paul.wit...@dorsetcouncil.gov.uk> wrote:

> Hi,
>
>
>
> I’m trying to use python to assign an authentication configuration to a
> WMS layers that I’m adding. I have been using the following guide
> https://docs.qgis.org/3.4/en/docs/pyqgis_developer_cookbook/authentication.html#leave-authcfg-expansion-to-qgsauthmanager
> .
>
>
>
> I had to update a few bits as I think some of the code maybe a little out
> of date but I managed to get it all working right down to the section I’ve
> linked to.
>
>
>
> The line  “rlayer = QgsRasterLayer(quri.encodedUri(), 'states', 'wms')”
> was resulting in an unexpected type error as encodedUri returns a
> QByteArray rather than a string but I just wrapped it in
> str(quri.encodedUri()) and that now returns as a string.
>
>
>
> The only trouble is that the getCapabilities statement fails and no layer
> is added.
>
>
>
> Does anyone know how I can see whether the AuthManager attempted to expand
> the authcfg and send credentials as I suspect it didn’t in my case?
>
>
>
> Sorry if this email is too much along the developer lines for this mailing
> list but it is only plugin development rather than actual development of
> the application itself so I thought I’d try my luck.
>
>
>
> Thanks,
>
> Paul
> This e-mail and any files transmitted with it are intended solely for the
> use of the individual or entity to whom they are addressed. It may contain
> unclassified but sensitive or protectively marked material and should be
> handled accordingly. Unless you are the named addressee (or authorised to
> receive it for the addressee) you may not copy or use it, or disclose it to
> anyone else. If you have received this transmission in error please notify
> the sender immediately. All traffic may be subject to recording and/or
> monitoring in accordance with relevant legislation. Any views expressed in
> this message are those of the individual sender, except where the sender
> specifies and with authority, states them to be the views of Dorset
> Council. Dorset Council does not accept service of documents by fax or
> other electronic means. Virus checking: Whilst all reasonable steps have
> been taken to ensure that this electronic communication and its attachments
> whether encoded, encrypted or otherwise supplied are free from computer
> viruses, Dorset Council accepts no liability in respect of any loss, cost,
> damage or expense suffered as a result of accessing this message or any of
> its attachments. For information on how Dorset Council processes your
> information, please see www.dorsetcouncil.gov.uk/416433
> ___
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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] Not valid data source on wms layer access for QGIS 3.8

2019-07-05 Per discussione Alessandro Pasotti
On Fri, Jul 5, 2019 at 8:13 AM Andrea Peri  wrote:

> Hi,
>
> I have trouble using our wms services with QGIS 3.8.
>
> As example:
> our url:
> http://www502.regione.toscana.it/ows_ofc/com.rt.wms.RTmap/wms?map=owsofc
>
> When I try to add it to a map canvas the connection return le list of
> layer .
> Choosing one and using the EPSG:3003.
> When Add to the canvas I see an error NOT VALID DATA SOURCE.
>
> The same steps instead work correctly with the old QGIS 2.18.
>
> Is this confirmed from some other one ?
>


Works for me on master.


-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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

  1   2   3   >