收录日期:2021/01/23 19:06:07 时间:2010-03-31 04:32:07 标签:python,mysql,database,django,geometry
class LocationLog(models.Model):
    user = models.ForeignKey(User)
    utm = models.GeometryField(spatial_index=True)

This is my database model. I would like to insert a row.

I want to insert a circle at point -55, 333. With a radius of 10. How can I put this circle into the geometry field?

Of course, then I would want to check which circles overlap a given circle. (my select statement)

Solved. I created a square.

from django.contrib.gis.geos import Polygon
s =  Polygon(( (x-rad,y+rad)
              ,(x+rad,y+rad)
              ,(x+rad,y-rad)
              ,(x-rad,y-rad)
              ,(x-rad,y+rad) )
            )
Then you insert "s" into the database as a GeometryField.