[Qgis-user] QGIS action to run a command in a terminal window on Windows

[Brent Wood via QGIS-User]

Hi,

I'm trying to create an action to run an SQL on a spatialite database & show 
the result as a QGIS action.

In Linux this works by running a script in an xterm, but I can't work out how 
to do something similar under widows.

Any suggestions?

Thanks

Brent Wood

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

From: QGIS-User  on behalf of Brent Wood via 
QGIS-User 
Sent: Wednesday, March 6, 2024 09:33
To: 'Qgis-user@lists.osgeo.org' 
Cc: Nyall Dawson 
Subject: [Qgis-user] Problem: Can't open Spatialite tables in QGIS on Windows

Hi,

We have been using QGIS & Spatialite for years and have recently encountered a 
problem in QGIS under Windows.

We connect to a spatialite database fine, we can list the tables, but when we 
try to open them we get an error:
db <...> table <...> is an invalid layer - not loaded (this is also written to 
the log)

I can open the db in DBManager and enter the query "select * from t_transect;" 
which runs & shows the data in the output pane.
When I try to load the layer as a map layer I get an error message referring me 
to the error log, but the log is empty.

This is using QGIS 3.34.1 on Windows.

The same database file works perfectly on Linux, with QGIS v3.34.3. A colleague 
has tried this & v3.36 on Windows with the same problem. The databases are 
generated with echo sounder data by the ESP3 application, and we have been able 
to use these in QGIS for years without problems until now.

Spatialite access the tables fine, the basic metadata is present:
select * from geometry_columns;
t_transect|geom_col|1|2|4326|0
t_echoint_transect_1d|geom_col|1|2|4326|0

The QGIS error message is not particularly helpful in determining the problem. 
Our workaround is to run the SQL we would have run in the QGIS database manager 
directly from the spatialite command line, exported to CSV & then open the CSV 
in QGIS, which works, but is not ideal.

For some context about these data:  The figure shows each "ping" from the echo 
sounder, scaled by the magnitude of the echo from fish, showing the location 
and density of fish encountered on each transect (ESP3 is used for the acoustic 
analysis). This dataset was from surveying a hill off the west coast of New 
Zealand (generated on Linux!).

[cid:d8335c55-7ad0-42bf-a514-c2ff56fc3815]
Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 
<https://www.niwa.co.nz/>
Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
+64-4-386-0529

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz<https://www.niwa.co.nz/> 
Facebook<https://www.facebook.com/nzniwa> 
LinkedIn<https://www.linkedin.com/company/niwa> 
Twitter<https://twitter.com/niwa_nz> 
Instagram<https://www.instagram.com/niwa_science> 
YouTube<https://www.youtube.com/channel/UCJ-j3MLMg1H59Ak2UaNLL3A>
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems.
Note: This email is intended solely for the use of the addressee and may 
contain information that is confidential or subject to legal professional 
privilege. If you receive this email in error please immediately notify the 
sender and delete the email.
___
QGIS-User mailing list
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] Adding virtual X & Y columns to a QGIS attribute form

[Brent Wood via QGIS-User]

Hi,

I have created an attribute form for a QGIS layer.

I want to add two fields to the form: the X & Y values of a point geometry 
column.

I can't find any way to do this - if I don't use the form, it is easy to add 
the virtual columns as expressions ($x & $y) in the table view, but I want 
these in the form view, not the table view.


Any suggestions appreciated.

Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram 
YouTube
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems.
Note: This email is intended solely for the use of the addressee and may 
contain information that is confidential or subject to legal professional 
privilege. If you receive this email in error please immediately notify the 
sender and delete the email.
___
QGIS-User mailing list
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] Adding a Web map to QGIS

[Brent Wood via QGIS-User]

Hi Krishna,

Can you not ask them to turn on the WFS service in their ARC setup? Unless, 
like many govt agencies, they just ignore users requests. Sigh.

Another option is to look for the data you want in data.gov. I have found that 
govt agencies often have strange & limited access to their data in-house, but 
also provide their data to data.gov, where it is more accessible.


Brent Wood

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


From: QGIS-User  on behalf of Emma Hain via 
QGIS-User 
Sent: Tuesday, March 12, 2024 12:21
To: krishna Ayyala 
Cc: qgis-user 
Subject: Re: [Qgis-user] Adding a Web map to QGIS

Hi Krishna
It looks like it is coming from the FCC Broadband 
Service
 so you can sift through their data and find what you need and link to it via 
your browser. It looks like the data is more in Tables so will need to play 
with them and link them into the Block Groups I think.
I saw this stack overflow about it as well : 
https://stackoverflow.com/questions/77629483/is-the-fcc-national-broadband-map-api-endpoint-working
Cheers
Em

On Sat, 9 Mar 2024 at 04:20, krishna Ayyala via QGIS-User 
mailto:qgis-user@lists.osgeo.org>> wrote:
Hello,
Is there any way that I can add this map to QGIS? I already wrote to the OK 
broadband office requesting the source data and did not hear back from them. I 
am pasting below the weblink.

OK Broadband 
Map

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


--
Emma Hain — Product Manager/Senior GIS Analyst
e...@north-road.com
[https://north-road.com]
North Road
Cartography • Development • Spatial Analysis

north-road.com
[https://ci3.googleusercontent.com/mail-sig/AIorK4xbsQ72BNIM2cWMZcuEKVer1Bwaq_gqYkdbtrjK2ifrqv-4o7aWjcvilgYXtNGpXLNgD00xgmQ][https://ci3.googleusercontent.com/mail-sig/AIorK4zEBWGJKio8gqmFT0h_51t4ZnmoGgbmV7SeL-4FKvwWApFWDWyK7p-c0-cSskUe7pjQzjEZj9Q][https://ci3.googleusercontent.com/mail-sig/AIorK4wlMciFPm8hqQZB_Qi57PUCv1dJqUC1A2i9qEMzWRFLcJ7Jil30YnULdJLxT6-qMfI6J4kcac4]
[https://womenindigital.org/wp-content/uploads/2023/03/WID-Membership-Badge.jpg]
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram 
YouTube
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems.
Note: This email is intended solely for the use of the addressee and may 
contain information that is confidential or subject to legal professional 
privilege. If you receive this email in error please immediately notify the 
sender and delete the email.
___
QGIS-User mailing list
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] Problem: Can't open Spatialite tables in QGIS on Windows

[Brent Wood via QGIS-User]

Hi,

We have been using QGIS & Spatialite for years and have recently encountered a 
problem in QGIS under Windows.

We connect to a spatialite database fine, we can list the tables, but when we 
try to open them we get an error:
db <...> table <...> is an invalid layer - not loaded (this is also written to 
the log)

I can open the db in DBManager and enter the query "select * from t_transect;" 
which runs & shows the data in the output pane.
When I try to load the layer as a map layer I get an error message referring me 
to the error log, but the log is empty.

This is using QGIS 3.34.1 on Windows.

The same database file works perfectly on Linux, with QGIS v3.34.3. A colleague 
has tried this & v3.36 on Windows with the same problem. The databases are 
generated with echo sounder data by the ESP3 application, and we have been able 
to use these in QGIS for years without problems until now.

Spatialite access the tables fine, the basic metadata is present:
select * from geometry_columns;
t_transect|geom_col|1|2|4326|0
t_echoint_transect_1d|geom_col|1|2|4326|0

The QGIS error message is not particularly helpful in determining the problem. 
Our workaround is to run the SQL we would have run in the QGIS database manager 
directly from the spatialite command line, exported to CSV & then open the CSV 
in QGIS, which works, but is not ideal.

For some context about these data:  The figure shows each "ping" from the echo 
sounder, scaled by the magnitude of the echo from fish, showing the location 
and density of fish encountered on each transect (ESP3 is used for the acoustic 
analysis). This dataset was from surveying a hill off the west coast of New 
Zealand (generated on Linux!).

[cid:d8335c55-7ad0-42bf-a514-c2ff56fc3815]
Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram 
YouTube
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems.
Note: This email is intended solely for the use of the addressee and may 
contain information that is confidential or subject to legal professional 
privilege. If you receive this email in error please immediately notify the 
sender and delete the email.
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] QGIS unable to access Spatialite tables.

[Brent Wood via QGIS-User]

Hi,

I and a few colleagues are encountering a problem accessing Spatialite tables 
from QGIS.
It does not seem to be happening with v3.28, but it is with v3.34 (in both 
Linux & Windows).

When opening a table in v2.8 there are no issues, everything is working as it 
has in recent years.
However, opening the same table (or an SQL on that table) results in an error 
message about an invalid layer, but no further or useful diagnostic info.

Can anyone suggest a possible cause or solution? My current workaround is to 
run the select in the Spatialite command line tool, with the geometry exported 
as WKT & then open the text file in QGIS.

At present I'm still trying to get access to the QGIS issues facility to log 
this problem, so cannot raise this there at present.



Thanks...

  Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram 
YouTube
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems.
Note: This email is intended solely for the use of the addressee and may 
contain information that is confidential or subject to legal professional 
privilege. If you receive this email in error please immediately notify the 
sender and delete the email.
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] QGIS/spatialite issue - invalid layers

[Brent Wood via QGIS-User]

Hi,

I have created an empty spatialite database with QGIS via the browser.

Running Mint Linux with QGIS:

3.34.1-Prizren

QGIS code revision

133927424d9



I create a spatialite table (in spatialite) & add some point data (EPSG 4326 - 
column is called "geom"). This opens fine in QGIS.

I add another geometry column to the table (point, epsg:3994)  & populate it 
with:
  update station set geom_3994= transform(geom,3994);

This appears fine in spatialite, but QGIS tells me it is an invalid layer, but 
nothing about why...

I have been doing this sort of stuff for years & not encountered this before.

Can anyone help me sort out why QGIS regards the data as invalid, & how to fix 
this?


Thanks

Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram 
YouTube
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems.
Note: This email is intended solely for the use of the addressee and may 
contain information that is confidential or subject to legal professional 
privilege. If you receive this email in error please immediately notify the 
sender and delete the email.
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] QGIS attribute forms question

[Brent Wood via QGIS-User]

Hi,

I have created some forms for data entry/edit using QGIS.

I have successfully exported them & imported them to apply in different 
computers with QGIS.

It can take several hours to create such a form where there are 80+ columns in 
the underlying database table,

I now have the situation where the underlying table needs columns added or 
removed.

QGIS will not apply a saved form to a layer unless the structure is identical.


How can I reuse a form for a layer representing a database table with (say) a 
single new column, by adding the new column to the form, rather than manually 
creating the whole form from scratch?


Thanks

Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram 
YouTube
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems.
Note: This email is intended solely for the use of the addressee and may 
contain information that is confidential or subject to legal professional 
privilege. If you receive this email in error please immediately notify the 
sender and delete the email.
___
QGIS-User mailing list
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] Null value issue in attribute form

[Brent Wood via QGIS-User]

Hi,

I have a database table which has an attribute form built for data entry, in 
QGIS 3.34.

There is a text field "station_code"
It is set to not null & enforce not null in the form.

If the default value is null (empty) the form includes the default text 'NULL'.
Any text entered in the form is then appended to the string 'NULL', which is 
NOT what I want to happen. This behaviour requires the user to delete the 4 
chars 'NULL' every time they enter some data, before typing in the value, which 
is something of an inconvenience, and leads to data errors.

If I set the default value in the form to '' (empty string), then the field is 
populated with this by default, and data entry works as I want, however, as 
this value is not null, the record can be saved without a value being entered, 
so the not null requirement is essentially useless.

Is there a way to set the form up to have a "not null" constraint applied in 
the form, without having QGIS pre-populate the field in the form with the 
string 'NULL'?
It works for integer types, the form has an italicised 'NULL' but this does NOT 
form part of the value in the field, unlike the string field.


Thanks

Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram 
YouTube
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems.
Note: This email is intended solely for the use of the addressee and may 
contain information that is confidential or subject to legal professional 
privilege. If you receive this email in error please immediately notify the 
sender and delete the email.
___
QGIS-User mailing list
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 can I center a world map cylindric projection over the Pacific Ocean?

[Brent Wood via QGIS-User]

Create a custom projection (CRS) with the parameters you want.

>From the main menu
Settings -> Custom projections


Find one that is close to what you want, paste it here & edit to your 
preferences



Brent Wood

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

From: QGIS-User  on behalf of JOE LEMONNIER 
via QGIS-User 
Sent: Saturday, April 29, 2023 10:41
To: qgis-user@lists.osgeo.org 
Subject: [Qgis-user] How can I center a world map cylindric projection over the 
Pacific Ocean?

Ideally, I would like to be able to change the center of projection for 
Cylindric as well as Pseudo-cylindric projections to center a world map over 
the meridian of my choice. Is there a simple way to do this? Please advise.

Thanks in advance,

Joe
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: 
https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user=05%7C01%7Cbrent.wood%40niwa.co.nz%7Ca29eedde7a0647faf76f08db483a8f24%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C638183188585068690%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=I6w6i0D90Bq2DUKJ7keHsWuZp6WCzkncX%2Bud%2FI0PCh0%3D=0
Unsubscribe: 
https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user=05%7C01%7Cbrent.wood%40niwa.co.nz%7Ca29eedde7a0647faf76f08db483a8f24%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C638183188585068690%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=I6w6i0D90Bq2DUKJ7keHsWuZp6WCzkncX%2Bud%2FI0PCh0%3D=0
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Post Cyclone Gabrielle aerial imagery for Hawkes Bay, New Zealand

[Brent Wood via QGIS-User]

This might interest QGIS-ers...

The LINZ (Land Information New Zealand) Data plugin ( allows users to connect 
to the LINZ Data Service WMTS services.
(https://www.linz.govt.nz/guidance/data-service/using-linz-data-importer-plugin-qgis,
 https://plugins.qgis.org/plugins/linz-data-importer/)

Since the cyclone the river valleys which were worst affected have been flown 
and the resulting map imagery made available by LINZ:
https://data.linz.govt.nz/layer/112726-hawkes-bay-010m-cyclone-gabrielle-aerial-photos-2023/

I'm using this with QField on a smartphone (Android) for field sampling 
sediment deposits - seems to work well.


Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] transferring data from ArcGis to QGIS

[Brent Wood via QGIS-User]

Hi Janet,

See https://north-road.com/slyr/

There is a free community version and a commercial one if you need the extra 
functionality.




Brent Wood

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


From: QGIS-User  on behalf of Janet via 
QGIS-User 
Sent: Friday, January 20, 2023 10:20
To: qgis-user@lists.osgeo.org 
Subject: [Qgis-user] transferring data from ArcGis to QGIS

For a number of years, whilst a student and on the staff of University I have 
used ArcGis.  After this year I will be retiring from University and losing 
this access.  I would like to copy all my work over to QGIS, so that I can 
continue my research, could you let me know if this is possible and where I can 
locate directions to do it.  I have all my work on an external hard drive.

Many thanks

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

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] QGIS & GPS

[Brent Wood via QGIS-User]

Gidday and Happy New Year from New Zealand!

I have spent too many hours on this already, sigh... Hopefully someone can help.

I normally use QGIS with USB GPS units on Linux and don't have driver issues, 
everything just works. But I now need to re-introduce myself to QGIS on Windows 
to set things up for other users, and it is proving very painful.

I'm using QGIS dev (3.29), 3.22 & v3.28 at present. Same issue on Windows with 
all of them.

I have historically used a Globalsat BR-355S4 USB GPS on Windows with no 
problems. Just install the Prolific USB-serial driver and everything works fine.

My recent Linux work has been using a G-Mouse (U-blox 7) chipset GPS which 
Linux typically mounts as /dev/ttyACM0 and QGIS is fine with that. Linux needs 
no additional drivers to be installed for this to work.

Now I'm trying to get this working on Windows... I can install the U-blox VCP 
(virtual com port) driver. The native driver Win10 finds & installs also  seems 
to work, but not with QGIS. I can connect to the relevant com port with several 
GPS monitoring applications & see the NMEA sentences fine. QGIS lists the port 
OK, but fails to connect on auto or to the port directly. This is not uncommon 
with the U-Blox 7, but none of the fixes I have found online have worked for me.

I just bought another GPS, a new model Globalsat one, BU-353N5, a replacement 
for the BR-355S4. This is not sending the $GP sentences, just the $GN ones. My 
GPS monitoring applications work OK with this on Linux & Windows, but QGIS on 
both platforms lists the device to connect to, but is unable to connect & use 
the GPS data. I can't even log the data with QGIS as QGIS won't connect to the 
port in the first place.

My 3 questions:

How can I get a U-Blox7 chipset GPS (which is working fine on Windows with 
other applications) recognised by and working with QGIS?

How can I get a  Globalsat  BU-353N or other GPS that does not output $GPGGA or 
$GPRWC, but provides $GNGGA instead, etc working with QGIS?

Can anyone suggest an alternative cheap, generic USB GPS which simply and 
reliably works with QGIS on Windows?

Is this something that I should file a bug report for (it does seem to be a 
fragility in QGIS that is not present in other GPS software)? I'm happy to send 
a working USB GPS to any dev willing to look into this.


Thanks

Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] The license agreement of QGIS

[Brent Wood via QGIS-User]

The full licence is described here:
https://docs.qgis.org/3.22/en/docs/user_manual/appendices/GNU_GPL.html

Essentially it means you can install and use QGIS anywhere you want for 
whatever the cost of downloading it might be (usually free). You can be an 
individual, government agency, commercial business, etc., that doesn't matter.

Note that if you do change the source code to provide some functionality that 
you require, the licence requires you to make your enhancements available under 
the same licence.

Cheers,

Brent Wood


From: QGIS-User  on behalf of Paco Lui via 
QGIS-User 
Sent: Thursday, December 8, 2022 16:01
To: qgis-user@lists.osgeo.org 
Subject: [Qgis-user] The license agreement of QGIS

Dear sir/madam,

I , on behalf of, Hong Kong Government, to ask some question about the license 
agreement for QGIS, our Division want to install the QGIS software for work 
purpose and I want to ask that need our division buys a license or it is free? 
thanks.

Best Regards,
Mr. Paco Lui
System Analyst1/TECH
Survey Division, Highways Department, Hong Kong Government
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Proj DB version conflict

[Brent Wood via Qgis-user]

Hi,

I have a problem working with QGIS, Spatialite, R (sf package), and Postgis on 
Linux (Mint/Ubuntu)

I cannot find versions of these applications that all share a common version of 
proj.db, and I cannot find a way to have a separate proj.db for each 
application.

Any suggestions?


Thanks

Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Watershed - Catchment area upstream of a point

[Brent Wood via Qgis-user]

Hi Tony,

Just wondering

If QGIS is using SAGA to do the work, have you considered installing SAGA & 
using it directly?

Brent Wood

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

From: Qgis-user  on behalf of Tony Shepherd 
(FarmMaps NZ) via Qgis-user 
Sent: Wednesday, November 9, 2022 11:04
To: 'Qgis Users List' 
Subject: [Qgis-user] Watershed - Catchment area upstream of a point


Hi All



I’m wanting to use a DEM/DTM to automatically map the watershed/catchment area 
upstream of a known point.



After a bit of reading, this appears to be a not-so-simple task but suggestions 
are to use the “Upslope Area” algorithm.



In my case, the program fails to finish running, and the message window shows 
the following error:

 SAGA Version: 7.8.2 (64 bit)
 Error: tool needs graphical user interface [Upslope Area]

 C:\Users\Tony\Documents>exit



Questions:

  *   Does anybody know what that error means?
  *   Is there another tool/method that is preferable to use?



Cheers

Tony



Tony Shepherd  |  GeoSpatial / Mapping Manager



Ph 027 435 6193  |  E t...@farmmaps.nz  |  W 
shepherdphotos.co.nz



[FM_logo1_small (Custom)]





[cid:image002.png@01D8F428.6B14E3F0]



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

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] [QGIS-Developer] Model for Temporal Measurement (vector) Datasets ?

[Brent Wood via Qgis-user]

Hi Richard,

I think the underlying issue here is that QGIS does not do data management... 
It just accesses data (whether not managed, managed or mismanaged).

You are correct, the traditional GIS model of a feature with attributes does 
not map to the real world very well in many use cases, and timeseries data is 
one. GIS is seldom used to manage data these days, with very powerful spatially 
enabled databases readily available. To use your IOT approach where location is 
just an attribute, in a relational db, the location IS just another attribute. 
Unlike the GIS model, where the spatial feature is somehow different, here it 
isn't. A record can have multiple geometries, times, dates, strings, numerics, 
etc... like start time, end time, start location, end location, trackline 
between them, if you want... impossible without nasty hacks in a GIS centric 
data store.

So you have a pretty standard situation where you have a set of sites where 
data is captured in an ongoing basis.

I have designed Postgis databases to do this... most recently, when 
Postgres/Postgis was staring to slow down a bit with 600,000,000 readings I 
moved to Postgres/Postgis/TimescaleDB which is returning typical query results 
in 10's of milliseconds with 4 billion readings.

You don't just have sites with readings, you have sites, sensors, calibrations, 
instruments, readings, personnel, etc... there is a whole lot of metadata/data 
pertaining to your setup that should probably be managed in a database. I don't 
know if you will have enough data to justify using TimescaleDB, but you should 
be using some sort of db to manage your data effectively & efficiently. And 
Postgis/Postgres is a hard combination to beat as a tool for doing this well.

Then you point QGIS at your database for the mapping, cartography, 
visualisation, etc. You can use database views to simplify queries, but there 
are issues with QGIS and views. I find using the QGIS DB manager with a query 
instantiated as a QGIS layer works much better than accessing a view in many 
cases.

And for an alternative mapping of IOT data to a data model, the Object 
Relational approach provided by Postgres supports non-relational structures 
like key/value (hstore) or jsonb data storage.


52North have a (somewhat complex) Postgis database design to provide a data 
store for their SOS (Sensor Observation Service) software. Perhaps overkill for 
your use case, but a very complete and robust solution. See: 
https://www.researchgate.net/figure/The-52-North-SOS-schema_fig14_327124727


Hope this helps, there are certainly effective ways to do what you want out 
there.


Cheers

Brent Wood

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



On 2 Sep 2022, at 13:07, Richard Duivenvoorde via QGIS-Developer 
 wrote:

Hi All,

Anybody is aware of a model in which data owns a location, but THAT location 
has a (growing) set of [timestamp, value] observation data to it

In GIS/QGIS everything is tabular (talking about vector here, I know meshes can 
have more shapes).

But in the IOT world the 'location' is 'just an attribute', and the 'other' 
data is actually more of interest (and growing in time).

Currently to view measurements, 'we' often replicate the location for every 
value/measurement: we create a 'Feature' for every time step (eg for example 
via a WFS)

The OGC has a SensorThingsApi (STA) standard, in which for given location you 
can request all values/observations (of filter a certain sensortype/parameter). 
So one geometry has a full table of data to it.

BUT to 'work' with that data in QGIS, you always have to 'flatten' it, one way 
or another, (I think), for every time step: create a feature with: location, 
time, value...

My Question:

- isn't there some model (or can we come up with one) in which a location can 
actually have a range of time/value data (like some table join like), and when 
you use the Temporal Controller, you style your layer by RE-using the one 
location, but getting the value for current Timestamp (in the TimeController). 
Some sort of indirect filtering?

- or is this the mesh model (I know netcdf's in which you have often predefined 
meshes/location and the data/time vector is growing)?
And would a solution be to have some kind of in memory vector -> mesh loader or 
so???

I hope this makes sense to others. Any input appreciated.

Regards,

Richard Duivenvoorde

PS, if you want to play with SensorThingsApi:
- install: https://github.com/AirBreak-UIA/SensorThingsAPI_QGIS-plugin
- connect it to: 
https://airquality-frost.k8s.ilt-dmz.iosb.fraunhofer.de/v1.1/Locations
(around 5000 location and 500-million 'observations')
- load all locations in one layer, and click on a location
My point: the data is then viewable/selectable by table and graph, but NOT 
loadable in a sense way (yet) in QGIS...
___
QGIS-Developer mailing list

[Qgis-user] Replay GPS data

[Brent Wood via Qgis-user]

Hi,

I have a log file of GPS NMEA messages captured during a survey.

I'm working with QGIS for real time data capture during these surveys.

For demo/training/dev purposes I'd like to pass the file of GPS messages into 
QGIS via teh GPS panel to simulate the real world survey.

Any suggestions as to how I can do this (running on Linux at present)??

I've tried gpsfake with gpsd but just run into network/port errors I can't 
resolve. I can uset netcat -l to listen then send the NMEA messages via netcat 
using a bash script, but can't see how to get netcat to work with QGIS as a 
listener.


Any advice appreciated!

Thanks

Brent Wood

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

From: Qgis-user  on behalf of Nyall Dawson 
via Qgis-user 
Sent: Tuesday, July 12, 2022 13:08
To: Piet 
Cc: qgis-user 
Subject: Re: [Qgis-user] Qgis 3.22.8 Error messages displayed in the GUI

On Mon, 11 Jul 2022 at 21:40, Piet via Qgis-user
 wrote:
>
> Dear List,
>
> I used a selfcompiled Qgis, build with 'Debug-Option' set in ccmake.
>
> Now there's a small red window in the main window which displayed 
> errors/warning.
>
> In my case "Qt: QXcbConnection: XCB error: 3 (BadWindow), sequence: 65154, 
> resource id: 11286601, major code: 40 (TranslateCoords), minor code: 0",
>
> which seems to be a known QT-Bug.
>
> Can I turn of this error window?

This particular one is now filtered out for 3.26+, as it's not
reflective of a bug in QGIS.

The others still remain, as they likely ARE indicative of something
which needs fixing in QGIS. If you encounter them, you should open
tickets for each so that the underlying cause can be identified.

Nyall

>
> Because it's upset me a bit and I can see the warnings in a console as well.
>
> Thank you for any hint!
>
> Kind regards
>
> Piet
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: 
> https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-userdata=05%7C01%7Cbrent.wood%40niwa.co.nz%7Ca0912e2b56df488e420408da63a31907%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C637931849460706969%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=ns3H5qS%2B0FYP5BVATejnMsFyGGc7%2BTPvKV%2BDicosqZM%3Dreserved=0
> Unsubscribe: 
> https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-userdata=05%7C01%7Cbrent.wood%40niwa.co.nz%7Ca0912e2b56df488e420408da63a31907%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C637931849460706969%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=ns3H5qS%2B0FYP5BVATejnMsFyGGc7%2BTPvKV%2BDicosqZM%3Dreserved=0
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: 
https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-userdata=05%7C01%7Cbrent.wood%40niwa.co.nz%7Ca0912e2b56df488e420408da63a31907%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C637931849460706969%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=ns3H5qS%2B0FYP5BVATejnMsFyGGc7%2BTPvKV%2BDicosqZM%3Dreserved=0
Unsubscribe: 
https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-userdata=05%7C01%7Cbrent.wood%40niwa.co.nz%7Ca0912e2b56df488e420408da63a31907%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C637931849460706969%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=ns3H5qS%2B0FYP5BVATejnMsFyGGc7%2BTPvKV%2BDicosqZM%3Dreserved=0
[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Polar stereographic (0 - 360 longitudes)

[Brent Wood via Qgis-user]

I don't believe you can.

The underlying proj libraries (as used by QGIS) no longer support longitudes > 
180 by default, so any re-projection from EPSG:4326 will only work with +-180 
longitudes.

There isa command line parameter (+over) which can be used with proj on the 
command line but I don't think this is supported by QGIS.

If you use Postgis (or Spatialite), there is an ST_ShiftLongitude() function 
that will switch +-180 to 0-360 or the reverse which makes the operation pretty 
trivial for any sort of geometry.

I have created a custom QGIS/Postgis projection (many years ago) which I 
assigned a code of 4327, this was essentially 4326 in a 0-360 degree space, so 
I could reproject between them, I'm not sure if this is still possible with the 
latest versions of proj with wkt definitions.

Brent Wood

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


From: Qgis-user  on behalf of Lester 
Anderson via Qgis-user 
Sent: Sunday, June 19, 2022 22:16
To: qgis-user@lists.osgeo.org 
Subject: [Qgis-user] Polar stereographic (0 - 360 longitudes)

Hi all,

I have data which is in 0-360 degree longitudes and I would like to apply a 
Polar stereographic projection. However, since the EPSG 3995 has limits of 
-180/+180 for longitude, as expected it gives half the plot.

For some reason I cannot create a custom projection with an extent such as:
xmin=0, xmax=360, ymin=60, ymax=90 based on 3995 even removing reference to 
this ID.

Any ideas how to proceed without having to shift it all to +/- 180

Tested in 3.20 and 3.24

Thanks

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

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] RAM and processing speed requirements for QGIS

[Brent Wood via Qgis-user]

Hi Helena,

My 02c - it totally depends...

QGIS as an application does not require much memory or cpu, until you throw 
data at it and ask it to do something. Your data and tasks determine the 
requirements, not the bare application. I did some benchmarking a while ago - R 
requires up to 8x the memory to load the same vector datasets as QGIS - so at 
least compared to R, QGIS is very memory efficient.

Also - QGIS has no data management capabilities. If you want to manage your 
spatial data on the same computer, you will probably want to install a spatial 
database, which will run in parallel to QGIS. So having the resources to do 
this will help a bit. A dual core cpu is not good for parallel processing - two 
few cores to be efficient.

That said, a reasonable i5 cpu with 8Gb of memory is plenty for basic tasks. 
More is obviously better. An older 2.7Ghz i5 is probably minimal, i7 a bit 
better. Before spending on hardware, try it and see. If your system performs 
well enough for you, that is really all you need to know. If not, fire up the 
system diagnostics & see what your memory & cpu (& possibly disk) bottlenecks 
are to see what you need more of.

Personally, I find the best general purpose platform to install & run QGIS on 
is Linux. If you are into cartography and the Adobe tools to work with 
graphics, then a Mac. Windows only if you don't have a choice.


Cheers

Brent Wood

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


From: Qgis-user  on behalf of Helena Farrell 
via Qgis-user 
Sent: Wednesday, April 20, 2022 06:46
To: qgis-user@lists.osgeo.org 
Subject: [Qgis-user] RAM and processing speed requirements for QGIS

Hello, I am seeking input on whether my 7 year old Mac with 8GB RAM and a 
2.7gigahertz processor is likely to perform poorly at running QGIS. Since these 
are like the bare minimum in terms of power, and I assume QGIS is a data-heavy 
program, I may need to invest in a new computer. Anyone have advice on RAM and 
processing speed specifications  that I should look for and whether a PC be 
better than a Mac for running this program?

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

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

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

[Brent Wood via Qgis-user]

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

Brent Wood

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

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


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

I am using GDAL – Vector Conversion – Convert format

The resulting Tab file is missing the Primary Key field.

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

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



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







Johanna Botman



Assets / GIS Officer – Melton City Council











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

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

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

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user