[Qgis-user] Hide/Show form field depending on precedent field values

2021-06-10 Thread Arnaud Vandecasteele
Hi, When creating a form by drag and drop fields, all fields are displayed unless you choose the hidden widget or you remove them from the field. But how to hide or show a form field depending on whether the user has completed a previous field? Thanks, Arnaud --

Re: [Qgis-user] Compiling messages Qgis 3.18.3

2021-06-10 Thread Saulteau Don
The patch resolved almost all of them! It's left a single CRS that couldn't be: Could not execute: INSERT INTO tbl_srs(srs_id, description,projection_acronym,ellipsoid_acronym,parameters,srid,auth_name,auth_id,is_geo,deprecated) VALUES (63 321, 'Timbalai 1948 / RSO Sarawak LSD

Re: [Qgis-user] How to filter shape or oracle layer

2021-06-10 Thread Andrea Giudiceandrea
Dario C wrote > this is the error message: The error confirms that your layer provider doesn't support the function used in your expression. Your expression works for a memory layer, instead. AFAIK you couldn't directly perform a spatial filtering for an ESRI Shapefile layer. I don't know if it

Re: [Qgis-user] SPLIT POLYGONS INTO 3 PARTS (similar size)

2021-06-10 Thread Thayer Young
Hi Azzura, You will need to run the entire process for each polygon. This is best way to handle this is by writing a python script or using the Graphical Modeler. In either case it would loop through the polygons, selecting a different polygon each time, and then applying the different tools. 

Re: [Qgis-user] How to filter shape or oracle layer

2021-06-10 Thread Dario C
Thank you. I appreciate it Il giorno gio 10 giu 2021 alle ore 21:26 Andrea Giudiceandrea < andreaer...@libero.it> ha scritto: > Dario C wrote > > this is the error message: > > The error confirms that your layer provider doesn't support the function > used in your expression. > Your expression

Re: [Qgis-user] How to filter shape or oracle layer

2021-06-10 Thread Dario C
this is the error message: [image: image.png] and here what I wrote: [image: image.png] Il giorno gio 10 giu 2021 alle ore 15:39 Andrea Giudiceandrea < andreaer...@libero.it> ha scritto: > Dario C wrote > > I'm using "Provider Specific Filter expression". > > The filter expression is specific

[Qgis-user] 3D Vertical line as invalid geometries

2021-06-10 Thread Nicolas Cadieux
Hi, I have been playing with the 3D functions in QGIS with the latest version of QGIS. Since drawing in 3D is normally something I do in a CAD, I have been asked to do this is QGIS and ArcMap for this particular project (let’s just say this reaffirmed my belief in the strength QGIS…). Anyway,

Re: [Qgis-user] How to filter shape or oracle layer

2021-06-10 Thread Andrea Giudiceandrea
Dario C wrote > I'm using "Provider Specific Filter expression". The filter expression is specific for the provider of the layer you want to filter. The filter is made at the data provider (OGR, PostgreSQL, MSSQL…) level. So the syntax depends on the data provider. Not all the data providers can

Re: [Qgis-user] How to filter shape or oracle layer

2021-06-10 Thread Andrea Giudiceandrea
Dario C wrote > The issue is that I tried to write down: > > intersects( $geometry, geometry( get_feature( layer, attributeField, value > ) )) > > But nothing happens :( Hi Dario, are you using the above expression as "Provider Feature Filter"/"Provider Specific Filter Expression"? Have you

Re: [Qgis-user] Compiling messages Qgis 3.18.3

2021-06-10 Thread Andrea Giudiceandrea
APM wrote > All blocks of the message contains > > "NOT NULL constraint failed:" Hi Piet, I've submitted a patch https://github.com/qgis/QGIS/pull/43671 which hopefully fixes the issue. If you want, you could try if it works for you. In case, let me know. Regards. Andrea -- Sent from:

Re: [Qgis-user] How to filter shape or oracle layer

2021-06-10 Thread Dario C
Thank you, based on something I have already heard (:D) what you suggested is the right way... I'll check. Thanks Il giorno gio 10 giu 2021 alle ore 15:03 Richard McDonnell < richard.mcdonn...@opw.ie> ha scritto: > I work a lot with National datasets, some with millions of geometries > > With

Re: [Qgis-user] How to filter shape or oracle layer

2021-06-10 Thread Dario C
Hi Andrea, I'm using "Provider Specific Filter expression". I don't even know how to use "Provider Feature Filter". And yes, I've replaced layer, filed and value with the real name. thanks Il giorno gio 10 giu 2021 alle ore 15:01 Andrea Giudiceandrea < andreaer...@libero.it> ha scritto: >

Re: [Qgis-user] Compiling messages Qgis 3.18.3

2021-06-10 Thread Andrea Giudiceandrea
APM wrote > After a 'make install' I received sevaral similar messages, please see a > cut below: > > > Could not execute: INSERT INTO tbl_srs(srs_id, > description,projection_acronym,ellipsoid_acronym,parameters,srid,auth_name,auth_id,is_geo,deprecated) > > VALUES (63422, 'NAD27

Re: [Qgis-user] Compiling messages Qgis 3.18.3

2021-06-10 Thread Andrea Giudiceandrea
Richard Duivenvoorde wrote > During install QGIS tries to sync your local crs db (in sqlite) with a new > list from ??? the installer, and SQlite complains about something (maybe > that a crs already excists and you cannot overwrite it or so)? Hi all, it seems to me there is a regression in

Re: [Qgis-user] How to filter shape or oracle layer

2021-06-10 Thread Richard McDonnell
I work a lot with National datasets, some with millions of geometries With these geometries we use PostgreSQL with PostGIS. Make sure the Geometries are indexed and it works very well. You mention Oracle, you should be able to index your geometries, should speed everything up on the database

Re: [Qgis-user] How to filter shape or oracle layer

2021-06-10 Thread Dario
Hi, In this casa I don’t want to use “select by location” or “extract by location”, because I’d like to use the original layer without exporting a new static shapefile. I don’t know what geometry Generator is and I’m going to check if it is suitable with my needs. My wish is to reduce

Re: [Qgis-user] How to filter shape or oracle layer

2021-06-10 Thread Richard McDonnell
Dario, To run a spatial query you need to use Select by Location or extract by location. This assumes that you have two different layers. I don’t believe it will do this for a single layer with the above. Are you trying to use the geometry Generator? Regards, Richard —— Richard McDonnell

Re: [Qgis-user] Compiling messages Qgis 3.18.3

2021-06-10 Thread APM
Dear Andrea, thank you for that! To be honest, I have no idea how to deal with a patch! Maybe you can give me a short advice? Kind regards Piet Am 10.06.21 um 13:35 schrieb Andrea Giudiceandrea: APM wrote All blocks of the message contains "NOT NULL constraint failed:" Hi Piet,

Re: [Qgis-user] How to filter shape or oracle layer

2021-06-10 Thread Dario
Hi Richard, The issue is that I tried to write down: intersects( $geometry, geometry( get_feature( layer, attributeField, value ) )) But nothing happens :( _ Il giorno 10 giu 2021, alle ore 12:21, Richard McDonnell ha scritto:  Hi Dario, If you right click on any Vector Layer and select

Re: [Qgis-user] Compiling messages Qgis 3.18.3

2021-06-10 Thread APM
Hello Andrea, yes, this is the case! All blocks of the message contains "NOT NULL constraint failed:" Kind regards Piet Am 10.06.21 um 11:11 schrieb Andrea Giudiceandrea: APM wrote After a 'make install' I received sevaral similar messages, please see a cut below: Could not execute:

Re: [Qgis-user] How to filter shape or oracle layer

2021-06-10 Thread Richard McDonnell
Hi Dario, If you right click on any Vector Layer and select Filter you can filter as you wish. Regards, Richard —— Richard McDonnell MSc GIS, FME Certified Professional FRM Data Management —— Oifig na nOibreacha Poiblí Office of Public Works Sráid Jonathan Swift, Baile Átha Troim, Co na Mí,