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

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

> 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> 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>
> *Sent:* 10 June 2021 12:41
> *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 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> 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> *On Behalf Of *Dario
> C
> *Sent:* 09 June 2021 12:33
> *To:* QGIS User List <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/f863d95d/attachment.html>