[postgis-users] ptarray_area_spheroid: cannot handle ptarray that crosses equator

Andreas Forø Tollefsen andreasft at gmail.com
Tue Feb 19 00:32:48 PST 2013


Hi,

I have a problem with my geography type query. The query is set up to
calculate the area of every intersection between a regular grid (.5x.5
decimal degrees) and a polygon shapefile for Africa.
However, I run into problems. I have checked both the grid geometry and the
polygon geometry, and both are valid. No problems there.

My query and error:
SELECT p.gid AS pg_gid, t.gid AS tribe_gid, t.tribe_code AS tribe_code,
ST_Area(ST_Intersection(p.cell::geography,
t.geom::geography))/ST_Area(p.cell::geography)*100 AS area_perc
INTO priogrid_tribes FROM priogrid_land p, border_tribes t WHERE
ST_Intersects(p.cell::geography, t.geom::geography);

ERROR:  ptarray_area_spheroid: cannot handle ptarray that crosses equator

Any ideas why I receive this error.

My system:
"POSTGIS="2.0.2 r10789" GEOS="3.4.0dev-CAPI-1.8.0" PROJ="Rel. 4.7.1, 23
September 2009" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.7.8" (core
procs from "2.0.1 r9979" need upgrade) RASTER (raster procs from "2.0.1
r9979" need upgrade)"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130219/e50b9fb1/attachment.html>


More information about the postgis-users mailing list