Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ability to filter appwrite Users and custom collections based on Geo coordinates #388

Open
sateeshs opened this issue Jun 7, 2020 · 14 comments
Labels
backlog Issues waiting in the backlog enhancement New feature or request product / databases Fixes and upgrades for the Appwrite Database.

Comments

@sateeshs
Copy link

sateeshs commented Jun 7, 2020

I have list of general stores across a city wide. As a developer I need to filter stores near to login user. Similarly store also like to see nearest customers.

Users and Stores needs to be filters by geo codes.

@eldadfux eldadfux added the enhancement New feature or request label Jun 7, 2020
@eldadfux
Copy link
Member

eldadfux commented Jun 7, 2020

This can be a very useful feature in so many use cases. To implement it we will need to add a new data + rule type for geo coordinates (x,y) + add option to cast resources order-by parameter to geo proximity. A nice addition will be to add a radius-limit parameter to return only result within a given radius.

@eldadfux eldadfux added the backlog Issues waiting in the backlog label Sep 10, 2020
@eldadfux eldadfux added this to To do in Backlog Sep 10, 2020
@gewenyu99
Copy link

While we don't have exactly what you requested for geolocation, there is a way to build location-based apps in Appwrite, if you can accept using rectangular regions instead of circular regions:

https://levelup.gitconnected.com/building-a-location-based-app-with-appwrite-48a2e2b6d4c2

I'm hoping this article will at least provide a temporary solution.

@Tananga
Copy link

Tananga commented May 21, 2022

This feature is a must have. I see that AppWrite is going big with Flutter and in flutter apps based on geolocation is very common.

@stnguyen90 stnguyen90 added the product / databases Fixes and upgrades for the Appwrite Database. label Mar 16, 2023
@stnguyen90
Copy link
Contributor

stnguyen90 commented Mar 30, 2023

@malikdoksoz
Copy link

malikdoksoz commented Apr 13, 2023

You might also be able to calculate the bounds: https://gis.stackexchange.com/questions/80809/calculating-bounding-box-coordinates-based-on-center-and-radius

Here's the dart code: https://gist.github.com/stnguyen90/145bc06d4ae72c69295a46a05e2092d5

If there is too much data, it would not make sense to calculate it with darts. For this, we expect geopoint feature in appwrite. This is like showing us data between at least 2 locations, for example the nearest 20 km distance.

I've been waiting for this feature for 3 months :)

@moshOntong-IT
Copy link

update for this issue or request features for Appwrite

@gewenyu99
Copy link

update for this issue or request features for Appwrite

AFAIK, we're not actively working on this yet. There's some other things we're prioritizing, but we'll make another update here when we have something planned.

@malikdoksoz
Copy link

No focus in 3 years :)

@gewenyu99
Copy link

No focus in 3 years :)

;) We could always use more hands, we'd love an RFC or other contribution.

We have ~15 engineers, your help could bring a 6.67% increase in our productivity 😉

Sit tight, we'll try to fit this into one of our future releases.

@stnguyen90
Copy link
Contributor

You might also be able to calculate the bounds: https://gis.stackexchange.com/questions/80809/calculating-bounding-box-coordinates-based-on-center-and-radius
Here's the dart code: https://gist.github.com/stnguyen90/145bc06d4ae72c69295a46a05e2092d5

If there is too much data, it would not make sense to calculate it with darts. For this, we expect geopoint feature in appwrite. This is like showing us data between at least 2 locations, for example the nearest 20 km distance.

Sorry, what do you mean? My suggestion allows you to show the nearest 20km things.

@malikdoksoz
Copy link

You might also be able to calculate the bounds: https://gis.stackexchange.com/questions/80809/calculating-bounding-box-coordinates-based-on-center-and-radius

Here's the dart code: https://gist.github.com/stnguyen90/145bc06d4ae72c69295a46a05e2092d5

If there is too much data, it would not make sense to calculate it with darts. For this, we expect geopoint feature in appwrite. This is like showing us data between at least 2 locations, for example the nearest 20 km distance.

Sorry, what do you mean? My suggestion allows you to show the nearest 20km things.

Imagine there are 10 million vehicle listings, and a user wants to see listings near their location using a location-based filter. What if one million people want to do the same from different locations?

@stnguyen90
Copy link
Contributor

@malikdoksoz, again, that's possible with my approach. Where is your concern?

@malikdoksoz
Copy link

@malikdoksoz, again, that's possible with my approach. Where is your concern?

Does it make sense to do this on the client side? This calculation should be on the server side.

@stnguyen90
Copy link
Contributor

@malikdoksoz, it would make it a little easier if it was done automatically server-side. Being able to do this simple calculation client-side allows you to move forward and not be blocked by having dedicated geo-based queries. Just to emphasize, the calculation is only to calculate the bounds. The processing of filtering data is still done server-side.

@stnguyen90 stnguyen90 removed this from To do in Backlog Apr 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
backlog Issues waiting in the backlog enhancement New feature or request product / databases Fixes and upgrades for the Appwrite Database.
Projects
Status: Todo
Development

No branches or pull requests

7 participants