[postgis-users] ERROR: AddToPROJ4SRSCache

Andreas Forø Tollefsen andreasft at gmail.com
Thu Mar 8 06:07:31 PST 2012


Hi,

I am trying to intersect two gemetries (casted to geography) and calculate
the sum of these in sq.km.
However, the query return this error:
ERROR:  AddToPROJ4SRSCache: couldn't parse proj4 string: '+proj=utm +zone=0
+south +ellps=WGS84 +datum=WGS84 +units=m +no_defs': invalid UTM zone number
********** Error **********
ERROR: AddToPROJ4SRSCache: couldn't parse proj4 string: '+proj=utm +zone=0
+south +ellps=WGS84 +datum=WGS84 +units=m +no_defs': invalid UTM zone number
SQL state: XX000

My query:
select p.gid, SUM(ST_Area(ST_Intersection(p.cell::geography,
c.geom::geography)))/1000^2 AS landarea FROM cshapeswdatevalid c,
priogrid_land p WHERE ST_Intersects(p.cell::geography, c.geom::geography)
AND c.gwsyear <= 2008 AND c.gweyear >= 2008
GROUP BY p.gid ORDER BY p.gid;

Any idea what is going on?

Best,
Andreas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120308/5063610a/attachment.html>


More information about the postgis-users mailing list