Get all groups within coordinates : Elgg.org

Get all groups within coordinates

I'm currently creating Elgg instance which will start with around 300k groups. I'd like to view all those groups within a map (leafletjs, but that isn't relevant). Loading 300k of groups in a single AJAX request (on a mobile device) is a lot, so I'd like to only return the visible groups on the map's square.

After some searching I came across this question, which seems to be really straightforward. Except, I'm currently stuck on implementing this into Elgg. This because Elgg uses multiple tables for metadata.

Do you guys have any idea how this could be implemented and how to start? I've added a `X` and `Y` metadata to some (not all, those without doesn't need to appear on the map) ElggGroup objects.

I'm currently trying multiple ways, but none of them really seems to work with the current structure (multiple joins) of the database.

Juho Jaakkola 3204 days ago

This is just a shot in the dark, but something like this might work:

$groups = elgg_get_entities_from_metadata(array(
    'type' => 'group',
    'metadata_name_value_pairs' => array(
        array(
            'name' => 'X',
            'value' => $x_max,
            'operator' => '<',
        ),
        array(
            'name' => 'X',
            'value' => $x_min,
            'operator' => '>',
        ),
        array(
            'name' => 'Y',
            'value' => $y_max,
            'operator' => '<',
        ),
        array(
            'name' => 'Y',
            'value' => $y_min,
            'operator' => '>',
        ),
    ),
));

- Wouter van Os@Wouter0100
Wouter van Os 3204 days ago
- 0 likes
Hmm, does coordinates work like that? Thanks, let me give it a try. If that works, I was just thinking to complicated.
- nikos@nlyberakis
nikos 3204 days ago
- 0 likes
Have a look at this plugin https://github.com/hypeJunction/hypeGeo
I have used functions from it for building similar functionality which you ask.
- ihayredinov@ihayredinov
ihayredinov 3204 days ago
- 0 likes
Juho's suggestion won't work with geocoordinates. The earth is a sphere and coordinates span north and east.
I am quite sure I have written a query for getting entities within a bounding box before, but I can't find it now.
These might help, you can use a radial search from map center. Take the distance from center to any of the corners and you will get your bounding box plus some adjacent items.
https://github.com/hypeJunction/hypeGeo/blob/master/lib/functions.php
https://github.com/hypeJunction/hypeMaps/blob/master/classes/hypeJunction/Maps/ElggMapQuery.php

Get all groups within coordinates

Plugin Development

Navigation

Contact

Legal