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

[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 side.
Have a look here..

https://docs.oracle.com/database/121/SPATL/creating-spatial-index.htm

You may have already done this. Apologies, I can’t be of more help.
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í, C15 NX36
Jonathan Swift Street, Trim, Co Meath, C15 NX36
——
M +353 87 688 5964 T +353 46 942 2409
https://gov.ie/opw

——
To send me files larger than 30MB, please use the link below https://filetransfer.opw.ie/filedrop/richard.mcdonnell@opw.ie

Email Disclaimer: https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/
From: Dario <dario955i at gmail.com>
Sent: 10 June 2021 13:25
To: Richard McDonnell <richard.mcdonnell at opw.ie>
Cc: QGIS User List <qgis-user at lists.osgeo.org>
Subject: Re: [Qgis-user] How to filter shape or oracle layer

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 rendering time because I’m using a big data (all the city), but actually I’m working only in a district. All the time I move, reload or pan I need to wait a lot. I don’t know what is the right procedure because I’m a super beginner. Sorry :)
_

Il giorno 10 giu 2021, alle ore 13:57, Richard McDonnell <richard.mcdonnell at opw.ie<mailto:richard.mcdonnell at opw.ie>> ha scritto:

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 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í, C15 NX36
Jonathan Swift Street, Trim, Co Meath, C15 NX36
——
M +353 87 688 5964 T +353 46 942 2409
https://gov.ie/opw

——
To send me files larger than 30MB, please use the link below https://filetransfer.opw.ie/filedrop/richard.mcdonnell@opw.ie

Email Disclaimer: https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/

From: Dario <dario955i at gmail.com<mailto:dario955i at gmail.com>>
Sent: 10 June 2021 12:41
To: Richard McDonnell <richard.mcdonnell at opw.ie<mailto:richard.mcdonnell at opw.ie>>
Cc: QGIS User List <qgis-user at lists.osgeo.org<mailto:qgis-user at lists.osgeo.org>>
Subject: Re: [Qgis-user] How to filter shape or oracle layer

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 <richard.mcdonnell at opw.ie<mailto:richard.mcdonnell at opw.ie>> ha scritto:

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í, C15 NX36
Jonathan Swift Street, Trim, Co Meath, C15 NX36
——
M +353 87 688 5964 T +353 46 942 2409
https://gov.ie/opw

——
To send me files larger than 30MB, please use the link below https://filetransfer.opw.ie/filedrop/richard.mcdonnell@opw.ie

Email Disclaimer: https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/

From: Qgis-user <qgis-user-bounces at lists.osgeo.org<mailto:qgis-user-bounces at lists.osgeo.org>> On Behalf Of Dario C
Sent: 09 June 2021 12:33
To: QGIS User List <qgis-user at lists.osgeo.org<mailto:qgis-user at lists.osgeo.org>>
Subject: [Qgis-user] How to filter shape or oracle layer

Hi, is there any way to filter a layer (both shape and oracle) using a spatial query?
(I would like to load/view only what it is inside a range of value of a proper "field")

Thanks
Please note that the existing 01-6476XXX / 046-9426XXX numbering ranges will no longer be available after 30th April 2021.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210610/57def4e2/attachment.html>