Django sort by distance

by

the .distance(ref_location) is removed in django >=1.9 you should use an annotation instead.

from django.contrib.gis.db.models.functions import Distance
from django.contrib.gis.measure import D
from django.contrib.gis.geos import Point

ref_location = Point(1.232433, 1.2323232, srid=4326)
yourmodel.objects.filter(location__distance_lte=(ref_location, D(m=2000)))                                                     
    .annotate(distance=Distance("location", ref_location))                                                                
    .order_by("distance")

also you should narrow down your search with the dwithin operator which uses the spatial index, distance does not use the index which slows your query down:

yourmodel.objects.filter(location__dwithin=(ref_location, 0.02))
    .filter(location__distance_lte=(ref_location, D(m=2000)))
    .annotate(distance=Distance('location', ref_location))
    .order_by('distance')

see this post for an explanation of location__dwithin=(ref_location, 0.02)

More Related Contents:

  1. GeoDjango on Windows: “Could not find the GDAL library” / “OSError: [WinError 126] The specified module could not be found”
  2. How to make/use a custom database function in Django
  3. How do I convert kilometres to degrees in Geodjango/GEOS?
  4. Type error on Login using the ‘login()’ function
  5. Django URLs TypeError: view must be a callable or a list/tuple in the case of include()
  6. Render HTML to PDF in Django site
  7. Error on “pip install -U channels” command using for otree (Running setup.py bdist_wheel for twisted … error)
  8. Django Rest Framework File Upload
  9. How can I filter a Django query with a list of values?
  10. Django: add image in an ImageField from image url
  11. how to iterate through dictionary in a dictionary in django template?
  12. Django self-referential foreign key
  13. Implementing Single Sign On (SSO) using Django [closed]
  14. Django values_list vs values
  15. What is the path that Django uses for locating and loading templates?
  16. ValueError: Missing staticfiles manifest entry for ‘favicon.ico’
  17. Django: python manage.py runserver gives RuntimeError: maximum recursion depth exceeded in cmp
  18. Determine complete Django url configuration
  19. Do properties work on Django model fields?
  20. Django Passing data between views
  21. Serving large files ( with high loads ) in Django
  22. Django custom annotation function
  23. can’t pip install mysql-python
  24. What is the difference between static files and media files in Django?
  25. How can I set two primary key fields for my models in Django?
  26. Can I make STATICFILES_DIR same as STATIC_ROOT in Django 1.3?
  27. PyCharm hangs on ‘scanning files to index’ background task
  28. How to redirect from a view to another view In Django
  29. How to delete a record in Django models?
  30. Collectstatic error while deploying Django app to Heroku

Leave a Comment