Intersect give ERROR: AddToPROJ4SRSCache

[andreasft]

Intersecting two gemetries (casted to geography) and calculating the sum of this intersection in sq.km 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

The 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;}

svn, rev 9240

[andreasft]

Files for testing: ​http://gisintersect.com/cshapes_pgland.sql.tar.gz

[strk]

I attached a reduction o input dataset. After restoring, you can reproduce the issue with:

SELECT ST_Intersection(c_geog, p_geog) from bug_1679;

[strk]

Fixed by r9476