[postgis-users] ERROR: ptarray_area_spheroid: cannot handle ptarraythat crosses equator

Sarah Berke skberke at uchicago.edu
Fri Jul 22 12:39:52 PDT 2011


Hello,

I found a short thread on this subject from February 2011--I am now having
the same problem that Marcello had, and I wonder if anyone has found a fix
or workaround for this problem? Using the same example code that Marcello
provided:

SELECT 161109 polygon ,ST_AREA(ST_GEOGFROMTEXT('POLYGON((15.8327132977611
0.25,16 0.25,16 0,15.8566682147637 0,15.8566112518311
0.00356000009924173,15.8485898971558 0.124770000576973,15.8327132977611
0.25))')) gsareageo;

I get

ERROR:  ptarray_area_spheroid: cannot handle ptarray that crosses equator
CONTEXT:  SQL function "st_area" statement 1

I am using:

PostgreSQL 8.4.8 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real
(Ubuntu 4.4.3-4ubuntu5) 4.4.3, 64-bit
POSTGIS="1.5.2" GEOS="3.3.0-CAPI-1.7.0" PROJ="Rel. 4.7.1, 23 September
2009" LIBXML="2.7.6" USE_STATS

>From the earlier thread, it sounds as if this version of postgis should run
the code just fine? I saw that Marcello was able to work around the problem
by changing 0 lats to being very near-0; but this of course affected the
calculated areas. Can anyone guess why this is a problem, or has anyone
figured out a better solution?

Thanks very much!
_________________________________
Sarah K Berke
Postdoctoral Scholar
Department of the Geophysical Sciences
University of Chicago
5734 S. Ellis Ave
Chicago, IL 60637
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110722/ec2f1ed8/attachment.html>


More information about the postgis-users mailing list