Opened 13 years ago
Closed 13 years ago
#1679 closed defect (fixed)
Intersect give ERROR: AddToPROJ4SRSCache
Reported by: | andreasft | Owned by: | pramsey |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS 2.0.0 |
Component: | postgis | Version: | master |
Keywords: | Cc: |
Description
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)))/10002 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
Attachments (1)
Change History (4)
comment:1 by , 13 years ago
by , 13 years ago
Attachment: | bug_1679.dump added |
---|
comment:2 by , 13 years ago
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;
Files for testing: http://gisintersect.com/cshapes_pgland.sql.tar.gz