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
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
