[postgis-tickets] [PostGIS] #3009: ST_Area(the_geom, false) may change column value

[PostGIS]

#3009: ST_Area(the_geom, false) may change column value
---------------------+------------------------------------------------------
 Reporter:  fursten  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.1.5
Component:  postgis  |     Version:  2.1.x        
 Keywords:           |  
---------------------+------------------------------------------------------
 Points in polygon with abs(longitude) > 90 get their longitude mirrored
 over longitude 90 east or west.


 An example:


 {{{
 select st_astext(areas)  from place where id = 362;
 "MULTIPOLYGON(((-8.62650874577284 115.346832275391,-8.58441599597068
 115.309066772461,-8.68013625652618 115.214309692383,-8.72629051135205
 115.198516845703,-8.76225972524743 115.307693481445,-8.64348030291466
 115.343399047852,-8.62650874577284 115.346832275 (...)"
 }}}


 But after executing


 {{{
 select st_area(p.areas, false) from place p where p.id=362;
 }}}


 The column value has changed.

 {{{

 select st_astext(areas)  from place where id = 362;
 "MULTIPOLYGON(((-8.62650874577284 64.6531677246094,-8.58441599597068
 64.6909332275391,-8.68013625652618 64.7856903076172,-8.72629051135205
 64.8014831542969,-8.76225972524743 64.6923065185547,-8.64348030291466
 64.6566009521484,-8.62650874577284 64.6531677246 (...)"
 }}}



 This has been observed on the two set-ups we have:

 "POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6
 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.6"
 LIBJSON="UNKNOWN" RASTER"

 "PostgreSQL 9.3.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
 20120313 (Red Hat 4.4.7-4), 64-bit"

 and


 "POSTGIS="2.1.2 r12389" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6
 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.6"
 LIBJSON="UNKNOWN" RASTER"

 "PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
 20120313 (Red Hat 4.4.7-4), 64-bit"

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3009>
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.