Re: [Qgis-user] Qgis/Postgis : Disable double authentication request?

2021-12-02 Thread Frank Broniewski 

Hi Laurent,

how do you authenticate against the PostGIS database? Do you use the 
Authentication manager? Then you might run into the same questions I 
asked last week, you might want to do a search on the mailing lists 
archive to see the answers I received on that topic.


In any case, if you use the authentication manager, the connection 
credetials to the PostGIS database are stored with a unique ID which is 
then in turn used in the layers connection string for reference. SInce 
this ID is different for each user, you run into the problem you 
encountered.


So, basically you have two options here:

* create an authentication entry with the same ID on each machine

* use PostgreSQL service files to connect to the database

The QGIS manual has a nice round up on the topic, you can find the 
related parts here 
https://docs.qgis.org/3.16/en/docs/user_manual/managing_data_source/opening_data.html?highlight=authentication#database-related-tools


HTH,

Frank

Am 01.12.21 um 15:55 schrieb celati Laurent:

Good afternoon,

I work on windows with qgis 3.16.6 and postgresql/postgis.
I have shared a qgis project to several users. The layers are postgis 
tables. For some time, whenever an user opens the project, it has been 
constantly asked for a double authentication (id / pswd).
Would somebody knows why and how to make so that there is as before a 
single request for authentication?


I paste below the header of my qgs project opened with a text editor; 
confidential content is replaced by X :


|http://mrcc.com/qgis.dtd' 'SYSTEM'> saveDateTime="2021-11-25T15:26:51" saveUser="XX" 
version="3.16.6-Hannover" saveUserFull="XXX" projectname=""> 
   
 |





Thanks a lot.

___
Qgis-user mailing list
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] raster area in vector

2021-12-02 Thread Eddison Araya 
[image: image.png]

Hello, I have two maps:

1 raster
1 vector

I want to have a map 3 where it tells me the following:

In the vector buffer area, which category of the raster is the most
according to the area.

I hope I have made sense of it.

Thanks

Eddison
___
Qgis-user mailing list
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] MapInfo export issue

2021-12-02 Thread Bo Victor Thomsen 

Hi Paul -

It's maybe not pertinent to case but I tried to export a Postgres-based 
layer to both the MapInfo MIF and Tab file-formats and showing the 
layers afterwards in QGIS - but using QGIS v. *3.22* on Windows 10. It 
worked perfectly.


I checked the first part of the generated MIF text file. It looked fine 
and contained all the necessary parts in the header : version info, 
projection info and data structure info.


Regarding your MapInfo error when reading  MIF/MID: It is probably 
caused by the MIF-file is missing  "Version 300" as the first line - 
causing the MapInfo interpreter to look after it until it find the first 
"Region"  definition in the file (MapInfo speak for polygon).  Why, I 
don't know... But QGIS v. 3.16 is a strange beast.


Did you check if the projection was correctly set in the "Save features 
as" dialog before exporting the data ?



Med venlig hilsen / Kind regards

Bo Victor Thomsen

Den 01-12-2021 kl. 18:04 skrev Paul Wittle:


Hi,

I’ve tried exporting to MIF instead of a tab file and it generates an 
error of “Found [region] while searching for [version]” when you try 
to load it into the MapInfo. The output is also creating an error when 
QGIS tries to load the data as well although I’m not sure if QGIS 
could ever directly load MIF files.


The main issue is that if you save to TAB and select “Add saved file 
to map” it draws in a different place. This feels a bit wrong to me.


In any case we are trying to get people to upgrade to the latest 
version of MapInfo so GeoPackage is supported. I will just advise our 
users to export to GeoPackage instead and use that as the main data 
sharing format instead.


Thanks for all the tips and suggestions though.

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/data-protection


___
Qgis-user mailing list
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] MapInfo export issue

2021-12-02 Thread Paul Wittle 
Morning,

That tool seems to be saving as I would have expected thank you for the tip 

I’ve told the users to use that tool instead of right click > export for now.

Cheers,
Paul

From: Richard Greenwood 
Sent: 02 December 2021 00:37
To: Nicolas Cadieux 
Cc: Paul Wittle ; qgis-user 

Subject: Re: [Qgis-user] MapInfo export issue

I don't know if this is related or helpful, but GDAL 3.0 doesn't produce 
MapInfo TAB files with the correct coordinate system when the coordinate system 
is in feet. GDAL 3.3 and 3.4 do work.

A suggestion would be to install GDAL 3.3 or 3.4 and use
ogr2ogr -f "MapInfo file" dest source

On Wed, Dec 1, 2021 at 10:41 AM Nicolas Cadieux 
mailto:njacadieux.git...@gmail.com>> wrote:
Hi,

If you send us a simple file (the original, the tab and mid mif version you 
created),  we could test on other versions of QGIS.  If you do this make sure 
we can correctly identify the proper location.  Use something like the outline 
of a building that we can find using Google earth as background image.
Nicolas Cadieux
https://gitlab.com/njacadieux


Le 1 déc. 2021 à 12:05, Paul Wittle 
mailto:paul.wit...@dorsetcouncil.gov.uk>> a 
écrit :

Hi,

I’ve tried exporting to MIF instead of a tab file and it generates an error of 
“Found [region] while searching for [version]” when you try to load it into the 
MapInfo. The output is also creating an error when QGIS tries to load the data 
as well although I’m not sure if QGIS could ever directly load MIF files.

The main issue is that if you save to TAB and select “Add saved file to map” it 
draws in a different place. This feels a bit wrong to me.

In any case we are trying to get people to upgrade to the latest version of 
MapInfo so GeoPackage is supported. I will just advise our users to export to 
GeoPackage instead and use that as the main data sharing format instead.

Thanks for all the tips and suggestions though.

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/data-protection
 ___
Qgis-user mailing list
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


--
Richard W. Greenwood
www.greenwoodmap.com
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,

Re: [Qgis-user] QGIS: Export Metadata from postgis tables to shp?

2021-12-02 Thread Etienne Trimaille 
Hi,

>From the PgMetadata plugin, you can export a single metadata sheet to PDF,
HTML or DCAT. You can also export your full catalog (the last button in the
dock, then you can "save as" your new layer).
It's possible to improve the PgMetadata plugin by saving the layer metadata
when the user is clicking "save as" on a layer which is stored in
postgresql.
PgMetadata is a "small" PG schema, so it's easy to extract information we
need.

How to retrieve data from PgMetadata in another application :
https://docs.3liz.org/qgis-pgmetadata-plugin/user-guide/advanced/

The database schema :
https://docs.3liz.org/qgis-pgmetadata-plugin/database/relationships.html

Le mer. 1 déc. 2021 à 21:28, celati Laurent  a
écrit :

> Thanks a lot for your really usefull reply.
> I just make a try and it works well.
> Now, i have to make a test/check with metadata produced with the plugin
> pgmetadata.
>
>
> Le mer. 1 déc. 2021 à 16:52, DelazJ  a écrit :
>
>> Hi Laurent,
>>
>> Starting from 3.20, you may want to test
>> https://qgis.org/en/site/forusers/visualchangelog320/index.html#feature-persist-layer-metadata-in-vector-file-exports
>> if I understand your need.
>>
>> Regards,
>> Harrissou
>>
>> Le mer. 1 déc. 2021 à 16:16, celati Laurent  a
>> écrit :
>>
>>> Good afternoon,
>>>
>>> With qgis, the description of a data seems to be available for filling
>>> and consultation via the 'information' and 'metadata' tabs in "LAYER
>>> PROPERTIES". There seem to be bridges between postgis and qgis. For
>>> example, when I fill the "Comment" field of a table with pgadmin, the
>>> content of the description is visible with qgis in the "Information" menu
>>> in the Comment line and in the Abstract line. The description is also
>>> visible in the "Metadata" menu in the Summary section / Identification tab.
>>>
>>> For some postgis tables, I have also described the data thanks to the
>>> usefull Pgmetadata plugin.
>>>
>>> My need would be to be able to export these different data descriptions
>>> during exports from these postgis tables toward files in shp format for
>>> example. That these descriptions be kept during the export. Is it possible?
>>> If yes, which tools / resources would exist?
>>>
>>> Thanks a lot.
>>> ___
>>> Qgis-user mailing list
>>> 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