The latitude and longitude fields in the database are counterproductive, and should be replaced with mysql point datatype. This will enable the use of geographic extension library in mysql and django. Today, seemingly simple queries like select all points within radius x, are really complex and slow. This will be elegantly resolved using point datatype.
The following tasks must be completed:
[ ] Install mysql spatial extensions
[ ] Replace latitude and longitude with position point(lat,lon)
[ ] Update data in position field
[ ] Install GEOS C-library on server
[ ] Enable GeoDjango in django settings
[ ] Update serializers and views to handle the new datatype
jonasfh
commented
5 years ago
The latitude and longitude fields in the database are counterproductive, and should be replaced with mysql point datatype. This will enable the use of geographic extension library in mysql and django. Today, seemingly simple queries like select all points within radius x, are really complex and slow. This will be elegantly resolved using point datatype.
The following tasks must be completed: