On Thu, Mar 08, 2012 at 03:07:31PM +0100, Andreas Forø Tollefsen wrote: > 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?
Could you please file a ticket for this ? Sounds like a bogus UTM zone computation (zone=0) --strk; ,------o-. | __/ | Delivering high quality PostGIS 2.0 ! | / 2.0 | http://strk.keybit.net - http://vizzuality.com `-o------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
