Hi. I am on Django 3.2 using Python 3.8 and Postgres. I’m trying to annotate the distance between a user and facility. My minimal code is as follows: User.objects.all().annotate( test=Subquery( Facility.objects.annotate( distance=Distance("facility_address__pnt", OuterRef("…

I think you might have to wrap the OuterRef in ExpressionWrapper here to tell Distance that it will eventually resolve to a PointField User.objects.annotate( test=Facility.objects.annotate( distance=Distance( "facility_address__pnt", ExpressionWrapper( …

Error when annotating distance between 2 points inside a Subquery - GeoDjango

Using Django Using the ORM

j-krl May 6, 2024, 2:09pm 4

Wow, thanks a million! Not sure I would have thought of that!

Topic		Replies	Views
TypeError: float() argument must be a string or a real number, not 'F' Using the ORM	7	2264	November 22, 2023
Join two models on geometry predicate Using the ORM	6	666	November 15, 2023
Simple annotation of related count using OuterRef ORM	4	182	July 11, 2025
Postgis Point Creation Using the ORM	13	1125	October 19, 2023
Is there a way to slice a subquery with an OuterRef(field) ? Using the ORM	3	789	May 3, 2024

Error when annotating distance between 2 points inside a Subquery - GeoDjango

Related topics