Do I need specific configuration for Spatialite with GeoDjango?

Question

According to https://docs.djangoproject.com/en/1.3/ref/contrib/gis/db-api/, Spatialite supports GeoQuerySet.distance(). However, having imported an area list (MultiPolygon as mpoly attribute), I'm trying to do the following:

Area.objects.all().distance(center)

And instead of something usable, I only get an error message: "ValueError: SQLite does not support linear distance calculations on geodetic coordinate systems."

What's wrong here, do I need some special configuration on Spatialite or is the documentation plain wrong?

score 6 · Accepted Answer · answered Aug 19 '11 at 08:20

6

You don't need to do anything regarding spatialite, but rather change the coordinate system (srid) you're using. Spatialite does distance calculations only on geographic coordinate systems, not geodetic. Check the SRID do you have in your model definition. Alternatively you can also switch to the postgis backend.

answered Aug 19 '11 at 08:20

brutasse

809
5
5

Excellent, I've set my Geometry field to 900913 and at least something worked. Have to figure out which projection I really need, but that's a great start. Thanks! – Nikolai Prokoschenko Aug 19 '11 at 11:22
How to do that in a PointField() ?? – Stéphane May 22 '14 at 12:59

Do I need specific configuration for Spatialite with GeoDjango?

1 Answers1