Filter point layer based on filtered polygon layer

Question

I have a polygon layer (electoral areas) and a point layer (sports clubs) in an Experience. I want to filter the electoral areas by, say, all that have more than 100 people over 55 years old (can even be pre-filtered). Then I want to output a list of all sports clubs in those electoral areas, or ideally choose the type of club, e.g. all basketball clubs. What is the best way to do this in ExB? I've been trying with the Query widget but not getting anywhere...

DarraghOSullivan · Answer

Hi again @IssyAmis ,

I'm definitely finding that the Dashboard has a better workflow but the main limitation is buffers around the points, which I can do in ExB. So you know of any way to work with buffers in a Dashboard?

DarraghOSullivan · Answer

Hi @IssyAmis,

Thank you for your reply, much appreciated. I've tried this and it works ok but still a little 'messy' for my users! Of course I could easily be missing something and making it more complicated than it needs to be, so I would appreciate a bit more detail on the workflow ...

I also tried this in a Dashboard and so far it seems a little more intuitive and elegant for the users. The main issue there is that there are almost 20,000 features in the polygon layer so things get super slow or even unresponsive!

Any insights or suggestions are welcome, thanks again.

IssyAmis · Answer

Hi @DarraghOSullivan

I've taken a look into this and a workflow that may work for you is using the "Select" widget to do an attribute selection with your polygon layer. This will select the polygons that match up with the filter you set. You can also add an action to the Select widget so that the data filters down when it is selected.

Once you have selected your data, you can use the "Query" widget and add both an attribute and spatial filter for your sports clubs layer - this way your users can choose the type of club and see which clubs are contained within the selected polygons.

I'm happy to provide some more details about this workflow if needed! I will keep looking to see whether there is a shorter way to achieve this - also happy for anyone else to jump in if they have one!

Thanks!

Issy