Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am trying to transform geometry column in django, here is my model

Python
<pre lang="Python">class Network(models.Model):
    name = models.CharField(max_length=50, blank=True)
    alias = models.CharField(max_length=100, blank=True)
    geometry = models.GeometryField(srid=3857, null=True, blank=True)
    bbox = models.GeometryField(srid=3857, null=True, blank=True)
    objects = models.GeoManager()

    class Meta:
        db_table = u'tbl_network'

    def __unicode__(self):
        return '%s' % self.name

I am trying to transform bbox column but GeoQuerySet automatically tranform geometry column
Python
Network.objects.transform(srid=3857).values('geometry','bbox')

SQL query output of above django query
Python
SELECT ST_Transform("tbl_network"."geometry", 3857), "tbl_network"."bbox" FROM "tbl_network"

So i tried it different way, now i exclude geometry column
Python
Network.objects.transform(srid=3857).values('bbox')

SQL query output of above django query
Python
SELECT "tbl_network"."bbox" FROM "tbl_network"

Now GeoQuerySet totally ignore transform function.

So my questions is,

How can i transform specific column of model?
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900