Re: [Qgis-user] Using Processing for nightly ETL jobs

2024-05-30 Thread Bernhard Ströbl via QGIS-User 
Hi Björn,

yes that works. Only challenge is that you have to tell the algorithm which 
geometry type the data is, whereas QGIS' native PostGIS writer does check that 
for itself and use an appropriate one. Being not able to tell beforehand I 
established a geometry filter and use the multi type in the writer.

Bernhard

> pathmapper  hat am 30.05.2024 09:37 CEST geschrieben:
> 
>  
> Hi Bernhard,
> 
> not sure about the native "Export to PostgreSQL" algorithm, but there's 
> also a GDAL alg "Export to PostgreSQL (new connection)" which allows to 
> configure the DB access. Using this one in your model should do the 
> trick..
> 
> Cheers,
> Björn
> 
> On 30.05.2024 08:47, Bernhard Ströbl via QGIS-User wrote:
> > Hello everybody,
> > 
> > I did some experiments in the last couple days and your help was very
> > valuable. I succeeded in creating two models that - when run within
> > QGIS or from the console - download data of different types and write
> > it into a PostgreSQL database. For automation purposes I want to run
> > my models on a Linux server. I am wondering how I would configure the
> > database access. The algorythm "Export to PostgreSQL" takes the
> > connection name as input. The connection name is the name of a
> > pg-connection configured using the GUI (and backed by a saved
> > authentication in this case). There will be no GUI (and probably no
> > graphic server either) on the server machine. Does anybody know if
> > creating a profile with the connection (without authentication) and
> > placing that as default profile in the home directory of the user
> > running the model will do the trick? Or would I need a different
> > approach?
> > I cannot try it out because currently I still have no access to the 
> > server.
> > 
> > Any help appreciated
> > Bernhard
> > 
> > 
> >> Germán Carrillo  hat am 22.05.2024 23:30 
> >> CEST geschrieben:
> >> 
> >> 
> >> Hi All,
> >> 
> >> have a look at:
> >> 
> >> https://github.com/gacarrillor/AppendFeaturesToLayer
> >> 
> >> It has ready-to-use models to perform transform and upsert (update or
> >> insert) operations.
> >> 
> >> You can run it via standalone processing (Python) scripts or via QGIS
> >> Process.
> >> 
> >> Regards,
> >> 
> >> Germán
> >> 
> >> 
> >> El mié, 22 may 2024 a las 12:20, Etienne Trimaille via QGIS-User (<
> >> qgis-user@lists.osgeo.org>) escribió:
> >> 
> >> > Hi,
> >> >
> >> > https://docs.qgis.org/3.34/en/docs/user_manual/processing/standalone.html
> >> >
> >> > Le mer. 22 mai 2024 à 18:52, NOSPAM via QGIS-User <
> >> > qgis-user@lists.osgeo.org> a écrit :
> >> >
> >> >> Dear List,
> >> >>
> >> >> has anybody already used QGIS' processing framework for performing
> >> >> nightly ETL jobs?
> >> >>
> >> >> I need to have nightly jobs run that
> >> >> 1) download data (e.g. from a WFS server),
> >> >> 2) perform some tasks like renaming fields or the like
> >> >> 3) and finally load them into a PostGIS database.
> >> >>
> >> >> My idea would be to design the process using the modeller. How can I
> >> >> have the thus created model run non interactively?
> >> >>
> >> >> Any ideas are welcome
> >> >>
> >> >> Bernhard
> >> >> ___
> >> >> QGIS-User mailing list
> >> >> 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
> >> >
> >> 
> >> 
> >> --
> >> ---
> >>|\__
> >> (:>__)(
> >>|/
> >> Soluciones Geoinformáticas Libres
> >> http://geotux.tuxfamily.org/
> >> https://twitter.com/GeoTux2 
> > ___
> > QGIS-User mailing list
> > 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] clip raster by layer mask

2024-05-30 Thread oisin.kelly.wild--- via QGIS-User 
At step 4, Tick the box ' selected feature'

⁣Oisin

Get BlueMail for Android ​

On 30 May 2024, 20:49, at 20:49, Bernd Vogelgesang via QGIS-User 
 wrote:
>Did you e.g. try to copy the selected region to a memory layer and
>perform the clip with that? Maybe the outcome gives some clues …
>
>
>Cheers,
>
>Bernd
>Am 30.05.24 um 20:33 schrieb Sibylle Stöckli via QGIS-User:
>> Dear community
>>
>> I am using the QGIS tool "clip raster by layer mask".
>>
>> Here the process
>>
>> 1. open attribute table of layer maks
>>
>> 2. select one "region"
>>
>> 3. select the raster layer layer of that "region"
>>
>> 4. raster - extraction-clip raster layer maks
>>
>> Question: when checking the result, the assignment of the "region" is
>
>> wrong. The clipped "region" is not that one that was selected in step
>2.
>>
>> Is there anything else that may hamper the compatibility of both
>layers?
>> Both layers are EPSG:2056 (see figures). IS the Foat32 data type a
>problem?
>>
>> Raster layer:
>>
>> Layer mask “regions”
>>
>> Kind regards
>>
>> Sibylle
>>
>>
>> ___
>> QGIS-User mailing list
>> QGIS-User@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>--
>Dipl.-Geogr.
>Bernd Vogelgesang
>Kappel 17
>91355 Hiltpoltstein
>Tel: 09192-3499427
>mobil: 0163-1860160
>m...@berndvogelgesang.de
>
>
>
>___
>QGIS-User mailing list
>QGIS-User@lists.osgeo.org
>List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] clip raster by layer mask

2024-05-30 Thread Bernd Vogelgesang via QGIS-User 
Did you e.g. try to copy the selected region to a memory layer and 
perform the clip with that? Maybe the outcome gives some clues …



Cheers,

Bernd
Am 30.05.24 um 20:33 schrieb Sibylle Stöckli via QGIS-User:

Dear community

I am using the QGIS tool "clip raster by layer mask".

Here the process

1. open attribute table of layer maks

2. select one "region"

3. select the raster layer layer of that "region"

4. raster - extraction-clip raster layer maks

Question: when checking the result, the assignment of the "region" is 
wrong. The clipped "region" is not that one that was selected in step 2.


Is there anything else that may hamper the compatibility of both layers? 
Both layers are EPSG:2056 (see figures). IS the Foat32 data type a problem?


Raster layer:

Layer mask “regions”

Kind regards

Sibylle


___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


--
Dipl.-Geogr.
Bernd Vogelgesang
Kappel 17
91355 Hiltpoltstein
Tel: 09192-3499427
mobil: 0163-1860160
m...@berndvogelgesang.deBEGIN:VCARD
VERSION:4.0
N:Vogelgesang;Bernd;;;
FN:Dipl-Geogr. Bernd Vogelgesang
EMAIL;PREF=1:m...@berndvogelgesang.de
TEL;TYPE=cell;VALUE=TEXT:+491631860160
TEL;TYPE=work;VALUE=TEXT:+4991923499427
ADR:;;Kappel 17;Hiltpoltstein;;91355;
END:VCARD
___
QGIS-User mailing list
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] clip raster by layer mask

2024-05-30 Thread Sibylle Stöckli via QGIS-User 
Dear community



I am using the QGIS tool "clip raster by layer mask".

Here the process

1. open attribute table of layer maks

2. select one "region"

3. select the raster layer layer of that "region"

4. raster - extraction-clip raster layer maks



Question: when checking the result, the assignment of the "region" is wrong.
The clipped "region" is not that one that was selected in step 2.

Is there anything else that may hamper the compatibility of both layers?
Both layers are EPSG:2056 (see figures). IS the Foat32 data type a problem?



Raster layer:













Layer mask "regions"









Kind regards

Sibylle

___
QGIS-User mailing list
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 Open Day 31 May 2024

2024-05-30 Thread Jeff McKenna via QGIS-User 

Minor correction (there was a link pointing to a previous March event)  :


Where to watch

Please see the event wiki page at QOD-May-2024 Wiki for all the details 
of times and links for participation: 
https://github.com/qgis/QGIS/wiki/QOD-May-2024



-jeff






On 2024-05-30 7:30 a.m., Amy Ternent via QGIS-User wrote:

Dear QGIS Users

On Friday, 31 May 2024 we will be holding our monthly QGIS Open Day! 
What is a QGIS Open Day you may be wondering to yourself? It is an 
initiative to replace the wonderful community meetups we used to hold 
every six months when times were different. Like our in-person meetings, 
the event is organised on the principle of self-organisation and 
community participation.


*Programme*

  * Session 1: The New "Add To Felt" Plugin ,YouTube Link
, Jitsi link


*Where to watch*

Please see the event wiki page at QOD-March-2024 Wiki 
 for all the details 
of times and links for participation.



  Recordings



All the events are recorded and made available to users who couldn't 
make the live events. Youtube live streams are automatically available 
for catch-up viewing. Reviewing video links for individual events should 
work without a hitch, but you can also catch up on recordings from the 
QGIS Youtube channel:


  * https://www.youtube.com/@qgishome 


  Code of Conduct



Participants are kindly reminded to please read and observe our QGIS 
Code of Conduct and Diversity Statement to make these events a great 
experience for everyone!


  * Code of Conduct


  * Diversity Statement



Please contact the Lead QOD Event Organiser, Amy by email 
a...@kartoza.com , or via the Telegram Channel 
 username @Amz if you have 
any queries or need help setting up events.


We look forward to seeing you there! 




--

Amy Ternent
GIS Technician
Visit http://kartoza.com  to find out about open source:
* Desktop GIS programming services
* Geospatial web development
* GIS Training
* Consulting Services
Office: +27(0)71 225 0039



___
QGIS-User mailing list
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 Open Day 31 May 2024

2024-05-30 Thread Amy Ternent via QGIS-User 
Dear QGIS Users

On Friday, 31 May 2024 we will be holding our monthly QGIS Open Day! What
is a QGIS Open Day you may be wondering to yourself? It is an initiative to
replace the wonderful community meetups we used to hold every six months
when times were different. Like our in-person meetings, the event is
organised on the principle of self-organisation and community participation.

*Programme*

   - Session 1: The New "Add To Felt" Plugin ,YouTube Link
   , Jitsi link
   

*Where to watch*

Please see the event wiki page at QOD-March-2024 Wiki
 for all the details of
times and links for participation.
Recordings 

All the events are recorded and made available to users who couldn't make
the live events. Youtube live streams are automatically available for
catch-up viewing. Reviewing video links for individual events should work
without a hitch, but you can also catch up on recordings from the QGIS
Youtube channel:

   - https://www.youtube.com/@qgishome

Code of Conduct


Participants are kindly reminded to please read and observe our QGIS Code
of Conduct and Diversity Statement to make these events a great experience
for everyone!

   - Code of Conduct
   

   - Diversity Statement
   


Please contact the Lead QOD Event Organiser, Amy by email a...@kartoza.com,
or via the Telegram Channel 
 username @Amz if you have any queries or need help setting up events.

We look forward to seeing you there!


-- 

Amy Ternent
GIS Technician
Visit http://kartoza.com to find out about open source:
* Desktop GIS programming services
* Geospatial web development
* GIS Training
* Consulting Services
Office: +27(0)71 225 0039
___
QGIS-User mailing list
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] lack of conflation tools

2024-05-30 Thread PIERRE Sylvain via QGIS-User 
Hi devs and  qgis power users,

After investigating I can arg that there's a lack of conflation tools in QGIS 
like such existing for Esri  :

https://proceedings.esri.com/library/userconf/proc17/tech-workshops/tw_513-105.pdf


Is there some plan or something I miss for doing such task in QGIS ?

Thanks


[cid:image001.jpg@01DAB287.134C7D80]
Sylvain PIERRE
Chef de projet système d'information
Direction des Systèmes d'Information et du Développement Numérique
Service Projets et Ingénierie Numérique
Collectivité européenne d'Alsace
Tél : 03 88 76 68 88
sylvain.pie...@alsace.eu
www.alsace.eu
[facebook] [twitter] 
  [insta] 


___
QGIS-User mailing list
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 Processing for nightly ETL jobs

2024-05-30 Thread pathmapper via QGIS-User 

Hi Bernhard,

not sure about the native "Export to PostgreSQL" algorithm, but there's 
also a GDAL alg "Export to PostgreSQL (new connection)" which allows to 
configure the DB access. Using this one in your model should do the 
trick..


Cheers,
Björn

On 30.05.2024 08:47, Bernhard Ströbl via QGIS-User wrote:

Hello everybody,

I did some experiments in the last couple days and your help was very
valuable. I succeeded in creating two models that - when run within
QGIS or from the console - download data of different types and write
it into a PostgreSQL database. For automation purposes I want to run
my models on a Linux server. I am wondering how I would configure the
database access. The algorythm "Export to PostgreSQL" takes the
connection name as input. The connection name is the name of a
pg-connection configured using the GUI (and backed by a saved
authentication in this case). There will be no GUI (and probably no
graphic server either) on the server machine. Does anybody know if
creating a profile with the connection (without authentication) and
placing that as default profile in the home directory of the user
running the model will do the trick? Or would I need a different
approach?
I cannot try it out because currently I still have no access to the 
server.


Any help appreciated
Bernhard


Germán Carrillo  hat am 22.05.2024 23:30 
CEST geschrieben:



Hi All,

have a look at:

https://github.com/gacarrillor/AppendFeaturesToLayer

It has ready-to-use models to perform transform and upsert (update or
insert) operations.

You can run it via standalone processing (Python) scripts or via QGIS
Process.

Regards,

Germán


El mié, 22 may 2024 a las 12:20, Etienne Trimaille via QGIS-User (<
qgis-user@lists.osgeo.org>) escribió:

> Hi,
>
> https://docs.qgis.org/3.34/en/docs/user_manual/processing/standalone.html
>
> Le mer. 22 mai 2024 à 18:52, NOSPAM via QGIS-User <
> qgis-user@lists.osgeo.org> a écrit :
>
>> Dear List,
>>
>> has anybody already used QGIS' processing framework for performing
>> nightly ETL jobs?
>>
>> I need to have nightly jobs run that
>> 1) download data (e.g. from a WFS server),
>> 2) perform some tasks like renaming fields or the like
>> 3) and finally load them into a PostGIS database.
>>
>> My idea would be to design the process using the modeller. How can I
>> have the thus created model run non interactively?
>>
>> Any ideas are welcome
>>
>> Bernhard
>> ___
>> QGIS-User mailing list
>> 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
>


--
---
   |\__
(:>__)(
   |/
Soluciones Geoinformáticas Libres
http://geotux.tuxfamily.org/
https://twitter.com/GeoTux2 

___
QGIS-User mailing list
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] Felt's Flagship Membership, Add to Felt, and Open Day

2024-05-30 Thread Anita Graser via QGIS-User 
Hi,

We’re delighted to announce Felt’s [0] continued flagship-level sustaining 
membership of QGIS. 

Felt’s contributions will allow us to continuously improve QGIS’ functionality 
and documentation, as well as the QGIS project infrastructure, including our 
2024 Grant Programme.

In addition to their membership, Felt is releasing a new version of the “Add To 
Felt” QGIS plugin [1]. Developed by the talented team at North Road [2], the 
plugin makes it easy to upload your data from QGIS to the web, where you can 
share it with colleagues and clients. The newest release includes raster data 
support and more robust preservation of styles from QGIS to Felt. This enables 
seamless integration and a flexible workflow between your desktop and the web.

Don't miss your chance to meet Felt's team presenting "Add To Felt" at 
tomorrow's QGIS Open Day [3].

Felt is the first user-friendly, collaboration tool for making and sharing the 
maps that drive your business. Whether you’re working in QGIS or setting up 
your stack for the first time, Felt makes it easy to visualize your data and 
communicate across teams quickly. Learn more at felt.com.

Regards,
Anita

[0] https://felt.com/
[1] https://plugins.qgis.org/plugins/felt/
[2] https://north-road.com/
[3] https://github.com/qgis/QGIS/wiki/QOD-May-2024


-- 
Anita Graser
Home: http://anitagraser.com
Mastodon: @underdark...@fosstodon.org 
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user