StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5121396
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-02-25T18:56:02.913
FavoriteCount
0
LastActivityDate
2011-02-25T20:38:29.890
LastEditDate
2011-02-25T20:38:29.890
LastEditorUserId
607508
OwnerUserId
607508
ParentId
5121271
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
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: <pre><code>class my_points(models.Model): name = models.CharField(max_length = 100) coords = models.PointField() </code></pre> Then, in one of your views, you'll need to instantiate a my_points object: <pre><code>a = my_point(name="example", coords=x,y) </code></pre> I imagine this isn't syntactically perfect, but the GeoDjango model api: <a href="http://docs.djangoproject.com/en/dev/ref/contrib/gis/model-api/" rel="nofollow">http://docs.djangoproject.com/en/dev/ref/contrib/gis/model-api/</a> and the regular geodjango models guide: <a href="http://docs.djangoproject.com/en/dev/topics/db/models/" rel="nofollow">http://docs.djangoproject.com/en/dev/topics/db/models/</a> 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". <pre><code>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() </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POdjango - add a POINT in a PostgreSQL database using GeoDjango from decimal coordinates
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. UScanisrufus
UserOwnerUserId
1. UScanisrufus
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POdjango - add a POINT in a PostgreSQL database using GeoDjango from decimal coordinates
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COUsing GeoDjango I want to do an update query to a table that has a POINT geometry field.
 singulars
 PostPostId
 PO
 UserUserId
 USavatar
2. CODon't really know how SO works. Updated my post, though. Hope this is more useful
 singulars
 PostPostId
 PO
 UserUserId
 UScanisrufus

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.