[postgis-devel] [PostGIS] #1679: Intersect give ERROR: AddToPROJ4SRSCache

PostGIS trac at osgeo.org
Mon Mar 12 07:10:59 PDT 2012


#1679: Intersect give ERROR: AddToPROJ4SRSCache
-----------------------+----------------------------------------------------
 Reporter:  andreasft  |       Owner:  pramsey      
     Type:  defect     |      Status:  new          
 Priority:  medium     |   Milestone:  PostGIS 2.0.0
Component:  postgis    |     Version:  trunk        
 Keywords:             |  
-----------------------+----------------------------------------------------
 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

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1679>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list