Django&Geopy:每个帖子列出的所有距离:如何将一个距离关联到一个帖子

Question

Django——Geopy

我正在寻找如何定义两点之间的距离。第一个与帖子本身有关，不会因每个帖子而改变。它指示了岗位的位置。第二个将链接到用户的位置。

我想计算帖子和用户之间的距离。

问题：假设我连接了：每个帖子都列出了所有距离

我得到了一个职位：[459.414、459.414、459.4140.605、0.605、.605、0.605459.414和0.605]km

user/models.py
        class UserProfile(models.Model):
            ...
            latitude = models.DecimalField(max_digits=9, decimal_places=6, blank=True, default='0')
            longitude = models.DecimalField(max_digits=9, decimal_places=6, blank=True, default='0')
post/models.py
    class Cuisine(models.Model):
         ...
         latitude_user = models.DecimalField(max_digits=9, decimal_places=6, blank=True, default='0')
         longitude_user = models.DecimalField(max_digits=9, decimal_places=6, blank=True, default='0')

感谢@tgrandje，我解决了一些问题，从UserProfile中找到了价值：问题是我每次发帖的距离总是一样的。有什么建议吗？

def Homemainpage(request):
    
    post = Cuisine.objects.filter(status=0).order_by('-publishing_date').all() #All cuisine
    
   if request.user.is_authenticated:
    if request.user.userprofile.full_address:
        distance = []
        for p in post:
            post_lon = p.longitude_user
            post_lat = p.latitude_user
        
            post_situation = (post_lon, post_lat)
        
            user_lon = UserProfile.objects.filter(user=request.user)[0].longitude
            user_lat = UserProfile.objects.filter(user=request.user)[0].latitude
            
            user_situation = (user_lon, user_lat)
        
            distance.append(round(geodesic(post_situation, user_situation).km, 3))
    
    # Pre commande pour demain
    #post = Cuisine.objects.filter(status=0).filter(start_date=now().date() + timedelta(days=1)).order_by('-publishing_date').all()
    # En commande pour aujourd'hui
    #post = Cuisine.objects.filter(status=0).filter(start_date=now().date()).order_by('-publishing_date').all()
    
    paginator = Paginator(post, 3)
    page_number = request.GET.get('page')
    page_obj = paginator.get_page(page_number)
    
    listaliments = ListAliments.objects.filter(status=1).all()
    typerepas = Typerepas.objects.filter(status=1).all()
    sperepas = Sperepas.objects.filter(status=1).all()
    
    return render(request, 'index.html', {
        'post': post,
        'listaliments': listaliments,
        'typerepas': typerepas,
        'sperepas': sperepas,
        'page_obj': page_obj,
        'today' : now().date(),
        'tomorrow': now().date() + timedelta(days=1),
        'distance': distance,
    })

Answer 1

如果你已经准备好了所有的纬度/经度，你可以使用pyproj，这真的很有效：

from pyproj import Geod
...
user_lon = UserProfile.objects.filter(user=self.request.user).get(self.longitude)
user_lat = UserProfile.objects.filter(user=self.request.user).get(self.latitude)
post_lon = Cuisine.objects.filter(slug=slug).get(self.longitude_user)
post_lat = Cuisine.objects.filter(slug=slug).get(self.latitude_user)
wgs84_geod = Geod(ellps='WGS84')
*_args, dist_meters = wgs84_geod.inv(user_lon,user_lat,post_lon,post_lat)
print(dist_meters)

---

编辑

def Homemainpage(request):
  post = Cuisine.objects.filter(status=0).order_by('-publishing_date').all() #All cuisine
  ...
  user_lon = UserProfile.objects.filter(user=request.user)[0].longitude
  user_lat = UserProfile.objects.filter(user=request.user)[0].latitude
  wgs84_geod = Geod(ellps='WGS84')
  kitchen_distance_dict = dict()
  for kitchen in Cuisine.objects.all():
    post_lon = kitchen.longitude
    post_lat = kitchen.latitude
    *_args, dist_meters = wgs84_geod.inv(user_lon,user_lat,post_lon,post_lat)
    kitchen_distance_dict[kitchen.pk] = dist_meters / 1000
  return render(request, 'index.html', {
    'post': post,
    'listaliments': listaliments,
    'typerepas': typerepas,
    'sperepas': sperepas,
    'page_obj': page_obj,
    'distance': kitchen_distance_dict,
  })