tags:

views:

6

answers:

0
Q: 

How can I query for the total area for a selection of polygons in Geodjango?

I need to convert my Postgresql/Postgis query below to a query in Geodjango? I'm confused by the Geoqueryset aggregates.

Select Sum(Area(geom))/4046.856 as Acres from annualreport_landstatus where status=2;

Thanks.

related questions

Is this feasbile with GIS?
Break up a polygon into smaller ones
Clarification regarding geodjango
How hard is it to modify the Django Models?
display MultiPolygonField data on Geodjango/OpenLayers
Getting "InternalError: no such savepoint" with PostGIS in Django even when using TransactionTestCase
GeoDjango, difference between dwithin and distance_lt?
geodjango - search by city, state or zip code
django, location based searches
Using Python simplejson to return pregenerated json
GeoDjango distance search
Getting GeoDjango + Spatialite running on Windows
Problem getting started with GeoDjango
How do you know what SRID to use for a shp file?
Furthest distance between any two points with GeoDjango
Adding a polygon directly in Geodjango/PostGIS
GeoDjango Point object giving different wkt than was initialized with. What am I doing wrong?
Using UTM with geodjango
GeoDjango - How to present points on a map?
Howto merge 2 Django QuerySets in one and make a SELECT DISTINCT
Does anyone know of any good open source Geodjango apps to dig through?
retrieve bounding box of a geodjango multipolygon object
Should I use GeoDjango for mapping a floor plan?
3 dimension GiS data with django and postgis
How to display data using openlayers with OpenStreetMap in geodjango?