django - 使用 GeoDjango 从十进制坐标在 PostgreSQL 数据库中添加一个点

发布于 2024-10-19 06:30:49 字数 293 浏览 6 评论 0 原文

我正在将 PostGIS 与 django 一起使用。我知道如何从十进制坐标在 PostgreSQL 上添加“POINT”，但是如何使用 GeoDjango 添加它？

这就是我在 PostgreSQL 中的做法：

UPDATE "my_table" SET coordinates=GeometryFromText('POINT(-93.7505 31.3059)',4269) WHERE id=101;

How do I do the same thing from django?

原文

I'm using PostGIS with django. I know how to add a "POINT" on PostgreSQL from decimal coordinates but how do I add it using GeoDjango?

This is how I do it in PostgreSQL:

UPDATE "my_table" SET coordinates=GeometryFromText('POINT(-93.7505 31.3059)',4269) WHERE id=101;

How do I do the same thing from django?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

梦过后 2024-10-26 06:30:49

这就是我认为您所要求的：

GeoDjango 使用对象关系映射器。在您的 models.py 中，您必须定义一个包含点的模型，例如：

class my_points(models.Model):
  name = models.CharField(max_length = 100)
  coords = models.PointField()

然后，在您的一个视图中，您需要实例化一个 my_points 对象：

a = my_point(name="example", coords=x,y)

我想这在语法上并不完美，但是GeoDjango 模型 api: http://docs.djangoproject.com/ en/dev/ref/contrib/gis/model-api/ 和常规 geodjango 模型指南：http://docs.djangoproject.com/en/dev/topics/db/models/ 可能会带你去你需要去的地方。希望有帮助。

编辑：
好吧，我没看懂你的帖子。 “添加一点”向我表明您想添加一个。不过，您的 SQL 语句用于更新值。

要更新数据库中的值，您仍然需要一个模型。我将继续假设您设置了一个名为“my_points”的模型。

from django.contrib.gis.geos import GEOSGeometry
# queries the database for the object with an id=101
a = my_points.objects.get(id=101)
# defines your point
pnt = GEOSGeometry('POINT(5 23)')
# updates the object in memory
a.coords = pnt
# saves the changes to the database
a.save()

Here's what I think you're asking for:

GeoDjango uses an object relational mapper. In your models.py, you'll have to define a model that includes a point, e.g:

class my_points(models.Model):
  name = models.CharField(max_length = 100)
  coords = models.PointField()

Then, in one of your views, you'll need to instantiate a my_points object:

a = my_point(name="example", coords=x,y)

I imagine this isn't syntactically perfect, but the GeoDjango model api: http://docs.djangoproject.com/en/dev/ref/contrib/gis/model-api/ and the regular geodjango models guide: http://docs.djangoproject.com/en/dev/topics/db/models/ will probably get you where you need to go. Hope that helps.

Edit:
Okay, I didn't understand your post. "add a POINT" indicated to me that you wanted to add one. Your SQL statement is for updating a value, though.

To update values in a database, you'll still need a model. I'm going to proceed on the assumption that you have a model set up called "my_points".

from django.contrib.gis.geos import GEOSGeometry
# queries the database for the object with an id=101
a = my_points.objects.get(id=101)
# defines your point
pnt = GEOSGeometry('POINT(5 23)')
# updates the object in memory
a.coords = pnt
# saves the changes to the database
a.save()

回复收藏 0 原文

~没有更多了~